Zmiany pomiędzy wersją 17 and wersją 18 dla AdminGuide/LogShrinking

Data i czas:

10/10/18 16:06:25 (6 years temu)

Autor:

JP (IP: 83.144.106.170)

Komentarz:

--

AdminGuide/LogShrinking

@@ -16 +16 @@
 DELETE FROM depository_log WHERE chacat = 'BS_SYNC_SUCCESS';
 
--- procedury z odpiętych dokumentów, spraw
-DELETE FROM procedures p WHERE NOT EXISTS (SELECT d.procid FROM documents d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND
-NOT EXISTS (SELECT d.procid FROM processes d WHERE p.procid = d.procid AND d.procid IS NOT NULL) AND
-NOT EXISTS (SELECT d.procid FROM rcp_cards d WHERE p.procid = d.procid AND d.procid IS NOT NULL) 
-AND p.procid = p.rootpr
+
 }}}