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
(288,'gh','gha',N'가나'),
(266,'ga','gab',N'가봉'),
(328,'gy','guy',N'가이아나'),
(270,'gm','gmb',N'감비아'),
(831,'gg','ggy',N'건지섬'),
(312,'gp','glp',N'과들루프'),
(320,'gt','gtm',N'과테말라'),
(316,'gu','gum',N'괌'),
(308,'gd','grd',N'그레나다'),
(300,'gr','grc',N'그리스'),
(304,'gl','grl',N'그린란드'),
(324,'gn','gin',N'기니'),
(624,'gw','gnb',N'기니비사우'),
(516,'na','nam',N'나미비아'),
(520,'nr','nru',N'나우루'),
(566,'ng','nga',N'나이지리아'),
(10,'aq','ata',N'남극'),
(728,'ss','ssd',N'남수단'),
(710,'za','zaf',N'남아프리카 공화국'),
(528,'nl','nld',N'네덜란드'),
(524,'np','npl',N'네팔'),
(578,'no','nor',N'노르웨이'),
(574,'nf','nfk',N'노퍽섬'),
(540,'nc','ncl',N'누벨칼레도니'),
(554,'nz','nzl',N'뉴질랜드'),
(570,'nu','niu',N'니우에'),
(562,'ne','ner',N'니제르'),
(558,'ni','nic',N'니카라과'),
(410,'kr','kor',N'대한민국'),
(208,'dk','dnk',N'덴마크'),
(214,'do','dom',N'도미니카 공화국'),
(212,'dm','dma',N'도미니카 연방'),
(276,'de','deu',N'독일'),
(626,'tl','tls',N'동티모르'),
(418,'la','lao',N'라오스'),
(430,'lr','lbr',N'라이베리아'),
(428,'lv','lva',N'라트비아'),
(643,'ru','rus',N'러시아'),
(422,'lb','lbn',N'레바논'),
(426,'ls','lso',N'레소토'),
(638,'re','reu',N'레위니옹'),
(642,'ro','rou',N'루마니아'),
(442,'lu','lux',N'룩셈부르크'),
(646,'rw','rwa',N'르완다'),
(434,'ly','lby',N'리비아'),
(440,'lt','ltu',N'리투아니아'),
(438,'li','lie',N'리히텐슈타인'),
(450,'mg','mdg',N'마다가스카르'),
(474,'mq','mtq',N'마르티니크'),
(584,'mh','mhl',N'마셜 제도'),
(175,'yt','myt',N'마요트'),
(446,'mo','mac',N'마카오'),
(807,'mk','mkd',N'북마케도니아'),
(454,'mw','mwi',N'말라위'),
(458,'my','mys',N'말레이시아'),
(466,'ml','mli',N'말리'),
(833,'im','imn',N'맨섬'),
(484,'mx','mex',N'멕시코'),
(492,'mc','mco',N'모나코'),
(504,'ma','mar',N'모로코'),
(480,'mu','mus',N'모리셔스'),
(478,'mr','mrt',N'모리타니'),
(508,'mz','moz',N'모잠비크'),
(499,'me','mne',N'몬테네그로'),
(500,'ms','msr',N'몬트세랫'),
(498,'md','mda',N'몰도바'),
(462,'mv','mdv',N'몰디브'),
(470,'mt','mlt',N'몰타'),
(496,'mn','mng',N'몽골'),
(840,'us','usa',N'미국'),
(581,'um','umi',N'미국령 군소 제도'),
(850,'vi','vir',N'미국령 버진아일랜드'),
(104,'mm','mmr',N'미얀마'),
(583,'fm','fsm',N'미크로네시아 연방'),
(548,'vu','vut',N'바누아투'),
(48,'bh','bhr',N'바레인'),
(52,'bb','brb',N'바베이도스'),
(336,'va','vat',N'바티칸 시국'),
(44,'bs','bhs',N'바하마'),
(50,'bd','bgd',N'방글라데시'),
(60,'bm','bmu',N'버뮤다'),
(204,'bj','ben',N'베냉'),
(862,'ve','ven',N'베네수엘라'),
(704,'vn','vnm',N'베트남'),
(56,'be','bel',N'벨기에'),
(112,'by','blr',N'벨라루스'),
(84,'bz','blz',N'벨리즈'),
(535,'bq','bes',N'보네르섬'),
(70,'ba','bih',N'보스니아 헤르체고비나'),
(72,'bw','bwa',N'보츠와나'),
(68,'bo','bol',N'볼리비아'),
(108,'bi','bdi',N'부룬디'),
(854,'bf','bfa',N'부르키나파소'),
(74,'bv','bvt',N'부베섬'),
(64,'bt','btn',N'부탄'),
(580,'mp','mnp',N'북마리아나 제도'),
(100,'bg','bgr',N'불가리아'),
(76,'br','bra',N'브라질'),
(96,'bn','brn',N'브루나이'),
(882,'ws','wsm',N'사모아'),
(682,'sa','sau',N'사우디아라비아'),
(239,'gs','sgs',N'사우스조지아 사우스샌드위치 제도'),
(674,'sm','smr',N'산마리노'),
(678,'st','stp',N'상투메 프린시페'),
(663,'mf','maf',N'생마르탱'),
(652,'bl','blm',N'생바르텔레미'),
(666,'pm','spm',N'생피에르 미클롱'),
(732,'eh','esh',N'서사하라'),
(686,'sn','sen',N'세네갈'),
(688,'rs','srb',N'세르비아'),
(690,'sc','syc',N'세이셸'),
(662,'lc','lca',N'세인트루시아'),
(670,'vc','vct',N'세인트빈센트 그레나딘'),
(659,'kn','kna',N'세인트키츠 네비스'),
(654,'sh','shn',N'세인트헬레나'),
(706,'so','som',N'소말리아'),
(90,'sb','slb',N'솔로몬 제도'),
(729,'sd','sdn',N'수단'),
(740,'sr','sur',N'수리남'),
(144,'lk','lka',N'스리랑카'),
(744,'sj','sjm',N'스발바르 얀마옌'),
(752,'se','swe',N'스웨덴'),
(756,'ch','che',N'스위스'),
(724,'es','esp',N'스페인'),
(703,'sk','svk',N'슬로바키아'),
(705,'si','svn',N'슬로베니아'),
(760,'sy','syr',N'시리아'),
(694,'sl','sle',N'시에라리온'),
(534,'sx','sxm',N'신트마르턴'),
(702,'sg','sgp',N'싱가포르'),
(784,'ae','are',N'아랍에미리트'),
(533,'aw','abw',N'아루바'),
(51,'am','arm',N'아르메니아'),
(32,'ar','arg',N'아르헨티나'),
(16,'as','asm',N'아메리칸사모아'),
(352,'is','isl',N'아이슬란드'),
(332,'ht','hti',N'아이티'),
(372,'ie','irl',N'아일랜드'),
(31,'az','aze',N'아제르바이잔'),
(4,'af','afg',N'아프가니스탄'),
(20,'ad','and',N'안도라'),
(8,'al','alb',N'알바니아'),
(12,'dz','dza',N'알제리'),
(24,'ao','ago',N'앙골라'),
(28,'ag','atg',N'앤티가 바부다'),
(660,'ai','aia',N'앵귈라'),
(232,'er','eri',N'에리트레아'),
(748,'sz','swz',N'에스와티니'),
(233,'ee','est',N'에스토니아'),
(218,'ec','ecu',N'에콰도르'),
(231,'et','eth',N'에티오피아'),
(222,'sv','slv',N'엘살바도르'),
(826,'gb','gbr',N'영국'),
(92,'vg','vgb',N'영국령 버진아일랜드'),
(86,'io','iot',N'영국령 인도양 지역'),
(887,'ye','yem',N'예멘'),
(512,'om','omn',N'오만'),
(36,'au','aus',N'오스트레일리아'),
(40,'at','aut',N'오스트리아'),
(340,'hn','hnd',N'온두라스'),
(248,'ax','ala',N'올란드 제도'),
(400,'jo','jor',N'요르단'),
(800,'ug','uga',N'우간다'),
(858,'uy','ury',N'우루과이'),
(860,'uz','uzb',N'우즈베키스탄'),
(804,'ua','ukr',N'우크라이나'),
(876,'wf','wlf',N'왈리스 푸투나'),
(368,'iq','irq',N'이라크'),
(364,'ir','irn',N'이란'),
(376,'il','isr',N'이스라엘'),
(818,'eg','egy',N'이집트'),
(380,'it','ita',N'이탈리아'),
(356,'in','ind',N'인도'),
(360,'id','idn',N'인도네시아'),
(392,'jp','jpn',N'일본'),
(388,'jm','jam',N'자메이카'),
(894,'zm','zmb',N'잠비아'),
(832,'je','jey',N'저지섬'),
(226,'gq','gnq',N'적도 기니'),
(408,'kp','prk',N'조선민주주의인민공화국'),
(268,'ge','geo',N'조지아'),
(156,'cn','chn',N'중국'),
(140,'cf','caf',N'중앙아프리카 공화국'),
(262,'dj','dji',N'지부티'),
(292,'gi','gib',N'지브롤터'),
(716,'zw','zwe',N'짐바브웨'),
(148,'td','tcd',N'차드'),
(203,'cz','cze',N'체코'),
(152,'cl','chl',N'칠레'),
(120,'cm','cmr',N'카메룬'),
(132,'cv','cpv',N'카보베르데'),
(398,'kz','kaz',N'카자흐스탄'),
(634,'qa','qat',N'카타르'),
(116,'kh','khm',N'캄보디아'),
(124,'ca','can',N'캐나다'),
(404,'ke','ken',N'케냐'),
(136,'ky','cym',N'케이맨 제도'),
(174,'km','com',N'코모로'),
(188,'cr','cri',N'코스타리카'),
(166,'cc','cck',N'코코스 제도'),
(384,'ci','civ',N'코트디부아르'),
(170,'co','col',N'콜롬비아'),
(178,'cg','cog',N'콩고 공화국'),
(180,'cd','cod',N'콩고 민주 공화국'),
(192,'cu','cub',N'쿠바'),
(414,'kw','kwt',N'쿠웨이트'),
(184,'ck','cok',N'쿡 제도'),
(531,'cw','cuw',N'퀴라소'),
(191,'hr','hrv',N'크로아티아'),
(162,'cx','cxr',N'크리스마스섬'),
(417,'kg','kgz',N'키르기스스탄'),
(296,'ki','kir',N'키리바시'),
(196,'cy','cyp',N'키프로스'),
(158,'tw','twn',N'대만'),
(762,'tj','tjk',N'타지키스탄'),
(834,'tz','tza',N'탄자니아'),
(764,'th','tha',N'태국'),
(796,'tc','tca',N'터크스 케이커스 제도'),
(792,'tr','tur',N'튀르키예'),
(768,'tg','tgo',N'토고'),
(772,'tk','tkl',N'토켈라우'),
(776,'to','ton',N'통가'),
(795,'tm','tkm',N'투르크메니스탄'),
(798,'tv','tuv',N'투발루'),
(788,'tn','tun',N'튀니지'),
(780,'tt','tto',N'트리니다드 토바고'),
(591,'pa','pan',N'파나마'),
(600,'py','pry',N'파라과이'),
(586,'pk','pak',N'파키스탄'),
(598,'pg','png',N'파푸아뉴기니'),
(585,'pw','plw',N'팔라우'),
(275,'ps','pse',N'팔레스타인'),
(234,'fo','fro',N'페로 제도'),
(604,'pe','per',N'페루'),
(620,'pt','prt',N'포르투갈'),
(238,'fk','flk',N'포클랜드 제도'),
(616,'pl','pol',N'폴란드'),
(630,'pr','pri',N'푸에르토리코'),
(250,'fr','fra',N'프랑스'),
(254,'gf','guf',N'프랑스령 기아나'),
(260,'tf','atf',N'프랑스령 남방 및 남극 지역'),
(258,'pf','pyf',N'프랑스령 폴리네시아'),
(242,'fj','fji',N'피지'),
(246,'fi','fin',N'핀란드'),
(608,'ph','phl',N'필리핀'),
(612,'pn','pcn',N'핏케언 제도'),
(334,'hm','hmd',N'허드 맥도널드 제도'),
(348,'hu','hun',N'헝가리'),
(344,'hk','hkg',N'홍콩')