aboutsummaryrefslogtreecommitdiff
path: root/backend/database
diff options
context:
space:
mode:
Diffstat (limited to 'backend/database')
-rw-r--r--backend/database/chapters.sql34
-rw-r--r--backend/database/init.sql1
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 @@
1INSERT INTO chapters(id, game_id, name) VALUES 1INSERT 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);