From: Ant Zucaro <azucaro@gmail.com>
Date: Wed, 28 May 2014 00:36:27 +0000 (-0400)
Subject: Add script to purge anticheat logs.
X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=e8f7a370387628225f8322f1bb187a2f4a42436f

Add script to purge anticheat logs.
---

diff --git a/scripts/purge_anticheat_log.sql b/scripts/purge_anticheat_log.sql
new file mode 100644
index 0000000..783a58a
--- /dev/null
+++ b/scripts/purge_anticheat_log.sql
@@ -0,0 +1,5 @@
+begin;
+    -- get rid of stuff that is older than 30 days old
+    delete from player_game_anticheats
+    where create_dt < now() at time zone 'utc' - interval '30 days';
+end;