From cff5e845c75e9e2751a2c1f01f8ae3fbf24f0e7d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 21 Nov 2024 18:12:07 +0300
Subject: feat/backend: gdrive to backblaze migration, improve create record
 (#237)

---
 backend/database/init.sql | 1 -
 1 file changed, 1 deletion(-)

(limited to 'backend/database')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index e238eae..d49e519 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -137,7 +137,6 @@ CREATE TABLE map_discussions_upvotes (
 
 CREATE TABLE demos (
   id UUID,
-  location_id TEXT NOT NULL,
   PRIMARY KEY (id)
 );
 
-- 
cgit v1.2.3


From 21980e68693a6941bed352a46212ccb72b8b7d88 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Tue, 31 Dec 2024 15:09:56 +0300
Subject: fix/backend: turret assassin map name typo (#254)

---
 backend/database/insert/maps.sql | 2 +-
 backend/handlers/home.go         | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'backend/database')

diff --git a/backend/database/insert/maps.sql b/backend/database/insert/maps.sql
index f0235fa..e896ba9 100644
--- a/backend/database/insert/maps.sql
+++ b/backend/database/insert/maps.sql
@@ -96,7 +96,7 @@ INSERT INTO maps(game_id, chapter_id, name, is_disabled, image) VALUES
 (2,13,'Catapult Block',false,''),
 (2,13,'Bridge Fling',false,''),
 (2,13,'Turret Walls',false,''),
-(2,13,'Turret Assasin',false,''),
+(2,13,'Turret Assassin',false,''),
 (2,13,'Bridge Testing',false,''),
 -- 4
 (2,14,'Cooperative Funnels',false,''),
diff --git a/backend/handlers/home.go b/backend/handlers/home.go
index 5b4e246..095b666 100644
--- a/backend/handlers/home.go
+++ b/backend/handlers/home.go
@@ -327,7 +327,7 @@ func SearchWithQuery(c *gin.Context) {
 		{ID: 80, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Catapult Block"},
 		{ID: 81, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Bridge Fling"},
 		{ID: 82, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Turret Walls"},
-		{ID: 83, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Turret Assasin"},
+		{ID: 83, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Turret Assassin"},
 		{ID: 84, Game: "Portal 2 - Cooperative", Chapter: "Course 3 - Hard-Light Surfaces", Map: "Bridge Testing"},
 		{ID: 85, Game: "Portal 2 - Cooperative", Chapter: "Course 4 - Excursion Funnels", Map: "Cooperative Funnels"},
 		{ID: 86, Game: "Portal 2 - Cooperative", Chapter: "Course 4 - Excursion Funnels", Map: "Funnel Drill"},
-- 
cgit v1.2.3


From 1685d6e13b8a09b0fb4f2ae94fb2e66a437f9155 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sat, 25 Jan 2025 00:38:49 +0300
Subject: wr: finale 2 - 0 portals (#258)

---
 backend/database/insert/history.sql | 1 +
 rankings/input/records.json         | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

(limited to 'backend/database')

diff --git a/backend/database/insert/history.sql b/backend/database/insert/history.sql
index 34fddcb..6b4922a 100644
--- a/backend/database/insert/history.sql
+++ b/backend/database/insert/history.sql
@@ -547,6 +547,7 @@ INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VA
 (57,1,'Krank',5,'2012-07-29'),
 (57,1,'Krzyhau',0,'2017-10-29'),
 (58,1,'Stimich',2,'2011-10-11'),
+(58,1,'Isenstige',0,'2025-01-24'),
 (59,1,'Isimmo',7,'2011-11-04'),
 (59,1,'sicklebrick',6,'2013-03-20'),
 (60,1,'CalmlyFrenetic',7,'2011-10-19'),
diff --git a/rankings/input/records.json b/rankings/input/records.json
index 884fd49..d960004 100644
--- a/rankings/input/records.json
+++ b/rankings/input/records.json
@@ -298,7 +298,7 @@
 		"id": 47822,
 		"name": "Finale 2",
 		"mode": 1,
-		"wr": 2
+		"wr": 0
 	},
 	{
 		"id": 47823,
-- 
cgit v1.2.3