diff options
| author | Tor Andersson <tor@ccxvii.net> | 2025-03-04 13:16:38 +0100 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2025-03-04 13:17:31 +0100 |
| commit | 845cb682fa01c9d0ac86b51d15e5e50e69ba7b1c (patch) | |
| tree | 060b93f0429b8cf44022f77b3428c9786e4ba0ee /tools/purge.sql | |
| parent | 69cda7a3a3ed4ccc111f6716dc8f87d051cc24ce (diff) | |
| download | server-845cb682fa01c9d0ac86b51d15e5e50e69ba7b1c.tar.gz | |
Script to lift tournament bans after time and games finished.
Diffstat (limited to 'tools/purge.sql')
| -rw-r--r-- | tools/purge.sql | 4 |
1 files changed, 0 insertions, 4 deletions
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; |