| | 2 | |
| | 3 | |
| | 4 | |
| | 5 | Dedykowane czyszczenie bazy po okresie testowym związanym z pobieraniem danych z systemu zew. |
| | 6 | |
| | 7 | '''UWAGA''' |
| | 8 | Czyści wszystkie dane dokumentów, klientów i spraw ustawiając sekwencje dla tych obiektów na 1. |
| | 9 | |
| | 10 | {{{ |
| | 11 | DELETE FROM documents CASCADE; |
| | 12 | DELETE FROM documents_log; |
| | 13 | DELETE FROM documents_history; |
| | 14 | DELETE FROM files; |
| | 15 | DELETE FROM attachments; |
| | 16 | DELETE FROM procedures; |
| | 17 | |
| | 18 | SELECT setval('documents_doc_id_seq', 1); |
| | 19 | |
| | 20 | DELETE FROM process_participants; |
| | 21 | DELETE FROM processes CASCADE; |
| | 22 | DELETE FROM processes_log; |
| | 23 | |
| | 24 | SELECT setval('processes_prc_id_seq', 1); |
| | 25 | |
| | 26 | DELETE FROM bank_accounts; |
| | 27 | DELETE FROM contacts CASCADE; |
| | 28 | DELETE FROM addresses CASCADE; |
| | 29 | DELETE FROM contacts_log; |
| | 30 | DELETE FROM addresses_log; |
| | 31 | |
| | 32 | |
| | 33 | DELETE FROM bs_connect_sync_log; |
| | 34 | DELETE FROM bs_connect_export_queue; |
| | 35 | |
| | 36 | SELECT setval('contacts_contid_seq', 1); |
| | 37 | SELECT setval('addresses_addrid_seq', 1); |
| | 38 | |
| | 39 | }}} |
