Zmiany pomiędzy wersją 3 and wersją 4 dla DeployerGuide/Others/DatabaseCleanup
- Data i czas:
- 09/10/13 17:49:40 (11 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
DeployerGuide/Others/DatabaseCleanup
v3 v4 79 79 NOT EXISTS (SELECT d.procid FROM rcp_cards d WHERE p.procid = d.procid AND d.procid IS NOT NULL) 80 80 }}} 81 82 Policzyć można je za pomocą: 83 {{{ 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 85 NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 86 NOT EXISTS (SELECT d.procid FROM rcp_cards d WHERE p.procid = d.procid AND d.procid IS NOT NULL) 87 }}}
