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'Afghanistan'),
(710,'za','zaf',N'Afrique du Sud'),
(248,'ax','ala',N'Îles Åland'),
(8,'al','alb',N'Albanie'),
(12,'dz','dza',N'Algérie'),
(276,'de','deu',N'Allemagne'),
(20,'ad','and',N'Andorre'),
(24,'ao','ago',N'Angola'),
(660,'ai','aia',N'Anguilla'),
(10,'aq','ata',N'Antarctique'),
(28,'ag','atg',N'Antigua-et-Barbuda'),
(682,'sa','sau',N'Arabie saoudite'),
(32,'ar','arg',N'Argentine'),
(51,'am','arm',N'Arménie'),
(533,'aw','abw',N'Aruba'),
(36,'au','aus',N'Australie'),
(40,'at','aut',N'Autriche'),
(31,'az','aze',N'Azerbaïdjan'),
(44,'bs','bhs',N'Bahamas'),
(48,'bh','bhr',N'Bahreïn'),
(50,'bd','bgd',N'Bangladesh'),
(52,'bb','brb',N'Barbade'),
(112,'by','blr',N'Biélorussie'),
(56,'be','bel',N'Belgique'),
(84,'bz','blz',N'Belize'),
(204,'bj','ben',N'Bénin'),
(60,'bm','bmu',N'Bermudes'),
(64,'bt','btn',N'Bhoutan'),
(68,'bo','bol',N'Bolivie'),
(535,'bq','bes',N'Pays-Bas caribéens'),
(70,'ba','bih',N'Bosnie-Herzégovine'),
(72,'bw','bwa',N'Botswana'),
(74,'bv','bvt',N'Île Bouvet'),
(76,'br','bra',N'Brésil'),
(96,'bn','brn',N'Brunei'),
(100,'bg','bgr',N'Bulgarie'),
(854,'bf','bfa',N'Burkina Faso'),
(108,'bi','bdi',N'Burundi'),
(136,'ky','cym',N'Îles Caïmans'),
(116,'kh','khm',N'Cambodge'),
(120,'cm','cmr',N'Cameroun'),
(124,'ca','can',N'Canada'),
(132,'cv','cpv',N'Cap-Vert'),
(140,'cf','caf',N'République centrafricaine'),
(152,'cl','chl',N'Chili'),
(156,'cn','chn',N'Chine'),
(162,'cx','cxr',N'Île Christmas'),
(196,'cy','cyp',N'Chypre'),
(166,'cc','cck',N'Îles Cocos'),
(170,'co','col',N'Colombie'),
(174,'km','com',N'Comores'),
(178,'cg','cog',N'République du Congo'),
(180,'cd','cod',N'République démocratique du Congo'),
(184,'ck','cok',N'Îles Cook'),
(410,'kr','kor',N'Corée du Sud'),
(408,'kp','prk',N'Corée du Nord'),
(188,'cr','cri',N'Costa Rica'),
(384,'ci','civ',N'Côte d''Ivoire'),
(191,'hr','hrv',N'Croatie'),
(192,'cu','cub',N'Cuba'),
(531,'cw','cuw',N'Curaçao'),
(208,'dk','dnk',N'Danemark'),
(262,'dj','dji',N'Djibouti'),
(214,'do','dom',N'République dominicaine'),
(212,'dm','dma',N'Dominique'),
(818,'eg','egy',N'Égypte'),
(784,'ae','are',N'Émirats arabes unis'),
(218,'ec','ecu',N'Équateur'),
(232,'er','eri',N'Érythrée'),
(724,'es','esp',N'Espagne'),
(233,'ee','est',N'Estonie'),
(840,'us','usa',N'États-Unis'),
(231,'et','eth',N'Éthiopie'),
(238,'fk','flk',N'Îles Malouines'),
(234,'fo','fro',N'Îles Féroé'),
(242,'fj','fji',N'Fidji'),
(246,'fi','fin',N'Finlande'),
(250,'fr','fra',N'France'),
(266,'ga','gab',N'Gabon'),
(270,'gm','gmb',N'Gambie'),
(268,'ge','geo',N'Géorgie'),
(239,'gs','sgs',N'Géorgie du Sud-et-les îles Sandwich du Sud'),
(288,'gh','gha',N'Ghana'),
(292,'gi','gib',N'Gibraltar'),
(300,'gr','grc',N'Grèce'),
(308,'gd','grd',N'Grenade'),
(304,'gl','grl',N'Groenland'),
(312,'gp','glp',N'Guadeloupe'),
(316,'gu','gum',N'Guam'),
(320,'gt','gtm',N'Guatemala'),
(831,'gg','ggy',N'Guernesey'),
(324,'gn','gin',N'Guinée'),
(624,'gw','gnb',N'Guinée-Bissau'),
(226,'gq','gnq',N'Guinée équatoriale'),
(328,'gy','guy',N'Guyana'),
(254,'gf','guf',N'Guyane'),
(332,'ht','hti',N'Haïti'),
(334,'hm','hmd',N'Îles Heard-et-MacDonald'),
(340,'hn','hnd',N'Honduras'),
(344,'hk','hkg',N'Hong Kong'),
(348,'hu','hun',N'Hongrie'),
(581,'um','umi',N'Îles mineures éloignées des États-Unis'),
(356,'in','ind',N'Inde'),
(360,'id','idn',N'Indonésie'),
(364,'ir','irn',N'Iran'),
(368,'iq','irq',N'Irak'),
(372,'ie','irl',N'Irlande'),
(352,'is','isl',N'Islande'),
(376,'il','isr',N'Israël'),
(380,'it','ita',N'Italie'),
(388,'jm','jam',N'Jamaïque'),
(392,'jp','jpn',N'Japon'),
(832,'je','jey',N'Jersey'),
(400,'jo','jor',N'Jordanie'),
(398,'kz','kaz',N'Kazakhstan'),
(404,'ke','ken',N'Kenya'),
(417,'kg','kgz',N'Kirghizistan'),
(296,'ki','kir',N'Kiribati'),
(414,'kw','kwt',N'Koweït'),
(418,'la','lao',N'Laos'),
(426,'ls','lso',N'Lesotho'),
(428,'lv','lva',N'Lettonie'),
(422,'lb','lbn',N'Liban'),
(430,'lr','lbr',N'Liberia'),
(434,'ly','lby',N'Libye'),
(438,'li','lie',N'Liechtenstein'),
(440,'lt','ltu',N'Lituanie'),
(442,'lu','lux',N'Luxembourg'),
(446,'mo','mac',N'Macao'),
(807,'mk','mkd',N'Macédoine du Nord'),
(450,'mg','mdg',N'Madagascar'),
(458,'my','mys',N'Malaisie'),
(454,'mw','mwi',N'Malawi'),
(462,'mv','mdv',N'Maldives'),
(466,'ml','mli',N'Mali'),
(470,'mt','mlt',N'Malte'),
(833,'im','imn',N'Île de Man'),
(580,'mp','mnp',N'Îles Mariannes du Nord'),
(504,'ma','mar',N'Maroc'),
(584,'mh','mhl',N'Îles Marshall'),
(474,'mq','mtq',N'Martinique'),
(480,'mu','mus',N'Maurice'),
(478,'mr','mrt',N'Mauritanie'),
(175,'yt','myt',N'Mayotte'),
(484,'mx','mex',N'Mexique'),
(583,'fm','fsm',N'États fédérés de Micronésie'),
(498,'md','mda',N'Moldavie'),
(492,'mc','mco',N'Monaco'),
(496,'mn','mng',N'Mongolie'),
(499,'me','mne',N'Monténégro'),
(500,'ms','msr',N'Montserrat'),
(508,'mz','moz',N'Mozambique'),
(104,'mm','mmr',N'Birmanie'),
(516,'na','nam',N'Namibie'),
(520,'nr','nru',N'Nauru'),
(524,'np','npl',N'Népal'),
(558,'ni','nic',N'Nicaragua'),
(562,'ne','ner',N'Niger'),
(566,'ng','nga',N'Nigeria'),
(570,'nu','niu',N'Niue'),
(574,'nf','nfk',N'Île Norfolk'),
(578,'no','nor',N'Norvège'),
(540,'nc','ncl',N'Nouvelle-Calédonie'),
(554,'nz','nzl',N'Nouvelle-Zélande'),
(86,'io','iot',N'Territoire britannique de l''océan Indien'),
(512,'om','omn',N'Oman'),
(800,'ug','uga',N'Ouganda'),
(860,'uz','uzb',N'Ouzbékistan'),
(586,'pk','pak',N'Pakistan'),
(585,'pw','plw',N'Palaos'),
(275,'ps','pse',N'Palestine'),
(591,'pa','pan',N'Panama'),
(598,'pg','png',N'Papouasie-Nouvelle-Guinée'),
(600,'py','pry',N'Paraguay'),
(528,'nl','nld',N'Pays-Bas'),
(604,'pe','per',N'Pérou'),
(608,'ph','phl',N'Philippines'),
(612,'pn','pcn',N'Îles Pitcairn'),
(616,'pl','pol',N'Pologne'),
(258,'pf','pyf',N'Polynésie française'),
(630,'pr','pri',N'Porto Rico'),
(620,'pt','prt',N'Portugal'),
(634,'qa','qat',N'Qatar'),
(638,'re','reu',N'La Réunion'),
(642,'ro','rou',N'Roumanie'),
(826,'gb','gbr',N'Royaume-Uni'),
(643,'ru','rus',N'Russie'),
(646,'rw','rwa',N'Rwanda'),
(732,'eh','esh',N'République arabe sahraouie démocratique'),
(652,'bl','blm',N'Saint-Barthélemy'),
(659,'kn','kna',N'Saint-Christophe-et-Niévès'),
(674,'sm','smr',N'Saint-Marin'),
(663,'mf','maf',N'Saint-Martin'),
(534,'sx','sxm',N'Saint-Martin'),
(666,'pm','spm',N'Saint-Pierre-et-Miquelon'),
(336,'va','vat',N'Saint-Siège (État de la Cité du Vatican)'),
(670,'vc','vct',N'Saint-Vincent-et-les-Grenadines'),
(654,'sh','shn',N'Sainte-Hélène, Ascension et Tristan da Cunha'),
(662,'lc','lca',N'Sainte-Lucie'),
(90,'sb','slb',N'Îles Salomon'),
(222,'sv','slv',N'Salvador'),
(882,'ws','wsm',N'Samoa'),
(16,'as','asm',N'Samoa américaines'),
(678,'st','stp',N'Sao Tomé-et-Principe'),
(686,'sn','sen',N'Sénégal'),
(688,'rs','srb',N'Serbie'),
(690,'sc','syc',N'Seychelles'),
(694,'sl','sle',N'Sierra Leone'),
(702,'sg','sgp',N'Singapour'),
(703,'sk','svk',N'Slovaquie'),
(705,'si','svn',N'Slovénie'),
(706,'so','som',N'Somalie'),
(729,'sd','sdn',N'Soudan'),
(728,'ss','ssd',N'Soudan du Sud'),
(144,'lk','lka',N'Sri Lanka'),
(752,'se','swe',N'Suède'),
(756,'ch','che',N'Suisse'),
(740,'sr','sur',N'Suriname'),
(744,'sj','sjm',N'Svalbard et île Jan Mayen'),
(748,'sz','swz',N'Eswatini'),
(760,'sy','syr',N'Syrie'),
(762,'tj','tjk',N'Tadjikistan'),
(158,'tw','twn',N'Taïwan (République de Chine)'),
(834,'tz','tza',N'Tanzanie'),
(148,'td','tcd',N'Tchad'),
(203,'cz','cze',N'Tchéquie'),
(260,'tf','atf',N'Terres australes et antarctiques françaises'),
(764,'th','tha',N'Thaïlande'),
(626,'tl','tls',N'Timor oriental'),
(768,'tg','tgo',N'Togo'),
(772,'tk','tkl',N'Tokelau'),
(776,'to','ton',N'Tonga'),
(780,'tt','tto',N'Trinité-et-Tobago'),
(788,'tn','tun',N'Tunisie'),
(795,'tm','tkm',N'Turkménistan'),
(796,'tc','tca',N'Îles Turques-et-Caïques'),
(792,'tr','tur',N'Turquie'),
(798,'tv','tuv',N'Tuvalu'),
(804,'ua','ukr',N'Ukraine'),
(858,'uy','ury',N'Uruguay'),
(548,'vu','vut',N'Vanuatu'),
(862,'ve','ven',N'Venezuela'),
(92,'vg','vgb',N'Îles Vierges britanniques'),
(850,'vi','vir',N'Îles Vierges des États-Unis'),
(704,'vn','vnm',N'Viêt Nam'),
(876,'wf','wlf',N'Wallis-et-Futuna'),
(887,'ye','yem',N'Yémen'),
(894,'zm','zmb',N'Zambie'),
(716,'zw','zwe',N'Zimbabwe')