-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- Host: localhost    Database: circle_k
-- ------------------------------------------------------
-- Server version	5.7.10-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 `catsat_paises`
--

DROP TABLE IF EXISTS `catsat_paises`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catsat_paises` (
  `CATSAT_PaisesID` varchar(50) NOT NULL DEFAULT '0',
  `ClavePais` varchar(50) DEFAULT '0',
  `Descripcion` varchar(100) DEFAULT NULL,
  `FormatoCodigoPostal` varchar(50) DEFAULT NULL,
  `FormatoRegistroIdentidadTributaria` varchar(50) DEFAULT NULL,
  `ValidacionRegistroIdentidadTributaria` varchar(50) DEFAULT NULL,
  `Agrupaciones` varchar(50) DEFAULT NULL,
  `InternalVersion` int(11) DEFAULT '0',
  `Activo` tinyint(4) DEFAULT '0',
  `Predeterminado` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`CATSAT_PaisesID`),
  UNIQUE KEY `ClavePais` (`ClavePais`),
  KEY `WDIDX_CATSAT_Paises_Activo` (`Activo`),
  KEY `WDIDX_CATSAT_Paises_Predeterminado` (`Predeterminado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `catsat_paises`
--

LOCK TABLES `catsat_paises` WRITE;
/*!40000 ALTER TABLE `catsat_paises` DISABLE KEYS */;
INSERT INTO `catsat_paises` VALUES ('100006','IMN','Isla de Man','','','','',2,0,0),('10006','SAU','Arabia Saudita','','','','',2,0,0),('1006','AFG','Afganistan','','','','',2,0,0),('101006','CXR','Isla de Navidad','','','','',2,0,0),('102006','NFK','Isla Norfolk','','','','',2,0,0),('103006','ISL','Islandia','','','','',2,0,0),('104006','CYM','Islas Caiman las','','','','',2,0,0),('105006','CCK','Islas Cocos Keeling','','','','',2,0,0),('106006','COK','Islas Cook las','','','','',2,0,0),('107006','FRO','Islas Feroe las','','','','',2,0,0),('108006','SGS','Georgia del sur y las islas sandwich del sur','','','','',2,0,0),('109006','HMD','Isla Heard e Islas McDonald','','','','',2,0,0),('110006','FLK','Islas Malvinas [Falkland] las','','','','',2,0,0),('11006','DZA','Argelia','','','','',2,0,0),('111006','MNP','Islas Marianas del Norte las','','','','',2,0,0),('112006','MHL','Islas Marshall las','','','','',2,0,0),('113006','PCN','Pitcairn','','','','',2,0,0),('114006','SLB','Islas Salomon las','','','','',2,0,0),('115006','TCA','Islas Turcas y Caicos las','','','','',2,0,0),('116006','UMI','Islas de Ultramar Menores de Estados Unidos las','','','','',2,0,0),('117006','VGB','Islas Virgenes Britanicas','','','','',2,0,0),('118006','VIR','Islas Virgenes EE.UU.','','','','',2,0,0),('119006','ISR','Israel','','','','',2,0,0),('120006','ITA','Italia','','','','Unión Europea',2,0,0),('12006','ARG','Argentina','','','','',2,0,0),('121006','JAM','Jamaica','','','','',2,0,0),('122006','JPN','Japon','','','','',2,0,0),('123006','JEY','Jersey','','','','',2,0,0),('124006','JOR','Jordania','','','','',2,0,0),('125006','KAZ','Kazajistan','','','','',2,0,0),('126006','KEN','Kenia','','','','',2,0,0),('127006','KGZ','Kirguistan','','','','',2,0,0),('128006','KIR','Kiribati','','','','',2,0,0),('129006','KWT','Kuwait','','','','',2,0,0),('130006','LAO','Lao, la Republica Democratica Popular','','','','',2,0,0),('13006','ARM','Armenia','','','','',2,0,0),('131006','LSO','Lesoto','','','','',2,0,0),('132006','LVA','Letonia','','','','Unión Europea',2,0,0),('133006','LBN','Libano','','','','',2,0,0),('134006','LBR','Liberia','','','','',2,0,0),('135006','LBY','Libia','','','','',2,0,0),('136006','LIE','Liechtenstein','','','','',2,0,0),('137006','LTU','Lituania','','','','Unión Europea',2,0,0),('138006','LUX','Luxemburgo','','','','Unión Europea',2,0,0),('139006','MAC','Macao','','','','',2,0,0),('140006','MDG','Madagascar','','','','',2,0,0),('14006','ABW','Aruba','','','','',2,0,0),('141006','MYS','Malasia','','','','',2,0,0),('142006','MWI','Malaui','','','','',2,0,0),('143006','MDV','Maldivas','','','','',2,0,0),('144006','MLI','Mali','','','','',2,0,0),('145006','MLT','Malta','','','','Unión Europea',2,0,0),('146006','MAR','Marruecos','','','','',2,0,0),('147006','MTQ','Martinica','','','','',2,0,0),('148006','MUS','Mauricio','','','','',2,0,0),('149006','MRT','Mauritania','','','','',2,0,0),('150006','MYT','Mayotte','','','','',2,0,0),('15006','AUS','Australia','','','','',2,0,0),('151006','MEX','Mexico','[0-9]{5}','[A-Z&Ñ]{3,4}[0-9]{2}(0[1-9]|1[012])(0[1-9]|[12][0-','Lista del SAT','TLCAN',2,1,1),('152006','FSM','Micronesia los Estados Federados de','','','','',2,0,0),('153006','MDA','Moldavia la Republica de','','','','',2,0,0),('154006','MCO','Monaco','','','','',2,0,0),('155006','MNG','Mongolia','','','','',2,0,0),('156006','MNE','Montenegro','','','','',2,0,0),('157006','MSR','Montserrat','','','','',2,0,0),('158006','MOZ','Mozambique','','','','',2,0,0),('159006','NAM','Namibia','','','','',2,0,0),('160006','NRU','Nauru','','','','',2,0,0),('16006','AUT','Austria','','','','Unión Europea',2,0,0),('161006','NPL','Nepal','','','','',2,0,0),('162006','NIC','Nicaragua','','','','',2,0,0),('163006','NER','Niger el','','','','',2,0,0),('164006','NGA','Nigeria','','','','',2,0,0),('165006','NIU','Niue','','','','',2,0,0),('166006','NOR','Noruega','','','','',2,0,0),('167006','NCL','Nueva Caledonia','','','','',2,0,0),('168006','NZL','Nueva Zelanda','','','','',2,0,0),('169006','OMN','Oman','','','','',2,0,0),('170006','NLD','Paises Bajos los','','','','Unión Europea',2,0,0),('17006','AZE','Azerbaiyan','','','','',2,0,0),('171006','PAK','Pakistan','','','','',2,0,0),('172006','PLW','Palaos','','','','',2,0,0),('173006','PSE','Palestina, Estado de','','','','',2,0,0),('174006','PAN','Panama','','','','',2,0,0),('175006','PNG','Papua Nueva Guinea','','','','',2,0,0),('176006','PRY','Paraguay','','','','',2,0,0),('177006','PER','Peru','','','','',2,0,0),('178006','PYF','Polinesia Francesa','','','','',2,0,0),('179006','POL','Polonia','','','','Unión Europea',2,0,0),('180006','PRT','Portugal','','','','Unión Europea',2,0,0),('18006','BHS','Bahamas las','','','','',2,0,0),('181006','PRI','Puerto Rico','','','','',2,0,0),('182006','GBR','Reino Unido el','','','','Unión Europea',2,0,0),('183006','CAF','Republica Centroafricana la','','','','',2,0,0),('184006','CZE','Republica Checa la','','','','Unión Europea',2,0,0),('185006','MKD','Macedonia la antigua Republica Yugoslava de','','','','',2,0,0),('186006','COG','Congo','','','','',2,0,0),('187006','COD','Congo la Republica Democratica del','','','','',2,0,0),('188006','DOM','Republica Dominicana la','','','','',2,0,0),('189006','REU','Reunion','','','','',2,0,0),('190006','RWA','Ruanda','','','','',2,0,0),('19006','BGD','Banglades','','','','',2,0,0),('191006','ROU','Rumania','','','','Unión Europea',2,0,0),('192006','RUS','Rusia, la Federacion de','','','','',2,0,0),('193006','ESH','Sahara Occidental','','','','',2,0,0),('194006','WSM','Samoa','','','','',2,0,0),('195006','ASM','Samoa Americana','','','','',2,0,0),('196006','BLM','San Bartolome','','','','',2,0,0),('197006','KNA','San Cristobal y Nieves','','','','',2,0,0),('198006','SMR','San Marino','','','','',2,0,0),('199006','MAF','San Martin parte francesa','','','','',2,0,0),('200006','SPM','San Pedro y Miquelon','','','','',2,0,0),('20006','BRB','Barbados','','','','',2,0,0),('2006','ALA','Islas Aland','','','','',2,0,0),('201006','VCT','San Vicente y las Granadinas','','','','',2,0,0),('202006','SHN','Santa Helena, Ascension y Tristan de Acuna','','','','',2,0,0),('203006','LCA','Santa Lucia','','','','',2,0,0),('204006','STP','Santo Tome y Principe','','','','',2,0,0),('205006','SEN','Senegal','','','','',2,0,0),('206006','SRB','Serbia','','','','',2,0,0),('207006','SYC','Seychelles','','','','',2,0,0),('208006','SLE','Sierra leona','','','','',2,0,0),('209006','SGP','Singapur','','','','',2,0,0),('210006','SXM','Sint Maarten parte holandesa','','','','',2,0,0),('21006','BHR','Barein','','','','',2,0,0),('211006','SYR','Siria, la Republica Arabe','','','','',2,0,0),('212006','SOM','Somalia','','','','',2,0,0),('213006','LKA','Sri Lanka','','','','',2,0,0),('214006','SWZ','Suazilandia','','','','',2,0,0),('215006','ZAF','Sudafrica','','','','',2,0,0),('216006','SDN','Sudan el','','','','',2,0,0),('217006','SSD','Sudan del Sur','','','','',2,0,0),('218006','SWE','Suecia','','','','Unión Europea',2,0,0),('219006','CHE','Suiza','','','','',2,0,0),('220006','SUR','Surinam','','','','',2,0,0),('22006','BEL','Belgica','','','','Unión Europea',2,0,0),('221006','SJM','Svalbard y Jan Mayen','','','','',2,0,0),('222006','THA','Tailandia','','','','',2,0,0),('223006','TWN','Taiwan Provincia de China','','','','',2,0,0),('224006','TZA','Tanzania, Republica Unida de','','','','',2,0,0),('225006','TJK','Tayikistan','','','','',2,0,0),('226006','IOT','Territorio Britanico del Oceano Indico el','','','','',2,0,0),('227006','ATF','Territorios Australes Franceses los','','','','',2,0,0),('228006','TLS','Timor-Leste','','','','',2,0,0),('229006','TGO','Togo','','','','',2,0,0),('230006','TKL','Tokelau','','','','',2,0,0),('23006','BLZ','Belice','','','','',2,0,0),('231006','TON','Tonga','','','','',2,0,0),('232006','TTO','Trinidad y Tobago','','','','',2,0,0),('233006','TUN','Tunez','','','','',2,0,0),('234006','TKM','Turkmenistan','','','','',2,0,0),('235006','TUR','Turquia','','','','',2,0,0),('236006','TUV','Tuvalu','','','','',2,0,0),('237006','UKR','Ucrania','','','','',2,0,0),('238006','UGA','Uganda','','','','',2,0,0),('239006','URY','Uruguay','','','','',2,0,0),('240006','UZB','Uzbekistan','','','','',2,0,0),('24006','BEN','Benin','','','','',2,0,0),('241006','VUT','Vanuatu','','','','',2,0,0),('242006','VAT','Santa Sede[Estado de la Ciudad del Vaticano] la','','','','',2,0,0),('243006','VEN','Venezuela, Republica Bolivariana de','','','','',2,0,0),('244006','VNM','Viet Nam','','','','',2,0,0),('245006','WLF','Wallis y Futuna','','','','',2,0,0),('246006','YEM','Yemen','','','','',2,0,0),('247006','DJI','Yibuti','','','','',2,0,0),('248006','ZMB','Zambia','','','','',2,0,0),('249006','ZWE','Zimbabue','','','','',2,0,0),('250006','ZZZ','Paises no declarados','','','','',2,0,0),('25006','BMU','Bermudas','','','','',2,0,0),('26006','BLR','Bielorrusia','','','','',2,0,0),('27006','MMR','Myanmar','','','','',2,0,0),('28006','BOL','Bolivia, Estado Plurinacional de','','','','',2,0,0),('29006','BIH','Bosnia y Herzegovina','','','','',2,0,0),('30006','BWA','Botsuana','','','','',2,0,0),('3006','ALB','Albania','','','','',2,0,0),('31006','BRA','Brasil','','','','',2,0,0),('32006','BRN','Brunei Darussalam','','','','',2,0,0),('33006','BGR','Bulgaria','','','','Unión Europea',2,0,0),('34006','BFA','Burkina Faso','','','','',2,0,0),('35006','BDI','Burundi','','','','',2,0,0),('36006','BTN','Butan','','','','',2,0,0),('37006','CPV','Cabo Verde','','','','',2,0,0),('38006','KHM','Camboya','','','','',2,0,0),('39006','CMR','Camerun','','','','',2,0,0),('40006','CAN','Canada','[A-Z][0-9][A-Z] [0-9][A-Z][0-9]','[0-9]{9}','','TLCAN',2,0,0),('4006','DEU','Alemania','','','','Unión Europea',2,0,0),('41006','QAT','Catar','','','','',2,0,0),('42006','BES','Bonaire, San Eustaquio y Saba','','','','',2,0,0),('43006','TCD','Chad','','','','',2,0,0),('44006','CHL','Chile','','','','',2,0,0),('45006','CHN','China','','','','',2,0,0),('46006','CYP','Chipre','','','','Unión Europea',2,0,0),('47006','COL','Colombia','','','','',2,0,0),('48006','COM','Comoras','','','','',2,0,0),('49006','PRK','Corea la Republica Democratica Popular de','','','','',2,0,0),('50006','KOR','Corea la Republica de','','','','',2,0,0),('5006','AND','Andorra','','','','',2,0,0),('51006','CIV','Cote d Ivoire','','','','',2,0,0),('52006','CRI','Costa Rica','','','','',2,0,0),('53006','HRV','Croacia','','','','Unión Europea',2,0,0),('54006','CUB','Cuba','','','','',2,0,0),('55006','CUW','Curacao','','','','',2,0,0),('56006','DNK','Dinamarca','','','','Unión Europea',2,0,0),('57006','DMA','Dominica','','','','',2,0,0),('58006','ECU','Ecuador','','','','',2,0,0),('59006','EGY','Egipto','','','','',2,0,0),('60006','SLV','El Salvador','','','','',2,0,0),('6006','AGO','Angola','','','','',2,0,0),('61006','ARE','Emiratos Arabes Unidos Los','','','','',2,0,0),('62006','ERI','Eritrea','','','','',2,0,0),('63006','SVK','Eslovaquia','','','','Unión Europea',2,0,0),('64006','SVN','Eslovenia','','','','Unión Europea',2,0,0),('65006','ESP','Espana','','','','Unión Europea',2,0,0),('66006','USA','Estados Unidos los','[0-9]{5}(-[0-9]{4})?','[0-9]{9}','','TLCAN',2,0,0),('67006','EST','Estonia','','','','Unión Europea',2,0,0),('68006','ETH','Etiopia','','','','',2,0,0),('69006','PHL','Filipinas las','','','','',2,0,0),('70006','FIN','Finlandia','','','','Unión Europea',2,0,0),('7006','AIA','Anguila','','','','',2,0,0),('71006','FJI','Fiyi','','','','',2,0,0),('72006','FRA','Francia','','','','Unión Europea',2,0,0),('73006','GAB','Gabon','','','','',2,0,0),('74006','GMB','Gambia La','','','','',2,0,0),('75006','GEO','Georgia','','','','',2,0,0),('76006','GHA','Ghana','','','','',2,0,0),('77006','GIB','Gibraltar','','','','',2,0,0),('78006','GRD','Granada','','','','',2,0,0),('79006','GRC','Grecia','','','','Unión Europea',2,0,0),('80006','GRL','Groenlandia','','','','',2,0,0),('8006','ATA','Antartida','','','','',2,0,0),('81006','GLP','Guadalupe','','','','',2,0,0),('82006','GUM','Guam','','','','',2,0,0),('83006','GTM','Guatemala','','','','',2,0,0),('84006','GUF','Guayana Francesa','','','','',2,0,0),('85006','GGY','Guernsey','','','','',2,0,0),('86006','GIN','Guinea','','','','',2,0,0),('87006','GNB','Guinea-Bisau','','','','',2,0,0),('88006','GNQ','Guinea Ecuatorial','','','','',2,0,0),('89006','GUY','Guyana','','','','',2,0,0),('90006','HTI','Haiti','','','','',2,0,0),('9006','ATG','Antigua y Barbuda','','','','',2,0,0),('91006','HND','Honduras','','','','',2,0,0),('92006','HKG','Hong Kong','','','','',2,0,0),('93006','HUN','Hungria','','','','Unión Europea',2,0,0),('94006','IND','India','','','','',2,0,0),('95006','IDN','Indonesia','','','','',2,0,0),('96006','IRQ','Irak','','','','',2,0,0),('97006','IRN','Iran la Republica Islamica de','','','','',2,0,0),('98006','IRL','Irlanda','','','','Unión Europea',2,0,0),('99006','BVT','Isla Bouvet','','','','',2,0,0);
/*!40000 ALTER TABLE `catsat_paises` 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 2026-05-30  9:22:45
