diff options
Diffstat (limited to 'backend/database')
| -rw-r--r-- | backend/database/init.sql | 3 |
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) |