summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2022-06-15 17:17:54 +0200
committerTor Andersson <tor@ccxvii.net>2022-06-16 18:37:57 +0200
commit28dbcd115dc23d920bf30de512a63efed8eeb58f (patch)
tree1c6f4df4483d7cde0ccdec8dc78098946bdd41a3
parentc0fedc808fa61551f926a57bfdafc996e90f6658 (diff)
downloadserver-28dbcd115dc23d920bf30de512a63efed8eeb58f.tar.gz
Drop time column from game replay table.
-rw-r--r--schema.sql4
1 files changed, 2 insertions, 2 deletions
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