From 9f7b5a836c8aeb83b66e0b41b8533443b5e99380 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 20 Aug 2023 12:36:34 +0300
Subject: fix: change map history from timestamp to date

Former-commit-id: 8a46950e919891f380dda5502e40434383c91245
---
 backend/database/history.sql | 522 +++++++++++++++++++++----------------------
 backend/database/init.sql    |   2 +-
 2 files changed, 262 insertions(+), 262 deletions(-)

(limited to 'backend/database')

diff --git a/backend/database/history.sql b/backend/database/history.sql
index 320d72f..b30d10d 100644
--- a/backend/database/history.sql
+++ b/backend/database/history.sql
@@ -1,279 +1,279 @@
 INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VALUES
 -- Portal 2 Singleplayer
 -- 1
-(3,1,'slmid1995',3,'2011-10-05 00:00:00'),
-(3,1,'LookLikeAKango',1,'2011-10-06 00:00:00'),
-(3,1,'Bananasaurus Rex',0,'2011-10-24 00:00:00'),
-(4,1,'Tyronis',1,'2011-10-05 00:00:00'),
-(4,1,'Krzyhau',0,'2019-05-10 00:00:00'),
-(5,1,'LookLikeAKango',2,'2011-10-05 00:00:00'),
-(5,1,'Jetwash',1,'2013-12-03 00:00:00'),
-(6,1,'Stimich',4,'2011-10-08 00:00:00'),
-(6,1,'aepaePolakrn',3,'2011-10-19 00:00:00'),
-(6,1,'Krzyhau',2,'2020-10-10 00:00:00'),
-(9,1,'slmid1995',4,'2011-10-05 00:00:00'),
-(9,1,'Jokie',3,'2011-10-05 00:00:00'),
-(9,1,'Tyronis',2,'2011-10-05 00:00:00'),
-(9,1,'sicklebrick',0,'2013-03-13 00:00:00'),
+(3,1,'slmid1995',3,'2011-10-05'),
+(3,1,'LookLikeAKango',1,'2011-10-06'),
+(3,1,'Bananasaurus Rex',0,'2011-10-24'),
+(4,1,'Tyronis',1,'2011-10-05'),
+(4,1,'Krzyhau',0,'2019-05-10'),
+(5,1,'LookLikeAKango',2,'2011-10-05'),
+(5,1,'Jetwash',1,'2013-12-03'),
+(6,1,'Stimich',4,'2011-10-08'),
+(6,1,'aepaePolakrn',3,'2011-10-19'),
+(6,1,'Krzyhau',2,'2020-10-10'),
+(9,1,'slmid1995',4,'2011-10-05'),
+(9,1,'Jokie',3,'2011-10-05'),
+(9,1,'Tyronis',2,'2011-10-05'),
+(9,1,'sicklebrick',0,'2013-03-13'),
 -- 2
-(10,1,'Paraxade0',2,'2011-04-21 00:00:00'),
-(10,1,'PerOculos',0,'2011-04-21 00:00:00'),
-(11,1,'Tyronis',2,'2011-10-05 00:00:00'),
-(11,1,'Krzyhau',0,'2018-06-09 00:00:00'),
-(12,1,'slmid1995',2,'2011-10-04 00:00:00'),
-(13,1,'LookLikeAKango',3,'2011-10-05 00:00:00'),
-(13,1,'Imanex',2,'2011-12-08 00:00:00'),
-(13,1,'jyjey',0,'2012-08-22 00:00:00'),
-(15,1,'Tyronis',2,'2011-10-05 00:00:00'),
-(16,1,'LookLikeAKango',2,'2011-10-05 00:00:00'),
-(16,1,'jyjey',0,'2012-08-25 00:00:00'),
-(17,1,'rocoty',2,'2011-10-05 00:00:00'),
-(17,1,'Nidboj132',0,'2023-02-05 00:00:00'),
+(10,1,'Paraxade0',2,'2011-04-21'),
+(10,1,'PerOculos',0,'2011-04-21'),
+(11,1,'Tyronis',2,'2011-10-05'),
+(11,1,'Krzyhau',0,'2018-06-09'),
+(12,1,'slmid1995',2,'2011-10-04'),
+(13,1,'LookLikeAKango',3,'2011-10-05'),
+(13,1,'Imanex',2,'2011-12-08'),
+(13,1,'jyjey',0,'2012-08-22'),
+(15,1,'Tyronis',2,'2011-10-05'),
+(16,1,'LookLikeAKango',2,'2011-10-05'),
+(16,1,'jyjey',0,'2012-08-25'),
+(17,1,'rocoty',2,'2011-10-05'),
+(17,1,'Nidboj132',0,'2023-02-05'),
 -- 3
-(18,1,'The Last Tofus',5,'2011-05-08 00:00:00'),
-(18,1,'Schlepian',4,'2011-10-08 00:00:00'),
-(18,1,'szeimartin',3,'2013-10-08 00:00:00'),
-(18,1,'Krzyhau',2,'2020-05-15 00:00:00'),
-(18,1,'Krzyhau',0,'2022-07-02 00:00:00'),
-(19,1,'LookLikeAKango',2,'2011-10-06 00:00:00'),
-(20,1,'Djinndrache',5,'2011-10-20 00:00:00'),
-(20,1,'Schlepian',4,'2011-10-30 00:00:00'),
-(20,1,'Jetwash',3,'2014-09-04 00:00:00'),
-(20,1,'Krzyhau',2,'2022-04-24 00:00:00'),
-(21,1,'LookLikeAKango',4,'2011-10-06 00:00:00'),
-(21,1,'ncla',2,'2011-10-30 00:00:00'),
-(21,1,'PerOculos',0,'2019-07-08 00:00:00'),
-(22,1,'Tyronis',0,'2011-10-05 00:00:00'),
-(23,1,'LookLikeAKango',2,'2011-10-06 00:00:00'),
-(23,1,'Krzyhau',0,'2018-08-01 00:00:00'),
-(24,1,'LeviHB',0,'2011-04-30 00:00:00'),
-(25,1,'Tyronis',0,'2011-10-06 00:00:00'),
-(26,1,'Schlepian',3,'2011-10-30 00:00:00'),
-(26,1,'Tyronis',2,'2012-01-08 00:00:00'),
-(26,1,'PerOculos',0,'2016-06-08 00:00:00'),
+(18,1,'The Last Tofus',5,'2011-05-08'),
+(18,1,'Schlepian',4,'2011-10-08'),
+(18,1,'szeimartin',3,'2013-10-08'),
+(18,1,'Krzyhau',2,'2020-05-15'),
+(18,1,'Krzyhau',0,'2022-07-02'),
+(19,1,'LookLikeAKango',2,'2011-10-06'),
+(20,1,'Djinndrache',5,'2011-10-20'),
+(20,1,'Schlepian',4,'2011-10-30'),
+(20,1,'Jetwash',3,'2014-09-04'),
+(20,1,'Krzyhau',2,'2022-04-24'),
+(21,1,'LookLikeAKango',4,'2011-10-06'),
+(21,1,'ncla',2,'2011-10-30'),
+(21,1,'PerOculos',0,'2019-07-08'),
+(22,1,'Tyronis',0,'2011-10-05'),
+(23,1,'LookLikeAKango',2,'2011-10-06'),
+(23,1,'Krzyhau',0,'2018-08-01'),
+(24,1,'LeviHB',0,'2011-04-30'),
+(25,1,'Tyronis',0,'2011-10-06'),
+(26,1,'Schlepian',3,'2011-10-30'),
+(26,1,'Tyronis',2,'2012-01-08'),
+(26,1,'PerOculos',0,'2016-06-08'),
 -- 4
-(27,1,'LeviHB',2,'2011-05-01 00:00:00'),
-(27,1,'PerOculos',0,'2020-07-13 00:00:00'),
-(28,1,'LeviHB',7,'2011-05-01 00:00:00'),
-(28,1,'Andy M.J.',2,'2011-10-07 00:00:00'),
-(28,1,'Krzyhau',0,'2018-05-19 00:00:00'),
-(29,1,'LeviHB',0,'2011-05-01 00:00:00'),
-(30,1,'Schlepian',2,'2011-10-30 00:00:00'),
-(31,1,'Tyronis',0,'2011-10-06 00:00:00'),
+(27,1,'LeviHB',2,'2011-05-01'),
+(27,1,'PerOculos',0,'2020-07-13'),
+(28,1,'LeviHB',7,'2011-05-01'),
+(28,1,'Andy M.J.',2,'2011-10-07'),
+(28,1,'Krzyhau',0,'2018-05-19'),
+(29,1,'LeviHB',0,'2011-05-01'),
+(30,1,'Schlepian',2,'2011-10-30'),
+(31,1,'Tyronis',0,'2011-10-06'),
 -- 5
-(32,1,'Tyronis',6,'2011-10-21 00:00:00'),
-(32,1,'Nidboj132',5,'2022-04-24 00:00:00'),
-(33,1,'Tyronis',7,'2011-10-06 00:00:00'),
-(33,1,'ISimmo',5,'2011-11-02 00:00:00'),
-(33,1,'PerOculos',4,'2017-05-30 00:00:00'),
-(34,1,'Schlepian',3,'2011-11-01 00:00:00'),
-(34,1,'Krzyhau',2,'2020-10-14 00:00:00'),
-(34,1,'zach',0,'2022-11-02 00:00:00'),
-(35,1,'Krank',2,'2012-07-28 00:00:00'),
+(32,1,'Tyronis',6,'2011-10-21'),
+(32,1,'Nidboj132',5,'2022-04-24'),
+(33,1,'Tyronis',7,'2011-10-06'),
+(33,1,'ISimmo',5,'2011-11-02'),
+(33,1,'PerOculos',4,'2017-05-30'),
+(34,1,'Schlepian',3,'2011-11-01'),
+(34,1,'Krzyhau',2,'2020-10-14'),
+(34,1,'zach',0,'2022-11-02'),
+(35,1,'Krank',2,'2012-07-28'),
 -- 6
-(36,1,'Tyronis',6,'2011-10-06 00:00:00'),
-(36,1,'CalmlyFrenetic',5,'2011-10-09 00:00:00'),
-(36,1,'sicklebrick',4,'2012-09-13 00:00:00'),
-(36,1,'Nidboj132',2,'2023-03-04 00:00:00'),
-(37,1,'LookLikeAKango',7,'2011-10-06 00:00:00'),
-(37,1,'Schlepian',6,'2011-11-01 00:00:00'),
-(37,1,'Tyronis',5,'2012-01-28 00:00:00'),
-(37,1,'Nidboj132',4,'2021-08-22 00:00:00'),
-(38,1,'Andy M.J.',2,'2011-10-06 00:00:00'),
-(38,1,'Sanguine Dagger',0,'2012-03-19 00:00:00'),
-(39,1,'Lambda Core',6,'2011-05-13 00:00:00'),
-(39,1,'The Last Tofus',5,'2011-05-13 00:00:00'),
-(39,1,'LookLikeAKango',4,'2011-10-16 00:00:00'),
-(39,1,'Kittaye',3,'2013-03-25 00:00:00'),
-(40,1,'LookLikeAKango',7,'2011-10-07 00:00:00'),
-(40,1,'Schlepian',6,'2011-11-05 00:00:00'),
-(40,1,'Kittaye',4,'2013-04-01 00:00:00'),
-(40,1,'Kittaye',3,'2014-09-13 00:00:00'),
-(40,1,'szeimartin',2,'2014-09-13 00:00:00'),
-(40,1,'Kittaye',0,'2014-09-15 00:00:00'),
-(41,1,'CalmlyFrenetic',7,'2011-10-09 00:00:00'),
-(41,1,'Jaso',6,'2011-10-11 00:00:00'),
-(41,1,'Krank',5,'2012-07-17 00:00:00'),
+(36,1,'Tyronis',6,'2011-10-06'),
+(36,1,'CalmlyFrenetic',5,'2011-10-09'),
+(36,1,'sicklebrick',4,'2012-09-13'),
+(36,1,'Nidboj132',2,'2023-03-04'),
+(37,1,'LookLikeAKango',7,'2011-10-06'),
+(37,1,'Schlepian',6,'2011-11-01'),
+(37,1,'Tyronis',5,'2012-01-28'),
+(37,1,'Nidboj132',4,'2021-08-22'),
+(38,1,'Andy M.J.',2,'2011-10-06'),
+(38,1,'Sanguine Dagger',0,'2012-03-19'),
+(39,1,'Lambda Core',6,'2011-05-13'),
+(39,1,'The Last Tofus',5,'2011-05-13'),
+(39,1,'LookLikeAKango',4,'2011-10-16'),
+(39,1,'Kittaye',3,'2013-03-25'),
+(40,1,'LookLikeAKango',7,'2011-10-07'),
+(40,1,'Schlepian',6,'2011-11-05'),
+(40,1,'Kittaye',4,'2013-04-01'),
+(40,1,'Kittaye',3,'2014-09-13'),
+(40,1,'szeimartin',2,'2014-09-13'),
+(40,1,'Kittaye',0,'2014-09-15'),
+(41,1,'CalmlyFrenetic',7,'2011-10-09'),
+(41,1,'Jaso',6,'2011-10-11'),
+(41,1,'Krank',5,'2012-07-17'),
 -- 7
-(42,1,'LookLikeAKango',4,'2011-05-17 00:00:00'),
-(42,1,'ISimmo',2,'2011-11-07 00:00:00'),
-(43,1,'lmao4ever',5,'2011-10-30 00:00:00'),
-(43,1,'Jaso',2,'2011-11-09 00:00:00'),
-(43,1,'feliser',0,'2022-06-26 00:00:00'),
-(44,1,'LookLikeAKango',18,'2011-10-07 00:00:00'),
-(44,1,'Tyronis',13,'2011-10-30 00:00:00'),
-(44,1,'Tyronis',12,'2011-11-10 00:00:00'),
-(44,1,'Jetwash',11,'2017-06-12 00:00:00'),
-(44,1,'Krzyhau',9,'2022-01-02 00:00:00'),
-(45,1,'LookLikeAKango',23,'2011-10-08 00:00:00'),
-(45,1,'CalmlyFrenetic',22,'2011-10-09 00:00:00'),
-(45,1,'cgreactor',17,'2011-10-09 00:00:00'),
-(45,1,'CalmlyFrenetic',16,'2011-10-10 00:00:00'),
-(45,1,'LookLikeAKango',15,'2011-10-19 00:00:00'),
-(45,1,'Jaso',12,'2012-07-19 00:00:00'),
-(45,1,'Krank',10,'2013-01-31 00:00:00'),
-(45,1,'Kittaye',7,'2013-04-04 00:00:00'),
-(45,1,'PerOculos',4,'2014-09-13 00:00:00'),
+(42,1,'LookLikeAKango',4,'2011-05-17'),
+(42,1,'ISimmo',2,'2011-11-07'),
+(43,1,'lmao4ever',5,'2011-10-30'),
+(43,1,'Jaso',2,'2011-11-09'),
+(43,1,'feliser',0,'2022-06-26'),
+(44,1,'LookLikeAKango',18,'2011-10-07'),
+(44,1,'Tyronis',13,'2011-10-30'),
+(44,1,'Tyronis',12,'2011-11-10'),
+(44,1,'Jetwash',11,'2017-06-12'),
+(44,1,'Krzyhau',9,'2022-01-02'),
+(45,1,'LookLikeAKango',23,'2011-10-08'),
+(45,1,'CalmlyFrenetic',22,'2011-10-09'),
+(45,1,'cgreactor',17,'2011-10-09'),
+(45,1,'CalmlyFrenetic',16,'2011-10-10'),
+(45,1,'LookLikeAKango',15,'2011-10-19'),
+(45,1,'Jaso',12,'2012-07-19'),
+(45,1,'Krank',10,'2013-01-31'),
+(45,1,'Kittaye',7,'2013-04-04'),
+(45,1,'PerOculos',4,'2014-09-13'),
 -- 8
-(46,1,'sparkle1princess',6,'2012-03-24 00:00:00'),
-(46,1,'Krzyhau',2,'2019-11-21 00:00:00'),
-(47,1,'holydevel',2,'2011-10-06 00:00:00'),
-(47,1,'JesusCatFace',0,'2015-01-16 00:00:00'),
-(48,1,'LookLikeAKango',5,'2011-10-08 00:00:00'),
-(48,1,'Tyronis',2,'2011-10-08 00:00:00'),
-(48,1,'adzicents',0,'2011-10-09 00:00:00'),
-(49,1,'adzicents',4,'2011-10-07 00:00:00'),
-(49,1,'Schlepian',2,'2011-10-08 00:00:00'),
-(49,1,'Nidboj132',0,'2022-09-26 00:00:00'),
-(50,1,'LookLikeAKango',4,'2011-10-08 00:00:00'),
-(50,1,'Tyronis',2,'2011-10-11 00:00:00'),
-(50,1,'sicklebrick',0,'2013-03-20 00:00:00'),
-(51,1,'Andy M.J.',3,'2011-10-08 00:00:00'),
-(51,1,'LookLikeAKango',2,'2011-10-20 00:00:00'),
-(52,1,'Jaso',0,'2011-10-10 00:00:00'),
-(53,1,'LookLikeAKango',9,'2011-10-08 00:00:00'),
-(53,1,'LookLikeAKango',2,'2011-10-20 00:00:00'),
-(53,1,'Schlepian',0,'2011-11-06 00:00:00'),
-(54,1,'LookLikeAKango',7,'2011-06-01 00:00:00'),
-(54,1,'Jaso',6,'2011-10-09 00:00:00'),
-(54,1,'Schlepian',5,'2011-11-06 00:00:00'),
-(54,1,'Spyrunite',4,'2012-08-30 00:00:00'),
-(54,1,'Krzyhau',3,'2019-04-22 00:00:00'),
-(55,1,'LookLikeAKango',7,'2011-10-08 00:00:00'),
-(55,1,'CalmlyFrenetic',3,'2011-10-09 00:00:00'),
-(55,1,'Jaso',2,'2011-11-26 00:00:00'),
-(55,1,'PerOculos',0,'2021-02-06 00:00:00'),
-(56,1,'CalmlyFrenetic',9,'2011-10-08 00:00:00'),
-(56,1,'LookLikeAKango',5,'2011-10-09 00:00:00'),
-(56,1,'CalmlyFrenetic',4,'2011-10-09 00:00:00'),
-(56,1,'Jetwash',2,'2014-09-05 00:00:00'),
+(46,1,'sparkle1princess',6,'2012-03-24'),
+(46,1,'Krzyhau',2,'2019-11-21'),
+(47,1,'holydevel',2,'2011-10-06'),
+(47,1,'JesusCatFace',0,'2015-01-16'),
+(48,1,'LookLikeAKango',5,'2011-10-08'),
+(48,1,'Tyronis',2,'2011-10-08'),
+(48,1,'adzicents',0,'2011-10-09'),
+(49,1,'adzicents',4,'2011-10-07'),
+(49,1,'Schlepian',2,'2011-10-08'),
+(49,1,'Nidboj132',0,'2022-09-26'),
+(50,1,'LookLikeAKango',4,'2011-10-08'),
+(50,1,'Tyronis',2,'2011-10-11'),
+(50,1,'sicklebrick',0,'2013-03-20'),
+(51,1,'Andy M.J.',3,'2011-10-08'),
+(51,1,'LookLikeAKango',2,'2011-10-20'),
+(52,1,'Jaso',0,'2011-10-10'),
+(53,1,'LookLikeAKango',9,'2011-10-08'),
+(53,1,'LookLikeAKango',2,'2011-10-20'),
+(53,1,'Schlepian',0,'2011-11-06'),
+(54,1,'LookLikeAKango',7,'2011-06-01'),
+(54,1,'Jaso',6,'2011-10-09'),
+(54,1,'Schlepian',5,'2011-11-06'),
+(54,1,'Spyrunite',4,'2012-08-30'),
+(54,1,'Krzyhau',3,'2019-04-22'),
+(55,1,'LookLikeAKango',7,'2011-10-08'),
+(55,1,'CalmlyFrenetic',3,'2011-10-09'),
+(55,1,'Jaso',2,'2011-11-26'),
+(55,1,'PerOculos',0,'2021-02-06'),
+(56,1,'CalmlyFrenetic',9,'2011-10-08'),
+(56,1,'LookLikeAKango',5,'2011-10-09'),
+(56,1,'CalmlyFrenetic',4,'2011-10-09'),
+(56,1,'Jetwash',2,'2014-09-05'),
 -- 9
-(57,1,'JNS',7,'2011-07-21 00:00:00'),
-(57,1,'Krank',5,'2012-07-29 00:00:00'),
-(57,1,'Krzyhau',0,'2017-10-29 00:00:00'),
-(58,1,'Stimich',2,'2011-10-11 00:00:00'),
-(59,1,'Isimmo',7,'2011-11-04 00:00:00'),
-(59,1,'sicklebrick',6,'2013-03-20 00:00:00'),
-(60,1,'CalmlyFrenetic',7,'2011-10-19 00:00:00'),
-(60,1,'Tyronis',6,'2011-11-01 00:00:00'),
+(57,1,'JNS',7,'2011-07-21'),
+(57,1,'Krank',5,'2012-07-29'),
+(57,1,'Krzyhau',0,'2017-10-29'),
+(58,1,'Stimich',2,'2011-10-11'),
+(59,1,'Isimmo',7,'2011-11-04'),
+(59,1,'sicklebrick',6,'2013-03-20'),
+(60,1,'CalmlyFrenetic',7,'2011-10-19'),
+(60,1,'Tyronis',6,'2011-11-01'),
 -- Portal 2 Cooperative
 -- 1
-(63,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
-(64,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(64,1,'Chubfish & Exhale',2,'2011-11-01 00:00:00'),
-(65,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(65,1,'Nidboj132 & Oryn',3,'2022-02-03 00:00:00'),
-(66,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(66,1,'Schlepian & Chubfish',2,'2011-10-01 00:00:00'),
-(67,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
-(68,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
+(63,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(64,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(64,1,'Chubfish & Exhale',2,'2011-11-01'),
+(65,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(65,1,'Nidboj132 & Oryn',3,'2022-02-03'),
+(66,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(66,1,'Schlepian & Chubfish',2,'2011-10-01'),
+(67,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(68,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
 -- 2
-(69,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(70,1,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01 00:00:00'),
-(70,1,'Schlepian & Chubfish',4,'2011-10-01 00:00:00'),
-(70,1,'Gocnak & z1mb0bw4y',2,'2012-08-03 00:00:00'),
-(70,1,'DM_ & VEGA',0,'2017-10-01 00:00:00'),
-(71,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(71,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
-(72,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(72,1,'Schlepian & LongJohnDickWeed',2,'2011-10-01 00:00:00'),
-(73,1,'Stimich & HiTMaRkS',9,'2011-05-09 00:00:00'),
-(73,1,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01 00:00:00'),
-(73,1,'Schlepian & Lemonsunshine',7,'2011-11-01 00:00:00'),
-(73,1,'DM_ & LsDK_',6,'2018-01-01 00:00:00'),
-(73,1,'Krzyhau & Klooger',4,'2018-11-01 00:00:00'),
-(74,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
-(74,1,'Stimich & Pitkakorva',7,'2011-10-11 00:00:00'),
-(74,1,'Schlepian & Isimmo',3,'2011-10-28 00:00:00'),
-(74,1,'Zypeh & szeimartin',2,'2013-11-01 00:00:00'),
-(75,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
-(75,1,'Schlepian & Urination',4,'2011-10-01 00:00:00'),
-(75,1,'Schlepian & Lemonsunshine',2,'2012-02-01 00:00:00'),
-(75,1,'DM_ & follon',0,'2015-04-01 00:00:00'),
-(76,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(76,1,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
+(69,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(70,1,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
+(70,1,'Schlepian & Chubfish',4,'2011-10-01'),
+(70,1,'Gocnak & z1mb0bw4y',2,'2012-08-03'),
+(70,1,'DM_ & VEGA',0,'2017-10-01'),
+(71,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(71,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(72,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(72,1,'Schlepian & LongJohnDickWeed',2,'2011-10-01'),
+(73,1,'Stimich & HiTMaRkS',9,'2011-05-09'),
+(73,1,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01'),
+(73,1,'Schlepian & Lemonsunshine',7,'2011-11-01'),
+(73,1,'DM_ & LsDK_',6,'2018-01-01'),
+(73,1,'Krzyhau & Klooger',4,'2018-11-01'),
+(74,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(74,1,'Stimich & Pitkakorva',7,'2011-10-11'),
+(74,1,'Schlepian & Isimmo',3,'2011-10-28'),
+(74,1,'Zypeh & szeimartin',2,'2013-11-01'),
+(75,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(75,1,'Schlepian & Urination',4,'2011-10-01'),
+(75,1,'Schlepian & Lemonsunshine',2,'2012-02-01'),
+(75,1,'DM_ & follon',0,'2015-04-01'),
+(76,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(76,1,'Chubfish & Exhale',0,'2011-12-01'),
 -- 3
-(77,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(78,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(78,1,'DM_ & marK',3,'2016-11-01 00:00:00'),
-(78,1,'Nidboj132 & Oryn',2,'2021-09-04 00:00:00'),
-(79,1,'ganonscrub & ?',5,'2011-04-01 00:00:00'),
-(79,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(79,1,'Chubfish & Exhale',2,'2012-08-04 00:00:00'),
-(80,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
-(80,1,'Chubfish & Exhale',4,'2011-12-01 00:00:00'),
-(81,1,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01 00:00:00'),
-(81,1,'Schlepian & Lemonsunshine',6,'2011-10-01 00:00:00'),
-(81,1,'takz & dawn',5,'2011-11-01 00:00:00'),
-(81,1,'Nidboj132 & Oryn',4,'2021-03-25 00:00:00'),
-(82,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(83,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01 00:00:00'),
-(83,1,'Schlepian & Lemonsunshine',2,'2011-10-01 00:00:00'),
-(83,1,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
-(84,1,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01 00:00:00'),
-(84,1,'Schlepian & Chubfish',4,'2011-10-01 00:00:00'),
-(84,1,'Chubfish & Exhale',2,'2012-01-01 00:00:00'),
-(84,1,'DM_ & wS',0,'2015-05-01 00:00:00'),
+(77,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(78,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(78,1,'DM_ & marK',3,'2016-11-01'),
+(78,1,'Nidboj132 & Oryn',2,'2021-09-04'),
+(79,1,'ganonscrub & ?',5,'2011-04-01'),
+(79,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(79,1,'Chubfish & Exhale',2,'2012-08-04'),
+(80,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(80,1,'Chubfish & Exhale',4,'2011-12-01'),
+(81,1,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01'),
+(81,1,'Schlepian & Lemonsunshine',6,'2011-10-01'),
+(81,1,'takz & dawn',5,'2011-11-01'),
+(81,1,'Nidboj132 & Oryn',4,'2021-03-25'),
+(82,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(83,1,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(83,1,'Schlepian & Lemonsunshine',2,'2011-10-01'),
+(83,1,'Chubfish & Exhale',0,'2011-12-01'),
+(84,1,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
+(84,1,'Schlepian & Chubfish',4,'2011-10-01'),
+(84,1,'Chubfish & Exhale',2,'2012-01-01'),
+(84,1,'DM_ & wS',0,'2015-05-01'),
 -- 4
-(85,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(85,1,'Chubfish & Exhale',0,'2011-10-01 00:00:00'),
-(86,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(86,1,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
-(87,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01 00:00:00'),
-(87,1,'Schlepian & Gopherdude',2,'2011-10-01 00:00:00'),
-(87,1,'DM_ & follon',0,'2015-04-01 00:00:00'),
-(88,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(88,1,'Schlepian & Gopherdude',0,'2011-10-01 00:00:00'),
-(89,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01 00:00:00'),
-(90,1,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01 00:00:00'),
-(90,1,'Schlepian & Urination',2,'2011-10-01 00:00:00'),
-(90,1,'Klooger & Jetwash',0,'2016-08-01 00:00:00'),
-(91,1,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01 00:00:00'),
-(91,1,'Undead & Zypeh',0,'2013-05-19 00:00:00'),
-(92,1,'txx478 & ?',5,'2011-05-01 00:00:00'),
-(92,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01 00:00:00'),
-(92,1,'Schlepian & Gopherdude',2,'2011-10-01 00:00:00'),
-(92,1,'ncla & takz',0,'2012-02-01 00:00:00'),
-(93,1,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01 00:00:00'),
-(93,1,'Schlepian & Gopherdude',0,'2011-10-01 00:00:00'),
+(85,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(85,1,'Chubfish & Exhale',0,'2011-10-01'),
+(86,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(86,1,'Chubfish & Exhale',0,'2011-12-01'),
+(87,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(87,1,'Schlepian & Gopherdude',2,'2011-10-01'),
+(87,1,'DM_ & follon',0,'2015-04-01'),
+(88,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(88,1,'Schlepian & Gopherdude',0,'2011-10-01'),
+(89,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(90,1,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01'),
+(90,1,'Schlepian & Urination',2,'2011-10-01'),
+(90,1,'Klooger & Jetwash',0,'2016-08-01'),
+(91,1,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
+(91,1,'Undead & Zypeh',0,'2013-05-19'),
+(92,1,'txx478 & ?',5,'2011-05-01'),
+(92,1,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(92,1,'Schlepian & Gopherdude',2,'2011-10-01'),
+(92,1,'ncla & takz',0,'2012-02-01'),
+(93,1,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
+(93,1,'Schlepian & Gopherdude',0,'2011-10-01'),
 -- 5
-(94,1,'Chubfish & Exhale',2,'2011-10-01 00:00:00'),
-(94,1,'Klooger & Imanex',0,'2013-08-01 00:00:00'),
-(95,1,'Schlepian & Issimoi',2,'2011-10-01 00:00:00'),
-(96,1,'ThePortalPatrol & ?',4,'2011-04-01 00:00:00'),
-(96,1,'sparkle1princess & Zypeh',2,'2014-01-01 00:00:00'),
-(97,1,'Stimich & HiTMaRkS',7,'2011-05-13 00:00:00'),
-(97,1,'Schlepian & Lemonsunshine',4,'2011-10-01 00:00:00'),
-(97,1,'DM_ & wS',2,'2014-05-01 00:00:00'),
-(98,1,'Imanex & 00svo',0,'2011-11-01 00:00:00'),
-(99,1,'Schlepian & Gopherdude',3,'2011-10-01 00:00:00'),
-(99,1,'Imanex & Klooger',2,'2013-08-01 00:00:00'),
-(99,1,'DM_ & wS',0,'2015-05-01 00:00:00'),
-(100,1,'Schlepian & Bananasaurus Rex',0,'2011-10-01 00:00:00'),
-(101,1,'Chubfish & Exhale',2,'2011-12-01 00:00:00'),
-(101,1,'DM_ & follon',0,'2015-04-01 00:00:00'),
+(94,1,'Chubfish & Exhale',2,'2011-10-01'),
+(94,1,'Klooger & Imanex',0,'2013-08-01'),
+(95,1,'Schlepian & Issimoi',2,'2011-10-01'),
+(96,1,'ThePortalPatrol & ?',4,'2011-04-01'),
+(96,1,'sparkle1princess & Zypeh',2,'2014-01-01'),
+(97,1,'Stimich & HiTMaRkS',7,'2011-05-13'),
+(97,1,'Schlepian & Lemonsunshine',4,'2011-10-01'),
+(97,1,'DM_ & wS',2,'2014-05-01'),
+(98,1,'Imanex & 00svo',0,'2011-11-01'),
+(99,1,'Schlepian & Gopherdude',3,'2011-10-01'),
+(99,1,'Imanex & Klooger',2,'2013-08-01'),
+(99,1,'DM_ & wS',0,'2015-05-01'),
+(100,1,'Schlepian & Bananasaurus Rex',0,'2011-10-01'),
+(101,1,'Chubfish & Exhale',2,'2011-12-01'),
+(101,1,'DM_ & follon',0,'2015-04-01'),
 -- 6
-(102,1,'dawn & takz',3,'2011-11-18 00:00:00'),
-(102,1,'Chubfish & Exhale',2,'2012-01-01 00:00:00'),
-(102,1,'Imanex & Klooger',0,'2013-08-01 00:00:00'),
-(103,1,'Schlepian & Lemonsunshine',0,'2011-10-01 00:00:00'),
-(104,1,'Schlepian & Lemonsunshine',0,'2011-10-01 00:00:00'),
-(105,1,'Blaizerazer & ?',8,'2011-10-01 00:00:00'),
-(105,1,'Schlepian & Lemonsunshine',5,'2011-11-01 00:00:00'),
-(105,1,'Imanex & Klooger',4,'2013-08-01 00:00:00'),
-(105,1,'DM_ & wS',3,'2014-05-01 00:00:00'),
-(105,1,'DM_ & follon',2,'2015-04-01 00:00:00'),
-(106,1,'Schlepian & Bananasaurus Rex',4,'2011-10-01 00:00:00'),
-(106,1,'Gig & takz',3,'2012-06-01 00:00:00'),
-(106,1,'Imanex & Klooger',0,'2013-06-01 00:00:00'),
-(107,1,'Chubfish & Exhale',2,'2011-10-01 00:00:00'),
-(107,1,'DM_ & follon',0,'2015-04-01 00:00:00'),
-(108,1,'DaFox & P',0,'2011-12-01 00:00:00'),
-(109,1,'Schlepian & Tyronis',5,'2011-10-01 00:00:00'),
-(109,1,'Chubfish & Exhale',0,'2011-12-01 00:00:00'),
-(110,1,'Tyronis & mr.bob806',15,'2011-10-01 00:00:00'),
-(110,1,'Schlepian & Chubfish',6,'2011-11-01 00:00:00'),
-(110,1,'00svo & z1mb0bw4y',5,'2012-08-08 00:00:00'),
-(110,1,'00svo & z1mb0bw4y',4,'2012-08-10 00:00:00'),
-(110,1,'Klooger & z1mb0bw4y',2,'2014-02-01 00:00:00'),
-(110,1,'DM_ & follon',0,'2015-04-01 00:00:00');
\ No newline at end of file
+(102,1,'dawn & takz',3,'2011-11-18'),
+(102,1,'Chubfish & Exhale',2,'2012-01-01'),
+(102,1,'Imanex & Klooger',0,'2013-08-01'),
+(103,1,'Schlepian & Lemonsunshine',0,'2011-10-01'),
+(104,1,'Schlepian & Lemonsunshine',0,'2011-10-01'),
+(105,1,'Blaizerazer & ?',8,'2011-10-01'),
+(105,1,'Schlepian & Lemonsunshine',5,'2011-11-01'),
+(105,1,'Imanex & Klooger',4,'2013-08-01'),
+(105,1,'DM_ & wS',3,'2014-05-01'),
+(105,1,'DM_ & follon',2,'2015-04-01'),
+(106,1,'Schlepian & Bananasaurus Rex',4,'2011-10-01'),
+(106,1,'Gig & takz',3,'2012-06-01'),
+(106,1,'Imanex & Klooger',0,'2013-06-01'),
+(107,1,'Chubfish & Exhale',2,'2011-10-01'),
+(107,1,'DM_ & follon',0,'2015-04-01'),
+(108,1,'DaFox & P',0,'2011-12-01'),
+(109,1,'Schlepian & Tyronis',5,'2011-10-01'),
+(109,1,'Chubfish & Exhale',0,'2011-12-01'),
+(110,1,'Tyronis & mr.bob806',15,'2011-10-01'),
+(110,1,'Schlepian & Chubfish',6,'2011-11-01'),
+(110,1,'00svo & z1mb0bw4y',5,'2012-08-08'),
+(110,1,'00svo & z1mb0bw4y',4,'2012-08-10'),
+(110,1,'Klooger & z1mb0bw4y',2,'2014-02-01'),
+(110,1,'DM_ & follon',0,'2015-04-01');
\ No newline at end of file
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 50e7c15..11d4944 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -59,7 +59,7 @@ CREATE TABLE map_history (
   category_id SMALLINT NOT NULL,
   user_name TEXT NOT NULL,
   score_count SMALLINT NOT NULL,
-  record_date TIMESTAMP NOT NULL,
+  record_date DATE NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (category_id) REFERENCES categories(id),
   FOREIGN KEY (map_id) REFERENCES maps(id),
-- 
cgit v1.2.3