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

Data i czas:

10/04/18 14:31:06 (6 years temu)

Autor:

JP (IP: 188.137.112.78)

Komentarz:

--

AdminGuide/LogShrinking

@@ -19 +19 @@
 2. Administracyjne - mogą być czyszczone ze wszystkich wpisów ale w oparciu o filtr DATY.
 {{{
+DELETE FROM contacts_log WHERE adddat < CURRENT_DATE - interval '2 years' AND chacat != 'ADDED';
 
+DELETE FROM addresses_log WHERE adddat < CURRENT_DATE - interval '2 years' AND chacat != 'ADDED';
+
+DELETE FROM email_accounts_log WHERE adddat < CURRENT_DATE - interval '2 years' AND chacat != 'ADDED';
+
+DELETE FROM depository_log WHERE adddat < CURRENT_DATE - interval '2 years' AND chacat != 'ADDED';
 
 }}}