From f968d091d6c3f313054b88a048c63280dd73fd31 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Wed, 28 Sep 2022 18:00:03 +0200
Subject: Add notepad.

---
 schema.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 39c0f35..28f32e3 100644
--- a/schema.sql
+++ b/schema.sql
@@ -286,6 +286,15 @@ create table if not exists game_replay (
 
 create index if not exists game_replay_idx on game_replay(game_id);
 
+create table if not exists game_notes (
+	game_id integer
+		references games
+			on delete cascade,
+	role text,
+	note text,
+	primary key (game_id, role)
+) without rowid;
+
 create table if not exists players (
 	game_id integer
 		references games
-- 
cgit v1.2.3

