diff options
| author | Tor Andersson <tor@ccxvii.net> | 2022-11-24 21:23:56 +0100 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2022-11-25 17:37:12 +0100 |
| commit | 83835ea22d7e169f80d8740ce8a542103257d173 (patch) | |
| tree | 24744e958aca45e583563ed6db9c58194dcd0b5c /tools/packreplay.sql | |
| parent | 1fd20db73895cf1ca8fab9cf2c7d288d3bcc1c92 (diff) | |
| download | server-83835ea22d7e169f80d8740ce8a542103257d173.tar.gz | |
Remove obsolete tools and update other tools.
Diffstat (limited to 'tools/packreplay.sql')
| -rw-r--r-- | tools/packreplay.sql | 8 |
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; |