From 83835ea22d7e169f80d8740ce8a542103257d173 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Thu, 24 Nov 2022 21:23:56 +0100
Subject: Remove obsolete tools and update other tools.

---
 tools/packreplay.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 tools/packreplay.sql

(limited to 'tools/packreplay.sql')

diff --git a/tools/packreplay.sql b/tools/packreplay.sql
new file mode 100644
index 0000000..28cd11f
--- /dev/null
+++ b/tools/packreplay.sql
@@ -0,0 +1,8 @@
+begin transaction;
+create temporary table replay_repack as
+	select game_id,role,action,arguments
+	from game_replay
+	order by game_id,replay_id;
+delete from game_replay;
+insert into game_replay (game_id,role,action,arguments) select * from replay_repack;
+commit;
-- 
cgit v1.2.3

