IF OBJECT_ID('world', 'U') IS NOT NULL DROP TABLE [world];

CREATE TABLE [world] (
    [id] INT NOT NULL,
    [alpha_2] CHAR(2) NOT NULL DEFAULT '',
    [alpha_3] CHAR(3) NOT NULL DEFAULT '',
    [name] NVARCHAR(75) NOT NULL DEFAULT '',
    CONSTRAINT [pk_world] PRIMARY KEY ([id])
);

INSERT INTO [world] ([id], [alpha_2], [alpha_3], [name]) VALUES
(4,'af','afg',N'阿富汗'),
(248,'ax','ala',N'奥兰'),
(8,'al','alb',N'阿尔巴尼亚'),
(12,'dz','dza',N'阿尔及利亚'),
(16,'as','asm',N'美属萨摩亚'),
(20,'ad','and',N'安道尔'),
(24,'ao','ago',N'安哥拉'),
(660,'ai','aia',N'安圭拉'),
(10,'aq','ata',N'南极洲'),
(28,'ag','atg',N'安提瓜和巴布达'),
(32,'ar','arg',N'阿根廷'),
(51,'am','arm',N'亚美尼亚'),
(533,'aw','abw',N'阿鲁巴'),
(36,'au','aus',N'澳大利亚'),
(40,'at','aut',N'奥地利'),
(31,'az','aze',N'阿塞拜疆'),
(44,'bs','bhs',N'巴哈马'),
(48,'bh','bhr',N'巴林'),
(50,'bd','bgd',N'孟加拉国'),
(52,'bb','brb',N'巴巴多斯'),
(112,'by','blr',N'白俄罗斯'),
(56,'be','bel',N'比利时'),
(84,'bz','blz',N'伯利兹'),
(204,'bj','ben',N'贝宁'),
(60,'bm','bmu',N'百慕大'),
(64,'bt','btn',N'不丹'),
(68,'bo','bol',N'玻利维亚'),
(535,'bq','bes',N'荷兰加勒比区'),
(70,'ba','bih',N'波黑'),
(72,'bw','bwa',N'博茨瓦纳'),
(74,'bv','bvt',N'布韦岛'),
(76,'br','bra',N'巴西'),
(86,'io','iot',N'英属印度洋领地'),
(96,'bn','brn',N'文莱'),
(100,'bg','bgr',N'保加利亚'),
(854,'bf','bfa',N'布基纳法索'),
(108,'bi','bdi',N'布隆迪'),
(132,'cv','cpv',N'佛得角'),
(116,'kh','khm',N'柬埔寨'),
(120,'cm','cmr',N'喀麦隆'),
(124,'ca','can',N'加拿大'),
(136,'ky','cym',N'开曼群岛'),
(140,'cf','caf',N'中非'),
(148,'td','tcd',N'乍得'),
(152,'cl','chl',N'智利'),
(156,'cn','chn',N'中国'),
(162,'cx','cxr',N'圣诞岛'),
(166,'cc','cck',N'科科斯（基林）群岛'),
(170,'co','col',N'哥伦比亚'),
(174,'km','com',N'科摩罗'),
(178,'cg','cog',N'刚果共和国'),
(180,'cd','cod',N'刚果民主共和国'),
(184,'ck','cok',N'库克群岛'),
(188,'cr','cri',N'哥斯达黎加'),
(384,'ci','civ',N'科特迪瓦'),
(191,'hr','hrv',N'克罗地亚'),
(192,'cu','cub',N'古巴'),
(531,'cw','cuw',N'库拉索'),
(196,'cy','cyp',N'塞浦路斯'),
(203,'cz','cze',N'捷克'),
(208,'dk','dnk',N'丹麦'),
(262,'dj','dji',N'吉布提'),
(212,'dm','dma',N'多米尼克'),
(214,'do','dom',N'多米尼加'),
(218,'ec','ecu',N'厄瓜多尔'),
(818,'eg','egy',N'埃及'),
(222,'sv','slv',N'萨尔瓦多'),
(226,'gq','gnq',N'赤道几内亚'),
(232,'er','eri',N'厄立特里亚'),
(233,'ee','est',N'爱沙尼亚'),
(748,'sz','swz',N'斯威士兰'),
(231,'et','eth',N'埃塞俄比亚'),
(238,'fk','flk',N'福克兰群岛'),
(234,'fo','fro',N'法罗群岛'),
(242,'fj','fji',N'斐济'),
(246,'fi','fin',N'芬兰'),
(250,'fr','fra',N'法国'),
(254,'gf','guf',N'法属圭亚那'),
(258,'pf','pyf',N'法属波利尼西亚'),
(260,'tf','atf',N'法属南部和南极领地'),
(266,'ga','gab',N'加蓬'),
(270,'gm','gmb',N'冈比亚'),
(268,'ge','geo',N'格鲁吉亚'),
(276,'de','deu',N'德国'),
(288,'gh','gha',N'加纳'),
(292,'gi','gib',N'直布罗陀'),
(300,'gr','grc',N'希腊'),
(304,'gl','grl',N'格陵兰'),
(308,'gd','grd',N'格林纳达'),
(312,'gp','glp',N'瓜德罗普'),
(316,'gu','gum',N'关岛'),
(320,'gt','gtm',N'危地马拉'),
(831,'gg','ggy',N'根西'),
(324,'gn','gin',N'几内亚'),
(624,'gw','gnb',N'几内亚比绍'),
(328,'gy','guy',N'圭亚那'),
(332,'ht','hti',N'海地'),
(334,'hm','hmd',N'赫德岛和麦克唐纳群岛'),
(336,'va','vat',N'梵蒂冈'),
(340,'hn','hnd',N'洪都拉斯'),
(344,'hk','hkg',N'香港'),
(348,'hu','hun',N'匈牙利'),
(352,'is','isl',N'冰岛'),
(356,'in','ind',N'印度'),
(360,'id','idn',N'印度尼西亚'),
(364,'ir','irn',N'伊朗'),
(368,'iq','irq',N'伊拉克'),
(372,'ie','irl',N'爱尔兰'),
(833,'im','imn',N'马恩岛'),
(376,'il','isr',N'以色列'),
(380,'it','ita',N'意大利'),
(388,'jm','jam',N'牙买加'),
(392,'jp','jpn',N'日本'),
(832,'je','jey',N'泽西'),
(400,'jo','jor',N'约旦'),
(398,'kz','kaz',N'哈萨克斯坦'),
(404,'ke','ken',N'肯尼亚'),
(296,'ki','kir',N'基里巴斯'),
(408,'kp','prk',N'朝鲜'),
(410,'kr','kor',N'韩国'),
(414,'kw','kwt',N'科威特'),
(417,'kg','kgz',N'吉尔吉斯斯坦'),
(418,'la','lao',N'老挝'),
(428,'lv','lva',N'拉脱维亚'),
(422,'lb','lbn',N'黎巴嫩'),
(426,'ls','lso',N'莱索托'),
(430,'lr','lbr',N'利比里亚'),
(434,'ly','lby',N'利比亚'),
(438,'li','lie',N'列支敦士登'),
(440,'lt','ltu',N'立陶宛'),
(442,'lu','lux',N'卢森堡'),
(446,'mo','mac',N'澳门'),
(450,'mg','mdg',N'马达加斯加'),
(454,'mw','mwi',N'马拉维'),
(458,'my','mys',N'马来西亚'),
(462,'mv','mdv',N'马尔代夫'),
(466,'ml','mli',N'马里'),
(470,'mt','mlt',N'马耳他'),
(584,'mh','mhl',N'马绍尔群岛'),
(474,'mq','mtq',N'马提尼克'),
(478,'mr','mrt',N'毛里塔尼亚'),
(480,'mu','mus',N'毛里求斯'),
(175,'yt','myt',N'马约特'),
(484,'mx','mex',N'墨西哥'),
(583,'fm','fsm',N'密克罗尼西亚联邦'),
(498,'md','mda',N'摩尔多瓦'),
(492,'mc','mco',N'摩纳哥'),
(496,'mn','mng',N'蒙古国'),
(499,'me','mne',N'黑山'),
(500,'ms','msr',N'蒙特塞拉特'),
(504,'ma','mar',N'摩洛哥'),
(508,'mz','moz',N'莫桑比克'),
(104,'mm','mmr',N'缅甸'),
(516,'na','nam',N'纳米比亚'),
(520,'nr','nru',N'瑙鲁'),
(524,'np','npl',N'尼泊尔'),
(528,'nl','nld',N'荷兰'),
(540,'nc','ncl',N'新喀里多尼亚'),
(554,'nz','nzl',N'新西兰'),
(558,'ni','nic',N'尼加拉瓜'),
(562,'ne','ner',N'尼日尔'),
(566,'ng','nga',N'尼日利亚'),
(570,'nu','niu',N'纽埃'),
(574,'nf','nfk',N'诺福克岛'),
(807,'mk','mkd',N'北马其顿'),
(580,'mp','mnp',N'北马里亚纳群岛'),
(578,'no','nor',N'挪威'),
(512,'om','omn',N'阿曼'),
(586,'pk','pak',N'巴基斯坦'),
(585,'pw','plw',N'帕劳'),
(275,'ps','pse',N'巴勒斯坦'),
(591,'pa','pan',N'巴拿马'),
(598,'pg','png',N'巴布亚新几内亚'),
(600,'py','pry',N'巴拉圭'),
(604,'pe','per',N'秘鲁'),
(608,'ph','phl',N'菲律宾'),
(612,'pn','pcn',N'皮特凯恩群岛'),
(616,'pl','pol',N'波兰'),
(620,'pt','prt',N'葡萄牙'),
(630,'pr','pri',N'波多黎各'),
(634,'qa','qat',N'卡塔尔'),
(638,'re','reu',N'留尼汪'),
(642,'ro','rou',N'罗马尼亚'),
(643,'ru','rus',N'俄罗斯'),
(646,'rw','rwa',N'卢旺达'),
(652,'bl','blm',N'圣巴泰勒米'),
(654,'sh','shn',N'圣赫勒拿、阿森松和特里斯坦-达库尼亚'),
(659,'kn','kna',N'圣基茨和尼维斯'),
(662,'lc','lca',N'圣卢西亚'),
(663,'mf','maf',N'法属圣马丁'),
(666,'pm','spm',N'圣皮埃尔和密克隆'),
(670,'vc','vct',N'圣文森特和格林纳丁斯'),
(882,'ws','wsm',N'萨摩亚'),
(674,'sm','smr',N'圣马力诺'),
(678,'st','stp',N'圣多美和普林西比'),
(682,'sa','sau',N'沙特阿拉伯'),
(686,'sn','sen',N'塞内加尔'),
(688,'rs','srb',N'塞尔维亚'),
(690,'sc','syc',N'塞舌尔'),
(694,'sl','sle',N'塞拉利昂'),
(702,'sg','sgp',N'新加坡'),
(534,'sx','sxm',N'荷属圣马丁'),
(703,'sk','svk',N'斯洛伐克'),
(705,'si','svn',N'斯洛文尼亚'),
(90,'sb','slb',N'所罗门群岛'),
(706,'so','som',N'索马里'),
(710,'za','zaf',N'南非'),
(239,'gs','sgs',N'南乔治亚和南桑威奇群岛'),
(728,'ss','ssd',N'南苏丹'),
(724,'es','esp',N'西班牙'),
(144,'lk','lka',N'斯里兰卡'),
(729,'sd','sdn',N'苏丹'),
(740,'sr','sur',N'苏里南'),
(744,'sj','sjm',N'斯瓦尔巴和扬马延'),
(752,'se','swe',N'瑞典'),
(756,'ch','che',N'瑞士'),
(760,'sy','syr',N'叙利亚'),
(158,'tw','twn',N'中国台湾省'),
(762,'tj','tjk',N'塔吉克斯坦'),
(834,'tz','tza',N'坦桑尼亚'),
(764,'th','tha',N'泰国'),
(626,'tl','tls',N'东帝汶'),
(768,'tg','tgo',N'多哥'),
(772,'tk','tkl',N'托克劳'),
(776,'to','ton',N'汤加'),
(780,'tt','tto',N'特立尼达和多巴哥'),
(788,'tn','tun',N'突尼斯'),
(792,'tr','tur',N'土耳其'),
(795,'tm','tkm',N'土库曼斯坦'),
(796,'tc','tca',N'特克斯和凯科斯群岛'),
(798,'tv','tuv',N'图瓦卢'),
(800,'ug','uga',N'乌干达'),
(804,'ua','ukr',N'乌克兰'),
(784,'ae','are',N'阿联酋'),
(826,'gb','gbr',N'英国'),
(840,'us','usa',N'美国'),
(581,'um','umi',N'美国本土外小岛屿'),
(858,'uy','ury',N'乌拉圭'),
(860,'uz','uzb',N'乌兹别克斯坦'),
(548,'vu','vut',N'瓦努阿图'),
(862,'ve','ven',N'委内瑞拉'),
(704,'vn','vnm',N'越南'),
(92,'vg','vgb',N'英属维尔京群岛'),
(850,'vi','vir',N'美属维尔京群岛'),
(876,'wf','wlf',N'瓦利斯和富图纳'),
(732,'eh','esh',N'西撒哈拉'),
(887,'ye','yem',N'也门'),
(894,'zm','zmb',N'赞比亚'),
(716,'zw','zwe',N'津巴布韦')