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","Albania"),
(12,"dz","dza","Algeria"),
(20,"ad","and","Andorra"),
(24,"ao","ago","Angola"),
(28,"ag","atg","Antigua și Barbuda"),
(32,"ar","arg","Argentina"),
(51,"am","arm","Armenia"),
(36,"au","aus","Australia"),
(40,"at","aut","Austria"),
(31,"az","aze","Azerbaidjan"),
(44,"bs","bhs","Bahamas"),
(48,"bh","bhr","Bahrain"),
(50,"bd","bgd","Bangladesh"),
(52,"bb","brb","Barbados"),
(112,"by","blr","Belarus"),
(56,"be","bel","Belgia"),
(84,"bz","blz","Belize"),
(204,"bj","ben","Benin"),
(64,"bt","btn","Bhutan"),
(68,"bo","bol","Bolivia"),
(70,"ba","bih","Bosnia și Herțegovina"),
(72,"bw","bwa","Botswana"),
(76,"br","bra","Brazilia"),
(96,"bn","brn","Brunei"),
(100,"bg","bgr","Bulgaria"),
(854,"bf","bfa","Burkina Faso"),
(108,"bi","bdi","Burundi"),
(116,"kh","khm","Cambodgia"),
(120,"cm","cmr","Camerun"),
(124,"ca","can","Canada"),
(132,"cv","cpv","Republica Capului Verde"),
(140,"cf","caf","Republica Centrafricană"),
(148,"td","tcd","Ciad"),
(152,"cl","chl","Chile"),
(156,"cn","chn","Republica Populară Chineză"),
(170,"co","col","Columbia"),
(174,"km","com","Comore"),
(178,"cg","cog","Congo"),
(180,"cd","cod","Republica Democrată Congo"),
(188,"cr","cri","Costa Rica"),
(384,"ci","civ","Coasta de Fildeș"),
(191,"hr","hrv","Croația"),
(192,"cu","cub","Cuba"),
(196,"cy","cyp","Cipru"),
(203,"cz","cze","Cehia"),
(208,"dk","dnk","Danemarca"),
(262,"dj","dji","Djibouti"),
(212,"dm","dma","Dominica"),
(214,"do","dom","Republica Dominicană"),
(218,"ec","ecu","Ecuador"),
(818,"eg","egy","Egipt"),
(222,"sv","slv","El Salvador"),
(226,"gq","gnq","Guineea Ecuatorială"),
(232,"er","eri","Eritreea"),
(233,"ee","est","Estonia"),
(748,"sz","swz","Eswatini"),
(231,"et","eth","Etiopia"),
(242,"fj","fji","Fiji"),
(246,"fi","fin","Finlanda"),
(250,"fr","fra","Franța"),
(266,"ga","gab","Gabon"),
(270,"gm","gmb","Gambia"),
(268,"ge","geo","Georgia"),
(276,"de","deu","Germania"),
(288,"gh","gha","Ghana"),
(300,"gr","grc","Grecia"),
(308,"gd","grd","Grenada"),
(320,"gt","gtm","Guatemala"),
(324,"gn","gin","Guineea"),
(624,"gw","gnb","Guineea-Bissau"),
(328,"gy","guy","Guyana"),
(332,"ht","hti","Haiti"),
(340,"hn","hnd","Honduras"),
(348,"hu","hun","Ungaria"),
(352,"is","isl","Islanda"),
(356,"in","ind","India"),
(360,"id","idn","Indonezia"),
(364,"ir","irn","Iran"),
(368,"iq","irq","Irak"),
(372,"ie","irl","Republica Irlanda"),
(376,"il","isr","Israel"),
(380,"it","ita","Italia"),
(388,"jm","jam","Jamaica"),
(392,"jp","jpn","Japonia"),
(400,"jo","jor","Iordania"),
(398,"kz","kaz","Kazahstan"),
(404,"ke","ken","Kenya"),
(296,"ki","kir","Kiribati"),
(408,"kp","prk","Coreea de Nord"),
(410,"kr","kor","Coreea de Sud"),
(414,"kw","kwt","Kuweit"),
(417,"kg","kgz","Kârgâzstan"),
(418,"la","lao","Laos"),
(428,"lv","lva","Letonia"),
(422,"lb","lbn","Liban"),
(426,"ls","lso","Lesotho"),
(430,"lr","lbr","Liberia"),
(434,"ly","lby","Libia"),
(438,"li","lie","Liechtenstein"),
(440,"lt","ltu","Lituania"),
(442,"lu","lux","Luxemburg"),
(807,"mk","mkd","Macedonia de Nord"),
(450,"mg","mdg","Madagascar"),
(454,"mw","mwi","Malawi"),
(458,"my","mys","Malaezia"),
(462,"mv","mdv","Maldive"),
(466,"ml","mli","Mali"),
(470,"mt","mlt","Malta"),
(584,"mh","mhl","Insulele Marshall"),
(478,"mr","mrt","Mauritania"),
(480,"mu","mus","Mauritius"),
(484,"mx","mex","Mexic"),
(583,"fm","fsm","Micronezia"),
(498,"md","mda","Republica Moldova"),
(492,"mc","mco","Monaco"),
(496,"mn","mng","Mongolia"),
(499,"me","mne","Muntenegru"),
(504,"ma","mar","Maroc"),
(508,"mz","moz","Mozambic"),
(104,"mm","mmr","Myanmar"),
(516,"na","nam","Namibia"),
(520,"nr","nru","Nauru"),
(524,"np","npl","Nepal"),
(528,"nl","nld","Țările de Jos"),
(554,"nz","nzl","Noua Zeelandă"),
(558,"ni","nic","Nicaragua"),
(562,"ne","ner","Niger"),
(566,"ng","nga","Nigeria"),
(578,"no","nor","Norvegia"),
(512,"om","omn","Oman"),
(586,"pk","pak","Pakistan"),
(585,"pw","plw","Palau"),
(591,"pa","pan","Panama"),
(598,"pg","png","Papua Noua Guinee"),
(600,"py","pry","Paraguay"),
(604,"pe","per","Peru"),
(608,"ph","phl","Filipine"),
(616,"pl","pol","Polonia"),
(620,"pt","prt","Portugalia"),
(634,"qa","qat","Qatar"),
(642,"ro","rou","România"),
(643,"ru","rus","Rusia"),
(646,"rw","rwa","Rwanda"),
(659,"kn","kna","Sfântul Kitts și Nevis"),
(662,"lc","lca","Sfânta Lucia"),
(670,"vc","vct","Sfântul Vincent și Grenadine"),
(882,"ws","wsm","Samoa"),
(674,"sm","smr","San Marino"),
(678,"st","stp","Sao Tome și Principe"),
(682,"sa","sau","Arabia Saudită"),
(686,"sn","sen","Senegal"),
(688,"rs","srb","Serbia"),
(690,"sc","syc","Seychelles"),
(694,"sl","sle","Sierra Leone"),
(702,"sg","sgp","Singapore"),
(703,"sk","svk","Slovacia"),
(705,"si","svn","Slovenia"),
(90,"sb","slb","Insulele Solomon"),
(706,"so","som","Somalia"),
(710,"za","zaf","Africa de Sud"),
(724,"es","esp","Spania"),
(144,"lk","lka","Sri Lanka"),
(729,"sd","sdn","Sudan"),
(728,"ss","ssd","Sudanul de Sud"),
(740,"sr","sur","Surinam"),
(752,"se","swe","Suedia"),
(756,"ch","che","Elveția"),
(760,"sy","syr","Siria"),
(762,"tj","tjk","Tadjikistan"),
(834,"tz","tza","Tanzania"),
(764,"th","tha","Thailanda"),
(626,"tl","tls","Timorul de Est"),
(768,"tg","tgo","Togo"),
(776,"to","ton","Tonga"),
(780,"tt","tto","Trinidad și Tobago"),
(788,"tn","tun","Tunisia"),
(792,"tr","tur","Turcia"),
(795,"tm","tkm","Turkmenistan"),
(798,"tv","tuv","Tuvalu"),
(800,"ug","uga","Uganda"),
(804,"ua","ukr","Ucraina"),
(784,"ae","are","Emiratele Arabe Unite"),
(826,"gb","gbr","Regatul Unit"),
(840,"us","usa","Statele Unite ale Americii"),
(858,"uy","ury","Uruguay"),
(860,"uz","uzb","Uzbekistan"),
(548,"vu","vut","Vanuatu"),
(862,"ve","ven","Venezuela"),
(704,"vn","vnm","Vietnam"),
(887,"ye","yem","Yemen"),
(894,"zm","zmb","Zambia"),
(716,"zw","zwe","Zimbabwe")