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.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 54867ca..1fda15d 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -16,6 +16,7 @@ CREATE TABLE games (
16 id SERIAL, 16 id SERIAL,
17 name TEXT NOT NULL, 17 name TEXT NOT NULL,
18 is_coop BOOLEAN NOT NULL, 18 is_coop BOOLEAN NOT NULL,
19 image TEXT NOT NULL,
19 PRIMARY KEY (id) 20 PRIMARY KEY (id)
20); 21);
21 22
@@ -24,6 +25,7 @@ CREATE TABLE chapters (
24 game_id SMALLINT NOT NULL, 25 game_id SMALLINT NOT NULL,
25 name TEXT NOT NULL, 26 name TEXT NOT NULL,
26 is_disabled BOOLEAN NOT NULL DEFAULT false, 27 is_disabled BOOLEAN NOT NULL DEFAULT false,
28 image TEXT NOT NULL,
27 PRIMARY KEY (id), 29 PRIMARY KEY (id),
28 FOREIGN KEY (game_id) REFERENCES games(id) 30 FOREIGN KEY (game_id) REFERENCES games(id)
29); 31);
@@ -40,6 +42,7 @@ CREATE TABLE maps (
40 chapter_id SMALLINT NOT NULL, 42 chapter_id SMALLINT NOT NULL,
41 name TEXT NOT NULL, 43 name TEXT NOT NULL,
42 is_disabled BOOLEAN NOT NULL DEFAULT false, 44 is_disabled BOOLEAN NOT NULL DEFAULT false,
45 image TEXT NOT NULL,
43 PRIMARY KEY (id), 46 PRIMARY KEY (id),
44 FOREIGN KEY (game_id) REFERENCES games(id), 47 FOREIGN KEY (game_id) REFERENCES games(id),
45 FOREIGN KEY (chapter_id) REFERENCES chapters(id) 48 FOREIGN KEY (chapter_id) REFERENCES chapters(id)