Czyszczenie bazy danych przed uruchomieniem

Po okresie testowania klient życzy sobie aby wyczyścić bazę. Można to zrobić poprzez wywołanie odpowiednich komend w bazie danych.

-- wyczyszczenie tabel z rekordami dziennikow
delete from regofpapers ;
delete from regofvatnotes;
delete from regofmagazins;
delete from regofresolutions;
delete from regofnotes;

-- wyczyszczenie tabel dokumentow
delete from documents;
delete from documents_history;
delete from attachments;

-- wyczyszczenie tabel plikow
delete from versions ;
delete from files;

-- wyzerowanie liczników
update counters set cntval = 0;
update briefcases set countr = 0;
update doss_extract_list set countr = 0;

-- wyczyszczenie zdarzen
delete from rcp_cards;
delete from events;
delete from process_comments;
delete from process_participants;
delete from processes;
delete from proc_link_users;

-- czyczczenie etapów, procedur
delete from stages;
delete from procedures;