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/categories.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 backend/database/insert/categories.sql

(limited to 'backend/database/insert/categories.sql')

diff --git a/backend/database/insert/categories.sql b/backend/database/insert/categories.sql
new file mode 100644
index 0000000..6bbf9b0
--- /dev/null
+++ b/backend/database/insert/categories.sql
@@ -0,0 +1,15 @@
+INSERT INTO categories(id, name) VALUES
+(1, 'CM'),
+(2, 'No SLA'),
+(3, 'Inbounds SLA'),
+(4, 'Any%'),
+(5, 'All Courses');
+
+INSERT INTO game_categories(id, game_id, category_id) VALUES
+(1, 1, 1),
+(2, 1, 2),
+(3, 1, 3),
+(4, 1, 4),
+(5, 2, 1),
+(6, 2, 4),
+(7, 2, 5);
\ No newline at end of file
-- 
cgit v1.2.3