From 69e15976e42ef404f5b0857e0ca2ea3bb8e6159b Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 31 Oct 2024 22:54:28 +0300
Subject: database: organize sql files

---
 backend/database/categories.sql        |  15 -
 backend/database/chapters.sql          |  17 -
 backend/database/countries.sql         | 252 ----------
 backend/database/games.sql             |   3 -
 backend/database/history.sql           | 840 ---------------------------------
 backend/database/init.sql              |   4 +-
 backend/database/insert/categories.sql |  15 +
 backend/database/insert/chapters.sql   |  17 +
 backend/database/insert/countries.sql  | 252 ++++++++++
 backend/database/insert/games.sql      |   3 +
 backend/database/insert/history.sql    | 840 +++++++++++++++++++++++++++++++++
 backend/database/insert/maps.sql       | 129 +++++
 backend/database/maps.sql              | 129 -----
 13 files changed, 1258 insertions(+), 1258 deletions(-)
 delete mode 100644 backend/database/categories.sql
 delete mode 100644 backend/database/chapters.sql
 delete mode 100644 backend/database/countries.sql
 delete mode 100644 backend/database/games.sql
 delete mode 100644 backend/database/history.sql
 create mode 100644 backend/database/insert/categories.sql
 create mode 100644 backend/database/insert/chapters.sql
 create mode 100644 backend/database/insert/countries.sql
 create mode 100644 backend/database/insert/games.sql
 create mode 100644 backend/database/insert/history.sql
 create mode 100644 backend/database/insert/maps.sql
 delete mode 100644 backend/database/maps.sql

diff --git a/backend/database/categories.sql b/backend/database/categories.sql
deleted file mode 100644
index 6bbf9b0..0000000
--- a/backend/database/categories.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-INSERT INTO categories(id, name) VALUES
-(1, 'CM'),
-(2, 'No SLA'),
-(3, 'Inbounds SLA'),
-(4, 'Any%'),
-(5, 'All Courses');
-
-INSERT INTO game_categories(id, game_id, category_id) VALUES
-(1, 1, 1),
-(2, 1, 2),
-(3, 1, 3),
-(4, 1, 4),
-(5, 2, 1),
-(6, 2, 4),
-(7, 2, 5);
\ No newline at end of file
diff --git a/backend/database/chapters.sql b/backend/database/chapters.sql
deleted file mode 100644
index f61d5bf..0000000
--- a/backend/database/chapters.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-INSERT INTO chapters(id, game_id, name, is_disabled) VALUES
-(1, 1, 'Chapter 1 - The Coutesy Call', false),
-(2, 1, 'Chapter 2 - The Cold Boot', false),
-(3, 1, 'Chapter 3 - The Return', false),
-(4, 1, 'Chapter 4 - The Surprise', false),
-(5, 1, 'Chapter 5 - The Escape', false),
-(6, 1, 'Chapter 6 - The Fall', false),
-(7, 1, 'Chapter 7 - The Reunion', false),
-(8, 1, 'Chapter 8 - The Itch', false),
-(9, 1, 'Chapter 9 - The Part Where He Kills You', false),
-(10, 2, 'Course 0 - Introduction', true),
-(11, 2, 'Course 1 - Team Building', false),
-(12, 2, 'Course 2 - Mass And Velocity', false),
-(13, 2, 'Course 3 - Hard-Light Surfaces', false),
-(14, 2, 'Course 4 - Excursion Funnels', false),
-(15, 2, 'Course 5 - Mobility Gels', false),
-(16, 2, 'Course 6 - Art Therapy', false);
\ No newline at end of file
diff --git a/backend/database/countries.sql b/backend/database/countries.sql
deleted file mode 100644
index 0272f6f..0000000
--- a/backend/database/countries.sql
+++ /dev/null
@@ -1,252 +0,0 @@
-INSERT INTO countries (country_code, country_name) VALUES
-('AF', 'AFGHANISTAN'),
-('AL', 'ALBANIA'),
-('DZ', 'ALGERIA'),
-('AS', 'AMERICAN SAMOA'),
-('AD', 'ANDORRA'),
-('AO', 'ANGOLA'),
-('AI', 'ANGUILLA'),
-('AQ', 'ANTARCTICA'),
-('AG', 'ANTIGUA AND BARBUDA'),
-('AR', 'ARGENTINA'),
-('AM', 'ARMENIA'),
-('AW', 'ARUBA'),
-('AU', 'AUSTRALIA'),
-('AT', 'AUSTRIA'),
-('AZ', 'AZERBAIJAN'),
-('BS', 'BAHAMAS'),
-('BH', 'BAHRAIN'),
-('BD', 'BANGLADESH'),
-('BB', 'BARBADOS'),
-('BY', 'BELARUS'),
-('BE', 'BELGIUM'),
-('BZ', 'BELIZE'),
-('BJ', 'BENIN'),
-('BM', 'BERMUDA'),
-('BT', 'BHUTAN'),
-('BO', 'BOLIVIA'),
-('BA', 'BOSNIA AND HERZEGOVINA'),
-('BW', 'BOTSWANA'),
-('BV', 'BOUVET ISLAND'),
-('BR', 'BRAZIL'),
-('IO', 'BRITISH INDIAN OCEAN TERRITORY'),
-('BN', 'BRUNEI DARUSSALAM'),
-('BG', 'BULGARIA'),
-('BF', 'BURKINA FASO'),
-('BI', 'BURUNDI'),
-('KH', 'CAMBODIA'),
-('CM', 'CAMEROON'),
-('CA', 'CANADA'),
-('CV', 'CAPE VERDE'),
-('KY', 'CAYMAN ISLANDS'),
-('CF', 'CENTRAL AFRICAN REPUBLIC'),
-('TD', 'CHAD'),
-('CL', 'CHILE'),
-('CN', 'CHINA'),
-('CX', 'CHRISTMAS ISLAND'),
-('CC', 'COCOS (KEELING) ISLANDS'),
-('CO', 'COLOMBIA'),
-('KM', 'COMOROS'),
-('CG', 'CONGO'),
-('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE'),
-('CK', 'COOK ISLANDS'),
-('CR', 'COSTA RICA'),
-('CI', 'COTE D''IVOIRE'),
-('HR', 'CROATIA'),
-('CU', 'CUBA'),
-('CY', 'CYPRUS'),
-('CZ', 'CZECHIA'),
-('DK', 'DENMARK'),
-('DJ', 'DJIBOUTI'),
-('DM', 'DOMINICA'),
-('DO', 'DOMINICAN REPUBLIC'),
-('EC', 'ECUADOR'),
-('EG', 'EGYPT'),
-('SV', 'EL SALVADOR'),
-('GQ', 'EQUATORIAL GUINEA'),
-('ER', 'ERITREA'),
-('EE', 'ESTONIA'),
-('ET', 'ETHIOPIA'),
-('FK', 'FALKLAND ISLANDS (MALVINAS)'),
-('FO', 'FAROE ISLANDS'),
-('FJ', 'FIJI'),
-('FI', 'FINLAND'),
-('FR', 'FRANCE'),
-('GF', 'FRENCH GUIANA'),
-('PF', 'FRENCH POLYNESIA'),
-('TF', 'FRENCH SOUTHERN TERRITORIES'),
-('GA', 'GABON'),
-('GM', 'GAMBIA'),
-('GE', 'GEORGIA'),
-('DE', 'GERMANY'),
-('GH', 'GHANA'),
-('GI', 'GIBRALTAR'),
-('GR', 'GREECE'),
-('GL', 'GREENLAND'),
-('GD', 'GRENADA'),
-('GP', 'GUADELOUPE'),
-('GU', 'GUAM'),
-('GT', 'GUATEMALA'),
-('GN', 'GUINEA'),
-('GW', 'GUINEA-BISSAU'),
-('GY', 'GUYANA'),
-('HT', 'HAITI'),
-('HM', 'HEARD ISLAND AND MCDONALD ISLANDS'),
-('VA', 'VATICAN CITY STATE'),
-('HN', 'HONDURAS'),
-('HK', 'HONG KONG'),
-('HU', 'HUNGARY'),
-('IS', 'ICELAND'),
-('IN', 'INDIA'),
-('ID', 'INDONESIA'),
-('IR', 'IRAN'),
-('IQ', 'IRAQ'),
-('IE', 'IRELAND'),
-('IL', 'ISRAEL'),
-('IT', 'ITALY'),
-('JM', 'JAMAICA'),
-('JP', 'JAPAN'),
-('JO', 'JORDAN'),
-('KZ', 'KAZAKHSTAN'),
-('KE', 'KENYA'),
-('KI', 'KIRIBATI'),
-('KP', 'NORTH KOREA'),
-('KR', 'SOUTH KOREA'),
-('KW', 'KUWAIT'),
-('KG', 'KYRGYZSTAN'),
-('LA', 'LAO'),
-('LV', 'LATVIA'),
-('LB', 'LEBANON'),
-('LS', 'LESOTHO'),
-('LR', 'LIBERIA'),
-('LY', 'LIBYAN ARAB JAMAHIRIYA'),
-('LI', 'LIECHTENSTEIN'),
-('LT', 'LITHUANIA'),
-('LU', 'LUXEMBOURG'),
-('MO', 'MACAO'),
-('MK', 'NORTH MACEDONIA'),
-('MG', 'MADAGASCAR'),
-('MW', 'MALAWI'),
-('MY', 'MALAYSIA'),
-('MV', 'MALDIVES'),
-('ML', 'MALI'),
-('MT', 'MALTA'),
-('MH', 'MARSHALL ISLANDS'),
-('MQ', 'MARTINIQUE'),
-('MR', 'MAURITANIA'),
-('MU', 'MAURITIUS'),
-('YT', 'MAYOTTE'),
-('MX', 'MEXICO'),
-('FM', 'MICRONESIA'),
-('MD', 'MOLDOVA'),
-('MC', 'MONACO'),
-('MN', 'MONGOLIA'),
-('MS', 'MONTSERRAT'),
-('MA', 'MOROCCO'),
-('MZ', 'MOZAMBIQUE'),
-('MM', 'MYANMAR'),
-('NA', 'NAMIBIA'),
-('NR', 'NAURU'),
-('NP', 'NEPAL'),
-('NL', 'NETHERLANDS'),
-('AN', 'NETHERLANDS ANTILLES'),
-('NC', 'NEW CALEDONIA'),
-('NZ', 'NEW ZEALAND'),
-('NI', 'NICARAGUA'),
-('NE', 'NIGER'),
-('NG', 'NIGERIA'),
-('NU', 'NIUE'),
-('NF', 'NORFOLK ISLAND'),
-('MP', 'NORTHERN MARIANA ISLANDS'),
-('NO', 'NORWAY'),
-('OM', 'OMAN'),
-('PK', 'PAKISTAN'),
-('PW', 'PALAU'),
-('PS', 'PALESTINE'),
-('PA', 'PANAMA'),
-('PG', 'PAPUA NEW GUINEA'),
-('PY', 'PARAGUAY'),
-('PE', 'PERU'),
-('PH', 'PHILIPPINES'),
-('PN', 'PITCAIRN'),
-('PL', 'POLAND'),
-('PT', 'PORTUGAL'),
-('PR', 'PUERTO RICO'),
-('QA', 'QATAR'),
-('RE', 'REUNION'),
-('RO', 'ROMANIA'),
-('RU', 'RUSSIAN FEDERATION'),
-('RW', 'RWANDA'),
-('SH', 'SAINT HELENA'),
-('KN', 'SAINT KITTS AND NEVIS'),
-('LC', 'SAINT LUCIA'),
-('PM', 'SAINT PIERRE AND MIQUELON'),
-('VC', 'SAINT VINCENT AND THE GRENADINES'),
-('WS', 'SAMOA'),
-('SM', 'SAN MARINO'),
-('ST', 'SAO TOME AND PRINCIPE'),
-('SA', 'SAUDI ARABIA'),
-('SN', 'SENEGAL'),
-('RS', 'SERBIA'),
-('SC', 'SEYCHELLES'),
-('SL', 'SIERRA LEONE'),
-('SG', 'SINGAPORE'),
-('SK', 'SLOVAKIA'),
-('SI', 'SLOVENIA'),
-('SB', 'SOLOMON ISLANDS'),
-('SO', 'SOMALIA'),
-('ZA', 'SOUTH AFRICA'),
-('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS'),
-('ES', 'SPAIN'),
-('LK', 'SRI LANKA'),
-('SD', 'SUDAN'),
-('SR', 'SURINAME'),
-('SJ', 'SVALBARD AND JAN MAYEN'),
-('SZ', 'SWAZILAND'),
-('SE', 'SWEDEN'),
-('CH', 'SWITZERLAND'),
-('SY', 'SYRIAN ARAB REPUBLIC'),
-('TW', 'TAIWAN'),
-('TJ', 'TAJIKISTAN'),
-('TZ', 'TANZANIA'),
-('TH', 'THAILAND'),
-('TL', 'TIMOR-LESTE'),
-('TG', 'TOGO'),
-('TK', 'TOKELAU'),
-('TO', 'TONGA'),
-('TT', 'TRINIDAD AND TOBAGO'),
-('TN', 'TUNISIA'),
-('TR', 'TURKEY'),
-('TM', 'TURKMENISTAN'),
-('TC', 'TURKS AND CAICOS ISLANDS'),
-('TV', 'TUVALU'),
-('UG', 'UGANDA'),
-('UA', 'UKRAINE'),
-('AE', 'UNITED ARAB EMIRATES'),
-('GB', 'UNITED KINGDOM'),
-('US', 'UNITED STATES'),
-('UM', 'UNITED STATES MINOR OUTLYING ISLANDS'),
-('UY', 'URUGUAY'),
-('UZ', 'UZBEKISTAN'),
-('VU', 'VANUATU'),
-('VE', 'VENEZUELA'),
-('VN', 'VIET NAM'),
-('VG', 'VIRGIN ISLANDS, BRITISH'),
-('VI', 'VIRGIN ISLANDS, U.S.'),
-('WF', 'WALLIS AND FUTUNA'),
-('EH', 'WESTERN SAHARA'),
-('YE', 'YEMEN'),
-('ZM', 'ZAMBIA'),
-('ZW', 'ZIMBABWE'),
-('ME', 'MONTENEGRO'),
-('XK', 'KOSOVO'),
-('AX', 'ALAND ISLANDS'),
-('BQ', 'BONAIRE'),
-('CW', 'CURACAO'),
-('GG', 'GUERNSEY'),
-('IM', 'ISLE OF MAN'),
-('JE', 'JERSEY'),
-('BL', 'SAINT BARTHELEMY'),
-('MF', 'SAINT MARTIN'),
-('SX', 'SINT MAARTEN'),
-('SS', 'SOUTH SUDAN');
\ No newline at end of file
diff --git a/backend/database/games.sql b/backend/database/games.sql
deleted file mode 100644
index 0c2374c..0000000
--- a/backend/database/games.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-INSERT INTO games(id, name, is_coop) VALUES
-(1, 'Portal 2 - Singleplayer', false),
-(2, 'Portal 2 - Cooperative', true);
\ No newline at end of file
diff --git a/backend/database/history.sql b/backend/database/history.sql
deleted file mode 100644
index 34fddcb..0000000
--- a/backend/database/history.sql
+++ /dev/null
@@ -1,840 +0,0 @@
-INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VALUES
--- Portal 2 Singleplayer
--- Chapter 1
-(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'),
-(7,1,'Tyronis',0,'2013-01-11'),
-(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'),
-
-(3,2,'slmid1995',3,'2011-10-05'),
-(3,2,'LookLikeAKango',1,'2011-10-06'),
-(3,2,'Bananasaurus Rex',0,'2011-10-24'),
-(4,2,'Tyronis',1,'2011-10-05'),
-(4,2,'Krzyhau',0,'2019-05-10'),
-(5,2,'LookLikeAKango',2,'2011-10-05'),
-(5,2,'JesusCatFace',1,'2013-04-01'),
-(6,2,'Stimich',4,'2011-10-08'),
-(6,2,'aepaePolakrn',3,'2011-10-19'),
-(6,2,'Krzyhau',2,'2020-10-10'),
-(7,2,'Tyronis',0,'2013-01-11'),
-(9,2,'slmid1995',4,'2011-10-05'),
-(9,2,'Jokie',3,'2011-10-05'),
-(9,2,'Tyronis',2,'2011-11-02'),
-(9,2,'sicklebrick',0,'2013-03-13'),
-
-(3,3,'slmid1995',3,'2011-10-05'),
-(3,3,'LookLikeAKango',1,'2011-10-06'),
-(3,3,'Bananasaurus Rex',0,'2011-10-24'),
-(4,3,'Tyronis',1,'2011-10-05'),
-(4,3,'Krzyhau',0,'2019-05-10'),
-(5,3,'LookLikeAKango',2,'2011-10-05'),
-(5,3,'JesusCatFace',1,'2013-04-01'),
-(6,3,'Stimich',4,'2011-10-08'),
-(6,3,'aepaePolakrn',3,'2011-10-19'),
-(6,3,'Krzyhau',1,'2017-07-29'),
-(7,3,'Tyronis',0,'2013-01-11'),
-(9,3,'slmid1995',4,'2011-10-05'),
-(9,3,'Jokie',3,'2011-10-05'),
-(9,3,'Tyronis',2,'2011-11-02'),
-(9,3,'sicklebrick',0,'2013-03-13'),
-
-(3,4,'Krzyhau',0,'2018-01-11'),
-(4,4,'Krzyhau',0,'2018-01-11'),
-(5,4,'Krzyhau',0,'2018-01-11'),
-(6,4,'Krzyhau',0,'2018-01-11'),
-(9,4,'sicklebrick',0,'2013-03-13'),
-
--- Chapter 2
-(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'),
-(14,0,'?',0,'2011-04-19'),
-(15,1,'Tyronis',2,'2011-10-05'),
-(15,1,'SuperAiderton',0,'2024-01-28'),
-(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'),
-
-(10,2,'Paraxade0',2,'2011-04-21'),
-(10,2,'PerOculos',0,'2014-08-23'),
-(11,2,'Tyronis',2,'2011-10-05'),
-(11,2,'Krzyhau',0,'2018-06-06'),
-(12,2,'slmid1995',2,'2011-10-04'),
-(13,2,'MPRS',3,'2011-05-04'),
-(13,2,'Imanex',2,'2011-12-08'),
-(13,2,'jyjey',0,'2012-08-22'),
-(15,2,'Tyronis',2,'2011-10-05'),
-(15,2,'Nidboj132',0,'2022-11-07'),
-(16,2,'LookLikeAKango',2,'2011-10-05'),
-(16,2,'jyjey',0,'2012-08-25'),
-(17,2,'rocoty',2,'2011-10-05'),
-(17,2,'Nidboj132',0,'2023-02-05'),
-
-(10,3,'Paraxade0',2,'2011-04-21'),
-(10,3,'PerOculos',0,'2014-08-23'),
-(11,3,'Tyronis',2,'2011-10-05'),
-(11,3,'Krzyhau',0,'2018-06-06'),
-(12,3,'slmid1995',2,'2011-10-04'),
-(12,3,'Krzyhau',0,'2018-08-08'),
-(13,3,'MPRS',3,'2011-05-04'),
-(13,3,'Imanex',2,'2011-12-08'),
-(13,3,'jyjey',0,'2012-08-22'),
-(15,3,'Tyronis',2,'2011-10-05'),
-(15,3,'Nidboj132',0,'2021-02-01'),
-(16,3,'LookLikeAKango',2,'2011-10-05'),
-(16,3,'jyjey',0,'2012-08-25'),
-(17,3,'rocoty',2,'2011-10-05'),
-(17,3,'Nidboj132',0,'2023-02-05'),
-
-(10,4,'PerOculos',0,'2014-08-23'),
-(11,4,'Krzyhau',0,'2018-01-11'),
-(12,4,'Krzyhau',0,'2018-01-11'),
-(13,4,'Krzyhau',0,'2018-01-11'),
-(15,4,'Krzyhau',0,'2018-01-11'),
-(16,4,'Krzyhau',0,'2018-01-11'),
-(17,4,'Krzyhau',0,'2018-01-11'),
-
--- Chapter 3
-(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'),
-
-(18,2,'The Last Tofus',5,'2011-05-08'),
-(18,2,'Schlepian',4,'2011-10-08'),
-(18,2,'szeimartin',3,'2013-04-19'),
-(18,2,'Krzyhau',2,'2020-05-15'),
-(18,2,'Krzyhau',0,'2022-07-02'),
-(19,2,'LookLikeAKango',2,'2011-10-06'),
-(20,2,'Djinndrache',5,'2011-10-20'),
-(20,2,'Schlepian',4,'2011-10-30'),
-(20,2,'Jetwash',3,'2014-09-04'),
-(20,2,'Krzyhau',2,'2020-02-17'),
-(21,2,'LookLikeAKango',4,'2011-10-06'),
-(21,2,'Schlepian',2,'2011-10-29'),
-(21,2,'PerOculos',0,'2019-04-06'),
-(22,2,'Tyronis',0,'2011-10-05'),
-(23,2,'LookLikeAKango',2,'2011-10-06'),
-(23,2,'Krzyhau',0,'2018-08-01'),
-(24,2,'LeviHB',0,'2011-04-30'),
-(25,2,'LeviHB',0,'2011-05-01'),
-(26,2,'Schlepian',3,'2011-10-30'),
-(26,2,'Tyronis',2,'2012-01-08'),
-(26,2,'PerOculos',0,'2016-06-08'),
-
-(18,3,'The Last Tofus',5,'2011-05-08'),
-(18,3,'Schlepian',4,'2011-10-08'),
-(18,3,'szeimartin',3,'2013-04-19'),
-(18,3,'Krzyhau',2,'2020-05-15'),
-(18,3,'Krzyhau',0,'2022-07-02'),
-(19,3,'LookLikeAKango',2,'2011-10-06'),
-(20,3,'Djinndrache',5,'2011-10-20'),
-(20,3,'Schlepian',4,'2011-10-30'),
-(20,3,'Jetwash',3,'2014-09-04'),
-(20,3,'Krzyhau',2,'2020-02-17'),
-(21,3,'LookLikeAKango',4,'2011-10-06'),
-(21,3,'Schlepian',2,'2011-10-29'),
-(21,3,'Krzyhau',0,'2018-08-10'),
-(22,3,'Tyronis',0,'2011-10-05'),
-(23,3,'LookLikeAKango',2,'2011-10-06'),
-(23,3,'Krzyhau',0,'2018-04-06'),
-(24,3,'LeviHB',0,'2011-04-30'),
-(25,3,'LeviHB',0,'2011-05-01'),
-(26,3,'Schlepian',3,'2011-10-30'),
-(26,3,'Tyronis',2,'2012-01-08'),
-(26,3,'PerOculos',0,'2016-06-08'),
-
-(18,4,'Krzyhau',0,'2018-01-11'),
-(19,4,'Krzyhau',0,'2018-01-11'),
-(20,4,'Krzyhau',0,'2018-01-11'),
-(21,4,'Krzyhau',0,'2018-01-11'),
-(22,4,'Krzyhau',0,'2018-01-21'),
-(23,4,'Krzyhau',0,'2018-01-11'),
-(24,4,'Krzyhau',0,'2018-01-11'),
-(25,4,'Krzyhau',0,'2018-01-11'),
-(26,4,'Krzyhau',0,'2018-01-11'),
-
--- Chapter 4
-(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'),
-
-(27,2,'LeviHB',2,'2011-05-01'),
-(27,2,'PerOculos',0,'2020-07-13'),
-(28,2,'LeviHB',7,'2011-05-01'),
-(28,2,'SpinDizzy',5,'2011-05-03'),
-(28,2,'SpinDizzy',4,'2011-05-06'),
-(28,2,'Andy M.J.',2,'2011-10-07'),
-(28,2,'Krzyhau',0,'2018-05-19'),
-(29,2,'LeviHB',0,'2011-05-01'),
-(30,2,'Schlepian',2,'2011-10-30'),
-(31,2,'Tyronis',0,'2011-10-06'),
-
-(27,3,'LeviHB',2,'2011-05-01'),
-(27,3,'PerOculos',0,'2020-07-13'),
-(28,3,'LeviHB',7,'2011-05-01'),
-(28,3,'SpinDizzy',5,'2011-05-03'),
-(28,3,'SpinDizzy',4,'2011-05-06'),
-(28,3,'Andy M.J.',2,'2011-10-07'),
-(28,3,'Krzyhau',0,'2018-05-19'),
-(29,3,'LeviHB',0,'2011-05-01'),
-(30,3,'Schlepian',2,'2011-10-30'),
-(31,3,'Tyronis',0,'2011-10-06'),
-
-(27,4,'Krzyhau',0,'2018-01-11'),
-(28,4,'Krzyhau',0,'2018-01-11'),
-(29,4,'Krzyhau',0,'2018-01-11'),
-(30,4,'Krzyhau',0,'2018-01-11'),
-(31,4,'Krzyhau',0,'2018-01-11'),
-
--- Chapter 5
-(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'),
-
-(32,2,'Tyronis',6,'2011-10-21'),
-(32,2,'Nidboj132',5,'2022-04-24'),
-(32,2,'Fridge',3,'2023-06-18'),
-(33,2,'Tyronis',7,'2011-10-06'),
-(33,2,'ISimmo',5,'2011-11-02'),
-(33,2,'PerOculos',4,'2017-05-30'),
-(34,2,'Schlepian',3,'2011-11-01'),
-(34,2,'Krzyhau',2,'2020-10-14'),
-(34,2,'Krzyhau + Nidboj132',0,'2021-03-14'),
-(35,2,'Krank',2,'2012-07-28'),
-
-(32,3,'Tyronis',6,'2011-10-21'),
-(32,3,'Krzyhau',4,'2018-08-07'),
-(32,3,'Nidboj132',3,'2022-04-24'),
-(33,3,'Tyronis',7,'2011-10-06'),
-(33,3,'ISimmo',5,'2011-11-02'),
-(33,3,'PerOculos',4,'2017-05-30'),
-(34,3,'Schlepian',3,'2011-11-01'),
-(34,3,'Krzyhau',2,'2020-07-09'),
-(34,3,'Krzyhau + Nidboj132',0,'2021-03-14'),
-(35,3,'Krank',2,'2012-07-28'),
-
-(32,4,'Krzyhau',0,'2021-02-09'),
-(33,4,'PerOculos',4,'2017-05-30'),
-(33,4,'Krzyhau',0,'2020-12-26'),
-(34,4,'Krzyhau',0,'2017-09-27'),
-(35,4,'Krank',2,'2012-07-28'),
-
--- Chapter 6
-(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'),
-
-(36,2,'Tyronis',6,'2011-10-06'),
-(36,2,'CalmlyFrenetic',5,'2011-10-09'),
-(36,2,'sicklebrick',4,'2012-09-13'),
-(36,2,'Nidboj132',2,'2023-03-04'),
-(37,2,'LookLikeAKango',7,'2011-10-06'),
-(37,2,'Schlepian',6,'2011-11-01'),
-(37,2,'Tyronis',5,'2012-01-28'),
-(37,2,'Nidboj132',4,'2021-08-22'),
-(38,2,'Andy M.J.',2,'2011-10-06'),
-(38,2,'Death Pony',0,'2011-11-12'),
-(39,2,'Lambda Core',6,'2011-05-13'),
-(39,2,'The Last Tofus',5,'2011-05-13'),
-(39,2,'LookLikeAKango',4,'2011-10-16'),
-(39,2,'Kittaye',3,'2013-03-25'),
-(40,2,'LookLikeAKango',7,'2011-10-07'),
-(40,2,'Schlepian',6,'2011-11-05'),
-(40,2,'Kittaye',4,'2013-04-01'),
-(40,2,'Kittaye',3,'2014-09-13'),
-(40,2,'szeimartin',2,'2014-09-13'),
-(40,2,'Kittaye',0,'2014-09-15'),
-(41,2,'CalmlyFrenetic',7,'2011-10-09'),
-(41,2,'Jaso',6,'2011-10-11'),
-(41,2,'Krank',5,'2012-07-17'),
-
-(36,3,'Tyronis',6,'2011-10-06'),
-(36,3,'CalmlyFrenetic',5,'2011-10-09'),
-(36,3,'sicklebrick',4,'2012-09-13'),
-(36,3,'Krzyhau',2,'2022-07-20'),
-(36,3,'Nidboj132',0,'2023-03-04'),
-(37,3,'LookLikeAKango',7,'2011-10-06'),
-(37,3,'Schlepian',6,'2011-11-01'),
-(37,3,'Tyronis',5,'2012-01-28'),
-(37,3,'?',4,'2021-08-22'),
-(37,3,'zach',2,'2022-10-17'),
-(38,3,'Andy M.J.',2,'2011-10-06'),
-(38,3,'Death Pony',0,'2011-11-12'),
-(39,3,'Lambda Core',6,'2011-05-13'),
-(39,3,'The Last Tofus',5,'2011-05-13'),
-(39,3,'LookLikeAKango',4,'2011-10-16'),
-(39,3,'Kittaye',3,'2013-03-25'),
-(40,3,'LookLikeAKango',7,'2011-10-07'),
-(40,3,'Schlepian',6,'2011-11-05'),
-(40,3,'Kittaye',4,'2013-04-01'),
-(40,3,'Kittaye',3,'2014-09-13'),
-(40,3,'szeimartin',2,'2014-09-13'),
-(40,3,'Kittaye',0,'2014-09-15'),
-(41,3,'CalmlyFrenetic',7,'2011-10-09'),
-(41,3,'Jaso',6,'2011-10-11'),
-(41,3,'Krank',5,'2012-07-17'),
-
-(36,4,'Krzyhau',2,'2022-07-20'),
-(36,4,'Nidboj132',0,'2023-03-04'),
-(37,4,'Tyronis',5,'2012-01-28'),
-(37,4,'Krzyhau',0,'2020-12-26'),
-(38,4,'Death Pony',0,'2011-11-12'),
-(39,4,'Kittaye',3,'2013-03-25'),
-(39,4,'Krzyhau',0,'2020-12-26'),
-(40,4,'Kittaye',0,'2014-09-15'),
-(41,4,'Krank',5,'2012-07-17'),
-(41,4,'Krzyhau',0,'2020-12-26'),
-
--- Chapter 7
-(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'),
-
-(42,2,'LookLikeAKango',4,'2011-05-17'),
-(42,2,'Schlepian',2,'2011-11-06'),
-(43,2,'lmao4ever',5,'2011-10-30'),
-(43,2,'Jaso',2,'2011-11-09'),
-(43,2,'feliser',0,'2022-06-26'),
-(44,2,'LookLikeAKango',18,'2011-10-07'),
-(44,2,'Tyronis',13,'2011-10-30'),
-(44,2,'Tyronis',12,'2011-11-10'),
-(44,2,'Jetwash',11,'2017-06-12'),
-(44,2,'Krzyhau',9,'2022-01-02'),
-(45,2,'LookLikeAKango',23,'2011-10-08'),
-(45,2,'CalmlyFrenetic',22,'2011-10-09'),
-(45,2,'cgreactor',17,'2011-10-09'),
-(45,2,'CalmlyFrenetic',16,'2011-10-10'),
-(45,2,'LookLikeAKango',15,'2011-10-19'),
-(45,2,'Jaso',12,'2012-07-19'),
-(45,2,'Krank',10,'2013-01-31'),
-(45,2,'Kittaye',7,'2013-04-04'),
-(45,2,'PerOculos',4,'2014-09-13'),
-
-(42,3,'LookLikeAKango',4,'2011-05-17'),
-(42,3,'Schlepian',2,'2011-11-06'),
-(43,3,'lmao4ever',5,'2011-10-30'),
-(43,3,'Jaso',2,'2011-11-09'),
-(43,3,'feliser',0,'2022-06-26'),
-(44,3,'LookLikeAKango',18,'2011-10-07'),
-(44,3,'Tyronis',13,'2011-10-30'),
-(44,3,'Tyronis',12,'2011-11-10'),
-(44,3,'Jetwash',11,'2017-06-12'),
-(44,3,'Krzyhau',9,'2022-01-02'),
-(45,3,'LookLikeAKango',23,'2011-10-08'),
-(45,3,'CalmlyFrenetic',22,'2011-10-09'),
-(45,3,'cgreactor',17,'2011-10-09'),
-(45,3,'CalmlyFrenetic',16,'2011-10-10'),
-(45,3,'LookLikeAKango',15,'2011-10-19'),
-(45,3,'Jaso',12,'2012-07-19'),
-(45,3,'Krank',10,'2013-01-31'),
-(45,3,'Kittaye',7,'2013-04-04'),
-(45,3,'PerOculos',4,'2014-09-13'),
-(45,3,'Fridge',3,'2023-08-19'),
-
-(42,4,'Schlepian',2,'2011-11-06'),
-(42,4,'Krzyhau',0,'2020-12-26'),
-(43,4,'Krzyhau',0,'2020-12-26'),
-(44,4,'Jetwash',11,'2017-06-12'),
-(44,4,'Nidboj',0,'2020-12-27'),
-(45,4,'PerOculos',4,'2014-09-13'),
-(45,4,'Krzyhau',0,'2020-12-27'),
-
--- Chapter 8
-(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'),
-
-(46,2,'Fapmid',6,'2011-05-29'),
-(46,2,'Krzyhau',2,'2019-11-21'),
-(47,2,'mprs',2,'2011-05-03'),
-(47,2,'JesusCatFace',0,'2015-01-16'),
-(48,2,'LookLikeAKango',5,'2011-10-08'),
-(48,2,'Tyronis',2,'2011-10-08'),
-(48,2,'Krank (most likely)',0,'2011-10-08'),
-(49,2,'9E161D40',3,'2011-05-06'),
-(49,2,'Schlepian',2,'2011-10-08'),
-(49,2,'Krank (most likely)',0,'2011-10-08'),
-(50,2,'LookLikeAKango',4,'2011-10-08'),
-(50,2,'Tyronis',2,'2011-10-11'),
-(50,2,'Krank (most likely)',0,'2011-10-11'),
-(51,2,'Andy M.J.',3,'2011-10-08'),
-(51,2,'LookLikeAKango',2,'2011-10-20'),
-(51,2,'Krank (most likely)',0,'2011-10-20'),
-(52,2,'SpinDizzy',3,'2011-05-02'),
-(52,2,'Krank (most likely)',0,'2011-05-02'),
-(53,2,'LookLikeAKango',9,'2011-10-08'),
-(53,2,'LookLikeAKango',2,'2011-10-20'),
-(53,2,'Krank',0,'2012-08-19'),
-(54,2,'LookLikeAKango',7,'2011-06-01'),
-(54,2,'Jaso',6,'2011-10-09'),
-(54,2,'Schlepian',5,'2011-11-06'),
-(54,2,'Spyrunite',4,'2012-08-30'),
-(54,2,'Krank (most likely)',2,'2012-08-30'),
-(54,2,'Krzyhau + Nidboj',0,'2018-08-01'),
-(55,2,'LookLikeAKango',7,'2011-10-08'),
-(55,2,'CalmlyFrenetic',3,'2011-10-09'),
-(55,2,'Jaso',2,'2011-11-26'),
-(55,2,'Krank (most likely)',0,'2011-11-26'),
-(56,2,'lihP',6,'2011-05-07'),
-(56,2,'LookLikeAKango',5,'2011-10-09'),
-(56,2,'CalmlyFrenetic',4,'2011-10-09'),
-(56,2,'Jetwash',2,'2014-09-05'),
-(56,2,'Krank (most likely)',0,'2014-09-05'),
-
-(46,3,'Fapmid',6,'2011-05-29'),
-(46,3,'Krzyhau',2,'2017-11-02'),
-(47,3,'mprs',2,'2011-05-03'),
-(47,3,'JesusCatFace',0,'2015-01-16'),
-(48,3,'LookLikeAKango',5,'2011-10-08'),
-(48,3,'Tyronis',2,'2011-10-08'),
-(48,3,'Krank (most likely)',0,'2011-10-08'),
-(49,3,'9E161D40',3,'2011-05-06'),
-(49,3,'Schlepian',2,'2011-10-08'),
-(49,3,'Krank (most likely)',0,'2011-10-08'),
-(50,3,'LookLikeAKango',4,'2011-10-08'),
-(50,3,'Tyronis',2,'2011-10-11'),
-(50,3,'Krank (most likely)',0,'2011-10-11'),
-(51,3,'Andy M.J.',3,'2011-10-08'),
-(51,3,'LookLikeAKango',2,'2011-10-20'),
-(51,3,'Krank (most likely)',0,'2011-10-20'),
-(52,3,'SpinDizzy',3,'2011-05-02'),
-(52,3,'Krank (most likely)',0,'2011-05-02'),
-(53,3,'LookLikeAKango',9,'2011-10-08'),
-(53,3,'LookLikeAKango',2,'2011-10-20'),
-(53,3,'Krank',0,'2012-08-19'),
-(54,3,'LookLikeAKango',7,'2011-06-01'),
-(54,3,'Jaso',6,'2011-10-09'),
-(54,3,'Schlepian',5,'2011-11-06'),
-(54,3,'Spyrunite',4,'2012-08-30'),
-(54,3,'Krank (most likely)',2,'2012-08-30'),
-(54,3,'Krzyhau + Nidboj',0,'2018-08-01'),
-(55,3,'LookLikeAKango',7,'2011-10-08'),
-(55,3,'CalmlyFrenetic',3,'2011-10-09'),
-(55,3,'Jaso',2,'2011-11-26'),
-(55,3,'Krank (most likely)',0,'2011-11-26'),
-(56,3,'lihP',6,'2011-05-07'),
-(56,3,'LookLikeAKango',5,'2011-10-09'),
-(56,3,'CalmlyFrenetic',4,'2011-10-09'),
-(56,3,'Jetwash',2,'2014-09-05'),
-(56,3,'Krank (most likely)',0,'2014-09-05'),
-
-(46,4,'Krzyhau',2,'2017-11-02'),
-(46,4,'Krzyhau',0,'2020-12-26'),
-(47,4,'Krzyhau',0,'2017-09-09'),
-(48,4,'Krzyhau',0,'2017-09-09'),
-(49,4,'Krzyhau',0,'2017-09-09'),
-(50,4,'Krzyhau',0,'2017-09-09'),
-(51,4,'Krzyhau',0,'2017-09-09'),
-(52,4,'Krzyhau',0,'2017-08-29'),
-(53,4,'Krzyhau',0,'2017-08-29'),
-(54,4,'Krzyhau',0,'2017-08-29'),
-(55,4,'Krzyhau',0,'2017-08-29'),
-(56,4,'Krzyhau',0,'2017-08-29'),
-
--- Chapter 9
-(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'),
-(60,1,'Black_Semka',4,'2024-06-27'),
-
-(57,2,'JNS',7,'2011-07-21'),
-(57,2,'Krank',5,'2012-07-29'),
-(57,2,'Krank',0,'2012-08-19'),
-(58,2,'Stimich',2,'2011-10-11'),
-(58,2,'Krank',0,'2012-08-21'),
-(59,2,'Isimmo',7,'2011-11-04'),
-(59,2,'Krank',4,'2012-08-22'),
-(59,2,'Krzyhau',2,'2017-08-29'),
-(60,2,'CalmlyFrenetic',7,'2011-10-19'),
-(60,2,'Tyronis',6,'2011-11-01'),
-(60,2,'Krzyhau',5,'2020-07-09'),
-(60,2,'Krzyhau + CeyHun',3,'2022-06-23'),
-(60,2,'Krzyhau',1,'2023-08-22'),
-
-(57,3,'JNS',7,'2011-07-21'),
-(57,3,'Krank',5,'2012-07-29'),
-(57,3,'Krank',0,'2012-08-19'),
-(58,3,'Stimich',2,'2011-10-11'),
-(58,3,'Krank',0,'2012-08-21'),
-(59,3,'Isimmo',7,'2011-11-04'),
-(59,3,'Krank',4,'2012-08-22'),
-(59,3,'Krzyhau',2,'2017-08-29'),
-(60,3,'CalmlyFrenetic',7,'2011-10-19'),
-(60,3,'Tyronis',6,'2011-11-01'),
-(60,3,'Krzyhau',5,'2020-07-09'),
-(60,3,'Krzyhau + CeyHun',3,'2022-06-23'),
-(60,3,'Krzyhau',1,'2023-08-22'),
-
-(57,4,'Krzyhau',0,'2017-09-09'),
-(58,4,'Krzyhau',0,'2017-09-09'),
-(59,4,'Krzyhau',2,'2017-09-09'),
-(60,4,'Krzyhau',1,'2017-09-09'),
-
--- Portal 2 Cooperative
--- Chapter 1
-(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'),
-(65,1,'Nidboj132 & Oryn',2,'2023-07-10'),
-(66,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(66,1,'Schlepian & Chubfish',2,'2011-10-01'),
-(66,1,'Seal & Acuifex',0,'2023-07-22'),
-(67,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-(68,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-
-(63,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-(64,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(64,5,'Chubfish & Exhale',2,'2011-11-01'),
-(65,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(65,5,'Nidboj132 & Oryn',3,'2022-02-03'),
-(65,5,'Nidboj132 & Oryn',2,'2023-07-10'),
-(66,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(66,5,'Schlepian & Chubfish',2,'2011-10-01'),
-(66,5,'Seal & Acuifex',0,'2023-07-22'),
-(67,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-(68,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-
--- Chapter 2
-(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'),
-
-(69,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(70,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
-(70,5,'Schlepian & Chubfish',4,'2011-10-01'),
-(70,5,'Gocnak & z1mb0bw4y',2,'2012-08-03'),
-(71,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(71,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-(72,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(72,5,'Schlepian & LongJohnDickWeed',2,'2011-10-01'),
-(73,5,'Stimich & HiTMaRkS',9,'2011-05-09'),
-(73,5,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01'),
-(73,5,'Schlepian & Lemonsunshine',7,'2011-11-01'),
-(73,5,'DM_ & LsDK_',6,'2018-01-01'),
-(73,5,'Krzyhau & Klooger',4,'2018-11-01'),
-(74,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
-(74,5,'Stimich & Pitkakorva',7,'2011-10-11'),
-(74,5,'Schlepian & Isimmo',3,'2011-10-28'),
-(74,5,'Zypeh & szeimartin',2,'2013-11-01'),
-(75,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
-(75,5,'Schlepian & Urination',4,'2011-10-01'),
-(75,5,'Schlepian & Lemonsunshine',2,'2012-02-01'),
-(75,5,'DM_ & follon',0,'2015-04-01'),
-(76,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(76,5,'Chubfish & Exhale',0,'2011-12-01'),
-
--- Chapter 3
-(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'),
-(79,1,'BiSaXa & Oryn',0,'2023-07-18'),
-(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'),
-(81,1,'Seal & Acuifex',2,'2023-12-27'),
-(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'),
-
-(77,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(78,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(78,5,'DM_ & marK',3,'2016-11-01'),
-(79,5,'ganonscrub & undefined',5,'2011-04-01'),
-(79,5,'Bgr & mongfish',4,'2011-04-23'),
-(79,5,'Chubfish & Exhale',2,'2012-08-04'),
-(79,5,'BiSaXa & Oryn',0,'2023-07-18'),
-(80,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
-(80,5,'Chubfish & Exhale',4,'2011-12-01'),
-(81,5,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01'),
-(81,5,'Schlepian & Lemonsunshine',6,'2011-10-01'),
-(81,5,'takz & dawn',5,'2011-11-01'),
-(81,5,'Nidboj132 & Oryn',4,'2024-01-06'),
-(82,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(83,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
-(83,5,'Schlepian & Lemonsunshine',2,'2011-10-01'),
-(83,5,'Chubfish & Exhale',0,'2011-12-01'),
-(84,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
-(84,5,'Schlepian & Chubfish',4,'2011-10-01'),
-(84,5,'Chubfish & Exhale',2,'2012-01-01'),
-(84,5,'DM_ & wS',0,'2015-05-01'),
-
--- Chapter 4
-(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'),
-
-(85,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(85,5,'Chubfish & Exhale',0,'2011-10-01'),
-(86,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(86,5,'Chubfish & Exhale',0,'2011-12-01'),
-(87,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
-(87,5,'Schlepian & Gopherdude',2,'2011-10-01'),
-(87,5,'DM_ & follon',0,'2015-04-01'),
-(88,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(88,5,'Schlepian & Gopherdude',0,'2011-10-01'),
-(89,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
-(90,5,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01'),
-(90,5,'Schlepian & Urination',2,'2011-10-01'),
-(90,5,'Klooger & Jetwash',0,'2016-02-01'),
-(91,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
-(91,5,'Undead & Zypeh',0,'2013-05-19'),
-(92,5,'txx478 & undefined',5,'2011-05-01'),
-(92,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
-(92,5,'Schlepian & Gopherdude',2,'2011-10-01'),
-(92,5,'ncla & takz',0,'2012-02-01'),
-(93,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
-(93,5,'Schlepian & Gopherdude',0,'2011-10-01'),
-
--- Chapter 5
-(94,1,'Chubfish & Exhale',2,'2011-10-01'),
-(94,1,'Klooger & Imanex',0,'2013-08-01'),
-(95,1,'Schlepian & Issimoi',2,'2011-10-01'),
-(95,1,'Seal & Acuifex',0,'2024-02-13'),
-(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'),
-
-(94,5,'Chubfish & Exhale',2,'2011-10-01'),
-(94,5,'Klooger & Imanex',0,'2013-08-01'),
-(95,5,'Schlepian & Issimoi',2,'2011-10-01'),
-(96,5,'ThePortalPatrol & undefined',4,'2011-04-01'),
-(96,5,'sparkle1princess & Zypeh',2,'2014-01-01'),
-(97,5,'Stimich & HiTMaRkS',7,'2011-05-13'),
-(97,5,'Schlepian & Lemonsunshine',4,'2011-10-01'),
-(97,5,'DM_ & wS',2,'2014-05-01'),
-(98,5,'Imanex & 00svo',0,'2011-11-01'),
-(99,5,'Schlepian & Gopherdude',3,'2011-10-01'),
-(99,5,'Imanex & Klooger',2,'2013-08-01'),
-(99,5,'DM_ & wS',0,'2015-05-01'),
-(100,5,'Schlepian & Bananasaurus Rex',0,'2011-10-01'),
-(101,5,'Chubfish & Exhale',2,'2011-12-01'),
-(101,5,'DM_ & follon',0,'2015-04-01'),
-
--- Chapter 6
-(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'),
-
-(102,5,'dawn & takz',3,'2011-11-18'),
-(102,5,'Chubfish & Exhale',2,'2012-01-01'),
-(102,5,'Imanex & Klooger',0,'2013-08-01'),
-(103,5,'Schlepian & Lemonsunshine',0,'2011-10-01'),
-(104,5,'Schlepian & Lemonsunshine',0,'2011-10-01'),
-(105,5,'Blaizerazer & undefined',8,'2011-10-01'),
-(105,5,'Schlepian & Lemonsunshine',5,'2011-11-01'),
-(105,5,'Imanex & Klooger',4,'2013-08-01'),
-(105,5,'DM_ & wS',3,'2014-05-01'),
-(105,5,'DM_ & follon',2,'2015-04-01'),
-(106,5,'Schlepian & Bananasaurus Rex',4,'2011-10-01'),
-(106,5,'Gig & takz',3,'2012-06-01'),
-(106,5,'Unknown players',0,'2015-04-01'),
-(107,5,'Chubfish & Exhale',2,'2011-10-01'),
-(107,5,'DM_ & follon',0,'2015-04-01'),
-(108,5,'DaFox & P',0,'2011-12-01'),
-(109,5,'Schlepian & Tyronis',5,'2011-10-01'),
-(109,5,'Chubfish & Exhale',0,'2011-12-01'),
-(110,5,'Tyronis & mr.bob806',15,'2011-10-01'),
-(110,5,'Schlepian & Chubfish',6,'2011-11-01'),
-(110,5,'00svo & z1mb0bw4y',5,'2012-08-08'),
-(110,5,'00svo & z1mb0bw4y',4,'2012-08-10'),
-(110,5,'Klooger & z1mb0bw4y',2,'2014-02-01'),
-(110,5,'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 51bf2af..11ccd38 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -68,7 +68,7 @@ CREATE TABLE map_history (
   user_name TEXT NOT NULL,
   score_count SMALLINT NOT NULL,
   description TEXT NOT NULL,
-  showcase TEXT NOT NULL DEFAULT,
+  showcase TEXT NOT NULL DEFAULT '',
   record_date DATE NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (category_id) REFERENCES categories(id),
@@ -210,7 +210,7 @@ CREATE TABLE audit (
     old_data JSONB,
     new_data JSONB,
     changed_by TEXT NOT NULL,
-    changed_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
+    changed_at TIMESTAMP DEFAULT now(),
     PRIMARY KEY (id),
     FOREIGN KEY (changed_by) REFERENCES users(steam_id)
 );
diff --git a/backend/database/insert/categories.sql b/backend/database/insert/categories.sql
new file mode 100644
index 0000000..6bbf9b0
--- /dev/null
+++ b/backend/database/insert/categories.sql
@@ -0,0 +1,15 @@
+INSERT INTO categories(id, name) VALUES
+(1, 'CM'),
+(2, 'No SLA'),
+(3, 'Inbounds SLA'),
+(4, 'Any%'),
+(5, 'All Courses');
+
+INSERT INTO game_categories(id, game_id, category_id) VALUES
+(1, 1, 1),
+(2, 1, 2),
+(3, 1, 3),
+(4, 1, 4),
+(5, 2, 1),
+(6, 2, 4),
+(7, 2, 5);
\ No newline at end of file
diff --git a/backend/database/insert/chapters.sql b/backend/database/insert/chapters.sql
new file mode 100644
index 0000000..f61d5bf
--- /dev/null
+++ b/backend/database/insert/chapters.sql
@@ -0,0 +1,17 @@
+INSERT INTO chapters(id, game_id, name, is_disabled) VALUES
+(1, 1, 'Chapter 1 - The Coutesy Call', false),
+(2, 1, 'Chapter 2 - The Cold Boot', false),
+(3, 1, 'Chapter 3 - The Return', false),
+(4, 1, 'Chapter 4 - The Surprise', false),
+(5, 1, 'Chapter 5 - The Escape', false),
+(6, 1, 'Chapter 6 - The Fall', false),
+(7, 1, 'Chapter 7 - The Reunion', false),
+(8, 1, 'Chapter 8 - The Itch', false),
+(9, 1, 'Chapter 9 - The Part Where He Kills You', false),
+(10, 2, 'Course 0 - Introduction', true),
+(11, 2, 'Course 1 - Team Building', false),
+(12, 2, 'Course 2 - Mass And Velocity', false),
+(13, 2, 'Course 3 - Hard-Light Surfaces', false),
+(14, 2, 'Course 4 - Excursion Funnels', false),
+(15, 2, 'Course 5 - Mobility Gels', false),
+(16, 2, 'Course 6 - Art Therapy', false);
\ No newline at end of file
diff --git a/backend/database/insert/countries.sql b/backend/database/insert/countries.sql
new file mode 100644
index 0000000..0272f6f
--- /dev/null
+++ b/backend/database/insert/countries.sql
@@ -0,0 +1,252 @@
+INSERT INTO countries (country_code, country_name) VALUES
+('AF', 'AFGHANISTAN'),
+('AL', 'ALBANIA'),
+('DZ', 'ALGERIA'),
+('AS', 'AMERICAN SAMOA'),
+('AD', 'ANDORRA'),
+('AO', 'ANGOLA'),
+('AI', 'ANGUILLA'),
+('AQ', 'ANTARCTICA'),
+('AG', 'ANTIGUA AND BARBUDA'),
+('AR', 'ARGENTINA'),
+('AM', 'ARMENIA'),
+('AW', 'ARUBA'),
+('AU', 'AUSTRALIA'),
+('AT', 'AUSTRIA'),
+('AZ', 'AZERBAIJAN'),
+('BS', 'BAHAMAS'),
+('BH', 'BAHRAIN'),
+('BD', 'BANGLADESH'),
+('BB', 'BARBADOS'),
+('BY', 'BELARUS'),
+('BE', 'BELGIUM'),
+('BZ', 'BELIZE'),
+('BJ', 'BENIN'),
+('BM', 'BERMUDA'),
+('BT', 'BHUTAN'),
+('BO', 'BOLIVIA'),
+('BA', 'BOSNIA AND HERZEGOVINA'),
+('BW', 'BOTSWANA'),
+('BV', 'BOUVET ISLAND'),
+('BR', 'BRAZIL'),
+('IO', 'BRITISH INDIAN OCEAN TERRITORY'),
+('BN', 'BRUNEI DARUSSALAM'),
+('BG', 'BULGARIA'),
+('BF', 'BURKINA FASO'),
+('BI', 'BURUNDI'),
+('KH', 'CAMBODIA'),
+('CM', 'CAMEROON'),
+('CA', 'CANADA'),
+('CV', 'CAPE VERDE'),
+('KY', 'CAYMAN ISLANDS'),
+('CF', 'CENTRAL AFRICAN REPUBLIC'),
+('TD', 'CHAD'),
+('CL', 'CHILE'),
+('CN', 'CHINA'),
+('CX', 'CHRISTMAS ISLAND'),
+('CC', 'COCOS (KEELING) ISLANDS'),
+('CO', 'COLOMBIA'),
+('KM', 'COMOROS'),
+('CG', 'CONGO'),
+('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE'),
+('CK', 'COOK ISLANDS'),
+('CR', 'COSTA RICA'),
+('CI', 'COTE D''IVOIRE'),
+('HR', 'CROATIA'),
+('CU', 'CUBA'),
+('CY', 'CYPRUS'),
+('CZ', 'CZECHIA'),
+('DK', 'DENMARK'),
+('DJ', 'DJIBOUTI'),
+('DM', 'DOMINICA'),
+('DO', 'DOMINICAN REPUBLIC'),
+('EC', 'ECUADOR'),
+('EG', 'EGYPT'),
+('SV', 'EL SALVADOR'),
+('GQ', 'EQUATORIAL GUINEA'),
+('ER', 'ERITREA'),
+('EE', 'ESTONIA'),
+('ET', 'ETHIOPIA'),
+('FK', 'FALKLAND ISLANDS (MALVINAS)'),
+('FO', 'FAROE ISLANDS'),
+('FJ', 'FIJI'),
+('FI', 'FINLAND'),
+('FR', 'FRANCE'),
+('GF', 'FRENCH GUIANA'),
+('PF', 'FRENCH POLYNESIA'),
+('TF', 'FRENCH SOUTHERN TERRITORIES'),
+('GA', 'GABON'),
+('GM', 'GAMBIA'),
+('GE', 'GEORGIA'),
+('DE', 'GERMANY'),
+('GH', 'GHANA'),
+('GI', 'GIBRALTAR'),
+('GR', 'GREECE'),
+('GL', 'GREENLAND'),
+('GD', 'GRENADA'),
+('GP', 'GUADELOUPE'),
+('GU', 'GUAM'),
+('GT', 'GUATEMALA'),
+('GN', 'GUINEA'),
+('GW', 'GUINEA-BISSAU'),
+('GY', 'GUYANA'),
+('HT', 'HAITI'),
+('HM', 'HEARD ISLAND AND MCDONALD ISLANDS'),
+('VA', 'VATICAN CITY STATE'),
+('HN', 'HONDURAS'),
+('HK', 'HONG KONG'),
+('HU', 'HUNGARY'),
+('IS', 'ICELAND'),
+('IN', 'INDIA'),
+('ID', 'INDONESIA'),
+('IR', 'IRAN'),
+('IQ', 'IRAQ'),
+('IE', 'IRELAND'),
+('IL', 'ISRAEL'),
+('IT', 'ITALY'),
+('JM', 'JAMAICA'),
+('JP', 'JAPAN'),
+('JO', 'JORDAN'),
+('KZ', 'KAZAKHSTAN'),
+('KE', 'KENYA'),
+('KI', 'KIRIBATI'),
+('KP', 'NORTH KOREA'),
+('KR', 'SOUTH KOREA'),
+('KW', 'KUWAIT'),
+('KG', 'KYRGYZSTAN'),
+('LA', 'LAO'),
+('LV', 'LATVIA'),
+('LB', 'LEBANON'),
+('LS', 'LESOTHO'),
+('LR', 'LIBERIA'),
+('LY', 'LIBYAN ARAB JAMAHIRIYA'),
+('LI', 'LIECHTENSTEIN'),
+('LT', 'LITHUANIA'),
+('LU', 'LUXEMBOURG'),
+('MO', 'MACAO'),
+('MK', 'NORTH MACEDONIA'),
+('MG', 'MADAGASCAR'),
+('MW', 'MALAWI'),
+('MY', 'MALAYSIA'),
+('MV', 'MALDIVES'),
+('ML', 'MALI'),
+('MT', 'MALTA'),
+('MH', 'MARSHALL ISLANDS'),
+('MQ', 'MARTINIQUE'),
+('MR', 'MAURITANIA'),
+('MU', 'MAURITIUS'),
+('YT', 'MAYOTTE'),
+('MX', 'MEXICO'),
+('FM', 'MICRONESIA'),
+('MD', 'MOLDOVA'),
+('MC', 'MONACO'),
+('MN', 'MONGOLIA'),
+('MS', 'MONTSERRAT'),
+('MA', 'MOROCCO'),
+('MZ', 'MOZAMBIQUE'),
+('MM', 'MYANMAR'),
+('NA', 'NAMIBIA'),
+('NR', 'NAURU'),
+('NP', 'NEPAL'),
+('NL', 'NETHERLANDS'),
+('AN', 'NETHERLANDS ANTILLES'),
+('NC', 'NEW CALEDONIA'),
+('NZ', 'NEW ZEALAND'),
+('NI', 'NICARAGUA'),
+('NE', 'NIGER'),
+('NG', 'NIGERIA'),
+('NU', 'NIUE'),
+('NF', 'NORFOLK ISLAND'),
+('MP', 'NORTHERN MARIANA ISLANDS'),
+('NO', 'NORWAY'),
+('OM', 'OMAN'),
+('PK', 'PAKISTAN'),
+('PW', 'PALAU'),
+('PS', 'PALESTINE'),
+('PA', 'PANAMA'),
+('PG', 'PAPUA NEW GUINEA'),
+('PY', 'PARAGUAY'),
+('PE', 'PERU'),
+('PH', 'PHILIPPINES'),
+('PN', 'PITCAIRN'),
+('PL', 'POLAND'),
+('PT', 'PORTUGAL'),
+('PR', 'PUERTO RICO'),
+('QA', 'QATAR'),
+('RE', 'REUNION'),
+('RO', 'ROMANIA'),
+('RU', 'RUSSIAN FEDERATION'),
+('RW', 'RWANDA'),
+('SH', 'SAINT HELENA'),
+('KN', 'SAINT KITTS AND NEVIS'),
+('LC', 'SAINT LUCIA'),
+('PM', 'SAINT PIERRE AND MIQUELON'),
+('VC', 'SAINT VINCENT AND THE GRENADINES'),
+('WS', 'SAMOA'),
+('SM', 'SAN MARINO'),
+('ST', 'SAO TOME AND PRINCIPE'),
+('SA', 'SAUDI ARABIA'),
+('SN', 'SENEGAL'),
+('RS', 'SERBIA'),
+('SC', 'SEYCHELLES'),
+('SL', 'SIERRA LEONE'),
+('SG', 'SINGAPORE'),
+('SK', 'SLOVAKIA'),
+('SI', 'SLOVENIA'),
+('SB', 'SOLOMON ISLANDS'),
+('SO', 'SOMALIA'),
+('ZA', 'SOUTH AFRICA'),
+('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS'),
+('ES', 'SPAIN'),
+('LK', 'SRI LANKA'),
+('SD', 'SUDAN'),
+('SR', 'SURINAME'),
+('SJ', 'SVALBARD AND JAN MAYEN'),
+('SZ', 'SWAZILAND'),
+('SE', 'SWEDEN'),
+('CH', 'SWITZERLAND'),
+('SY', 'SYRIAN ARAB REPUBLIC'),
+('TW', 'TAIWAN'),
+('TJ', 'TAJIKISTAN'),
+('TZ', 'TANZANIA'),
+('TH', 'THAILAND'),
+('TL', 'TIMOR-LESTE'),
+('TG', 'TOGO'),
+('TK', 'TOKELAU'),
+('TO', 'TONGA'),
+('TT', 'TRINIDAD AND TOBAGO'),
+('TN', 'TUNISIA'),
+('TR', 'TURKEY'),
+('TM', 'TURKMENISTAN'),
+('TC', 'TURKS AND CAICOS ISLANDS'),
+('TV', 'TUVALU'),
+('UG', 'UGANDA'),
+('UA', 'UKRAINE'),
+('AE', 'UNITED ARAB EMIRATES'),
+('GB', 'UNITED KINGDOM'),
+('US', 'UNITED STATES'),
+('UM', 'UNITED STATES MINOR OUTLYING ISLANDS'),
+('UY', 'URUGUAY'),
+('UZ', 'UZBEKISTAN'),
+('VU', 'VANUATU'),
+('VE', 'VENEZUELA'),
+('VN', 'VIET NAM'),
+('VG', 'VIRGIN ISLANDS, BRITISH'),
+('VI', 'VIRGIN ISLANDS, U.S.'),
+('WF', 'WALLIS AND FUTUNA'),
+('EH', 'WESTERN SAHARA'),
+('YE', 'YEMEN'),
+('ZM', 'ZAMBIA'),
+('ZW', 'ZIMBABWE'),
+('ME', 'MONTENEGRO'),
+('XK', 'KOSOVO'),
+('AX', 'ALAND ISLANDS'),
+('BQ', 'BONAIRE'),
+('CW', 'CURACAO'),
+('GG', 'GUERNSEY'),
+('IM', 'ISLE OF MAN'),
+('JE', 'JERSEY'),
+('BL', 'SAINT BARTHELEMY'),
+('MF', 'SAINT MARTIN'),
+('SX', 'SINT MAARTEN'),
+('SS', 'SOUTH SUDAN');
\ No newline at end of file
diff --git a/backend/database/insert/games.sql b/backend/database/insert/games.sql
new file mode 100644
index 0000000..0c2374c
--- /dev/null
+++ b/backend/database/insert/games.sql
@@ -0,0 +1,3 @@
+INSERT INTO games(id, name, is_coop) VALUES
+(1, 'Portal 2 - Singleplayer', false),
+(2, 'Portal 2 - Cooperative', true);
\ No newline at end of file
diff --git a/backend/database/insert/history.sql b/backend/database/insert/history.sql
new file mode 100644
index 0000000..34fddcb
--- /dev/null
+++ b/backend/database/insert/history.sql
@@ -0,0 +1,840 @@
+INSERT INTO map_history(map_id,category_id,user_name,score_count,record_date) VALUES
+-- Portal 2 Singleplayer
+-- Chapter 1
+(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'),
+(7,1,'Tyronis',0,'2013-01-11'),
+(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'),
+
+(3,2,'slmid1995',3,'2011-10-05'),
+(3,2,'LookLikeAKango',1,'2011-10-06'),
+(3,2,'Bananasaurus Rex',0,'2011-10-24'),
+(4,2,'Tyronis',1,'2011-10-05'),
+(4,2,'Krzyhau',0,'2019-05-10'),
+(5,2,'LookLikeAKango',2,'2011-10-05'),
+(5,2,'JesusCatFace',1,'2013-04-01'),
+(6,2,'Stimich',4,'2011-10-08'),
+(6,2,'aepaePolakrn',3,'2011-10-19'),
+(6,2,'Krzyhau',2,'2020-10-10'),
+(7,2,'Tyronis',0,'2013-01-11'),
+(9,2,'slmid1995',4,'2011-10-05'),
+(9,2,'Jokie',3,'2011-10-05'),
+(9,2,'Tyronis',2,'2011-11-02'),
+(9,2,'sicklebrick',0,'2013-03-13'),
+
+(3,3,'slmid1995',3,'2011-10-05'),
+(3,3,'LookLikeAKango',1,'2011-10-06'),
+(3,3,'Bananasaurus Rex',0,'2011-10-24'),
+(4,3,'Tyronis',1,'2011-10-05'),
+(4,3,'Krzyhau',0,'2019-05-10'),
+(5,3,'LookLikeAKango',2,'2011-10-05'),
+(5,3,'JesusCatFace',1,'2013-04-01'),
+(6,3,'Stimich',4,'2011-10-08'),
+(6,3,'aepaePolakrn',3,'2011-10-19'),
+(6,3,'Krzyhau',1,'2017-07-29'),
+(7,3,'Tyronis',0,'2013-01-11'),
+(9,3,'slmid1995',4,'2011-10-05'),
+(9,3,'Jokie',3,'2011-10-05'),
+(9,3,'Tyronis',2,'2011-11-02'),
+(9,3,'sicklebrick',0,'2013-03-13'),
+
+(3,4,'Krzyhau',0,'2018-01-11'),
+(4,4,'Krzyhau',0,'2018-01-11'),
+(5,4,'Krzyhau',0,'2018-01-11'),
+(6,4,'Krzyhau',0,'2018-01-11'),
+(9,4,'sicklebrick',0,'2013-03-13'),
+
+-- Chapter 2
+(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'),
+(14,0,'?',0,'2011-04-19'),
+(15,1,'Tyronis',2,'2011-10-05'),
+(15,1,'SuperAiderton',0,'2024-01-28'),
+(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'),
+
+(10,2,'Paraxade0',2,'2011-04-21'),
+(10,2,'PerOculos',0,'2014-08-23'),
+(11,2,'Tyronis',2,'2011-10-05'),
+(11,2,'Krzyhau',0,'2018-06-06'),
+(12,2,'slmid1995',2,'2011-10-04'),
+(13,2,'MPRS',3,'2011-05-04'),
+(13,2,'Imanex',2,'2011-12-08'),
+(13,2,'jyjey',0,'2012-08-22'),
+(15,2,'Tyronis',2,'2011-10-05'),
+(15,2,'Nidboj132',0,'2022-11-07'),
+(16,2,'LookLikeAKango',2,'2011-10-05'),
+(16,2,'jyjey',0,'2012-08-25'),
+(17,2,'rocoty',2,'2011-10-05'),
+(17,2,'Nidboj132',0,'2023-02-05'),
+
+(10,3,'Paraxade0',2,'2011-04-21'),
+(10,3,'PerOculos',0,'2014-08-23'),
+(11,3,'Tyronis',2,'2011-10-05'),
+(11,3,'Krzyhau',0,'2018-06-06'),
+(12,3,'slmid1995',2,'2011-10-04'),
+(12,3,'Krzyhau',0,'2018-08-08'),
+(13,3,'MPRS',3,'2011-05-04'),
+(13,3,'Imanex',2,'2011-12-08'),
+(13,3,'jyjey',0,'2012-08-22'),
+(15,3,'Tyronis',2,'2011-10-05'),
+(15,3,'Nidboj132',0,'2021-02-01'),
+(16,3,'LookLikeAKango',2,'2011-10-05'),
+(16,3,'jyjey',0,'2012-08-25'),
+(17,3,'rocoty',2,'2011-10-05'),
+(17,3,'Nidboj132',0,'2023-02-05'),
+
+(10,4,'PerOculos',0,'2014-08-23'),
+(11,4,'Krzyhau',0,'2018-01-11'),
+(12,4,'Krzyhau',0,'2018-01-11'),
+(13,4,'Krzyhau',0,'2018-01-11'),
+(15,4,'Krzyhau',0,'2018-01-11'),
+(16,4,'Krzyhau',0,'2018-01-11'),
+(17,4,'Krzyhau',0,'2018-01-11'),
+
+-- Chapter 3
+(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'),
+
+(18,2,'The Last Tofus',5,'2011-05-08'),
+(18,2,'Schlepian',4,'2011-10-08'),
+(18,2,'szeimartin',3,'2013-04-19'),
+(18,2,'Krzyhau',2,'2020-05-15'),
+(18,2,'Krzyhau',0,'2022-07-02'),
+(19,2,'LookLikeAKango',2,'2011-10-06'),
+(20,2,'Djinndrache',5,'2011-10-20'),
+(20,2,'Schlepian',4,'2011-10-30'),
+(20,2,'Jetwash',3,'2014-09-04'),
+(20,2,'Krzyhau',2,'2020-02-17'),
+(21,2,'LookLikeAKango',4,'2011-10-06'),
+(21,2,'Schlepian',2,'2011-10-29'),
+(21,2,'PerOculos',0,'2019-04-06'),
+(22,2,'Tyronis',0,'2011-10-05'),
+(23,2,'LookLikeAKango',2,'2011-10-06'),
+(23,2,'Krzyhau',0,'2018-08-01'),
+(24,2,'LeviHB',0,'2011-04-30'),
+(25,2,'LeviHB',0,'2011-05-01'),
+(26,2,'Schlepian',3,'2011-10-30'),
+(26,2,'Tyronis',2,'2012-01-08'),
+(26,2,'PerOculos',0,'2016-06-08'),
+
+(18,3,'The Last Tofus',5,'2011-05-08'),
+(18,3,'Schlepian',4,'2011-10-08'),
+(18,3,'szeimartin',3,'2013-04-19'),
+(18,3,'Krzyhau',2,'2020-05-15'),
+(18,3,'Krzyhau',0,'2022-07-02'),
+(19,3,'LookLikeAKango',2,'2011-10-06'),
+(20,3,'Djinndrache',5,'2011-10-20'),
+(20,3,'Schlepian',4,'2011-10-30'),
+(20,3,'Jetwash',3,'2014-09-04'),
+(20,3,'Krzyhau',2,'2020-02-17'),
+(21,3,'LookLikeAKango',4,'2011-10-06'),
+(21,3,'Schlepian',2,'2011-10-29'),
+(21,3,'Krzyhau',0,'2018-08-10'),
+(22,3,'Tyronis',0,'2011-10-05'),
+(23,3,'LookLikeAKango',2,'2011-10-06'),
+(23,3,'Krzyhau',0,'2018-04-06'),
+(24,3,'LeviHB',0,'2011-04-30'),
+(25,3,'LeviHB',0,'2011-05-01'),
+(26,3,'Schlepian',3,'2011-10-30'),
+(26,3,'Tyronis',2,'2012-01-08'),
+(26,3,'PerOculos',0,'2016-06-08'),
+
+(18,4,'Krzyhau',0,'2018-01-11'),
+(19,4,'Krzyhau',0,'2018-01-11'),
+(20,4,'Krzyhau',0,'2018-01-11'),
+(21,4,'Krzyhau',0,'2018-01-11'),
+(22,4,'Krzyhau',0,'2018-01-21'),
+(23,4,'Krzyhau',0,'2018-01-11'),
+(24,4,'Krzyhau',0,'2018-01-11'),
+(25,4,'Krzyhau',0,'2018-01-11'),
+(26,4,'Krzyhau',0,'2018-01-11'),
+
+-- Chapter 4
+(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'),
+
+(27,2,'LeviHB',2,'2011-05-01'),
+(27,2,'PerOculos',0,'2020-07-13'),
+(28,2,'LeviHB',7,'2011-05-01'),
+(28,2,'SpinDizzy',5,'2011-05-03'),
+(28,2,'SpinDizzy',4,'2011-05-06'),
+(28,2,'Andy M.J.',2,'2011-10-07'),
+(28,2,'Krzyhau',0,'2018-05-19'),
+(29,2,'LeviHB',0,'2011-05-01'),
+(30,2,'Schlepian',2,'2011-10-30'),
+(31,2,'Tyronis',0,'2011-10-06'),
+
+(27,3,'LeviHB',2,'2011-05-01'),
+(27,3,'PerOculos',0,'2020-07-13'),
+(28,3,'LeviHB',7,'2011-05-01'),
+(28,3,'SpinDizzy',5,'2011-05-03'),
+(28,3,'SpinDizzy',4,'2011-05-06'),
+(28,3,'Andy M.J.',2,'2011-10-07'),
+(28,3,'Krzyhau',0,'2018-05-19'),
+(29,3,'LeviHB',0,'2011-05-01'),
+(30,3,'Schlepian',2,'2011-10-30'),
+(31,3,'Tyronis',0,'2011-10-06'),
+
+(27,4,'Krzyhau',0,'2018-01-11'),
+(28,4,'Krzyhau',0,'2018-01-11'),
+(29,4,'Krzyhau',0,'2018-01-11'),
+(30,4,'Krzyhau',0,'2018-01-11'),
+(31,4,'Krzyhau',0,'2018-01-11'),
+
+-- Chapter 5
+(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'),
+
+(32,2,'Tyronis',6,'2011-10-21'),
+(32,2,'Nidboj132',5,'2022-04-24'),
+(32,2,'Fridge',3,'2023-06-18'),
+(33,2,'Tyronis',7,'2011-10-06'),
+(33,2,'ISimmo',5,'2011-11-02'),
+(33,2,'PerOculos',4,'2017-05-30'),
+(34,2,'Schlepian',3,'2011-11-01'),
+(34,2,'Krzyhau',2,'2020-10-14'),
+(34,2,'Krzyhau + Nidboj132',0,'2021-03-14'),
+(35,2,'Krank',2,'2012-07-28'),
+
+(32,3,'Tyronis',6,'2011-10-21'),
+(32,3,'Krzyhau',4,'2018-08-07'),
+(32,3,'Nidboj132',3,'2022-04-24'),
+(33,3,'Tyronis',7,'2011-10-06'),
+(33,3,'ISimmo',5,'2011-11-02'),
+(33,3,'PerOculos',4,'2017-05-30'),
+(34,3,'Schlepian',3,'2011-11-01'),
+(34,3,'Krzyhau',2,'2020-07-09'),
+(34,3,'Krzyhau + Nidboj132',0,'2021-03-14'),
+(35,3,'Krank',2,'2012-07-28'),
+
+(32,4,'Krzyhau',0,'2021-02-09'),
+(33,4,'PerOculos',4,'2017-05-30'),
+(33,4,'Krzyhau',0,'2020-12-26'),
+(34,4,'Krzyhau',0,'2017-09-27'),
+(35,4,'Krank',2,'2012-07-28'),
+
+-- Chapter 6
+(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'),
+
+(36,2,'Tyronis',6,'2011-10-06'),
+(36,2,'CalmlyFrenetic',5,'2011-10-09'),
+(36,2,'sicklebrick',4,'2012-09-13'),
+(36,2,'Nidboj132',2,'2023-03-04'),
+(37,2,'LookLikeAKango',7,'2011-10-06'),
+(37,2,'Schlepian',6,'2011-11-01'),
+(37,2,'Tyronis',5,'2012-01-28'),
+(37,2,'Nidboj132',4,'2021-08-22'),
+(38,2,'Andy M.J.',2,'2011-10-06'),
+(38,2,'Death Pony',0,'2011-11-12'),
+(39,2,'Lambda Core',6,'2011-05-13'),
+(39,2,'The Last Tofus',5,'2011-05-13'),
+(39,2,'LookLikeAKango',4,'2011-10-16'),
+(39,2,'Kittaye',3,'2013-03-25'),
+(40,2,'LookLikeAKango',7,'2011-10-07'),
+(40,2,'Schlepian',6,'2011-11-05'),
+(40,2,'Kittaye',4,'2013-04-01'),
+(40,2,'Kittaye',3,'2014-09-13'),
+(40,2,'szeimartin',2,'2014-09-13'),
+(40,2,'Kittaye',0,'2014-09-15'),
+(41,2,'CalmlyFrenetic',7,'2011-10-09'),
+(41,2,'Jaso',6,'2011-10-11'),
+(41,2,'Krank',5,'2012-07-17'),
+
+(36,3,'Tyronis',6,'2011-10-06'),
+(36,3,'CalmlyFrenetic',5,'2011-10-09'),
+(36,3,'sicklebrick',4,'2012-09-13'),
+(36,3,'Krzyhau',2,'2022-07-20'),
+(36,3,'Nidboj132',0,'2023-03-04'),
+(37,3,'LookLikeAKango',7,'2011-10-06'),
+(37,3,'Schlepian',6,'2011-11-01'),
+(37,3,'Tyronis',5,'2012-01-28'),
+(37,3,'?',4,'2021-08-22'),
+(37,3,'zach',2,'2022-10-17'),
+(38,3,'Andy M.J.',2,'2011-10-06'),
+(38,3,'Death Pony',0,'2011-11-12'),
+(39,3,'Lambda Core',6,'2011-05-13'),
+(39,3,'The Last Tofus',5,'2011-05-13'),
+(39,3,'LookLikeAKango',4,'2011-10-16'),
+(39,3,'Kittaye',3,'2013-03-25'),
+(40,3,'LookLikeAKango',7,'2011-10-07'),
+(40,3,'Schlepian',6,'2011-11-05'),
+(40,3,'Kittaye',4,'2013-04-01'),
+(40,3,'Kittaye',3,'2014-09-13'),
+(40,3,'szeimartin',2,'2014-09-13'),
+(40,3,'Kittaye',0,'2014-09-15'),
+(41,3,'CalmlyFrenetic',7,'2011-10-09'),
+(41,3,'Jaso',6,'2011-10-11'),
+(41,3,'Krank',5,'2012-07-17'),
+
+(36,4,'Krzyhau',2,'2022-07-20'),
+(36,4,'Nidboj132',0,'2023-03-04'),
+(37,4,'Tyronis',5,'2012-01-28'),
+(37,4,'Krzyhau',0,'2020-12-26'),
+(38,4,'Death Pony',0,'2011-11-12'),
+(39,4,'Kittaye',3,'2013-03-25'),
+(39,4,'Krzyhau',0,'2020-12-26'),
+(40,4,'Kittaye',0,'2014-09-15'),
+(41,4,'Krank',5,'2012-07-17'),
+(41,4,'Krzyhau',0,'2020-12-26'),
+
+-- Chapter 7
+(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'),
+
+(42,2,'LookLikeAKango',4,'2011-05-17'),
+(42,2,'Schlepian',2,'2011-11-06'),
+(43,2,'lmao4ever',5,'2011-10-30'),
+(43,2,'Jaso',2,'2011-11-09'),
+(43,2,'feliser',0,'2022-06-26'),
+(44,2,'LookLikeAKango',18,'2011-10-07'),
+(44,2,'Tyronis',13,'2011-10-30'),
+(44,2,'Tyronis',12,'2011-11-10'),
+(44,2,'Jetwash',11,'2017-06-12'),
+(44,2,'Krzyhau',9,'2022-01-02'),
+(45,2,'LookLikeAKango',23,'2011-10-08'),
+(45,2,'CalmlyFrenetic',22,'2011-10-09'),
+(45,2,'cgreactor',17,'2011-10-09'),
+(45,2,'CalmlyFrenetic',16,'2011-10-10'),
+(45,2,'LookLikeAKango',15,'2011-10-19'),
+(45,2,'Jaso',12,'2012-07-19'),
+(45,2,'Krank',10,'2013-01-31'),
+(45,2,'Kittaye',7,'2013-04-04'),
+(45,2,'PerOculos',4,'2014-09-13'),
+
+(42,3,'LookLikeAKango',4,'2011-05-17'),
+(42,3,'Schlepian',2,'2011-11-06'),
+(43,3,'lmao4ever',5,'2011-10-30'),
+(43,3,'Jaso',2,'2011-11-09'),
+(43,3,'feliser',0,'2022-06-26'),
+(44,3,'LookLikeAKango',18,'2011-10-07'),
+(44,3,'Tyronis',13,'2011-10-30'),
+(44,3,'Tyronis',12,'2011-11-10'),
+(44,3,'Jetwash',11,'2017-06-12'),
+(44,3,'Krzyhau',9,'2022-01-02'),
+(45,3,'LookLikeAKango',23,'2011-10-08'),
+(45,3,'CalmlyFrenetic',22,'2011-10-09'),
+(45,3,'cgreactor',17,'2011-10-09'),
+(45,3,'CalmlyFrenetic',16,'2011-10-10'),
+(45,3,'LookLikeAKango',15,'2011-10-19'),
+(45,3,'Jaso',12,'2012-07-19'),
+(45,3,'Krank',10,'2013-01-31'),
+(45,3,'Kittaye',7,'2013-04-04'),
+(45,3,'PerOculos',4,'2014-09-13'),
+(45,3,'Fridge',3,'2023-08-19'),
+
+(42,4,'Schlepian',2,'2011-11-06'),
+(42,4,'Krzyhau',0,'2020-12-26'),
+(43,4,'Krzyhau',0,'2020-12-26'),
+(44,4,'Jetwash',11,'2017-06-12'),
+(44,4,'Nidboj',0,'2020-12-27'),
+(45,4,'PerOculos',4,'2014-09-13'),
+(45,4,'Krzyhau',0,'2020-12-27'),
+
+-- Chapter 8
+(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'),
+
+(46,2,'Fapmid',6,'2011-05-29'),
+(46,2,'Krzyhau',2,'2019-11-21'),
+(47,2,'mprs',2,'2011-05-03'),
+(47,2,'JesusCatFace',0,'2015-01-16'),
+(48,2,'LookLikeAKango',5,'2011-10-08'),
+(48,2,'Tyronis',2,'2011-10-08'),
+(48,2,'Krank (most likely)',0,'2011-10-08'),
+(49,2,'9E161D40',3,'2011-05-06'),
+(49,2,'Schlepian',2,'2011-10-08'),
+(49,2,'Krank (most likely)',0,'2011-10-08'),
+(50,2,'LookLikeAKango',4,'2011-10-08'),
+(50,2,'Tyronis',2,'2011-10-11'),
+(50,2,'Krank (most likely)',0,'2011-10-11'),
+(51,2,'Andy M.J.',3,'2011-10-08'),
+(51,2,'LookLikeAKango',2,'2011-10-20'),
+(51,2,'Krank (most likely)',0,'2011-10-20'),
+(52,2,'SpinDizzy',3,'2011-05-02'),
+(52,2,'Krank (most likely)',0,'2011-05-02'),
+(53,2,'LookLikeAKango',9,'2011-10-08'),
+(53,2,'LookLikeAKango',2,'2011-10-20'),
+(53,2,'Krank',0,'2012-08-19'),
+(54,2,'LookLikeAKango',7,'2011-06-01'),
+(54,2,'Jaso',6,'2011-10-09'),
+(54,2,'Schlepian',5,'2011-11-06'),
+(54,2,'Spyrunite',4,'2012-08-30'),
+(54,2,'Krank (most likely)',2,'2012-08-30'),
+(54,2,'Krzyhau + Nidboj',0,'2018-08-01'),
+(55,2,'LookLikeAKango',7,'2011-10-08'),
+(55,2,'CalmlyFrenetic',3,'2011-10-09'),
+(55,2,'Jaso',2,'2011-11-26'),
+(55,2,'Krank (most likely)',0,'2011-11-26'),
+(56,2,'lihP',6,'2011-05-07'),
+(56,2,'LookLikeAKango',5,'2011-10-09'),
+(56,2,'CalmlyFrenetic',4,'2011-10-09'),
+(56,2,'Jetwash',2,'2014-09-05'),
+(56,2,'Krank (most likely)',0,'2014-09-05'),
+
+(46,3,'Fapmid',6,'2011-05-29'),
+(46,3,'Krzyhau',2,'2017-11-02'),
+(47,3,'mprs',2,'2011-05-03'),
+(47,3,'JesusCatFace',0,'2015-01-16'),
+(48,3,'LookLikeAKango',5,'2011-10-08'),
+(48,3,'Tyronis',2,'2011-10-08'),
+(48,3,'Krank (most likely)',0,'2011-10-08'),
+(49,3,'9E161D40',3,'2011-05-06'),
+(49,3,'Schlepian',2,'2011-10-08'),
+(49,3,'Krank (most likely)',0,'2011-10-08'),
+(50,3,'LookLikeAKango',4,'2011-10-08'),
+(50,3,'Tyronis',2,'2011-10-11'),
+(50,3,'Krank (most likely)',0,'2011-10-11'),
+(51,3,'Andy M.J.',3,'2011-10-08'),
+(51,3,'LookLikeAKango',2,'2011-10-20'),
+(51,3,'Krank (most likely)',0,'2011-10-20'),
+(52,3,'SpinDizzy',3,'2011-05-02'),
+(52,3,'Krank (most likely)',0,'2011-05-02'),
+(53,3,'LookLikeAKango',9,'2011-10-08'),
+(53,3,'LookLikeAKango',2,'2011-10-20'),
+(53,3,'Krank',0,'2012-08-19'),
+(54,3,'LookLikeAKango',7,'2011-06-01'),
+(54,3,'Jaso',6,'2011-10-09'),
+(54,3,'Schlepian',5,'2011-11-06'),
+(54,3,'Spyrunite',4,'2012-08-30'),
+(54,3,'Krank (most likely)',2,'2012-08-30'),
+(54,3,'Krzyhau + Nidboj',0,'2018-08-01'),
+(55,3,'LookLikeAKango',7,'2011-10-08'),
+(55,3,'CalmlyFrenetic',3,'2011-10-09'),
+(55,3,'Jaso',2,'2011-11-26'),
+(55,3,'Krank (most likely)',0,'2011-11-26'),
+(56,3,'lihP',6,'2011-05-07'),
+(56,3,'LookLikeAKango',5,'2011-10-09'),
+(56,3,'CalmlyFrenetic',4,'2011-10-09'),
+(56,3,'Jetwash',2,'2014-09-05'),
+(56,3,'Krank (most likely)',0,'2014-09-05'),
+
+(46,4,'Krzyhau',2,'2017-11-02'),
+(46,4,'Krzyhau',0,'2020-12-26'),
+(47,4,'Krzyhau',0,'2017-09-09'),
+(48,4,'Krzyhau',0,'2017-09-09'),
+(49,4,'Krzyhau',0,'2017-09-09'),
+(50,4,'Krzyhau',0,'2017-09-09'),
+(51,4,'Krzyhau',0,'2017-09-09'),
+(52,4,'Krzyhau',0,'2017-08-29'),
+(53,4,'Krzyhau',0,'2017-08-29'),
+(54,4,'Krzyhau',0,'2017-08-29'),
+(55,4,'Krzyhau',0,'2017-08-29'),
+(56,4,'Krzyhau',0,'2017-08-29'),
+
+-- Chapter 9
+(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'),
+(60,1,'Black_Semka',4,'2024-06-27'),
+
+(57,2,'JNS',7,'2011-07-21'),
+(57,2,'Krank',5,'2012-07-29'),
+(57,2,'Krank',0,'2012-08-19'),
+(58,2,'Stimich',2,'2011-10-11'),
+(58,2,'Krank',0,'2012-08-21'),
+(59,2,'Isimmo',7,'2011-11-04'),
+(59,2,'Krank',4,'2012-08-22'),
+(59,2,'Krzyhau',2,'2017-08-29'),
+(60,2,'CalmlyFrenetic',7,'2011-10-19'),
+(60,2,'Tyronis',6,'2011-11-01'),
+(60,2,'Krzyhau',5,'2020-07-09'),
+(60,2,'Krzyhau + CeyHun',3,'2022-06-23'),
+(60,2,'Krzyhau',1,'2023-08-22'),
+
+(57,3,'JNS',7,'2011-07-21'),
+(57,3,'Krank',5,'2012-07-29'),
+(57,3,'Krank',0,'2012-08-19'),
+(58,3,'Stimich',2,'2011-10-11'),
+(58,3,'Krank',0,'2012-08-21'),
+(59,3,'Isimmo',7,'2011-11-04'),
+(59,3,'Krank',4,'2012-08-22'),
+(59,3,'Krzyhau',2,'2017-08-29'),
+(60,3,'CalmlyFrenetic',7,'2011-10-19'),
+(60,3,'Tyronis',6,'2011-11-01'),
+(60,3,'Krzyhau',5,'2020-07-09'),
+(60,3,'Krzyhau + CeyHun',3,'2022-06-23'),
+(60,3,'Krzyhau',1,'2023-08-22'),
+
+(57,4,'Krzyhau',0,'2017-09-09'),
+(58,4,'Krzyhau',0,'2017-09-09'),
+(59,4,'Krzyhau',2,'2017-09-09'),
+(60,4,'Krzyhau',1,'2017-09-09'),
+
+-- Portal 2 Cooperative
+-- Chapter 1
+(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'),
+(65,1,'Nidboj132 & Oryn',2,'2023-07-10'),
+(66,1,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(66,1,'Schlepian & Chubfish',2,'2011-10-01'),
+(66,1,'Seal & Acuifex',0,'2023-07-22'),
+(67,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(68,1,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+
+(63,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(64,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(64,5,'Chubfish & Exhale',2,'2011-11-01'),
+(65,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(65,5,'Nidboj132 & Oryn',3,'2022-02-03'),
+(65,5,'Nidboj132 & Oryn',2,'2023-07-10'),
+(66,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(66,5,'Schlepian & Chubfish',2,'2011-10-01'),
+(66,5,'Seal & Acuifex',0,'2023-07-22'),
+(67,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(68,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+
+-- Chapter 2
+(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'),
+
+(69,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(70,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
+(70,5,'Schlepian & Chubfish',4,'2011-10-01'),
+(70,5,'Gocnak & z1mb0bw4y',2,'2012-08-03'),
+(71,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(71,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(72,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(72,5,'Schlepian & LongJohnDickWeed',2,'2011-10-01'),
+(73,5,'Stimich & HiTMaRkS',9,'2011-05-09'),
+(73,5,'Mathias123961 & Sir Spawn Alot',8,'2011-08-01'),
+(73,5,'Schlepian & Lemonsunshine',7,'2011-11-01'),
+(73,5,'DM_ & LsDK_',6,'2018-01-01'),
+(73,5,'Krzyhau & Klooger',4,'2018-11-01'),
+(74,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(74,5,'Stimich & Pitkakorva',7,'2011-10-11'),
+(74,5,'Schlepian & Isimmo',3,'2011-10-28'),
+(74,5,'Zypeh & szeimartin',2,'2013-11-01'),
+(75,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(75,5,'Schlepian & Urination',4,'2011-10-01'),
+(75,5,'Schlepian & Lemonsunshine',2,'2012-02-01'),
+(75,5,'DM_ & follon',0,'2015-04-01'),
+(76,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(76,5,'Chubfish & Exhale',0,'2011-12-01'),
+
+-- Chapter 3
+(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'),
+(79,1,'BiSaXa & Oryn',0,'2023-07-18'),
+(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'),
+(81,1,'Seal & Acuifex',2,'2023-12-27'),
+(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'),
+
+(77,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(78,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(78,5,'DM_ & marK',3,'2016-11-01'),
+(79,5,'ganonscrub & undefined',5,'2011-04-01'),
+(79,5,'Bgr & mongfish',4,'2011-04-23'),
+(79,5,'Chubfish & Exhale',2,'2012-08-04'),
+(79,5,'BiSaXa & Oryn',0,'2023-07-18'),
+(80,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(80,5,'Chubfish & Exhale',4,'2011-12-01'),
+(81,5,'Mathias123961 & Sir Spawn Alot',7,'2011-08-01'),
+(81,5,'Schlepian & Lemonsunshine',6,'2011-10-01'),
+(81,5,'takz & dawn',5,'2011-11-01'),
+(81,5,'Nidboj132 & Oryn',4,'2024-01-06'),
+(82,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(83,5,'Mathias123961 & Sir Spawn Alot',5,'2011-08-01'),
+(83,5,'Schlepian & Lemonsunshine',2,'2011-10-01'),
+(83,5,'Chubfish & Exhale',0,'2011-12-01'),
+(84,5,'Mathias123961 & Sir Spawn Alot',6,'2011-08-01'),
+(84,5,'Schlepian & Chubfish',4,'2011-10-01'),
+(84,5,'Chubfish & Exhale',2,'2012-01-01'),
+(84,5,'DM_ & wS',0,'2015-05-01'),
+
+-- Chapter 4
+(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'),
+
+(85,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(85,5,'Chubfish & Exhale',0,'2011-10-01'),
+(86,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(86,5,'Chubfish & Exhale',0,'2011-12-01'),
+(87,5,'Mathias123961 & Sir Spawn Alot',3,'2011-08-01'),
+(87,5,'Schlepian & Gopherdude',2,'2011-10-01'),
+(87,5,'DM_ & follon',0,'2015-04-01'),
+(88,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(88,5,'Schlepian & Gopherdude',0,'2011-10-01'),
+(89,5,'Mathias123961 & Sir Spawn Alot',0,'2011-08-01'),
+(90,5,'Mathias123961 & Sir Spawn Alot',4,'2011-09-01'),
+(90,5,'Schlepian & Urination',2,'2011-10-01'),
+(90,5,'Klooger & Jetwash',0,'2016-02-01'),
+(91,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
+(91,5,'Undead & Zypeh',0,'2013-05-19'),
+(92,5,'txx478 & undefined',5,'2011-05-01'),
+(92,5,'Mathias123961 & Sir Spawn Alot',4,'2011-08-01'),
+(92,5,'Schlepian & Gopherdude',2,'2011-10-01'),
+(92,5,'ncla & takz',0,'2012-02-01'),
+(93,5,'Mathias123961 & Sir Spawn Alot',2,'2011-08-01'),
+(93,5,'Schlepian & Gopherdude',0,'2011-10-01'),
+
+-- Chapter 5
+(94,1,'Chubfish & Exhale',2,'2011-10-01'),
+(94,1,'Klooger & Imanex',0,'2013-08-01'),
+(95,1,'Schlepian & Issimoi',2,'2011-10-01'),
+(95,1,'Seal & Acuifex',0,'2024-02-13'),
+(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'),
+
+(94,5,'Chubfish & Exhale',2,'2011-10-01'),
+(94,5,'Klooger & Imanex',0,'2013-08-01'),
+(95,5,'Schlepian & Issimoi',2,'2011-10-01'),
+(96,5,'ThePortalPatrol & undefined',4,'2011-04-01'),
+(96,5,'sparkle1princess & Zypeh',2,'2014-01-01'),
+(97,5,'Stimich & HiTMaRkS',7,'2011-05-13'),
+(97,5,'Schlepian & Lemonsunshine',4,'2011-10-01'),
+(97,5,'DM_ & wS',2,'2014-05-01'),
+(98,5,'Imanex & 00svo',0,'2011-11-01'),
+(99,5,'Schlepian & Gopherdude',3,'2011-10-01'),
+(99,5,'Imanex & Klooger',2,'2013-08-01'),
+(99,5,'DM_ & wS',0,'2015-05-01'),
+(100,5,'Schlepian & Bananasaurus Rex',0,'2011-10-01'),
+(101,5,'Chubfish & Exhale',2,'2011-12-01'),
+(101,5,'DM_ & follon',0,'2015-04-01'),
+
+-- Chapter 6
+(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'),
+
+(102,5,'dawn & takz',3,'2011-11-18'),
+(102,5,'Chubfish & Exhale',2,'2012-01-01'),
+(102,5,'Imanex & Klooger',0,'2013-08-01'),
+(103,5,'Schlepian & Lemonsunshine',0,'2011-10-01'),
+(104,5,'Schlepian & Lemonsunshine',0,'2011-10-01'),
+(105,5,'Blaizerazer & undefined',8,'2011-10-01'),
+(105,5,'Schlepian & Lemonsunshine',5,'2011-11-01'),
+(105,5,'Imanex & Klooger',4,'2013-08-01'),
+(105,5,'DM_ & wS',3,'2014-05-01'),
+(105,5,'DM_ & follon',2,'2015-04-01'),
+(106,5,'Schlepian & Bananasaurus Rex',4,'2011-10-01'),
+(106,5,'Gig & takz',3,'2012-06-01'),
+(106,5,'Unknown players',0,'2015-04-01'),
+(107,5,'Chubfish & Exhale',2,'2011-10-01'),
+(107,5,'DM_ & follon',0,'2015-04-01'),
+(108,5,'DaFox & P',0,'2011-12-01'),
+(109,5,'Schlepian & Tyronis',5,'2011-10-01'),
+(109,5,'Chubfish & Exhale',0,'2011-12-01'),
+(110,5,'Tyronis & mr.bob806',15,'2011-10-01'),
+(110,5,'Schlepian & Chubfish',6,'2011-11-01'),
+(110,5,'00svo & z1mb0bw4y',5,'2012-08-08'),
+(110,5,'00svo & z1mb0bw4y',4,'2012-08-10'),
+(110,5,'Klooger & z1mb0bw4y',2,'2014-02-01'),
+(110,5,'DM_ & follon',0,'2015-04-01');
\ No newline at end of file
diff --git a/backend/database/insert/maps.sql b/backend/database/insert/maps.sql
new file mode 100644
index 0000000..f0235fa
--- /dev/null
+++ b/backend/database/insert/maps.sql
@@ -0,0 +1,129 @@
+INSERT INTO maps(game_id, chapter_id, name, is_disabled, image) VALUES
+-- Portal 2 Singleplayer
+-- 1
+(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
+(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',false,''),
+(1,2,'Trust Fling',false,''),
+(1,2,'Pit Flings',false,''),
+(1,2,'Fizzler Intro',false,''),
+-- 3
+(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
+(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
+(1,5,'Turret Factory',false,''),
+(1,5,'Turret Sabotage',false,''),
+(1,5,'Neurotoxin Sabotage',false,''),
+(1,5,'Core',false,''),
+-- 6
+(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
+(1,7,'Propulsion Intro',false,''),
+(1,7,'Propulsion Flings',false,''),
+(1,7,'Conversion Intro',false,''),
+(1,7,'Three Gels',false,''),
+-- 8
+(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
+(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',true,''),
+(2,10,'Hub',true,''),
+-- 1
+(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
+(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
+(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
+(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
+(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
+(2,16,'Separation',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
diff --git a/backend/database/maps.sql b/backend/database/maps.sql
deleted file mode 100644
index 082c85a..0000000
--- a/backend/database/maps.sql
+++ /dev/null
@@ -1,129 +0,0 @@
-INSERT INTO maps(game_id, chapter_id, name, is_disabled, image) VALUES
--- Portal 2 Singleplayer
--- 1
-(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
-(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',false,''),
-(1,2,'Trust Fling',false,''),
-(1,2,'Pit Flings',false,''),
-(1,2,'Fizzler Intro',false,''),
--- 3
-(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
-(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
-(1,5,'Turret Factory',false,''),
-(1,5,'Turret Sabotage',false,''),
-(1,5,'Neurotoxin Sabotage',false,''),
-(1,5,'Core',false,''),
--- 6
-(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
-(1,7,'Propulsion Intro',false,''),
-(1,7,'Propulsion Flings',false,''),
-(1,7,'Conversion Intro',false,''),
-(1,7,'Three Gels',false,''),
--- 8
-(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
-(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',true,''),
-(2,10,'Hub',true,''),
--- 1
-(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
-(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
-(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
-(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
-(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
-(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
-- 
cgit v1.2.3