Zmiany pomiędzy wersją 14 and wersją 15 dla DeployerGuide/Others/DatabaseCleanup
- Data i czas:
- 10/08/16 10:33:05 (8 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
DeployerGuide/Others/DatabaseCleanup
v14 v15 31 31 delete from procedures; 32 32 33 -- Czyszczenie logów 34 delete from log; 35 delete from log_trace; 36 delete from login_history; 37 38 -- Czyszczenie wszystkich Komentarzy 39 delete from readed_comments; 40 delete from comments; 41 33 42 -- czyszczenie usuniętych wpisów 34 43 DELETE from fk_elements WHERE doc_id IN (SELECT doc_id FROM documents where adduid IN (SELECT usr_id FROM users where is_del is true)); … … 39 48 40 49 delete from readed_comments where usr_id IN (SELECT usr_id FROM users where is_del is true); 41 -- lub wszystkich komentarzy42 delete from readed_comments;43 delete from comments;44 ---------45 50 46 51 delete from contacts_caretakers where usr_id IN (SELECT usr_id FROM users where is_del is true); … … 66 71 delete from documents where is_del is true; 67 72 68 -- Czyszczenie logów 69 delete from log; 70 delete from log_trace; 71 delete from login_history; 73 72 74 73 75
