Zmiany pomiędzy wersją 9 and wersją 10 dla DeployerGuide/Others/DatabaseCleanup

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

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione

  • DeployerGuide/Others/DatabaseCleanup

    v9 v10  
    7171{{{ 
    7272#!sql 
    73 DELETE FROM procedures WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
     73DELETE FROM procedures p WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
    7474NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND 
    7575NOT EXISTS (SELECT d.procid FROM rcp_cards d WHERE p.procid = d.procid AND d.procid IS NOT NULL)