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=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `world` (`id`, `alpha_2`, `alpha_3`, `name`) VALUES
(662,"lc","lca","Αγία Λουκία"),
(652,"bl","blm","Άγιος Βαρθολομαίος"),
(663,"mf","maf","Άγιος Μαρτίνος (Γαλλία)"),
(534,"sx","sxm","Άγιος Μαρτίνος (Ολλανδία)"),
(670,"vc","vct","Άγιος Βικέντιος και Γρεναδίνες"),
(674,"sm","smr","Άγιος Μαρίνος"),
(666,"pm","spm","Σαιν Πιερ και Μικελόν"),
(659,"kn","kna","Άγιος Χριστόφορος και Νέβις"),
(31,"az","aze","Αζερμπαϊτζάν"),
(818,"eg","egy","Αίγυπτος"),
(231,"et","eth","Αιθιοπία"),
(332,"ht","hti","Αϊτή"),
(384,"ci","civ","Ακτή Ελεφαντοστού"),
(8,"al","alb","Αλβανία"),
(12,"dz","dza","Αλγερία"),
(16,"as","asm","Αμερικανική Σαμόα"),
(626,"tl","tls","Ανατολικό Τιμόρ"),
(24,"ao","ago","Ανγκόλα"),
(660,"ai","aia","Ανγκουίλα"),
(20,"ad","and","Ανδόρρα"),
(10,"aq","ata","Ανταρκτική"),
(28,"ag","atg","Αντίγκουα και Μπαρμπούντα"),
(32,"ar","arg","Αργεντινή"),
(51,"am","arm","Αρμενία"),
(533,"aw","abw","Αρούμπα"),
(36,"au","aus","Αυστραλία"),
(40,"at","aut","Αυστρία"),
(4,"af","afg","Αφγανιστάν"),
(548,"vu","vut","Βανουάτου"),
(336,"va","vat","Βατικανό"),
(56,"be","bel","Βέλγιο"),
(862,"ve","ven","Βενεζουέλα"),
(60,"bm","bmu","Βερμούδες"),
(704,"vn","vnm","Βιετνάμ"),
(68,"bo","bol","Βολιβία"),
(408,"kp","prk","Βόρεια Κορέα"),
(70,"ba","bih","Βοσνία-Ερζεγοβίνη"),
(100,"bg","bgr","Βουλγαρία"),
(76,"br","bra","Βραζιλία"),
(86,"io","iot","Βρετανικό Έδαφος Ινδικού Ωκεανού"),
(92,"vg","vgb","Βρετανικές Παρθένοι Νήσοι"),
(250,"fr","fra","Γαλλία"),
(260,"tf","atf","Γαλλικά Νότια και Ανταρκτικά Εδάφη"),
(254,"gf","guf","Γαλλική Γουιάνα"),
(258,"pf","pyf","Γαλλική Πολυνησία"),
(276,"de","deu","Γερμανία"),
(268,"ge","geo","Γεωργία"),
(292,"gi","gib","Γιβραλτάρ"),
(270,"gm","gmb","Γκάμπια"),
(266,"ga","gab","Γκαμπόν"),
(288,"gh","gha","Γκάνα"),
(831,"gg","ggy","Γκέρνσεϊ"),
(316,"gu","gum","Γκουάμ"),
(312,"gp","glp","Γουαδελούπη"),
(320,"gt","gtm","Γουατεμάλα"),
(328,"gy","guy","Γουιάνα"),
(324,"gn","gin","Γουινέα"),
(624,"gw","gnb","Γουινέα-Μπισσάου"),
(308,"gd","grd","Γρενάδα"),
(304,"gl","grl","Γροιλανδία"),
(208,"dk","dnk","Δανία"),
(214,"do","dom","Δομινικανή Δημοκρατία"),
(275,"ps","pse","Δυτική Όχθη"),
(732,"eh","esh","Δυτική Σαχάρα"),
(222,"sv","slv","Ελ Σαλβαδόρ"),
(756,"ch","che","Ελβετία"),
(300,"gr","grc","Ελλάδα"),
(232,"er","eri","Ερυθραία"),
(233,"ee","est","Εσθονία"),
(894,"zm","zmb","Ζάμπια"),
(716,"zw","zwe","Ζιμπάμπουε"),
(784,"ae","are","Ηνωμένα Αραβικά Εμιράτα"),
(840,"us","usa","Ηνωμένες Πολιτείες Αμερικής"),
(581,"um","umi","Απομακρυσμένες Νησίδες των Ηνωμένων Πολιτειών"),
(826,"gb","gbr","Ηνωμένο Βασίλειο"),
(392,"jp","jpn","Ιαπωνία"),
(356,"in","ind","Ινδία"),
(360,"id","idn","Ινδονησία"),
(400,"jo","jor","Ιορδανία"),
(368,"iq","irq","Ιράκ"),
(364,"ir","irn","Ιράν"),
(372,"ie","irl","Ιρλανδία"),
(226,"gq","gnq","Ισημερινή Γουινέα"),
(218,"ec","ecu","Ισημερινός"),
(352,"is","isl","Ισλανδία"),
(724,"es","esp","Ισπανία"),
(376,"il","isr","Ισραήλ"),
(380,"it","ita","Ιταλία"),
(398,"kz","kaz","Καζακστάν"),
(120,"cm","cmr","Καμερούν"),
(116,"kh","khm","Καμπότζη"),
(124,"ca","can","Καναδάς"),
(634,"qa","qat","Κατάρ"),
(140,"cf","caf","Κεντροαφρικανική Δημοκρατία"),
(404,"ke","ken","Κένυα"),
(156,"cn","chn","Κίνα"),
(417,"kg","kgz","Κιργιζία"),
(296,"ki","kir","Κιριμπάτι"),
(178,"cg","cog","Κογκό"),
(170,"co","col","Κολομβία"),
(174,"km","com","Κομόρες"),
(188,"cr","cri","Κόστα Ρίκα"),
(192,"cu","cub","Κούβα"),
(414,"kw","kwt","Κουβέιτ"),
(531,"cw","cuw","Κουρασάο"),
(191,"hr","hrv","Κροατία"),
(196,"cy","cyp","Κύπρος"),
(180,"cd","cod","Λαϊκή Δημοκρατία του Κογκό"),
(418,"la","lao","Λάος"),
(426,"ls","lso","Λεσότο"),
(428,"lv","lva","Λεττονία"),
(112,"by","blr","Λευκορωσία"),
(422,"lb","lbn","Λίβανος"),
(430,"lr","lbr","Λιβερία"),
(434,"ly","lby","Λιβύη"),
(440,"lt","ltu","Λιθουανία"),
(438,"li","lie","Λίχτενσταϊν"),
(442,"lu","lux","Λουξεμβούργο"),
(175,"yt","myt","Μαγιότ"),
(450,"mg","mdg","Μαδαγασκάρη"),
(446,"mo","mac","Μακάο"),
(458,"my","mys","Μαλαισία"),
(454,"mw","mwi","Μαλάουι"),
(462,"mv","mdv","Μαλδίβες"),
(466,"ml","mli","Μάλι"),
(470,"mt","mlt","Μάλτα"),
(504,"ma","mar","Μαρόκο"),
(474,"mq","mtq","Μαρτινίκα"),
(480,"mu","mus","Μαυρίκιος"),
(478,"mr","mrt","Μαυριτανία"),
(499,"me","mne","Μαυροβούνιο"),
(484,"mx","mex","Μεξικό"),
(104,"mm","mmr","Μιανμάρ"),
(496,"mn","mng","Μογγολία"),
(508,"mz","moz","Μοζαμβίκη"),
(498,"md","mda","Μολδαβία"),
(492,"mc","mco","Μονακό"),
(500,"ms","msr","Μοντσερράτ"),
(50,"bd","bgd","Μπανγκλαντές"),
(52,"bb","brb","Μπαρμπάντος"),
(44,"bs","bhs","Μπαχάμες"),
(48,"bh","bhr","Μπαχρέιν"),
(84,"bz","blz","Μπελίζ"),
(204,"bj","ben","Μπενίν"),
(535,"bq","bes","Μποναίρ, Άγιος Ευστάθιος και Σάμπα"),
(72,"bw","bwa","Μποτσουάνα"),
(854,"bf","bfa","Μπουρκίνα Φάσο"),
(108,"bi","bdi","Μπουρούντι"),
(64,"bt","btn","Μπουτάν"),
(96,"bn","brn","Μπρουνέι"),
(516,"na","nam","Ναμίμπια"),
(520,"nr","nru","Ναουρού"),
(554,"nz","nzl","Νέα Ζηλανδία"),
(540,"nc","ncl","Νέα Καληδονία"),
(524,"np","npl","Νεπάλ"),
(74,"bv","bvt","Μπουβέ"),
(574,"nf","nfk","Νησί Νόρφολκ"),
(162,"cx","cxr","Νήσος των Χριστουγέννων"),
(166,"cc","cck","Νησιά Κόκος (Keeling)"),
(248,"ax","ala","Ώλαντ"),
(580,"mp","mnp","Βόρειες Μαριάνες Νήσοι"),
(584,"mh","mhl","Νήσοι Μάρσαλ"),
(612,"pn","pcn","Νησιά Πίτκερν"),
(136,"ky","cym","Κέιμαν Νήσοι"),
(184,"ck","cok","Νήσοι Κουκ"),
(90,"sb","slb","Νήσοι Σολομώντα"),
(234,"fo","fro","Νήσοι Φερόες"),
(238,"fk","flk","Νήσοι Φώκλαντ"),
(833,"im","imn","Νήσος Μαν"),
(334,"hm","hmd","Νήσοι Χερντ και Μακντόναλντ"),
(562,"ne","ner","Νίγηρας"),
(566,"ng","nga","Νιγηρία"),
(558,"ni","nic","Νικαράγουα"),
(570,"nu","niu","Νιούε"),
(578,"no","nor","Νορβηγία"),
(710,"za","zaf","Νότια Αφρική"),
(239,"gs","sgs","Νήσοι Νότια Γεωργία και Νότιες Σάντουιτς"),
(410,"kr","kor","Νότια Κορέα"),
(728,"ss","ssd","Νότιο Σουδάν"),
(212,"dm","dma","Δομινίκα"),
(528,"nl","nld","Ολλανδία (Κάτω Χώρες)"),
(512,"om","omn","Ομάν"),
(583,"fm","fsm","Ομόσπονδες Πολιτείες της Μικρονησίας"),
(340,"hn","hnd","Ονδούρα"),
(876,"wf","wlf","Ουαλίς και Φουτουνά"),
(348,"hu","hun","Ουγγαρία"),
(800,"ug","uga","Ουγκάντα"),
(860,"uz","uzb","Ουζμπεκιστάν"),
(804,"ua","ukr","Ουκρανία"),
(858,"uy","ury","Ουρουγουάη"),
(586,"pk","pak","Πακιστάν"),
(585,"pw","plw","Παλάου"),
(591,"pa","pan","Παναμάς"),
(598,"pg","png","Παπούα Νέα Γουινέα"),
(600,"py","pry","Παραγουάη"),
(850,"vi","vir","Αμερικανικές Παρθένοι Νήσοι"),
(807,"mk","mkd","Βόρεια Μακεδονία"),
(604,"pe","per","Περού"),
(616,"pl","pol","Πολωνία"),
(620,"pt","prt","Πορτογαλία"),
(630,"pr","pri","Πουέρτο Ρίκο"),
(132,"cv","cpv","Πράσινο Ακρωτήρι"),
(638,"re","reu","Ρεϊνιόν"),
(646,"rw","rwa","Ρουάντα"),
(642,"ro","rou","Ρουμανία"),
(643,"ru","rus","Ρωσία"),
(882,"ws","wsm","Σαμόα"),
(654,"sh","shn","Νήσος Αγίας Ελένης"),
(678,"st","stp","Σάο Τομέ και Πρίνσιπε"),
(682,"sa","sau","Σαουδική Αραβία"),
(744,"sj","sjm","Σβάλμπαρντ"),
(686,"sn","sen","Σενεγάλη"),
(688,"rs","srb","Σερβία"),
(690,"sc","syc","Σεϋχέλλες"),
(694,"sl","sle","Σιέρα Λεόνε"),
(702,"sg","sgp","Σιγκαπούρη"),
(703,"sk","svk","Σλοβακία"),
(705,"si","svn","Σλοβενία"),
(706,"so","som","Σομαλία"),
(748,"sz","swz","Εσουατίνι"),
(729,"sd","sdn","Σουδάν"),
(752,"se","swe","Σουηδία"),
(740,"sr","sur","Σουρινάμ"),
(144,"lk","lka","Σρι Λάνκα"),
(760,"sy","syr","Συρία"),
(158,"tw","twn","Ταϊβάν"),
(764,"th","tha","Ταϊλάνδη"),
(834,"tz","tza","Τανζανία"),
(762,"tj","tjk","Τατζικιστάν"),
(796,"tc","tca","Τερκς και Κέικος"),
(388,"jm","jam","Τζαμάικα"),
(832,"je","jey","Τζέρσεϊ"),
(262,"dj","dji","Τζιμπουτί"),
(776,"to","ton","Τόγκα"),
(768,"tg","tgo","Τόγκο"),
(772,"tk","tkl","Τοκελάου"),
(798,"tv","tuv","Τουβαλού"),
(792,"tr","tur","Τουρκία"),
(795,"tm","tkm","Τουρκμενιστάν"),
(780,"tt","tto","Τρινιντάντ και Τομπάγκο"),
(148,"td","tcd","Τσαντ"),
(203,"cz","cze","Τσεχία"),
(788,"tn","tun","Τυνησία"),
(887,"ye","yem","Υεμένη"),
(608,"ph","phl","Φιλιππίνες"),
(246,"fi","fin","Φινλανδία"),
(242,"fj","fji","Φίτζι"),
(152,"cl","chl","Χιλή"),
(344,"hk","hkg","Χονγκ Κονγκ")