Zmiany pomiędzy wersją 7 and wersją 8 dla DeployerGuide/Others/DatabaseCleanup
- Data i czas:
- 11/18/15 11:58:17 (8 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
DeployerGuide/Others/DatabaseCleanup
v7 v8 73 73 74 74 {{{ 75 #!sql 75 76 DELETE FROM procedures WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 76 77 NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND … … 80 81 Policzyć można je za pomocą: 81 82 {{{ 83 #!sql 82 84 SELECT 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 83 85 NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND
