From d35a9a945ecaeeceb21bd91eeeaa4c6ec0a15e24 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Fri, 5 Jul 2024 21:03:46 +0300
Subject: feat: return portal count from games and chapter map select (#155)

---
 backend/database/categories.sql | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

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

diff --git a/backend/database/categories.sql b/backend/database/categories.sql
index 5cadad5..6bbf9b0 100644
--- a/backend/database/categories.sql
+++ b/backend/database/categories.sql
@@ -2,4 +2,14 @@ INSERT INTO categories(id, name) VALUES
 (1, 'CM'),
 (2, 'No SLA'),
 (3, 'Inbounds SLA'),
-(4, 'Any%');
\ No newline at end of file
+(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

