summaryrefslogtreecommitdiff
path: root/tools/packreplay.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tools/packreplay.sql')
-rw-r--r--tools/packreplay.sql8
1 files changed, 8 insertions, 0 deletions
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;