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