<pre>
<?php
ob_start();
if( !isset($_GET['preview']) ){
$uri = ($_SERVER['REQUEST_URI'] != '/')?$_SERVER['REQUEST_URI']:'index.html';
$uri = str_replace('/','-',$uri);
if( file_exists('cache/'.$uri) )
{
echo file_get_contents('cache/'.$uri);
echo '<!-- im cached'.'cache/'.$uri.' created:'.date("Y-m-d H:i:s",filemtime('cache/'.$uri)).'--!>';
$date2 = strtotime(date('Y-m-d H:i:s'));
$date1 = filemtime('cache/'.$uri);
$diff = abs($date2 - $date1);
$hours = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days*60*60*24)/ (60*60));
if( $hours > 1) unlink('cache/'.$uri);
exit;
}
define('WP_USE_THEMES', true);
require('./wp-blog-header.php');
$content = ob_get_contents();
if(!preg_match('/Error establishing/mis',$content)){
file_put_contents('cache/'.$uri, $content);
}
echo '<!-- im not 2 cached--!>';
}
else{
define('WP_USE_THEMES', true);
require('./wp-blog-header.php');
}
echo '<!-- im not cached--!>';
?>
</pre>
the script will create a physical file and will be deleted after an hour.
deleting of files is not run by cron you can do it if you want but in this case once user access the page and see's expired cached it will be deleted and create new one.
Tuesday, January 15, 2013
Simple cache for websites
I used to have issues with shared hosting.
when you use database it will really slow your webpage. now to fix this i only fetch the data from the db once and save it as text file using cache
see below:
Wednesday, January 2, 2013
Yii save() is not saving
You probably have some issues with validation performed in CActiveRecord
to get the error just var_dump( $modelobject->getErrors())
or if you want to bypass the validation simply
$modelobject->save(false);
Sunday, December 2, 2012
YII: Fetch rows using msql In clause
$criteria = new CDbCriteria;
$criteria->addInCondition("model_id", $_POST['autoId']);
$Model= Model::model()->findAll($criteria);
Sunday, November 25, 2012
Add range in YII sql condition
$criteria->addBetweenCondition('expiry_date', ''.$this->date_first.'', ''.$this->date_last.'');
Sunday, November 18, 2012
list of countries states and provinces
http://purpleslinky.com/trivia/quizzes/list-of-world-countries-counties-states-provinces-currencies/
List of countries in sql format
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AQ','ANTARCTICA','Antarctica','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BV','BOUVET ISLAND','Bouvet Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CX','CHRISTMAS ISLAND','Christmas Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IN','INDIA','India','IND','356');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YT','MAYOTTE','Mayotte','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TL','TIMOR-LESTE','Timor-Leste','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AQ','ANTARCTICA','Antarctica','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BV','BOUVET ISLAND','Bouvet Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CX','CHRISTMAS ISLAND','Christmas Island','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IN','INDIA','India','IND','356');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YT','MAYOTTE','Mayotte','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TL','TIMOR-LESTE','Timor-Leste','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands','','');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO country (`code`,`name`,`printable_name`,`iso3`,`number_code`) VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');
Subscribe to:
Posts (Atom)