Add script to purge anticheat logs.
authorAnt Zucaro <azucaro@gmail.com>
Wed, 28 May 2014 00:36:27 +0000 (20:36 -0400)
committerAnt Zucaro <azucaro@gmail.com>
Wed, 28 May 2014 00:36:27 +0000 (20:36 -0400)
scripts/purge_anticheat_log.sql [new file with mode: 0644]

diff --git a/scripts/purge_anticheat_log.sql b/scripts/purge_anticheat_log.sql
new file mode 100644 (file)
index 0000000..783a58a
--- /dev/null
@@ -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;