-- 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 `familias` -- DROP TABLE IF EXISTS `familias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `familias` ( `FamiliasID` varchar(50) NOT NULL, `Nombre` varchar(50) DEFAULT NULL, `Activo` tinyint(4) DEFAULT '0', `InternalVersion` int(11) DEFAULT '0', `Numero` int(11) DEFAULT '0', `DivisionesID` varchar(50) DEFAULT NULL, `Memo1` varchar(50) DEFAULT NULL, `Memo2` varchar(50) DEFAULT NULL, `Memo3` varchar(50) DEFAULT NULL, `Licores` tinyint(4) DEFAULT '0', `Redondeo` tinyint(4) DEFAULT '0', `ApoyoRedondeo` tinyint(4) DEFAULT '0', `Boletos` tinyint(4) DEFAULT '0', `Servicios` tinyint(4) DEFAULT '0', `Multijuegos` tinyint(4) DEFAULT '0', `Memo4` varchar(50) DEFAULT NULL, `Manufacturado` tinyint(4) DEFAULT '0', `Memo5` varchar(50) DEFAULT NULL, PRIMARY KEY (`FamiliasID`), KEY `WDIDX_Familias_Activo` (`Activo`), KEY `WDIDX_Familias_Numero` (`Numero`), KEY `WDIDX_Familias_DivisionesID` (`DivisionesID`), KEY `WDIDX_Familias_Licores` (`Licores`), KEY `WDIDX_Familias_Redondeo` (`Redondeo`), KEY `WDIDX_Familias_ApoyoRedondeo` (`ApoyoRedondeo`), KEY `WDIDX_Familias_Boletos` (`Boletos`), KEY `WDIDX_Familias_Servicios` (`Servicios`), KEY `WDIDX_Familias_Multijuegos` (`Multijuegos`), KEY `WDIDX_Familias_Manufacturado` (`Manufacturado`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `familias` -- LOCK TABLES `familias` WRITE; /*!40000 ALTER TABLE `familias` DISABLE KEYS */; INSERT INTO `familias` VALUES ('0-1','ETIQUETAS COMIDA',1,1,64,'CK','','','',0,0,0,0,0,0,'',0,''),('0-11','ARTICULOS A PRUEBA O CUPONES',1,3,28,'AE','','','',0,0,0,0,0,0,'',0,''),('0-12','BEBIDAS',1,1,2,'AE','','','',0,0,0,0,0,0,'',0,''),('0-13','ABONO APARTADO',1,1,41,'OC','','','',0,0,0,0,0,0,'',0,''),('0-14','REDONDEO',1,2,34,'FH','','','',0,1,0,0,0,0,'',0,''),('0-15','APOYO REDONDEO',1,2,40,'FH','','','',0,0,1,0,0,0,'',0,''),('0-16','LENTES VIP',1,1,12,'CK','','','',0,0,0,0,0,0,'',0,''),('0-17','APOYO CON DESPENSAS',1,1,69,'CK','','','',0,0,0,0,0,0,'',0,''),('0-18','TAMARINDO ENCHILADO',1,5,1,'PECAS','','','',0,1,0,0,0,0,'',0,''),('0-19','DULCES Y PALETAS CARAMELO',1,4,2,'PECAS','','','',0,0,0,0,0,0,'',0,''),('0-2','ACCESORIOS DE COCINAS Y TIENDAS NUEVAS',1,1,60,'CK','','','',0,0,0,0,0,0,'',0,''),('0-20','POLVOS CON SAL/LIMON Y CHILE',1,2,9,'PECAS','','','',0,0,0,0,0,0,'',0,''),('0-21','CHURRITOS',1,1,10,'PECAS','','','',0,0,0,0,0,0,'',0,''),('0-22','SERVICIO TRANSPORTE (MODELO)',1,2,71,'CK','','','',0,0,0,0,0,0,'',0,''),('0-23','AGUA PRIFICADA A GRANEL',1,1,24,'PECAS','','','',0,0,0,0,0,0,'',0,''),('0-24','INSUMOS EL PECAS',1,1,25,'PECAS','','','',0,0,0,0,0,0,'',0,''),('0-25','ART AUTOMOTRIZ',1,1,21,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-26','VARIOS (LENTES, LLAVEROS, CACHUCHAS)',0,2,17,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-27','FARMACIA',1,1,18,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-28','PAPELERIA',1,1,24,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-29','MATERIAS PRIMAS VR SNACKS',1,1,30,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-3','PAPELERIA',1,1,62,'CK','','','',0,0,0,0,0,0,'',0,''),('0-30','BOTANAS',1,1,4,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-31','BOLSAS/PELICULA VR SNACK',1,2,31,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-32','UNIFORMES',1,1,68,'SNK','','','',0,0,0,0,0,0,'',0,''),('0-33','ABARROTES',1,1,6,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-34','PAPELERIA',1,1,24,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-35','ART. USO INTERNO',1,1,35,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-36','MATERIA PRIMAS PARA COCINA',1,1,59,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-37','ACCESORIOS DE COCINAS Y TIENDAS NUEVAS',1,1,60,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-38','LIMPIEZA',1,1,61,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-39','PAPELERIA',1,1,62,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-4','EMPAQUES Y VASOS DE COCINA',1,1,63,'CK','','','',0,0,0,0,0,0,'',0,''),('0-40','ETIQUETAS COMIDA',1,1,64,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-41','ARTICULOS DE LIMPIEZA',1,2,1,'GAS','','','',0,0,0,0,0,0,'',0,''),('0-42','REDONDEO',1,2,34,'PKY','','','',0,0,1,0,0,0,'',0,''),('0-43','APOYO REDONDEO',1,2,40,'PKY','','','',0,1,0,0,0,0,'',0,''),('0-44','INSUMOS VR SNACKS',1,1,72,'CK','','','',0,0,0,0,0,0,'',0,''),('0-45','REDONDEO',1,2,34,'ADM','','','',0,1,0,0,0,0,'',0,''),('0-46','APOYO A REDONDEO',1,2,40,'ADM','','','',0,0,1,0,0,0,'',0,''),('0-47','ARTICULOS DE PAPELERIA ',1,2,2,'GAS','','','',0,0,0,0,0,0,'',0,''),('0-48','MOBILIARIO Y EQUIPO',0,2,3,'GAS','','','',0,0,0,0,0,0,'',0,''),('0-49','HERRAMIENTAS Y EQUIPO DE MANTENIMIENTO',1,1,73,'CK','','','',0,0,0,0,0,0,'',0,''),('0-5','LIMPIEZA',1,1,61,'CK','','','',0,0,0,0,0,0,'',0,''),('0-50','UNIFORMES ',0,3,4,'GAS','','','',0,0,0,0,0,0,'',0,''),('0-51','AGUA LLENADO DE GALON',1,1,10,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-52','MANTENIMIENTO',0,2,5,'GAS','','','',0,0,0,0,0,0,'',0,''),('0-53','POSTRES ASIAN',1,1,65,'AE','','','',0,0,0,0,0,0,'',0,''),('0-54','FARMACIA',1,1,18,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-55','UNIFORMES',1,1,66,'AE','','','',0,0,0,0,0,0,'',0,''),('0-56','BLACK HAWK',1,3,74,'CK','','','',0,0,0,0,1,0,'',0,''),('0-57','UNIFORMES',1,1,68,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-58','CARRERA CARWASH',1,1,92,'CK','','','',0,0,0,0,0,0,'',0,''),('0-59','MOBILIARIO/EQUIPOS',1,1,50,'LOLAS','','','',0,0,0,0,0,0,'',0,''),('0-6','APOYO AL REDONDEO',1,2,41,'AE','','','',0,0,1,0,0,0,'',0,''),('0-7','REDONDEO',1,3,34,'AE','','','',0,1,0,0,0,0,'',0,''),('1-1','CERVEZA / ANTIDOTOS',1,2,1,'CK','','','',1,0,0,0,0,0,'',0,''),('1-10','BEBIDAS NO CARBONATADOS',1,1,10,'CK','','','',0,0,0,0,0,0,'',0,''),('1-11','ART LIMP IEZA(DETER',1,1,11,'CK','','','',0,0,0,0,0,0,'',0,''),('1-12','PERIODIC / REVISTAS',1,1,14,'CK','','','',0,0,0,0,0,0,'',0,''),('1-13','ART BEBE',1,1,15,'CK','','','',0,0,0,0,0,0,'',0,''),('1-14','PILAS (ENERGIZER-EVEREADY)',1,1,16,'CK','','','',0,0,0,0,0,0,'',0,''),('1-15','VARIOS (LENTES,LLAVEROS,CACHUCHAS)',1,2,17,'CK','','','',0,0,0,0,0,0,'',0,''),('1-16','FARMACIA',1,2,18,'CK','','','',0,0,0,0,0,0,'',0,''),('1-17','CARNES FRIAS',1,1,19,'CK','','','',0,0,0,0,0,0,'',0,''),('1-18','ART PROM OCIONALES',1,1,20,'CK','','','',0,0,0,0,0,0,'',0,''),('1-19','ART AUTO MOTRIZ',1,1,21,'CK','','','',0,0,0,0,0,0,'',0,''),('1-2','REFRESCOS',1,1,2,'CK','','','',0,0,0,0,0,0,'',0,''),('1-20','ART MASC OTAS',1,1,22,'CK','','','',0,0,0,0,0,0,'',0,''),('1-21','PALETERI A',1,1,23,'CK','','','',0,0,0,0,0,0,'',0,''),('1-22','PAPELERI A',1,3,24,'CK','','','',0,0,0,0,0,0,'',0,''),('1-23','VINOS Y LICORES',1,1,25,'CK','','','',1,0,0,0,0,0,'',0,''),('1-24','TARJETAS / TELEFONOS',1,2,26,'CK','','','',0,0,0,0,0,0,'',0,''),('1-25','HIELO (REFRIGERADOS)',1,1,27,'CK','','','',0,0,0,0,0,0,'',0,''),('1-26','ART PRUE BA',1,1,28,'CK','','','',0,0,0,0,0,0,'',0,''),('1-27','BOLETOS FERIA',1,2,29,'CK','','','',0,0,0,1,0,0,'',0,''),('1-28','MULTIJUEGOS TELEVISA',1,1,30,'CK','','','',0,0,0,0,0,1,'',0,''),('1-29','ART DESE CHABLES',1,1,31,'CK','','','',0,0,0,0,0,0,'',0,''),('1-3','LACTEOS',1,1,3,'CK','','','',0,0,0,0,0,0,'',0,''),('1-30','DISCOS Y CASETTES',1,1,32,'CK','','','',0,0,0,0,0,0,'',0,''),('1-31','FAST FOO D',1,1,33,'CK','','','',0,0,0,0,0,0,'',1,''),('1-32','REDONDEO',1,1,34,'CK','','','',0,1,0,0,0,0,'',0,''),('1-33','ART. USO INTERNO',1,1,35,'CK','','','',0,0,0,0,0,0,'',0,''),('1-34','RESTAURANT',1,1,36,'CK','','','',0,0,0,0,0,0,'',1,''),('1-35','RASCALE (MULTIJUEGOS TELEVISA)',1,1,37,'CK','','','',0,0,0,0,0,0,'',0,''),('1-36','SEGUROS CACHANILLA R C ',1,3,39,'CK','','','',0,0,0,1,0,0,'',0,''),('1-37','APOYO A REDONDEO',1,1,40,'CK','','','',0,0,1,0,0,0,'',0,''),('1-38','C.F.E.',1,1,41,'CK','','','',0,0,0,0,1,0,'',0,''),('1-39','OOMAPAS',1,2,42,'CK','','','',0,0,0,0,1,0,'',0,''),('1-4','BOTANAS',1,1,4,'CK','','','',0,0,0,0,0,0,'',0,''),('1-40','TELNOR',1,1,43,'CK','','','',0,0,0,0,1,0,'',0,''),('1-41','CABLE',1,1,44,'CK','','','',0,0,0,0,1,0,'',0,''),('1-42','TELMEX',1,1,45,'CK','','','',0,0,0,0,1,0,'',0,''),('1-43','C.E.S.P.T.E.',1,2,46,'CK','','','',0,0,0,0,1,0,'',0,''),('1-44','BOLETO BEISBOL',1,1,47,'CK','','','',0,0,0,1,0,0,'',0,''),('1-45','MOBILIARIO/EQUIPO',1,1,50,'CK','','','',0,0,0,0,0,0,'',0,''),('1-46','MEDICINA GENERICO (FARMACIA',1,1,51,'CK','','','',0,0,0,0,0,0,'',0,''),('1-47','MEDICINA PATENTE (FARMACIA)',1,1,52,'CK','','','',0,0,0,0,0,0,'',0,''),('1-48','VITAMINAS Y SUPLEMENTOS (FA',1,1,54,'CK','','','',0,0,0,0,0,0,'',0,''),('1-49','ART. PARA BEBE (FARMACIA)',1,1,55,'CK','','','',0,0,0,0,0,0,'',0,''),('1-5','GALLETAS PANES Y TORTILLAS',1,1,5,'CK','','','',0,0,0,0,0,0,'',0,''),('1-50','MISCELANEA (FARMACIA)',1,1,56,'CK','','','',0,0,0,0,0,0,'',0,''),('1-51','PERFUMERIA (FARMACIA)',1,1,57,'CK','','','',0,0,0,0,0,0,'',0,''),('1-52','MATERIAL DE CURACION (FARMA',1,1,58,'CK','','','',0,0,0,0,0,0,'',0,''),('1-53','GENERICO',1,1,0,'CK','','','',0,0,0,0,0,0,'',0,''),('1-54','LLAMADAS TELEFONICAS',1,2,48,'CK','','','',0,0,0,0,0,0,'',0,''),('1-55','C.E.S.P.M.',1,2,49,'CK','','','',0,0,0,0,1,0,'',0,''),('1-56','SERVICIOS BANAMEX',1,1,38,'CK','','','',0,0,0,0,1,0,'',0,''),('1-6','ABARROTES',1,1,6,'CK','','','',0,0,0,0,0,0,'',0,''),('1-7','BEBIDAS ISLA FRIA - CALIENTE',1,2,7,'CK','','','',0,0,0,0,0,0,'',0,''),('1-8','CHOCOLATE / DULCES',1,1,8,'CK','','','',0,0,0,0,0,0,'',0,''),('1-9','CIGARROS',1,3,9,'CK','','','',0,0,0,0,0,0,'',0,''),('10-1','ALARMAS',1,1,66,'CK','','','',0,0,0,0,1,0,'',0,''),('124-1','ACCESORIOS DOS',1,2,4,'OC','','','',0,0,0,0,0,0,'',0,''),('124-2','ACCESORIOS TRES',1,2,6,'OC','','','',0,0,0,0,0,0,'',0,''),('124-3','ACCESORIOS CUATRO',1,3,8,'OC','','','',0,0,0,0,0,0,'',0,''),('135-1','TABLETS',1,1,9,'OC','','','',0,0,0,0,0,0,'',0,''),('135-2','SERVICIOS TECNICOS',1,1,10,'OC','','','',0,0,0,0,0,0,'',0,''),('193-1','INSERTOS ENSALADERAS',1,1,89,'CK','','','',0,0,0,0,0,0,'',0,''),('193-2','C.E.S.P.E.',1,1,65,'CK','','','',0,0,0,0,1,0,'',0,''),('193-3','ART PDV CARRETERA',1,2,90,'CK','','','',0,0,0,0,0,0,'',0,''),('193-4','ART PROMO VIP ASIAN',1,2,91,'CK','','','',0,0,0,0,0,0,'',0,''),('2-1','CONCIERTOS GRUPO ANZA',1,1,13,'CK','','','',0,0,0,0,1,0,'',0,''),('210-1','ABARROTES COMESTIBLES',1,2,6,'SP','','','',0,0,0,0,0,0,'',0,''),('210-10','CHOCOLATES/DULCES',1,2,8,'SP','','','',0,0,0,0,0,0,'',0,''),('210-11','ART. AUTORMOTRIZ',1,2,21,'SP','','','',0,0,0,0,0,0,'',0,''),('210-12','ART. VARIOS',1,2,17,'SP','','','',0,0,0,0,0,0,'',0,''),('210-13','ART. LIMPIEZA (DETERGENTES)',1,2,11,'SP','','','',0,0,0,0,0,0,'',0,''),('210-14','ART. BEBE',1,2,15,'SP','','','',0,0,0,0,0,0,'',0,''),('210-15','DISCOS Y CASTTES',1,2,32,'SP','','','',0,0,0,0,0,0,'',0,''),('210-16','PAPELERIA',1,2,24,'SP','','','',0,0,0,0,0,0,'',0,''),('210-17','ART. MASCOTAS',1,2,22,'SP','','','',0,0,0,0,0,0,'',0,''),('210-18','CIGARROS',1,2,9,'SP','','','',0,0,0,0,0,0,'',0,''),('210-19','ART. USO INTERNO',1,2,35,'SP','','','',0,0,0,0,0,0,'',0,''),('210-2','FAST FOOD',1,2,7,'SP','','','',0,0,0,0,0,0,'',0,''),('210-20','ART. TEMPORADA',1,2,28,'SP','','','',0,0,0,0,0,0,'',0,''),('210-21','ART. PROMOCIONALES',1,2,20,'SP','','','',0,0,0,0,0,0,'',0,''),('210-22','ELECTRONICA',1,2,12,'SP','','','',0,0,0,0,0,0,'',0,''),('210-23','ELECTRODOMESTICOS',1,2,13,'SP','','','',0,0,0,0,0,0,'',0,''),('210-24','REGALOS',1,2,16,'SP','','','',0,0,0,0,0,0,'',0,''),('210-25','JUGUETES',1,2,36,'SP','','','',0,0,0,0,0,0,'',0,''),('210-26','VINOS Y LICORES',1,2,25,'SP','','','',0,0,0,0,0,0,'',0,''),('210-27','ART. DE TEMPORADA',1,2,23,'SP','','','',0,0,0,0,0,0,'',0,''),('210-28','MOVILIARIO/EQUIPO',1,2,50,'SP','','','',0,0,0,0,0,0,'',0,''),('210-29','ACCESORIOS P/TELEFONO',1,2,26,'SP','','','',0,0,0,0,0,0,'',0,''),('210-3','BOTANAS',1,2,4,'SP','','','',0,0,0,0,0,0,'',0,''),('210-30','ARTICULOS VARIOS',1,2,27,'SP','','','',0,0,0,0,0,0,'',0,''),('210-31','ARTICULOS P/LIMPIEZA Y USO INTERNO',1,2,61,'SP','','','',0,0,0,0,0,0,'',0,''),('210-32','ACCESORIOS DE COCINAS Y TIENDA',1,2,60,'SP','','','',0,0,0,0,0,0,'',0,''),('210-33','ARTICULOS DE PAPELERIA',1,2,62,'SP','','','',0,0,0,0,0,0,'',0,''),('210-34','EMPAQUES Y VASOS',1,2,63,'SP','','','',0,0,0,0,0,0,'',0,''),('210-35','ARTICULOS VARIOS (3)',1,2,37,'SP','','','',0,0,0,0,0,0,'',0,''),('210-36','ARTICULOS FARMACIA (2)',1,2,39,'SP','','','',0,0,0,0,0,0,'',0,''),('210-37','ARTICULOS DE TEMPORADA (2)',1,2,38,'SP','','','',0,0,0,0,0,0,'',0,''),('210-38','ARTICULOS PARA DAMA',1,2,14,'SP','','','',0,0,0,0,0,0,'',0,''),('210-39','ARTICULOS VARIOS (4)',1,2,47,'SP','','','',0,0,0,0,0,0,'',0,''),('210-4','GALLETAS, PANES Y TORTILLAS',1,2,5,'SP','','','',0,0,0,0,0,0,'',0,''),('210-40','JUGUETES (2)',1,2,46,'SP','','','',0,0,0,0,0,0,'',0,''),('210-41','ABARROTES (2)',1,2,30,'SP','','','',0,0,0,0,0,0,'',0,''),('210-42','APOYO AL REDONDEO',1,4,41,'SP','','','',0,0,1,0,0,0,'',0,''),('210-43','APARTADOS',1,3,64,'SP','','','',0,0,0,0,0,0,'',0,''),('210-5','CARNES FRIAS',1,2,19,'SP','','','',0,0,0,0,0,0,'',0,''),('210-6','LACTEOS',1,2,3,'SP','','','',0,0,0,0,0,0,'',0,''),('210-7','REFRESCOS',1,2,2,'SP','','','',0,0,0,0,0,0,'',0,''),('210-8','BEBIDAS NO CARBONATADOS',1,2,10,'SP','','','',0,0,0,0,0,0,'',0,''),('210-9','FARMACIA',1,2,18,'SP','','','',0,0,0,0,0,0,'',0,''),('219-1','SERVICIOS DE GOBIERNO',1,2,70,'CK','','','',0,0,0,0,1,0,'',0,''),('26-1','CONCIERTOS GRUPO ANZA',0,2,13,'CK','','','',0,0,0,0,1,0,'',0,''),('297-1','C.E.S.P.T.',1,2,67,'CK','','','',0,0,0,0,1,0,'',0,''),('3-1','REDONDEO',1,2,34,'SP','','','',0,1,0,0,0,0,'',0,''),('3-2','REGALOS (2)',1,4,40,'SP','','','',0,0,0,0,0,0,'',0,''),('326-1','TELEFONOS',1,2,1,'OC','','','',0,0,0,0,0,0,'',0,''),('326-2','TARJETAS Y CHIP',1,2,2,'OC','','','',0,0,0,0,0,0,'',0,''),('326-3','ACCESORIOS',1,4,3,'OC','','','',0,0,0,0,0,0,'',0,''),('326-4','RENTAS TARIFARIAS',1,2,5,'OC','','','',0,0,0,0,0,0,'',0,''),('326-5','PROMOCIONES',1,2,7,'OC','','','',0,0,0,0,0,0,'',0,''),('35-1','SEGUROS ALMEX',1,3,53,'CK','','','',0,0,0,0,1,0,'',0,''),('366-1','MOBILIARIO Y EQUIPO',1,1,50,'AE','','','',0,0,0,0,0,0,'',0,''),('366-10','LIMPIEZA',1,1,61,'AE','','','',0,0,0,0,0,0,'',0,''),('366-11','AGUA NATURAL',1,1,10,'AE','','','',0,0,0,0,0,0,'',0,''),('366-12','ETIQUETAS COMIDA',1,1,64,'AE','','','',0,0,0,0,0,0,'',0,''),('366-13','FARMACIA',1,3,18,'AE','','','',0,0,0,0,0,0,'',0,''),('366-14','EMPAQUES Y VASOS',1,1,63,'AE','','','',0,0,0,0,0,0,'',0,''),('366-2','ACCESORIOS DE COCINAS Y TIENDAS NUEVAS',1,1,60,'AE','','','',0,0,0,0,0,0,'',0,''),('366-3','ARTICULO USO INTERNO',1,1,35,'AE','','','',0,0,0,0,0,0,'',0,''),('366-4','CARNES FRIAS',1,1,19,'AE','','','',0,0,0,0,0,0,'',0,''),('366-5','MATERIA PRIMAS PARA COCINA',1,2,59,'AE','','','',0,0,0,0,0,0,'',0,''),('366-6','ALIMENTOS PROCESADOS WOK',1,1,3,'AE','','','',0,0,0,0,0,0,'',0,''),('366-7','VINOS Y LICORES VIVA VILLA',1,1,25,'AE','','','',0,0,0,0,0,0,'',0,''),('366-8','CONCENTRADO AGUAS FRESCAS Y TE',1,1,7,'AE','','','',0,0,0,0,0,0,'',0,''),('366-9','ART DESECHABLES',1,1,31,'AE','','','',0,0,0,0,0,0,'',0,''),('399-1','PAPELERIA',1,1,62,'AE','','','',0,0,0,0,0,0,'',0,''),('409-2','ABARROTES',1,1,6,'AE','','','',0,0,0,0,0,0,'',0,''),('409-3','PAPELERIA',1,1,24,'AE','','','',0,0,0,0,0,0,'',0,''),('58-1','UNIFORMES',1,1,68,'CK','','','',0,0,0,0,0,0,'',0,''),('589-1','SEMILLAS',1,1,3,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-2','FRUTOS SECOS',1,4,4,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-3','CHOCOLATES',1,1,5,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-4','MALVAVISCOS',1,1,6,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-5','GOMITAS',1,1,7,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-6','MAZAPAN',1,2,8,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-7','MATERIAS PRIMAS EL PECAS',1,1,21,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-8','BOLSAS Y CAJAS PARA EMPACAR',1,2,22,'PECAS','','','',0,0,0,0,0,0,'',0,''),('589-9','ETIQUETAS',1,1,23,'PECAS','','','',0,0,0,0,0,0,'',0,''),('77-1','MATERIA PRIMAS PARA COCINA',1,2,59,'CK','','','',0,0,0,0,0,0,'',0,''),('999-',NULL,0,0,0,NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL,0,NULL),('999-1','REDONDEO',1,1,34,'GAS','','','',0,1,0,0,0,0,'',0,''),('999-10','APOYO A REDONDEO',0,2,40,'PECAS','','','',0,0,1,0,0,0,'',0,''),('999-11','APOYO A REDONDEO',1,1,35,'CONT',NULL,NULL,NULL,0,0,1,0,0,0,NULL,0,NULL),('999-12','MOBILIARIO/EQUIPO',1,1,50,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-13','ART. USO INTERNO',1,1,35,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-14','MATERIA PRIMAS PARA COCINA',1,2,59,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-15','ACCESORIOS DE COCINAS Y TIENDAS NUEVAS',1,1,60,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-16','LIMPIEZA',1,1,61,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-17','PAPELERIA',1,1,62,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-18','EMPAQUES Y VASOS DE COCINA',1,1,63,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-19','ETIQUETAS COMIDA',1,1,64,'SNK','','','',0,0,0,0,0,0,'',0,''),('999-2','APOYO A REDONDEO',1,1,40,'GAS','','','',0,0,1,0,0,0,'',0,''),('999-20','REDONDEO',1,2,34,'LIMP','','','',0,1,0,0,0,0,'',0,''),('999-21','APOYO A REDONDEO',1,2,35,'LIMP',NULL,NULL,NULL,0,0,1,0,0,0,NULL,0,NULL),('999-3','APOYO A REDONDEO',1,1,40,'OC','','','',0,0,1,0,0,0,'',0,''),('999-4','REDONDEO',1,1,34,'OC','','','',0,1,0,0,0,0,'',0,''),('999-5','REDONDEO',1,1,34,'SUB','','','',0,1,0,0,0,0,'',0,''),('999-6','APOYO A REDONDEO',1,1,40,'SUB','','','',0,0,1,0,0,0,'',0,''),('999-7','REDONDEO',1,1,34,'CC','','','',0,1,0,0,0,0,'',0,''),('999-8','APOYO A REDONDEO',1,1,40,'CC','','','',0,0,1,0,0,0,'',0,''),('999-9','REDONDEO',1,1,34,'CONT','','','',0,1,0,0,0,0,'',0,''); /*!40000 ALTER TABLE `familias` 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:24:00