6 files changed, 478 insertions, 163 deletions

diff --git a/backend/database/categories.sql b/backend/database/categories.sql
new file mode 100644
index 0000000..5cadad5
--- /dev/null
+++ b/backend/database/categories.sql
@@ -0,0 +1,5 @@
+INSERT INTO categories(id, name) VALUES
+(1, 'CM'),
+(2, 'No SLA'),
+(3, 'Inbounds SLA'),
+(4, 'Any%');
\ No newline at end of file
diff --git a/backend/database/chapters.sql b/backend/database/chapters.sql
new file mode 100644
index 0000000..f01ae9c
--- /dev/null
+++ b/backend/database/chapters.sql
@@ -0,0 +1,17 @@
+INSERT INTO chapters(id, game_id, name) VALUES
+(1, 1, 'The Coutesy Call'),
+(2, 1, 'The Cold Boot'),
+(3, 1, 'The Return'),
+(4, 1, 'The Surprise'),
+(5, 1, 'The Escape'),
+(6, 1, 'The Fall'),
+(7, 1, 'The Reunion'),
+(8, 1, 'The Itch'),
+(9, 1, 'The Part Where He Kills You'),
+(10, 2, 'Introduction'),
+(11, 2, 'Team Building'),
+(12, 2, 'Mass And Velocity'),
+(13, 2, 'Hard-Light Surfaces'),
+(14, 2, 'Excursion Funnels'),
+(15, 2, 'Mobility Gels'),
+(16, 2, 'Art Therapy');
\ No newline at end of file
diff --git a/backend/database/games.sql b/backend/database/games.sql
new file mode 100644
index 0000000..5e2f4ee
--- /dev/null
+++ b/backend/database/games.sql
@@ -0,0 +1,3 @@
+INSERT INTO games(id, name) VALUES
+(1, 'Portal 2 - Singleplayer'),
+(2, 'Portal 2 - Cooperative');
\ No newline at end of file
diff --git a/backend/database/history.sql b/backend/database/history.sql
new file mode 100644
index 0000000..0840bf3
--- /dev/null
+++ b/backend/database/history.sql
@@ -0,0 +1,279 @@
+INSERT INTO map_history(map_id,user_name,score_count,record_date) VALUES
+-- Portal 2 Singleplayer
+-- 1
+(3,'slmid1995',3,'2011-10-05 00:00:00'),
+(3,'LookLikeAKango',1,'2011-10-06 00:00:00'),
+(3,'Bananasaurus Rex',0,'2011-10-24 00:00:00'),
+(4,'Tyronis',1,'2011-10-05 00:00:00'),
+(4,'Krzyhau',0,'2019-05-10 00:00:00'),
+(5,'LookLikeAKango',2,'2011-10-05 00:00:00'),
+(5,'Jetwash',1,'2013-12-03 00:00:00'),
+(6,'Stimich',4,'2011-10-08 00:00:00'),
+(6,'aepaePolakrn',3,'2011-10-19 00:00:00'),
+(6,'Krzyhau',2,'2020-10-10 00:00:00'),
+(9,'slmid1995',4,'2011-10-05 00:00:00'),
+(9,'Jokie',3,'2011-10-05 00:00:00'),
+(9,'Tyronis',2,'2011-10-05 00:00:00'),
+(9,'sicklebrick',0,'2013-03-13 00:00:00'),
+-- 2
+(10,'Paraxade0',2,'2011-04-21 00:00:00'),
+(10,'PerOculos',0,'2011-04-21 00:00:00'),
+(11,'Tyronis',2,'2011-10-05 00:00:00'),
+(11,'Krzyhau',0,'2018-06-09 00:00:00'),
+(12,'slmid1995',2,'2011-10-04 00:00:00'),
+(13,'LookLikeAKango',3,'2011-10-05 00:00:00'),
+(13,'Imanex',2,'2011-12-08 00:00:00'),
+(13,'jyjey',0,'2012-08-22 00:00:00'),
+(15,'Tyronis',2,'2011-10-05 00:00:00'),
+(16,'LookLikeAKango',2,'2011-10-05 00:00:00'),
+(16,'jyjey',0,'2012-08-25 00:00:00'),
+(17,'rocoty',0,'2011-10-05 00:00:00'),
+(17,'Nidboj132',0,'2023-02-05 00:00:00'),
+-- 3
+(18,'The Last Tofus',5,'2011-05-08 00:00:00'),
+(18,'Schlepian',4,'2011-10-08 00:00:00'),
+(18,'szeimartin',3,'2013-10-08 00:00:00'),
+(18,'Krzyhau',2,'2020-05-15 00:00:00'),
+(18,'Krzyhau',0,'2022-07-02 00:00:00'),
+(19,'LookLikeAKango',2,'2011-10-06 00:00:00'),
+(20,'Djinndrache',5,'2011-10-20 00:00:00'),
+(20,'Schlepian',4,'2011-10-30 00:00:00'),
+(20,'Jetwash',3,'2014-09-04 00:00:00'),
+(20,'Krzyhau',2,'2022-04-24 00:00:00'),
+(21,'LookLikeAKango',4,'2011-10-06 00:00:00'),
+(21,'ncla',2,'2011-10-30 00:00:00'),
+(21,'PerOculos',0,'2019-07-08 00:00:00'),
+(22,'Tyronis',0,'2011-10-05 00:00:00'),
+(23,'LookLikeAKango',2,'2011-10-06 00:00:00'),
+(23,'Krzyhau',0,'2018-08-01 00:00:00'),
+(24,'LeviHB',0,'2011-04-30 00:00:00'),
+(25,'Tyronis',0,'2011-10-06 00:00:00'),
+(26,'Schlepian',3,'2011-10-30 00:00:00'),
+(26,'Tyronis',2,'2012-01-08 00:00:00'),
+(26,'PerOculos',0,'2016-06-08 00:00:00'),
+-- 4
+(27,'LeviHB',2,'2011-05-01 00:00:00'),
+(27,'PerOculos',0,'2020-07-13 00:00:00'),
+(28,'LeviHB',7,'2011-05-01 00:00:00'),
+(28,'Andy M.J.',2,'2011-10-07 00:00:00'),
+(28,'Krzyhau',0,'2018-05-19 00:00:00'),
+(29,'LeviHB',0,'2011-05-01 00:00:00'),
+(30,'Schlepian',2,'2011-10-30 00:00:00'),
+(31,'Tyronis',0,'2011-10-06 00:00:00'),
+-- 5
+(32,'Tyronis',6,'2011-10-21 00:00:00'),
+(32,'Nidboj132',5,'2022-04-24 00:00:00'),
+(33,'Tyronis',7,'2011-10-06 00:00:00'),
+(33,'ISimmo',5,'2011-11-02 00:00:00'),
+(33,'PerOculos',4,'2017-05-30 00:00:00'),
+(34,'Schlepian',3,'2011-11-01 00:00:00'),
+(34,'Krzyhau',2,'2020-10-14 00:00:00'),
+(34,'zach',0,'2022-11-02 00:00:00'),
+(35,'Krank',2,'2012-07-28 00:00:00'),
+-- 6
+(36,'Tyronis',6,'2011-10-06 00:00:00'),
+(36,'CalmlyFrenetic',5,'2011-10-09 00:00:00'),
+(36,'sicklebrick',4,'2012-09-13 00:00:00'),
+(36,'Nidboj132',2,'2023-03-04 00:00:00'),
+(37,'LookLikeAKango',7,'2011-10-06 00:00:00'),
+(37,'Schlepian',6,'2011-11-01 00:00:00'),
+(37,'Tyronis',5,'2012-01-28 00:00:00'),
+(37,'Nidboj132',4,'2021-08-22 00:00:00'),
+(38,'Andy M.J.',2,'2011-10-06 00:00:00'),
+(38,'Sanguine Dagger',0,'2012-03-19 00:00:00'),
+(39,'Lambda Core',6,'2011-05-13 00:00:00'),
+(39,'The Last Tofus',5,'2011-05-13 00:00:00'),
+(39,'LookLikeAKango',4,'2011-10-16 00:00:00'),
+(39,'Kittaye',3,'2013-03-25 00:00:00'),
+(40,'LookLikeAKango',7,'2011-10-07 00:00:00'),
+(40,'Schlepian',6,'2011-11-05 00:00:00'),
+(40,'Kittaye',4,'2013-04-01 00:00:00'),
+(40,'Kittaye',3,'2014-09-13 00:00:00'),
+(40,'szeimartin',2,'2014-09-13 00:00:00'),
+(40,'Kittaye',0,'2014-09-15 00:00:00'),
+(41,'CalmlyFrenetic',7,'2011-10-09 00:00:00'),
+(41,'Jaso',6,'2011-10-11 00:00:00'),
+(41,'Krank',5,'2012-07-17 00:00:00'),
+-- 7
+(42,'LookLikeAKango',4,'2011-05-17 00:00:00'),
+(42,'ISimmo',2,'2011-11-07 00:00:00'),
+(43,'lmao4ever',5,'2011-10-30 00:00:00'),
+(43,'Jaso',2,'2011-11-09 00:00:00'),
+(43,'feliser',0,'2022-06-26 00:00:00'),
+(44,'LookLikeAKango',18,'2011-10-07 00:00:00'),
+(44,'Tyronis',13,'2011-10-30 00:00:00'),
+(44,'Tyronis',12,'2011-11-10 00:00:00'),
+(44,'Jetwash',11,'2017-06-12 00:00:00'),
+(44,'Krzyhau',9,'2022-01-02 00:00:00'),
+(45,'LookLikeAKango',23,'2011-10-08 00:00:00'),
+(45,'CalmlyFrenetic',22,'2011-10-09 00:00:00'),
+(45,'cgreactor',17,'2011-10-09 00:00:00'),
+(45,'CalmlyFrenetic',16,'2011-10-10 00:00:00'),
+(45,'LookLikeAKango',15,'2011-10-19 00:00:00'),
+(45,'Jaso',12,'2012-07-19 00:00:00'),
+(45,'Krank',10,'2013-01-31 00:00:00'),
+(45,'Kittaye',7,'2013-04-04 00:00:00'),
+(45,'PerOculos',4,'2014-09-13 00:00:00'),
+-- 8
+(46,'sparkle1princess',6,'2012-03-24 00:00:00'),
+(46,'Krzyhau',2,'2019-11-21 00:00:00'),
+(47,'holydevel',2,'2011-10-06 00:00:00'),
+(47,'JesusCatFace',0,'2015-01-16 00:00:00'),
+(48,'LookLikeAKango',5,'2011-10-08 00:00:00'),
+(48,'Tyronis',2,'2011-10-08 00:00:00'),
+(48,'adzicents',0,'2011-10-09 00:00:00'),
+(49,'adzicents',4,'2011-10-07 00:00:00'),
+(49,'Schlepian',2,'2011-10-08 00:00:00'),
+(49,'Nidboj132',0,'2022-09-26 00:00:00'),
+(50,'LookLikeAKango',4,'2011-10-08 00:00:00'),
+(50,'Tyronis',2,'2011-10-11 00:00:00'),
+(50,'sicklebrick',0,'2013-03-20 00:00:00'),
+(51,'Andy M.J.',3,'2011-10-08 00:00:00'),
+(51,'LookLikeAKango',2,'2011-10-20 00:00:00'),
+(52,'Jaso',0,'2011-10-10 00:00:00'),
+(53,'LookLikeAKango',9,'2011-10-08 00:00:00'),
+(53,'LookLikeAKango',2,'2011-10-20 00:00:00'),
+(53,'Schlepian',0,'2011-11-06 00:00:00'),
+(54,'LookLikeAKango',7,'2011-06-01 00:00:00'),
+(54,'Jaso',6,'2011-10-09 00:00:00'),
+(54,'Schlepian',5,'2011-11-06 00:00:00'),
+(54,'Spyrunite',4,'2012-08-30 00:00:00'),
+(54,'Krzyhau',3,'2019-04-22 00:00:00'),
+(55,'LookLikeAKango',7,'2011-10-08 00:00:00'),
+(55,'CalmlyFrenetic',3,'2011-10-09 00:00:00'),
+(55,'Jaso',2,'2011-11-26 00:00:00'),
+(55,'PerOculos',0,'2021-02-06 00:00:00'),
+(56,'CalmlyFrenetic',9,'2011-10-08 00:00:00'),
+(56,'LookLikeAKango',5,'2011-10-09 00:00:00'),
+(56,'CalmlyFrenetic',4,'2011-10-09 00:00:00'),
+(56,'Jetwash',2,'2014-09-05 00:00:00'),
+-- 9
+(57,'JNS',7,'2011-07-21 00:00:00'),
+(57,'Krank',5,'2012-07-29 00:00:00'),
+(57,'Krzyhau',0,'2017-10-29 00:00:00'),
+(58,'Stimich',2,'2011-10-11 00:00:00'),
+(59,'Isimmo',7,'2011-11-04 00:00:00'),
+(59,'sicklebrick',6,'2013-03-20 00:00:00'),
+(60,'CalmlyFrenetic',7,'2011-10-19 00:00:00'),
+(60,'Tyronis',6,'2011-11-01 00:00:00'),
+-- Portal 2 Cooperative
+-- 1
+(63,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+(64,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(64,'Chubfish & Exhale',2,'2011-11-01 00:00:00'),
+(65,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(65,'Nidboj132 & Oryn',3,'2022-02-03 00:00:00'),
+(66,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(66,'Schlepian & Chubfish',2,'2011-10-01 00:00:00'),
+(67,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+(68,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+-- 2
+(69,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(70,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01 00:00:00'),
+(70,'Schlepian & Chubfish',4,'2011-10-01 00:00:00'),
+(70,'Gocnak & z1mb0bw4y',2,'2012-08-03 00:00:00'),
+(70,'DM_ & VEGA',0,'2017-10-01 00:00:00'),
+(71,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(71,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+(72,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(72,'Schlepian & LongJohnDickWeed',2,'2011-10-01 00:00:00'),
+(73,'Stimich & HiTMaRkS',9,'2011-05-09 00:00:00'),
+(73,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01 00:00:00'),
+(73,'Schlepian & Lemonsunshine',7,'2011-11-01 00:00:00'),
+(73,'DM_ & LsDK_',6,'2018-01-01 00:00:00'),
+(73,'Krzyhau & Klooger',4,'2018-11-01 00:00:00'),
+(74,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
+(74,'Stimich & Pitkakorva',7,'2011-10-11 00:00:00'),
+(74,'Schlepian & Isimmo',3,'2011-10-28 00:00:00'),
+(74,'Zypeh & szeimartin',2,'2013-11-01 00:00:00'),
+(75,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
+(75,'Schlepian & Urination',4,'2011-10-01 00:00:00'),
+(75,'Schlepian & Lemonsunshine',2,'2012-02-01 00:00:00'),
+(75,'DM_ & follon',0,'2015-04-01 00:00:00'),
+(76,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(76,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
+-- 3
+(77,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(78,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(78,'DM_ & marK',3,'2016-11-01 00:00:00'),
+(78,'Nidboj132 & Oryn',2,'2021-09-04 00:00:00'),
+(79,'ganonscrub & ?',5,'2011-04-01 00:00:00'),
+(79,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(79,'Chubfish & Exhale',2,'2012-08-04 00:00:00'),
+(80,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
+(80,'Chubfish & Exhale',4,'2011-12-01 00:00:00'),
+(81,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01 00:00:00'),
+(81,'Schlepian & Lemonsunshine',6,'2011-10-01 00:00:00'),
+(81,'takz & dawn',5,'2011-11-01 00:00:00'),
+(81,'Nidboj132 & Oryn',4,'2021-03-25 00:00:00'),
+(82,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(83,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
+(83,'Schlepian & Lemonsunshine',2,'2011-10-01 00:00:00'),
+(83,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
+(84,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01 00:00:00'),
+(84,'Schlepian & Chubfish',4,'2011-10-01 00:00:00'),
+(84,'Chubfish & Exhale',2,'2012-01-01 00:00:00'),
+(84,'DM_ & wS',0,'2015-05-01 00:00:00'),
+-- 4
+(85,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(85,'Chubfish & Exhale',0,'2011-10-01 00:00:00'),
+(86,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(86,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
+(87,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
+(87,'Schlepian & Gopherdude',2,'2011-10-01 00:00:00'),
+(87,'DM_ & follon',0,'2015-04-01 00:00:00'),
+(88,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(88,'Schlepian & Gopherdude',0,'2011-10-01 00:00:00'),
+(89,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+(90,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01 00:00:00'),
+(90,'Schlepian & Urination',2,'2011-10-01 00:00:00'),
+(90,'Klooger & Jetwash',0,'2016-08-01 00:00:00'),
+(91,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01 00:00:00'),
+(91,'Undead & Zypeh',0,'2013-05-19 00:00:00'),
+(92,'txx478 & ?',5,'2011-05-01 00:00:00'),
+(92,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
+(92,'Schlepian & Gopherdude',2,'2011-10-01 00:00:00'),
+(92,'ncla & takz',0,'2012-02-01 00:00:00'),
+(93,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01 00:00:00'),
+(93,'Schlepian & Gopherdude',0,'2011-10-01 00:00:00'),
+-- 5
+(94,'Chubfish & Exhale',2,'2011-10-01 00:00:00'),
+(94,'Klooger & Imanex',0,'2013-08-01 00:00:00'),
+(95,'Schlepian & Issimoi',2,'2011-10-01 00:00:00'),
+(96,'ThePortalPatrol & ?',4,'2011-04-01 00:00:00'),
+(96,'sparkle1princess & Zypeh',2,'2014-01-01 00:00:00'),
+(97,'Stimich & HiTMaRkS',7,'2011-05-13 00:00:00'),
+(97,'Schlepian & Lemonsunshine',4,'2011-10-01 00:00:00'),
+(97,'DM_ & wS',2,'2014-05-01 00:00:00'),
+(98,'Imanex & 00svo',0,'2011-11-01 00:00:00'),
+(99,'Schlepian & Gopherdude',3,'2011-10-01 00:00:00'),
+(99,'Imanex & Klooger',2,'2013-08-01 00:00:00'),
+(99,'DM_ & wS',0,'2015-05-01 00:00:00'),
+(100,'Schlepian & Bananasaurus Rex',0,'2011-10-01 00:00:00'),
+(101,'Chubfish & Exhale',2,'2011-12-01 00:00:00'),
+(101,'DM_ & follon',0,'2015-04-01 00:00:00'),
+-- 6
+(102,'dawn & takz',3,'2011-11-18 00:00:00'),
+(102,'Chubfish & Exhale',2,'2012-01-01 00:00:00'),
+(102,'Imanex & Klooger',0,'2013-08-01 00:00:00'),
+(103,'Schlepian & Lemonsunshine',0,'2011-10-01 00:00:00'),
+(104,'Schlepian & Lemonsunshine',0,'2011-10-01 00:00:00'),
+(105,'Blaizerazer & ?',8,'2011-10-01 00:00:00'),
+(105,'Schlepian & Lemonsunshine',5,'2011-11-01 00:00:00'),
+(105,'Imanex & Klooger',4,'2013-08-01 00:00:00'),
+(105,'DM_ & wS',3,'2014-05-01 00:00:00'),
+(105,'DM_ & follon',2,'2015-04-01 00:00:00'),
+(106,'Schlepian & Bananasaurus Rex',4,'2011-10-01 00:00:00'),
+(106,'Gig & takz',3,'2012-06-01 00:00:00'),
+(106,'Imanex & Klooger',0,'2013-06-01 00:00:00'),
+(107,'Chubfish & Exhale',2,'2011-10-01 00:00:00'),
+(107,'DM_ & follon',0,'2015-04-01 00:00:00'),
+(108,'DaFox & P',0,'2011-12-01 00:00:00'),
+(109,'Schlepian & Tyronis',5,'2011-10-01 00:00:00'),
+(109,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
+(110,'Tyronis & mr.bob806',15,'2011-10-01 00:00:00'),
+(110,'Schlepian & Chubfish',6,'2011-11-01 00:00:00'),
+(110,'00svo & z1mb0bw4y',5,'2012-08-08 00:00:00'),
+(110,'00svo & z1mb0bw4y',4,'2012-08-10 00:00:00'),
+(110,'Klooger & z1mb0bw4y',2,'2014-02-01 00:00:00'),
+(110,'DM_ & follon',0,'2015-04-01 00:00:00');
\ No newline at end of file
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 7e225f0..51a4881 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -1,16 +1,6 @@
-DROP TABLE IF EXISTS showcases;
-DROP TABLE IF EXISTS titles;
-DROP TABLE IF EXISTS records_sp;
-DROP TABLE IF EXISTS records_mp;
-DROP TABLE IF EXISTS maps;
-DROP TABLE IF EXISTS users;
-DROP TABLE IF EXISTS countries;
-
-DROP TABLE IF EXISTS demos;
-
 CREATE TABLE users (
   steam_id TEXT,
-  username TEXT NOT NULL,
+  user_name TEXT NOT NULL,
   avatar_link TEXT NOT NULL,
   country_code CHAR(2) NOT NULL,
   created_at TIMESTAMP NOT NULL DEFAULT now(),
@@ -18,14 +8,68 @@ CREATE TABLE users (
   PRIMARY KEY (steam_id)
 );
 
+CREATE TABLE games (
+  id SMALLSERIAL,
+  name TEXT NOT NULL,
+  PRIMARY KEY (id)
+);
+
+CREATE TABLE chapters (
+  id SMALLSERIAL,
+  game_id SMALLINT NOT NULL,
+  name TEXT NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (game_id) REFERENCES games(id)
+);
+
+CREATE TABLE categories (
+  id SMALLSERIAL,
+  name TEXT NOT NULL,
+  PRIMARY KEY (id)
+);
+
 CREATE TABLE maps (
   id SMALLSERIAL,
-  map_name TEXT NOT NULL,
-  wr_score SMALLINT NOT NULL,
-  wr_time INTEGER NOT NULL,
-  is_coop BOOLEAN NOT NULL,
+  game_id SMALLINT NOT NULL,
+  chapter_id SMALLINT NOT NULL,
+  name TEXT NOT NULL,
+  description TEXT NOT NULL,
+  showcase TEXT NOT NULL,
   is_disabled BOOLEAN NOT NULL DEFAULT false,
-  PRIMARY KEY (id)
+  PRIMARY KEY (id),
+  FOREIGN KEY (game_id) REFERENCES games(id),
+  FOREIGN KEY (chapter_id) REFERENCES chapters(id)
+);
+
+CREATE TABLE map_history (
+  id SMALLSERIAL,
+  map_id SMALLINT NOT NULL,
+  user_name TEXT NOT NULL,
+  score_count SMALLINT NOT NULL,
+  record_date TIMESTAMP NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (map_id) REFERENCES maps(id)
+);
+
+CREATE TABLE map_ratings (
+  id SERIAL,
+  map_id SMALLINT NOT NULL,
+  user_id TEXT NOT NULL,
+  rating SMALLINT NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (map_id) REFERENCES maps(id),
+  FOREIGN KEY (user_id) REFERENCES users(steam_id)
+);
+
+CREATE TABLE map_routers (
+  id SMALLSERIAL,
+  map_id SMALLINT NOT NULL,
+  user_id TEXT,
+  user_name TEXT NOT NULL,
+  score_count SMALLINT NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (map_id) REFERENCES maps(id),
+  FOREIGN KEY (user_id) REFERENCES users(steam_id)
 );
 
 CREATE TABLE demos (
@@ -78,36 +122,3 @@ CREATE TABLE countries (
   country_name TEXT NOT NULL,
   PRIMARY KEY (country_code)
 );
-
--- CREATE TABLE community_maps (
---   id SMALLSERIAL,
---   map_id SMALLINT NOT NULL,
---   category TEXT NOT NULL,
---   tutorial TEXT NOT NULL,
---   video_link TEXT NOT NULL,
---   PRIMARY KEY (id),
---   FOREIGN KEY (map_id) REFERENCES maps(id)
--- );
-
--- TODO
--- CREATE TABLE community_history (
---   id SERIAL,
---   map_id SMALLINT NOT NULL,
---   user_id TEXT NOT NULL,
---   score_count SMALLINT NOT NULL,
---   created_at TIMESTAMP NOT NULL DEFAULT now(),
---   PRIMARY KEY (id),
---   FOREIGN KEY (user_id) REFERENCES users(steam_id),
---   FOREIGN KEY (map_id) REFERENCES maps(id)
--- );
-
--- CREATE TABLE community_posts (
---   id SERIAL,
---   map_id SMALLINT NOT NULL,
---   user_id TEXT NOT NULL,
---   post TEXT NOT NULL,
---   created_at TIMESTAMP NOT NULL DEFAULT now(),
---   PRIMARY KEY (id),
---   FOREIGN KEY (user_id) REFERENCES users(steam_id),
---   FOREIGN KEY (map_id) REFERENCES maps(id)
--- );
\ No newline at end of file
diff --git a/backend/database/maps.sql b/backend/database/maps.sql
index 127eb58..50689e2 100644
--- a/backend/database/maps.sql
+++ b/backend/database/maps.sql
@@ -1,129 +1,129 @@
-DELETE FROM maps;
-INSERT INTO maps (map_name, wr_score, wr_time, is_coop, is_disabled) VALUES
--- Singleplayer
+INSERT INTO maps(game_id, chapter_id, name, description, showcase, is_disabled) VALUES
+-- Portal 2 Singleplayer
 -- 1
-('Container Ride',0,-1,false,true),
-('Portal Carousel',0,-1,false,true),
-('Portal Gun',0,-1,false,false),
-('Smooth Jazz',0,-1,false,false),
-('Cube Momentum',1,-1,false,false),
-('Future Starter',2,-1,false,false),
-('Secret Panel',0,-1,false,false),
-('Wakeup',0,-1,false,true),
-('Incinerator',0,-1,false,false),
+(1,1,'Container Ride','','',true),
+(1,1,'Portal Carousel','','',true),
+(1,1,'Portal Gun','','',false),
+(1,1,'Smooth Jazz','','',false),
+(1,1,'Cube Momentum','','',false),
+(1,1,'Future Starter','','',false),
+(1,1,'Secret Panel','','',false),
+(1,1,'Wakeup','','',true),
+(1,1,'Incinerator','','',false),
 -- 2
-('Laser Intro',0,-1,false,false),
-('Laser Stairs',0,-1,false,false),
-('Dual Lasers',2,-1,false,false),
-('Laser Over Goo',0,-1,false,false),
-('Catapult Intro',0,-1,false,true),
-('Trust Fling',2,-1,false,false),
-('Pit Flings',0,-1,false,false),
-('Fizzler Intro',2,-1,false,false),
+(1,2,'Laser Intro','','',false),
+(1,2,'Laser Stairs','','',false),
+(1,2,'Dual Lasers','','',false),
+(1,2,'Laser Over Goo','','',false),
+(1,2,'Catapult Intro','','',true),
+(1,2,'Trust Fling','','',false),
+(1,2,'Pit Flings','','',false),
+(1,2,'Fizzler Intro','','',false),
 -- 3
-('Ceiling Catapult',0,-1,false,false),
-('Ricochet',2,-1,false,false),
-('Bridge Intro',2,-1,false,false),
-('Bridge The Gap',0,-1,false,false),
-('Turret Intro',0,-1,false,false),
-('Laser Relays',0,-1,false,false),
-('Turret Blocker',0,-1,false,false),
-('Laser vs Turret',0,-1,false,false),
-('Pull The Rug',0,-1,false,false),
+(1,3,'Ceiling Catapult','','',false),
+(1,3,'Ricochet','','',false),
+(1,3,'Bridge Intro','','',false),
+(1,3,'Bridge The Gap','','',false),
+(1,3,'Turret Intro','','',false),
+(1,3,'Laser Relays','','',false),
+(1,3,'Turret Blocker','','',false),
+(1,3,'Laser vs Turret','','',false),
+(1,3,'Pull The Rug','','',false),
 -- 4
-('Column Blocker',0,-1,false,false),
-('Laser Chaining',0,-1,false,false),
-('Triple Laser',0,-1,false,false),
-('Jail Break',2,-1,false,false),
-('Escape',0,-1,false,false),
+(1,4,'Column Blocker','','',false),
+(1,4,'Laser Chaining','','',false),
+(1,4,'Triple Laser','','',false),
+(1,4,'Jail Break','','',false),
+(1,4,'Escape','','',false),
 -- 5
-('Turret Factory',5,-1,false,false),
-('Turret Sabotage',4,-1,false,false),
-('Neurotoxin Sabotage',0,-1,false,false),
-('Core',2,-1,false,false),
+(1,5,'Turret Factory','','',false),
+(1,5,'Turret Sabotage','','',false),
+(1,5,'Neurotoxin Sabotage','','',false),
+(1,5,'Core','','',false),
 -- 6
-('Underground',4,-1,false,false),
-('Cave Johnson',4,-1,false,false),
-('Repulsion Intro',0,-1,false,false),
-('Bomb Flings',3,-1,false,false),
-('Crazy Box',0,-1,false,false),
-('PotatOS',5,-1,false,false),
+(1,6,'Underground','','',false),
+(1,6,'Cave Johnson','','',false),
+(1,6,'Repulsion Intro','','',false),
+(1,6,'Bomb Flings','','',false),
+(1,6,'Crazy Box','','',false),
+(1,6,'PotatOS','','',false),
 -- 7
-('Propulsion Intro',2,-1,false,false),
-('Propulsion Flings',0,-1,false,false),
-('Conversion Intro',9,-1,false,false),
-('Three Gels',4,-1,false,false),
+(1,7,'Propulsion Intro','','',false),
+(1,7,'Propulsion Flings','','',false),
+(1,7,'Conversion Intro','','',false),
+(1,7,'Three Gels','','',false),
 -- 8
-('Test',2,-1,false,false),
-('Funnel Intro',0,-1,false,false),
-('Ceiling Button',0,-1,false,false),
-('Wall Button',0,-1,false,false),
-('Polarity',0,-1,false,false),
-('Funnel Catch',2,-1,false,false),
-('Stop The Box',0,-1,false,false),
-('Laser Catapult',0,-1,false,false),
-('Laser Platform',3,-1,false,false),
-('Propulsion Catch',0,-1,false,false),
-('Repulsion Polarity',2,-1,false,false),
+(1,8,'Test','','',false),
+(1,8,'Funnel Intro','','',false),
+(1,8,'Ceiling Button','','',false),
+(1,8,'Wall Button','','',false),
+(1,8,'Polarity','','',false),
+(1,8,'Funnel Catch','','',false),
+(1,8,'Stop The Box','','',false),
+(1,8,'Laser Catapult','','',false),
+(1,8,'Laser Platform','','',false),
+(1,8,'Propulsion Catch','','',false),
+(1,8,'Repulsion Polarity','','',false),
 -- 9
-('Finale 1',0,-1,false,false),
-('Finale 2',2,-1,false,false),
-('Finale 3',6,-1,false,false),
-('Finale 4',6,-1,false,false),
--- Coop
+(1,9,'Finale 1','','',false),
+(1,9,'Finale 2','','',false),
+(1,9,'Finale 3','','',false),
+(1,9,'Finale 4','','',false),
+-- Portal 2 Cooperative
+-- 0
+(2,10,'Calibration','','',false),
+(2,10,'Hub','','',true),
 -- 1
-('Calibration',4,-1,true,false),
-('Hub',0,-1,false,true),
-('Doors',0,-1,true,false),
-('Buttons',2,-1,true,false),
-('Lasers',3,-1,true,false),
-('Rat Maze',2,-1,true,false),
-('Laser Crusher',0,-1,true,false),
-('Behind The Scenes',0,-1,true,false),
+(2,11,'Doors','','',false),
+(2,11,'Buttons','','',false),
+(2,11,'Lasers','','',false),
+(2,11,'Rat Maze','','',false),
+(2,11,'Laser Crusher','','',false),
+(2,11,'Behind The Scenes','','',false),
 -- 2
-('Flings',4,-1,true,false),
-('Infinifling',0,-1,true,false),
-('Team Retrieval',0,-1,true,false),
-('Vertical Flings',2,-1,true,false),
-('Catapults',4,-1,true,false),
-('Multifling',2,-1,true,false),
-('Fling Crushers',0,-1,true,false),
-('Industrial Fan',0,-1,true,false),
+(2,12,'Flings','','',false),
+(2,12,'Infinifling','','',false),
+(2,12,'Team Retrieval','','',false),
+(2,12,'Vertical Flings','','',false),
+(2,12,'Catapults','','',false),
+(2,12,'Multifling','','',false),
+(2,12,'Fling Crushers','','',false),
+(2,12,'Industrial Fan','','',false),
 -- 3
-('Cooperative Bridges',3,-1,true,false),
-('Bridge Swap',2,-1,true,false),
-('Fling Block',2,-1,true,false),
-('Catapult Block',4,-1,true,false),
-('Bridge Fling',4,-1,true,false),
-('Turret Walls',4,-1,true,false),
-('Turret Assasin',0,-1,true,false),
-('Bridge Testing',0,-1,true,false),
+(2,13,'Cooperative Bridges','','',false),
+(2,13,'Bridge Swap','','',false),
+(2,13,'Fling Block','','',false),
+(2,13,'Catapult Block','','',false),
+(2,13,'Bridge Fling','','',false),
+(2,13,'Turret Walls','','',false),
+(2,13,'Turret Assasin','','',false),
+(2,13,'Bridge Testing','','',false),
 -- 4
-('Cooperative Funnels',0,-1,true,false),
-('Funnel Drill',0,-1,true,false),
-('Funnel Catch',0,-1,true,false),
-('Funnel Laser',0,-1,true,false),
-('Cooperative Polarity',0,-1,true,false),
-('Funnel Hop',0,-1,true,false),
-('Advanced Polarity',0,-1,true,false),
-('Funnel Maze',0,-1,true,false),
-('Turret Warehouse',0,-1,true,false),
+(2,14,'Cooperative Funnels','','',false),
+(2,14,'Funnel Drill','','',false),
+(2,14,'Funnel Catch','','',false),
+(2,14,'Funnel Laser','','',false),
+(2,14,'Cooperative Polarity','','',false),
+(2,14,'Funnel Hop','','',false),
+(2,14,'Advanced Polarity','','',false),
+(2,14,'Funnel Maze','','',false),
+(2,14,'Turret Warehouse','','',false),
 -- 5
-('Repulsion Jumps',0,-1,true,false),
-('Double Bounce',2,-1,true,false),
-('Bridge Repulsion',2,-1,true,false),
-('Wall Repulsion',2,-1,true,false),
-('Propulsion Crushers',0,-1,true,false),
-('Turret Ninja',0,-1,true,false),
-('Propulsion Retrieval',0,-1,true,false),
-('Vault Entrance',0,-1,true,false),
+(2,15,'Repulsion Jumps','','',false),
+(2,15,'Double Bounce','','',false),
+(2,15,'Bridge Repulsion','','',false),
+(2,15,'Wall Repulsion','','',false),
+(2,15,'Propulsion Crushers','','',false),
+(2,15,'Turret Ninja','','',false),
+(2,15,'Propulsion Retrieval','','',false),
+(2,15,'Vault Entrance','','',false),
 -- 6
-('Seperation',0,-1,true,false),
-('Triple Axis',0,-1,true,false),
-('Catapult Catch',0,-1,true,false),
-('Bridge Gels',2,-1,true,false),
-('Maintenance',0,-1,true,false),
-('Bridge Catch',0,-1,true,false),
-('Double Lift',0,-1,true,false),
-('Gel Maze',0,-1,true,false),
-('Crazier Box',0,-1,true,false);
\ No newline at end of file
+(2,16,'Seperation','','',false),
+(2,16,'Triple Axis','','',false),
+(2,16,'Catapult Catch','','',false),
+(2,16,'Bridge Gels','','',false),
+(2,16,'Maintenance','','',false),
+(2,16,'Bridge Catch','','',false),
+(2,16,'Double Lift','','',false),
+(2,16,'Gel Maze','','',false),
+(2,16,'Crazier Box','','',false);
\ No newline at end of file