From cd31abc1bf4a97b04afb95fc10a88070f1a72cc4 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Mon, 24 Apr 2023 21:28:10 +0300
Subject: feat: history data from lp sheet ported

---
 backend/database/history.sql | 279 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 279 insertions(+)
 create mode 100644 backend/database/history.sql

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

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
-- 
cgit v1.2.3