diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-10-10 19:16:06 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-10-10 19:16:06 +0300 |
| commit | 83963bd8a7ee906b93e24afea53516bc7f19afd1 (patch) | |
| tree | 88aa6332228043d52ce76fa414edd01f11462220 /backend/database/init.sql | |
| parent | feat: new endpoint for getting every map for a game (#114) (diff) | |
| download | lphub-83963bd8a7ee906b93e24afea53516bc7f19afd1.tar.gz lphub-83963bd8a7ee906b93e24afea53516bc7f19afd1.tar.bz2 lphub-83963bd8a7ee906b93e24afea53516bc7f19afd1.zip | |
feat: add is_disabled to chapters itself (#112)
Former-commit-id: 86a6b1564e835d6c637144bf313a9cdec2fc4207
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 | ); |