aboutsummaryrefslogtreecommitdiff
path: root/backend/database/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/database/init.sql')
-rw-r--r--backend/database/init.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 17a0ce5..9851ad7 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -23,6 +23,7 @@ CREATE TABLE chapters (
23 id SERIAL, 23 id SERIAL,
24 game_id SMALLINT NOT NULL, 24 game_id SMALLINT NOT NULL,
25 name TEXT NOT NULL, 25 name TEXT NOT NULL,
26 is_disabled BOOLEAN NOT NULL DEFAULT false,
26 PRIMARY KEY (id), 27 PRIMARY KEY (id),
27 FOREIGN KEY (game_id) REFERENCES games(id) 28 FOREIGN KEY (game_id) REFERENCES games(id)
28); 29);