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"),
(140,"cf","caf","Afrika Erdiko Errepublika"),
(8,"al","alb","Albania"),
(276,"de","deu","Alemania"),
(12,"dz","dza","Aljeria"),
(20,"ad","and","Andorra"),
(24,"ao","ago","Angola"),
(784,"ae","are","Arabiar Emirerri Batuak"),
(28,"ag","atg","Antigua eta Barbuda"),
(32,"ar","arg","Argentina"),
(51,"am","arm","Armenia"),
(36,"au","aus","Australia"),
(40,"at","aut","Austria"),
(31,"az","aze","Azerbaijan"),
(44,"bs","bhs","Bahamak"),
(50,"bd","bgd","Bangladesh"),
(52,"bb","brb","Barbados"),
(48,"bh","bhr","Bahrain"),
(56,"be","bel","Belgika"),
(84,"bz","blz","Belize"),
(204,"bj","ben","Benin"),
(112,"by","blr","Bielorrusia"),
(384,"ci","civ","Boli Kosta"),
(68,"bo","bol","Bolivia"),
(70,"ba","bih","Bosnia-Herzegovina"),
(72,"bw","bwa","Botswana"),
(76,"br","bra","Brasil"),
(96,"bn","brn","Brunei"),
(100,"bg","bgr","Bulgaria"),
(854,"bf","bfa","Burkina Faso"),
(108,"bi","bdi","Burundi"),
(64,"bt","btn","Bhutan"),
(208,"dk","dnk","Danimarka"),
(262,"dj","dji","Djibuti"),
(212,"dm","dma","Dominika"),
(214,"do","dom","Dominikar Errepublika"),
(818,"eg","egy","Egipto"),
(626,"tl","tls","Ekialdeko Timor"),
(218,"ec","ecu","Ekuador"),
(226,"gq","gnq","Ekuatore Ginea"),
(232,"er","eri","Eritrea"),
(826,"gb","gbr","Erresuma Batua"),
(642,"ro","rou","Errumania"),
(643,"ru","rus","Errusia"),
(703,"sk","svk","Eslovakia"),
(705,"si","svn","Eslovenia"),
(724,"es","esp","Espainia"),
(840,"us","usa","AEB"),
(233,"ee","est","Estonia"),
(231,"et","eth","Etiopia"),
(242,"fj","fji","Fiji"),
(608,"ph","phl","Filipinak"),
(246,"fi","fin","Finlandia"),
(250,"fr","fra","Frantzia"),
(266,"ga","gab","Gabon"),
(270,"gm","gmb","Gambia"),
(268,"ge","geo","Georgia"),
(288,"gh","gha","Ghana"),
(324,"gn","gin","Ginea"),
(624,"gw","gnb","Ginea-Bissau"),
(308,"gd","grd","Grenada"),
(300,"gr","grc","Grezia"),
(320,"gt","gtm","Guatemala"),
(328,"gy","guy","Guyana"),
(332,"ht","hti","Haiti"),
(710,"za","zaf","Hegoafrika"),
(410,"kr","kor","Hego Korea"),
(728,"ss","ssd","Hego Sudan"),
(528,"nl","nld","Herbehereak"),
(340,"hn","hnd","Honduras"),
(348,"hu","hun","Hungaria"),
(356,"in","ind","India"),
(360,"id","idn","Indonesia"),
(408,"kp","prk","Ipar Korea"),
(368,"iq","irq","Irak"),
(364,"ir","irn","Iran"),
(372,"ie","irl","Irlandako Errepublika"),
(352,"is","isl","Islandia"),
(376,"il","isr","Israel"),
(380,"it","ita","Italia"),
(388,"jm","jam","Jamaika"),
(392,"jp","jpn","Japonia"),
(400,"jo","jor","Jordania"),
(132,"cv","cpv","Cabo Verde"),
(120,"cm","cmr","Kamerun"),
(124,"ca","can","Kanada"),
(116,"kh","khm","Kanbodia"),
(398,"kz","kaz","Kazakhstan"),
(404,"ke","ken","Kenya"),
(417,"kg","kgz","Kirgizistan"),
(296,"ki","kir","Kiribati"),
(170,"co","col","Kolonbia"),
(174,"km","com","Komoreak"),
(178,"cg","cog","Kongoko Errepublika"),
(180,"cd","cod","Kongoko Errepublika Demokratikoa"),
(188,"cr","cri","Costa Rica"),
(191,"hr","hrv","Kroazia"),
(192,"cu","cub","Kuba"),
(414,"kw","kwt","Kuwait"),
(418,"la","lao","Laos"),
(426,"ls","lso","Lesotho"),
(428,"lv","lva","Letonia"),
(422,"lb","lbn","Libano"),
(430,"lr","lbr","Liberia"),
(434,"ly","lby","Libia"),
(438,"li","lie","Liechtenstein"),
(440,"lt","ltu","Lituania"),
(442,"lu","lux","Luxenburgo"),
(450,"mg","mdg","Madagaskar"),
(807,"mk","mkd","Ipar Mazedonia"),
(458,"my","mys","Malaysia"),
(454,"mw","mwi","Malawi"),
(462,"mv","mdv","Maldivak"),
(466,"ml","mli","Mali"),
(470,"mt","mlt","Malta"),
(504,"ma","mar","Maroko"),
(584,"mh","mhl","Marshall Uharteak"),
(478,"mr","mrt","Mauritania"),
(480,"mu","mus","Maurizio"),
(484,"mx","mex","Mexiko"),
(583,"fm","fsm","Mikronesiako Estatu Federatuak"),
(498,"md","mda","Moldavia"),
(492,"mc","mco","Monako"),
(496,"mn","mng","Mongolia"),
(499,"me","mne","Montenegro"),
(508,"mz","moz","Mozambike"),
(104,"mm","mmr","Myanmar"),
(516,"na","nam","Namibia"),
(520,"nr","nru","Nauru"),
(524,"np","npl","Nepal"),
(562,"ne","ner","Niger"),
(566,"ng","nga","Nigeria"),
(558,"ni","nic","Nikaragua"),
(578,"no","nor","Norvegia"),
(512,"om","omn","Oman"),
(586,"pk","pak","Pakistan"),
(585,"pw","plw","Palau"),
(591,"pa","pan","Panama"),
(598,"pg","png","Papua Ginea Berria"),
(600,"py","pry","Paraguai"),
(604,"pe","per","Peru"),
(616,"pl","pol","Polonia"),
(620,"pt","prt","Portugal"),
(634,"qa","qat","Qatar"),
(646,"rw","rwa","Ruanda"),
(222,"sv","slv","El Salvador"),
(90,"sb","slb","Salomon Uharteak"),
(882,"ws","wsm","Samoa"),
(670,"vc","vct","Saint Vincent eta Grenadinak"),
(659,"kn","kna","Saint Kitts eta Nevis"),
(674,"sm","smr","San Marino"),
(678,"st","stp","Sao Tome eta Principe"),
(662,"lc","lca","Santa Luzia"),
(682,"sa","sau","Saudi Arabia"),
(686,"sn","sen","Senegal"),
(688,"rs","srb","Serbia"),
(690,"sc","syc","Seychelleak"),
(694,"sl","sle","Sierra Leona"),
(702,"sg","sgp","Singapur"),
(760,"sy","syr","Siria"),
(706,"so","som","Somalia"),
(144,"lk","lka","Sri Lanka"),
(748,"sz","swz","Eswatini"),
(729,"sd","sdn","Sudan"),
(752,"se","swe","Suedia"),
(756,"ch","che","Suitza"),
(740,"sr","sur","Surinam"),
(764,"th","tha","Thailandia"),
(762,"tj","tjk","Tajikistan"),
(834,"tz","tza","Tanzania"),
(768,"tg","tgo","Togo"),
(776,"to","ton","Tonga"),
(780,"tt","tto","Trinidad eta Tobago"),
(788,"tn","tun","Tunisia"),
(792,"tr","tur","Turkia"),
(795,"tm","tkm","Turkmenistan"),
(798,"tv","tuv","Tuvalu"),
(148,"td","tcd","Txad"),
(203,"cz","cze","Txekia"),
(152,"cl","chl","Txile"),
(156,"cn","chn","Txina"),
(800,"ug","uga","Uganda"),
(804,"ua","ukr","Ukraina"),
(858,"uy","ury","Uruguai"),
(860,"uz","uzb","Uzbekistan"),
(548,"vu","vut","Vanuatu"),
(862,"ve","ven","Venezuela"),
(704,"vn","vnm","Vietnam"),
(887,"ye","yem","Yemen"),
(894,"zm","zmb","Zambia"),
(554,"nz","nzl","Zeelanda Berria"),
(716,"zw","zwe","Zimbabwe"),
(196,"cy","cyp","Zipre")