From e8f7a370387628225f8322f1bb187a2f4a42436f Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Tue, 27 May 2014 20:36:27 -0400
Subject: [PATCH] Add script to purge anticheat logs.

---
 scripts/purge_anticheat_log.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 scripts/purge_anticheat_log.sql

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;
-- 
2.39.2