/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_DCountry` (
  `id` char(2) NOT NULL,
  `isoAlpha3` char(3) NOT NULL,
  `name` varchar(255) NOT NULL,
  `sorter` int(11) NOT NULL,
  `visible` enum('n','y') NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `isoAlpha3` (`isoAlpha3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_DCountry` (`id`, `isoAlpha3`, `name`, `sorter`, `visible`) VALUES ('AF','AFG','AFGHANISTAN',2,'y'),('AL','ALB','ALBANIA',3,'y'),('DZ','DZA','ALGERIA',4,'y'),('AD','AND','ANDORRA',5,'y'),('AO','AGO','ANGOLA',6,'y'),('AQ','ATA','ANTARCTICA',7,'y'),('AG','ATG','ANTIGUA AND BARBUDA',8,'y'),('AR','ARG','ARGENTINA',9,'y'),('AM','ARM','ARMENIA',10,'y'),('AW','ABW','ARUBA',11,'y'),('AU','AUS','AUSTRALIA',12,'y'),('AT','AUT','AUSTRIA',13,'y'),('AZ','AZE','AZERBAIJAN',14,'y'),('BS','BHS','BAHAMAS',15,'y'),('BH','BHR','BAHRAIN',16,'y'),('BD','BGD','BANGLADESH',17,'y'),('BB','BRB','BARBADOS',18,'y'),('BY','BLR','BELARUS',19,'y'),('BE','BEL','BELGIUM',20,'y'),('BZ','BLZ','BELIZE',21,'y'),('BJ','BEN','BENIN',22,'y'),('BM','BMU','BERMUDA',23,'y'),('BT','BTN','BHUTAN',24,'y'),('BO','BOL','BOLIVIA',25,'y'),('BA','BIH','BOSNIA AND HERZEGOVINA',26,'y'),('BW','BWA','BOTSWANA',27,'y'),('BR','BRA','BRAZIL',28,'y'),('IO','IOT','BRITISH INDIAN OCEAN TERRITORY',29,'y'),('BN','BRN','BRUNEI DARUSSALAM',30,'y'),('BG','BGR','BULGARIA',31,'y'),('BF','BFA','BURKINA FASO',32,'y'),('BI','BDI','BURUNDI',33,'y'),('KH','KHM','CAMBODIA',34,'y'),('CM','CMR','CAMEROON',35,'y'),('CA','CAN','CANADA',36,'y'),('CV','CPV','CAPE VERDE',37,'y'),('CF','CAF','CENTRAL AFRICAN REPUBLIC',38,'y'),('TD','TCD','CHAD',39,'y'),('CL','CHL','CHILE',40,'y'),('CN','CHN','CHINA',41,'y'),('CO','COL','COLOMBIA',42,'y'),('KM','COM','COMOROS',43,'y'),('CG','COG','CONGO',44,'y'),('CD','COD','CONGO, DEMOCRATIC REPUBLIC OF THE',45,'y'),('CR','CRI','COSTA RICA',46,'y'),('CI','CIV','COTE D\'IVOIRE',47,'y'),('HR','HRV','CROATIA',48,'y'),('CU','CUB','CUBA',49,'y'),('CY','CYP','CYPRUS',50,'y'),('CZ','CZE','CZECH REPUBLIC',51,'y'),('DK','DNK','DENMARK',52,'y'),('DJ','DJI','DJIBOUTI',53,'y'),('DM','DMA','DOMINICA',54,'y'),('DO','DOM','DOMINICAN REPUBLIC',55,'y'),('EC','ECU','ECUADOR',56,'y'),('EG','EGY','EGYPT',57,'y'),('SV','SLV','EL SALVADOR',58,'y'),('GQ','GNQ','EQUATORIAL GUINEA',59,'y'),('ER','ERI','ERITREA',60,'y'),('EE','EST','ESTONIA',61,'y'),('ET','ETH','ETHIOPIA',62,'y'),('FO','FRO','FAROE ISLANDS',63,'y'),('FJ','FJI','FIJI',64,'y'),('FI','FIN','FINLAND',65,'y'),('FR','FRA','FRANCE',66,'y'),('GF','GUF','FRENCH GUIANA',67,'y'),('TF','ATF','FRENCH SOUTHERN TERRITORIES',68,'y'),('GA','GAB','GABON',69,'y'),('GM','GMB','GAMBIA',70,'y'),('GE','GEO','GEORGIA',71,'y'),('DE','DEU','GERMANY',72,'y'),('GH','GHA','GHANA',73,'y'),('GR','GRC','GREECE',74,'y'),('GD','GRD','GRENADA',75,'y'),('GP','GLP','GUADELOUPE',76,'y'),('GT','GTM','GUATEMALA',77,'y'),('GN','GIN','GUINEA',78,'y'),('GW','GNB','GUINEA-BISSAU',79,'y'),('GY','GUY','GUYANA',80,'y'),('HT','HTI','HAITI',81,'y'),('HN','HND','HONDURAS',82,'y'),('HU','HUN','HUNGARY',83,'y'),('IS','ISL','ICELAND',84,'y'),('IN','IND','INDIA',85,'y'),('ID','IDN','INDONESIA',86,'y'),('IR','IRN','IRAN, ISLAMIC REPUBLIC OF',87,'y'),('IQ','IRQ','IRAQ',88,'y'),('IE','IRL','IRELAND',89,'y'),('IL','ISR','ISRAEL',90,'y'),('IT','ITA','ITALY',91,'y'),('JM','JAM','JAMAICA',92,'y'),('JP','JPN','JAPAN',93,'y'),('JE','JEY','JERSEY',94,'y'),('JO','JOR','JORDAN',95,'y'),('KZ','KAZ','KAZAKHSTAN',96,'y'),('KE','KEN','KENYA',97,'y'),('KI','KIR','KIRIBATI',98,'y'),('KP','PRK','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF',99,'y'),('KR','KOR','KOREA, REPUBLIC OF',100,'y'),('KW','KWT','KUWAIT',101,'y'),('KG','KGZ','KYRGYZSTAN',102,'y'),('LA','LAO','LAO PEOPLE\'S DEMOCRATIC REPUBLIC',103,'y'),('LV','LVA','LATVIA',104,'y'),('LB','LBN','LEBANON',105,'y'),('LS','LSO','LESOTHO',106,'y'),('LR','LBR','LIBERIA',107,'y'),('LY','LBY','LIBYAN ARAB JAMAHIRIYA',108,'y'),('LI','LIE','LIECHTENSTEIN',109,'y'),('LT','LTU','LITHUANIA',110,'y'),('LU','LUX','LUXEMBOURG',111,'y'),('MO','MAC','MACAU',112,'y'),('MK','MKD','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF',113,'y'),('MG','MDG','MADAGASCAR',114,'y'),('MW','MWI','MALAWI',115,'y'),('MY','MYS','MALAYSIA',116,'y'),('MV','MDV','MALDIVES',117,'y'),('ML','MLI','MALI',118,'y'),('MQ','MTQ','MARTINIQUE',119,'y'),('MR','MRT','MAURITANIA',120,'y'),('MU','MUS','MAURITIUS',121,'y'),('MX','MEX','MEXICO',122,'y'),('FM','FSM','MICRONESIA, FEDERATED STATES OF',123,'y'),('MD','MDA','MOLDOVA',124,'y'),('MC','MCO','MONACO',125,'y'),('MN','MNG','MONGOLIA',126,'y'),('ME','MNE','MONTENEGRO',127,'y'),('MS','MSR','MONTSERRAT',128,'y'),('MA','MAR','MOROCCO',129,'y'),('MZ','MOZ','MOZAMBIQUE',130,'y'),('MM','MMR','MYANMAR',131,'y'),('NA','NAM','NAMIBIA',132,'y'),('NP','NPL','NEPAL',133,'y'),('NL','NLD','NETHERLANDS',134,'y'),('NZ','NZL','NEW ZEALAND',135,'y'),('NI','NIC','NICARAGUA',136,'y'),('NE','NER','NIGER',137,'y'),('NG','NGA','NIGERIA',138,'y'),('NO','NOR','NORWAY',139,'y'),('OM','OMN','OMAN',140,'y'),('PK','PAK','PAKISTAN',141,'y'),('PW','PLW','PALAU',142,'y'),('PS','PSE','PALESTINIAN TERRITORY',143,'y'),('PA','PAN','PANAMA',144,'y'),('PG','PNG','PAPUA NEW GUINEA',145,'y'),('PY','PRY','PARAGUAY',146,'y'),('PE','PER','PERU',147,'y'),('PH','PHL','PHILIPPINES',148,'y'),('PL','POL','POLAND',149,'y'),('PT','PRT','PORTUGAL',150,'y'),('QA','QAT','QATAR',151,'y'),('RE','REU','REUNION',152,'y'),('RO','ROU','ROMANIA',153,'y'),('RU','RUS','RUSSIAN FEDERATION',154,'y'),('RW','RWA','RWANDA',155,'y'),('SH','SHN','SAINT HELENA',156,'y'),('KN','KNA','SAINT KITTS AND NEVIS',157,'y'),('LC','LCA','SAINT LUCIA',158,'y'),('VC','VCT','SAINT VINCENT AND THE GRENADINES',159,'y'),('SM','SMR','SAN MARINO',160,'y'),('ST','STP','SAO TOME AND PRINCIPE',161,'y'),('SA','SAU','SAUDI ARABIA',162,'y'),('SN','SEN','SENEGAL',163,'y'),('RS','SRB','SERBIA',164,'y'),('SC','SYC','SEYCHELLES',165,'y'),('SL','SLE','SIERRA LEONE',166,'y'),('SK','SVK','SLOVAKIA',167,'y'),('SI','SVN','SLOVENIA',168,'y'),('SB','SLB','SOLOMON ISLANDS',169,'y'),('SO','SOM','SOMALIA',170,'y'),('ZA','ZAF','SOUTH AFRICA',171,'y'),('ES','ESP','SPAIN',172,'y'),('LK','LKA','SRI LANKA',173,'y'),('SD','SDN','SUDAN',174,'y'),('SR','SUR','SURINAME',175,'y'),('SZ','SWZ','SWAZILAND',176,'y'),('SE','SWE','SWEDEN',177,'y'),('CH','CHE','SWITZERLAND',178,'y'),('SY','SYR','SYRIAN ARAB REPUBLIC',179,'y'),('TW','TWN','TAIWAN, PROVINCE OF CHINA',180,'y'),('TJ','TJK','TAJIKISTAN',181,'y'),('TZ','TZA','TANZANIA, UNITED REPUBLIC OF',182,'y'),('TH','THA','THAILAND',183,'y'),('TL','TLS','TIMOR-LESTE (EAST TIMOR)',184,'y'),('TG','TGO','TOGO',185,'y'),('TT','TTO','TRINIDAD AND TOBAGO',186,'y'),('TN','TUN','TUNISIA',187,'y'),('TR','TUR','TURKEY',188,'y'),('TM','TKM','TURKMENISTAN',189,'y'),('UG','UGA','UGANDA',190,'y'),('UA','UKR','UKRAINE',191,'y'),('AE','ARE','UNITED ARAB EMIRATES',192,'y'),('GB','GBR','UNITED KINGDOM',193,'y'),('US','USA','UNITED STATES',0,'y'),('UY','URY','URUGUAY',195,'y'),('UZ','UZB','UZBEKISTAN',196,'y'),('VU','VUT','VANUATU',197,'y'),('VE','VEN','VENEZUELA',198,'y'),('VN','VNM','VIETNAM',199,'y'),('EH','ESH','WESTERN SAHARA',200,'y'),('YE','YEM','YEMEN',201,'y'),('ZM','ZMB','ZAMBIA',202,'y'),('ZW','ZWE','ZIMBABWE',203,'y');