-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

/*!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 `quempais`
--

DROP TABLE IF EXISTS `quempais`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quempais` (
  `cod_nacion` char(4) NOT NULL DEFAULT '' COMMENT 'País',
  `cod_nacion_3` char(3) NOT NULL DEFAULT '' COMMENT 'Código ISO 3 dígitos',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `nombre_en` text NOT NULL COMMENT 'Nombre inglés',
  `cod_idioma_habi` char(4) NOT NULL DEFAULT 'ES' COMMENT 'Idioma habitual',
  `intercomunitario` char(1) NOT NULL DEFAULT 'N' COMMENT 'Comunitario',
  `formato_fecha` char(1) NOT NULL DEFAULT '1' COMMENT 'Formato fecha',
  `formato_numero` char(1) NOT NULL DEFAULT '1' COMMENT 'Formato número',
  `unidades_medida` char(1) NOT NULL DEFAULT '1' COMMENT 'Unidades de medida',
  `cod_moneda` char(3) NOT NULL DEFAULT '' COMMENT 'Moneda',
  `sw_pais_origen` char(1) NOT NULL DEFAULT 'N' COMMENT 'Ver páis origen',
  `siglas_pais_ori` char(16) NOT NULL DEFAULT '' COMMENT 'Sigla pais origen',
  `digitos_vta` char(12) NOT NULL DEFAULT '' COMMENT 'Dígs. cta.vta.',
  `digitos_com` char(12) NOT NULL DEFAULT '' COMMENT 'Dígs cta.comp.',
  `posicion_vta` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Posic. inicial cta.vta.',
  `posicion_com` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Posic. inicial cta.comp.',
  `clave_nif_340` char(1) NOT NULL DEFAULT '1' COMMENT 'Clave NIF 340',
  `normativa` text NOT NULL COMMENT 'Normativa',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`cod_nacion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quempais`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `quempais` WRITE;
/*!40000 ALTER TABLE `quempais` DISABLE KEYS */;
INSERT INTO `quempais` (`cod_nacion`, `cod_nacion_3`, `nombre`, `nombre_en`, `cod_idioma_habi`, `intercomunitario`, `formato_fecha`, `formato_numero`, `unidades_medida`, `cod_moneda`, `sw_pais_origen`, `siglas_pais_ori`, `digitos_vta`, `digitos_com`, `posicion_vta`, `posicion_com`, `clave_nif_340`, `normativa`, `observaciones`, `id_tenant`) VALUES ('AD','AND','Andorra','Andorra','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AE','ARE','Emiratos Árabes Unidos','United Arab Emirates','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AF','AFG','Afganistán','Afghanistan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AG','ATG','Antigua y Barbuda','Antigua and Barbuda','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AI','AIA','Anguila','Anguilla','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AL','ALB','Albania','Albania','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AM','ARM','Armenia','Armenia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AN','ANT','Antillas Neerlandesas (obsoleto)','','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AO','AGO','Angola','Angola','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AQ','ATA','Antártida','Antarctica','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AR','ARG','Argentina','Argentina','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AS','ASM','Samoa Americana','American Samoa','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AT','AUT','Austria','Austria','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('AU','AUS','Australia','Australia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AW','ABW','Aruba','Aruba','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AX','ALA','Åland, Islas','Åland Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('AZ','AZE','Azerbaiyán','Azerbaijan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BA','BIH','Bosnia y Herzegovina','Bosnia and Herzegovina','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BB','BRB','Barbados','Barbados','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BD','BGD','Bangladesh','Bangladesh','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BE','BEL','Bélgica','Belgium','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('BF','BFA','Burkina Faso','Burkina Faso','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BG','BGR','Bulgaria','Bulgaria','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('BH','BHR','Bahrein','Bahrain','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BI','BDI','Burundi','Burundi','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BJ','BEN','Benín','Benin','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BL','BLM','San Bartolomé / Saint Barthélemy','Saint Barthélemy','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BM','BMU','Bermudas','Bermuda','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BN','BRN','Brunei Darussalam','Brunei Darussalam','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BO','BOL','Bolivia','Bolivia, Plurinational State of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BQ','BES','Bonaire, San Eustaquio y Saba (pertenece Países Bajos)','Bonaire, Sint Eustatius and Saba','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BR','BRA','Brasil','Brazil','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BS','BHS','Bahamas','Bahamas','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BT','BTN','Bhután','Bhutan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BV','BVT','Isla Bouvet (Noruega)','Bouvet Island','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BW','BWA','Botsuana','Botswana','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BY','BLR','Belarús (antiguamente Bielorrusia)','Belarus','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('BZ','BLZ','Belice','Belize','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CA','CAN','Canadá','Canada','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CC','CCK','Islas Cocos/Keeling','Cocos','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CD','COD','República Democrática del Congo','Congo, the Democratic Republic of the','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CF','CAF','República Centroafricana','Central African Republic','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CG','COG','República del Congo','Congo','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CH','CHE','Suiza','Switzerland','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CI','CIV','Costa de Marfil (Côte d\'Ivoire)','Côte d\'Ivoire','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CK','COK','Islas Cook','Cook Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CL','CHL','Chile','Chile','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CM','CMR','Camerún','Cameroon','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CN','CHN','China','China','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CO','COL','Colombia','Colombia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CR','CRI','Costa Rica','Costa Rica','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CU','CUB','Cuba','Cuba','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CV','CPV','Cabo Verde','Cabo Verde','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CW','CUW','Curaçao (pertenece Países Bajos)','Curaçao','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CX','CXR','Isla de Navidad (Australia)','Christmas Island','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('CY','CYP','Chipre','Cyprus','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('CZ','CZE','República Checa / Chequia','Czechia','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('DE','DEU','Alemania','Germany','ES','S','1','1','1','EUR','N','','','',0,0,'1','','',1),('DJ','DJI','Yibuti / Djibouti','Djibouti','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('DK','DNK','Dinamarca','Denmark','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('DM','DMA','Dominica','Dominica','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('DO','DOM','República Dominicana','Dominican Republic','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('DZ','DZA','Argelia','Algeria','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('EA','','Ceuta y Melilla (solo a título estadístico)','','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('EC','ECU','Ecuador','Ecuador','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('EE','EST','Estonia','Estonia','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('EG','EGY','Egipto','Egypt','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('EH','ESH','República Árabe Saharaui Democrática / Sahara Occidental','Western Sahara','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ER','ERI','Eritrea','Eritrea','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ES','ESP','España','Spain','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('ESPA','','ESPAÑA','','00','N','1','1','1','','S','','00','',0,0,'1','00000000000000000000000000000000000000000000000000000000000000000','',1),('ET','ETH','Etiopía','Ethiopia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('EU','EUR','Unión Europea (solo a título estadístico)','','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('FI','FIN','Finlandia','Finland','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('FJ','FJI','Fiyi (Fiji)','Fiji','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('FK','FLK','Islas Malvinas (Falkland)','Falkland Islands (Malvinas)','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('FM','FSM','Estados Federados de Micronesia','Micronesia, Federated States of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('FO','FRO','Islas Feroe','Faroe Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('FR','FRA','FRANCE','France','ES','S','1','1','1','EUR','N','','','',0,0,'1','','',1),('FRAN','','FRANCIA','','FR','S','1','1','1','','S','','00','',0,0,'1','','',1),('GA','GAB','Gabón','Gabon','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GB','GBR','Reino Unido de Gran Bretaña e Irlanda del Norte','United Kingdom of Great Britain and Northern Ireland','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('GD','GRD','Granada','Grenada','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GE','GEO','Georgia','Georgia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GF','GUF','Guayana Francesa','French Guiana','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GG','GGY','Guernsey','Guernsey','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GH','GHA','Ghana','Ghana','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GI','GIB','Gibraltar','Gibraltar','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GL','GRL','Groenlandia','Greenland','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GM','GMB','Gambia','Gambia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GN','GIN','Guinea','Guinea','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GP','GLP','Guadalupe (Guadeloupe)','Guadeloupe','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GQ','GNQ','Guinea Ecuatorial','Equatorial Guinea','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GR','GRC','Grecia','Greece','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('GS','SGS','Islas Georgias del Sur y Sandwich del Sur','South Georgia and the South Sandwich Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GT','GTM','Guatemala','Guatemala','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GU','GUM','Guam','Guam','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GW','GNB','Guinea Bissau','Guinea-Bissau','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('GY','GUY','Guyana','Guyana','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('HK','HKG','Hong Kong','Hong Kong','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('HM','HMD','Islas Heard y McDonald','Heard Island and McDonald Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('HN','HND','Honduras','Honduras','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('HR','HRV','Croacia','Croatia','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('HT','HTI','Haití','Haiti','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('HU','HUN','Hungría','Hungary','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('IC','','Islas Canarias (solo a título estadístico)','','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('ID','IDN','Indonesia','Indonesia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IE','IRL','Irlanda','Ireland','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('IL','ISR','Israel','Israel','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IM','IMN','Isla de Man (Corona británica)','Isle of Man','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IN','IND','India','India','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IO','IOT','Territorio Británico del Océano Índico','British Indian Ocean Territory','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IQ','IRQ','Iraq','Iraq','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IR','IRN','Irán (Repúplica Islámica de)','Iran, Islamic Republic of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IS','ISL','Islandia','Iceland','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('IT','ITA','Italia','Italy','ES','S','1','1','1','EUR','N','','','',0,0,'1','','',1),('ITAL','','ITALIA','','ES','S','1','1','1','EUR','S','','00','',0,0,'1','','',1),('JE','JEY','Jersey','Jersey','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('JM','JAM','Jamaica','Jamaica','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('JO','JOR','Jordania','Jordan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('JP','JPN','Japón','Japan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KE','KEN','Kenia/Kenya','Kenya','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KG','KGZ','Kirguistán','Kyrgyzstan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KH','KHM','Camboya (antes República Jemer)','Cambodia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KI','KIR','Kiribati','Kiribati','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KM','COM','Comoras','Comoros','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KN','KNA','San Cristóbal y Nieves / Saint Kitts y Nevis','Saint Kitts and Nevis','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KP','PRK','Corea del Norte','Korea, Democratic People\'s Republic of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KR','KOR','Corea del Sur','Korea, Republic of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KW','KWT','Kuwait','Kuwait','ES','N','1','1','1','€','N','','','',0,0,'1','','',1),('KY','CYM','Islas Caimán','Cayman Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('KZ','KAZ','Kazajistán','Kazakhstan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LA','LAO','Laos/Lao','Lao People\'s Democratic Republic','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LB','LBN','Líbano','Lebanon','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LC','LCA','Santa Lucía','Saint Lucia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LI','LIE','Liechtenstein','Liechtenstein','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LK','LKA','Sri Lanka','Sri Lanka','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LR','LBR','Liberia','Liberia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LS','LSO','Lesoto/Lesotho','Lesotho','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('LT','LTU','Lituania','Lithuania','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('LU','LUX','Luxemburgo','Luxembourg','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('LV','LVA','Letonia','Latvia','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('LY','LBY','Libia','Libya','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MA','MAR','Marruecos','Morocco','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MC','MCO','Mónaco','Monaco','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MD','MDA','Moldavia/Moldova','Moldova','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ME','MNE','Montenegro','Montenegro','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MF','MAF','San Martín','Saint Martin (French part)','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MG','MDG','Madagascar','Madagascar','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MH','MHL','Islas Marshall','Marshall Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MK','MKD','Macedonia (ex República Yugoslava de)','Macedonia, the former Yugoslav Republic of	1993','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ML','MLI','Malí','Mali','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MM','MMR','Myanmar (anteriormete Birmania)','Myanmar','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MN','MNG','Mongolia','Mongolia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MO','MAC','Macao','Macao','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MP','MNP','Islas Marianas del Norte','Northern Mariana Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MQ','MTQ','Martinica/Martinique','Martinique','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MR','MRT','Mauritania','Mauritania','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MS','MSR','Montserrat','Montserrat','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MT','MLT','Malta','Malta','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('MU','MUS','Mauricio','Mauritius','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MV','MDV','Maldivas','Maldives','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MW','MWI','Malaui/Malawi','Malawi','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MX','MEX','México','Mexico','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MY','MYS','Malasia','Malaysia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('MZ','MOZ','Mozambique','Mozambique','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NA','NAM','Namibia','Namibia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NC','NCL','Nueva Caledonia','New Caledonia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NE','NER','Níger','Niger','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NF','NFK','Isla Norfolk (Australia)','Norfolk Island','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NG','NGA','Nigeria','Nigeria','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NI','NIC','Nicaragua','Nicaragua','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NL','NLD','Países Bajos (Holanda)','Netherlands','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('NO','NOR','Noruega','Norway','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NP','NPL','Nepal','Nepal','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NR','NRU','Nauru','Nauru','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NU','NIU','Niue','Niue','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('NZ','NZL','Nueva Zelanda','New Zealand','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('OM','OMN','Omán','Oman','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PA','PAN','Panamá','Panama','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PE','PER','Perú','Peru','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PF','PYF','Polinesia Francesa','French Polynesia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PG','PNG','Papúa Nueva Guinea','Papua New Guinea','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PH','PHL','Filipinas','Philippines','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PK','PAK','Pakistán','Pakistan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PL','POL','Polonia','Poland','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('PM','SPM','San Pedro y Miquelón','Saint Pierre and Miquelon','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PN','PCN','Islas Pitcairn','Pitcairn','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PORT','','PORTUGAL','','ES','S','1','1','1','','S','','00','',0,0,'1','','',1),('PR','PRI','Puerto Rico','Puerto Rico','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PS','PSE','Estado de Palestina (Cisjordania y Franja de Gaza)','Palestine, State of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PT','PRT','Portugal','Portugal','PT','S','1','1','1','EUR','N','','','',0,0,'1','','',1),('PTAS','','ESPAÑA','','','N','1','1','1','','N','','00','',0,0,'1','','',1),('PW','PLW','Palaos/Palau','Palau','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('PY','PRY','Paraguay','Paraguay','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('QA','QAT','Qatar','Qatar','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('RE','REU','Reunión','Réunion','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('RO','ROU','Rumania','Romania','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('RS','SRB','Serbia','Serbia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('RU','RUS','Federación de Rusia','Russian Federation','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('RW','RWA','Ruanda/Rwanda','Rwanda','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SA','SAU','Arabia Saudita','Saudi Arabia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SB','SLB','Islas Salomón','Solomon Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SC','SYC','Seychelles','Seychelles','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SD','SDN','Sudán','Sudan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SE','SWE','Suecia','Sweden','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('SG','SGP','Singapur','Singapore','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SH','SHN','Santa Helena, Ascensión y Tristán de Acuña','Saint Helena, Ascension and Tristan da Cunha','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SI','SVN','Eslovenia','Slovenia','ES','S','1','1','1','','N','','','',0,0,'1','','',1),('SJ','SJM','Svalbard y Jan Mayen','Svalbard and Jan Mayen','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SK','SVK','Eslovaquia','Slovakia','ES','S','1','1','1','EUR','N','','','',0,0,'1','','',1),('SL','SLE','Sierra Leona','Sierra Leone','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SM','SMR','San Marino','San Marino','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SN','SEN','Senegal','Senegal','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SO','SOM','Somalia','Somalia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SR','SUR','Surinam / Suriname','Suriname','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SS','SSD','Sudán de Sur','South Sudan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ST','STP','Santo Tomé y Príncipe','Sao Tome and Principe','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SU','URS','Unión Soviética (solo a título estadístico)','','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SUIZ','','SUIZA','','ES','N','1','1','1','','S','','00','',0,0,'1','','',1),('SV','SLV','El Salvador','El Salvador','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SX','SXM','Sint Maarten (pertenece Países Bajos)','Sint Maarten (Dutch part)','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SY','SYR','República Árabe Siria','Syrian Arab Republic','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('SZ','SWZ','Suazilandia / Swazilandia','Swaziland','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TC','TCA','Islas Turcas y Caicos','Turks and Caicos Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TD','TCD','Chad','Chad','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TF','ATF','Tierras Australes Francesas','French Southern Territories','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TG','TGO','Togo','Togo','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TH','THA','Tailandia','Thailand','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TJ','TJK','Tayikistán','Tajikistan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TK','TKL','Tokelau','Tokelau','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TL','TLS','Timor Oriental / Timor-Leste','Timor-Leste','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TM','TKM','Turkmenistán','Turkmenistan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TN','TUN','Túnez','Tunisia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TO','TON','Tonga','Tonga','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TR','TUR','Turquía','Turkey','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TT','TTO','Trinidad y Tobago','Trinidad and Tobago','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TV','TUV','Tuvalu','Tuvalu','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TW','TWN','Taiwán (Provincia de China)','Taiwan, Province of China','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('TZ','TZA','Tanzania','Tanzania, United Republic of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('UA','UKR','Ucrania','Ukraine','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('UG','UGA','Uganda','Uganda','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('UM','UMI','Islas ultramarinas de Estados Unidos','United States Minor Outlying Islands','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('US','USA','Estados Unidos de América','United States of America','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('UY','URY','Uruguay','Uruguay','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('UZ','UZB','Uzbekistán','Uzbekistan','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VA','VAT','Ciudad del Vaticano / Santa Sede','Holy See','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VC','VCT','San Vicente y las Granadinas','Saint Vincent and the Grenadines','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VE','VEN','Venezuela','Venezuela, Bolivarian Republic of','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VG','VGB','Islas Vírgenes Británicas','Virgin Islands, British','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VI','VIR','Islas Vírgenes de los Estados Unidos','Virgin Islands, U.S.','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VN','VNM','Vietnam','Viet Nam','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('VU','VUT','Vanuatu','Vanuatu','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('WF','WLF','Wallis y Futuna','Wallis and Futuna','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('WS','WSM','Samoa','Samoa','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('YE','YEM','Yemen','Yemen','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('YT','MYT','Mayotte','Mayotte','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ZA','ZAF','Sudáfrica','South Africa','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ZM','ZMB','Zambia','Zambia','ES','N','1','1','1','','N','','','',0,0,'1','','',1),('ZW','ZWE','Zimbabue','Zimbabwe','ES','N','1','1','1','','N','','','',0,0,'1','','',1);
/*!40000 ALTER TABLE `quempais` 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 2025-10-30  8:42:00
