-- 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 `consecutivostiendas` -- DROP TABLE IF EXISTS `consecutivostiendas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `consecutivostiendas` ( `ConsecutivosTiendasID` varchar(50) DEFAULT NULL, `InternalVersion` int(11) DEFAULT '0', `Valor` varchar(50) DEFAULT NULL, `TiposConsecutivosID` varchar(50) DEFAULT NULL, `TiendasID` varchar(50) DEFAULT NULL, `Consecutivo` bigint(20) DEFAULT '0', KEY `WDIDX_ConsecutivosTiendas_ConsecutivosTiendasID` (`ConsecutivosTiendasID`), KEY `WDIDX_ConsecutivosTiendas_TiposConsecutivosID` (`TiposConsecutivosID`), KEY `WDIDX_ConsecutivosTiendas_TiendasID` (`TiendasID`), KEY `WDIDX_ConsecutivosTiendas_Consecutivo` (`Consecutivo`), KEY `WDIDX_ConsecutivosTiendas_TiendaTiposConsecutivos` (`TiposConsecutivosID`,`TiendasID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `consecutivostiendas` -- LOCK TABLES `consecutivostiendas` WRITE; /*!40000 ALTER TABLE `consecutivostiendas` DISABLE KEYS */; INSERT INTO `consecutivostiendas` VALUES ('0-1',21,'18','Facturas','0-2',0),('0-10',164,'163','Facturas','192-195',0),('0-11',128,'127','Facturas','192-194',0),('0-12',10,'9','Facturas','0-225',0),('0-13',98,'97','Facturas','0-224',0),('0-14',17,'16','Facturas','0-233',0),('0-15',19,'18','Facturas','0-280',0),('0-16',25,'24','Facturas','0-227',0),('0-17',29,'29','Facturas','0-231',0),('0-18',67,'66','Facturas','0-235',0),('0-19',45,'44','Facturas','0-236',0),('0-2',4355,'4356','Facturas','192-23',0),('0-20',29,'29','Facturas','0-238',0),('0-21',53,'52','Facturas','0-223',0),('0-22',36,'41','Facturas','999-5',0),('0-23',151,'150','Facturas','192-226',0),('0-24',5,'4','Facturas','0-222',0),('0-25',6,'5','Facturas','0-234',0),('0-28',8,'7','Facturas','192-403',0),('0-3',3412,'3651','Facturas','0-144',0),('0-4',2138,'2173','Facturas','0-145',0),('0-5',6,'6','Facturas','0-156',0),('0-6',19,'18','Facturas','0-157',0),('0-7',372,'375','Facturas','0-185',0),('0-8',3,'2','Facturas','0-232',0),('0-9',60,'59','Facturas','0-228',0),('10-1',95,'97','Facturas','0-144',0),('102-2',5694,'5733','Facturas','12',0),('106-1',17898,'18019','Facturas','35',0),('106-2',97835,'98021','Facturas','2-12',0),('108-2',18395,'18572','Facturas','34',0),('114-3',213394,'185114','Facturas','2-14',0),('114-4',74576,'74935','Facturas','17',0),('114-5',12084,'12304','Facturas','104-34',0),('115-2',34782,'35125','Facturas','27',0),('12-2',6407,'6200','Facturas','6',0),('121-1',1851,'1865','Facturas','104-24',0),('125-2',10841,'10926','Facturas','104-31',0),('125-3',593,'600','Facturas','78-2',0),('126-1',56427,'56538','Facturas','104-41',0),('128-1',18475,'18518','Facturas','2-11',0),('130-1',130438,'130682','Facturas','2-17',0),('130-2',75706,'76175','Facturas','30',0),('138-1',92563,'109905','Facturas','2-15',0),('139-1',22782,'22947','Facturas','2-7',0),('140-1',18596,'18680','Facturas','2-8',0),('141-1',56489,'56772','Facturas','104-43',0),('142-1',7000,'7004','Facturas','104-42',0),('143-1',51706,'51767','Facturas','2-16',0),('144-1',30958,'31055','Facturas','2-5',0),('145-1',9864,'10704','Facturas','104-49',0),('145-2',636,'691','Facturas','104-56',0),('146-1',23130,'23130','Facturas','2-6',0),('147-1',90892,'91056','Facturas','2-20',0),('148-1',24303,'24409','Facturas','2-4',0),('150-1',14648,'14743','Facturas','2-10',0),('151-1',1894,'1907','Facturas','104-37',0),('151-2',1702,'1713','Facturas','104-36',0),('151-3',1155,'1167','Facturas','104-38',0),('151-4',1755,'1770','Facturas','104-35',0),('151-5',4433,'4478','Facturas','104-26',0),('151-6',4395,'4462','Facturas','104-33',0),('151-7',4242,'4275','Facturas','104-27',0),('151-8',1716,'1749','Facturas','104-29',0),('151-9',2547,'2580','Facturas','104-40',0),('152-1',188,'221','Facturas','104-51',0),('153-1',4321,'4384','Facturas','104-32',0),('154-1',62989,'63171','Facturas','104-47',0),('155-1',28987,'29050','Facturas','104-53',0),('155-2',707,'721','Facturas','78-1',0),('155-3',371,'379','Facturas','192-95',0),('156-4',4341,'4390','Facturas','104-52',0),('157-1',4664,'4694','Facturas','104-28',0),('158-1',1352,'1388','Facturas','104-59',0),('158-2',997,'1075','Facturas','192-234',0),('159-1',20638,'20689','Facturas','104-46',0),('16-2',29291,'29418','Facturas','9',0),('162-1',591,'611','Facturas','104-54',0),('162-2',420,'532','Facturas','104-55',0),('163-1',11064,'10990','Facturas','104-45',0),('164-1',5597,'5587','Facturas','21',0),('164-2',4389,'4570','Facturas','104-39',0),('174-1',564,'626','Facturas','78-7',0),('18-2',6785,'2846','Facturas','1',0),('187-1',17,'16','Facturas','192-144',0),('187-2',17,'16','Facturas','192-145',0),('187-3',5453,'5525','Facturas','192-180',0),('187-4',1354,'1377','Facturas','192-213',0),('187-6',30,'481','Facturas','0-145',0),('190-1',60320,'72397','Facturas','188-1',0),('190-2',145811,'146668','Facturas','192-3',0),('190-3',11322,'11437','Facturas','192-4',0),('195-2',5650,'5702','Facturas','192-2',0),('195-3',11958,'12008','Facturas','192-5',0),('20-1',15852,'15919','Facturas','192-56',0),('201-1',16986,'17047','Facturas','188-2',0),('201-2',23114,'23188','Facturas','188-3',0),('203-1',34378,'34540','Facturas','192-6',0),('203-2',87674,'87940','Facturas','192-8',0),('21-2',5869,'5935','Facturas','8',0),('210-1',3294,'3332','Facturas','192-10',0),('219-1',23387,'23394','Facturas','178-1',0),('219-2',105975,'106265','Facturas','178-2',0),('219-3',4831,'4867','Facturas','178-3',0),('22-2',9513,'9508','Facturas','3',0),('221-1',53841,'53997','Facturas','192-34',0),('221-2',36892,'37092','Facturas','192-31',0),('221-3',11309,'11496','Facturas','192-42',0),('243-1',38323,'38491','Facturas','192-172',0),('25-3',5329,'5427','Facturas','16',0),('250-1',10598,'10815','Facturas','192-50',0),('250-2',16829,'65495','Facturas','192-54',0),('259-1',8413,'8482','Facturas','192-48',0),('259-2',37157,'37327','Facturas','192-49',0),('260-1',4579,'4621','Facturas','192-53',0),('265-1',4101,'4186','Facturas','192-51',0),('265-2',6863,'6887','Facturas','192-55',0),('27-2',5759,'5909','Facturas','13',0),('275-1',1,'0','Facturas','192-366',0),('278-1',13494,'12996','Facturas','192-61',1968),('278-2',602,'604','Facturas','192-60',0),('28-2',5232,'5286','Facturas','15',0),('281-1',81003,'81192','Facturas','192-65',0),('281-2',7785,'7844','Facturas','192-64',0),('288-1',12749,'12844','Facturas','192-68',0),('288-2',95244,'95423','Facturas','192-69',0),('296-1',16032,'16045','Facturas','192-74',0),('296-2',144793,'145055','Facturas','192-75',0),('296-3',5433,'5464','Facturas','192-97',0),('297-1',36422,'36501','Facturas','192-71',0),('297-2',117835,'118119','Facturas','192-78',0),('297-3',9158,'9198','Facturas','192-98',0),('298-1',8417,'8477','Facturas','192-73',0),('298-2',58624,'58764','Facturas','178-5',0),('299-1',12376,'12457','Facturas','192-72',0),('299-2',59628,'59873','Facturas','192-88',0),('31-1',5063,'5148','Facturas','32',0),('32-3',6109,'6198','Facturas','5',0),('327-2',8192,'8236','Facturas','192-112',0),('328-3',53326,'53547','Facturas','192-114',0),('329-1',15936,'16013','Facturas','192-111',0),('334-2',6881,'7999','Facturas','192-119',0),('339-1',5353,'5403','Facturas','192-123',0),('339-2',42553,'42655','Facturas','192-125',0),('339-3',3326,'3353','Facturas','192-127',0),('34-1',6610,'6661','Facturas','26',0),('340-1',967,'969','Facturas','192-126',0),('343-2',48544,'48652','Facturas','192-124',0),('344-1',7767,'7806','Facturas','192-122',0),('355-1',7359,'7638','Facturas','192-129',0),('36-1',9944,'10025','Facturas','23',0),('361-1',8145,'8361','Facturas','192-130',0),('366-1',5044,'5190','Facturas','192-133',0),('368-1',3091,'3234','Facturas','178-6',0),('368-2',14131,'14175','Facturas','192-136',0),('374-2',1555,'1637','Facturas','178-16',0),('374-3',29369,'29473','Facturas','178-14',0),('38-1',7796,'7872','Facturas','25',0),('393-1',6735,'6743','Facturas','178-7',0),('398-1',8816,'8841','Facturas','192-142',0),('399-1',3122,'3202','Facturas','178-17',0),('401-1',11745,'11990','Facturas','178-12',0),('406-1',13215,'13361','Facturas','192-149',0),('409-1',3522,'3585','Facturas','192-147',0),('41-1',8860,'8898','Facturas','19',0),('411-1',1815,'1856','Facturas','192-152',0),('419-1',1952,'1959','Facturas','192-174',0),('424-2',3246,'3388','Facturas','192-161',0),('424-3',12750,'12847','Facturas','192-164',0),('426-1',5180,'5419','Facturas','192-155',0),('428-2',107135,'107397','Facturas','192-166',0),('431-1',56716,'57106','Facturas','192-157',0),('431-3',13840,'14149','Facturas','192-163',0),('433-2',23657,'23759','Facturas','192-165',0),('433-3',2062,'2184','Facturas','192-162',0),('434-1',3407,'3632','Facturas','192-156',0),('438-1',3324,'3401','Facturas','192-158',0),('439-1',1609,'1622','Facturas','192-159',0),('44-1',12085,'12192','Facturas','24',0),('443-1',10704,'10718','Facturas','192-160',0),('45-1',205,'205','Facturas','192-120',0),('46-1',19136,'14299','Facturas','18',0),('46-2',45623,'45749','Facturas','2-13',0),('467-1',5644,'5689','Facturas','192-192',0),('468-1',26109,'26172','Facturas','192-193',0),('468-2',1,'0','Facturas','0-139',0),('47-1',28448,'28455','Facturas','22',0),('47-4',83,'85','Facturas','0-145',0),('471-1',636,'641','Facturas','192-196',0),('472-1',4196,'4213','Facturas','192-197',0),('475-1',11347,'11392','Facturas','192-202',0),('478-1',1847,'1941','Facturas','192-190',0),('479-1',239,'241','Facturas','192-203',0),('48-2',6519,'6637','Facturas','192-113',0),('488-1',38475,'38734','Facturas','192-206',0),('493-1',19473,'19524','Facturas','178-25',0),('497-1',2388,'2464','Facturas','192-214',0),('500-1',24521,'24545','Facturas','178-28',0),('503-1',1874,'1948','Facturas','192-219',0),('509-1',7540,'7541','Facturas','192-220',0),('510-1',1679,'1754','Facturas','192-215',0),('510-2',648,'652','Facturas','192-218',0),('510-3',145,'150','Facturas','0-159',0),('517-1',33598,'33630','Facturas','192-221',0),('519-1',9245,'9269','Facturas','192-224',0),('525-1',4714,'4732','Facturas','192-225',0),('529-1',2176,'2180','Facturas','192-229',0),('530-1',2293,'2297','Facturas','192-227',0),('531-1',2618,'2620','Facturas','192-228',0),('532-1',3684,'3700','Facturas','192-230',0),('535-1',421,'430','Facturas','178-30',0),('539-1',1416,'1475','Facturas','178-29',0),('54-2',8599,'8668','Facturas','11',0),('544-1',1488,'1494','Facturas','192-232',0),('545-1',174,'173','Facturas','178-32',0),('546-1',1762,'1811','Facturas','178-33',0),('546-2',20504,'20658','Facturas','192-235',0),('55-3',109137,'109462','Facturas','2-9',0),('55-4',36900,'37188','Facturas','4',0),('554-1',375,'374','Facturas','178-35',0),('558-1',2083,'2177','Facturas','178-34',0),('56-1',5424,'5465','Facturas','14',0),('561-1',1205,'1205','Facturas','178-40',0),('563-1',3463,'3466','Facturas','192-238',0),('565-1',34208,'34220','Facturas','178-39',0),('566-1',1441,'1520','Facturas','178-38',0),('572-1',1043,'1064','Facturas','192-239',0),('573-1',2039,'2046','Facturas','178-36',0),('574-1',3652,'3653','Facturas','178-37',0),('575-1',1132,'1135','Facturas','178-43',0),('576-2',1777,'1813','Facturas','178-42',0),('58-11',1,'0','Facturas','192-155',0),('586-1',3776,'3832','Facturas','178-45',0),('589-1',136,'143','Facturas','192-242',0),('59-3',1238,'32179','Facturas','178-48',0),('594-1',528,'557','Facturas','192-356',0),('599-1',269,'268','Facturas','192-374',0),('6-1',278,'288','Facturas','192-375',0),('600-1',271,'271','Facturas','192-373',0),('601-1',284,'303','Facturas','192-372',0),('61-3',10256,'10375','Facturas','28',0),('62-1',55488,'55716','Facturas','2-18',0),('62-2',23482,'23634','Facturas','31',0),('65-2',5070,'5098','Facturas','10',0),('670-1',70,'69','Facturas','192-399',0),('70-3',8748,'8846','Facturas','29',0),('8-2',5091,'5135','Facturas','7',0),('800-27',754,'753','Facturas','192-357',0),('801-26',421,'420','Facturas','192-216',0),('83-1',8,'7','Facturas','192-116',0),('85-3',24831,'24938','Facturas','20',0),('85-4',84621,'84821','Facturas','2-19',0),('85-5',2096,'2218','Facturas','104-57',0),('86-1',33,'32','Facturas','192-247',0),('9-2',9465,'9595','Facturas','2',0),('901-1',152,'158','Facturas','178-49',0),('903-1',1700,'1734','Facturas','178-47',0),('850-1',708,'715','Facturas','192-402',0); /*!40000 ALTER TABLE `consecutivostiendas` 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:25:18