From 69e15976e42ef404f5b0857e0ca2ea3bb8e6159b Mon Sep 17 00:00:00 2001 From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> Date: Thu, 31 Oct 2024 22:54:28 +0300 Subject: database: organize sql files --- backend/database/insert/chapters.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 backend/database/insert/chapters.sql (limited to 'backend/database/insert/chapters.sql') 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 @@ +INSERT INTO chapters(id, game_id, name, is_disabled) VALUES +(1, 1, 'Chapter 1 - The Coutesy Call', false), +(2, 1, 'Chapter 2 - The Cold Boot', false), +(3, 1, 'Chapter 3 - The Return', false), +(4, 1, 'Chapter 4 - The Surprise', false), +(5, 1, 'Chapter 5 - The Escape', false), +(6, 1, 'Chapter 6 - The Fall', false), +(7, 1, 'Chapter 7 - The Reunion', false), +(8, 1, 'Chapter 8 - The Itch', false), +(9, 1, 'Chapter 9 - The Part Where He Kills You', false), +(10, 2, 'Course 0 - Introduction', true), +(11, 2, 'Course 1 - Team Building', false), +(12, 2, 'Course 2 - Mass And Velocity', false), +(13, 2, 'Course 3 - Hard-Light Surfaces', false), +(14, 2, 'Course 4 - Excursion Funnels', false), +(15, 2, 'Course 5 - Mobility Gels', false), +(16, 2, 'Course 6 - Art Therapy', false); \ No newline at end of file -- cgit v1.2.3