From f968d091d6c3f313054b88a048c63280dd73fd31 Mon Sep 17 00:00:00 2001 From: Tor Andersson 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