From 7884ae7ca077082a7d87621aa1f437628f10372d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 15 Jan 2023 02:48:44 +0300
Subject: add wr time to maps database

---
 backend/database/init.sql |   1 +
 backend/database/maps.sql | 222 +++++++++++++++++++++++-----------------------
 2 files changed, 112 insertions(+), 111 deletions(-)

(limited to 'backend/database')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 345cee3..f5d380c 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -22,6 +22,7 @@ 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,
   is_disabled BOOLEAN NOT NULL DEFAULT false,
   PRIMARY KEY (id)
diff --git a/backend/database/maps.sql b/backend/database/maps.sql
index e67d7e8..127eb58 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, is_coop, is_disabled) VALUES
+INSERT INTO maps (map_name, wr_score, wr_time, is_coop, is_disabled) VALUES
 -- Singleplayer
 -- 1
-('Container Ride',0,false,true),
-('Portal Carousel',0,false,true),
-('Portal Gun',0,false,false),
-('Smooth Jazz',0,false,false),
-('Cube Momentum',1,false,false),
-('Future Starter',2,false,false),
-('Secret Panel',0,false,false),
-('Wakeup',0,false,true),
-('Incinerator',0,false,false),
+('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),
 -- 2
-('Laser Intro',0,false,false),
-('Laser Stairs',0,false,false),
-('Dual Lasers',2,false,false),
-('Laser Over Goo',0,false,false),
-('Catapult Intro',0,false,true),
-('Trust Fling',2,false,false),
-('Pit Flings',0,false,false),
-('Fizzler Intro',2,false,false),
+('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),
 -- 3
-('Ceiling Catapult',0,false,false),
-('Ricochet',2,false,false),
-('Bridge Intro',2,false,false),
-('Bridge The Gap',0,false,false),
-('Turret Intro',0,false,false),
-('Laser Relays',0,false,false),
-('Turret Blocker',0,false,false),
-('Laser vs Turret',0,false,false),
-('Pull The Rug',0,false,false),
+('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),
 -- 4
-('Column Blocker',0,false,false),
-('Laser Chaining',0,false,false),
-('Triple Laser',0,false,false),
-('Jail Break',2,false,false),
-('Escape',0,false,false),
+('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),
 -- 5
-('Turret Factory',5,false,false),
-('Turret Sabotage',4,false,false),
-('Neurotoxin Sabotage',0,false,false),
-('Core',2,false,false),
+('Turret Factory',5,-1,false,false),
+('Turret Sabotage',4,-1,false,false),
+('Neurotoxin Sabotage',0,-1,false,false),
+('Core',2,-1,false,false),
 -- 6
-('Underground',4,false,false),
-('Cave Johnson',4,false,false),
-('Repulsion Intro',0,false,false),
-('Bomb Flings',3,false,false),
-('Crazy Box',0,false,false),
-('PotatOS',5,false,false),
+('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),
 -- 7
-('Propulsion Intro',2,false,false),
-('Propulsion Flings',0,false,false),
-('Conversion Intro',9,false,false),
-('Three Gels',4,false,false),
+('Propulsion Intro',2,-1,false,false),
+('Propulsion Flings',0,-1,false,false),
+('Conversion Intro',9,-1,false,false),
+('Three Gels',4,-1,false,false),
 -- 8
-('Test',2,false,false),
-('Funnel Intro',0,false,false),
-('Ceiling Button',0,false,false),
-('Wall Button',0,false,false),
-('Polarity',0,false,false),
-('Funnel Catch',2,false,false),
-('Stop The Box',0,false,false),
-('Laser Catapult',0,false,false),
-('Laser Platform',3,false,false),
-('Propulsion Catch',0,false,false),
-('Repulsion Polarity',2,false,false),
+('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),
 -- 9
-('Finale 1',0,false,false),
-('Finale 2',2,false,false),
-('Finale 3',6,false,false),
-('Finale 4',6,false,false),
+('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
-('Calibration',4,true,false),
-('Hub',0,false,true),
-('Doors',0,true,false),
-('Buttons',2,true,false),
-('Lasers',3,true,false),
-('Rat Maze',2,true,false),
-('Laser Crusher',0,true,false),
-('Behind The Scenes',0,true,false),
+('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
-('Flings',4,true,false),
-('Infinifling',0,true,false),
-('Team Retrieval',0,true,false),
-('Vertical Flings',2,true,false),
-('Catapults',4,true,false),
-('Multifling',2,true,false),
-('Fling Crushers',0,true,false),
-('Industrial Fan',0,true,false),
+('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),
 -- 3
-('Cooperative Bridges',3,true,false),
-('Bridge Swap',2,true,false),
-('Fling Block',2,true,false),
-('Catapult Block',4,true,false),
-('Bridge Fling',4,true,false),
-('Turret Walls',4,true,false),
-('Turret Assasin',0,true,false),
-('Bridge Testing',0,true,false),
+('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),
 -- 4
-('Cooperative Funnels',0,true,false),
-('Funnel Drill',0,true,false),
-('Funnel Catch',0,true,false),
-('Funnel Laser',0,true,false),
-('Cooperative Polarity',0,true,false),
-('Funnel Hop',0,true,false),
-('Advanced Polarity',0,true,false),
-('Funnel Maze',0,true,false),
-('Turret Warehouse',0,true,false),
+('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),
 -- 5
-('Repulsion Jumps',0,true,false),
-('Double Bounce',2,true,false),
-('Bridge Repulsion',2,true,false),
-('Wall Repulsion',2,true,false),
-('Propulsion Crushers',0,true,false),
-('Turret Ninja',0,true,false),
-('Propulsion Retrieval',0,true,false),
-('Vault Entrance',0,true,false),
+('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),
 -- 6
-('Seperation',0,true,false),
-('Triple Axis',0,true,false),
-('Catapult Catch',0,true,false),
-('Bridge Gels',2,true,false),
-('Maintenance',0,true,false),
-('Bridge Catch',0,true,false),
-('Double Lift',0,true,false),
-('Gel Maze',0,true,false),
-('Crazier Box',0,true,false);
\ No newline at end of file
+('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
-- 
cgit v1.2.3