Version 2 (modified by TS, 11 years ago) |
---|
Przewodnik użytkownika > Czyszczenie dokumentów, klientów i spraw po okresie testowym
Dedykowane czyszczenie bazy po okresie testowym związanym z pobieraniem danych z systemu zew.
UWAGA Czyści wszystkie dane dokumentów, klientów i spraw ustawiając sekwencje dla tych obiektów na 1.
DELETE FROM documents CASCADE; DELETE FROM documents_log; DELETE FROM documents_history; DELETE FROM files; DELETE FROM attachments; DELETE FROM procedures; SELECT setval('documents_doc_id_seq', 1); DELETE FROM process_participants; DELETE FROM processes CASCADE; DELETE FROM processes_log; SELECT setval('processes_prc_id_seq', 1); DELETE FROM bank_accounts; DELETE FROM contacts CASCADE; DELETE FROM addresses CASCADE; DELETE FROM contacts_log; DELETE FROM addresses_log; DELETE FROM bs_connect_sync_log; DELETE FROM bs_connect_export_queue; SELECT setval('contacts_contid_seq', 1); SELECT setval('addresses_addrid_seq', 1);