Add script to purge anticheat logs.

[xonotic/xonstatdb.git] / scripts / purge_anticheat_log.sql

diff --git a/scripts/purge_anticheat_log.sql b/scripts/purge_anticheat_log.sql
new file mode 100644 (file)
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;