SET NAMES utf8;

DROP TABLE IF EXISTS "world";

CREATE TABLE "world" (
  "id" int(11) NOT NULL,
  "name" varchar(75) NOT NULL DEFAULT "",
  "alpha_2" char(2) NOT NULL DEFAULT "",
  "alpha_3" char(3) NOT NULL DEFAULT "",
  PRIMARY KEY ("id")
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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