SET NAMES utf8;

DROP TABLE IF EXISTS `countries`;

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `alpha_2` char(2) NOT NULL DEFAULT "",
  `alpha_3` char(3) NOT NULL DEFAULT "",
  `name` varchar(75) NOT NULL DEFAULT "",
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

INSERT INTO `countries` (`id`, `alpha_2`, `alpha_3`, `name`) VALUES
(4,"af","afg","Afganistan"),
(8,"al","alb","Albánsko"),
(12,"dz","dza","Alžírsko"),
(20,"ad","and","Andorra"),
(24,"ao","ago","Angola"),
(28,"ag","atg","Antigua a Barbuda"),
(32,"ar","arg","Argentína"),
(51,"am","arm","Arménsko"),
(36,"au","aus","Austrália"),
(31,"az","aze","Azerbajdžan"),
(44,"bs","bhs","Bahamy"),
(48,"bh","bhr","Bahrajn"),
(50,"bd","bgd","Bangladéš"),
(52,"bb","brb","Barbados"),
(56,"be","bel","Belgicko"),
(84,"bz","blz","Belize"),
(204,"bj","ben","Benin"),
(64,"bt","btn","Bhután"),
(112,"by","blr","Bielorusko"),
(68,"bo","bol","Bolívia"),
(70,"ba","bih","Bosna a Hercegovina"),
(72,"bw","bwa","Botswana"),
(76,"br","bra","Brazília"),
(96,"bn","brn","Brunej"),
(100,"bg","bgr","Bulharsko"),
(854,"bf","bfa","Burkina"),
(108,"bi","bdi","Burundi"),
(196,"cy","cyp","Cyprus"),
(148,"td","tcd","Čad"),
(203,"cz","cze","Česko"),
(499,"me","mne","Čierna Hora"),
(152,"cl","chl","Čile"),
(156,"cn","chn","Čína"),
(208,"dk","dnk","Dánsko"),
(212,"dm","dma","Dominika"),
(214,"do","dom","Dominikánska republika"),
(262,"dj","dji","Džibutsko"),
(818,"eg","egy","Egypt"),
(218,"ec","ecu","Ekvádor"),
(232,"er","eri","Eritrea"),
(233,"ee","est","Estónsko"),
(231,"et","eth","Etiópia"),
(242,"fj","fji","Fidži"),
(608,"ph","phl","Filipíny"),
(246,"fi","fin","Fínsko"),
(250,"fr","fra","Francúzsko"),
(266,"ga","gab","Gabon"),
(270,"gm","gmb","Gambia"),
(288,"gh","gha","Ghana"),
(300,"gr","grc","Grécko"),
(308,"gd","grd","Grenada"),
(268,"ge","geo","Gruzínsko"),
(320,"gt","gtm","Guatemala"),
(324,"gn","gin","Guinea"),
(624,"gw","gnb","Guinea-Bissau"),
(328,"gy","guy","Guyana"),
(332,"ht","hti","Haiti"),
(528,"nl","nld","Holandsko"),
(340,"hn","hnd","Honduras"),
(191,"hr","hrv","Chorvátsko"),
(356,"in","ind","India"),
(360,"id","idn","Indonézia"),
(364,"ir","irn","Irán"),
(368,"iq","irq","Irak"),
(372,"ie","irl","Írsko"),
(352,"is","isl","Island"),
(376,"il","isr","Izrael"),
(388,"jm","jam","Jamajka"),
(392,"jp","jpn","Japonsko"),
(887,"ye","yem","Jemen"),
(400,"jo","jor","Jordánsko"),
(710,"za","zaf","Južná Afrika"),
(728,"ss","ssd","Južný Sudán"),
(116,"kh","khm","Kambodža"),
(120,"cm","cmr","Kamerun"),
(124,"ca","can","Kanada"),
(132,"cv","cpv","Kapverdy"),
(634,"qa","qat","Katar"),
(398,"kz","kaz","Kazachstan"),
(404,"ke","ken","Keňa"),
(417,"kg","kgz","Kirgizsko"),
(296,"ki","kir","Kiribati"),
(170,"co","col","Kolumbia"),
(174,"km","com","Komory"),
(178,"cg","cog","Kongo"),
(180,"cd","cod","Konžská demokratická republika"),
(408,"kp","prk","Kórejská ľudovodemokratická republika"),
(410,"kr","kor","Kórejská republika"),
(188,"cr","cri","Kostarika"),
(192,"cu","cub","Kuba"),
(414,"kw","kwt","Kuvajt"),
(418,"la","lao","Laos"),
(426,"ls","lso","Lesotho"),
(422,"lb","lbn","Libanon"),
(430,"lr","lbr","Libéria"),
(434,"ly","lby","Líbya"),
(438,"li","lie","Lichtenštajnsko"),
(440,"lt","ltu","Litva"),
(428,"lv","lva","Lotyšsko"),
(442,"lu","lux","Luxembursko"),
(807,"mk","mkd","Severné Macedónsko"),
(450,"mg","mdg","Madagaskar"),
(348,"hu","hun","Maďarsko"),
(458,"my","mys","Malajzia"),
(454,"mw","mwi","Malawi"),
(462,"mv","mdv","Maldivy"),
(466,"ml","mli","Mali"),
(470,"mt","mlt","Malta"),
(504,"ma","mar","Maroko"),
(584,"mh","mhl","Marshallove ostrovy"),
(480,"mu","mus","Maurícius"),
(478,"mr","mrt","Mauritánia"),
(484,"mx","mex","Mexiko"),
(583,"fm","fsm","Mikronézia"),
(104,"mm","mmr","Mjanmarsko"),
(498,"md","mda","Moldavsko"),
(492,"mc","mco","Monako"),
(496,"mn","mng","Mongolsko"),
(508,"mz","moz","Mozambik"),
(516,"na","nam","Namíbia"),
(520,"nr","nru","Nauru"),
(276,"de","deu","Nemecko"),
(524,"np","npl","Nepál"),
(562,"ne","ner","Niger"),
(566,"ng","nga","Nigéria"),
(558,"ni","nic","Nikaragua"),
(578,"no","nor","Nórsko"),
(554,"nz","nzl","Nový Zéland"),
(512,"om","omn","Omán"),
(586,"pk","pak","Pakistan"),
(585,"pw","plw","Palau"),
(591,"pa","pan","Panama"),
(598,"pg","png","Papua-Nová Guinea"),
(600,"py","pry","Paraguaj"),
(604,"pe","per","Peru"),
(384,"ci","civ","Pobrežie Slonoviny"),
(616,"pl","pol","Poľsko"),
(620,"pt","prt","Portugalsko"),
(40,"at","aut","Rakúsko"),
(226,"gq","gnq","Rovníková Guinea"),
(642,"ro","rou","Rumunsko"),
(643,"ru","rus","Rusko"),
(646,"rw","rwa","Rwanda"),
(222,"sv","slv","Salvádor"),
(882,"ws","wsm","Samoa"),
(674,"sm","smr","San Maríno"),
(682,"sa","sau","Saudská Arábia"),
(686,"sn","sen","Senegal"),
(690,"sc","syc","Seychely"),
(694,"sl","sle","Sierra Leone"),
(702,"sg","sgp","Singapur"),
(703,"sk","svk","Slovensko"),
(705,"si","svn","Slovinsko"),
(706,"so","som","Somálsko"),
(784,"ae","are","Spojené arabské emiráty"),
(826,"gb","gbr","Spojené kráľovstvo"),
(840,"us","usa","Spojené štáty"),
(688,"rs","srb","Srbsko"),
(144,"lk","lka","Srí Lanka"),
(140,"cf","caf","Stredoafrická republika"),
(729,"sd","sdn","Sudán"),
(740,"sr","sur","Surinam"),
(662,"lc","lca","Svätá Lucia"),
(659,"kn","kna","Svätý Krištof a Nevis"),
(678,"st","stp","Svätý Tomáš a Princov ostrov"),
(670,"vc","vct","Svätý Vincent a Grenadíny"),
(748,"sz","swz","Svazijsko"),
(760,"sy","syr","Sýria"),
(90,"sb","slb","Šalamúnove ostrovy"),
(724,"es","esp","Španielsko"),
(756,"ch","che","Švajčiarsko"),
(752,"se","swe","Švédsko"),
(762,"tj","tjk","Tadžikistan"),
(380,"it","ita","Taliansko"),
(834,"tz","tza","Tanzánia"),
(764,"th","tha","Thajsko"),
(768,"tg","tgo","Togo"),
(776,"to","ton","Tonga"),
(780,"tt","tto","Trinidad a Tobago"),
(788,"tn","tun","Tunisko"),
(792,"tr","tur","Turecko"),
(795,"tm","tkm","Turkménsko"),
(798,"tv","tuv","Tuvalu"),
(800,"ug","uga","Uganda"),
(804,"ua","ukr","Ukrajina"),
(858,"uy","ury","Uruguaj"),
(860,"uz","uzb","Uzbekistan"),
(548,"vu","vut","Vanuatu"),
(862,"ve","ven","Venezuela"),
(704,"vn","vnm","Vietnam"),
(626,"tl","tls","Východný Timor"),
(894,"zm","zmb","Zambia"),
(716,"zw","zwe","Zimbabwe")