· 8 years ago · Jul 07, 2018, 12:18 PM
1DROP TABLE IF EXISTS `countrycode`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `countrycode` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `country` varchar(150) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;
9/*!40101 SET character_set_client = @saved_cs_client */;
10
11--
12-- Dumping data for table `countrycode`
13--
14
15LOCK TABLES `countrycode` WRITE;
16/*!40000 ALTER TABLE `countrycode` DISABLE KEYS */;
17INSERT INTO `countrycode` VALUES (2,'Alaska'),(3,'Albania'),(4,'Algeria'),(5,'AmericanSamoa'),(6,'Andorra'),(7,'Angola'),(8,'Antarctica'),(9,'Argentina'),(10,'Armenia'),(11,'Aruba'),(12,'Ascension'),(13,'Australia'),(14,'Austria'),(15,'Azerbaijan'),(16,'Bahrain'),(17,'Bangladesh'),(18,'Belarus'),(19,'Belgium'),(20,'Belize'),(21,'Benin'),(22,'Bhutan'),(23,'Bolivia'),(24,'Bosnia & Herzegovina'),(25,'Botswana'),(26,'Brazil'),(27,'Brunei Darussalam'),(28,'Bulgaria'),(29,'Burkina Faso'),(30,'Burundi'),(31,'Cambodia'),(32,'Cameroon'),(33,'Canada'),(34,'Cape Verde Islands'),(35,'Central African Republic'),(36,'Chad'),(37,'Chile'),(38,'China'),(39,'Colombia'),(40,'Comoros'),(41,'Congo'),(42,'Cook Islands'),(43,'Costa Rica'),(44,'Croatia'),(45,'Cuba'),(46,'Cuba Guantanamo Bay'),(47,'Cyprus'),(48,'Czech Republic'),(49,'Denmark'),(50,'Diego Garcia'),(51,'Djibouti'),(52,'Dominican Republic'),(53,'East Timor'),(54,'Ecuador'),(55,'Egypt'),(56,'El Salvador'),(57,'Equatorial Guinea'),(58,'Eritrea'),(59,'Estonia'),(60,'Ethiopia'),(61,'Faroe Islands'),(62,'Fiji Islands'),(63,'Finland'),(64,'France'),(65,'French Guiana'),(66,'French Polynesia'),(67,'Gabonese Republic'),(68,'Gambia'),(69,'Georgia'),(70,'Germany'),(71,'Ghana'),(72,'Gibraltar'),(73,'Greece'),(74,'Greenland'),(75,'Guadeloupe'),(76,'Guam'),(77,'Guatemala'),(78,'Guinea'),(79,'Guyana'),(80,'Haiti'),(81,'Honduras'),(82,'Hong Kong'),(83,'Hungary'),(84,'Iceland'),(85,'India'),(86,'Indonesia'),(87,'Iran'),(88,'Iraq'),(89,'Ireland'),(90,'Israel'),(91,'Italy'),(92,'Jamaica'),(93,'Japan'),(94,'Jordan'),(95,'Kazakstan'),(96,'Kenya'),(97,'Kiribati'),(98,'Kuwait'),(99,'Kyrgyz Republic'),(100,'Laos'),(101,'Latvia'),(102,'Lebanon'),(103,'Lesotho'),(104,'Liberia'),(105,'Libya'),(106,'Liechtenstein'),(107,'Lithuania'),(108,'Luxembourg'),(109,'Macao'),(110,'Madagascar'),(111,'Malawi'),(112,'Malaysia'),(113,'Maldives'),(114,'Mali Republic'),(115,'Malta'),(116,'Marshall Islands'),(117,'Martinique'),(118,'Mauritania'),(119,'Mauritius'),(120,'MayotteIsland'),(121,'Mexico'),(122,'Midway Islands'),(123,'Moldova'),(124,'Monaco'),(125,'Mongolia'),(126,'Morocco'),(127,'Mozambique'),(128,'Myanmar'),(129,'Namibia'),(130,'Nauru'),(131,'Nepal'),(132,'Netherlands'),(133,'Netherlands Antilles'),(134,'New Caledonia'),(135,'New Zealand'),(136,'Nicaragua'),(137,'Niger'),(138,'Nigeria'),(139,'Niue'),(140,'Norfolk Island'),(141,'North Korea'),(142,'Norway'),(143,'Oman'),(144,'Pakistan'),(145,'Palau'),(146,'Palestinian Settlements'),(147,'Panama'),(148,'PapuaNew Guinea'),(149,'Paraguay'),(150,'Peru'),(151,'Philippines'),(152,'Poland'),(153,'Portugal'),(154,'Puerto Rico'),(155,'Qatar'),(156,'RéunionIsland'),(157,'Romania'),(158,'Russia'),(159,'Rwandese Republic'),(160,'San Marino'),(161,'Saudi Arabia'),(162,'São Tomé and Principe'),(163,'Senegal '),(164,'Serbia and Montenegro'),(165,'Seychelles Republic'),(166,'Sierra Leone'),(167,'Singapore'),(168,'Slovak Republic'),(169,'Slovenia'),(170,'Solomon Islands'),(171,'Somali Democratic Republic'),(172,'South Africa'),(173,'South Korea'),(174,'Spain'),(175,'Sri Lanka'),(176,'St Kitts - Nevis'),(177,'St. Helena'),(178,'St. Lucia'),(179,'St. Pierre & Miquelon'),(180,'St. Vincent & Grenadines'),(181,'Sudan'),(182,'Suriname'),(183,'Swaziland'),(184,'Sweden'),(185,'Switzerland'),(186,'Syria'),(187,'Taiwan'),(188,'Tajikistan'),(189,'Tanzania'),(190,'Thailand'),(191,'Togolese Republic'),(192,'Tokelau'),(193,'Tonga Islands'),(194,'Trinidad & Tobago'),(195,'Tunisia'),(196,'Turkey'),(197,'Turkmenistan'),(198,'Tuvalu'),(199,'Uganda'),(200,'Ukraine'),(201,'United Arab Emirates'),(202,'United Kingdom'),(203,'United States of America'),(204,'Uruguay'),(205,'Uzbekistan'),(206,'Vanuatu'),(207,'Venezuela'),(208,'Vietnam'),(209,'Wake Island'),(210,'Wallisand Futuna Islands'),(211,'Western Samoa'),(212,'Yemen'),(213,'Zambia'),(214,'Zimbabwe'),(215,'po[');
18/*!40000 ALTER TABLE `countrycode` ENABLE KEYS */;
19UNLOCK TABLES;