From 845cb682fa01c9d0ac86b51d15e5e50e69ba7b1c Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Tue, 4 Mar 2025 13:16:38 +0100
Subject: Script to lift tournament bans after time and games finished.

---
 tools/purge.sql | 4 ----
 1 file changed, 4 deletions(-)

(limited to 'tools/purge.sql')

diff --git a/tools/purge.sql b/tools/purge.sql
index 3e3bfc6..2a95f01 100644
--- a/tools/purge.sql
+++ b/tools/purge.sql
@@ -28,12 +28,8 @@ create temporary view prune_all_list as
 		)
 	;
 
-begin immediate;
-
 select 'PURGE SNAPS FROM ' || count(1) from prune_snap_list;
 delete from live.game_snap where game_id in (select game_id from prune_snap_list);
 
 select 'PURGE ALL FROM ' || count(1) from prune_all_list;
 update live.games set status = 3 where game_id in (select game_id from prune_all_list);
-
-commit;
-- 
cgit v1.2.3

