diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-04-24 16:01:23 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-04-24 16:01:23 +0300 |
| commit | cf52f753cfe1f06f4081510175d3584f122848af (patch) | |
| tree | f656de3c960bd116189309cfd3658765899799b1 /backend/database/chapters.sql | |
| parent | doc: fix demo download uuid from path to query (diff) | |
| download | lphub-cf52f753cfe1f06f4081510175d3584f122848af.tar.gz lphub-cf52f753cfe1f06f4081510175d3584f122848af.tar.bz2 lphub-cf52f753cfe1f06f4081510175d3584f122848af.zip | |
feat/db: multiple game/chapter support, improved map relations (#1)
Diffstat (limited to 'backend/database/chapters.sql')
| -rw-r--r-- | backend/database/chapters.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/backend/database/chapters.sql b/backend/database/chapters.sql new file mode 100644 index 0000000..f01ae9c --- /dev/null +++ b/backend/database/chapters.sql | |||
| @@ -0,0 +1,17 @@ | |||
| 1 | INSERT INTO chapters(id, game_id, name) VALUES | ||
| 2 | (1, 1, 'The Coutesy Call'), | ||
| 3 | (2, 1, 'The Cold Boot'), | ||
| 4 | (3, 1, 'The Return'), | ||
| 5 | (4, 1, 'The Surprise'), | ||
| 6 | (5, 1, 'The Escape'), | ||
| 7 | (6, 1, 'The Fall'), | ||
| 8 | (7, 1, 'The Reunion'), | ||
| 9 | (8, 1, 'The Itch'), | ||
| 10 | (9, 1, 'The Part Where He Kills You'), | ||
| 11 | (10, 2, 'Introduction'), | ||
| 12 | (11, 2, 'Team Building'), | ||
| 13 | (12, 2, 'Mass And Velocity'), | ||
| 14 | (13, 2, 'Hard-Light Surfaces'), | ||
| 15 | (14, 2, 'Excursion Funnels'), | ||
| 16 | (15, 2, 'Mobility Gels'), | ||
| 17 | (16, 2, 'Art Therapy'); \ No newline at end of file | ||