SET NAMES utf8;

DROP TABLE IF EXISTS `world`;

CREATE TABLE `world` (
  `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 `world` (`id`, `alpha_2`, `alpha_3`, `name`) VALUES
(4,"af","afg","Afganistán"),
(248,"ax","ala","Åland"),
(8,"al","alb","Albania"),
(276,"de","deu","Alemania"),
(20,"ad","and","Andorra"),
(24,"ao","ago","Angola"),
(660,"ai","aia","Anguila"),
(10,"aq","ata","Antártida"),
(28,"ag","atg","Antigua y Barbuda"),
(682,"sa","sau","Arabia Saudita"),
(12,"dz","dza","Argelia"),
(32,"ar","arg","Argentina"),
(51,"am","arm","Armenia"),
(533,"aw","abw","Aruba"),
(36,"au","aus","Australia"),
(40,"at","aut","Austria"),
(31,"az","aze","Azerbaiyán"),
(44,"bs","bhs","Bahamas"),
(50,"bd","bgd","Bangladés"),
(52,"bb","brb","Barbados"),
(48,"bh","bhr","Baréin"),
(56,"be","bel","Bélgica"),
(84,"bz","blz","Belice"),
(204,"bj","ben","Benín"),
(60,"bm","bmu","Bermudas"),
(112,"by","blr","Bielorrusia"),
(68,"bo","bol","Bolivia"),
(535,"bq","bes","Bonaire, San Eustaquio y Saba"),
(70,"ba","bih","Bosnia y Herzegovina"),
(72,"bw","bwa","Botsuana"),
(76,"br","bra","Brasil"),
(96,"bn","brn","Brunéi"),
(100,"bg","bgr","Bulgaria"),
(854,"bf","bfa","Burkina Faso"),
(108,"bi","bdi","Burundi"),
(64,"bt","btn","Bután"),
(132,"cv","cpv","Cabo Verde"),
(116,"kh","khm","Camboya"),
(120,"cm","cmr","Camerún"),
(124,"ca","can","Canadá"),
(634,"qa","qat","Catar"),
(148,"td","tcd","Chad"),
(152,"cl","chl","Chile"),
(156,"cn","chn","China"),
(196,"cy","cyp","Chipre"),
(170,"co","col","Colombia"),
(174,"km","com","Comoras"),
(408,"kp","prk","Corea del Norte"),
(410,"kr","kor","Corea del Sur"),
(384,"ci","civ","Costa de Marfil"),
(188,"cr","cri","Costa Rica"),
(191,"hr","hrv","Croacia"),
(192,"cu","cub","Cuba"),
(531,"cw","cuw","Curazao"),
(208,"dk","dnk","Dinamarca"),
(212,"dm","dma","Dominica"),
(218,"ec","ecu","Ecuador"),
(818,"eg","egy","Egipto"),
(222,"sv","slv","El Salvador"),
(784,"ae","are","Emiratos Árabes Unidos"),
(232,"er","eri","Eritrea"),
(703,"sk","svk","Eslovaquia"),
(705,"si","svn","Eslovenia"),
(724,"es","esp","España"),
(840,"us","usa","Estados Unidos"),
(233,"ee","est","Estonia"),
(231,"et","eth","Etiopía"),
(608,"ph","phl","Filipinas"),
(246,"fi","fin","Finlandia"),
(242,"fj","fji","Fiyi"),
(250,"fr","fra","Francia"),
(266,"ga","gab","Gabón"),
(270,"gm","gmb","Gambia"),
(268,"ge","geo","Georgia"),
(288,"gh","gha","Ghana"),
(292,"gi","gib","Gibraltar"),
(308,"gd","grd","Granada"),
(300,"gr","grc","Grecia"),
(304,"gl","grl","Groenlandia"),
(312,"gp","glp","Guadalupe"),
(316,"gu","gum","Guam"),
(320,"gt","gtm","Guatemala"),
(254,"gf","guf","Guayana Francesa"),
(831,"gg","ggy","Guernsey"),
(324,"gn","gin","Guinea"),
(624,"gw","gnb","Guinea-Bisáu"),
(226,"gq","gnq","Guinea Ecuatorial"),
(328,"gy","guy","Guyana"),
(332,"ht","hti","Haití"),
(340,"hn","hnd","Honduras"),
(344,"hk","hkg","Hong Kong"),
(348,"hu","hun","Hungría"),
(356,"in","ind","India"),
(360,"id","idn","Indonesia"),
(368,"iq","irq","Irak"),
(364,"ir","irn","Irán"),
(372,"ie","irl","Irlanda"),
(74,"bv","bvt","Isla Bouvet"),
(833,"im","imn","Isla de Man"),
(162,"cx","cxr","Isla de Navidad"),
(352,"is","isl","Islandia"),
(136,"ky","cym","Islas Caimán"),
(166,"cc","cck","Islas Cocos"),
(184,"ck","cok","Islas Cook"),
(234,"fo","fro","Islas Feroe"),
(239,"gs","sgs","Islas Georgias del Sur y Sandwich del Sur"),
(334,"hm","hmd","Islas Heard y McDonald"),
(238,"fk","flk","Islas Malvinas"),
(580,"mp","mnp","Islas Marianas del Norte"),
(584,"mh","mhl","Islas Marshall"),
(612,"pn","pcn","Islas Pitcairn"),
(90,"sb","slb","Islas Salomón"),
(796,"tc","tca","Islas Turcas y Caicos"),
(581,"um","umi","Islas Ultramarinas Menores de los Estados Unidos"),
(92,"vg","vgb","Islas Vírgenes Británicas"),
(850,"vi","vir","Islas Vírgenes de los Estados Unidos"),
(376,"il","isr","Israel"),
(380,"it","ita","Italia"),
(388,"jm","jam","Jamaica"),
(392,"jp","jpn","Japón"),
(832,"je","jey","Jersey"),
(400,"jo","jor","Jordania"),
(398,"kz","kaz","Kazajistán"),
(404,"ke","ken","Kenia"),
(417,"kg","kgz","Kirguistán"),
(296,"ki","kir","Kiribati"),
(414,"kw","kwt","Kuwait"),
(418,"la","lao","Laos"),
(426,"ls","lso","Lesoto"),
(428,"lv","lva","Letonia"),
(422,"lb","lbn","Líbano"),
(430,"lr","lbr","Liberia"),
(434,"ly","lby","Libia"),
(438,"li","lie","Liechtenstein"),
(440,"lt","ltu","Lituania"),
(442,"lu","lux","Luxemburgo"),
(446,"mo","mac","Macao"),
(807,"mk","mkd","Macedonia del Norte"),
(450,"mg","mdg","Madagascar"),
(458,"my","mys","Malasia"),
(454,"mw","mwi","Malaui"),
(462,"mv","mdv","Maldivas"),
(466,"ml","mli","Mali"),
(470,"mt","mlt","Malta"),
(504,"ma","mar","Marruecos"),
(474,"mq","mtq","Martinica"),
(480,"mu","mus","Mauricio"),
(478,"mr","mrt","Mauritania"),
(175,"yt","myt","Mayotte"),
(484,"mx","mex","México"),
(583,"fm","fsm","Micronesia"),
(498,"md","mda","Moldavia"),
(492,"mc","mco","Mónaco"),
(496,"mn","mng","Mongolia"),
(499,"me","mne","Montenegro"),
(500,"ms","msr","Montserrat"),
(508,"mz","moz","Mozambique"),
(104,"mm","mmr","Birmania"),
(516,"na","nam","Namibia"),
(520,"nr","nru","Nauru"),
(524,"np","npl","Nepal"),
(558,"ni","nic","Nicaragua"),
(562,"ne","ner","Níger"),
(566,"ng","nga","Nigeria"),
(570,"nu","niu","Niue"),
(574,"nf","nfk","Isla Norfolk"),
(578,"no","nor","Noruega"),
(540,"nc","ncl","Nueva Caledonia"),
(554,"nz","nzl","Nueva Zelanda"),
(512,"om","omn","Omán"),
(528,"nl","nld","Países Bajos"),
(586,"pk","pak","Pakistán"),
(585,"pw","plw","Palaos"),
(275,"ps","pse","Palestina"),
(591,"pa","pan","Panamá"),
(598,"pg","png","Papúa Nueva Guinea"),
(600,"py","pry","Paraguay"),
(604,"pe","per","Perú"),
(258,"pf","pyf","Polinesia Francesa"),
(616,"pl","pol","Polonia"),
(620,"pt","prt","Portugal"),
(630,"pr","pri","Puerto Rico"),
(826,"gb","gbr","Reino Unido"),
(732,"eh","esh","República Árabe Saharaui Democrática"),
(140,"cf","caf","República Centroafricana"),
(203,"cz","cze","República Checa"),
(178,"cg","cog","República del Congo"),
(180,"cd","cod","República Democrática del Congo"),
(214,"do","dom","República Dominicana"),
(638,"re","reu","Reunión"),
(646,"rw","rwa","Ruanda"),
(642,"ro","rou","Rumania"),
(643,"ru","rus","Rusia"),
(882,"ws","wsm","Samoa"),
(16,"as","asm","Samoa Americana"),
(652,"bl","blm","San Bartolomé"),
(659,"kn","kna","San Cristóbal y Nieves"),
(674,"sm","smr","San Marino"),
(663,"mf","maf","San Martín"),
(666,"pm","spm","San Pedro y Miquelón"),
(670,"vc","vct","San Vicente y las Granadinas"),
(654,"sh","shn","Santa Elena, Ascensión y Tristán de Acuña"),
(662,"lc","lca","Santa Lucía"),
(678,"st","stp","Santo Tomé y Príncipe"),
(686,"sn","sen","Senegal"),
(688,"rs","srb","Serbia"),
(690,"sc","syc","Seychelles"),
(694,"sl","sle","Sierra Leona"),
(702,"sg","sgp","Singapur"),
(534,"sx","sxm","San Martín"),
(760,"sy","syr","Siria"),
(706,"so","som","Somalia"),
(144,"lk","lka","Sri Lanka"),
(748,"sz","swz","Suazilandia"),
(710,"za","zaf","Sudáfrica"),
(729,"sd","sdn","Sudán"),
(728,"ss","ssd","Sudán del Sur"),
(752,"se","swe","Suecia"),
(756,"ch","che","Suiza"),
(740,"sr","sur","Surinam"),
(744,"sj","sjm","Svalbard y Jan Mayen"),
(764,"th","tha","Tailandia"),
(158,"tw","twn","Taiwán (República de China)"),
(834,"tz","tza","Tanzania"),
(762,"tj","tjk","Tayikistán"),
(86,"io","iot","Territorio Británico del Océano Índico"),
(260,"tf","atf","Tierras Australes y Antárticas Francesas"),
(626,"tl","tls","Timor Oriental"),
(768,"tg","tgo","Togo"),
(772,"tk","tkl","Tokelau"),
(776,"to","ton","Tonga"),
(780,"tt","tto","Trinidad y Tobago"),
(788,"tn","tun","Túnez"),
(795,"tm","tkm","Turkmenistán"),
(792,"tr","tur","Turquía"),
(798,"tv","tuv","Tuvalu"),
(804,"ua","ukr","Ucrania"),
(800,"ug","uga","Uganda"),
(858,"uy","ury","Uruguay"),
(860,"uz","uzb","Uzbekistán"),
(548,"vu","vut","Vanuatu"),
(336,"va","vat","Vaticano, Ciudad del"),
(862,"ve","ven","Venezuela"),
(704,"vn","vnm","Vietnam"),
(876,"wf","wlf","Wallis y Futuna"),
(887,"ye","yem","Yemen"),
(262,"dj","dji","Yibuti"),
(894,"zm","zmb","Zambia"),
(716,"zw","zwe","Zimbabue")