Zmiany pomiędzy wersją 13 and wersją 14 dla DeployerGuide/Others/DatabaseCleanup

Pokaż
Ignoruj:
Data i czas:
10/08/16 10:32:18 (8 years temu)
Autor:
mkrolikowski (IP: 82.145.221.127)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione
  • DeployerGuide/Others/DatabaseCleanup

    v13 v14  
    3939 
    4040delete from readed_comments where usr_id IN (SELECT usr_id FROM users where is_del is true); 
     41-- lub wszystkich komentarzy 
     42delete from readed_comments; 
     43delete from comments; 
     44--------- 
    4145 
    4246delete from contacts_caretakers where usr_id IN (SELECT usr_id FROM users where is_del is true);