feat: return portal count from games and chapter map select (#155)

2 files changed, 20 insertions, 1 deletions

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
diff --git a/backend/database/init.sql b/backend/database/init.sql
index c33821b..77a88f5 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -36,6 +36,15 @@ CREATE TABLE categories (
   PRIMARY KEY (id)
 );
 
+CREATE TABLE game_categories (
+  id SERIAL,
+  game_id SMALLINT NOT NULL,
+  category_id SMALLINT NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (game_id) REFERENCES games(id),
+  FOREIGN KEY (category_id) REFERENCES categories(id)
+);
+
 CREATE TABLE maps (
   id SERIAL,
   game_id SMALLINT NOT NULL,