Skip to content

Instantly share code, notes, and snippets.

@Mutahhar

Mutahhar/continents.sql

Last active December 26, 2019 13:38
Show Gist options
  • Save Mutahhar/3c3cf883420780e69e4cb20612605328 to your computer and use it in GitHub Desktop.
Save Mutahhar/3c3cf883420780e69e4cb20612605328 to your computer and use it in GitHub Desktop.
Download ZIP
SQL statement for creating continents and countries tables and relations in them
Raw
continents.sql
DROP TABLE IF EXISTS `continents`;
CREATE TABLE `continents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`slug` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `continents` */
insert into `continents`(`id`,`code`,`title`,`created_at`,`updated_at`,`slug`) values
(1,'AF','Africa','2017-02-22 21:36:41','2017-02-22 21:36:41','africa'),
(2,'AS','Asia','2017-02-22 21:36:41','2017-02-22 21:36:41','asia'),
(3,'EU','Europe','2017-02-22 21:36:41','2017-02-22 21:36:41','europe'),
(4,'NA','North America','2017-02-22 21:36:41','2017-02-22 21:36:41','north-america'),
(5,'SA','South America','2017-02-22 21:36:41','2017-02-22 21:36:41','south-america'),
(6,'OC','Oceania','2017-02-22 21:36:41','2017-02-22 21:36:41','oceania'),
(7,'AN','Antarctica','2017-02-22 21:36:41','2017-02-22 21:36:41','antarctica');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Raw
countries.sql
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `countries` */
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`continent_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`iso3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`full_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`slug` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `countries` */
insert into `countries`(`id`,`code`,`title`,`continent_code`,`iso3`,`number`,`full_name`,`created_at`,`updated_at`,`slug`) values
(1,'AF','Afghanistan','AS','AFG',4,'Islamic Republic of Afghanistan','2017-02-22 21:37:38','2017-02-22 21:37:38','afghanistan'),
(2,'AX','Aland Islands','EU','ALA',248,'Åland Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','aland-islands'),
(3,'AL','Albania','EU','ALB',8,'Republic of Albania','2017-02-22 21:37:38','2017-02-22 21:37:38','albania'),
(4,'DZ','Algeria','AF','DZA',12,'People\'s Democratic Republic of Algeria','2017-02-22 21:37:38','2017-02-22 21:37:38','algeria'),
(5,'AS','American Samoa','OC','ASM',16,'American Samoa','2017-02-22 21:37:38','2017-02-22 21:37:38','american-samoa'),
(6,'AD','Andorra','EU','AND',20,'Principality of Andorra','2017-02-22 21:37:38','2017-02-22 21:37:38','andorra'),
(7,'AO','Angola','AF','AGO',24,'Republic of Angola','2017-02-22 21:37:38','2017-02-22 21:37:38','angola'),
(8,'AI','Anguilla','NA','AIA',660,'Anguilla','2017-02-22 21:37:38','2017-02-22 21:37:38','anguilla'),
(9,'AQ','Antarctica','AN','ATA',10,'Antarctica (the territory South of 60 deg S)','2017-02-22 21:37:38','2017-02-22 21:37:38','antarctica'),
(10,'AG','Antigua and Barbuda','NA','ATG',28,'Antigua and Barbuda','2017-02-22 21:37:38','2017-02-22 21:37:38','antigua-and-barbuda'),
(11,'AR','Argentina','SA','ARG',32,'Argentine Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','argentina'),
(12,'AM','Armenia','AS','ARM',51,'Republic of Armenia','2017-02-22 21:37:38','2017-02-22 21:37:38','armenia'),
(13,'AW','Aruba','NA','ABW',533,'Aruba','2017-02-22 21:37:38','2017-02-22 21:37:38','aruba'),
(14,'AU','Australia','OC','AUS',36,'Commonwealth of Australia','2017-02-22 21:37:38','2017-02-22 21:37:38','australia'),
(15,'AT','Austria','EU','AUT',40,'Republic of Austria','2017-02-22 21:37:38','2017-02-22 21:37:38','austria'),
(16,'AZ','Azerbaijan','AS','AZE',31,'Republic of Azerbaijan','2017-02-22 21:37:38','2017-02-22 21:37:38','azerbaijan'),
(17,'BS','Bahamas','NA','BHS',44,'Commonwealth of the Bahamas','2017-02-22 21:37:38','2017-02-22 21:37:38','bahamas'),
(18,'BH','Bahrain','AS','BHR',48,'Kingdom of Bahrain','2017-02-22 21:37:38','2017-02-22 21:37:38','bahrain'),
(19,'BD','Bangladesh','AS','BGD',50,'People\'s Republic of Bangladesh','2017-02-22 21:37:38','2017-02-22 21:37:38','bangladesh'),
(20,'BB','Barbados','NA','BRB',52,'Barbados','2017-02-22 21:37:38','2017-02-22 21:37:38','barbados'),
(21,'BY','Belarus','EU','BLR',112,'Republic of Belarus','2017-02-22 21:37:38','2017-02-22 21:37:38','belarus'),
(22,'BE','Belgium','EU','BEL',56,'Kingdom of Belgium','2017-02-22 21:37:38','2017-02-22 21:37:38','belgium'),
(23,'BZ','Belize','NA','BLZ',84,'Belize','2017-02-22 21:37:38','2017-02-22 21:37:38','belize'),
(24,'BJ','Benin','AF','BEN',204,'Republic of Benin','2017-02-22 21:37:38','2017-02-22 21:37:38','benin'),
(25,'BM','Bermuda','NA','BMU',60,'Bermuda','2017-02-22 21:37:38','2017-02-22 21:37:38','bermuda'),
(26,'BT','Bhutan','AS','BTN',64,'Kingdom of Bhutan','2017-02-22 21:37:38','2017-02-22 21:37:38','bhutan'),
(27,'BO','Bolivia','SA','BOL',68,'Plurinational State of Bolivia','2017-02-22 21:37:38','2017-02-22 21:37:38','bolivia'),
(28,'BQ','Bonaire Sint Eustatius and Saba','NA','BES',535,'Bonaire, Sint Eustatius and Saba','2017-02-22 21:37:38','2017-02-22 21:37:38','bonaire-sint-eustatius-and-saba'),
(29,'BA','Bosnia and Herzegovina','EU','BIH',70,'Bosnia and Herzegovina','2017-02-22 21:37:38','2017-02-22 21:37:38','bosnia-and-herzegovina'),
(30,'BW','Botswana','AF','BWA',72,'Republic of Botswana','2017-02-22 21:37:38','2017-02-22 21:37:38','botswana'),
(31,'BV','Bouvet Island Bouvetoya','AN','BVT',74,'Bouvet Island (Bouvetøya)','2017-02-22 21:37:38','2017-02-22 21:37:38','bouvet-island-bouvetoya'),
(32,'BR','Brazil','SA','BRA',76,'Federative Republic of Brazil','2017-02-22 21:37:38','2017-02-22 21:37:38','brazil'),
(33,'IO','British Indian Ocean Territory Chagos Archipelago','AS','IOT',86,'British Indian Ocean Territory (Chagos Archipelago)','2017-02-22 21:37:38','2017-02-22 21:37:38','british-indian-ocean-territory-chagos-archipelago'),
(34,'VG','British Virgin Islands','NA','VGB',92,'British Virgin Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','british-virgin-islands'),
(35,'BN','Brunei Darussalam','AS','BRN',96,'Brunei Darussalam','2017-02-22 21:37:38','2017-02-22 21:37:38','brunei-darussalam'),
(36,'BG','Bulgaria','EU','BGR',100,'Republic of Bulgaria','2017-02-22 21:37:38','2017-02-22 21:37:38','bulgaria'),
(37,'BF','Burkina Faso','AF','BFA',854,'Burkina Faso','2017-02-22 21:37:38','2017-02-22 21:37:38','burkina-faso'),
(38,'BI','Burundi','AF','BDI',108,'Republic of Burundi','2017-02-22 21:37:38','2017-02-22 21:37:38','burundi'),
(39,'KH','Cambodia','AS','KHM',116,'Kingdom of Cambodia','2017-02-22 21:37:38','2017-02-22 21:37:38','cambodia'),
(40,'CM','Cameroon','AF','CMR',120,'Republic of Cameroon','2017-02-22 21:37:38','2017-02-22 21:37:38','cameroon'),
(41,'CA','Canada','NA','CAN',124,'Canada','2017-02-22 21:37:38','2017-02-22 21:37:38','canada'),
(42,'CV','Cabo Verde','AF','CPV',132,'Republic of Cabo Verde','2017-02-22 21:37:38','2017-02-22 21:37:38','cabo-verde'),
(43,'KY','Cayman Islands','NA','CYM',136,'Cayman Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','cayman-islands'),
(44,'CF','Central African Republic','AF','CAF',140,'Central African Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','central-african-republic'),
(45,'TD','Chad','AF','TCD',148,'Republic of Chad','2017-02-22 21:37:38','2017-02-22 21:37:38','chad'),
(46,'CL','Chile','SA','CHL',152,'Republic of Chile','2017-02-22 21:37:38','2017-02-22 21:37:38','chile'),
(47,'CN','China','AS','CHN',156,'People\'s Republic of China','2017-02-22 21:37:38','2017-02-22 21:37:38','china'),
(48,'CX','Christmas Island','AS','CXR',162,'Christmas Island','2017-02-22 21:37:38','2017-02-22 21:37:38','christmas-island'),
(49,'CC','Cocos Keeling Islands','AS','CCK',166,'Cocos (Keeling) Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','cocos-keeling-islands'),
(50,'CO','Colombia','SA','COL',170,'Republic of Colombia','2017-02-22 21:37:38','2017-02-22 21:37:38','colombia'),
(51,'KM','Comoros','AF','COM',174,'Union of the Comoros','2017-02-22 21:37:38','2017-02-22 21:37:38','comoros'),
(52,'CD','Congo','AF','COD',180,'Democratic Republic of the Congo','2017-02-22 21:37:38','2017-02-22 21:37:38','congo'),
(53,'CG','Congo','AF','COG',178,'Republic of the Congo','2017-02-22 21:37:38','2017-02-22 21:37:38','democratic-congo'),
(54,'CK','Cook Islands','OC','COK',184,'Cook Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','cook-islands'),
(55,'CR','Costa Rica','NA','CRI',188,'Republic of Costa Rica','2017-02-22 21:37:38','2017-02-22 21:37:38','costa-rica'),
(56,'CI','Cote dIvoire','AF','CIV',384,'Republic of Cote d\'Ivoire','2017-02-22 21:37:38','2017-02-22 21:37:38','cote-divoire'),
(57,'HR','Croatia','EU','HRV',191,'Republic of Croatia','2017-02-22 21:37:38','2017-02-22 21:37:38','croatia'),
(58,'CU','Cuba','NA','CUB',192,'Republic of Cuba','2017-02-22 21:37:38','2017-02-22 21:37:38','cuba'),
(59,'CW','Curacao','NA','CUW',531,'Curaçao','2017-02-22 21:37:38','2017-02-22 21:37:38','curacao'),
(60,'CY','Cyprus','AS','CYP',196,'Republic of Cyprus','2017-02-22 21:37:38','2017-02-22 21:37:38','cyprus'),
(61,'CZ','Czechia','EU','CZE',203,'Czech Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','czechia'),
(62,'DK','Denmark','EU','DNK',208,'Kingdom of Denmark','2017-02-22 21:37:38','2017-02-22 21:37:38','denmark'),
(63,'DJ','Djibouti','AF','DJI',262,'Republic of Djibouti','2017-02-22 21:37:38','2017-02-22 21:37:38','djibouti'),
(64,'DM','Dominica','NA','DMA',212,'Commonwealth of Dominica','2017-02-22 21:37:38','2017-02-22 21:37:38','dominica'),
(65,'DO','Dominican Republic','NA','DOM',214,'Dominican Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','dominican-republic'),
(66,'EC','Ecuador','SA','ECU',218,'Republic of Ecuador','2017-02-22 21:37:38','2017-02-22 21:37:38','ecuador'),
(67,'EG','Egypt','AF','EGY',818,'Arab Republic of Egypt','2017-02-22 21:37:38','2017-02-22 21:37:38','egypt'),
(68,'SV','El Salvador','NA','SLV',222,'Republic of El Salvador','2017-02-22 21:37:38','2017-02-22 21:37:38','el-salvador'),
(69,'GQ','Equatorial Guinea','AF','GNQ',226,'Republic of Equatorial Guinea','2017-02-22 21:37:38','2017-02-22 21:37:38','equatorial-guinea'),
(70,'ER','Eritrea','AF','ERI',232,'State of Eritrea','2017-02-22 21:37:38','2017-02-22 21:37:38','eritrea'),
(71,'EE','Estonia','EU','EST',233,'Republic of Estonia','2017-02-22 21:37:38','2017-02-22 21:37:38','estonia'),
(72,'ET','Ethiopia','AF','ETH',231,'Federal Democratic Republic of Ethiopia','2017-02-22 21:37:38','2017-02-22 21:37:38','ethiopia'),
(73,'FO','Faroe Islands','EU','FRO',234,'Faroe Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','faroe-islands'),
(74,'FK','Falkland Islands Malvinas','SA','FLK',238,'Falkland Islands (Malvinas)','2017-02-22 21:37:38','2017-02-22 21:37:38','falkland-islands-malvinas'),
(75,'FJ','Fiji','OC','FJI',242,'Republic of Fiji','2017-02-22 21:37:38','2017-02-22 21:37:38','fiji'),
(76,'FI','Finland','EU','FIN',246,'Republic of Finland','2017-02-22 21:37:38','2017-02-22 21:37:38','finland'),
(77,'FR','France','EU','FRA',250,'French Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','france'),
(78,'GF','French Guiana','SA','GUF',254,'French Guiana','2017-02-22 21:37:38','2017-02-22 21:37:38','french-guiana'),
(79,'PF','French Polynesia','OC','PYF',258,'French Polynesia','2017-02-22 21:37:38','2017-02-22 21:37:38','french-polynesia'),
(80,'TF','French Southern Territories','AN','ATF',260,'French Southern Territories','2017-02-22 21:37:38','2017-02-22 21:37:38','french-southern-territories'),
(81,'GA','Gabon','AF','GAB',266,'Gabonese Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','gabon'),
(82,'GM','Gambia','AF','GMB',270,'Islamic Republic of the Gambia','2017-02-22 21:37:38','2017-02-22 21:37:38','gambia'),
(83,'GE','Georgia','AS','GEO',268,'Georgia','2017-02-22 21:37:38','2017-02-22 21:37:38','georgia'),
(84,'DE','Germany','EU','DEU',276,'Federal Republic of Germany','2017-02-22 21:37:38','2017-02-22 21:37:38','germany'),
(85,'GH','Ghana','AF','GHA',288,'Republic of Ghana','2017-02-22 21:37:38','2017-02-22 21:37:38','ghana'),
(86,'GI','Gibraltar','EU','GIB',292,'Gibraltar','2017-02-22 21:37:38','2017-02-22 21:37:38','gibraltar'),
(87,'GR','Greece','EU','GRC',300,'Hellenic Republic of Greece','2017-02-22 21:37:38','2017-02-22 21:37:38','greece'),
(88,'GL','Greenland','NA','GRL',304,'Greenland','2017-02-22 21:37:38','2017-02-22 21:37:38','greenland'),
(89,'GD','Grenada','NA','GRD',308,'Grenada','2017-02-22 21:37:38','2017-02-22 21:37:38','grenada'),
(90,'GP','Guadeloupe','NA','GLP',312,'Guadeloupe','2017-02-22 21:37:38','2017-02-22 21:37:38','guadeloupe'),
(91,'GU','Guam','OC','GUM',316,'Guam','2017-02-22 21:37:38','2017-02-22 21:37:38','guam'),
(92,'GT','Guatemala','NA','GTM',320,'Republic of Guatemala','2017-02-22 21:37:38','2017-02-22 21:37:38','guatemala'),
(93,'GG','Guernsey','EU','GGY',831,'Bailiwick of Guernsey','2017-02-22 21:37:38','2017-02-22 21:37:38','guernsey'),
(94,'GN','Guinea','AF','GIN',324,'Republic of Guinea','2017-02-22 21:37:38','2017-02-22 21:37:38','guinea'),
(95,'GW','Guinea-Bissau','AF','GNB',624,'Republic of Guinea-Bissau','2017-02-22 21:37:38','2017-02-22 21:37:38','guinea-bissau'),
(96,'GY','Guyana','SA','GUY',328,'Co-operative Republic of Guyana','2017-02-22 21:37:38','2017-02-22 21:37:38','guyana'),
(97,'HT','Haiti','NA','HTI',332,'Republic of Haiti','2017-02-22 21:37:38','2017-02-22 21:37:38','haiti'),
(98,'HM','Heard Island and McDonald Islands','AN','HMD',334,'Heard Island and McDonald Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','heard-island-and-mcdonald-islands'),
(99,'VA','Holy See Vatican City State','EU','VAT',336,'Holy See (Vatican City State)','2017-02-22 21:37:38','2017-02-22 21:37:38','holy-see-vatican-city-state'),
(100,'HN','Honduras','NA','HND',340,'Republic of Honduras','2017-02-22 21:37:38','2017-02-22 21:37:38','honduras'),
(101,'HK','Hong Kong','AS','HKG',344,'Hong Kong Special Administrative Region of China','2017-02-22 21:37:38','2017-02-22 21:37:38','hong-kong'),
(102,'HU','Hungary','EU','HUN',348,'Hungary','2017-02-22 21:37:38','2017-02-22 21:37:38','hungary'),
(103,'IS','Iceland','EU','ISL',352,'Republic of Iceland','2017-02-22 21:37:38','2017-02-22 21:37:38','iceland'),
(104,'IN','India','AS','IND',356,'Republic of India','2017-02-22 21:37:38','2017-02-22 21:37:38','india'),
(105,'ID','Indonesia','AS','IDN',360,'Republic of Indonesia','2017-02-22 21:37:38','2017-02-22 21:37:38','indonesia'),
(106,'IR','Iran','AS','IRN',364,'Islamic Republic of Iran','2017-02-22 21:37:38','2017-02-22 21:37:38','iran'),
(107,'IQ','Iraq','AS','IRQ',368,'Republic of Iraq','2017-02-22 21:37:38','2017-02-22 21:37:38','iraq'),
(108,'IE','Ireland','EU','IRL',372,'Ireland','2017-02-22 21:37:38','2017-02-22 21:37:38','ireland'),
(109,'IM','Isle of Man','EU','IMN',833,'Isle of Man','2017-02-22 21:37:38','2017-02-22 21:37:38','isle-of-man'),
(110,'IL','Israel','AS','ISR',376,'State of Israel','2017-02-22 21:37:38','2017-02-22 21:37:38','israel'),
(111,'IT','Italy','EU','ITA',380,'Italian Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','italy'),
(112,'JM','Jamaica','NA','JAM',388,'Jamaica','2017-02-22 21:37:38','2017-02-22 21:37:38','jamaica'),
(113,'JP','Japan','AS','JPN',392,'Japan','2017-02-22 21:37:38','2017-02-22 21:37:38','japan'),
(114,'JE','Jersey','EU','JEY',832,'Bailiwick of Jersey','2017-02-22 21:37:38','2017-02-22 21:37:38','jersey'),
(115,'JO','Jordan','AS','JOR',400,'Hashemite Kingdom of Jordan','2017-02-22 21:37:38','2017-02-22 21:37:38','jordan'),
(116,'KZ','Kazakhstan','AS','KAZ',398,'Republic of Kazakhstan','2017-02-22 21:37:38','2017-02-22 21:37:38','kazakhstan'),
(117,'KE','Kenya','AF','KEN',404,'Republic of Kenya','2017-02-22 21:37:38','2017-02-22 21:37:38','kenya'),
(118,'KI','Kiribati','OC','KIR',296,'Republic of Kiribati','2017-02-22 21:37:38','2017-02-22 21:37:38','kiribati'),
(119,'KP','Korea','AS','PRK',408,'Democratic People\'s Republic of Korea','2017-02-22 21:37:38','2017-02-22 21:37:38','democratic-korea'),
(120,'KR','Korea','AS','KOR',410,'Republic of Korea','2017-02-22 21:37:38','2017-02-22 21:37:38','korea'),
(121,'KW','Kuwait','AS','KWT',414,'State of Kuwait','2017-02-22 21:37:38','2017-02-22 21:37:38','kuwait'),
(122,'KG','Kyrgyz Republic','AS','KGZ',417,'Kyrgyz Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','kyrgyz-republic'),
(123,'LA','Lao Peoples Democratic Republic','AS','LAO',418,'Lao People\'s Democratic Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','lao-peoples-democratic-republic'),
(124,'LV','Latvia','EU','LVA',428,'Republic of Latvia','2017-02-22 21:37:38','2017-02-22 21:37:38','latvia'),
(125,'LB','Lebanon','AS','LBN',422,'Lebanese Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','lebanon'),
(126,'LS','Lesotho','AF','LSO',426,'Kingdom of Lesotho','2017-02-22 21:37:38','2017-02-22 21:37:38','lesotho'),
(127,'LR','Liberia','AF','LBR',430,'Republic of Liberia','2017-02-22 21:37:38','2017-02-22 21:37:38','liberia'),
(128,'LY','Libya','AF','LBY',434,'Libya','2017-02-22 21:37:38','2017-02-22 21:37:38','libya'),
(129,'LI','Liechtenstein','EU','LIE',438,'Principality of Liechtenstein','2017-02-22 21:37:38','2017-02-22 21:37:38','liechtenstein'),
(130,'LT','Lithuania','EU','LTU',440,'Republic of Lithuania','2017-02-22 21:37:38','2017-02-22 21:37:38','lithuania'),
(131,'LU','Luxembourg','EU','LUX',442,'Grand Duchy of Luxembourg','2017-02-22 21:37:38','2017-02-22 21:37:38','luxembourg'),
(132,'MO','Macao','AS','MAC',446,'Macao Special Administrative Region of China','2017-02-22 21:37:38','2017-02-22 21:37:38','macao'),
(133,'MK','Macedonia','EU','MKD',807,'Republic of Macedonia','2017-02-22 21:37:38','2017-02-22 21:37:38','macedonia'),
(134,'MG','Madagascar','AF','MDG',450,'Republic of Madagascar','2017-02-22 21:37:38','2017-02-22 21:37:38','madagascar'),
(135,'MW','Malawi','AF','MWI',454,'Republic of Malawi','2017-02-22 21:37:38','2017-02-22 21:37:38','malawi'),
(136,'MY','Malaysia','AS','MYS',458,'Malaysia','2017-02-22 21:37:38','2017-02-22 21:37:38','malaysia'),
(137,'MV','Maldives','AS','MDV',462,'Republic of Maldives','2017-02-22 21:37:38','2017-02-22 21:37:38','maldives'),
(138,'ML','Mali','AF','MLI',466,'Republic of Mali','2017-02-22 21:37:38','2017-02-22 21:37:38','mali'),
(139,'MT','Malta','EU','MLT',470,'Republic of Malta','2017-02-22 21:37:38','2017-02-22 21:37:38','malta'),
(140,'MH','Marshall Islands','OC','MHL',584,'Republic of the Marshall Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','marshall-islands'),
(141,'MQ','Martinique','NA','MTQ',474,'Martinique','2017-02-22 21:37:38','2017-02-22 21:37:38','martinique'),
(142,'MR','Mauritania','AF','MRT',478,'Islamic Republic of Mauritania','2017-02-22 21:37:38','2017-02-22 21:37:38','mauritania'),
(143,'MU','Mauritius','AF','MUS',480,'Republic of Mauritius','2017-02-22 21:37:38','2017-02-22 21:37:38','mauritius'),
(144,'YT','Mayotte','AF','MYT',175,'Mayotte','2017-02-22 21:37:38','2017-02-22 21:37:38','mayotte'),
(145,'MX','Mexico','NA','MEX',484,'United Mexican States','2017-02-22 21:37:38','2017-02-22 21:37:38','mexico'),
(146,'FM','Micronesia','OC','FSM',583,'Federated States of Micronesia','2017-02-22 21:37:38','2017-02-22 21:37:38','micronesia'),
(147,'MD','Moldova','EU','MDA',498,'Republic of Moldova','2017-02-22 21:37:38','2017-02-22 21:37:38','moldova'),
(148,'MC','Monaco','EU','MCO',492,'Principality of Monaco','2017-02-22 21:37:38','2017-02-22 21:37:38','monaco'),
(149,'MN','Mongolia','AS','MNG',496,'Mongolia','2017-02-22 21:37:38','2017-02-22 21:37:38','mongolia'),
(150,'ME','Montenegro','EU','MNE',499,'Montenegro','2017-02-22 21:37:38','2017-02-22 21:37:38','montenegro'),
(151,'MS','Montserrat','NA','MSR',500,'Montserrat','2017-02-22 21:37:38','2017-02-22 21:37:38','montserrat'),
(152,'MA','Morocco','AF','MAR',504,'Kingdom of Morocco','2017-02-22 21:37:38','2017-02-22 21:37:38','morocco'),
(153,'MZ','Mozambique','AF','MOZ',508,'Republic of Mozambique','2017-02-22 21:37:38','2017-02-22 21:37:38','mozambique'),
(154,'MM','Myanmar','AS','MMR',104,'Republic of the Union of Myanmar','2017-02-22 21:37:38','2017-02-22 21:37:38','myanmar'),
(155,'NA','Namibia','AF','NAM',516,'Republic of Namibia','2017-02-22 21:37:38','2017-02-22 21:37:38','namibia'),
(156,'NR','Nauru','OC','NRU',520,'Republic of Nauru','2017-02-22 21:37:38','2017-02-22 21:37:38','nauru'),
(157,'NP','Nepal','AS','NPL',524,'Federal Democratic Republic of Nepal','2017-02-22 21:37:38','2017-02-22 21:37:38','nepal'),
(158,'NL','Netherlands','EU','NLD',528,'Kingdom of the Netherlands','2017-02-22 21:37:38','2017-02-22 21:37:38','netherlands'),
(159,'NC','New Caledonia','OC','NCL',540,'New Caledonia','2017-02-22 21:37:38','2017-02-22 21:37:38','new-caledonia'),
(160,'NZ','New Zealand','OC','NZL',554,'New Zealand','2017-02-22 21:37:38','2017-02-22 21:37:38','new-zealand'),
(161,'NI','Nicaragua','NA','NIC',558,'Republic of Nicaragua','2017-02-22 21:37:38','2017-02-22 21:37:38','nicaragua'),
(162,'NE','Niger','AF','NER',562,'Republic of Niger','2017-02-22 21:37:38','2017-02-22 21:37:38','niger'),
(163,'NG','Nigeria','AF','NGA',566,'Federal Republic of Nigeria','2017-02-22 21:37:38','2017-02-22 21:37:38','nigeria'),
(164,'NU','Niue','OC','NIU',570,'Niue','2017-02-22 21:37:38','2017-02-22 21:37:38','niue'),
(165,'NF','Norfolk Island','OC','NFK',574,'Norfolk Island','2017-02-22 21:37:38','2017-02-22 21:37:38','norfolk-island'),
(166,'MP','Northern Mariana Islands','OC','MNP',580,'Commonwealth of the Northern Mariana Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','northern-mariana-islands'),
(167,'NO','Norway','EU','NOR',578,'Kingdom of Norway','2017-02-22 21:37:38','2017-02-22 21:37:38','norway'),
(168,'OM','Oman','AS','OMN',512,'Sultanate of Oman','2017-02-22 21:37:38','2017-02-22 21:37:38','oman'),
(169,'PK','Pakistan','AS','PAK',586,'Islamic Republic of Pakistan','2017-02-22 21:37:38','2017-02-22 21:37:38','pakistan'),
(170,'PW','Palau','OC','PLW',585,'Republic of Palau','2017-02-22 21:37:38','2017-02-22 21:37:38','palau'),
(171,'PS','Palestine','AS','PSE',275,'State of Palestine','2017-02-22 21:37:38','2017-02-22 21:37:38','palestine'),
(172,'PA','Panama','NA','PAN',591,'Republic of Panama','2017-02-22 21:37:38','2017-02-22 21:37:38','panama'),
(173,'PG','Papua New Guinea','OC','PNG',598,'Independent State of Papua New Guinea','2017-02-22 21:37:38','2017-02-22 21:37:38','papua-new-guinea'),
(174,'PY','Paraguay','SA','PRY',600,'Republic of Paraguay','2017-02-22 21:37:38','2017-02-22 21:37:38','paraguay'),
(175,'PE','Peru','SA','PER',604,'Republic of Peru','2017-02-22 21:37:38','2017-02-22 21:37:38','peru'),
(176,'PH','Philippines','AS','PHL',608,'Republic of the Philippines','2017-02-22 21:37:38','2017-02-22 21:37:38','philippines'),
(177,'PN','Pitcairn Islands','OC','PCN',612,'Pitcairn Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','pitcairn-islands'),
(178,'PL','Poland','EU','POL',616,'Republic of Poland','2017-02-22 21:37:38','2017-02-22 21:37:38','poland'),
(179,'PT','Portugal','EU','PRT',620,'Portuguese Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','portugal'),
(180,'PR','Puerto Rico','NA','PRI',630,'Commonwealth of Puerto Rico','2017-02-22 21:37:38','2017-02-22 21:37:38','puerto-rico'),
(181,'QA','Qatar','AS','QAT',634,'State of Qatar','2017-02-22 21:37:38','2017-02-22 21:37:38','qatar'),
(182,'RE','Reunion','AF','REU',638,'Réunion','2017-02-22 21:37:38','2017-02-22 21:37:38','reunion'),
(183,'RO','Romania','EU','ROU',642,'Romania','2017-02-22 21:37:38','2017-02-22 21:37:38','romania'),
(184,'RU','Russian Federation','EU','RUS',643,'Russian Federation','2017-02-22 21:37:38','2017-02-22 21:37:38','russian-federation'),
(185,'RW','Rwanda','AF','RWA',646,'Republic of Rwanda','2017-02-22 21:37:38','2017-02-22 21:37:38','rwanda'),
(186,'BL','Saint Barthelemy','NA','BLM',652,'Saint Barthélemy','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-barthelemy'),
(187,'SH','Saint Helena Ascension and Tristan da Cunha','AF','SHN',654,'Saint Helena, Ascension and Tristan da Cunha','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-helena-ascension-and-tristan-da-cunha'),
(188,'KN','Saint Kitts and Nevis','NA','KNA',659,'Federation of Saint Kitts and Nevis','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-kitts-and-nevis'),
(189,'LC','Saint Lucia','NA','LCA',662,'Saint Lucia','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-lucia'),
(190,'MF','Saint Martin','NA','MAF',663,'Saint Martin (French part)','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-martin'),
(191,'PM','Saint Pierre and Miquelon','NA','SPM',666,'Saint Pierre and Miquelon','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-pierre-and-miquelon'),
(192,'VC','Saint Vincent and the Grenadines','NA','VCT',670,'Saint Vincent and the Grenadines','2017-02-22 21:37:38','2017-02-22 21:37:38','saint-vincent-and-the-grenadines'),
(193,'WS','Samoa','OC','WSM',882,'Independent State of Samoa','2017-02-22 21:37:38','2017-02-22 21:37:38','samoa'),
(194,'SM','San Marino','EU','SMR',674,'Republic of San Marino','2017-02-22 21:37:38','2017-02-22 21:37:38','san-marino'),
(195,'ST','Sao Tome and Principe','AF','STP',678,'Democratic Republic of Sao Tome and Principe','2017-02-22 21:37:38','2017-02-22 21:37:38','sao-tome-and-principe'),
(196,'SA','Saudi Arabia','AS','SAU',682,'Kingdom of Saudi Arabia','2017-02-22 21:37:38','2017-02-22 21:37:38','saudi-arabia'),
(197,'SN','Senegal','AF','SEN',686,'Republic of Senegal','2017-02-22 21:37:38','2017-02-22 21:37:38','senegal'),
(198,'RS','Serbia','EU','SRB',688,'Republic of Serbia','2017-02-22 21:37:38','2017-02-22 21:37:38','serbia'),
(199,'SC','Seychelles','AF','SYC',690,'Republic of Seychelles','2017-02-22 21:37:38','2017-02-22 21:37:38','seychelles'),
(200,'SL','Sierra Leone','AF','SLE',694,'Republic of Sierra Leone','2017-02-22 21:37:38','2017-02-22 21:37:38','sierra-leone'),
(201,'SG','Singapore','AS','SGP',702,'Republic of Singapore','2017-02-22 21:37:38','2017-02-22 21:37:38','singapore'),
(202,'SX','Sint Maarten Dutch part','NA','SXM',534,'Sint Maarten (Dutch part)','2017-02-22 21:37:38','2017-02-22 21:37:38','sint-maarten-dutch-part'),
(203,'SK','Slovakia Slovak Republic','EU','SVK',703,'Slovakia (Slovak Republic)','2017-02-22 21:37:38','2017-02-22 21:37:38','slovakia-slovak-republic'),
(204,'SI','Slovenia','EU','SVN',705,'Republic of Slovenia','2017-02-22 21:37:38','2017-02-22 21:37:38','slovenia'),
(205,'SB','Solomon Islands','OC','SLB',90,'Solomon Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','solomon-islands'),
(206,'SO','Somalia','AF','SOM',706,'Federal Republic of Somalia','2017-02-22 21:37:38','2017-02-22 21:37:38','somalia'),
(207,'ZA','South Africa','AF','ZAF',710,'Republic of South Africa','2017-02-22 21:37:38','2017-02-22 21:37:38','south-africa'),
(208,'GS','South Georgia and the South Sandwich Islands','AN','SGS',239,'South Georgia and the South Sandwich Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','south-georgia-and-the-south-sandwich-islands'),
(209,'SS','South Sudan','AF','SSD',728,'Republic of South Sudan','2017-02-22 21:37:38','2017-02-22 21:37:38','south-sudan'),
(210,'ES','Spain','EU','ESP',724,'Kingdom of Spain','2017-02-22 21:37:38','2017-02-22 21:37:38','spain'),
(211,'LK','Sri Lanka','AS','LKA',144,'Democratic Socialist Republic of Sri Lanka','2017-02-22 21:37:38','2017-02-22 21:37:38','sri-lanka'),
(212,'SD','Sudan','AF','SDN',729,'Republic of Sudan','2017-02-22 21:37:38','2017-02-22 21:37:38','sudan'),
(213,'SR','Suriname','SA','SUR',740,'Republic of Suriname','2017-02-22 21:37:38','2017-02-22 21:37:38','suriname'),
(214,'SJ','Svalbard and Jan Mayen Islands','EU','SJM',744,'Svalbard & Jan Mayen Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','svalbard-and-jan-mayen-islands'),
(215,'SZ','Swaziland','AF','SWZ',748,'Kingdom of Swaziland','2017-02-22 21:37:38','2017-02-22 21:37:38','swaziland'),
(216,'SE','Sweden','EU','SWE',752,'Kingdom of Sweden','2017-02-22 21:37:38','2017-02-22 21:37:38','sweden'),
(217,'CH','Switzerland','EU','CHE',756,'Swiss Confederation','2017-02-22 21:37:38','2017-02-22 21:37:38','switzerland'),
(218,'SY','Syrian Arab Republic','AS','SYR',760,'Syrian Arab Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','syrian-arab-republic'),
(219,'TW','Taiwan','AS','TWN',158,'Taiwan, Province of China','2017-02-22 21:37:38','2017-02-22 21:37:38','taiwan'),
(220,'TJ','Tajikistan','AS','TJK',762,'Republic of Tajikistan','2017-02-22 21:37:38','2017-02-22 21:37:38','tajikistan'),
(221,'TZ','Tanzania','AF','TZA',834,'United Republic of Tanzania','2017-02-22 21:37:38','2017-02-22 21:37:38','tanzania'),
(222,'TH','Thailand','AS','THA',764,'Kingdom of Thailand','2017-02-22 21:37:38','2017-02-22 21:37:38','thailand'),
(223,'TL','Timor-Leste','AS','TLS',626,'Democratic Republic of Timor-Leste','2017-02-22 21:37:38','2017-02-22 21:37:38','timor-leste'),
(224,'TG','Togo','AF','TGO',768,'Togolese Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','togo'),
(225,'TK','Tokelau','OC','TKL',772,'Tokelau','2017-02-22 21:37:38','2017-02-22 21:37:38','tokelau'),
(226,'TO','Tonga','OC','TON',776,'Kingdom of Tonga','2017-02-22 21:37:38','2017-02-22 21:37:38','tonga'),
(227,'TT','Trinidad and Tobago','NA','TTO',780,'Republic of Trinidad and Tobago','2017-02-22 21:37:38','2017-02-22 21:37:38','trinidad-and-tobago'),
(228,'TN','Tunisia','AF','TUN',788,'Tunisian Republic','2017-02-22 21:37:38','2017-02-22 21:37:38','tunisia'),
(229,'TR','Turkey','AS','TUR',792,'Republic of Turkey','2017-02-22 21:37:38','2017-02-22 21:37:38','turkey'),
(230,'TM','Turkmenistan','AS','TKM',795,'Turkmenistan','2017-02-22 21:37:38','2017-02-22 21:37:38','turkmenistan'),
(231,'TC','Turks and Caicos Islands','NA','TCA',796,'Turks and Caicos Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','turks-and-caicos-islands'),
(232,'TV','Tuvalu','OC','TUV',798,'Tuvalu','2017-02-22 21:37:38','2017-02-22 21:37:38','tuvalu'),
(233,'UG','Uganda','AF','UGA',800,'Republic of Uganda','2017-02-22 21:37:38','2017-02-22 21:37:38','uganda'),
(234,'UA','Ukraine','EU','UKR',804,'Ukraine','2017-02-22 21:37:38','2017-02-22 21:37:38','ukraine'),
(235,'AE','United Arab Emirates','AS','ARE',784,'United Arab Emirates','2017-02-22 21:37:38','2017-02-22 21:37:38','united-arab-emirates'),
(236,'GB','United Kingdom of Great Britain and Northern Ireland','EU','GBR',826,'United Kingdom of Great Britain & Northern Ireland','2017-02-22 21:37:38','2017-02-22 21:37:38','united-kingdom-of-great-britain-and-northern-ireland'),
(237,'US','United States of America','NA','USA',840,'United States of America','2017-02-22 21:37:38','2017-02-22 21:37:38','united-states-of-america'),
(238,'UM','United States Minor Outlying Islands','OC','UMI',581,'United States Minor Outlying Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','united-states-minor-outlying-islands'),
(239,'VI','United States Virgin Islands','NA','VIR',850,'United States Virgin Islands','2017-02-22 21:37:38','2017-02-22 21:37:38','united-states-virgin-islands'),
(240,'UY','Uruguay','SA','URY',858,'Eastern Republic of Uruguay','2017-02-22 21:37:38','2017-02-22 21:37:38','uruguay'),
(241,'UZ','Uzbekistan','AS','UZB',860,'Republic of Uzbekistan','2017-02-22 21:37:38','2017-02-22 21:37:38','uzbekistan'),
(242,'VU','Vanuatu','OC','VUT',548,'Republic of Vanuatu','2017-02-22 21:37:38','2017-02-22 21:37:38','vanuatu'),
(243,'VE','Venezuela','SA','VEN',862,'Bolivarian Republic of Venezuela','2017-02-22 21:37:38','2017-02-22 21:37:38','venezuela'),
(244,'VN','Vietnam','AS','VNM',704,'Socialist Republic of Vietnam','2017-02-22 21:37:38','2017-02-22 21:37:38','vietnam'),
(245,'WF','Wallis and Futuna','OC','WLF',876,'Wallis and Futuna','2017-02-22 21:37:38','2017-02-22 21:37:38','wallis-and-futuna'),
(246,'EH','Western Sahara','AF','ESH',732,'Western Sahara','2017-02-22 21:37:38','2017-02-22 21:37:38','western-sahara'),
(247,'YE','Yemen','AS','YEM',887,'Yemen','2017-02-22 21:37:38','2017-02-22 21:37:38','yemen'),
(248,'ZM','Zambia','AF','ZMB',894,'Republic of Zambia','2017-02-22 21:37:38','2017-02-22 21:37:38','zambia'),
(249,'ZW','Zimbabwe','AF','ZWE',716,'Republic of Zimbabwe','2017-02-22 21:37:38','2017-02-22 21:37:38','zimbabwe');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment