From 2a29b33b595f34e463b46388018e456500519404 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Sun, 5 Mar 2023 17:55:48 +0100 Subject: Update schema. --- schema.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/schema.sql b/schema.sql index 07c51bb..c8ea5a9 100644 --- a/schema.sql +++ b/schema.sql @@ -433,6 +433,7 @@ begin delete from game_state where game_id = old.game_id; delete from game_chat where game_id = old.game_id; delete from game_replay where game_id = old.game_id; + delete from game_notes where game_id = old.game_id; delete from last_notified where game_id = old.game_id; delete from unread_chats where game_id = old.game_id; delete from players where game_id = old.game_id; @@ -477,7 +478,7 @@ begin end; create table if not exists deleted_users ( - user_id integer primary key, + user_id integer, name text collate nocase, mail text collate nocase, time real default (julianday()) -- cgit v1.2.3