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 | |
| 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')
| -rw-r--r-- | backend/database/chapters.sql | 34 | ||||
| -rw-r--r-- | backend/database/init.sql | 1 |
2 files changed, 18 insertions, 17 deletions
diff --git a/backend/database/chapters.sql b/backend/database/chapters.sql index 9538bed..f61d5bf 100644 --- a/backend/database/chapters.sql +++ b/backend/database/chapters.sql | |||
| @@ -1,17 +1,17 @@ | |||
| 1 | INSERT INTO chapters(id, game_id, name) VALUES | 1 | INSERT INTO chapters(id, game_id, name, is_disabled) VALUES |
| 2 | (1, 1, 'Chapter 1 - The Coutesy Call'), | 2 | (1, 1, 'Chapter 1 - The Coutesy Call', false), |
| 3 | (2, 1, 'Chapter 2 - The Cold Boot'), | 3 | (2, 1, 'Chapter 2 - The Cold Boot', false), |
| 4 | (3, 1, 'Chapter 3 - The Return'), | 4 | (3, 1, 'Chapter 3 - The Return', false), |
| 5 | (4, 1, 'Chapter 4 - The Surprise'), | 5 | (4, 1, 'Chapter 4 - The Surprise', false), |
| 6 | (5, 1, 'Chapter 5 - The Escape'), | 6 | (5, 1, 'Chapter 5 - The Escape', false), |
| 7 | (6, 1, 'Chapter 6 - The Fall'), | 7 | (6, 1, 'Chapter 6 - The Fall', false), |
| 8 | (7, 1, 'Chapter 7 - The Reunion'), | 8 | (7, 1, 'Chapter 7 - The Reunion', false), |
| 9 | (8, 1, 'Chapter 8 - The Itch'), | 9 | (8, 1, 'Chapter 8 - The Itch', false), |
| 10 | (9, 1, 'Chapter 9 - The Part Where He Kills You'), | 10 | (9, 1, 'Chapter 9 - The Part Where He Kills You', false), |
| 11 | (10, 2, 'Course 0 - Introduction'), | 11 | (10, 2, 'Course 0 - Introduction', true), |
| 12 | (11, 2, 'Course 1 - Team Building'), | 12 | (11, 2, 'Course 1 - Team Building', false), |
| 13 | (12, 2, 'Course 2 - Mass And Velocity'), | 13 | (12, 2, 'Course 2 - Mass And Velocity', false), |
| 14 | (13, 2, 'Course 3 - Hard-Light Surfaces'), | 14 | (13, 2, 'Course 3 - Hard-Light Surfaces', false), |
| 15 | (14, 2, 'Course 4 - Excursion Funnels'), | 15 | (14, 2, 'Course 4 - Excursion Funnels', false), |
| 16 | (15, 2, 'Course 5 - Mobility Gels'), | 16 | (15, 2, 'Course 5 - Mobility Gels', false), |
| 17 | (16, 2, 'Course 6 - Art Therapy'); \ No newline at end of file | 17 | (16, 2, 'Course 6 - Art Therapy', false); \ No newline at end of file |
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 | ); |