database: organize sql files

6 files changed, 1256 insertions, 0 deletions

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