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);