X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=DOCS%2Fen%2Fcountry%2Fcountries-sorted.sql;h=6b3a5266c005b846ba1cd674d3d130e9368952b1;hp=85c0b1aa7b94cbd7338ff3999f61708aa69beb2c;hb=9a60a71dde1189e5c922a6dd377b862d08ea8f51;hpb=3010e02e68f51325da31625a29fe940646f6ff04;ds=sidebyside diff --git a/DOCS/en/country/countries-sorted.sql b/DOCS/en/country/countries-sorted.sql index 85c0b1aa7b..6b3a5266c0 100644 --- a/DOCS/en/country/countries-sorted.sql +++ b/DOCS/en/country/countries-sorted.sql @@ -1,257 +1,257 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','United Kingdom','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','England','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Great Britain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Scotland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Channel Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IE','Ireland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IF','Northern Ireland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IS','Iceland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IT','Italy','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NL','Netherlands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NO','Norway','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FJ','Fiji','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','United Kingdom','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','England','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Great Britain','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Scotland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Channel Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IE','Ireland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IF','Northern Ireland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IS','Iceland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IT','Italy','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NL','Netherlands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NO','Norway','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FJ','Fiji','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); +INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y');