Version 5 (modified by jpo, 7 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 events;
DELETE FROM regofpapers;
DELETE FROM regofvatnotes;


DELETE FROM bank_accounts;
DELETE FROM contacts CASCADE;
DELETE FROM contacts_caretakers 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;
DELETE FROM bs_connect_contact_addresses_coherences;

SELECT setval('contacts_contid_seq', 1); 
SELECT setval('addresses_addrid_seq', 1); 

Schemat wyszukiwarki
DELETE FROM jet_search.indexer_workers_log CASCADE
DELETE FROM jet_search.indexer_workers_queue CASCADE
DELETE FROM jet_search.search_area CASCADE 
DELETE FROM jet_search.search_words