/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
DROP TABLE IF EXISTS `worldwide_countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worldwide_countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `iso_code_2` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `iso_code_3` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `iso_numeric` smallint DEFAULT NULL,
  `dialling_code` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `worldwide_countries` WRITE;
/*!40000 ALTER TABLE `worldwide_countries` DISABLE KEYS */;
INSERT INTO `worldwide_countries` VALUES (1,'Afghanistan','AF','AFG',4,93),(2,'Albania','AL','ALB',8,355),(3,'Algeria','DZ','DZA',12,213),(4,'American Samoa','AS','ASM',16,1684),(5,'Andorra','AD','AND',20,376),(6,'Angola','AO','AGO',24,244),(7,'Anguilla','AI','AIA',660,1264),(8,'Antarctica','AQ','ATA',10,0),(9,'Antigua and Barbuda','AG','ATG',28,1268),(10,'Argentina','AR','ARG',32,54),(11,'Armenia','AM','ARM',51,374),(12,'Aruba','AW','ABW',533,297),(13,'Australia','AU','AUS',36,61),(14,'Austria','AT','AUT',40,43),(15,'Azerbaijan','AZ','AZE',31,994),(16,'Bahamas','BS','BHS',44,1242),(17,'Bahrain','BH','BHR',48,973),(18,'Bangladesh','BD','BGD',50,880),(19,'Barbados','BB','BRB',52,1246),(20,'Belarus','BY','BLR',112,375),(21,'Belgium','BE','BEL',56,32),(22,'Belize','BZ','BLZ',84,501),(23,'Benin','BJ','BEN',204,229),(24,'Bermuda','BM','BMU',60,1441),(25,'Bhutan','BT','BTN',64,975),(26,'Bolivia','BO','BOL',68,591),(27,'Bonaire, Sint Eustatius and Saba','BQ','BES',535,599),(28,'Bosnia and Herzegovina','BA','BIH',70,387),(29,'Botswana','BW','BWA',72,267),(30,'Bouvet Island','BV','BVT',74,0),(31,'Brazil','BR','BRA',76,55),(32,'British Indian Ocean Territory','IO','IOT',86,246),(33,'Brunei Darussalam','BN','BRN',96,673),(34,'Bulgaria','BG','BGR',100,359),(35,'Burkina Faso','BF','BFA',854,226),(36,'Burundi','BI','BDI',108,257),(37,'Cabo Verde','CV','CPV',132,238),(38,'Cambodia','KH','KHM',116,855),(39,'Cameroon','CM','CMR',120,237),(40,'Canada','CA','CAN',124,1),(41,'Cayman Islands','KY','CYM',136,1345),(42,'Central African Republic','CF','CAF',140,236),(43,'Chad','TD','TCD',148,235),(44,'Chile','CL','CHL',152,56),(45,'China','CN','CHN',156,86),(46,'Christmas Island','CX','CXR',162,61),(47,'Cocos (Keeling) Islands','CC','CCK',166,61),(48,'Colombia','CO','COL',170,57),(49,'Comoros','KM','COM',174,269),(50,'Congo','CG','COG',178,242),(51,'Congo, the Democratic Republic of the','CD','COD',180,243),(52,'Cook Islands','CK','COK',184,682),(53,'Costa Rica','CR','CRI',188,506),(54,'Côte d\'Ivoire','CI','CIV',384,225),(55,'Croatia','HR','HRV',191,385),(56,'Cuba','CU','CUB',192,53),(57,'Curaçao','CW','CUW',531,599),(58,'Cyprus','CY','CYP',196,357),(59,'Czechia','CZ','CZE',203,420),(60,'Denmark','DK','DNK',208,45),(61,'Djibouti','DJ','DJI',262,253),(62,'Dominica','DM','DMA',212,1767),(63,'Dominican Republic','DO','DOM',214,1809),(64,'Ecuador','EC','ECU',218,593),(65,'Egypt','EG','EGY',818,20),(66,'El Salvador','SV','SLV',222,503),(67,'Equatorial Guinea','GQ','GNQ',226,240),(68,'Eritrea','ER','ERI',232,291),(69,'Estonia','EE','EST',233,372),(70,'Eswatini','SZ','SWZ',748,268),(71,'Ethiopia','ET','ETH',231,251),(72,'Falkland Islands (Malvinas)','FK','FLK',238,500),(73,'Faroe Islands','FO','FRO',234,298),(74,'Fiji','FJ','FJI',242,679),(75,'Finland','FI','FIN',246,358),(76,'France','FR','FRA',250,33),(77,'French Guiana','GF','GUF',254,594),(78,'French Polynesia','PF','PYF',258,689),(79,'French Southern Territories','TF','ATF',260,0),(80,'Gabon','GA','GAB',266,241),(81,'Gambia','GM','GMB',270,220),(82,'Georgia','GE','GEO',268,995),(83,'Germany','DE','DEU',276,49),(84,'Ghana','GH','GHA',288,233),(85,'Gibraltar','GI','GIB',292,350),(86,'Greece','GR','GRC',300,30),(87,'Greenland','GL','GRL',304,299),(88,'Grenada','GD','GRD',308,1473),(89,'Guadeloupe','GP','GLP',312,590),(90,'Guam','GU','GUM',316,1671),(91,'Guatemala','GT','GTM',320,502),(92,'Guernsey','GG','GGY',831,44),(93,'Guinea','GN','GIN',324,224),(94,'Guinea-Bissau','GW','GNB',624,245),(95,'Guyana','GY','GUY',328,592),(96,'Haiti','HT','HTI',332,509),(97,'Heard Island and McDonald Islands','HM','HMD',334,0),(98,'Holy See','VA','VAT',336,379),(99,'Honduras','HN','HND',340,504),(100,'Hong Kong','HK','HKG',344,852),(101,'Hungary','HU','HUN',348,36),(102,'Iceland','IS','ISL',352,354),(103,'India','IN','IND',356,91),(104,'Indonesia','ID','IDN',360,62),(105,'Iran, Islamic Republic of','IR','IRN',364,98),(106,'Iraq','IQ','IRQ',368,964),(107,'Ireland','IE','IRL',372,353),(108,'Isle of Man','IM','IMN',833,44),(109,'Israel','IL','ISR',376,972),(110,'Italy','IT','ITA',380,39),(111,'Jamaica','JM','JAM',388,1876),(112,'Japan','JP','JPN',392,81),(113,'Jersey','JE','JEY',832,44),(114,'Jordan','JO','JOR',400,962),(115,'Kazakhstan','KZ','KAZ',398,7),(116,'Kenya','KE','KEN',404,254),(117,'Kiribati','KI','KIR',296,686),(118,'Korea, Democratic People\'s Republic of','KP','PRK',408,850),(119,'Korea, Republic of','KR','KOR',410,82),(120,'Kosovo','XK','XKX',NULL,383),(121,'Kuwait','KW','KWT',414,965),(122,'Kyrgyzstan','KG','KGZ',417,996),(123,'Lao People\'s Democratic Republic','LA','LAO',418,856),(124,'Latvia','LV','LVA',428,371),(125,'Lebanon','LB','LBN',422,961),(126,'Lesotho','LS','LSO',426,266),(127,'Liberia','LR','LBR',430,231),(128,'Libya','LY','LBY',434,218),(129,'Liechtenstein','LI','LIE',438,423),(130,'Lithuania','LT','LTU',440,370),(131,'Luxembourg','LU','LUX',442,352),(132,'Macao','MO','MAC',446,853),(133,'Madagascar','MG','MDG',450,261),(134,'Malawi','MW','MWI',454,265),(135,'Malaysia','MY','MYS',458,60),(136,'Maldives','MV','MDV',462,960),(137,'Mali','ML','MLI',466,223),(138,'Malta','MT','MLT',470,356),(139,'Marshall Islands','MH','MHL',584,692),(140,'Martinique','MQ','MTQ',474,596),(141,'Mauritania','MR','MRT',478,222),(142,'Mauritius','MU','MUS',480,230),(143,'Mayotte','YT','MYT',175,262),(144,'Mexico','MX','MEX',484,52),(145,'Micronesia, Federated States of','FM','FSM',583,691),(146,'Moldova, Republic of','MD','MDA',498,373),(147,'Monaco','MC','MCO',492,377),(148,'Mongolia','MN','MNG',496,976),(149,'Montenegro','ME','MNE',499,382),(150,'Montserrat','MS','MSR',500,1664),(151,'Morocco','MA','MAR',504,212),(152,'Mozambique','MZ','MOZ',508,258),(153,'Myanmar','MM','MMR',104,95),(154,'Namibia','NA','NAM',516,264),(155,'Nauru','NR','NRU',520,674),(156,'Nepal','NP','NPL',524,977),(157,'Netherlands','NL','NLD',528,31),(158,'New Caledonia','NC','NCL',540,687),(159,'New Zealand','NZ','NZL',554,64),(160,'Nicaragua','NI','NIC',558,505),(161,'Niger','NE','NER',562,227),(162,'Nigeria','NG','NGA',566,234),(163,'Niue','NU','NIU',570,683),(164,'Norfolk Island','NF','NFK',574,672),(165,'North Macedonia','MK','MKD',807,389),(166,'Northern Mariana Islands','MP','MNP',580,1670),(167,'Norway','NO','NOR',578,47),(168,'Oman','OM','OMN',512,968),(169,'Pakistan','PK','PAK',586,92),(170,'Palau','PW','PLW',585,680),(171,'Palestine, State of','PS','PSE',275,970),(172,'Panama','PA','PAN',591,507),(173,'Papua New Guinea','PG','PNG',598,675),(174,'Paraguay','PY','PRY',600,595),(175,'Peru','PE','PER',604,51),(176,'Philippines','PH','PHL',608,63),(177,'Pitcairn','PN','PCN',612,64),(178,'Poland','PL','POL',616,48),(179,'Portugal','PT','PRT',620,351),(180,'Puerto Rico','PR','PRI',630,1787),(181,'Qatar','QA','QAT',634,974),(182,'Réunion','RE','REU',638,262),(183,'Romania','RO','ROU',642,40),(184,'Russian Federation','RU','RUS',643,7),(185,'Rwanda','RW','RWA',646,250),(186,'Saint Barthélemy','BL','BLM',652,590),(187,'Saint Helena, Ascension and Tristan da Cunha','SH','SHN',654,290),(188,'Saint Kitts and Nevis','KN','KNA',659,1869),(189,'Saint Lucia','LC','LCA',662,1758),(190,'Saint Martin (French part)','MF','MAF',663,590),(191,'Saint Pierre and Miquelon','PM','SPM',666,508),(192,'Saint Vincent and the Grenadines','VC','VCT',670,1784),(193,'Samoa','WS','WSM',882,685),(194,'San Marino','SM','SMR',674,378),(195,'Sao Tome and Principe','ST','STP',678,239),(196,'Saudi Arabia','SA','SAU',682,966),(197,'Senegal','SN','SEN',686,221),(198,'Serbia','RS','SRB',688,381),(199,'Seychelles','SC','SYC',690,248),(200,'Sierra Leone','SL','SLE',694,232),(201,'Singapore','SG','SGP',702,65),(202,'Sint Maarten (Dutch part)','SX','SXM',534,1721),(203,'Slovakia','SK','SVK',703,421),(204,'Slovenia','SI','SVN',705,386),(205,'Solomon Islands','SB','SLB',90,677),(206,'Somalia','SO','SOM',706,252),(207,'South Africa','ZA','ZAF',710,27),(208,'South Georgia and the South Sandwich Islands','GS','SGS',239,500),(209,'South Sudan','SS','SSD',728,211),(210,'Spain','ES','ESP',724,34),(211,'Sri Lanka','LK','LKA',144,94),(212,'Sudan','SD','SDN',729,249),(213,'Suriname','SR','SUR',740,597),(214,'Svalbard and Jan Mayen','SJ','SJM',744,47),(215,'Sweden','SE','SWE',752,46),(216,'Switzerland','CH','CHE',756,41),(217,'Syrian Arab Republic','SY','SYR',760,963),(218,'Taiwan, Province of China','TW','TWN',158,886),(219,'Tajikistan','TJ','TJK',762,992),(220,'Tanzania, United Republic of','TZ','TZA',834,255),(221,'Thailand','TH','THA',764,66),(222,'Timor-Leste','TL','TLS',626,670),(223,'Togo','TG','TGO',768,228),(224,'Tokelau','TK','TKL',772,690),(225,'Tonga','TO','TON',776,676),(226,'Trinidad and Tobago','TT','TTO',780,1868),(227,'Tunisia','TN','TUN',788,216),(228,'Türkiye','TR','TUR',792,90),(229,'Turkmenistan','TM','TKM',795,993),(230,'Turks and Caicos Islands','TC','TCA',796,1649),(231,'Tuvalu','TV','TUV',798,688),(232,'Uganda','UG','UGA',800,256),(233,'Ukraine','UA','UKR',804,380),(234,'United Arab Emirates','AE','ARE',784,971),(235,'United Kingdom','GB','GBR',826,44),(236,'United States','US','USA',840,1),(237,'United States Minor Outlying Islands','UM','UMI',581,1),(238,'Uruguay','UY','URY',858,598),(239,'Uzbekistan','UZ','UZB',860,998),(240,'Vanuatu','VU','VUT',548,678),(241,'Venezuela','VE','VEN',862,58),(242,'Viet Nam','VN','VNM',704,84),(243,'Virgin Islands, British','VG','VGB',92,1284),(244,'Virgin Islands, U.S.','VI','VIR',850,1340),(245,'Wallis and Futuna','WF','WLF',876,681),(246,'Western Sahara','EH','ESH',732,212),(247,'Yemen','YE','YEM',887,967),(248,'Zambia','ZM','ZMB',894,260),(249,'Zimbabwe','ZW','ZWE',716,263);
/*!40000 ALTER TABLE `worldwide_countries` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;