-- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
--
-- 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,0,'','','','',0,0,0,0,0,0,'',0,''),('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,1,340,'CK','','','',0,0,0,0,0,0,'',0,''),('0-15','APOYO REDONDEO',1,1,400,'CK','','','',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-3','PAPELERIA',1,1,62,'CK','','','',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-5','LIMPIEZA',1,1,61,'CK','','','',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,CAC',1,1,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,2,41,'SP','','','',0,0,0,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,2,40,'SP','','','',0,0,1,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,3,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,''),('77-1','MATERIA PRIMAS PARA COCINA',1,2,59,'CK','','','',0,0,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 2019-12-04  6:39:25