Zmiany pomiędzy wersją 7 and wersją 8 dla DeployerGuide/Others/DatabaseCleanup

Pokaż
Ignoruj:
Data i czas:
11/18/15 11:58:17 (9 years temu)
Autor:
jachtelik (IP: 79.188.124.105)
Komentarz:

--

Legend:

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

    v7 v8  
    7373 
    7474{{{ 
     75#!sql 
    7576DELETE FROM procedures WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
    7677NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
     
    8081Policzyć można je za pomocą: 
    8182{{{ 
     83#!sql 
    8284SELECT count(procid) FROM procedures p WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
    8385NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND