From 845cb682fa01c9d0ac86b51d15e5e50e69ba7b1c Mon Sep 17 00:00:00 2001 From: Tor Andersson 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