DELETE FROM uc_countries;
INSERT INTO uc_countries VALUES (004,"AFGHANISTAN",'AF','AFG',1);
INSERT INTO uc_countries VALUES (248,"ALAND ISLANDS",'AX','ALA',1);
INSERT INTO uc_countries VALUES (008,"ALBANIA",'AL','ALB',1);
INSERT INTO uc_countries VALUES (012,"ALGERIA",'DZ','DZA',1);
INSERT INTO uc_countries VALUES (016,"AMERICAN SAMOA",'AS','ASM',1);
INSERT INTO uc_countries VALUES (020,"ANDORRA",'AD','AND',1);
INSERT INTO uc_countries VALUES (024,"ANGOLA",'AO','AGO',1);
INSERT INTO uc_countries VALUES (660,"ANGUILLA",'AI','AIA',1);
INSERT INTO uc_countries VALUES (010,"ANTARCTICA",'AQ','ATA',1);
INSERT INTO uc_countries VALUES (028,"ANTIGUA AND BARBUDA",'AG','ATG',1);
INSERT INTO uc_countries VALUES (032,"ARGENTINA",'AR','ARG',1);
INSERT INTO uc_countries VALUES (051,"ARMENIA",'AM','ARM',1);
INSERT INTO uc_countries VALUES (533,"ARUBA",'AW','ABW',1);
INSERT INTO uc_countries VALUES (036,"AUSTRALIA",'AU','AUS',1);
INSERT INTO uc_countries VALUES (040,"AUSTRIA",'AT','AUT',1);
INSERT INTO uc_countries VALUES (031,"AZERBAIJAN",'AZ','AZE',1);
INSERT INTO uc_countries VALUES (044,"BAHAMAS",'BS','BHS',1);
INSERT INTO uc_countries VALUES (048,"BAHRAIN",'BH','BHR',1);
INSERT INTO uc_countries VALUES (050,"BANGLADESH",'BD','BGD',1);
INSERT INTO uc_countries VALUES (052,"BARBADOS",'BB','BRB',1);
INSERT INTO uc_countries VALUES (112,"BELARUS",'BY','BLR',1);
INSERT INTO uc_countries VALUES (056,"BELGIUM",'BE','BEL',1);
INSERT INTO uc_countries VALUES (084,"BELIZE",'BZ','BLZ',1);
INSERT INTO uc_countries VALUES (204,"BENIN",'BJ','BEN',1);
INSERT INTO uc_countries VALUES (060,"BERMUDA",'BM','BMU',1);
INSERT INTO uc_countries VALUES (064,"BHUTAN",'BT','BTN',1);
INSERT INTO uc_countries VALUES (068,"BOLIVIA",'BO','BOL',1);
INSERT INTO uc_countries VALUES (070,"BOSNIA AND HERZEGOVINA",'BA','BIH',1);
INSERT INTO uc_countries VALUES (072,"BOTSWANA",'BW','BWA',1);
INSERT INTO uc_countries VALUES (074,"BOUVET ISLAND",'BV','BVT',1);
INSERT INTO uc_countries VALUES (076,"BRAZIL",'BR','BRA',1);
INSERT INTO uc_countries VALUES (086,"BRITISH INDIAN OCEAN TERRITORY",'IO','IOT',1);
INSERT INTO uc_countries VALUES (096,"BRUNEI DARUSSALAM",'BN','BRN',1);
INSERT INTO uc_countries VALUES (100,"BULGARIA",'BG','BGR',1);
INSERT INTO uc_countries VALUES (854,"BURKINA FASO",'BF','BFA',1);
INSERT INTO uc_countries VALUES (108,"BURUNDI",'BI','BDI',1);
INSERT INTO uc_countries VALUES (116,"CAMBODIA",'KH','KHM',1);
INSERT INTO uc_countries VALUES (120,"CAMEROON",'CM','CMR',1);
INSERT INTO uc_countries VALUES (124,"CANADA",'CA','CAN',1);
INSERT INTO uc_countries VALUES (132,"CAPE VERDE",'CV','CPV',1);
INSERT INTO uc_countries VALUES (136,"CAYMAN ISLANDS",'KY','CYM',1);
INSERT INTO uc_countries VALUES (140,"CENTRAL AFRICAN REPUBLIC",'CF','CAF',1);
INSERT INTO uc_countries VALUES (148,"CHAD",'TD','TCD',1);
INSERT INTO uc_countries VALUES (152,"CHILE",'CL','CHL',1);
INSERT INTO uc_countries VALUES (156,"CHINA",'CN','CHN',1);
INSERT INTO uc_countries VALUES (162,"CHRISTMAS ISLAND",'CX','CXR',1);
INSERT INTO uc_countries VALUES (166,"COCOS (KEELING) ISLANDS",'CC','CCK',1);
INSERT INTO uc_countries VALUES (170,"COLOMBIA",'CO','COL',1);
INSERT INTO uc_countries VALUES (174,"COMOROS",'KM','COM',1);
INSERT INTO uc_countries VALUES (178,"CONGO",'CG','COG',1);
INSERT INTO uc_countries VALUES (180,"CONGO, THE DEMOCRATIC REPUBLIC OF THE",'CD','COD',1);
INSERT INTO uc_countries VALUES (184,"COOK ISLANDS",'CK','COK',1);
INSERT INTO uc_countries VALUES (188,"COSTA RICA",'CR','CRI',1);
INSERT INTO uc_countries VALUES (384,"COTE D'IVOIRE",'CI','CIV',1);
INSERT INTO uc_countries VALUES (191,"CROATIA",'HR','HRV',1);
INSERT INTO uc_countries VALUES (192,"CUBA",'CU','CUB',1);
INSERT INTO uc_countries VALUES (196,"CYPRUS",'CY','CYP',1);
INSERT INTO uc_countries VALUES (203,"CZECH REPUBLIC",'CZ','CZE',1);
INSERT INTO uc_countries VALUES (208,"DENMARK",'DK','DNK',1);
INSERT INTO uc_countries VALUES (262,"DJIBOUTI",'DJ','DJI',1);
INSERT INTO uc_countries VALUES (212,"DOMINICA",'DM','DMA',1);
INSERT INTO uc_countries VALUES (214,"DOMINICAN REPUBLIC",'DO','DOM',1);
INSERT INTO uc_countries VALUES (218,"ECUADOR",'EC','ECU',1);
INSERT INTO uc_countries VALUES (818,"EGYPT",'EG','EGY',1);
INSERT INTO uc_countries VALUES (222,"EL SALVADOR",'SV','SLV',1);
INSERT INTO uc_countries VALUES (226,"EQUATORIAL GUINEA",'GQ','GNQ',1);
INSERT INTO uc_countries VALUES (232,"ERITREA",'ER','ERI',1);
INSERT INTO uc_countries VALUES (233,"ESTONIA",'EE','EST',1);
INSERT INTO uc_countries VALUES (231,"ETHIOPIA",'ET','ETH',1);
INSERT INTO uc_countries VALUES (238,"FALKLAND ISLANDS (MALVINAS)",'FK','FLK',1);
INSERT INTO uc_countries VALUES (234,"FAROE ISLANDS",'FO','FRO',1);
INSERT INTO uc_countries VALUES (242,"FIJI",'FJ','FJI',1);
INSERT INTO uc_countries VALUES (246,"FINLAND",'FI','FIN',1);
INSERT INTO uc_countries VALUES (250,"FRANCE",'FR','FRA',1);
INSERT INTO uc_countries VALUES (254,"FRENCH GUIANA",'GF','GUF',1);
INSERT INTO uc_countries VALUES (258,"FRENCH POLYNESIA",'PF','PYF',1);
INSERT INTO uc_countries VALUES (260,"FRENCH SOUTHERN TERRITORIES",'TF','ATF',1);
INSERT INTO uc_countries VALUES (266,"GABON",'GA','GAB',1);
INSERT INTO uc_countries VALUES (270,"GAMBIA",'GM','GMB',1);
INSERT INTO uc_countries VALUES (268,"GEORGIA",'GE','GEO',1);
INSERT INTO uc_countries VALUES (276,"GERMANY",'DE','DEU',1);
INSERT INTO uc_countries VALUES (288,"GHANA",'GH','GHA',1);
INSERT INTO uc_countries VALUES (292,"GIBRALTAR",'GI','GIB',1);
INSERT INTO uc_countries VALUES (300,"GREECE",'GR','GRC',1);
INSERT INTO uc_countries VALUES (304,"GREENLAND",'GL','GRL',1);
INSERT INTO uc_countries VALUES (308,"GRENADA",'GD','GRD',1);
INSERT INTO uc_countries VALUES (312,"GUADELOUPE",'GP','GLP',1);
INSERT INTO uc_countries VALUES (316,"GUAM",'GU','GUM',1);
INSERT INTO uc_countries VALUES (320,"GUATEMALA",'GT','GTM',1);
INSERT INTO uc_countries VALUES (831,"GUERNSEY",'GG','GGY',1);
INSERT INTO uc_countries VALUES (324,"GUINEA",'GN','GIN',1);
INSERT INTO uc_countries VALUES (624,"GUINEA-BISSAU",'GW','GNB',1);
INSERT INTO uc_countries VALUES (328,"GUYANA",'GY','GUY',1);
INSERT INTO uc_countries VALUES (332,"HAITI",'HT','HTI',1);
INSERT INTO uc_countries VALUES (334,"HEARD ISLAND AND MCDONALD ISLANDS",'HM','HMD',1);
INSERT INTO uc_countries VALUES (340,"HONDURAS",'HN','HND',1);
INSERT INTO uc_countries VALUES (344,"HONG KONG",'HK','HKG',1);
INSERT INTO uc_countries VALUES (348,"HUNGARY",'HU','HUN',1);
INSERT INTO uc_countries VALUES (352,"ICELAND",'IS','ISL',1);
INSERT INTO uc_countries VALUES (356,"INDIA",'IN','IND',1);
INSERT INTO uc_countries VALUES (360,"INDONESIA",'ID','IDN',1);
INSERT INTO uc_countries VALUES (364,"IRAN (ISLAMIC REPUBLIC OF)",'IR','IRN',1);
INSERT INTO uc_countries VALUES (368,"IRAQ",'IQ','IRQ',1);
INSERT INTO uc_countries VALUES (372,"IRELAND",'IE','IRL',1);
INSERT INTO uc_countries VALUES (833,"ISLE OF MAN",'IM','IMM',1);
INSERT INTO uc_countries VALUES (376,"ISRAEL",'IL','ISR',1);
INSERT INTO uc_countries VALUES (380,"ITALY",'IT','ITA',1);
INSERT INTO uc_countries VALUES (388,"JAMAICA",'JM','JAM',1);
INSERT INTO uc_countries VALUES (392,"JAPAN",'JP','JPN',1);
INSERT INTO uc_countries VALUES (832,"JERSEY",'JE','JEY',1);
INSERT INTO uc_countries VALUES (400,"JORDAN",'JO','JOR',1);
INSERT INTO uc_countries VALUES (398,"KAZAKHSTAN",'KZ','KAZ',1);
INSERT INTO uc_countries VALUES (404,"KENYA",'KE','KEN',1);
INSERT INTO uc_countries VALUES (296,"KIRIBATI",'KI','KIR',1);
INSERT INTO uc_countries VALUES (408,"KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF",'KP','PRK',1);
INSERT INTO uc_countries VALUES (410,"KOREA, REPUBLIC OF",'KR','KOR',1);
INSERT INTO uc_countries VALUES (414,"KUWAIT",'KW','KWT',1);
INSERT INTO uc_countries VALUES (417,"KYRGYZSTAN",'KG','KGZ',1);
INSERT INTO uc_countries VALUES (418,"LAO PEOPLE'S DEMOCRATIC REPUBLIC",'LA','LAO',1);
INSERT INTO uc_countries VALUES (428,"LATVIA",'LV','LVA',1);
INSERT INTO uc_countries VALUES (422,"LEBANON",'LB','LBN',1);
INSERT INTO uc_countries VALUES (426,"LESOTHO",'LS','LSO',1);
INSERT INTO uc_countries VALUES (430,"LIBERIA",'LR','LBR',1);
INSERT INTO uc_countries VALUES (434,"LIBYAN ARAB JAMAHIRIYA",'LY','LBY',1);
INSERT INTO uc_countries VALUES (438,"LIECHTENSTEIN",'LI','LIE',1);
INSERT INTO uc_countries VALUES (440,"LITHUANIA",'LT','LTU',1);
INSERT INTO uc_countries VALUES (442,"LUXEMBOURG",'LU','LUX',1);
INSERT INTO uc_countries VALUES (446,"MACAO",'MO','MAC',1);
INSERT INTO uc_countries VALUES (807,"MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF",'MK','MKD',1);
INSERT INTO uc_countries VALUES (450,"MADAGASCAR",'MG','MDG',1);
INSERT INTO uc_countries VALUES (454,"MALAWI",'MW','MWI',1);
INSERT INTO uc_countries VALUES (458,"MALAYSIA",'MY','MYS',1);
INSERT INTO uc_countries VALUES (462,"MALDIVES",'MV','MDV',1);
INSERT INTO uc_countries VALUES (466,"MALI",'ML','MLI',1);
INSERT INTO uc_countries VALUES (470,"MALTA",'MT','MLT',1);
INSERT INTO uc_countries VALUES (584,"MARSHALL ISLANDS",'MH','MHL',1);
INSERT INTO uc_countries VALUES (474,"MARTINIQUE",'MQ','MTQ',1);
INSERT INTO uc_countries VALUES (478,"MAURITANIA",'MR','MRT',1);
INSERT INTO uc_countries VALUES (480,"MAURITIUS",'MU','MUS',1);
INSERT INTO uc_countries VALUES (175,"MAYOTTE",'YT','MYT',1);
INSERT INTO uc_countries VALUES (484,"MEXICO",'MX','MEX',1);
INSERT INTO uc_countries VALUES (583,"MICRONESIA, FEDERATED STATES OF",'FM','FSM',1);
INSERT INTO uc_countries VALUES (498,"MOLDOVA, REPUBLIC OF",'MD','MDA',1);
INSERT INTO uc_countries VALUES (492,"MONACO",'MC','MCO',1);
INSERT INTO uc_countries VALUES (496,"MONGOLIA",'MN','MNG',1);
INSERT INTO uc_countries VALUES (499,"MONTENEGRO",'ME','MNE',1);
INSERT INTO uc_countries VALUES (500,"MONTSERRAT",'MS','MSR',1);
INSERT INTO uc_countries VALUES (504,"MOROCCO",'MA','MAR',1);
INSERT INTO uc_countries VALUES (508,"MOZAMBIQUE",'MZ','MOZ',1);
INSERT INTO uc_countries VALUES (104,"MYANMAR",'MM','MMR',1);
INSERT INTO uc_countries VALUES (516,"NAMIBIA",'NA','NAM',1);
INSERT INTO uc_countries VALUES (520,"NAURU",'NR','NRU',1);
INSERT INTO uc_countries VALUES (524,"NEPAL",'NP','NPL',1);
INSERT INTO uc_countries VALUES (528,"NETHERLANDS",'NL','NLD',1);
INSERT INTO uc_countries VALUES (530,"NETHERLANDS ANTILLES",'AN','ANT',1);
INSERT INTO uc_countries VALUES (540,"NEW CALEDONIA",'NC','NCL',1);
INSERT INTO uc_countries VALUES (554,"NEW ZEALAND",'NZ','NZL',1);
INSERT INTO uc_countries VALUES (558,"NICARAGUA",'NI','NIC',1);
INSERT INTO uc_countries VALUES (562,"NIGER",'NE','NER',1);
INSERT INTO uc_countries VALUES (566,"NIGERIA",'NG','NGA',1);
INSERT INTO uc_countries VALUES (570,"NIUE",'NU','NIU',1);
INSERT INTO uc_countries VALUES (574,"NORFOLK ISLAND",'NF','NFK',1);
INSERT INTO uc_countries VALUES (580,"NORTHERN MARIANA ISLANDS",'MP','MNP',1);
INSERT INTO uc_countries VALUES (578,"NORWAY",'NO','NOR',1);
INSERT INTO uc_countries VALUES (512,"OMAN",'OM','OMN',1);
INSERT INTO uc_countries VALUES (586,"PAKISTAN",'PK','PAK',1);
INSERT INTO uc_countries VALUES (585,"PALAU",'PW','PLW',1);
INSERT INTO uc_countries VALUES (275,"PALESTINIAN TERRITORY, OCCUPIED",'PS','PSE',1);
INSERT INTO uc_countries VALUES (591,"PANAMA",'PA','PAN',1);
INSERT INTO uc_countries VALUES (598,"PAPUA NEW GUINEA",'PG','PNG',1);
INSERT INTO uc_countries VALUES (600,"PARAGUAY",'PY','PRY',1);
INSERT INTO uc_countries VALUES (604,"PERU",'PE','PER',1);
INSERT INTO uc_countries VALUES (608,"PHILIPPINES",'PH','PHL',1);
INSERT INTO uc_countries VALUES (612,"PITCAIRN",'PN','PCN',1);
INSERT INTO uc_countries VALUES (616,"POLAND",'PL','POL',1);
INSERT INTO uc_countries VALUES (620,"PORTUGAL",'PT','PRT',1);
INSERT INTO uc_countries VALUES (630,"PUERTO RICO",'PR','PRI',1);
INSERT INTO uc_countries VALUES (634,"QATAR",'QA','QAT',1);
INSERT INTO uc_countries VALUES (638,"REUNION",'RE','REU',1);
INSERT INTO uc_countries VALUES (642,"ROMANIA",'RO','ROU',1);
INSERT INTO uc_countries VALUES (643,"RUSSIAN FEDERATION",'RU','RUS',1);
INSERT INTO uc_countries VALUES (646,"RWANDA",'RW','RWA',1);
INSERT INTO uc_countries VALUES (654,"SAINT HELENA",'SH','SHN',1);
INSERT INTO uc_countries VALUES (659,"SAINT KITTS AND NEVIS",'KN','KNA',1);
INSERT INTO uc_countries VALUES (662,"SAINT LUCIA",'LC','LCA',1);
INSERT INTO uc_countries VALUES (666,"SAINT PIERRE AND MIQUELON",'PM','SPM',1);
INSERT INTO uc_countries VALUES (670,"SAINT VINCENT AND THE GRENADINES",'VC','VCT',1);
INSERT INTO uc_countries VALUES (882,"SAMOA",'WS','WSM',1);
INSERT INTO uc_countries VALUES (674,"SAN MARINO",'SM','SMR',1);
INSERT INTO uc_countries VALUES (678,"SAO TOME AND PRINCIPE",'ST','STP',1);
INSERT INTO uc_countries VALUES (682,"SAUDI ARABIA",'SA','SAU',1);
INSERT INTO uc_countries VALUES (686,"SENEGAL",'SN','SEN',1);
INSERT INTO uc_countries VALUES (688,"SERBIA",'RS','SRB',1);
INSERT INTO uc_countries VALUES (690,"SEYCHELLES",'SC','SYC',1);
INSERT INTO uc_countries VALUES (694,"SIERRA LEONE",'SL','SLE',1);
INSERT INTO uc_countries VALUES (702,"SINGAPORE",'SG','SGP',1);
INSERT INTO uc_countries VALUES (703,"SLOVAKIA",'SK','SVK',1);
INSERT INTO uc_countries VALUES (705,"SLOVENIA",'SI','SVN',1);
INSERT INTO uc_countries VALUES (090,"SOLOMON ISLANDS",'SB','SLB',1);
INSERT INTO uc_countries VALUES (706,"SOMALIA",'SO','SOM',1);
INSERT INTO uc_countries VALUES (710,"SOUTH AFRICA",'ZA','ZAF',1);
INSERT INTO uc_countries VALUES (239,"SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS",'GS','SGS',1);
INSERT INTO uc_countries VALUES (724,"SPAIN",'ES','ESP',1);
INSERT INTO uc_countries VALUES (144,"SRI LANKA",'LK','LKA',1);
INSERT INTO uc_countries VALUES (736,"SUDAN",'SD','SDN',1);
INSERT INTO uc_countries VALUES (740,"SURINAME",'SR','SUR',1);
INSERT INTO uc_countries VALUES (744,"SVALBARD AND JAN MAYEN",'SJ','SJM',1);
INSERT INTO uc_countries VALUES (748,"SWAZILAND",'SZ','SWZ',1);
INSERT INTO uc_countries VALUES (752,"SWEDEN",'SE','SWE',1);
INSERT INTO uc_countries VALUES (756,"SWITZERLAND",'CH','CHE',1);
INSERT INTO uc_countries VALUES (760,"SYRIAN ARAB REPUBLIC",'SY','SYR',1);
INSERT INTO uc_countries VALUES (158,"TAIWAN, PROVINCE OF CHINA",'TW','TWN',1);
INSERT INTO uc_countries VALUES (762,"TAJIKISTAN",'TJ','TJK',1);
INSERT INTO uc_countries VALUES (834,"TANZANIA, UNITED REPUBLIC OF",'TZ','TZA',1);
INSERT INTO uc_countries VALUES (764,"THAILAND",'TH','THA',1);
INSERT INTO uc_countries VALUES (626,"TIMOR-LESTE",'TL','TLS',1);
INSERT INTO uc_countries VALUES (768,"TOGO",'TG','TGO',1);
INSERT INTO uc_countries VALUES (772,"TOKELAU",'TK','TKL',1);
INSERT INTO uc_countries VALUES (776,"TONGA",'TO','TON',1);
INSERT INTO uc_countries VALUES (780,"TRINIDAD AND TOBAGO",'TT','TTO',1);
INSERT INTO uc_countries VALUES (788,"TUNISIA",'TN','TUN',1);
INSERT INTO uc_countries VALUES (792,"TURKEY",'TR','TUR',1);
INSERT INTO uc_countries VALUES (795,"TURKMENISTAN",'TM','TKM',1);
INSERT INTO uc_countries VALUES (796,"TURKS AND CAICOS ISLANDS",'TC','TCA',1);
INSERT INTO uc_countries VALUES (798,"TUVALU",'TV','TUV',1);
INSERT INTO uc_countries VALUES (800,"UGANDA",'UG','UGA',1);
INSERT INTO uc_countries VALUES (804,"UKRAINE",'UA','UKR',1);
INSERT INTO uc_countries VALUES (784,"UNITED ARAB EMIRATES",'AE','ARE',1);
INSERT INTO uc_countries VALUES (826,"UNITED KINGDOM",'GB','GBR',1);
INSERT INTO uc_countries VALUES (840,"UNITED STATES",'US','USA',1);
INSERT INTO uc_countries VALUES (581,"UNITED STATES MINOR OUTLYING ISLANDS",'UM','UMI',1);
INSERT INTO uc_countries VALUES (858,"URUGUAY",'UY','URY',1);
INSERT INTO uc_countries VALUES (860,"UZBEKISTAN",'UZ','UZB',1);
INSERT INTO uc_countries VALUES (548,"VANUATU",'VU','VUT',1);
INSERT INTO uc_countries VALUES (336,"VATICAN CITY STATE (HOLY SEE)",'VA','VAT',1);
INSERT INTO uc_countries VALUES (862,"VENEZUELA",'VE','VEN',1);
INSERT INTO uc_countries VALUES (704,"VIET NAM",'VN','VNM',1);
INSERT INTO uc_countries VALUES (092,"VIRGIN ISLANDS (BRITISH)",'VG','VGB',1);
INSERT INTO uc_countries VALUES (850,"VIRGIN ISLANDS (U.S.)",'VI','VIR',1);
INSERT INTO uc_countries VALUES (876,"WALLIS AND FUTUNA",'WF','WLF',1);
INSERT INTO uc_countries VALUES (732,"WESTERN SAHARA",'EH','ESH',1);
INSERT INTO uc_countries VALUES (887,"YEMEN",'YE','YEM',1);
INSERT INTO uc_countries VALUES (891,"YUGOSLAVIA",'YU','YUG',1);
INSERT INTO uc_countries VALUES (894,"ZAMBIA",'ZM','ZMB',1);
INSERT INTO uc_countries VALUES (716,"ZIMBABWE",'ZW','ZWE',1);