Zmiany pomiędzy wersją 12 and wersją 13 dla AdminGuide/LogShrinking

Data i czas:

10/04/18 14:33:26 (6 years temu)

Autor:

JP (IP: 188.137.112.78)

Komentarz:

--

AdminGuide/LogShrinking

@@ -15 +15 @@
 
 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) 
 }}}