Add PRNG seed to game state.

Log all game actions to a table so they can be replayed.

1 files changed, 9 insertions, 0 deletions

diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt
index e731c8c..1623ec3 100644
--- a/tools/sql/schema.txt
+++ b/tools/sql/schema.txt
@@ -55,6 +55,14 @@ CREATE TABLE IF NOT EXISTS games (
 	state TEXT
 );
 
+CREATE TABLE IF NOT EXISTS replay (
+	game_id INTEGER,
+	time TIMESTAMP,
+	role TEXT,
+	action TEXT,
+	arguments TEXT
+);
+
 CREATE TABLE IF NOT EXISTS chats (
 	game_id INTEGER PRIMARY KEY,
 	time TIMESTAMP,
@@ -110,6 +118,7 @@ BEGIN
 	DELETE FROM players WHERE game_id = old.game_id;
 	DELETE FROM notifications WHERE game_id = old.game_id;
 	DELETE FROM chats WHERE game_id = old.game_id;
+	DELETE FROM replay WHERE game_id = old.game_id;
 END;
 
 DROP VIEW IF EXISTS player_view;