From 2a29b33b595f34e463b46388018e456500519404 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sun, 5 Mar 2023 17:55:48 +0100
Subject: Update schema.

---
 schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'schema.sql')

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

