| | 1 | = Czyszczenie bazy danych przed uruchomieniem = |
| | 2 | |
| | 3 | Po okresie testowania klient życzy sobie aby wyczyścić bazę. Można to zrobić poprzez wywołanie odpowiednich komend w bazie danych. |
| | 4 | |
| | 5 | {{{ |
| | 6 | -- wyczyszczenie tabel z rekordami dziennikow |
| | 7 | delete from regofpapers ; |
| | 8 | delete from regofvatnotes; |
| | 9 | delete from regofmagazins; |
| | 10 | delete from regofresolutions; |
| | 11 | delete from regofnotes; |
| | 12 | |
| | 13 | -- wyczyszczenie tabel dokumentow |
| | 14 | delete from documents; |
| | 15 | delete from documents_history; |
| | 16 | delete from attachments; |
| | 17 | |
| | 18 | -- wyczyszczenie tabel plikow |
| | 19 | delete from versions ; |
| | 20 | delete from files; |
| | 21 | |
| | 22 | -- wyzerowanie liczników |
| | 23 | update counters set cntval = 0; |
| | 24 | update briefcases set countr = 0; |
| | 25 | update doss_extract_list set countr = 0; |
| | 26 | |
| | 27 | -- wyczyszczenie zdarzen |
| | 28 | delete from rcp_cards; |
| | 29 | delete from events; |
| | 30 | delete from process_comments; |
| | 31 | delete from process_participants; |
| | 32 | delete from processes; |
| | 33 | delete from proc_link_users; |
| | 34 | |
| | 35 | -- czyczczenie etapów, procedur |
| | 36 | delete from stages; |
| | 37 | delete from procedures; |
| | 38 | |
| | 39 | }}} |
| | 40 | |
