aboutsummaryrefslogtreecommitdiff
path: root/backend/database/insert/chapters.sql
diff options
context:
space:
mode:
authorArda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>2024-10-31 22:54:28 +0300
committerArda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>2024-10-31 22:54:28 +0300
commit69e15976e42ef404f5b0857e0ca2ea3bb8e6159b (patch)
tree7f17f86b19f25a4e3e47a8edf5104ec3ab5256a4 /backend/database/insert/chapters.sql
parentbackend: add rate limiting (diff)
downloadlphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.gz
lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.bz2
lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.zip
database: organize sql files
Diffstat (limited to 'backend/database/insert/chapters.sql')
-rw-r--r--backend/database/insert/chapters.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/backend/database/insert/chapters.sql b/backend/database/insert/chapters.sql
new file mode 100644
index 0000000..f61d5bf
--- /dev/null
+++ b/backend/database/insert/chapters.sql
@@ -0,0 +1,17 @@
1INSERT INTO chapters(id, game_id, name, is_disabled) VALUES
2(1, 1, 'Chapter 1 - The Coutesy Call', false),
3(2, 1, 'Chapter 2 - The Cold Boot', false),
4(3, 1, 'Chapter 3 - The Return', false),
5(4, 1, 'Chapter 4 - The Surprise', false),
6(5, 1, 'Chapter 5 - The Escape', false),
7(6, 1, 'Chapter 6 - The Fall', false),
8(7, 1, 'Chapter 7 - The Reunion', false),
9(8, 1, 'Chapter 8 - The Itch', false),
10(9, 1, 'Chapter 9 - The Part Where He Kills You', false),
11(10, 2, 'Course 0 - Introduction', true),
12(11, 2, 'Course 1 - Team Building', false),
13(12, 2, 'Course 2 - Mass And Velocity', false),
14(13, 2, 'Course 3 - Hard-Light Surfaces', false),
15(14, 2, 'Course 4 - Excursion Funnels', false),
16(15, 2, 'Course 5 - Mobility Gels', false),
17(16, 2, 'Course 6 - Art Therapy', false); \ No newline at end of file