From 28dbcd115dc23d920bf30de512a63efed8eeb58f Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Wed, 15 Jun 2022 17:17:54 +0200
Subject: Drop time column from game replay table.

---
 schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index a5ec561..4527b9b 100644
--- a/schema.sql
+++ b/schema.sql
@@ -274,11 +274,11 @@ create view game_chat_view as
 create index if not exists game_chat_idx on game_chat(game_id);
 
 create table if not exists game_replay (
+	replay_id integer
+		primary key,
 	game_id integer
 		references games
 			on delete cascade,
-	time timestamp
-		default current_timestamp,
 	role text,
 	action text,
 	arguments json
-- 
cgit v1.2.3