From d4eaac958d3c5c68a6e4bfd47ababb61bd9fd524 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 10 Jul 2023 15:40:45 +0200 Subject: Use sequential per-game chat ids. --- schema.sql | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index f959720..144ba7d 100644 --- a/schema.sql +++ b/schema.sql @@ -293,12 +293,13 @@ create table if not exists game_state ( ); create table if not exists game_chat ( - chat_id integer primary key, game_id integer, - time datetime default current_timestamp, + chat_id integer, user_id integer, - message text -); + time datetime default current_timestamp, + message text, + primary key (game_id, chat_id) +) without rowid; create table if not exists unread_chats ( user_id integer, @@ -309,14 +310,12 @@ create table if not exists unread_chats ( drop view if exists game_chat_view; create view game_chat_view as select - chat_id, game_id, time, name, message + game_id, chat_id, time, name, message from game_chat natural join users ; -create index if not exists game_chat_idx on game_chat(game_id); - create table if not exists game_replay ( game_id integer, replay_id integer, -- cgit v1.2.3