-- MySQL dump 10.15  Distrib 10.0.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: global
-- ------------------------------------------------------
-- Server version	10.0.23-MariaDB-1~wheezy-log

/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

--
-- Table structure for table `address_country`
--

DROP TABLE IF EXISTS `address_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso_n3` int(3) unsigned zerofill DEFAULT NULL,
  `iso_a2` varchar(2) DEFAULT NULL,
  `iso_a3` varchar(3) DEFAULT NULL,
  `dial_code` varchar(45) DEFAULT NULL,
  `zip_format` varchar(255) DEFAULT NULL,
  `name_long` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_un_long` varchar(255) DEFAULT NULL,
  `name_un` varchar(255) DEFAULT NULL,
  `default_lang_id` int(11) DEFAULT NULL,
  `default_currency_id` int(11) DEFAULT NULL,
  `states` tinyint(4) DEFAULT NULL,
  `region_type_primary` varchar(128) DEFAULT NULL,
  `region_type_secondary` varchar(128) DEFAULT NULL,
  `continent` varchar(2) DEFAULT NULL,
  `neighbours` varchar(64) DEFAULT NULL,
  `languages` varchar(128) DEFAULT NULL,
  `tld` varchar(3) DEFAULT NULL,
  `currency_code` varchar(3) DEFAULT NULL,
  `dummy` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `iso_n3` (`iso_n3`),
  UNIQUE KEY `iso_a2` (`iso_a2`),
  UNIQUE KEY `iso_a3` (`iso_a3`),
  UNIQUE KEY `iso_a3_2` (`iso_a3`),
  KEY `default_lang_id` (`default_lang_id`),
  KEY `default_currency_id` (`default_currency_id`),
  KEY `continent` (`continent`),
  KEY `currency_code` (`currency_code`)
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address_country`
--

LOCK TABLES `address_country` WRITE;
/*!40000 ALTER TABLE `address_country` DISABLE KEYS */;
INSERT INTO `address_country` VALUES (1,004,'AF','AFG',NULL,'^(\\d{4})$','Islámská republika Afghánistán','Afghánistán','the Islamic Republic of Afghanistan','Afghanistan',NULL,NULL,0,'province','district','AS','TM,CN,IR,TJ,PK,UZ','fa-AF,ps,uz-AF,tk','.af','AFN',NULL),(2,008,'AL','ALB','+355','','Albánská republika','Albánie','the Republic of Albania','Albania',NULL,NULL,0,'county','commune','EU','MK,GR,ME,RS,XK','sq,el','.al','ALL',NULL),(3,010,'AQ','ATA',NULL,NULL,'Antarktida','Antarktida','Antarctica','Antarctica',NULL,NULL,0,'claim',NULL,'AN',NULL,NULL,'.aq',NULL,NULL),(4,012,'DZ','DZA','+213','^(\\d{5})$','Alžírská demokratická a lidová republika','Alžírsko','the People\'s Democratic Republic of Algeria','Algeria',NULL,NULL,0,'province','municipality','AF','NE,EH,LY,MR,TN,MA,ML','ar-DZ','.dz','DZD',NULL),(5,016,'AS','ASM',NULL,'^(\\d{5})$','Americká Samoa','Americká Samoa','American Samoa','American Samoa',NULL,NULL,0,'district','county','OC',NULL,'en-AS,sm,to','.as','USD',NULL),(6,020,'AD','AND','+376','^(?:AD)*(\\d{3})$','Andorrské knížectví','Andorra','the Principality of Andorra','Andorra',NULL,NULL,0,'parish',NULL,'EU','ES,FR','ca','.ad','EUR',NULL),(7,024,'AO','AGO','+244','','Angolská republika','Angola','the Republic of Angola','Angola',NULL,NULL,0,'province','council','AF','CD,NA,ZM,CG','pt-AO','.ao','AOA',NULL),(8,028,'AG','ATG','+1 (268)','^(\\d{5})$','Antigua a Barbuda','Antigua a Barbuda','Antigua and Barbuda','Antigua and Barbuda',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-AG','.ag','XCD',NULL),(9,031,'AZ','AZE','+994','(AZ) (\\d{4})','Ázerbájdžánská republika','Ázerbájdžán','the Republic of Azerbaijan','Azerbaijan',NULL,NULL,0,'district',NULL,'AS','GE,IR,AM,TR,RU','az,ru,hy','.az','AZN',NULL),(10,032,'AR','ARG','+54','^([A-Z]\\d{4}[A-Z]{3})|([A-Z]\\d{4})$','Argentinská republika','Argentina','the Argentine Republic','Argentina',NULL,NULL,0,'province','department','SA','CL,BO,UY,PY,BR','es-AR,en,it,de,fr,gn','.ar','ARS',NULL),(11,036,'AU','AUS','+61','^(\\d{4})$','Austrálie','Austrálie','Australia','Australia',NULL,NULL,1,'shire',NULL,'OC',NULL,'en-AU','.au','AUD',NULL),(12,040,'AT','AUT','+43','^(\\d{4})$','Rakouská republika','Rakousko','the Republic of Austria','Austria',NULL,NULL,1,'district',NULL,'EU','CH,DE,HU,SK,CZ,IT,SI,LI','de-AT,hr,hu,sl','.at','EUR',NULL),(13,044,'BS','BHS','+1 (242)','','Bahamské společenství','Bahamy','the Commonwealth of The Bahamas','Bahamas',NULL,NULL,0,'district',NULL,'NA',NULL,'en-BS','.bs','BSD',NULL),(14,048,'BH','BHR','+973','^(\\d{3}\\d?)$','Království Bahrajn','Bahrajn','the Kingdom of Bahrain','Bahrain',NULL,NULL,0,'governorate',NULL,'AS',NULL,'ar-BH,en,fa,ur','.bh','BHD',NULL),(15,050,'BD','BGD','+880','^(\\d{4})$','Bangladéšská lidová republika','Bangladéš','the People\'s Republic of Bangladesh','Bangladesh',NULL,NULL,0,'division','district','AS','MM,IN','bn-BD,en','.bd','BDT',NULL),(16,051,'AM','ARM','+374','^(\\d{4})$','Arménská republika','Arménie','the Republic of Armenia','Armenia',NULL,NULL,0,'province',NULL,'AS','GE,IR,AZ,TR','hy','.am','AMD',NULL),(17,052,'BB','BRB','+1 (246)','^(?:BB)*(\\d{5})$','Barbados','Barbados','Barbados','Barbados',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-BB','.bb','BBD',NULL),(18,056,'BE','BEL','+32','^(\\d{4})$','Belgické království','Belgie','the Kingdom of Belgium','Belgium',NULL,NULL,0,'province','arrondissement','EU','DE,NL,LU,FR','nl-BE,fr-BE,de-BE','.be','EUR',NULL),(19,060,'BM','BMU','+1 (441)','^([A-Z]{2} \\d{2})$','Bermudy','Bermudy','Bermuda','Bermuda',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-BM,pt','.bm','BMD',NULL),(20,064,'BT','BTN','+975','^(\\d{5})$','Bhútánské království','Bhútán','the Kingdom of Bhutan','Bhutan',NULL,NULL,0,'district','subdistrict','AS','CN,IN','dz','.bt','BTN',NULL),(21,068,'BO','BOL','+591','','Mnohonárodní stát Bolívie','Mnohonárodní stát Bolívie','the Plurinational State of Bolivia','Bolivia',NULL,NULL,0,'department','province','SA','PE,CL,PY,BR,AR','es-BO,qu,ay','.bo','BOB',NULL),(22,070,'BA','BIH','+387','^(\\d{5})$','Bosna a Hercegovina','Bosna a Hercegovina','Bosnia and Herzegovina','Bosnia and Herzegovina',NULL,NULL,0,'county','commune','EU','HR,ME,RS','bs,hr-BA,sr-BA','.ba','BAM',NULL),(23,072,'BW','BWA','+267','','Republika Botswana','Botswana','the Republic of Botswana','Botswana',NULL,NULL,0,'district','sub-district','AF','ZW,ZA,NA','en-BW,tn-BW','.bw','BWP',NULL),(24,074,'BV','BVT',NULL,NULL,'Bouvetův ostrov','Bouvetův ostrov','Bouvet Island','Bouvet Island',NULL,NULL,0,NULL,NULL,'AN',NULL,NULL,'.bv','NOK',NULL),(25,076,'BR','BRA','+55','[0-9]{5}-[0-9]{3}','Brazilská federativní republika','Brazílie','the Federative Republic of Brazil','Brazil',NULL,NULL,1,'microregion',NULL,'SA','SR,PE,BO,UY,GY,PY,GF,VE,CO,AR','pt-BR,es,en,fr','.br','BRL',NULL),(26,084,'BZ','BLZ','+501','','Belize','Belize','Belize','Belize',NULL,NULL,0,'district','subdivision','NA','GT,MX','en-BZ,es','.bz','BZD',NULL),(27,086,'IO','IOT',NULL,'','Britské indickooceánské území','Britské indickooceánské území','British Indian Ocean Territory (the)','British Indian Ocean Territory',NULL,NULL,0,NULL,NULL,'AS',NULL,'en-IO','.io','USD',NULL),(28,090,'SB','SLB','+677','','Šalomounovy ostrovy','Šalomounovy ostrovy','Solomon Islands (the)','Solomon Islands',NULL,NULL,0,'province','ward','OC',NULL,'en-SB,tpi','.sb','SBD',NULL),(29,092,'VG','VGB','+1 (284)','','Britské Panenské ostrovy','Britské Panenské ostrovy','British Virgin Islands (the)','Virgin Islands (British)',NULL,NULL,0,NULL,NULL,'NA',NULL,'en-VG','.vg','USD',NULL),(30,095,'XK','XKO',NULL,'','Republika Kosovo','Kosovo','Kosovo','Kosovo',NULL,NULL,0,NULL,NULL,'EU','RS,AL,MK,ME','sq,sr',NULL,'EUR',NULL),(31,096,'BN','BRN','+673','^([A-Z]{2}\\d{4})$','Brunej Darussalam','Brunej','Brunei Darussalam','Brunei',NULL,NULL,0,'district','mukim','AS','MY','ms-BN,en-BN','.bn','BND',NULL),(32,100,'BG','BGR','+359','^(\\d{4})$','Bulharská republika','Bulharsko','the Republic of Bulgaria','Bulgaria',NULL,NULL,0,'region','municipality','EU','MK,GR,RO,TR,RS','bg,tr-BG,rom','.bg','BGN',NULL),(33,104,'MM','MMR','+95','^(\\d{5})$','Republika Myanmarský svaz','Myanma','the Republic of the Union of Myanmar','Myanmar',NULL,NULL,0,'region','district','AS','CN,LA,TH,BD,IN','my','.mm','MMK',NULL),(34,108,'BI','BDI','+257','','Republika Burundi','Burundi','the Republic of Burundi','Burundi',NULL,NULL,0,'province','commune','AF','TZ,CD,RW','fr-BI,rn','.bi','BIF',NULL),(35,112,'BY','BLR','+375','^(\\d{6})$','Běloruská republika','Bělorusko','the Republic of Belarus','Belarus',NULL,NULL,0,'region','district','EU','PL,LT,UA,RU,LV','be,ru','.by','BYR',NULL),(36,116,'KH','KHM','+855','^(\\d{5})$','Kambodžské království','Kambodža','the Kingdom of Cambodia','Cambodia',NULL,NULL,0,'province','district','AS','LA,TH,VN','km,fr,en','.kh','KHR',NULL),(37,120,'CM','CMR','+237','','Kamerunská republika','Kamerun','the Republic of Cameroon','Cameroon',NULL,NULL,0,'region','department','AF','TD,CF,GA,GQ,CG,NG','en-CM,fr-CM','.cm','XAF',NULL),(38,124,'CA','CAN','+1','^(?!.*[DFIOQU])[A-VXY][0-9][A-Z] +?[0-9][A-Z][0-9]$','Kanada','Kanada','Canada','Canada',NULL,NULL,0,'province','county','NA','US','en-CA,fr-CA,iu','.ca','CAD',NULL),(39,132,'CV','CPV','+238','^(\\d{4})$','Kapverdská republika','Kapverdy','the Republic of Cape Verde','Cape Verde',NULL,NULL,0,'county','parish','AF',NULL,'pt-CV','.cv','CVE',NULL),(40,136,'KY','CYM','+1 (345)','^[K][Y][0-9]{1}[-]([0-9]){4}$','Kajmanské ostrovy','Kajmanské ostrovy','Cayman Islands (the)','Cayman Islands',NULL,NULL,0,'district',NULL,'NA',NULL,'en-KY','.ky','KYD',NULL),(41,140,'CF','CAF','+236','','Středoafrická republika','Středoafrická republika','the Central African Republic','Central African Republic',NULL,NULL,0,'prefecture','sub-prefecture','AF','TD,SD,CD,SS,CM,CG','fr-CF,sg,ln,kg','.cf','XAF',NULL),(42,144,'LK','LKA','+94','^(\\d{5})$','Srílanská demokratická socialistická republika','Srí Lanka','the Democratic Socialist Republic of Sri Lanka','Sri Lanka',NULL,NULL,0,'district','division','AS',NULL,'si,ta,en','.lk','LKR',NULL),(43,148,'TD','TCD','+235','^(\\d{5})$','Čadská republika','Čad','the Republic of Chad','Chad',NULL,NULL,0,'region','department','AF','NE,LY,CF,SD,CM,NG','fr-TD,ar-TD,sre','.td','XAF',NULL),(44,152,'CL','CHL','+56','^(\\d{7})$','Chilská republika','Chile','the Republic of Chile','Chile',NULL,NULL,0,'region','province','SA','PE,BO,AR','es-CL','.cl','CLP',NULL),(45,156,'CN','CHN','+86','^(\\d{6})$','Čínská lidová republika','Čína','the People\'s Republic of China','China',NULL,NULL,0,'province','prefecture','AS','LA,BT,TJ,KZ,MN,AF,NP,MM,KG,PK,KP,RU,VN,IN','zh-CN,yue,wuu,dta,ug,za','.cn','CNY',NULL),(46,158,'TW','TWN','+886','^(\\d{3} \\d{2})|(\\d{3})$','Tchaj-wan (čínská provincie)','Tchaj-wan (čínská provincie)','Taiwan (Province of China)','Taiwan (Province of China)',NULL,NULL,0,'province','county','AS',NULL,'zh-TW,zh,nan,hak','.tw','TWD',NULL),(47,162,'CX','CXR',NULL,'^(6978)$','Vánoční ostrov','Vánoční ostrov','Christmas Island','Christmas Island',NULL,NULL,0,NULL,NULL,'AS',NULL,'en,zh,ms-CC','.cx','AUD',NULL),(48,166,'CC','CCK',NULL,'^(6799 W3)$','Kokosové (Keelingovy) ostrovy','Kokosové (Keelingovy) ostrovy','Cocos (Keeling) Islands (the)','Cocos (Keeling) Islands',NULL,NULL,0,NULL,NULL,'AS',NULL,'ms-CC,en','.cc','AUD',NULL),(49,170,'CO','COL','+57','^(\\d{6})$','Kolumbijská republika','Kolumbie','the Republic of Colombia','Colombia',NULL,NULL,0,'department','municipality','SA','EC,PE,PA,BR,VE','es-CO','.co','COP',NULL),(50,174,'KM','COM','+269','','Komorský svaz','Komory','the Union of the Comoros','Comoros',NULL,NULL,0,'autonomous island',NULL,'AF',NULL,'ar,fr-KM','.km','KMF',NULL),(51,175,'YT','MYT','+262','^(\\d{5})$','Mayotte','Mayotte','Mayotte','Mayotte',NULL,NULL,0,NULL,'commune','AF',NULL,'fr-YT','.yt','EUR',NULL),(52,178,'CG','COG','+242','','Konžská republika','Kongo, republika','the Republic of the Congo','Congo',NULL,NULL,0,'region','district','AF','CF,GA,CD,CM,AO','fr-CG,kg,ln-CG','.cg','XAF',NULL),(53,180,'CD','COD','+243','','Demokratická republika Kongo','Kongo, demokratická republika','the Democratic Republic of the Congo','Congo (the Democratic Republic of the)',NULL,NULL,0,'province','zone','AF','TZ,CF,SS,RW,ZM,BI,UG,CG,AO','fr-CD,ln,kg','.cd','CDF',NULL),(54,184,'CK','COK',NULL,'','Cookovy ostrovy','Cookovy ostrovy','Cook Islands (the)','Cook Islands',NULL,NULL,0,NULL,NULL,'OC',NULL,'en-CK,mi','.ck','NZD',NULL),(55,188,'CR','CRI','+506','^(\\d{4})$','Kostarická republika','Kostarika','the Republic of Costa Rica','Costa Rica',NULL,NULL,0,'province','canton','NA','PA,NI','es-CR,en','.cr','CRC',NULL),(56,191,'HR','HRV','+385','^(?:HR)*(\\d{5})$','Chorvatská republika','Chorvatsko','the Republic of Croatia','Croatia',NULL,NULL,0,'county','commune','EU','HU,SI,BA,ME,RS','hr-HR,sr','.hr','HRK',NULL),(57,192,'CU','CUB','+53','^(?:CP)*(\\d{5})$','Kubánská republika','Kuba','the Republic of Cuba','Cuba',NULL,NULL,0,'province','municipality','NA','US','es-CU','.cu','CUP',NULL),(58,196,'CY','CYP','+357','^(\\d{4})$','Kyperská republika','Kypr','the Republic of Cyprus','Cyprus',NULL,NULL,0,'district',NULL,'EU',NULL,'el-CY,tr-CY,en','.cy','EUR',NULL),(59,203,'CZ','CZE','+420','^[0-9]{3} [0-9]{2}$','Česká republika','Česká republika','the Czech Republic','Czech Republic',1,1,0,'region','district','EU','PL,DE,SK,AT','cs,sk','.cz','CZK',NULL),(60,204,'BJ','BEN','+229','','Beninská republika','Benin','the Republic of Benin','Benin',NULL,NULL,0,'department','commune','AF','NE,TG,BF,NG','fr-BJ','.bj','XOF',NULL),(61,208,'DK','DNK','+45','^(\\d{4})$','Dánské království','Dánsko','the Kingdom of Denmark','Denmark',NULL,NULL,0,'region','municipality','EU','DE','da-DK,en,fo,de-DK','.dk','DKK',NULL),(62,212,'DM','DMA','+1 (767)','','Dominické společenství','Dominika','the Commonwealth of Dominica','Dominica',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-DM','.dm','XCD',NULL),(63,214,'DO','DOM','+1 (8)','^(\\d{5})$','Dominikánská republika','Dominikánská republika','the Dominican Republic','Dominican Republic',NULL,NULL,0,'province','municipality','NA','HT','es-DO','.do','DOP',NULL),(64,218,'EC','ECU','+593','^(\\d{6})$','Ekvádorská republika','Ekvádor','the Republic of Ecuador','Ecuador',NULL,NULL,0,'province','canton','SA','PE,CO','es-EC','.ec','USD',NULL),(65,222,'SV','SLV','+503','^(\\d{5})$','Salvadorská republika','Salvador','the Republic of El Salvador','El Salvador',NULL,NULL,0,'department','municipio','NA','GT,HN','es-SV','.sv','USD',NULL),(66,226,'GQ','GNQ','+240','','Republika Rovníková Guinea','Rovníková Guinea','the Republic of Equatorial Guinea','Equatorial Guinea',NULL,NULL,0,'province','district','AF','GA,CM','es-GQ,fr','.gq','XAF',NULL),(67,231,'ET','ETH','+251','^(\\d{4})$','Etiopská federativní demokratická republika','Etiopie','the Federal Democratic Republic of Ethiopia','Ethiopia',NULL,NULL,1,'zone',NULL,'AF','ER,KE,SD,SS,SO,DJ','am,en-ET,om-ET,ti-ET,so-ET,sid','.et','ETB',NULL),(68,232,'ER','ERI','+291','','Eritrea','Eritrea','Eritrea','Eritrea',NULL,NULL,0,'region','subregion','AF','ET,SD,DJ','aa-ER,ar,tig,kun,ti-ER','.er','ERN',NULL),(69,233,'EE','EST','+372','^(\\d{5})$','Estonská republika','Estonsko','the Republic of Estonia','Estonia',NULL,NULL,0,'county','municipality','EU','RU,LV','et,ru','.ee','EUR',NULL),(70,234,'FO','FRO','+298','^(?:FO)*(\\d{3})$','Faerské ostrovy','Faerské ostrovy','Faroe Islands (the)','Faroe Islands',NULL,NULL,0,'region','commune','EU',NULL,'fo,da-FO','.fo','DKK',NULL),(71,238,'FK','FLK','+500','^(FIQQ 1ZZ)$','Falklandské ostrovy (Malvíny)','Falklandské ostrovy (Malvíny)','Falkland Islands (the) (Malvinas)','Falkland Islands (Malvinas)',NULL,NULL,0,NULL,NULL,'SA',NULL,'en-FK','.fk','FKP',NULL),(72,239,'GS','SGS',NULL,NULL,'Jižní Georgie a Jižní Sandwichovy ostrovy','Jižní Georgie a Jižní Sandwichovy ostrovy','South Georgia and the South Sandwich Islands','South Georgia and the South Sandwich Islands',NULL,NULL,0,NULL,NULL,'AN',NULL,'en','.gs','GBP',NULL),(73,242,'FJ','FJI','+679','','Fidžijská republika','Fidži','the Republic of Fiji','Fiji',NULL,NULL,0,'division','province','OC',NULL,'en-FJ,fj','.fj','FJD',NULL),(74,246,'FI','FIN','+358','^(?:FI)*(\\d{5})$','Finská republika','Finsko','the Republic of Finland','Finland',NULL,NULL,0,'region','sub-region','EU','NO,RU,SE','fi-FI,sv-FI,smn','.fi','EUR',NULL),(75,248,'AX','ALA',NULL,'^(\\d{5})$','Alandské ostrovy','Alandské ostrovy','Åland Islands','Åland Islands',NULL,NULL,0,'municipality',NULL,'EU',NULL,'sv-AX','.ax','EUR',NULL),(76,250,'FR','FRA','+33','^(\\d{5})$','Francouzská republika','Francie','the French Republic','France',NULL,NULL,0,'department','arrondissement','EU','CH,DE,BE,LU,IT,AD,MC,ES','fr-FR,frp,br,co,ca,eu,oc','.fr','EUR',NULL),(77,254,'GF','GUF','+594','^((97)|(98)3\\d{2})$','Francouzská Guyana','Francouzská Guyana','French Guiana','French Guiana',NULL,NULL,0,'arrondissement','commune','SA','SR,BR','fr-GF','.gf','EUR',NULL),(78,258,'PF','PYF','+689','^((97)|(98)7\\d{2})$','Francouzská Polynésie','Francouzská Polynésie','French Polynesia','French Polynesia',NULL,NULL,0,'subdivision','commune','OC',NULL,'fr-PF,ty','.pf','XPF',NULL),(79,260,'TF','ATF',NULL,NULL,'Francouzská jižní území','Francouzská jižní území','French Southern Territories (the)','French Southern Territories',NULL,NULL,0,'district',NULL,'AN',NULL,'fr','.tf','EUR',NULL),(80,262,'DJ','DJI','+253','','Džibutská republika','Džibutsko','the Republic of Djibouti','Djibouti',NULL,NULL,0,'region','commune','AF','ER,ET,SO','fr-DJ,ar,so-DJ,aa','.dj','DJF',NULL),(81,266,'GA','GAB','+241','','Gabonská republika','Gabon','the Gabonese Republic','Gabon',NULL,NULL,0,'province','department','AF','CM,GQ,CG','fr-GA','.ga','XAF',NULL),(82,268,'GE','GEO','+995','^(\\d{6})$','Gruzie','Gruzie','Georgia','Georgia',NULL,NULL,0,'region','district','AS','AM,AZ,TR,RU','ka,ru,hy,az','.ge','GEL',NULL),(83,270,'GM','GMB','+220','','Gambijská republika','Gambie','the Republic of The Gambia','Gambia',NULL,NULL,0,'region','district','AF','SN','en-GM,mnk,wof,wo,ff','.gm','GMD',NULL),(84,275,'PS','PSE',NULL,NULL,'Okupované palestinské území','Palestinské území (okupované)','the Occupied Palestinian Territory','Palestinian Territory',NULL,NULL,0,'district','governorate','AS','JO,IL,EG','ar-PS','.ps','ILS',NULL),(85,276,'DE','DEU','+49','^(\\d{5})$','Spolková republika Německo','Německo','the Federal Republic of Germany','Germany',5,5,1,'district',NULL,'EU','CH,PL,NL,DK,BE,CZ,LU,FR,AT','de','.de','EUR',NULL),(86,288,'GH','GHA','+233','','Ghanská republika','Ghana','the Republic of Ghana','Ghana',NULL,NULL,0,'region','district','AF','CI,TG,BF','en-GH,ak,ee,tw','.gh','GHS',NULL),(87,292,'GI','GIB','+350','^(GX11 1AA)$','Gibraltar','Gibraltar','Gibraltar','Gibraltar',NULL,NULL,0,NULL,NULL,'EU','ES','en-GI,es,it,pt','.gi','GIP',NULL),(88,296,'KI','KIR','+686','','Republika Kiribati','Kiribati','the Republic of Kiribati','Kiribati',NULL,NULL,0,'island group',NULL,'OC',NULL,'en-KI,gil','.ki','AUD',NULL),(89,300,'GR','GRC','+30','^(\\d{3}) \\d{2}$','Řecká republika','Řecko','the Hellenic Republic','Greece',NULL,NULL,0,'administration','municipality','EU','AL,MK,TR,BG','el-GR,en,fr','.gr','EUR',NULL),(90,304,'GL','GRL','+299','^(\\d{4})$','Grónsko','Grónsko','Greenland','Greenland',NULL,NULL,0,'commune','municipality','NA',NULL,'kl,da-GL,en','.gl','DKK',NULL),(91,308,'GD','GRD','+1 (473)','','Grenada','Grenada','Grenada','Grenada',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-GD','.gd','XCD',NULL),(92,312,'GP','GLP','+590','^((97)|(98)\\d{3})$','Guadeloupe','Guadeloupe','Guadeloupe','Guadeloupe',NULL,NULL,0,'arrondissement','commune','NA',NULL,'fr-GP','.gp','EUR',NULL),(93,316,'GU','GUM',NULL,'^(\\d{5})$','Guam','Guam','Guam','Guam',NULL,NULL,0,'municipality',NULL,'OC',NULL,'en-GU,ch-GU','.gu','USD',NULL),(94,320,'GT','GTM','+502','^(\\d{5})$','Guatemalská republika','Guatemala','the Republic of Guatemala','Guatemala',NULL,NULL,0,'department','municipality','NA','MX,HN,BZ,SV','es-GT','.gt','GTQ',NULL),(95,324,'GN','GIN','+224','^(\\d{3})$','Guinejská republika','Guinea','the Republic of Guinea','Guinea',NULL,NULL,0,'prefecture','subprefecture','AF','LR,SN,SL,CI,GW,ML','fr-GN','.gn','GNF',NULL),(96,328,'GY','GUY','+592','','Guyanská republika','Guyana','the Republic of Guyana','Guyana',NULL,NULL,0,'region','council','SA','SR,BR,VE','en-GY','.gy','GYD',NULL),(97,332,'HT','HTI','+509','^(?:HT)*(\\d{4})$','Republika Haiti','Haiti','the Republic of Haiti','Haiti',NULL,NULL,0,'department','arrondissement','NA','DO','ht,fr-HT','.ht','HTG',NULL),(98,334,'HM','HMD',NULL,NULL,'Heardův ostrov a McDonaldovy ostrovy','Heardův ostrov a McDonaldovy ostrovy','Heard Island and McDonald Islands','Heard Island and McDonald Islands',NULL,NULL,0,NULL,NULL,'AN',NULL,NULL,'.hm','AUD',NULL),(99,336,'VA','VAT','+39 (066)','(120)','Svatý stolec (Vatikánský městský stát)','Svatý stolec (Vatikánský městský stát)','Holy See (the) (Vatican City State)','Holy See (Vatican City State)',NULL,NULL,0,NULL,NULL,'EU','IT','la,it,fr','.va','EUR',NULL),(100,340,'HN','HND','+504','^([A-Z]{2}\\d{4})$','Honduraská republika','Honduras','the Republic of Honduras','Honduras',NULL,NULL,0,'department','municipality','NA','GT,NI,SV','es-HN','.hn','HNL',NULL),(101,344,'HK','HKG','+852','','Zvláštní administrativní oblast Číny Hongkong','Hongkong','the Hong Kong Special Administrative Region of China','Hong Kong',NULL,NULL,0,'district','council','AS',NULL,'zh-HK,yue,zh,en','.hk','HKD',NULL),(102,348,'HU','HUN','+36','^(\\d{4})$','Maďarsko','Maďarsko','Hungary','Hungary',NULL,NULL,0,'county','town-region','EU','SK,SI,RO,UA,HR,AT,RS','hu-HU','.hu','HUF',NULL),(103,352,'IS','ISL','+354','^(\\d{3})$','Islandská republika','Island','the Republic of Iceland','Iceland',NULL,NULL,0,'region','municipality','EU',NULL,'is,en,de,da,sv,no','.is','ISK',NULL),(104,356,'IN','IND','+91','^(\\d{6})$','Indická republika','Indie','the Republic of India','India',NULL,NULL,1,'district',NULL,'AS','CN,NP,MM,BT,PK,BD','en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc','.in','INR',NULL),(105,360,'ID','IDN','+62','^(\\d{5})$','Indonéská republika','Indonésie','the Republic of Indonesia','Indonesia',NULL,NULL,0,'province','regency','AS','PG,TL,MY','id,en,nl,jv','.id','IDR',NULL),(106,364,'IR','IRN','+98','^(\\d{10})$','Íránská islámská republika','Írán (islámská republika)','the Islamic Republic of Iran','Iran',NULL,NULL,0,'province','county','AS','TM,AF,IQ,AM,PK,AZ,TR','fa-IR,ku','.ir','IRR',NULL),(107,368,'IQ','IRQ','+964','^(\\d{5})$','Irácká republika','Irák','the Republic of Iraq','Iraq',NULL,NULL,0,'province','qadha','AS','SY,SA,IR,JO,TR,KW','ar-IQ,ku,hy','.iq','IQD',NULL),(108,372,'IE','IRL','+353','','Irsko','Irsko','Ireland','Ireland',NULL,NULL,0,'county',NULL,'EU','GB','en-IE,ga-IE','.ie','EUR',NULL),(109,376,'IL','ISR','+972','^(\\d{5})$','Stát Izrael','Izrael','the State of Israel','Israel',NULL,NULL,0,'district','subdistrict','AS','SY,JO,LB,EG,PS','he,ar-IL,en-IL,','.il','ILS',NULL),(110,380,'IT','ITA','+39','^(\\d{5})$','Italská republika','Itálie','the Republic of Italy','Italy',NULL,NULL,0,'province','commune','EU','CH,VA,SI,SM,FR,AT','it-IT,de-IT,fr-IT,sc,ca,co,sl','.it','EUR',NULL),(111,384,'CI','CIV','+225','','Republika Pobřeží Slonoviny','Pobřeží Slonoviny','the Republic of Côte d\'Ivoire','Côte d\'Ivoire',NULL,NULL,0,'district','region','AF','LR,GH,GN,BF,ML','fr-CI','.ci','XOF',NULL),(112,388,'JM','JAM','+1 (876)','','Jamajka','Jamajka','Jamaica','Jamaica',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-JM','.jm','JMD',NULL),(113,392,'JP','JPN','+81','^(\\d{3}-\\d{4})$','Japonsko','Japonsko','Japan','Japan',NULL,NULL,0,'prefecture','county','AS',NULL,'ja','.jp','JPY',NULL),(114,398,'KZ','KAZ','+7 7','^(\\d{6})$','Republika Kazachstán','Kazachstán','the Republic of Kazakhstan','Kazakhstan',NULL,NULL,0,'region','rayon','AS','TM,CN,KG,UZ,RU','kk,ru','.kz','KZT',NULL),(115,400,'JO','JOR','+962','^(\\d{5})$','Jordánské hášimovské království','Jordánsko','the Hashemite Kingdom of Jordan','Jordan',NULL,NULL,0,'province','sub-district','AS','SY,SA,IQ,IL,PS','ar-JO,en','.jo','JOD',NULL),(116,404,'KE','KEN','+254','^(\\d{5})$','Keňská republika','Keňa','the Republic of Kenya','Kenya',NULL,NULL,0,'county','district','AF','ET,TZ,SS,SO,UG','en-KE,sw-KE','.ke','KES',NULL),(117,408,'KP','PRK','+850','^(\\d{6})$','Korejská lidově demokratická republika','Severní Korea','the Democratic People\'s Republic of Korea','North Korea',NULL,NULL,0,'province','county','AS','CN,KR,RU','ko-KP','.kp','KPW',NULL),(118,410,'KR','KOR','+82','^(\\d{3}[-]\\d{3})$','Korejská republika','Korejská republika','the Republic of Korea','Korea',NULL,NULL,0,'province','county','AS','KP','ko-KR,en','.kr','KRW',NULL),(119,414,'KW','KWT','+965','^(\\d{5})$','Stát Kuvajt','Kuvajt','the State of Kuwait','Kuwait',NULL,NULL,0,'governorate',NULL,'AS','SA,IQ','ar-KW,en','.kw','KWD',NULL),(120,417,'KG','KGZ','+996','^(\\d{6})$','Kyrgyzská republika','Kyrgyzstán','the Kyrgyz Republic','Kyrgyzstan',NULL,NULL,0,'region','district','AS','CN,TJ,UZ,KZ','ky,uz,ru','.kg','KGS',NULL),(121,418,'LA','LAO','+856','^(\\d{4})$','Laoská lidově demokratická republika','Laoská lidově demokratická republika','the Lao People\'s Democratic Republic','Lao People\'s Democratic Republic',NULL,NULL,0,'province','district','AS','CN,MM,KH,TH,VN','lo,fr,en','.la','LAK',NULL),(122,422,'LB','LBN','+961','^(\\d{4}(\\d{4})?)$','Libanonská republika','Libanon','the Lebanese Republic','Lebanon',NULL,NULL,0,'province','county','AS','SY,IL','ar-LB,fr-LB,en,hy','.lb','LBP',NULL),(123,426,'LS','LSO','+266','^(\\d{3})$','Království Lesotho','Lesotho','the Kingdom of Lesotho','Lesotho',NULL,NULL,0,'district','council','AF','ZA','en-LS,st,zu,xh','.ls','LSL',NULL),(124,428,'LV','LVA','+371','^[L]{1}[V]{1}[-]([0-9]){4}$','Lotyšská republika','Lotyšsko','the Republic of Latvia','Latvia',NULL,NULL,0,'municipality',NULL,'EU','LT,EE,BY,RU','lv,ru,lt','.lv','EUR',NULL),(125,430,'LR','LBR','+231','^(\\d{4})$','Liberijská republika','Libérie','the Republic of Liberia','Liberia',NULL,NULL,0,'county','district','AF','SL,CI,GN','en-LR','.lr','LRD',NULL),(126,434,'LY','LBY','+218','','Libye','Libye','Libya','Libya',NULL,NULL,0,'district',NULL,'AF','TD,NE,DZ,SD,TN,EG','ar-LY,it,en','.ly','LYD',NULL),(127,438,'LI','LIE','+423','^(\\d{4})$','Lichtenštejnské knížectví','Lichtenštejnsko','the Principality of Liechtenstein','Liechtenstein',NULL,NULL,0,'commune',NULL,'EU','CH,AT','de-LI','.li','CHF',NULL),(128,440,'LT','LTU','+370','^(?:LT)*(\\d{5})$','Litevská republika','Litva','the Republic of Lithuania','Lithuania',NULL,NULL,0,'county','municipality','EU','PL,BY,RU,LV','lt,ru,pl','.lt','EUR',NULL),(129,442,'LU','LUX','+352','^(\\d{4})$','Lucemburské velkovévodství','Lucembursko','the Grand Duchy of Luxembourg','Luxembourg',NULL,NULL,0,'district','canton','EU','DE,BE,FR','lb,de-LU,fr-LU','.lu','EUR',NULL),(130,446,'MO','MAC','+853','','Zvláštní administrativní oblast Číny Macao','Macao','Macao Special Administrative Region of China','Macao',NULL,NULL,0,'district','parish','AS',NULL,'zh,zh-MO,pt','.mo','MOP',NULL),(131,450,'MG','MDG','+261','^(\\d{3})$','Madagaskarská republika','Madagaskar','the Republic of Madagascar','Madagascar',NULL,NULL,0,'province','region','AF',NULL,'fr-MG,mg','.mg','MGA',NULL),(132,454,'MW','MWI','+265','','Republika Malawi','Malawi','the Republic of Malawi','Malawi',NULL,NULL,0,'district',NULL,'AF','TZ,MZ,ZM','ny,yao,tum,swk','.mw','MWK',NULL),(133,458,'MY','MYS','+60','^(\\d{5})$','Malajsie','Malajsie','Malaysia','Malaysia',NULL,NULL,1,'district',NULL,'AS','BN,TH,ID','ms-MY,en,zh,ta,te,ml,pa,th','.my','MYR',NULL),(134,462,'MV','MDV','+960','^(\\d{2}-\\d{2])$','Maledivská republika','Maledivy','the Republic of Maldives','Maldives',NULL,NULL,0,'atoll',NULL,'AS',NULL,'dv,en','.mv','MVR',NULL),(135,466,'ML','MLI','+223','','Republika Mali','Mali','the Republic of Mali','Mali',NULL,NULL,0,'region','circle','AF','SN,NE,DZ,CI,GN,MR,BF','fr-ML,bm','.ml','XOF',NULL),(136,470,'MT','MLT','+356','^[A-Z]{3} [0-9]{4}$','Maltská republika','Malta','the Republic of Malta','Malta',NULL,NULL,0,'region','locality','EU',NULL,'mt,en-MT','.mt','EUR',NULL),(137,474,'MQ','MTQ','+596','^(\\d{5})$','Martinik','Martinik','Martinique','Martinique',NULL,NULL,0,'arrondissement','commune','NA',NULL,'fr-MQ','.mq','EUR',NULL),(138,478,'MR','MRT','+222','','Mauritánská islámská republika','Mauritánie','the Islamic Republic of Mauritania','Mauritania',NULL,NULL,0,'region','department','AF','SN,DZ,EH,ML','ar-MR,fuc,snk,fr,mey,wo','.mr','MRO',NULL),(139,480,'MU','MUS','+230','','Mauricijská republika','Mauricius','the Republic of Mauritius','Mauritius',NULL,NULL,0,'district',NULL,'AF',NULL,'en-MU,bho,fr','.mu','MUR',NULL),(140,484,'MX','MEX','+52','^(\\d{5})$','Spojené státy mexické','Mexiko','the United Mexican States','Mexico',NULL,NULL,1,'municipality',NULL,'NA','GT,US,BZ','es-MX','.mx','MXN',NULL),(141,492,'MC','MCO','+377','^(\\d{5})$','Monacké knížectví','Monako','the Principality of Monaco','Monaco',NULL,NULL,0,'commune',NULL,'EU','FR','fr-MC,en,it','.mc','EUR',NULL),(142,496,'MN','MNG','+976','^(\\d{5})$','Mongolsko','Mongolsko','Mongolia','Mongolia',NULL,NULL,0,'province','soum','AS','CN,RU','mn,ru','.mn','MNT',NULL),(143,498,'MD','MDA','+373','^(?:MD)*(\\d{4})$','Moldavská republika','Moldavská republika','the Republic of Moldova','Moldova',NULL,NULL,0,'district',NULL,'EU','RO,UA','ro,ru,gag,tr','.md','MDL',NULL),(144,499,'ME','MNE','+382','^(\\d{5})$','Černá Hora','Černá Hora','Montenegro','Montenegro',NULL,NULL,0,'commune','settlement','EU','AL,HR,BA,RS,XK','sr,hu,bs,sq,hr,rom','.me','EUR',NULL),(145,500,'MS','MSR',NULL,NULL,'Montserrat','Montserrat','Montserrat','Montserrat',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-MS','.ms','XCD',NULL),(146,504,'MA','MAR','+212','^(\\d{5})$','Marocké království','Maroko','the Kingdom of Morocco','Morocco',NULL,NULL,0,'region','prefecture','AF','DZ,EH,ES','ar-MA,fr','.ma','MAD',NULL),(147,508,'MZ','MOZ','+258','^(\\d{4})$','Mosambická republika','Mosambik','the Republic of Mozambique','Mozambique',NULL,NULL,0,'province','district','AF','ZW,TZ,SZ,ZA,ZM,MW','pt-MZ,vmw','.mz','MZN',NULL),(148,512,'OM','OMN','+968','^(\\d{3})$','Sultanát Omán','Omán','the Sultanate of Oman','Oman',NULL,NULL,0,'governorate','district','AS','SA,YE,AE','ar-OM,en,bal,ur','.om','OMR',NULL),(149,516,'NA','NAM','+264','','Namibijská republika','Namibie','the Republic of Namibia','Namibia',NULL,NULL,0,'region','constituency','AF','ZA,BW,ZM,AO','en-NA,af,de,hz,naq','.na','NAD',NULL),(150,520,'NR','NRU','+674','','Republika Nauru','Nauru','the Republic of Nauru','Nauru',NULL,NULL,0,'district',NULL,'OC',NULL,'na,en-NR','.nr','AUD',NULL),(151,524,'NP','NPL','+977','^(\\d{5})$','Nepálská federativní demokratická republika','Nepál','the Federal Democratic Republic of Nepal','Nepal',NULL,NULL,0,'region','district','AS','CN,IN','ne,en','.np','NPR',NULL),(152,528,'NL','NLD','+31','[0-9]{4} [A-Z]{2}','Nizozemské království','Nizozemsko','the Kingdom of the Netherlands','Netherlands',NULL,NULL,0,'province','municipality','EU','DE,BE','nl-NL,fy-NL','.nl','EUR',NULL),(153,531,'CW','CUW',NULL,'^(0000 CW)$','Curaçao','Curaçao','Curaçao','Curaçao',NULL,NULL,0,NULL,NULL,'NA',NULL,'nl,pap','.cw','ANG',NULL),(154,533,'AW','ABW','+297','^(0000 AW)$','Aruba','Aruba','Aruba','Aruba',NULL,NULL,0,NULL,NULL,'NA',NULL,'nl-AW,es,en','.aw','AWG',NULL),(155,534,'SX','SXM',NULL,NULL,'Svatý Martin (n','Svatý Martin (n','Sint Maarten (Dutch part)','Sint Maarten (Dutch part)',NULL,NULL,0,NULL,NULL,'NA','MF','nl,en','.sx','ANG',NULL),(156,535,'BQ','BES',NULL,NULL,'Bonaire, Svatý Eustach a Saba','Bonaire, Svatý Eustach a Saba','Bonaire, Sint Eustatius and Saba','Bonaire, Sint Eustatius and Saba',NULL,NULL,0,'island region',NULL,'NA',NULL,'nl,pap,en','.bq','USD',NULL),(157,540,'NC','NCL','+687','^(\\d{5})$','Nová Kaledonie','Nová Kaledonie','New Caledonia','New Caledonia',NULL,NULL,0,'province','commune','OC',NULL,'fr-NC','.nc','XPF',NULL),(158,548,'VU','VUT','+678','','Republika Vanuatu','Vanuatu','the Republic of Vanuatu','Vanuatu',NULL,NULL,0,'province','council','OC',NULL,'bi,en-VU,fr-VU','.vu','VUV',NULL),(159,554,'NZ','NZL','+64','^(\\d{4})$','Nový Zéland','Nový Zéland','New Zealand','New Zealand',NULL,NULL,0,'region','district','OC',NULL,'en-NZ,mi','.nz','NZD',NULL),(160,558,'NI','NIC','+505','^(\\d{7})$','Nikaragujská republika','Nikaragua','the Republic of Nicaragua','Nicaragua',NULL,NULL,0,'department','municipality','NA','CR,HN','es-NI,en','.ni','NIO',NULL),(161,562,'NE','NER','+227','^(\\d{4})$','Nigerská republika','Niger','the Republic of the Niger','Niger',NULL,NULL,0,'region','department','AF','TD,BJ,DZ,LY,BF,NG,ML','fr-NE,ha,kr,dje','.ne','XOF',NULL),(162,566,'NG','NGA','+234','^(\\d{6})$','Nigerijská federativní republika','Nigérie','the Federal Republic of Nigeria','Nigeria',NULL,NULL,1,'l. g. a.',NULL,'AF','TD,NE,BJ,CM','en-NG,ha,yo,ig,ff','.ng','NGN',NULL),(163,570,'NU','NIU',NULL,NULL,'Niue','Niue','Niue','Niue',NULL,NULL,0,NULL,'village','OC',NULL,'niu,en-NU','.nu','NZD',NULL),(164,574,'NF','NFK',NULL,NULL,'Ostrov Norfolk','Ostrov Norfolk','Norfolk Island','Norfolk Island',NULL,NULL,0,NULL,NULL,'OC',NULL,'en-NF','.nf','AUD',NULL),(165,578,'NO','NOR','+47','^(\\d{4})$','Norské království','Norsko','the Kingdom of Norway','Norway',NULL,NULL,0,'county','municipality','EU','FI,RU,SE','no,nb,nn,se,fi','.no','NOK',NULL),(166,580,'MP','MNP',NULL,'^(\\d{5})$','Společenství Ostrovy Severní Mariany','Ostrovy Severní Mariany','the Commonwealth of the Northern Mariana Islands','Northern Mariana Islands',NULL,NULL,0,'municipality',NULL,'OC',NULL,'fil,tl,zh,ch-MP,en-MP','.mp','USD',NULL),(167,581,'UM','UMI',NULL,NULL,'Menší odlehlé ostrovy USA','Menší odlehlé ostrovy USA','United States Minor Outlying Islands (the)','United States Minor Outlying Islands',NULL,NULL,0,'territory',NULL,'OC',NULL,'en-UM','.um','USD',NULL),(168,583,'FM','FSM','+691','^(\\d{5})$','Federativní státy Mikronésie','Mikronesie','the Federated States of Micronesia','Micronesia',NULL,NULL,1,'municipality',NULL,'OC',NULL,'en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg','.fm','USD',NULL),(169,584,'MH','MHL','+692','','Republika Marshallovy ostrovy','Marshallovy ostrovy','the Republic of the Marshall Islands','Marshall Islands',NULL,NULL,0,NULL,'municipality','OC',NULL,'mh,en-MH','.mh','USD',NULL),(170,585,'PW','PLW','+680','^(96940)$','Republika Palau','Palau','the Republic of Palau','Palau',NULL,NULL,1,NULL,NULL,'OC',NULL,'pau,sov,en-PW,tox,ja,fil,zh','.pw','USD',NULL),(171,586,'PK','PAK','+92','^(\\d{5})$','Pákistánská islámská republika','Pákistán','the Islamic Republic of Pakistan','Pakistan',NULL,NULL,0,'province','division','AS','CN,AF,IR,IN','ur-PK,en-PK,pa,sd,ps,brh','.pk','PKR',NULL),(172,591,'PA','PAN','+507','','Panamská republika','Panama','the Republic of Panama','Panama',NULL,NULL,0,'province','district','NA','CR,CO','es-PA,en','.pa','PAB',NULL),(173,598,'PG','PNG','+675','^(\\d{3})$','Papua Nová Guinea','Papua Nová Guinea','Papua New Guinea','Papua New Guinea',NULL,NULL,0,'province','district','OC','ID','en-PG,ho,meu,tpi','.pg','PGK',NULL),(174,600,'PY','PRY','+595','^(\\d{4})$','Paraguayská republika','Paraguay','the Republic of Paraguay','Paraguay',NULL,NULL,0,'department','district','SA','BO,BR,AR','es-PY,gn','.py','PYG',NULL),(175,604,'PE','PER','+51','^(\\d{5})$','Peruánská republika','Peru','the Republic of Peru','Peru',NULL,NULL,0,'region','province','SA','EC,CL,BO,BR,CO','es-PE,qu,ay','.pe','PEN',NULL),(176,608,'PH','PHL','+63','^(\\d{4})$','Filipínská republika','Filipíny','the Republic of the Philippines','Philippines',NULL,NULL,0,'province','municipality','AS',NULL,'tl,en-PH,fil','.ph','PHP',NULL),(177,612,'PN','PCN',NULL,NULL,'Pitcairn','Pitcairn','Pitcairn','Pitcairn',NULL,NULL,0,NULL,NULL,'OC',NULL,'en-PN','.pn','NZD',NULL),(178,616,'PL','POL','+48','^[0-9]{2}[-]([0-9]){3}$','Polská republika','Polsko','the Republic of Poland','Poland',NULL,NULL,0,'province','county','EU','DE,LT,SK,CZ,BY,UA,RU','pl','.pl','PLN',NULL),(179,620,'PT','PRT','+351','^\\d{4}((-|\\s)?\\d{3})?$','Portugalská republika','Portugalsko','the Portuguese Republic','Portugal',NULL,NULL,0,'district','municipality','EU','ES','pt-PT,mwl','.pt','EUR',NULL),(180,624,'GW','GNB','+245','^(\\d{4})$','Republika Guinea-Bissau','Guinea-Bissau','the Republic of Guinea-Bissau','Guinea-Bissau',NULL,NULL,0,'region','sector','AF','SN,GN','pt-GW,pov','.gw','XOF',NULL),(181,626,'TL','TLS','+670','^(\\d{5})$','Demokratická republika Východní Timor','Východní Timor','the Democratic Republic of Timor-Leste','Timor-Leste',NULL,NULL,0,'district','subdistrict','OC','ID','tet,pt-TL,id,en','.tl','USD',NULL),(182,630,'PR','PRI','+1','^\\d{5}((-|\\s)?\\d{4})?$','Portoriko','Portoriko','Puerto Rico','Puerto Rico',NULL,NULL,0,'municipality','barrio','NA',NULL,'en-PR,es-PR','.pr','USD',NULL),(183,634,'QA','QAT','+974','','Stát Katar','Katar','the State of Qatar','Qatar',NULL,NULL,0,'municipality',NULL,'AS','SA','ar-QA,es','.qa','QAR',NULL),(184,638,'RE','REU','+262','[9]{1}[7|8][4|7|8]\\d{2}','Réunion','Réunion','Réunion','Réunion',NULL,NULL,0,'arrondissement','commune','AF',NULL,'fr-RE','.re','EUR',NULL),(185,642,'RO','ROU','+40','^(\\d{6})$','Rumunsko','Rumunsko','Romania','Romania',NULL,NULL,0,'county','commune','EU','MD,HU,UA,BG,RS','ro,hu,rom','.ro','RON',NULL),(186,643,'RU','RUS','+7','^(\\d{6})$','Ruská federace','Rusko','the Russian Federation','Russia',NULL,NULL,0,'subject','raion','EU','GE,CN,BY,UA,KZ,LV,PL,EE,LT,FI,MN,NO,AZ,KP','ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv,mdf,chm,ba,inh,tut,kbd,krc,ava,sah,nog','.ru','RUB',NULL),(187,646,'RW','RWA','+250','','Republika Rwanda','Rwanda','the Republic of Rwanda','Rwanda',NULL,NULL,0,'province','district','AF','TZ,CD,BI,UG','rw,en-RW,fr-RW,sw','.rw','RWF',NULL),(188,652,'BL','BLM','+590','^(\\d{5})$','Svatý Bartoloměj','Svatý Bartoloměj','Saint Barthélemy','Saint Barthélemy',NULL,NULL,0,NULL,NULL,'NA',NULL,'fr','.gp','EUR',NULL),(189,654,'SH','SHN',NULL,'^[A-Z]{4} (1ZZ)$','Svatá Helena, Ascension a Tristan da Cunha','Svatá Helena, Ascension a Tristan da Cunha','Saint Helena, Ascension and Tristan da Cunha','Saint Helena, Ascension and Tristan da Cunha',NULL,NULL,0,'dependency',NULL,'AF',NULL,'en-SH','.sh','SHP',NULL),(190,659,'KN','KNA','+1 (869)','','Svatý Kryštof a Nevis','Svatý Kryštof a Nevis','Saint Kitts and Nevis','Saint Kitts and Nevis',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-KN','.kn','XCD',NULL),(191,660,'AI','AIA',NULL,NULL,'Anguilla','Anguilla','Anguilla','Anguilla',NULL,NULL,0,'district',NULL,'NA',NULL,'en-AI','.ai','XCD',NULL),(192,662,'LC','LCA','+1 (758)','','Svatá Lucie','Svatá Lucie','Saint Lucia','Saint Lucia',NULL,NULL,0,'district',NULL,'NA',NULL,'en-LC','.lc','XCD',NULL),(193,663,'MF','MAF','+590','','Svatý Martin (francouzská část)','Svatý Martin (francouzská část)','Saint Martin (French part)','Saint Martin (French part)',NULL,NULL,0,NULL,NULL,'NA','SX','fr','.gp','EUR',NULL),(194,666,'PM','SPM','+508','','Saint Pierre a Miquelon','Saint Pierre a Miquelon','Saint Pierre and Miquelon','Saint Pierre and Miquelon',NULL,NULL,0,'commune',NULL,'NA',NULL,'fr-PM','.pm','EUR',NULL),(195,670,'VC','VCT','+1 (784)','(VC)(\\d{4})','Svatý Vincenc a Grenadiny','Svatý Vincenc a Grenadiny','Saint Vincent and the Grenadines','Saint Vincent and the Grenadines',NULL,NULL,0,'parish',NULL,'NA',NULL,'en-VC,fr','.vc','XCD',NULL),(196,674,'SM','SMR','+378','^(4789\\d)$','Republika San Marino','San Marino','the Republic of San Marino','San Marino',NULL,NULL,0,'municipality',NULL,'EU','IT','it-SM','.sm','EUR',NULL),(197,678,'ST','STP','+239','','Demokratická republika Svatý Tomáš a Princův ostrov','Svatý Tomáš a Princův ostrov','the Democratic Republic of Sao Tome and Principe','Sao Tome and Principe',NULL,NULL,0,'region','district','AF',NULL,'pt-ST','.st','STD',NULL),(198,682,'SA','SAU','+966','^(\\d{5})$','Království Saúdská Arábie','Saúdská Arábie','the Kingdom of Saudi Arabia','Saudi Arabia',NULL,NULL,0,'region','governorate','AS','QA,OM,IQ,YE,JO,AE,KW','ar-SA','.sa','SAR',NULL),(199,686,'SN','SEN','+221','^(\\d{5})$','Senegalská republika','Senegal','the Republic of Senegal','Senegal',NULL,NULL,0,'region','department','AF','GN,MR,GW,GM,ML','fr-SN,wo,fuc,mnk','.sn','XOF',NULL),(200,688,'RS','SRB','+381','^(\\d{5})$','Republika Srbsko','Srbsko','the Republic of Serbia','Serbia',NULL,NULL,0,'district','municipality','EU','AL,HU,MK,RO,HR,BA,BG,ME,XK','sr,hu,bs,rom','.rs','RSD',NULL),(201,690,'SC','SYC','+248','','Seychelská republika','Seychely','the Republic of Seychelles','Seychelles',NULL,NULL,0,'district','subdistrict','AF',NULL,'en-SC,fr-SC','.sc','SCR',NULL),(202,694,'SL','SLE','+232','','Republika Sierra Leone','Sierra Leone','the Republic of Sierra Leone','Sierra Leone',NULL,NULL,0,'province','district','AF','LR,GN','en-SL,men,tem','.sl','SLL',NULL),(203,702,'SG','SGP','+65','^(\\d{6})$','Singapurská republika','Singapur','the Republic of Singapore','Singapore',NULL,NULL,0,NULL,NULL,'AS',NULL,'cmn,en-SG,ms-SG,ta-SG,zh-SG','.sg','SGD',NULL),(204,703,'SK','SVK','+421','^(\\d{3} \\d{2})$','Slovenská republika','Slovensko','the Slovak Republic','Slovakia',3,3,0,'region','district','EU','PL,HU,CZ,UA,AT','sk,hu','.sk','EUR',NULL),(205,704,'VN','VNM','+84','^(\\d{6})$','Vietnamská socialistická republika','Vietnam','the Socialist Republic of Viet Nam','Viet Nam',NULL,NULL,0,'province','district','AS','CN,LA,KH','vi,en,fr,zh,km','.vn','VND',NULL),(206,705,'SI','SVN','+386','^(\\d{4})$','Slovinská republika','Slovinsko','the Republic of Slovenia','Slovenia',NULL,NULL,0,'region','commune','EU','HU,IT,HR,AT','sl,sh','.si','EUR',NULL),(207,706,'SO','SOM','+252','^([A-Z]{2}\\d{5})$','Somálská republika','Somálsko','the Somali Republic','Somalia',NULL,NULL,0,'region','district','AF','ET,KE,DJ','so-SO,ar-SO,it,en-SO','.so','SOS',NULL),(208,710,'ZA','ZAF','+27','^(\\d{4})$','Jihoafrická republika','Jihoafrická republika','the Republic of South Africa','South Africa',NULL,NULL,0,'province','municipality','AF','ZW,SZ,MZ,BW,NA,LS','zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr','.za','ZAR',NULL),(209,716,'ZW','ZWE','+263','','Republika Zimbabwe','Zimbabwe','the Republic of Zimbabwe','Zimbabwe',NULL,NULL,0,'province','district','AF','ZA,MZ,BW,ZM','en-ZW,sn,nr,nd','.zw','ZWL',NULL),(210,724,'ES','ESP','+34','^(\\d{5})$','Španělské království','Španělsko','the Kingdom of Spain','Spain',NULL,NULL,0,'province','municipality','EU','AD,PT,GI,FR,MA','es-ES,ca,gl,eu,oc','.es','EUR',NULL),(211,728,'SS','SSD','+211','^(\\d{5})$','Jihosúdánská republika','Jižní Súdán','the Republic of South Sudan','South Sudan',NULL,NULL,1,'county',NULL,'AF','CD,CF,ET,KE,SD,UG,','en',NULL,'SSP',NULL),(212,729,'SD','SDN','+249','^(\\d{5})$','Súdánská republika','Súdán','the Republic of the Sudan','Sudan',NULL,NULL,1,'district',NULL,'AF','SS,TD,EG,ET,ER,LY,CF','ar-SD,en,fia','.sd','SDG',NULL),(213,732,'EH','ESH','+212','','Západní Sahara','Západní Sahara','Western Sahara','Western Sahara',NULL,NULL,0,'province',NULL,'AF','DZ,MR,MA','ar,mey','.eh','MAD',NULL),(214,740,'SR','SUR','+597','','Surinamská republika','Surinam','the Republic of Suriname','Suriname',NULL,NULL,0,'district','ressort','SA','GY,BR,GF','nl-SR,en,srn,hns,jv','.sr','SRD',NULL),(215,744,'SJ','SJM','+47','','Svalbard a Jan Mayen','Svalbard a Jan Mayen','Svalbard and Jan Mayen','Svalbard and Jan Mayen',NULL,NULL,0,'territory','authority','EU',NULL,'no,ru','.sj','NOK',NULL),(216,748,'SZ','SWZ','+268','^([A-Z]\\d{3})$','Svazijské království','Svazijsko','the Kingdom of Swaziland','Swaziland',NULL,NULL,0,'region','constituency','AF','ZA,MZ','en-SZ,ss-SZ','.sz','SZL',NULL),(217,752,'SE','SWE','+46','^(\\d{3} \\d{2})$','Švédské království','Švédsko','the Kingdom of Sweden','Sweden',NULL,NULL,0,'county','municipality','EU','NO,FI','sv-SE,se,sma,fi-SE','.se','SEK',NULL),(218,756,'CH','CHE','+41','^(\\d{4})$','Švýcarská konfederace','Švýcarsko','the Swiss Confederation','Switzerland',NULL,NULL,0,'canton','district','EU','DE,IT,LI,FR,AT','de-CH,fr-CH,it-CH,rm','.ch','CHF',NULL),(219,760,'SY','SYR','+963','','Syrská arabská republika','Sýrie','Syrian Arab Republic','Syria',NULL,NULL,0,'province','district','AS','IQ,JO,IL,TR,LB','ar-SY,ku,hy,arc,fr,en','.sy','SYP',NULL),(220,762,'TJ','TJK','+992','^(\\d{3})$','Republika Tádžikistán','Tádžikistán','the Republic of Tajikistan','Tajikistan',NULL,NULL,0,'region','raion','AS','CN,AF,KG,UZ','tg,ru','.tj','TJS',NULL),(221,764,'TH','THA','+66','^(\\d{5})$','Thajské království','Thajsko','the Kingdom of Thailand','Thailand',NULL,NULL,0,'province','district','AS','LA,MM,KH,MY','th,en','.th','THB',NULL),(222,768,'TG','TGO','+228','','Republika Togo','Togo','the Togolese Republic','Togo',NULL,NULL,0,'region','prefecture','AF','BJ,GH,BF','fr-TG,ee,hna,kbp,dag,ha','.tg','XOF',NULL),(223,772,'TK','TKL',NULL,NULL,'Tokelau','Tokelau','Tokelau','Tokelau',NULL,NULL,0,'atoll',NULL,'OC',NULL,'tkl,en-TK','.tk','NZD',NULL),(224,776,'TO','TON','+676','','Království Tonga','Tonga','the Kingdom of Tonga','Tonga',NULL,NULL,0,'island group','district','OC',NULL,'to,en-TO','.to','TOP',NULL),(225,780,'TT','TTO','+1 (868)','','Republika Trinidad a Tobago','Trinidad a Tobago','the Republic of Trinidad and Tobago','Trinidad and Tobago',NULL,NULL,0,'county',NULL,'NA',NULL,'en-TT,hns,fr,es,zh','.tt','TTD',NULL),(226,784,'AE','ARE','+971','','Spojené arabské emiráty','Spojené arabské emiráty','the United Arab Emirates','United Arab Emirates',NULL,NULL,0,'emirate',NULL,'AS','SA,OM','ar-AE,fa,en,hi,ur','.ae','AED',NULL),(227,788,'TN','TUN','+216','^(\\d{4})$','Tuniská republika','Tunisko','the Republic of Tunisia','Tunisia',NULL,NULL,0,'governorate','delegation','AF','DZ,LY','ar-TN,fr','.tn','TND',NULL),(228,792,'TR','TUR','+90','^(\\d{5})$','Turecká republika','Turecko','the Republic of Turkey','Turkey',NULL,NULL,0,'province','district','AS','SY,GE,IQ,IR,GR,AM,AZ,BG','tr-TR,ku,diq,az,av','.tr','TRY',NULL),(229,795,'TM','TKM','+993','^(\\d{6})$','Turkmenistán','Turkmenistán','Turkmenistan','Turkmenistan',NULL,NULL,0,'province','district','AS','AF,IR,UZ,KZ','tk,ru,uz','.tm','TMT',NULL),(230,796,'TC','TCA','+1 (649)','^(TKCA 1ZZ)$','Ostrovy Turks a Caicos','Ostrovy Turks a Caicos','Turks and Caicos Islands (the)','Turks and Caicos Islands',NULL,NULL,0,NULL,NULL,'NA',NULL,'en-TC','.tc','USD',NULL),(231,798,'TV','TUV','+688','','Tuvalu','Tuvalu','Tuvalu','Tuvalu',NULL,NULL,0,'island council',NULL,'OC',NULL,'tvl,en,sm,gil','.tv','AUD',NULL),(232,800,'UG','UGA','+256','','Ugandská republika','Uganda','the Republic of Uganda','Uganda',NULL,NULL,0,'district','county','AF','TZ,KE,SS,CD,RW','en-UG,lg,sw,ar','.ug','UGX',NULL),(233,804,'UA','UKR','+380','^(\\d{5})$','Ukrajina','Ukrajina','Ukraine','Ukraine',NULL,NULL,0,'region','raion','EU','PL,MD,HU,SK,BY,RO,RU','uk,ru-UA,rom,pl,hu','.ua','UAH',NULL),(234,807,'MK','MKD','+389','^(\\d{4})$','Bývalá jugoslávská republika Makedonie','Makedonie, bývalá jugoslávská republika','the former Yugoslav Republic of Macedonia','Macedonia',NULL,NULL,0,'municipality',NULL,'EU','AL,GR,BG,RS,XK','mk,sq,tr,rmm,sr','.mk','MKD',NULL),(235,818,'EG','EGY','+20','^(\\d{5})$','Egyptská arabská republika','Egypt','the Arab Republic of Egypt','Egypt',NULL,NULL,0,'governorate',NULL,'AF','LY,SD,IL,PS','ar-EG,en,fr','.eg','EGP',NULL),(236,826,'GB','GBR','+44','^(((([A-PR-UWYZ][0-9][0-9A-HJKS-UW]?)|([A-PR-UWYZ][A-HK-Y][0-9][0-9ABEHMNPRV-Y]?))\\s{0,2}[0-9]([ABD-HJLNP-UW-Z]{2}))|(GIR\\s{0,2}0AA))$','Spojené království Velké Británie a Severního Irska','Spojené království','the United Kingdom of Great Britain and Northern Ireland','United Kingdom',2,2,0,'county','district','EU','IE','en-GB,cy-GB,gd','.uk','GBP',NULL),(237,831,'GG','GGY','+44','((GY)([0-9][0-9A-HJKPS-UW]?|[A-HK-Y][0-9][0-9ABEHMNPRV-Y]?) [0-9][ABD-HJLNP-UW-Z]{2})','Guernsey','Guernsey','Guernsey','Guernsey',NULL,NULL,0,'parish',NULL,'EU',NULL,'en,fr','.gg','GBP',NULL),(238,832,'JE','JEY','+44','(JE)([0-9]\\d{1})','Jersey','Jersey','Jersey','Jersey',NULL,NULL,0,'parish',NULL,'EU',NULL,'en,pt','.je','GBP',NULL),(239,833,'IM','IMN','+44','((IM)([0-9][0-9A-HJKPS-UW]?|[A-HK-Y][0-9][0-9ABEHMNPRV-Y]?) [0-9][ABD-HJLNP-UW-Z]{2})','Ostrov Man','Ostrov Man','Isle of Man','Isle of Man',NULL,NULL,0,'sheading','parish','EU',NULL,'en,gv','.im','GBP',NULL),(240,834,'TZ','TZA','+255','','Tanzanská sjednocená republika','Tanzánie','United Republic of Tanzania','Tanzania',NULL,NULL,0,'region','district','AF','MZ,KE,CD,RW,ZM,BI,UG,MW','sw-TZ,en,ar','.tz','TZS',NULL),(241,840,'US','USA','+1','^\\d{5}([\\-]\\d{4})?$','Spojené státy americké','Spojené státy americké / USA','the United States of America','United states of america / USA',NULL,2,1,'county',NULL,'NA','CA,MX,CU','en-US,es-US,haw,fr','.us','USD',NULL),(242,850,'VI','VIR',NULL,'^(\\d{5})$','Americké Panenské ostrovy','Americké Panenské ostrovy','the Virgin Islands of the United States','Virgin Islands (U.S.)',NULL,NULL,0,'district','subdistrict','NA',NULL,'en-VI','.vi','USD',NULL),(243,854,'BF','BFA','+226','','Burkina Faso','Burkina Faso','Burkina Faso','Burkina Faso',NULL,NULL,0,'province','department','AF','NE,BJ,GH,CI,TG,ML','fr-BF','.bf','XOF',NULL),(244,858,'UY','URY','+598','^(\\d{5})$','Uruguayská východní republika','Uruguay','the Eastern Republic of Uruguay','Uruguay',NULL,NULL,0,'department',NULL,'SA','BR,AR','es-UY','.uy','UYU',NULL),(245,860,'UZ','UZB','+998','^(\\d{6})$','Republika Uzbekistán','Uzbekistán','the Republic of Uzbekistan','Uzbekistan',NULL,NULL,0,'region','district','AS','TM,AF,KG,TJ,KZ','uz,ru,tg','.uz','UZS',NULL),(246,862,'VE','VEN','+58','^(\\d{5})$','Bolívarovská republika Venezuela','Venezuela','the Bolivarian Republic of Venezuela','Venezuela',NULL,NULL,1,'municipality',NULL,'SA','GY,BR,CO','es-VE','.ve','VEF',NULL),(247,876,'WF','WLF','+681','','Ostrovy Wallis a Futuna','Wallis a Futuna','Wallis and Futuna Islands','Wallis and Futuna',NULL,NULL,0,'kingdom','district','OC',NULL,'wls,fud,fr-WF','.wf','XPF',NULL),(248,882,'WS','WSM','+685','','Nezávislý stát Samoa','Samoa','the Independent State of Samoa','Samoa',NULL,NULL,0,'district',NULL,'OC',NULL,'sm,en-WS','.ws','WST',NULL),(249,887,'YE','YEM','+967','','Jemenská republika','Jemen','the Republic of Yemen','Yemen',NULL,NULL,0,'governorate','district','AS','SA,OM','ar-YE','.ye','YER',NULL),(250,894,'ZM','ZMB','+260','^(\\d{5})$','Zambijská republika','Zambie','the Republic of Zambia','Zambia',NULL,NULL,0,'province','district','AF','ZW,TZ,MZ,CD,NA,MW,AO','en-ZM,bem,loz,lun,lue,ny,toi','.zm','ZMW',NULL),(251,000,'00','000',NULL,NULL,NULL,'DUMMY',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `address_country` 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 */;

-- Dump completed on 2016-02-29 10:49:50
