--
-- Host: localhost    Database: melcochudos
-- ------------------------------------------------------


--
-- Table structure for table `abonos`
--

CREATE TABLE `abonos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `nc` int DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `saldoinicialfactura` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `saldoinicial` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `observacionesabono` varchar(300) DEFAULT NULL,
  `observacionesabonos` varchar(100) DEFAULT NULL,
  `consecutivosistema` int DEFAULT NULL,
  `idoorden` int DEFAULT '0',
  `idorden` int DEFAULT '0',
  `idtercero` int DEFAULT '0',
  `destino` varchar(25) DEFAULT NULL,
  `idreserva` int DEFAULT '0',
  `idasesor` int DEFAULT '0',
  `abonogeneral` varchar(25) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idfactura` (`idfactura`),
  CONSTRAINT `abonos_ibfk_1` FOREIGN KEY (`idz`) REFERENCES `z` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonos`
--


--
-- Table structure for table `abonoscompras`
--

CREATE TABLE `abonoscompras` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmayorcompras` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` int DEFAULT '0',
  `valorinicial` int NOT NULL DEFAULT '0',
  `fecha` date DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `mediodepago` varchar(25) DEFAULT NULL,
  `observacionesabonocompra` varchar(200) DEFAULT NULL,
  `abonogeneral` varchar(25) DEFAULT NULL,
  `idtercero` int DEFAULT '0',
  `consecutivoac` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idmayorcompras` (`idmayorcompras`),
  KEY `idz` (`idz`),
  CONSTRAINT `abonoscompras_ibfk_1` FOREIGN KEY (`idmayorcompras`) REFERENCES `mayorescompras` (`id`),
  CONSTRAINT `abonoscompras_ibfk_2` FOREIGN KEY (`idz`) REFERENCES `z` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonoscompras`
--


--
-- Table structure for table `abonosexternos`
--

CREATE TABLE `abonosexternos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `nc` int DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `saldoinicialfactura` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `saldoinicial` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `observacionesabono` varchar(100) DEFAULT NULL,
  `observacionesabonos` varchar(100) DEFAULT NULL,
  `consecutivosistema` int DEFAULT NULL,
  `idoorden` int DEFAULT '0',
  `idorden` int DEFAULT '0',
  `idtercero` int DEFAULT '0',
  `destino` varchar(25) DEFAULT NULL,
  `idreserva` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idfactura` (`idfactura`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosexternos`
--


--
-- Table structure for table `abonosordenservicio`
--

CREATE TABLE `abonosordenservicio` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idorden` bigint unsigned NOT NULL,
  `consecutivo` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  `facturado` int DEFAULT '0',
  `abonado` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idfactura` (`idorden`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosordenservicio`
--


--
-- Table structure for table `abonosprestamos`
--

CREATE TABLE `abonosprestamos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `valor` int DEFAULT NULL,
  `saldoinicial` int DEFAULT NULL,
  `saldofinal` int DEFAULT NULL,
  `idz` int DEFAULT '1',
  `idusuario` int DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idprestamo` int DEFAULT NULL,
  `consecutivo` int DEFAULT NULL,
  `idcliente` int DEFAULT '0',
  `cc` int DEFAULT '0',
  `mediodepago` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosprestamos`
--


--
-- Table structure for table `abonosprestamosin`
--

CREATE TABLE `abonosprestamosin` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `valor` int DEFAULT NULL,
  `saldoinicial` int DEFAULT NULL,
  `saldofinal` int DEFAULT NULL,
  `idz` int DEFAULT '1',
  `idusuario` int DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idprestamo` int DEFAULT NULL,
  `consecutivo` int DEFAULT NULL,
  `idcliente` int DEFAULT '0',
  `cc` int DEFAULT '0',
  `mediodepago` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '0',
  `observaciones` varchar(100) DEFAULT NULL,
  `abonado` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosprestamosin`
--


--
-- Table structure for table `abonosreservas`
--

CREATE TABLE `abonosreservas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `nc` int DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `saldoinicialfactura` double NOT NULL DEFAULT '0',
  `cc` int DEFAULT '2',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `saldoinicial` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `observacionesabono` varchar(100) DEFAULT NULL,
  `observacionesabonos` varchar(100) DEFAULT NULL,
  `consecutivosistema` int DEFAULT NULL,
  `abonado` int DEFAULT '0',
  `idorden` int DEFAULT '0',
  `idtercero` int DEFAULT '0',
  `destino` varchar(25) DEFAULT NULL,
  `idreserva` int DEFAULT '0',
  `mediodepago` varchar(25) DEFAULT 'EFECTIVO',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idfactura` (`idfactura`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosreservas`
--


--
-- Table structure for table `abonosseparados`
--

CREATE TABLE `abonosseparados` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmayorseparados` bigint unsigned NOT NULL,
  `nc` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `saldoinicialfactura` double NOT NULL DEFAULT '0',
  `consecutivo` int NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `saldoinicial` double NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `idgasto` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idmayorseparados` (`idmayorseparados`),
  CONSTRAINT `abonosseparados_ibfk_1` FOREIGN KEY (`idz`) REFERENCES `z` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `abonosseparados`
--


--
-- Table structure for table `adicionales`
--

CREATE TABLE `adicionales` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned DEFAULT NULL,
  `idadicional` bigint unsigned DEFAULT NULL,
  `incremento` decimal(5,2) DEFAULT '0.00',
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idarticulo_2` (`idarticulo`,`idadicional`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idadicional` (`idadicional`),
  CONSTRAINT `adicionales_ibfk_1` FOREIGN KEY (`idadicional`) REFERENCES `articulos` (`id`),
  CONSTRAINT `adicionales_ibfk_2` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `adicionales`
--


--
-- Table structure for table `ajustesdebodega`
--

CREATE TABLE `ajustesdebodega` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cantidad` int DEFAULT NULL,
  `detalle` varchar(100) NOT NULL DEFAULT '',
  `idusuario` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idusuario` (`idusuario`),
  KEY `cc` (`cc`),
  CONSTRAINT `ajustesdebodega_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `ajustesdebodega_ibfk_3` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ajustesdebodega`
--


--
-- Table structure for table `ajustesdeinventario`
--

CREATE TABLE `ajustesdeinventario` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cantidad` double DEFAULT '0',
  `detalle` varchar(100) NOT NULL DEFAULT '',
  `idusuario` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idusuario` (`idusuario`),
  KEY `cc` (`cc`),
  CONSTRAINT `ajustesdeinventario_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ajustesdeinventario`
--


--
-- Table structure for table `anticipos`
--

CREATE TABLE `anticipos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fechacreacion` date DEFAULT NULL,
  `valor` int DEFAULT '0',
  `mediodepago` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'EFECTIVO',
  `afectacaja` tinyint unsigned DEFAULT '1',
  `observaciones` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `idorden` int DEFAULT '0',
  `idusuario` int DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `idz` int DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `idcliente` int DEFAULT '0',
  `anticpoencm` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `anticipos`
--


--
-- Table structure for table `anticiposeliminados`
--

CREATE TABLE `anticiposeliminados` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fechacreacion` date DEFAULT NULL,
  `valor` int DEFAULT '0',
  `mediodepago` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `afectacaja` tinyint unsigned DEFAULT '1',
  `observaciones` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `idorden` int DEFAULT '0',
  `idusuario` int DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `idcliente` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `anticiposeliminados`
--


--
-- Table structure for table `articulos`
--

CREATE TABLE `articulos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idtienda` int DEFAULT '1',
  `esmp` bit(1) DEFAULT b'1',
  `seproduce` int DEFAULT '0',
  `sedesccomponeenventa` int NOT NULL DEFAULT '1',
  `idseccion` int DEFAULT '0',
  `SUBseccion` varchar(50) DEFAULT 'GENERAL',
  `ordendelarticulo` int DEFAULT '0',
  `referencia` varchar(20) NOT NULL DEFAULT '',
  `alias` varchar(20) NOT NULL DEFAULT '',
  `codabajo` varchar(5) NOT NULL DEFAULT '',
  `CODARTICULOABAJO` varchar(5) NOT NULL DEFAULT '',
  `situacioncocina` varchar(25) DEFAULT 'CAJA',
  `descripcion` varchar(100) NOT NULL DEFAULT ' ',
  `descripcionlarga` varchar(300) NOT NULL DEFAULT ' ',
  `seccion` varchar(50) NOT NULL DEFAULT 'SELECCIONE',
  `valordeventa` double NOT NULL DEFAULT '0',
  `cantidad` double NOT NULL DEFAULT '0',
  `cantidadenbodega` int DEFAULT '0',
  `fechadecreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `extension` varchar(5) NOT NULL DEFAULT ' ',
  `cc` bigint unsigned NOT NULL DEFAULT '0',
  `ultimocoste` double NOT NULL DEFAULT '0',
  `tienecomposicion` int NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `saleenlamesa` int DEFAULT '1',
  `esmodificador` int DEFAULT '1',
  `costomedio` double NOT NULL DEFAULT '0',
  `costoactual` double NOT NULL DEFAULT '0',
  `cantidadminima` int DEFAULT '0',
  `numerodelineas` int NOT NULL DEFAULT '1',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `linea` varchar(50) NOT NULL DEFAULT 'SELECCIONE',
  `familiademodificadores` varchar(50) NOT NULL DEFAULT 'SELECCIONE',
  `descuentomaximo` int DEFAULT '0',
  `valordistribuidor` int NOT NULL DEFAULT '0',
  `descatalogado` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `tienemodificadores` int NOT NULL DEFAULT '0',
  `valordeventatiendas` double NOT NULL DEFAULT '0',
  `valordeventafundaciones` double NOT NULL DEFAULT '0',
  `valortiendavirtual` decimal(11,2) DEFAULT NULL,
  `comision` int NOT NULL DEFAULT '0',
  `orden` int NOT NULL DEFAULT '0',
  `semonitorea` int NOT NULL DEFAULT '0',
  `idunidaddemedida` bigint unsigned NOT NULL DEFAULT '1',
  `idrapi` varchar(25) DEFAULT NULL,
  `sesubeaifood` int DEFAULT '0',
  `sesubearappi` int DEFAULT '0',
  `venderaceropesos` int DEFAULT '0',
  `secompra` int DEFAULT '0',
  `marca` varchar(25) DEFAULT NULL,
  `talla` varchar(5) DEFAULT NULL,
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  `COD_SATELITE_ARTICULO` varchar(25) DEFAULT NULL,
  `fabricante` varchar(100) DEFAULT NULL,
  `modelo` varchar(100) DEFAULT NULL,
  `serial` varchar(100) DEFAULT NULL,
  `usuarioedita` varchar(100) DEFAULT NULL,
  `ultimaedicion` datetime DEFAULT CURRENT_TIMESTAMP,
  `cantidad2` int DEFAULT '0',
  `situacioncocina2` varchar(25) DEFAULT 'SELECCIONE',
  `valordeventaregular` int DEFAULT '0',
  `idifood` varchar(25) DEFAULT NULL,
  `sesubeashopify` int DEFAULT '0',
  `codigoarea` int DEFAULT NULL,
  `materiales` varchar(300) DEFAULT NULL,
  `idlinea` int DEFAULT NULL,
  `porcentajecomision` decimal(5,2) DEFAULT NULL,
  `cuenta_impuesto` int DEFAULT NULL,
  `urlfotoarticulo` varchar(500) DEFAULT 'https://susoftware.es/imagenes/susoftware.png',
  `imei` varchar(50) DEFAULT NULL,
  `sefactura` bit(1) DEFAULT b'1',
  `cupon_vence` date DEFAULT NULL,
  `porcentajeutilidad1` bit(1) DEFAULT b'0',
  `porcentajeutilidad2` bit(1) DEFAULT b'0',
  `tipoanimal` bit(1) DEFAULT b'0',
  `tiendavirtual` bit(1) DEFAULT b'1',
  `sevendeacero` bit(1) DEFAULT b'0',
  `descuentodeldia` int DEFAULT '0',
  `conteodiario` int DEFAULT '0',
  `cantidadbodega` bit(1) DEFAULT b'0',
  `verenventas` bit(1) DEFAULT b'0',
  `mostraartodosentv` int DEFAULT '1',
  `impultraprocesados` int DEFAULT '0',
  `urlfoto` bit(1) DEFAULT b'0',
  `meta` bit(1) DEFAULT b'0',
  `promocionar_t` int DEFAULT '0',
  `p_descuento1` decimal(3,2) DEFAULT '0.00',
  `compraminima` int DEFAULT '1',
  `vrventapublico` int DEFAULT '0',
  `dia` int DEFAULT '0',
  `lunes` int DEFAULT '0',
  `martes` int DEFAULT '0',
  `miercoles` int DEFAULT '0',
  `jueves` int DEFAULT '0',
  `viernes` int DEFAULT '0',
  `sabado` int DEFAULT '0',
  `domingo` int DEFAULT '0',
  `inilunes` time DEFAULT '00:00:00',
  `inimartes` time DEFAULT '00:00:00',
  `inimiercoles` time DEFAULT '00:00:00',
  `inijueves` time DEFAULT '00:00:00',
  `iniviernes` time DEFAULT '00:00:00',
  `inisabado` time DEFAULT '00:00:00',
  `inidomingo` time DEFAULT '00:00:00',
  `finlunes` time DEFAULT '00:00:00',
  `finmartes` time DEFAULT '00:00:00',
  `finmiercoles` time DEFAULT '00:00:00',
  `finjueves` time DEFAULT '00:00:00',
  `finviernes` time DEFAULT '00:00:00',
  `finsabado` time DEFAULT '00:00:00',
  `findomingo` time DEFAULT '00:00:00',
  `descuentodeldiaentv` int DEFAULT '0',
  `porcentaje_ganancia_en_venta` decimal(5,2) DEFAULT '0.00',
  `factorpresentacion` int DEFAULT '1',
  `idpresentacion` int DEFAULT '0',
  `presentacion` varchar(25) DEFAULT NULL,
  `valorporfactor` decimal(8,2) DEFAULT '0.00',
  `fecha_vence_articulos` date DEFAULT NULL,
  `referencia2` varchar(25) DEFAULT NULL,
  `compromisoactual` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idunidaddemedida` (`idunidaddemedida`),
  CONSTRAINT `articulos_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `articulos_ibfk_3` FOREIGN KEY (`idunidaddemedida`) REFERENCES `unidadesdemedida` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `articulos`
--

INSERT INTO `articulos` (`id`, `idtienda`, `esmp`, `seproduce`, `sedesccomponeenventa`, `idseccion`, `SUBseccion`, `ordendelarticulo`, `referencia`, `alias`, `codabajo`, `CODARTICULOABAJO`, `situacioncocina`, `descripcion`, `descripcionlarga`, `seccion`, `valordeventa`, `cantidad`, `cantidadenbodega`, `fechadecreacion`, `extension`, `cc`, `ultimocoste`, `tienecomposicion`, `idusuario`, `saleenlamesa`, `esmodificador`, `costomedio`, `costoactual`, `cantidadminima`, `numerodelineas`, `porcentajeiva`, `linea`, `familiademodificadores`, `descuentomaximo`, `valordistribuidor`, `descatalogado`, `subido`, `tienemodificadores`, `valordeventatiendas`, `valordeventafundaciones`, `valortiendavirtual`, `comision`, `orden`, `semonitorea`, `idunidaddemedida`, `idrapi`, `sesubeaifood`, `sesubearappi`, `venderaceropesos`, `secompra`, `marca`, `talla`, `referenciacruzada`, `pv`, `COD_SATELITE_ARTICULO`, `fabricante`, `modelo`, `serial`, `usuarioedita`, `ultimaedicion`, `cantidad2`, `situacioncocina2`, `valordeventaregular`, `idifood`, `sesubeashopify`, `codigoarea`, `materiales`, `idlinea`, `porcentajecomision`, `cuenta_impuesto`, `urlfotoarticulo`, `imei`, `sefactura`, `cupon_vence`, `porcentajeutilidad1`, `porcentajeutilidad2`, `tipoanimal`, `tiendavirtual`, `sevendeacero`, `descuentodeldia`, `conteodiario`, `cantidadbodega`, `verenventas`, `mostraartodosentv`, `impultraprocesados`, `urlfoto`, `meta`, `promocionar_t`, `p_descuento1`, `compraminima`, `vrventapublico`, `dia`, `lunes`, `martes`, `miercoles`, `jueves`, `viernes`, `sabado`, `domingo`, `inilunes`, `inimartes`, `inimiercoles`, `inijueves`, `iniviernes`, `inisabado`, `inidomingo`, `finlunes`, `finmartes`, `finmiercoles`, `finjueves`, `finviernes`, `finsabado`, `findomingo`, `descuentodeldiaentv`, `porcentaje_ganancia_en_venta`, `factorpresentacion`, `idpresentacion`, `presentacion`, `valorporfactor`, `fecha_vence_articulos`, `referencia2`, `compromisoactual`) VALUES (1,1,_binary '',1,1,1,'GENERAL',0,'','','','','CAJA','Pancakes con huevos y tocineta','Con Cafe o Jugo','SELECCIONE',12000,-1,0,'2025-10-30 17:26:08',' ',2,0,0,1,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,1,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-10-30 17:26:08',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(2,1,_binary '',1,1,2,'GENERAL',0,'','','','','CAJA','Porcion Red velvet','','SELECCIONE',9000,0,0,'2025-11-06 20:22:40',' ',0,0,0,1,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,1,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-06 20:22:40',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(3,1,_binary '',1,1,2,'GENERAL',0,'','','','','CAJA','Porcion de Chocolate','','SELECCIONE',9000,8,0,'2025-11-06 20:26:41',' ',0,9000,0,1,1,1,9000,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,2,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-06 20:26:41',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(4,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Expreso',' ','SELECCIONE',3500,0,0,'2025-11-08 10:59:27',' ',2,0,0,1,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-08 10:59:27',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(5,1,_binary '',1,1,2,'GENERAL',0,'','','','','CAJA','Porción Almojabana','','SELECCIONE',9000,0,0,'2025-11-09 03:56:45',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:56:45',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(6,1,_binary '',1,1,2,'GENERAL',0,'','','','','CAJA','Porción Naranja y Amapola','','SELECCIONE',8000,-1,0,'2025-11-09 03:56:48',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:56:48',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(7,1,_binary '',1,1,0,'GENERAL',0,'','','','','CAJA','Milo','','SELECCIONE',9500,0,0,'2025-11-09 03:56:52',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:56:52',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(8,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Ferrero','','SELECCIONE',9000,3,0,'2025-11-09 03:56:59',' ',0,9000,0,6,1,1,9000,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:56:59',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(9,1,_binary '',0,1,3,'GENERAL',0,'','','','','CAJA','Almendras','','SELECCIONE',8500,0,0,'2025-11-09 03:57:01',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:01',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(10,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Chocolate','','SELECCIONE',8500,1,0,'2025-11-09 03:57:03',' ',0,8500,0,6,1,1,8500,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:03',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(11,1,_binary '',0,1,3,'GENERAL',0,'','','','','CAJA','Churro','','SELECCIONE',8500,0,0,'2025-11-09 03:57:06',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:06',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(12,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Red Velvet','','SELECCIONE',8500,0,0,'2025-11-09 03:57:07',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:07',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(13,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Macadamia','','SELECCIONE',8500,0,0,'2025-11-09 03:57:07',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:07',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(14,1,_binary '',1,1,2,'GENERAL',0,'','','','','CAJA','Porción Zanahoria','','SELECCIONE',8000,0,0,'2025-11-09 03:57:11',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 03:57:11',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(15,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Americano','','SELECCIONE',3500,0,0,'2025-11-09 04:07:03',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:07:03',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(16,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Capuchino','','SELECCIONE',7000,0,0,'2025-11-09 04:07:39',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:07:39',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(17,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Te chai en leche','','SELECCIONE',7500,0,0,'2025-11-09 04:07:43',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:07:43',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(18,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Te chai en agua','','SELECCIONE',6500,0,0,'2025-11-09 04:07:49',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:07:49',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(19,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Chocolate en agua','','SELECCIONE',6500,0,0,'2025-11-09 04:09:54',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:09:54',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(20,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Milo','','SELECCIONE',7500,0,0,'2025-11-09 04:09:55',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:09:55',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(21,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Aromática','','SELECCIONE',0,0,0,'2025-11-09 04:10:40',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:10:40',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(22,1,_binary '',1,1,6,'GENERAL',0,'','','','','CAJA','Milo','','SELECCIONE',8500,0,0,'2025-11-09 04:12:10',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:10',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(23,1,_binary '',1,1,7,'GENERAL',0,'','','','','CAJA','Chocolate en leche','','SELECCIONE',7500,0,0,'2025-11-09 04:12:12',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:12',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(24,1,_binary '',1,1,6,'GENERAL',0,'','','','','CAJA','Limonada de sandia','','SELECCIONE',10000,0,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(25,1,_binary '',1,1,9,'GENERAL',0,'','','','','CAJA','Frutos Rojos','','SELECCIONE',11000,0,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(26,1,_binary '',1,1,9,'GENERAL',0,'','','','','CAJA','Sandía cereza','','SELECCIONE',11000,0,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(27,1,_binary '',1,1,9,'GENERAL',0,'','','','','CAJA','Maracumango','','SELECCIONE',11000,-1,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(28,1,_binary '',1,1,6,'GENERAL',0,'','','','','CAJA','Limonada de cereza','','SELECCIONE',10000,0,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(29,1,_binary '',1,1,6,'GENERAL',0,'','','','','CAJA','Limonada natural','','SELECCIONE',9000,0,0,'2025-11-09 04:12:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(30,1,_binary '',1,1,6,'GENERAL',0,'','','','','CAJA','Frape de café','','SELECCIONE',8500,0,0,'2025-11-09 04:12:14',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:12:14',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(31,1,_binary '',1,1,9,'GENERAL',0,'','','','','CAJA','Lulo','','SELECCIONE',11000,0,0,'2025-11-09 04:28:26',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:28:26',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(32,1,_binary '',1,1,5,'GENERAL',0,'','','','','CAJA','Wrap pollo','Tortilla, pollo deslechado, tocineta, aguacate, queso, lechuga y salsa. Acompañado de té y platanitos','SELECCIONE',22000,0,0,'2025-11-09 04:28:48',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 04:28:48',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(33,1,_binary '',1,1,5,'GENERAL',0,'','','','','CAJA','Wrap desmechado','Tortilla, carne desmechada, queso, aguacate, lechuga y salsa. Acompañado de platanitos y té','SELECCIONE',22000,-1,0,'2025-11-09 07:29:51',' ',2,0,0,1,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 07:29:51',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(34,1,_binary '',0,1,6,'GENERAL',0,'','','','','CAJA','Botella de agua','','SELECCIONE',2000,0,0,'2025-11-09 07:30:20',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 07:30:20',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(35,1,_binary '',1,1,5,'GENERAL',0,'','','','','CAJA','Bowl melcochudo','Ensalada de lechuga, pollo, tocineta, queso Gouda, crutons y salsa cesar','SELECCIONE',23000,0,0,'2025-11-09 13:01:34',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:01:34',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(36,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Milo','','SELECCIONE',9000,0,0,'2025-11-09 13:01:37',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:01:37',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(37,1,_binary '',1,1,1,'GENERAL',0,'','','','','CAJA','Omelette con queso y tocineta','Acompañado de aguacate y café o jugo','SELECCIONE',12000,-3,0,'2025-11-09 13:08:21',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:08:21',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(38,1,_binary '',0,1,6,'GENERAL',0,'','','','','CAJA','Vaso de leche','','SELECCIONE',3000,0,0,'2025-11-09 13:23:04',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:23:04',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(39,1,_binary '',1,1,9,'GENERAL',0,'','','','','CAJA','Soda con limon','Con sal y limón','SELECCIONE',4000,0,0,'2025-11-09 13:23:44',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:23:44',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(40,1,_binary '',0,1,6,'GENERAL',0,'','','','','CAJA','Hit','','SELECCIONE',3500,0,0,'2025-11-09 13:23:46',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:23:46',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(41,1,_binary '',1,1,4,'GENERAL',0,'','','','','CAJA','Tiramisú','','SELECCIONE',12000,-1,0,'2025-11-09 13:26:14',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:26:14',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(42,1,_binary '',1,1,4,'GENERAL',0,'','','','','CAJA','Cheesecake','Frutos rojos','SELECCIONE',12000,0,0,'2025-11-09 13:26:16',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 13:26:16',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(43,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','EN ESPERA',' ','SELECCIONE',0,0,0,'2025-11-09 17:41:55',' ',2,0,0,1,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,'-1','distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:41:55',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(44,1,_binary '',1,1,3,'GENERAL',0,'','','','','CAJA','Sneakers','','SELECCIONE',9000,0,0,'2025-11-09 17:43:05',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:43:05',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(45,1,_binary '',0,1,6,'GENERAL',0,'','','','','CAJA','Coca cola','','SELECCIONE',0,0,0,'2025-11-09 17:43:49',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:43:49',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(46,1,_binary '',0,1,6,'GENERAL',0,'','','','','CAJA','Soda','','SELECCIONE',2500,0,0,'2025-11-09 17:44:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:44:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(47,1,_binary '',1,1,1,'GENERAL',0,'','','','','CAJA','Arepa con carne desmechada','','SELECCIONE',10000,0,0,'2025-11-09 17:46:13',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:46:13',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(48,1,_binary '',0,1,1,'GENERAL',0,'','','','','CAJA','Tostadas francesas con huevo y fruta','','SELECCIONE',12000,0,0,'2025-11-09 17:46:34',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:46:34',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(49,1,_binary '',0,1,1,'GENERAL',0,'','','','','CAJA','Bowl granola con yogurt y fruta','Fruta sujeta a disponibilidad','SELECCIONE',13000,0,0,'2025-11-09 17:47:05',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-09 17:47:05',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(50,1,_binary '',0,1,3,'GENERAL',0,'','','','','CAJA','Chocomasmelo','','SELECCIONE',9000,2,0,'2025-11-13 18:28:22',' ',0,9000,0,6,1,1,9000,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,1,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-13 18:28:22',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0),(51,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-11-18 19:29:48',' ',0,0,0,6,1,1,0,0,0,1,0,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,0,NULL,NULL,NULL,'distrito',NULL,NULL,NULL,NULL,NULL,'2025-11-18 19:29:48',0,'SELECCIONE',0,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,_binary '\0',_binary '\0',_binary '\0',_binary '',_binary '\0',0,0,_binary '\0',_binary '\0',1,0,_binary '\0',_binary '\0',0,0.00,1,0,0,0,0,0,0,0,0,0,'00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00',0,0.00,1,0,NULL,0.00,NULL,NULL,0);

--
-- Table structure for table `asignacionarticulosfamiliasmodificadores`
--

CREATE TABLE `asignacionarticulosfamiliasmodificadores` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `familiademodificadores` varchar(50) NOT NULL DEFAULT '',
  `activo` int DEFAULT '0',
  `idfamilia` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sesubeaifood` int DEFAULT '0',
  `idrapi` varchar(25) DEFAULT NULL,
  `papa` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `orden` int DEFAULT '0',
  `sesubearappi` int DEFAULT '1',
  `minimo` int DEFAULT '0',
  `maximo` int DEFAULT '0',
  `ordenasignaionfm` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idfamilia` (`idfamilia`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `asignacionarticulosfamiliasmodificadores`
--


--
-- Table structure for table `asignacionclientesturnos`
--

CREATE TABLE `asignacionclientesturnos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idcliente` bigint unsigned DEFAULT NULL,
  `idturno` bigint unsigned DEFAULT NULL,
  `fechacreacion` date DEFAULT NULL,
  `idusuario` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idcliente` (`idcliente`),
  KEY `idturno` (`idturno`),
  KEY `idusuario` (`idusuario`),
  CONSTRAINT `asignacionclientesturnos_ibfk_1` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`),
  CONSTRAINT `asignacionclientesturnos_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `asignacionclientesturnos`
--


--
-- Table structure for table `asignacioncupones`
--

CREATE TABLE `asignacioncupones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `idcupon` bigint DEFAULT NULL,
  `fechainicio` date DEFAULT NULL,
  `fechafin` date DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `porcentajedescuento` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idfamilia` (`fechafin`),
  KEY `idcupon` (`idcupon`),
  CONSTRAINT `asignacioncupones_ibfk_1` FOREIGN KEY (`idcupon`) REFERENCES `cupones` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `asignacioncupones`
--


--
-- Table structure for table `asignaciondescuentos`
--

CREATE TABLE `asignaciondescuentos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `idcliente` int DEFAULT NULL,
  `fechainicio` date DEFAULT NULL,
  `fechafin` date DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `porcentajedescuento` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idfamilia` (`fechafin`)
) ENGINE=InnoDB AUTO_INCREMENT=1392 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `asignaciondescuentos`
--


--
-- Table structure for table `asignacionseccionesterceros`
--

CREATE TABLE `asignacionseccionesterceros` (
  `idcliente` bigint unsigned NOT NULL,
  `idseccion` bigint unsigned NOT NULL,
  `activo` int DEFAULT '1',
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idcliente_2` (`idcliente`,`idseccion`),
  KEY `idseccion` (`idseccion`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `asig1` FOREIGN KEY (`idseccion`) REFERENCES `secciones` (`id`),
  CONSTRAINT `asig12` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `asignacionseccionesterceros`
--

INSERT INTO `asignacionseccionesterceros` (`idcliente`, `idseccion`, `activo`, `id`) VALUES (7,1,1,1),(7,2,1,2),(7,3,1,3),(7,4,1,4),(7,5,1,5),(7,6,1,6),(7,7,1,7),(7,8,1,8),(9,1,1,16),(8,1,1,17),(6,1,1,18),(5,1,1,19),(2,1,1,20),(1,1,1,21),(9,2,1,22),(8,2,1,23),(6,2,1,24),(5,2,1,25),(2,2,1,26),(1,2,1,27),(9,3,1,28),(8,3,1,29),(6,3,1,30),(5,3,1,31),(2,3,1,32),(1,3,1,33),(9,4,1,34),(8,4,1,35),(6,4,1,36),(5,4,1,37),(2,4,1,38),(1,4,1,39),(9,5,1,40),(8,5,1,41),(6,5,1,42),(5,5,1,43),(2,5,1,44),(1,5,1,45),(9,6,1,46),(8,6,1,47),(6,6,1,48),(5,6,1,49),(2,6,1,50),(1,6,1,51),(9,7,1,52),(8,7,1,53),(6,7,1,54),(5,7,1,55),(2,7,1,56),(1,7,1,57),(9,8,1,58),(8,8,1,59),(6,8,1,60),(5,8,1,61),(2,8,1,62),(1,8,1,63),(6,9,1,79),(7,9,1,80),(9,9,1,81),(1,9,1,86),(2,9,1,87),(5,9,1,88),(8,9,1,89),(1,10,1,93),(2,10,1,94),(5,10,1,95),(6,10,1,96),(7,10,1,97),(8,10,1,98),(9,10,1,99);

--
-- Table structure for table `asignacionzonasterceros`
--

CREATE TABLE `asignacionzonasterceros` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idcliente` bigint unsigned NOT NULL,
  `idzona` bigint unsigned NOT NULL,
  `activo` int DEFAULT '1',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idcliente` (`idcliente`,`idzona`),
  KEY `clienteszonas2` (`idzona`),
  CONSTRAINT `clienteszonas1` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`),
  CONSTRAINT `clienteszonas2` FOREIGN KEY (`idzona`) REFERENCES `zonas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `asignacionzonasterceros`
--

INSERT INTO `asignacionzonasterceros` (`id`, `idcliente`, `idzona`, `activo`) VALUES (1,5,1,1),(2,6,1,1),(5,7,1,1),(6,8,1,1),(7,9,1,1),(10,1,1,1),(11,2,1,1),(13,1,2,1),(14,2,2,1),(15,5,2,1),(16,6,2,1),(17,7,2,1),(18,8,2,1),(19,9,2,1),(36,1,4,1),(37,2,4,1),(38,5,4,1),(39,6,4,1),(40,7,4,1),(41,8,4,1),(42,9,4,1);

--
-- Table structure for table `auxiliarbuscarpadre`
--

CREATE TABLE `auxiliarbuscarpadre` (
  `a` int NOT NULL,
  `b` int NOT NULL,
  `idusuario` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `auxiliarbuscarpadre`
--


--
-- Table structure for table `auxiliarcambiodeprecios`
--

CREATE TABLE `auxiliarcambiodeprecios` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idinsumo` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL DEFAULT '1',
  `cc` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idinsumo`),
  KEY `idcaja` (`idarticulo`),
  KEY `cc` (`cc`),
  CONSTRAINT `auxiliarcambiodeprecios_ibfk_1` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`),
  CONSTRAINT `auxiliarcambiodeprecios_ibfk_2` FOREIGN KEY (`idinsumo`) REFERENCES `articulos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `auxiliarcambiodeprecios`
--


--
-- Table structure for table `auxiliarcostoagrupado`
--

CREATE TABLE `auxiliarcostoagrupado` (
  `idarticulo` int NOT NULL,
  `idinsumo` int NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `auxiliarcostoagrupado`
--


--
-- Table structure for table `auxiliarcotizarreceta`
--

CREATE TABLE `auxiliarcotizarreceta` (
  `idarticulo` int NOT NULL,
  `idinsumo` int NOT NULL,
  `idusuario` int NOT NULL,
  `cantidad` double NOT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `auxiliarcotizarreceta`
--


--
-- Table structure for table `bajas`
--

CREATE TABLE `bajas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `codvendedor` int NOT NULL DEFAULT '0',
  `REFERENCIA` varchar(20) DEFAULT NULL,
  `situacioncocina` varchar(50) DEFAULT NULL,
  `idmayor` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `INCREMENTO` int NOT NULL,
  `codarticulo` int NOT NULL,
  `codsituacion` int NOT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `referenciafront` varchar(15) DEFAULT NULL,
  `impuesto` double DEFAULT '0',
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` bigint unsigned NOT NULL,
  `esmodificador` int DEFAULT '0',
  `nombrearticulo` varchar(100) DEFAULT NULL,
  `cantidad` double NOT NULL DEFAULT '0',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `idmesa` int NOT NULL DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `baseunitario` double NOT NULL DEFAULT '0',
  `ivaunitario` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `documento` varchar(3) NOT NULL DEFAULT 'V',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `HORAINI` datetime DEFAULT NULL,
  `HORAFIN` datetime DEFAULT NULL,
  `ultimaedicion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `idnc` bigint unsigned NOT NULL DEFAULT '1',
  `nc` int DEFAULT '0',
  `idusuarionc` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `comision` int NOT NULL DEFAULT '0',
  `devolucionrevisada` int DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `fechamc` datetime DEFAULT NULL,
  `tienenc` int NOT NULL DEFAULT '0',
  `marcadoparanc` int NOT NULL DEFAULT '0',
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODMODIF` varchar(2) NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `CODARTICULOABAJO` varchar(12) NOT NULL DEFAULT '',
  `PRECIOIVA` int NOT NULL DEFAULT '0',
  `NUMMODIF` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `aliasespera` int NOT NULL DEFAULT '1',
  `impresiones` int NOT NULL DEFAULT '1',
  `IDMOTIVODTO` varchar(2) NOT NULL DEFAULT '-1',
  `DETALLEDENUMLINEA` varchar(2) NOT NULL DEFAULT '0',
  `FAMILIAAENA` varchar(2) NOT NULL DEFAULT '0',
  `DETALLEMODIF` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_NUMERO` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_N` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_SERIE` varchar(2) NOT NULL DEFAULT '0',
  `ABONODE_FO` varchar(2) NOT NULL DEFAULT '-1',
  `NORDERTIQUET` varchar(1) NOT NULL DEFAULT '0',
  `SORDERTIQUET` varchar(1) NOT NULL DEFAULT '',
  `REQ` int NOT NULL DEFAULT '0',
  `COSTEIVA` int NOT NULL DEFAULT '0',
  `DTO` int NOT NULL DEFAULT '0',
  `TIPO` varchar(2) NOT NULL DEFAULT 'V',
  `CODMACRO` int NOT NULL DEFAULT '0',
  `CODFORMATO` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idmayor` (`idmayor`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  CONSTRAINT `bajas_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bajas_ibfk_3` FOREIGN KEY (`idz`) REFERENCES `z` (`id`),
  CONSTRAINT `bajas_ibfk_4` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bajas_ibfk_6` FOREIGN KEY (`idmayor`) REFERENCES `mayoresbajas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bajas`
--


--
-- Table structure for table `bajasauxiliar`
--

CREATE TABLE `bajasauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `referenciafront` varchar(15) DEFAULT NULL,
  `descripcion` varchar(50) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idmesa` int DEFAULT '1',
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int NOT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '2',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `observacion` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃƒÂ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `bajasauxiliar_ibfk_1` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`),
  CONSTRAINT `bajasauxiliar_ibfk_3` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bajasauxiliar_ibfk_4` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bajasauxiliar_ibfk_6` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bajasauxiliar`
--


--
-- Table structure for table `banco`
--

CREATE TABLE `banco` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` int DEFAULT NULL,
  `valor` double DEFAULT '0',
  `tipo` varchar(25) DEFAULT NULL,
  `descripcion` varchar(25) DEFAULT NULL,
  `concepto` varchar(200) DEFAULT NULL,
  `idz` int DEFAULT '1',
  `fecha` date DEFAULT NULL,
  `valorinicial` double DEFAULT '0',
  `valorfinal` double DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `banco`
--


--
-- Table structure for table `barrios`
--

CREATE TABLE `barrios` (
  `barrio` varchar(150) DEFAULT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `incremento` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `barrio` (`barrio`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `barrios`
--

INSERT INTO `barrios` (`barrio`, `id`, `incremento`) VALUES ('PELUQUERIA VIERNES Am',20,0),('CUIDADO FACIAL',21,0),('EL COTIJO',22,0);

--
-- Table structure for table `bases`
--

CREATE TABLE `bases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `base` int NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL,
  `idz` int NOT NULL DEFAULT '1',
  `idusuario` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `usuario` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idz` (`idz`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bases`
--

INSERT INTO `bases` (`id`, `base`, `fechacreacion`, `idz`, `idusuario`, `pv`, `usuario`) VALUES (1,107000,'2025-11-20 08:56:03',1,6,'extremabelleza',NULL);

--
-- Table structure for table `bitacora`
--

CREATE TABLE `bitacora` (
  `id` int NOT NULL,
  `texto` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `fecha` date DEFAULT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `idcliente` bigint unsigned DEFAULT NULL,
  `idusuario` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  CONSTRAINT `bitacora_ibfk_1` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bitacora_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bitacora`
--


--
-- Table structure for table `bolsillos`
--

CREATE TABLE `bolsillos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL,
  `valorinicial` double NOT NULL DEFAULT '0',
  `valorfinal` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idfactura` int DEFAULT '0',
  `movimiento` varchar(8) DEFAULT 'INGRESO',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  CONSTRAINT `bolsillos_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `bolsillos_ibfk_2` FOREIGN KEY (`idz`) REFERENCES `z` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `bolsillos`
--


--
-- Table structure for table `cajamayor`
--

CREATE TABLE `cajamayor` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` int DEFAULT NULL,
  `valor` double DEFAULT '0',
  `tipo` varchar(25) DEFAULT NULL,
  `descripcion` varchar(25) DEFAULT NULL,
  `concepto` varchar(25) DEFAULT NULL,
  `idz` int DEFAULT '1',
  `fecha` date DEFAULT NULL,
  `valorinicial` double DEFAULT '0',
  `valorfinal` double DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cajamayor`
--


--
-- Table structure for table `cajamayor2`
--

CREATE TABLE `cajamayor2` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` int DEFAULT NULL,
  `valor` double DEFAULT '0',
  `tipo` varchar(25) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT '',
  `concepto` varchar(120) DEFAULT NULL,
  `idz` int DEFAULT '1',
  `fecha` date DEFAULT NULL,
  `valorinicial` double DEFAULT '0',
  `valorfinal` double DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `mediodepago` varchar(25) DEFAULT NULL,
  `entrada` double DEFAULT '0',
  `salida` double DEFAULT '0',
  `idprestamoin` int DEFAULT NULL,
  `idtabla` int DEFAULT '0',
  `tabla` varchar(12) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cajamayor2`
--


--
-- Table structure for table `cajas`
--

CREATE TABLE `cajas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `caja` varchar(25) NOT NULL DEFAULT '',
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cajas`
--

INSERT INTO `cajas` (`id`, `caja`, `cc`, `pv`) VALUES (1,'1',1,'distrito'),(2,'1',2,'distrito');

--
-- Table structure for table `calendario`
--

CREATE TABLE `calendario` (
  `id` int NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `titulo` varchar(200) DEFAULT NULL,
  `start` datetime DEFAULT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `profesional` varchar(100) DEFAULT NULL,
  `estado` varchar(25) DEFAULT 'PENDIENTE',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `calendario`
--


--
-- Table structure for table `cambios`
--

CREATE TABLE `cambios` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bruto` double DEFAULT '0',
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `referenciafront` varchar(15) DEFAULT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idfactura` int DEFAULT NULL,
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int NOT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '2',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `mediodepago` varchar(25) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `tipo` varchar(25) DEFAULT NULL,
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `CODARTICULOABAJO` int NOT NULL DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `impreso` int DEFAULT '0',
  `unidadesdemedida` varchar(25) DEFAULT NULL,
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `referencia` varchar(25) DEFAULT NULL,
  `consecutivo` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cambios`
--


--
-- Table structure for table `cambiosauxiliar`
--

CREATE TABLE `cambiosauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bruto` double DEFAULT '0',
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `iva` double DEFAULT '0',
  `descripcion` varchar(120) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idfactura` int DEFAULT NULL,
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int NOT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '2',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `observacion` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `CODARTICULOABAJO` int NOT NULL DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `impreso` int DEFAULT '0',
  `unidadesdemedida` varchar(25) DEFAULT NULL,
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `referencia` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cambiosauxiliar`
--


--
-- Table structure for table `cambiosrecibidoauxiliar`
--

CREATE TABLE `cambiosrecibidoauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bruto` double DEFAULT '0',
  `estadoimpresion` int DEFAULT '0',
  `identificador` varchar(100) DEFAULT NULL,
  `referenciapayu` varchar(200) DEFAULT NULL,
  `referenciafront` varchar(15) DEFAULT NULL,
  `descripcion` varchar(120) DEFAULT NULL,
  `pagarcontraentrega` int DEFAULT '0',
  `idfactura` int DEFAULT NULL,
  `descuento` double NOT NULL DEFAULT '0',
  `codsituacion` int NOT NULL,
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `idarticulo` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL DEFAULT '2',
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `comentario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(200) DEFAULT NULL,
  `valorunitario` double NOT NULL DEFAULT '0',
  `cantidad` int DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fechaentregado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `costomedio` double DEFAULT '0',
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `tipo` varchar(25) DEFAULT NULL,
  `observacion` varchar(25) NOT NULL DEFAULT '',
  `despachado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `entregado` int NOT NULL DEFAULT '0' COMMENT 'Significa que la cocina ya sirviÃ² el producto',
  `enespera` int NOT NULL DEFAULT '0' COMMENT 'para que el mesero ya no pueda eliminar',
  `comision` int NOT NULL DEFAULT '0',
  `porcentajedescuento` double NOT NULL DEFAULT '0',
  `impuesto` double NOT NULL DEFAULT '0',
  `base` double NOT NULL DEFAULT '0',
  `servicio` double NOT NULL DEFAULT '0',
  `CODMODIF` int NOT NULL DEFAULT '0',
  `numlinea` int NOT NULL DEFAULT '0',
  `esmodif` int NOT NULL DEFAULT '0',
  `situacioncocina` varchar(50) DEFAULT NULL,
  `CODARTICULOABAJO` int NOT NULL DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `unidaddemedida` varchar(25) DEFAULT NULL,
  `impreso` int DEFAULT '0',
  `unidadesdemedida` varchar(25) DEFAULT NULL,
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `afectacaja` int DEFAULT '1',
  `referencia` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idvendedor` (`idvendedor`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cambiosrecibidoauxiliar`
--


--
-- Table structure for table `cargos`
--

CREATE TABLE `cargos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cargo` varchar(120) NOT NULL DEFAULT '',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cargos`
--


--
-- Table structure for table `causaciones`
--

CREATE TABLE `causaciones` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `valor` int DEFAULT '0',
  `idcliente` int DEFAULT NULL,
  `tipo` varchar(15) DEFAULT 'PAGO',
  `estado` varchar(25) DEFAULT 'ACTIVO',
  `idpadre3` varchar(25) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `fechacreacion` datetime DEFAULT CURRENT_TIMESTAMP,
  `fecharecibido4` date DEFAULT NULL,
  `devolucionreportada` bit(1) DEFAULT b'0',
  `fecharecibido7` datetime DEFAULT NULL,
  `fecharecibido10` datetime DEFAULT NULL,
  `fechaeliminado` datetime DEFAULT NULL,
  `usuarioelimina` varchar(150) DEFAULT NULL,
  `idfactura` int DEFAULT '0',
  `idpadre` int DEFAULT '0',
  `cliente` varchar(25) DEFAULT NULL,
  `padre` varchar(25) DEFAULT NULL,
  `idmayornomina` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cc` (`idcliente`)
) ENGINE=InnoDB AUTO_INCREMENT=452 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `causaciones`
--


--
-- Table structure for table `centrosdecostos`
--

CREATE TABLE `centrosdecostos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `refrescarcache` int DEFAULT '0',
  `debepagarel` int DEFAULT '0',
  `direccion` varchar(120) NOT NULL DEFAULT ' ',
  `titulotirilla` varchar(50) DEFAULT NULL,
  `pagoefectivo` int DEFAULT '0',
  `cuenta_costodeventa` int DEFAULT NULL,
  `type_regime_id` int DEFAULT '0',
  `ultimomespagado` int DEFAULT '0',
  `telefono` varchar(20) NOT NULL DEFAULT ' ',
  `nit` varchar(20) NOT NULL DEFAULT ' ',
  `centrodecostos` varchar(100) NOT NULL DEFAULT 'ALIMENTOS DOGGY',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `representante` varchar(100) NOT NULL DEFAULT ' ',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idresolucion` bigint unsigned NOT NULL DEFAULT '1',
  `email` varchar(100) DEFAULT '',
  `regimen` varchar(45) DEFAULT NULL,
  `comentariotirilla` text,
  `convertirpedidoenfactura` int DEFAULT '0',
  `numero` varchar(40) DEFAULT '',
  `prefijo` varchar(5) DEFAULT NULL,
  `razonsocialcomanda` varchar(100) DEFAULT NULL,
  `mostrariva` int NOT NULL DEFAULT '0',
  `contacto` varchar(200) DEFAULT NULL,
  `telefonocontacto` varchar(25) DEFAULT NULL,
  `cuenta_ingreso` int DEFAULT NULL,
  `modulocontable` bit(1) DEFAULT b'0',
  `impresionfichaderegistro` varchar(7) DEFAULT 'TIRILLA',
  `cuenta_inventario` int DEFAULT NULL,
  `alerta2` varchar(100) DEFAULT NULL,
  `desde` int DEFAULT NULL,
  `hasta` int DEFAULT NULL,
  `porcentajeservicio` int DEFAULT '10',
  `lineaimpuestos` varchar(4) DEFAULT '12',
  `fecharesolucion` date DEFAULT NULL,
  `fechainicioresolucion` date DEFAULT NULL,
  `fechafinresolucion` date DEFAULT NULL,
  `prefijofe` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(2) DEFAULT NULL,
  `codigomunicipio` varchar(5) DEFAULT NULL,
  `ciudad` varchar(25) DEFAULT NULL,
  `departamento` varchar(25) DEFAULT NULL,
  `id_tipo_persona` int DEFAULT '2',
  `tipo_identificacion` varchar(3) DEFAULT 'NIT',
  `prefijonc` varchar(2) DEFAULT NULL,
  `token_taxxa` varchar(150) DEFAULT NULL,
  `usuarioTaxxa` varchar(150) DEFAULT NULL,
  `claveTaxxa` varchar(15) DEFAULT NULL,
  `puedeusar` int DEFAULT '0',
  `descuento` double DEFAULT '0',
  `descuentodeldia` int DEFAULT '0',
  `alerta` varchar(150) DEFAULT NULL,
  `hastafe` int DEFAULT '0',
  `fechahastafe` date DEFAULT NULL,
  `satelitecallcenter` varchar(25) DEFAULT 'SELECCIONE',
  `tituloimpuestos` varchar(50) DEFAULT 'DETALLE IMPOCONSUMO',
  `nombreimpuesto` varchar(50) DEFAULT 'IMPOCONSUMO',
  `endpoint_taxxa` varchar(200) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `zonapostal` varchar(6) DEFAULT NULL,
  `prefijodocequivalente` varchar(5) DEFAULT NULL,
  `responsabilidades` varchar(10) DEFAULT NULL,
  `tipo_persona` varchar(7) DEFAULT 'company',
  `resdianfe` varchar(25) DEFAULT NULL,
  `desdefe` int DEFAULT '0',
  `fechafe` date DEFAULT NULL,
  `cuenta_devolucion` int DEFAULT NULL,
  `comosemideeltiempo` int DEFAULT '0',
  `minutosdescanso` int DEFAULT '0',
  `tiendaonline` bit(1) DEFAULT b'1',
  `cuenta_cxp` int DEFAULT NULL,
  `vence_firmadigital` date DEFAULT NULL,
  `ultimocobro` datetime DEFAULT NULL,
  `fechaproximopago` date DEFAULT NULL,
  `telegram_vendedor` varchar(25) DEFAULT NULL,
  `calculodeservicio` varchar(5) DEFAULT 'total',
  `textowsp` varchar(100) DEFAULT NULL,
  `wsp` varchar(100) DEFAULT NULL,
  `visitastv` int DEFAULT '0',
  `calculodescuento` varchar(5) DEFAULT 'total',
  `mostrarcategorias` varchar(2) DEFAULT 'SI',
  `calculodelcosto` varchar(5) DEFAULT 'total',
  `mostrarpventv` varchar(2) DEFAULT 'SI',
  `urlinstagram` varchar(200) DEFAULT NULL,
  `urlfacebook` varchar(200) DEFAULT NULL,
  `urltiktok` varchar(200) DEFAULT NULL,
  `titulocabecera` varchar(100) DEFAULT '',
  `piedepaginafe` varchar(500) DEFAULT NULL,
  `lunes` bit(1) DEFAULT b'1',
  `martes` bit(1) DEFAULT b'1',
  `miercoles` bit(1) DEFAULT b'1',
  `jueves` bit(1) DEFAULT b'1',
  `viernes` bit(1) DEFAULT b'1',
  `sabado` bit(1) DEFAULT b'1',
  `domingo` bit(1) DEFAULT b'1',
  `inilunes` time DEFAULT '08:00:00',
  `inimartes` time DEFAULT '08:00:00',
  `inimiercoles` time DEFAULT '08:00:00',
  `inijueves` time DEFAULT '08:00:00',
  `iniviernes` time DEFAULT '08:00:00',
  `inisabado` time DEFAULT '08:00:00',
  `inidomingo` time DEFAULT '08:00:00',
  `finlunes` time DEFAULT '23:00:00',
  `finmartes` time DEFAULT '23:00:00',
  `finmiercoles` time DEFAULT '23:00:00',
  `finjueves` time DEFAULT '23:00:00',
  `finviernes` time DEFAULT '23:00:00',
  `finsabado` time DEFAULT '23:00:00',
  `findomingo` time DEFAULT '23:00:00',
  `inilunes2` time DEFAULT '08:00:00',
  `finlunes2` time DEFAULT '08:00:00',
  `inimartes2` time DEFAULT '08:00:00',
  `finmartes2` time DEFAULT '08:00:00',
  `inimiercoles2` time DEFAULT '08:00:00',
  `finmiercoles2` time DEFAULT '08:00:00',
  `inijueves2` time DEFAULT '08:00:00',
  `finjueves2` time DEFAULT '08:00:00',
  `iniviernes2` time DEFAULT '08:00:00',
  `finviernes2` time DEFAULT '08:00:00',
  `inisabado2` time DEFAULT '08:00:00',
  `finsabado2` time DEFAULT '08:00:00',
  `inidomingo2` time DEFAULT '08:00:00',
  `findomingo2` time DEFAULT '08:00:00',
  `porcentajeips` int DEFAULT '0',
  `activarporcentajeips` int DEFAULT '0',
  `fechafinfe` date DEFAULT NULL,
  `resposelectronico` varchar(25) DEFAULT NULL,
  `desdeposelectronico` int DEFAULT '0',
  `hastaposelectronico` int DEFAULT '0',
  `fechaposelectronico` date DEFAULT NULL,
  `fechafinposelectronico` date DEFAULT NULL,
  `prefijope` varchar(4) DEFAULT NULL,
  `fechahastape` date DEFAULT NULL,
  `registromercantil` varchar(25) DEFAULT NULL,
  `digitodeverificacion` int DEFAULT NULL,
  `tokenapidian` varchar(100) DEFAULT NULL,
  `idsoftware` varchar(100) DEFAULT '',
  `pin` varchar(6) DEFAULT NULL,
  `firmadigital` text,
  `clavefirmadigital` varchar(50) DEFAULT NULL,
  `horainicioprocedimientos` time DEFAULT NULL,
  `modulo` int DEFAULT '4',
  `SoftwareID` varchar(80) DEFAULT NULL,
  `clavefirma` varchar(20) DEFAULT NULL,
  `nombrecomercialcc` varchar(50) DEFAULT '',
  `porcentaje_ganancia_en_venta` decimal(5,2) DEFAULT NULL,
  `snotetop` varchar(150) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `centrosdecostos`
--

INSERT INTO `centrosdecostos` (`id`, `refrescarcache`, `debepagarel`, `direccion`, `titulotirilla`, `pagoefectivo`, `cuenta_costodeventa`, `type_regime_id`, `ultimomespagado`, `telefono`, `nit`, `centrodecostos`, `fechacreacion`, `representante`, `idusuario`, `idresolucion`, `email`, `regimen`, `comentariotirilla`, `convertirpedidoenfactura`, `numero`, `prefijo`, `razonsocialcomanda`, `mostrariva`, `contacto`, `telefonocontacto`, `cuenta_ingreso`, `modulocontable`, `impresionfichaderegistro`, `cuenta_inventario`, `alerta2`, `desde`, `hasta`, `porcentajeservicio`, `lineaimpuestos`, `fecharesolucion`, `fechainicioresolucion`, `fechafinresolucion`, `prefijofe`, `codigodepartamento`, `codigomunicipio`, `ciudad`, `departamento`, `id_tipo_persona`, `tipo_identificacion`, `prefijonc`, `token_taxxa`, `usuarioTaxxa`, `claveTaxxa`, `puedeusar`, `descuento`, `descuentodeldia`, `alerta`, `hastafe`, `fechahastafe`, `satelitecallcenter`, `tituloimpuestos`, `nombreimpuesto`, `endpoint_taxxa`, `pv`, `zonapostal`, `prefijodocequivalente`, `responsabilidades`, `tipo_persona`, `resdianfe`, `desdefe`, `fechafe`, `cuenta_devolucion`, `comosemideeltiempo`, `minutosdescanso`, `tiendaonline`, `cuenta_cxp`, `vence_firmadigital`, `ultimocobro`, `fechaproximopago`, `telegram_vendedor`, `calculodeservicio`, `textowsp`, `wsp`, `visitastv`, `calculodescuento`, `mostrarcategorias`, `calculodelcosto`, `mostrarpventv`, `urlinstagram`, `urlfacebook`, `urltiktok`, `titulocabecera`, `piedepaginafe`, `lunes`, `martes`, `miercoles`, `jueves`, `viernes`, `sabado`, `domingo`, `inilunes`, `inimartes`, `inimiercoles`, `inijueves`, `iniviernes`, `inisabado`, `inidomingo`, `finlunes`, `finmartes`, `finmiercoles`, `finjueves`, `finviernes`, `finsabado`, `findomingo`, `inilunes2`, `finlunes2`, `inimartes2`, `finmartes2`, `inimiercoles2`, `finmiercoles2`, `inijueves2`, `finjueves2`, `iniviernes2`, `finviernes2`, `inisabado2`, `finsabado2`, `inidomingo2`, `findomingo2`, `porcentajeips`, `activarporcentajeips`, `fechafinfe`, `resposelectronico`, `desdeposelectronico`, `hastaposelectronico`, `fechaposelectronico`, `fechafinposelectronico`, `prefijope`, `fechahastape`, `registromercantil`, `digitodeverificacion`, `tokenapidian`, `idsoftware`, `pin`, `firmadigital`, `clavefirmadigital`, `horainicioprocedimientos`, `modulo`, `SoftwareID`, `clavefirma`, `nombrecomercialcc`, `porcentaje_ganancia_en_venta`, `snotetop`) VALUES (2,0,32,'Calle 5 # 26-62','RECIBO DE CAJA',0,0,0,2,'3154431169','34556407','EXTREMA BELLEZA CALI','2020-12-24 19:28:24','MARIA IRSA FERNANDEZ RIVERA',1,1,'extremabellezacali@gmail.com','NATUTAL','si deseas alguna información administrativa, contáctate al 315 4431169, recuerda después de 5 días no aceptamos devoluciones, en productos, servicios o cursos, no se aceptan reclamos sin esta factura, para algún reclamo debe hacerlo al 3154431169',0,'',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,'12',NULL,NULL,NULL,NULL,'52','001','CALI-3154431169','52',2,'NIT',NULL,NULL,NULL,NULL,0,0,0,NULL,NULL,NULL,'SELECCIONE',NULL,'IMPOCONSUMO','','extremabelleza','630001',NULL,NULL,'company',NULL,NULL,NULL,NULL,0,0,_binary '',NULL,NULL,NULL,NULL,NULL,'total',NULL,NULL,2,'total','SI','total','1',NULL,NULL,NULL,'',NULL,_binary '',_binary '',_binary '',_binary '',_binary '',_binary '',_binary '','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','23:00:00','23:00:00','23:00:00','23:00:00','23:00:00','23:00:00','23:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00','08:00:00',0,0,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,4,NULL,NULL,'',NULL,NULL);

--
-- Table structure for table `cierres`
--

CREATE TABLE `cierres` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(50) DEFAULT '',
  `observaciones` varchar(200) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idz_2` (`idz`,`mediodepago`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  CONSTRAINT `cierres_ibfk_1` FOREIGN KEY (`idz`) REFERENCES `z` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cierres`
--

INSERT INTO `cierres` (`id`, `fechacreacion`, `valor`, `idusuario`, `idz`, `mediodepago`, `observaciones`) VALUES (1,'2025-11-20 21:27:39',0,6,1,'EFECTIVO',NULL),(2,'2025-11-20 21:27:39',0,6,1,'DAVIPLATA',NULL),(3,'2025-11-20 21:27:39',0,6,1,'BOLD',NULL),(4,'2025-11-20 21:27:39',0,6,1,'NEQUI',NULL),(5,'2025-11-20 21:27:39',0,6,1,'BANCOLOMBIA',NULL),(6,'2025-11-20 21:27:39',0,6,1,'SISTECREDITO',NULL),(7,'2025-11-20 21:27:39',0,6,1,'DINERO LOCAL 2 O 3 ',NULL),(8,'2025-11-20 21:27:39',0,6,1,'TRANSFERENCIA EDUCATE',NULL),(9,'2025-11-20 21:27:39',0,6,1,'ADDI',NULL),(10,'2025-11-20 21:27:39',0,6,1,'ANULACION X CONCEPTO DE',NULL);

--
-- Table structure for table `cierresdecaja`
--

CREATE TABLE `cierresdecaja` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `m1` int NOT NULL DEFAULT '0',
  `m2` int NOT NULL DEFAULT '0',
  `m5` int NOT NULL DEFAULT '0',
  `m10` int NOT NULL DEFAULT '0',
  `m20` int NOT NULL DEFAULT '0',
  `m50` int NOT NULL DEFAULT '0',
  `m100` int NOT NULL DEFAULT '0',
  `m200` int NOT NULL DEFAULT '0',
  `m500` int NOT NULL DEFAULT '0',
  `m1000` int NOT NULL DEFAULT '0',
  `b5` int NOT NULL DEFAULT '0',
  `b20` int NOT NULL DEFAULT '0',
  `b10` int NOT NULL DEFAULT '0',
  `b50` int NOT NULL DEFAULT '0',
  `b100` int NOT NULL DEFAULT '0',
  `b1000` int NOT NULL DEFAULT '0',
  `b2000` int NOT NULL DEFAULT '0',
  `b5000` int NOT NULL DEFAULT '0',
  `b10000` int NOT NULL DEFAULT '0',
  `b20000` int NOT NULL DEFAULT '0',
  `b50000` int NOT NULL DEFAULT '0',
  `b100000` int NOT NULL DEFAULT '0',
  `tarjeta` int NOT NULL DEFAULT '0',
  `rappi` int NOT NULL DEFAULT '0',
  `uber` int NOT NULL DEFAULT '0',
  `ifood` int NOT NULL DEFAULT '0',
  `domi` int NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcaja` bigint unsigned NOT NULL,
  `declarado` double NOT NULL DEFAULT '0',
  `efectivoenz` double NOT NULL DEFAULT '0',
  `diferencia` double NOT NULL DEFAULT '0',
  `observaciones` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `venta` double DEFAULT '0',
  `domicilio` double DEFAULT '0',
  `base` double DEFAULT '0',
  `gasto` double DEFAULT '0',
  `esperado` double DEFAULT '0',
  `sobrante` double DEFAULT '0',
  `faltante` double DEFAULT '0',
  `servicio` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `cc` (`cc`),
  CONSTRAINT `cierresdecaja_ibfk_2` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cierresdecaja`
--


--
-- Table structure for table `ciudades`
--

CREATE TABLE `ciudades` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ciudad` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `cc` bigint unsigned NOT NULL,
  `codigodepartamento` varchar(7) DEFAULT NULL,
  `departamento` varchar(25) DEFAULT NULL,
  `codigociudad` varchar(7) DEFAULT NULL,
  `codigopostal` varchar(7) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `ciudades`
--

INSERT INTO `ciudades` (`id`, `ciudad`, `cc`, `codigodepartamento`, `departamento`, `codigociudad`, `codigopostal`, `pv`) VALUES (1,'CALI',2,'05','VALLE','60000','e','distrito'),(3,'PEREIRA',2,'66','RISARALDA','001',NULL,'distrito'),(4,'ARMENIA',2,'06','QUINDIO','63000','630001','distrito'),(5,'PASTO',2,NULL,'NARIÑO',NULL,NULL,'distrito');

--
-- Table structure for table `clasesdevehiculo`
--

CREATE TABLE `clasesdevehiculo` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clasedevehiculo` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `clasedevehiculo` (`clasedevehiculo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `clasesdevehiculo`
--


--
-- Table structure for table `clasificacionclientes`
--

CREATE TABLE `clasificacionclientes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `clasificacion` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clasificacionclientes`
--


--
-- Table structure for table `clientes`
--

CREATE TABLE `clientes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `primernombre` varchar(100) DEFAULT NULL,
  `barrio` varchar(25) DEFAULT NULL,
  `grupo` varchar(50) DEFAULT NULL,
  `codabajo` int DEFAULT NULL,
  `primerapellido` varchar(25) DEFAULT '',
  `tipodepersona` int DEFAULT '2',
  `cedula` varchar(15) DEFAULT '',
  `direccion` varchar(100) DEFAULT '',
  `fechadenacimiento` date DEFAULT NULL,
  `celular` varchar(15) DEFAULT '',
  `fechadecreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ciudad` varchar(40) DEFAULT '',
  `departamento` varchar(25) DEFAULT 'RISARALDA',
  `clave` text,
  `rol` varchar(25) NOT NULL DEFAULT 'CLIENTE',
  `email` varchar(100) DEFAULT '',
  `telefono` varchar(10) DEFAULT '',
  `edad` int NOT NULL DEFAULT '0',
  `genero` varchar(12) NOT NULL DEFAULT 'MASCULINO',
  `tipodedocumento` varchar(5) NOT NULL DEFAULT 'CC',
  `saldo` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `esproveedor` varchar(2) DEFAULT 'NO',
  `cuantoledebo` int DEFAULT '0',
  `bolsillo` int DEFAULT '0',
  `contacto` varchar(200) DEFAULT '',
  `telefonocontacto` varchar(25) DEFAULT '',
  `espersonajuridica` int NOT NULL DEFAULT '0',
  `enviarcorreo` int NOT NULL DEFAULT '0',
  `observacion` text,
  `numerocalle` varchar(4) DEFAULT NULL,
  `puntos` int NOT NULL DEFAULT '0',
  `esempleado` int NOT NULL DEFAULT '0',
  `idgrupo` int DEFAULT '0',
  `descatalogado` int DEFAULT '0',
  `eps` varchar(150) DEFAULT NULL,
  `afp` varchar(150) DEFAULT NULL,
  `codigociudad` varchar(5) DEFAULT '66001',
  `codigodepartamento` varchar(3) DEFAULT '66',
  `codigopostal` varchar(10) DEFAULT '660001',
  `razonsocial` varchar(100) DEFAULT NULL,
  `segundonombre` varchar(25) DEFAULT NULL,
  `segundoapellido` varchar(25) DEFAULT NULL,
  `legalidad` int DEFAULT '0',
  `tipo_identificacion` varchar(5) DEFAULT 'CC',
  `nombrecomercial` varchar(200) DEFAULT NULL,
  `dv` int DEFAULT NULL,
  `sfiscalresponsibilities` varchar(7) DEFAULT 'R-99-PN',
  `regimenfiscal` int DEFAULT '49',
  `expedicioncedula` date DEFAULT NULL,
  `marcavehiculo` varchar(25) DEFAULT NULL,
  `placavehiculo` varchar(6) DEFAULT NULL,
  `nacionalidad` varchar(25) DEFAULT NULL,
  `municipioexpedido` varchar(25) DEFAULT NULL,
  `departamentoexpedido` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `sessionid` varchar(32) DEFAULT NULL,
  `huella` blob,
  `idcargo` int DEFAULT '0',
  `codigonomina` varchar(1) DEFAULT NULL,
  `codigozona` varchar(5) DEFAULT NULL,
  `areanomina` varchar(5) DEFAULT NULL,
  `idturno` int DEFAULT '0',
  `idturno2` int DEFAULT '0',
  `fechainicioturnoactual` date DEFAULT NULL,
  `fechafinturnoactual` date DEFAULT NULL,
  `fechainicioprooximoturno` date DEFAULT NULL,
  `fechaprooximoturno` date DEFAULT NULL,
  `iddomiciliarioyoyo` int DEFAULT NULL,
  `ciudadexpedicioncedula` varchar(25) DEFAULT NULL,
  `intentosfallidos` int DEFAULT '0',
  `ipultimoacceso` varchar(16) DEFAULT NULL,
  `codigoarea` varchar(5) DEFAULT NULL,
  `pagarextras` bit(1) DEFAULT b'0',
  `vencimientolicencia` date DEFAULT NULL,
  `diacontacto1` int DEFAULT '0',
  `diacontacto2` int DEFAULT '0',
  `urlfotocliente` varchar(170) DEFAULT NULL,
  `tokendispositivo` varchar(150) DEFAULT NULL,
  `sueldomensual` int DEFAULT '0',
  `auxtransportemensual` int DEFAULT '0',
  `clasificacion` varchar(25) DEFAULT 'CLIENTE FINAL',
  `instagram` varchar(50) DEFAULT NULL,
  `licenciaconduccion` varchar(25) DEFAULT NULL,
  `nombrereferencia1` varchar(150) DEFAULT NULL,
  `nombrereferencia2` varchar(150) DEFAULT NULL,
  `telefonoreferencia1` varchar(150) DEFAULT NULL,
  `telefonoreferencia2` varchar(150) DEFAULT NULL,
  `parentescorefererencia2` varchar(150) DEFAULT NULL,
  `parentesco` varchar(150) DEFAULT NULL,
  `parentescorefererencia1` varchar(150) DEFAULT NULL,
  `EDS` varchar(1) DEFAULT NULL,
  `comensalescliente` int DEFAULT '0',
  `idtelegram` varchar(25) DEFAULT NULL,
  `membrecia_hasta` date DEFAULT NULL,
  `idpadre2` int DEFAULT '0',
  `banco` varchar(25) DEFAULT NULL,
  `tipodecuenta` varchar(12) DEFAULT NULL,
  `cuentabancaria` varchar(15) DEFAULT NULL,
  `urlcedulacliente` varchar(100) DEFAULT NULL,
  `urlrutcliente` varchar(100) DEFAULT NULL,
  `urlcamaracliente` varchar(100) DEFAULT NULL,
  `fecha_expedicion` date DEFAULT NULL,
  `datosvalidados` int DEFAULT '0',
  `ultimavalidacion` date DEFAULT NULL,
  `cuentainscrita` int DEFAULT '0',
  `fechaactualizacionrut` date DEFAULT NULL,
  `direccion2` varchar(100) DEFAULT NULL,
  `direccion3` varchar(100) DEFAULT NULL,
  `identificadortv` varchar(30) DEFAULT NULL,
  `origencliente` varchar(10) DEFAULT 'CLIENTES',
  `aceptacondiciones` int DEFAULT '0',
  `fechaaceptacondiciones` date DEFAULT NULL,
  `HTTP_HOST` bit(1) DEFAULT b'0',
  `porcentaje_comision_enventa` int DEFAULT '0',
  `codigomasser` bit(1) DEFAULT b'0',
  `rutacualizado` varchar(2) DEFAULT 'NO',
  `tokenfirebase` varchar(500) DEFAULT NULL,
  `origen_cliente` varchar(3) DEFAULT 'CON',
  `proximallamada` date DEFAULT NULL,
  `idpadre` int DEFAULT '0',
  `campovalor_cliente` varchar(25) DEFAULT 'valordeventa',
  `responsable` varchar(50) DEFAULT NULL,
  `aplicaretencion` int DEFAULT '0',
  `puedehacerpedido` int DEFAULT '1',
  `clientes_bloqueados` varchar(300) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `clientes`
--

INSERT INTO `clientes` (`id`, `primernombre`, `barrio`, `grupo`, `codabajo`, `primerapellido`, `tipodepersona`, `cedula`, `direccion`, `fechadenacimiento`, `celular`, `fechadecreacion`, `ciudad`, `departamento`, `clave`, `rol`, `email`, `telefono`, `edad`, `genero`, `tipodedocumento`, `saldo`, `cc`, `idusuario`, `esproveedor`, `cuantoledebo`, `bolsillo`, `contacto`, `telefonocontacto`, `espersonajuridica`, `enviarcorreo`, `observacion`, `numerocalle`, `puntos`, `esempleado`, `idgrupo`, `descatalogado`, `eps`, `afp`, `codigociudad`, `codigodepartamento`, `codigopostal`, `razonsocial`, `segundonombre`, `segundoapellido`, `legalidad`, `tipo_identificacion`, `nombrecomercial`, `dv`, `sfiscalresponsibilities`, `regimenfiscal`, `expedicioncedula`, `marcavehiculo`, `placavehiculo`, `nacionalidad`, `municipioexpedido`, `departamentoexpedido`, `pv`, `sessionid`, `huella`, `idcargo`, `codigonomina`, `codigozona`, `areanomina`, `idturno`, `idturno2`, `fechainicioturnoactual`, `fechafinturnoactual`, `fechainicioprooximoturno`, `fechaprooximoturno`, `iddomiciliarioyoyo`, `ciudadexpedicioncedula`, `intentosfallidos`, `ipultimoacceso`, `codigoarea`, `pagarextras`, `vencimientolicencia`, `diacontacto1`, `diacontacto2`, `urlfotocliente`, `tokendispositivo`, `sueldomensual`, `auxtransportemensual`, `clasificacion`, `instagram`, `licenciaconduccion`, `nombrereferencia1`, `nombrereferencia2`, `telefonoreferencia1`, `telefonoreferencia2`, `parentescorefererencia2`, `parentesco`, `parentescorefererencia1`, `EDS`, `comensalescliente`, `idtelegram`, `membrecia_hasta`, `idpadre2`, `banco`, `tipodecuenta`, `cuentabancaria`, `urlcedulacliente`, `urlrutcliente`, `urlcamaracliente`, `fecha_expedicion`, `datosvalidados`, `ultimavalidacion`, `cuentainscrita`, `fechaactualizacionrut`, `direccion2`, `direccion3`, `identificadortv`, `origencliente`, `aceptacondiciones`, `fechaaceptacondiciones`, `HTTP_HOST`, `porcentaje_comision_enventa`, `codigomasser`, `rutacualizado`, `tokenfirebase`, `origen_cliente`, `proximallamada`, `idpadre`, `campovalor_cliente`, `responsable`, `aplicaretencion`, `puedehacerpedido`, `clientes_bloqueados`) VALUES (1,'SYSTEM',NULL,NULL,NULL,'',2,'','','2006-06-11','','2017-12-20 22:34:05','Pereira','','$1$PeWCIkk7$JT1Lk8Y7F3vAkCnFT6gho/','ADMINISTRADOR','',NULL,0,'MASCULINO','CC',0,2,1,'NO',0,39000,NULL,NULL,1,1,'','2',8,0,0,0,NULL,NULL,'66001','66','0',NULL,NULL,NULL,0,'3',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','rp0kmr2hqb0i947d5d3g05ljhk',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO','','CON',NULL,0,'valordeventa',NULL,0,1,NULL),(2,'SOFTWARE',NULL,NULL,NULL,'',2,'','','2050-12-12','','2021-12-16 07:59:15','J','JKLK','$1$Dnms6kqF$2qo7IA/GsVVspl3kfeDD3/','ADMINISTRADOR',NULL,'',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,'2',0,0,0,0,NULL,NULL,'L','L','','','','',0,'CC','',NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','a78a1730c46d6f379f8d320230346578',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO','','CON',NULL,0,'valordeventa',NULL,0,1,NULL),(3,'CONSUMIDOR FINAL',NULL,NULL,NULL,'',2,'222222222222','',NULL,'','2025-10-30 17:26:08','','RISARALDA',NULL,'CLIENTE','','',0,'MASCULINO','CC',0,3,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(4,'VENTA DIRECTA',NULL,NULL,NULL,'',2,'VENTADIRECTA','',NULL,'','2025-10-30 17:26:08','','RISARALDA',NULL,'CLIENTE','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(5,'Robier valencia',NULL,NULL,NULL,'',2,'101336357788','',NULL,'','2025-10-30 17:41:28','','RISARALDA','20K7i8qughUkA','ADMINISTRADOR','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','ebpq9h2s3b86v3g18garn5c0r9',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(6,'ISABELLA ESCOBAR CAJERA',NULL,NULL,NULL,'',2,'1088335208','','1996-05-08','','2025-11-01 08:20:26','','RISARALDA','18/D3yPTj6CUk','ADMINISTRADOR','','',0,'MASCULINO','CC',0,2,1,'SI',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','plu1mhrth5f44rceumco6t5i58',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(7,'MARIA JOSE CAJERA',NULL,NULL,NULL,'',2,'1192730463','',NULL,'','2025-11-06 19:42:23','','RISARALDA','16oizVcJhjsgQ','CAJERA','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','a8v8ngsnokk9qtihm4tp9c4r0v',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(8,'ANGIE LORENA CAJERA',NULL,NULL,NULL,'',2,'1004994143','',NULL,'','2025-11-06 19:46:58','','RISARALDA','17U9vFy0GBVho','CAJERA','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza','b0eb1dq1teeocabit07d46p1m7',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(9,'ANGIE LORENA MESERA',NULL,NULL,NULL,'',2,'10049941433','',NULL,'','2025-11-06 19:48:11','','RISARALDA','13J8Qbm2fpIfA','MESERA','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(10,'MARÍA JOSÉ MESERA',NULL,NULL,NULL,'',2,'11927304633','',NULL,'','2025-11-08 11:00:15','','RISARALDA','14A8IxwQ/Nabo','CLIENTE','','',0,'MASCULINO','CC',0,2,6,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(11,'MARIO CAJERO',NULL,NULL,NULL,'',2,'','',NULL,'','2025-11-08 11:00:42','','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,6,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(12,'ISABELLA ESCOBAR MESERA',NULL,NULL,NULL,'',2,'10883352088','',NULL,'','2025-11-18 18:40:33','','RISARALDA','13oHFhUn1gmtM','CLIENTE','','',0,'MASCULINO','CC',0,2,6,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL),(13,'ISABELLA REPOSTERIA',NULL,NULL,NULL,'',2,'','',NULL,'','2025-11-18 18:42:14','','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,6,'SI',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,NULL,0,'CC',NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'extremabelleza',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,0,0,NULL,NULL,0,0,'CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'CLIENTES',0,NULL,_binary '\0',0,_binary '\0','NO',NULL,'CON',NULL,0,'valordeventa',NULL,0,1,NULL);

--
-- Table structure for table `cocina_pedidos`
--

CREATE TABLE `cocina_pedidos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idmesa` int NOT NULL,
  `idcliente` int NOT NULL,
  `idarticulo` int NOT NULL,
  `cantidad` decimal(10,2) NOT NULL,
  `valorunitario` decimal(10,2) NOT NULL,
  `descuento` decimal(10,2) DEFAULT '0.00',
  `valortotal` decimal(10,2) NOT NULL,
  `observaciones` text COLLATE utf8mb4_unicode_ci,
  `fechacreacion` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `despachado` tinyint(1) DEFAULT '0',
  `PrecuentaCallcenter` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_mesa_despachado` (`idmesa`,`despachado`),
  KEY `idx_fechacreacion` (`fechacreacion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cocina_pedidos`
--


--
-- Table structure for table `colores`
--

CREATE TABLE `colores` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `color` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `color` (`color`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `colores`
--

INSERT INTO `colores` (`id`, `color`) VALUES (1,'BLANCO CLARO'),(2,'BLANCO VERDE'),(3,'BLANCO SAL'),(4,'BLANCO'),(5,'SUPER BLANCO '),(6,'BLANCO PERLADO'),(7,'BLANCO MAHLER'),(8,'BLANCO LECHE'),(9,'BLANCO  PERLADO'),(10,'BLANCO NEVADA BICAPA'),(11,'VERDE BLANCO'),(12,'SUPER BLANCO 2'),(13,'VERDE'),(14,'BLANCO NEVADO'),(15,'BLANCO BRILLANTE'),(16,'BLANCO PURO'),(17,'BLANCO CRISTAL'),(18,'BLANCO NEVADO BICAPA'),(19,'BLANCO CERAMICA'),(20,'BLANCO CANDY'),(21,'BLANCO PLATA'),(22,'BLANCO CHERY'),(23,'BLANCO  CERAMICA'),(24,'BLANCO LUNA'),(25,'BLANCO OLIMPICO'),(26,'BLANCO ARTICA'),(27,'BLANCO TITANIO'),(28,'BLANCO GLACIAL'),(29,'BLANCO  ARTICA'),(30,'BLANCO VAINILLA'),(31,'PENDIENTE'),(32,'BLANCO ARTICO'),(33,NULL);

--
-- Table structure for table `componentesarticulos`
--

CREATE TABLE `componentesarticulos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `idinsumo` bigint unsigned NOT NULL,
  `cantidad` double NOT NULL DEFAULT '1',
  `cc` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `tipo` varchar(12) DEFAULT NULL,
  `idpaparapi` int DEFAULT '0',
  `valor` double DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `PRECIOIVA` int DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idinsumo` (`idinsumo`),
  KEY `idarticulo` (`idarticulo`),
  CONSTRAINT `componentesarticulos_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `componentesarticulos_ibfk_3` FOREIGN KEY (`idinsumo`) REFERENCES `articulos` (`id`),
  CONSTRAINT `componentesarticulos_ibfk_4` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `componentesarticulos`
--


--
-- Table structure for table `compras`
--

CREATE TABLE `compras` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cantidad` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `idproveedor` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idmayor` bigint unsigned NOT NULL,
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double DEFAULT '0',
  `afectacaja` int NOT NULL DEFAULT '1',
  `iva` double NOT NULL DEFAULT '0',
  `idunidaddemedida` bigint unsigned NOT NULL,
  `valorgramo` double NOT NULL DEFAULT '0',
  `factor` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `nd` int DEFAULT '0',
  `compras` int DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  `tipodeiva` varchar(12) DEFAULT NULL,
  `descuento` double DEFAULT '0',
  `porcentajedescuento` double DEFAULT '0',
  `nombreimpuesto` varchar(3) DEFAULT 'IVA',
  `imei` varchar(50) DEFAULT NULL,
  `fechavencecompra` date DEFAULT NULL,
  `descripcionencompra` varchar(100) DEFAULT NULL,
  `ibua` int DEFAULT '0',
  `advalorem` int DEFAULT '0',
  `fletecompra` double DEFAULT '0',
  `proximocostomedio` double DEFAULT '0',
  `p_descuentosinfacturar` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idproveedor` (`idproveedor`),
  KEY `idmayor` (`idmayor`),
  KEY `idunidaddemedida` (`idunidaddemedida`),
  KEY `cc` (`cc`),
  KEY `idz` (`idz`),
  KEY `idusuario` (`idusuario`),
  CONSTRAINT `compras_ibfk_4` FOREIGN KEY (`idmayor`) REFERENCES `mayorescompras` (`id`),
  CONSTRAINT `compras_ibfk_6` FOREIGN KEY (`idz`) REFERENCES `z` (`id`),
  CONSTRAINT `compras_ibfk_7` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `compras`
--

INSERT INTO `compras` (`id`, `idarticulo`, `fecha`, `cantidad`, `valortotal`, `valorunitario`, `idproveedor`, `fechacreacion`, `idmayor`, `porcentajeiva`, `base`, `afectacaja`, `iva`, `idunidaddemedida`, `valorgramo`, `factor`, `cc`, `idz`, `idusuario`, `idcaja`, `nd`, `compras`, `pv`, `tipodeiva`, `descuento`, `porcentajedescuento`, `nombreimpuesto`, `imei`, `fechavencecompra`, `descripcionencompra`, `ibua`, `advalorem`, `fletecompra`, `proximocostomedio`, `p_descuentosinfacturar`) VALUES (1,3,'2025-11-18 19:48:08',8,72000,9000,13,'2025-11-18 19:48:08',4,0,72000,1,0,1,9000,1,0,1,6,1,0,1,'distrito','INCLUIDO',0,0,'IVA','','0000-00-00','Porcion de Chocolate',0,0,0,9000,0),(2,8,'2025-11-18 19:49:00',3,27000,9000,13,'2025-11-18 19:49:00',4,0,27000,1,0,1,9000,1,0,1,6,1,0,1,'distrito','INCLUIDO',0,0,'IVA','','0000-00-00','Ferrero',0,0,0,9000,0),(3,10,'2025-11-18 19:49:39',1,8500,8500,13,'2025-11-18 19:49:39',4,0,8500,1,0,1,8500,1,0,1,6,1,0,1,'distrito','INCLUIDO',0,0,'IVA','','0000-00-00','Chocolate',0,0,0,8500,0),(4,50,'2025-11-18 19:50:42',2,18000,9000,13,'2025-11-18 19:50:42',4,0,18000,1,0,1,9000,1,0,1,6,1,0,1,'distrito','INCLUIDO',0,0,'IVA','','0000-00-00','Chocomasmelo',0,0,0,9000,0);

--
-- Table structure for table `comprasauxiliar`
--

CREATE TABLE `comprasauxiliar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cantidad` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `idproveedor` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idmayor` bigint unsigned NOT NULL,
  `porcentajeiva` double NOT NULL DEFAULT '0',
  `base` double DEFAULT '0',
  `iva` double NOT NULL DEFAULT '0',
  `idunidaddemedida` bigint unsigned NOT NULL,
  `valorgramo` double NOT NULL DEFAULT '0',
  `factor` double NOT NULL DEFAULT '0',
  `cc` bigint unsigned NOT NULL,
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  `descuento` double DEFAULT '0',
  `porcentajedescuento` double DEFAULT '0',
  `tipodeiva` varchar(12) DEFAULT NULL,
  `nombreimpuesto` varchar(3) DEFAULT 'IVA',
  `imei` varchar(50) DEFAULT NULL,
  `fechavencecompra` date DEFAULT NULL,
  `ibua` int DEFAULT '0',
  `advalorem` int DEFAULT '0',
  `costomedioaux` double DEFAULT '0',
  `fleteaux` double DEFAULT '0',
  `proximocostomedio` double DEFAULT '0',
  `p_descuentosinfacturar` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `comprasauxiliar`
--

INSERT INTO `comprasauxiliar` (`id`, `idarticulo`, `fecha`, `cantidad`, `valortotal`, `valorunitario`, `idproveedor`, `fechacreacion`, `idmayor`, `porcentajeiva`, `base`, `iva`, `idunidaddemedida`, `valorgramo`, `factor`, `cc`, `idz`, `idusuario`, `idcaja`, `pv`, `descuento`, `porcentajedescuento`, `tipodeiva`, `nombreimpuesto`, `imei`, `fechavencecompra`, `ibua`, `advalorem`, `costomedioaux`, `fleteaux`, `proximocostomedio`, `p_descuentosinfacturar`) VALUES (1,34,'2025-11-18 14:13:45',10,10000,1000,6,'2025-11-18 14:13:45',1,0,10000,0,1,1000,1,0,1,6,1,'distrito',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,1000,0),(2,2,'2025-11-18 19:47:42',11,99000,9000,13,'2025-11-18 19:47:42',3,0,99000,0,1,9000,1,0,1,6,1,'distrito',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,9000,0);

--
-- Table structure for table `comprobantesdenomina`
--

CREATE TABLE `comprobantesdenomina` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuario` bigint unsigned NOT NULL,
  `desde` date DEFAULT NULL,
  `hasta` date DEFAULT NULL,
  `idcliente` bigint unsigned NOT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `nombre` varchar(150) DEFAULT NULL,
  `afp` varchar(150) DEFAULT NULL,
  `salario` int NOT NULL DEFAULT '0',
  `consecutivo` int DEFAULT '0',
  `comisiones` int DEFAULT '0',
  `salud` int DEFAULT '0',
  `transporte` int DEFAULT '0',
  `pension` int DEFAULT '0',
  `mediodepago` varchar(25) DEFAULT 'EFECTIVO',
  `afectacaja` int DEFAULT '0',
  `idz` int DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `comprobantesdenomina_ibfk_2` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`),
  CONSTRAINT `comprobantesdenomina_ibfk_3` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comprobantesdenomina`
--


--
-- Table structure for table `conceptosgastos`
--

CREATE TABLE `conceptosgastos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `concepto` varchar(200) DEFAULT NULL,
  `cc` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `conceptosgastos`
--

INSERT INTO `conceptosgastos` (`id`, `concepto`, `cc`, `pv`) VALUES (13,'ARRENDAMIENTO',1,'distrito'),(14,'IMPREVISTOS',1,'distrito');

--
-- Table structure for table `configuracion`
--

CREATE TABLE `configuracion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clave` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `valor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `descripcion` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `configuracion`
--

INSERT INTO `configuracion` (`id`, `clave`, `valor`, `descripcion`) VALUES (11,'Ajustes de inventario','Hay mas unidades en el inventario físico',''),(12,'Ajustes de inventario','Hay menos en el inventario físico',''),(13,'Ajustes de inventario','Se le da de baja por descomposición',''),(14,'Ajustes de inventario','Se le da de baja por mala presentación',''),(15,'Ajustes de inventario','Sale como degustación',''),(16,'Ajustes de inventario','Sale como promoción',''),(17,'Ajustes de inventario','Descontado para cocina',''),(18,'Edición en regularizaciones','Modificando la cantidad','Modificando la cantidad/Agregando la cantidad'),(19,'Fecha para guardar ventas a la madrugada','Fecha real','<ul><li>Fecha real</li><li>Fecha del turno actual</li></ul>'),(20,'Puede repetir celular en el callcenter','Si','<ul><li>Si</li><li>No</li></ul>'),(21,'Tipo de impresion para stickers de articulos v1','QR','<ul><li>BARCODE</li><li>QR</li></ul>');

--
-- Table structure for table `configuracion_incrementos`
--

CREATE TABLE `configuracion_incrementos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idseccion` int NOT NULL,
  `base_calculo` enum('ultimocoste','valordeventatiendas') NOT NULL DEFAULT 'ultimocoste',
  `incremento_valordeventa` decimal(10,2) NOT NULL DEFAULT '15.00',
  `incremento_valordistribuidor` decimal(10,2) NOT NULL DEFAULT '12.00',
  `incremento_valordeventatiendas` decimal(10,2) NOT NULL DEFAULT '10.00',
  `incremento_vrventapublico` decimal(10,2) NOT NULL DEFAULT '40.00',
  `incremento_valortiendavirtual` decimal(10,2) NOT NULL DEFAULT '15.00',
  `redondeo` int NOT NULL DEFAULT '50',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `fechacreacion` datetime NOT NULL,
  `idusuario` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idseccion` (`idseccion`),
  KEY `activo` (`activo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `configuracion_incrementos`
--


--
-- Table structure for table `configuracionshopify`
--

CREATE TABLE `configuracionshopify` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `COD_SATELITE` varchar(25) DEFAULT 'extremabelleza',
  `endpoint1` varchar(200) DEFAULT NULL,
  `endpoint2` varchar(200) DEFAULT NULL,
  `audience` varchar(100) DEFAULT NULL,
  `token1` varchar(200) DEFAULT NULL,
  `token2` varchar(200) DEFAULT NULL,
  `urltoken` varchar(100) DEFAULT NULL,
  `urlmenu` varchar(200) DEFAULT NULL,
  `storeId` varchar(50) NOT NULL,
  `urlactivaciones` varchar(200) DEFAULT NULL,
  `taken` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `configuracionshopify`
--


--
-- Table structure for table `configuraciontirilla`
--

CREATE TABLE `configuraciontirilla` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fuentemodificadorescomanda` int DEFAULT '12',
  `fuentelineascomanda` int DEFAULT '12',
  `COD_SATELITE` varchar(50) DEFAULT NULL,
  `user` varchar(200) DEFAULT NULL,
  `fuentedatosempresa` int DEFAULT '0',
  `fuentetitulo` int DEFAULT '0',
  `bdcontroldelcliente` varchar(300) DEFAULT NULL,
  `userbdcontroldelcliente` varchar(50) DEFAULT NULL,
  `quienrecibeelpedido` varchar(50) DEFAULT NULL,
  `dominiodelcliente` varchar(500) DEFAULT NULL COMMENT 'En este campo se buscan los archivos para devolver la configuración de la tirilla y los datos que se eimprimen',
  `rutaquehayparaimprimir` varchar(50) DEFAULT NULL,
  `master` varchar(200) DEFAULT NULL,
  `rutaborrarfactura` varchar(200) DEFAULT NULL,
  `masterparasubirdatosdeinformes` varchar(200) DEFAULT NULL,
  `bdparasubirdatosdeinformes` varchar(50) DEFAULT NULL,
  `tabladondeseeejecutaelprocedimiento` varchar(50) DEFAULT 'tabladondeseeejecutaelprocedimiento',
  `tamanopapel` int NOT NULL DEFAULT '1',
  `fuenteunocomanda` int NOT NULL DEFAULT '12',
  `cantidadletrasunocomanda` int NOT NULL DEFAULT '20',
  `fuentedoscomanda` int NOT NULL DEFAULT '12',
  `cantidadletrasdoscomanda` int NOT NULL DEFAULT '20',
  `fuentetrescomanda` int NOT NULL DEFAULT '10',
  `cantidadletrastrescomanda` int NOT NULL DEFAULT '10',
  `fuenteunofactura` int NOT NULL DEFAULT '12',
  `cantidadletrasunofactura` int NOT NULL DEFAULT '20',
  `fuentedosfactura` int NOT NULL DEFAULT '12',
  `cantidadletrasdosfactura` int NOT NULL DEFAULT '20',
  `fuentetresfactura` int NOT NULL DEFAULT '10',
  `cantidadletrastresfactura` int NOT NULL DEFAULT '10',
  `alergenos` int NOT NULL DEFAULT '0',
  `imprimir` int NOT NULL DEFAULT '1',
  `facturadeconfirmacion` int NOT NULL DEFAULT '0',
  `campoparaelconsecutivo` varchar(15) NOT NULL DEFAULT 'pendiente',
  `tipotirillafactura` varchar(4) DEFAULT 'pdf',
  `formatofechasistema` varchar(10) NOT NULL DEFAULT 'YYYY-MM-dd' COMMENT 'Para integracion, se refiere al idioma del sistema operativo donde corre el programa, sirve para arreglar los insert que tienen fechas que no ingresan en sql server',
  `lineaimpuestos` varchar(20) NOT NULL DEFAULT 'pendiente',
  `TIPOIVAPORDEFECTO` double NOT NULL DEFAULT '0' COMMENT 'Cuando lineaimpuestos es cero se utiliza este codigo para calcular el porcentaje del iva en la columna tipoiva de tiquetslin',
  `codigoenlace` varchar(1) NOT NULL DEFAULT '5',
  `titulotirilla` varchar(100) DEFAULT NULL,
  `nombreimpresora` varchar(100) DEFAULT NULL,
  `codalmacen` varchar(5) DEFAULT NULL,
  `codalmacenfapster` varchar(5) NOT NULL DEFAULT '7' COMMENT '(Integracion) Es el cod que se envía a fapster en la tabla pendientes de dbotaxml en la columna codalmacen ',
  `pagoepayco` int NOT NULL DEFAULT '0',
  `pagodatafono` int DEFAULT '0',
  `pagoqr` int NOT NULL DEFAULT '0',
  `pagoefectivo` int NOT NULL DEFAULT '0',
  `sizetextomediana` int NOT NULL DEFAULT '12',
  `sizetextomediano` int NOT NULL DEFAULT '12',
  `sizelineascomanda` int NOT NULL DEFAULT '12',
  `sizetitulo` int DEFAULT '12',
  `sizetextopequeno` int NOT NULL DEFAULT '12',
  `maxletrasencomanda` int NOT NULL DEFAULT '12',
  `maxletrasenfactura` int NOT NULL DEFAULT '30',
  `bd` varchar(50) DEFAULT NULL,
  `serie` varchar(5) DEFAULT NULL,
  `caja` int NOT NULL DEFAULT '1' COMMENT 'Valor fijo para tiquetscab y remtrasacciones',
  `serieresolucion` varchar(50) DEFAULT NULL,
  `fo` int NOT NULL DEFAULT '0',
  `n` varchar(1) NOT NULL DEFAULT 'B',
  `terminal` varchar(50) DEFAULT NULL,
  `seriedelequipo` varchar(50) DEFAULT NULL,
  `host` varchar(120) NOT NULL DEFAULT 'host',
  `regimen` varchar(50) DEFAULT NULL,
  `comentariotirilla` varchar(1200) DEFAULT NULL,
  `observacionalpie` varchar(500) DEFAULT '.' COMMENT 'Se utiliza para poner el texto sobre el destino de la propina, solo se usa en impresión automática',
  `email` varchar(120) DEFAULT NULL,
  `hasta` int DEFAULT NULL,
  `desde` int DEFAULT NULL,
  `fechainicioresolucion` varchar(20) DEFAULT NULL,
  `resolucioncontrol` varchar(20) DEFAULT NULL,
  `nit` varchar(20) DEFAULT NULL,
  `telefono` varchar(100) DEFAULT NULL,
  `subtitulo` varchar(100) DEFAULT NULL,
  `direccion` varchar(100) DEFAULT NULL,
  `razonsocial` varchar(100) DEFAULT NULL,
  `razonsocialcomanda` varchar(100) DEFAULT NULL,
  `numfacturaescero` int NOT NULL DEFAULT '0',
  `seimprimrecomandaconlafactura` int NOT NULL DEFAULT '1',
  `direccionparapush` text COMMENT 'Esta dirección se utiliza para enviar notificaciones al computador del cliente cuando el java se desconecta',
  `direccionservidorqueescucha` varchar(50) DEFAULT NULL,
  `tabla` varchar(25) DEFAULT NULL COMMENT 'Este es el nombre de la tabla donde se guardan las facturas de pendientes por imprimir',
  `imprimirfacturadoble` int NOT NULL DEFAULT '0',
  `fuentelineasfactura` int DEFAULT '14',
  `imprimirprecuentaconservicio` int NOT NULL DEFAULT '1' COMMENT '1 para que la precuenta imprima con la propina, 0 para que no lo haga',
  `pv` varchar(25) DEFAULT NULL,
  `fuentetitulop` int DEFAULT '12',
  `fuentedatosempresap` int DEFAULT '12',
  `fuentelineascomandap` int DEFAULT '12',
  `fuentemodificadorescomandap` int DEFAULT '12',
  `fuentetotalesp` int DEFAULT '16',
  `fuentehoracomanda` int DEFAULT '12',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `COD_SATELITE` (`COD_SATELITE`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `configuraciontirilla`
--

INSERT INTO `configuraciontirilla` (`id`, `fuentemodificadorescomanda`, `fuentelineascomanda`, `COD_SATELITE`, `user`, `fuentedatosempresa`, `fuentetitulo`, `bdcontroldelcliente`, `userbdcontroldelcliente`, `quienrecibeelpedido`, `dominiodelcliente`, `rutaquehayparaimprimir`, `master`, `rutaborrarfactura`, `masterparasubirdatosdeinformes`, `bdparasubirdatosdeinformes`, `tabladondeseeejecutaelprocedimiento`, `tamanopapel`, `fuenteunocomanda`, `cantidadletrasunocomanda`, `fuentedoscomanda`, `cantidadletrasdoscomanda`, `fuentetrescomanda`, `cantidadletrastrescomanda`, `fuenteunofactura`, `cantidadletrasunofactura`, `fuentedosfactura`, `cantidadletrasdosfactura`, `fuentetresfactura`, `cantidadletrastresfactura`, `alergenos`, `imprimir`, `facturadeconfirmacion`, `campoparaelconsecutivo`, `tipotirillafactura`, `formatofechasistema`, `lineaimpuestos`, `TIPOIVAPORDEFECTO`, `codigoenlace`, `titulotirilla`, `nombreimpresora`, `codalmacen`, `codalmacenfapster`, `pagoepayco`, `pagodatafono`, `pagoqr`, `pagoefectivo`, `sizetextomediana`, `sizetextomediano`, `sizelineascomanda`, `sizetitulo`, `sizetextopequeno`, `maxletrasencomanda`, `maxletrasenfactura`, `bd`, `serie`, `caja`, `serieresolucion`, `fo`, `n`, `terminal`, `seriedelequipo`, `host`, `regimen`, `comentariotirilla`, `observacionalpie`, `email`, `hasta`, `desde`, `fechainicioresolucion`, `resolucioncontrol`, `nit`, `telefono`, `subtitulo`, `direccion`, `razonsocial`, `razonsocialcomanda`, `numfacturaescero`, `seimprimrecomandaconlafactura`, `direccionparapush`, `direccionservidorqueescucha`, `tabla`, `imprimirfacturadoble`, `fuentelineasfactura`, `imprimirprecuentaconservicio`, `pv`, `fuentetitulop`, `fuentedatosempresap`, `fuentelineascomandap`, `fuentemodificadorescomandap`, `fuentetotalesp`, `fuentehoracomanda`) VALUES (1,16,16,'SALOME3','',16,14,' ',' ','.','https://salome3.controllocal.co','quehaypaimprimir.php','no','borrarfactura.php','no','no','no',200,12,25,12,25,10,10,10,34,8,34,9,32,0,1,0,'pendiente','pdf','YYYY-MM-dd','pendiente',0,'5','FACTURA','SAT 15TUS','10','7',0,0,0,0,12,12,12,12,12,12,30,'no','no',1,'no',0,'B','NO','NO RESPONSABLES DE IVA','localhost','         Regimen Ordinario','Gracias por su compra','.','0',2000,1,'2020-03-10','2020-03-10','9930070-9','3206664955','Casasviejas','Calle 6 # 6-03','Todo Arepas Salome 3','Todo Arepas Salome 3',0,0,NULL,'https://salome3.controllocal.co','.',0,14,1,NULL,12,12,12,12,16,12);

--
-- Table structure for table `consecutivos`
--

CREATE TABLE `consecutivos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` bigint NOT NULL DEFAULT '1',
  `cc` bigint unsigned NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tipo` varchar(50) NOT NULL DEFAULT 'VENTAS',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `consecutivos`
--

INSERT INTO `consecutivos` (`id`, `consecutivo`, `cc`, `fechacreacion`, `tipo`, `idusuario`, `pv`) VALUES (1,17,1,'2020-12-24 19:28:24','VENTAS',1,'distrito'),(2,8911,2,'2020-12-24 19:28:24','VENTAS',1,'distrito'),(3,934,1,'2020-12-24 19:28:24','Z',1,'distrito'),(4,822,2,'2020-12-24 19:28:24','Z',1,'distrito'),(5,10445,1,'2020-12-24 19:28:24','ABONOS',1,'distrito'),(6,10437,2,'2020-12-24 19:28:24','ABONOS',1,'distrito'),(7,1,1,'2020-12-24 19:28:24','NOTASCREDITO',1,'distrito'),(8,1,2,'2020-12-24 19:28:24','NOTASCREDITO',1,'distrito'),(9,1,1,'2020-12-24 19:28:24','NOTASDEBITO',1,'distrito'),(10,1,2,'2020-12-24 19:28:24','NOTASDEBITO',1,'distrito'),(11,1,1,'2020-12-24 19:28:24','CORTESIAS',1,'distrito'),(12,1,2,'2020-12-24 19:28:24','CORTESIAS',1,'distrito'),(13,16,1,'2020-12-24 19:28:24','COMPROBANTE DE EGRESOS',1,'distrito'),(14,654,2,'2020-12-24 19:28:24','COMPROBANTE DE EGRESOS',1,'distrito'),(15,2,1,'2020-12-24 19:28:24','SEPARADOS',1,'distrito'),(16,2,2,'2020-12-24 19:28:24','SEPARADOS',1,'distrito'),(17,1,1,'2020-12-24 19:28:24','PRODUCCION',1,'distrito'),(18,1,2,'2020-12-24 19:28:24','PRODUCCION',1,'distrito'),(19,1,2,'2020-12-24 19:28:24','SOLICITUDES',1,'distrito'),(20,1,2,'2020-12-24 19:28:24','SOLICITUDES',1,'distrito'),(21,10,1,'2021-04-04 18:41:42','BAJAS',1,'distrito'),(22,10,2,'2021-04-04 18:41:52','BAJAS',1,'distrito'),(23,1,2,'2021-04-07 16:39:42','FE',1,'distrito'),(24,1,2,'2021-04-07 16:39:45','NOTADEBITOFE',1,'distrito'),(25,1,2,'2021-04-07 16:39:46','NOTACREDITOFE',1,'distrito'),(26,1,2,'2021-04-07 16:39:48','CONTINGENCIAFE',1,'distrito'),(27,1,2,'2021-08-31 05:13:46','ABONOS PRESTAMOS',1,'distrito'),(28,1,2,'2021-09-02 21:51:07','ABONOS SEPARADOS',1,'distrito'),(29,1,2,'2021-10-09 01:38:12','RecepcionEquipo',1,'distrito'),(30,1,2,'2022-01-16 10:24:00','TRASLADOS',1,'distrito'),(31,1,2,'2022-01-24 12:25:47','PrecuentaCallcenter',1,'distrito'),(32,1,2,'2022-02-04 19:54:59','FICHA DE REGISTRO',1,'distrito'),(33,1,2,'2022-08-12 19:58:22','DOCUMENTO SOPORTE',1,'distrito'),(34,1,2,'2023-01-26 09:53:43','DEVOLUCIONES POR PAGAR',1,'distrito'),(35,1,2,'2024-06-01 17:53:09','POS ELECTRONICO',1,'distrito');

--
-- Table structure for table `contable`
--

CREATE TABLE `contable` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `idfactura` bigint unsigned NOT NULL,
  `idusuario` bigint unsigned NOT NULL,
  `idcliente` bigint unsigned NOT NULL,
  `cuenta` varchar(8) DEFAULT NULL,
  `debito` int DEFAULT '0',
  `credito` int DEFAULT '0',
  `descripcioncuenta` varchar(25) DEFAULT NULL,
  `tipo` varchar(25) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idfactura` (`idfactura`),
  KEY `contable_ibfk_3` (`idcliente`),
  CONSTRAINT `contable_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `contable_ibfk_2` FOREIGN KEY (`idfactura`) REFERENCES `facturas` (`id`),
  CONSTRAINT `contable_ibfk_3` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `contable`
--


--
-- Table structure for table `conteodiario`
--

CREATE TABLE `conteodiario` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `descripcion` varchar(100) NOT NULL DEFAULT '',
  `cantidad` double NOT NULL DEFAULT '0',
  `mes` int NOT NULL,
  `ano` int NOT NULL,
  `costomedio` double NOT NULL,
  `idusuario` bigint unsigned NOT NULL,
  `cc` bigint unsigned NOT NULL,
  `fechacracion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fisico` double NOT NULL DEFAULT '0',
  `idmayor` bigint unsigned NOT NULL DEFAULT '0',
  `fecha` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idmayor` (`idusuario`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idmayor_2` (`idmayor`),
  CONSTRAINT `conteodiario_ibfk_1` FOREIGN KEY (`idmayor`) REFERENCES `mayoresconteodiario` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `conteodiario`
--


--
-- Table structure for table `cotizaciondereceta`
--

CREATE TABLE `cotizaciondereceta` (
  `idarticulo` int NOT NULL,
  `cantidad` double NOT NULL,
  `idusuario` int NOT NULL,
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `revisado` int NOT NULL DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cotizaciondereceta`
--

INSERT INTO `cotizaciondereceta` (`idarticulo`, `cantidad`, `idusuario`, `id`, `revisado`, `pv`) VALUES (20,1,1,13,1,'distrito'),(98,2,2,14,1,'distrito');

--
-- Table structure for table `cotizaciones`
--

CREATE TABLE `cotizaciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idmayor` bigint unsigned NOT NULL,
  `consecutivo` int NOT NULL,
  `idarticulo` bigint unsigned NOT NULL,
  `cantidad` int NOT NULL DEFAULT '0',
  `valorunitario` double NOT NULL DEFAULT '0',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `valortotal` double NOT NULL DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idcliente` bigint unsigned NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `escortesiadeconvenio` int NOT NULL DEFAULT '0',
  `fechaabonado` datetime DEFAULT NULL,
  `descripcion` varchar(25) DEFAULT NULL,
  `porcentajedescuento` double DEFAULT '0',
  `porcentajeiva` decimal(5,2) DEFAULT '0.00',
  `base` double DEFAULT '0',
  `impuesto` double DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idmayor` (`idmayor`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cotizaciones`
--


--
-- Table structure for table `cuentadecobro`
--

CREATE TABLE `cuentadecobro` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consecutivo` int NOT NULL DEFAULT '0',
  `idusuario` bigint NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` float NOT NULL DEFAULT '0',
  `concepto` text,
  `idcliente` bigint NOT NULL,
  `tipodeventa` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cuentadecobro`
--


--
-- Table structure for table `cuentas`
--

CREATE TABLE `cuentas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tipo` varchar(25) DEFAULT NULL,
  `cuenta` int DEFAULT NULL,
  `Nombre` varchar(25) DEFAULT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `porcentaje` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `tipo` (`tipo`,`porcentaje`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cuentas`
--


--
-- Table structure for table `cupones`
--

CREATE TABLE `cupones` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `nombre` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cupones`
--


--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `departments_country_id_foreign` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `country_id`, `name`, `code`, `created_at`, `updated_at`) VALUES (1,46,'Amazonas','91','2024-06-21 01:05:20','2024-06-21 01:05:20'),(2,46,'Antioquia','05','2024-06-21 01:05:20','2024-06-21 01:05:20'),(3,46,'Arauca','81','2024-06-21 01:05:20','2024-06-21 01:05:20'),(4,46,'Atlántico','08','2024-06-21 01:05:20','2024-06-21 01:05:20'),(5,46,'Bogotá','11','2024-06-21 01:05:20','2024-06-21 01:05:20'),(6,46,'Bolívar','13','2024-06-21 01:05:20','2024-06-21 01:05:20'),(7,46,'Boyacá','15','2024-06-21 01:05:20','2024-06-21 01:05:20'),(8,46,'Caldas','17','2024-06-21 01:05:20','2024-06-21 01:05:20'),(9,46,'Caquetá','18','2024-06-21 01:05:20','2024-06-21 01:05:20'),(10,46,'Casanare','85','2024-06-21 01:05:20','2024-06-21 01:05:20'),(11,46,'Cauca','19','2024-06-21 01:05:20','2024-06-21 01:05:20'),(12,46,'Cesar','20','2024-06-21 01:05:20','2024-06-21 01:05:20'),(13,46,'Chocó','27','2024-06-21 01:05:20','2024-06-21 01:05:20'),(14,46,'Córdoba','23','2024-06-21 01:05:20','2024-06-21 01:05:20'),(15,46,'Cundinamarca','25','2024-06-21 01:05:20','2024-06-21 01:05:20'),(16,46,'Guainía','94','2024-06-21 01:05:20','2024-06-21 01:05:20'),(17,46,'Guaviare','95','2024-06-21 01:05:20','2024-06-21 01:05:20'),(18,46,'Huila','41','2024-06-21 01:05:20','2024-06-21 01:05:20'),(19,46,'La Guajira','44','2024-06-21 01:05:20','2024-06-21 01:05:20'),(20,46,'Magdalena','47','2024-06-21 01:05:20','2024-06-21 01:05:20'),(21,46,'Meta','50','2024-06-21 01:05:20','2024-06-21 01:05:20'),(22,46,'Nariño','52','2024-06-21 01:05:20','2024-06-21 01:05:20'),(23,46,'Norte de Santander','54','2024-06-21 01:05:20','2024-06-21 01:05:20'),(24,46,'Putumayo','86','2024-06-21 01:05:20','2024-06-21 01:05:20'),(25,46,'Quindío','63','2024-06-21 01:05:20','2024-06-21 01:05:20'),(26,46,'Risaralda','66','2024-06-21 01:05:20','2024-06-21 01:05:20'),(27,46,'San Andrés y Providencia','88','2024-06-21 01:05:20','2024-06-21 01:05:20'),(28,46,'Santander','68','2024-06-21 01:05:20','2024-06-21 01:05:20'),(29,46,'Sucre','70','2024-06-21 01:05:20','2024-06-21 01:05:20'),(30,46,'Tolima','73','2024-06-21 01:05:20','2024-06-21 01:05:20'),(31,46,'Valle del Cauca','76','2024-06-21 01:05:20','2024-06-21 01:05:20'),(32,46,'Vaupés','97','2024-06-21 01:05:20','2024-06-21 01:05:20'),(33,46,'Vichada','99','2024-06-21 01:05:20','2024-06-21 01:05:20');

--
-- Table structure for table `descuentosporgrupo`
--

CREATE TABLE `descuentosporgrupo` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idgrupo` bigint unsigned NOT NULL DEFAULT '1',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `porcentaje` int NOT NULL DEFAULT '0',
  `linea` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idgrupo` (`idgrupo`),
  KEY `cc` (`cc`),
  CONSTRAINT `descuentosporgrupo_ibfk_1` FOREIGN KEY (`idgrupo`) REFERENCES `gruposdepersonas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `descuentosporgrupo`
--


--
-- Table structure for table `descuentosprogramados`
--

CREATE TABLE `descuentosprogramados` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` bigint unsigned NOT NULL,
  `idcliente` bigint unsigned NOT NULL,
  `valor` int DEFAULT NULL,
  `mes` tinyint unsigned DEFAULT NULL,
  `ano` year DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idcliente_2` (`idcliente`,`mes`,`ano`),
  KEY `idusuario` (`idusuario`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB AUTO_INCREMENT=505 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `descuentosprogramados`
--


--
-- Table structure for table `devolucionesporpagar`
--

CREATE TABLE `devolucionesporpagar` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `idfactura` bigint unsigned NOT NULL,
  `consecutivo` int DEFAULT '0',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valor` double NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `pagado` bit(1) DEFAULT b'0',
  `fechapagado` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `idusuariopaga` bigint unsigned NOT NULL DEFAULT '1',
  `idcliente` bigint unsigned DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `idusuario` (`idusuario`),
  KEY `idfactura` (`idfactura`),
  CONSTRAINT `cons_devporpgagar_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `cons_devporpgagar_2` FOREIGN KEY (`idfactura`) REFERENCES `facturas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `devolucionesporpagar`
--


--
-- Table structure for table `direcciones`
--

CREATE TABLE `direcciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `direccion` varchar(300) DEFAULT NULL,
  `telefono` varchar(15) DEFAULT NULL,
  `idcliente` bigint unsigned NOT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `direccion` (`direccion`,`idcliente`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `direcciones_ibfk_1` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `direcciones`
--


--
-- Table structure for table `ediciones`
--

CREATE TABLE `ediciones` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tabla` varchar(300) DEFAULT NULL,
  `tarea` varchar(600) DEFAULT NULL,
  `usuario` varchar(300) DEFAULT NULL,
  `fechacreacion` varchar(300) DEFAULT NULL,
  `antes` varchar(300) DEFAULT NULL,
  `despues` varchar(300) DEFAULT NULL,
  `campo` varchar(150) DEFAULT NULL,
  `idtabla` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=377 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ediciones`
--

INSERT INTO `ediciones` (`id`, `tabla`, `tarea`, `usuario`, `fechacreacion`, `antes`, `despues`, `campo`, `idtabla`) VALUES (1,'clientes','editar id 5    ','SYSTEM   ','2025-10-30 17:42:06','','Robier valencia','primernombre',NULL),(2,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:42:18','','111111','cedula',NULL),(3,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:42:36','111111','10133635','cedula',NULL),(4,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:42:38','CLIENTE','ADMINISTRADOR','rol',NULL),(5,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:42:47','','111111','clave',NULL),(6,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:43:13','10133635','101336357788','cedula',NULL),(7,'clientes','editar id 5 Robier valencia   ','SYSTEM   ','2025-10-30 17:43:16','678ojYQwl0kMw','101336357788','clave',NULL),(8,'clientes','editar id 6    ','SYSTEM   ','2025-11-01 08:21:17','','ISABELLA ESCOBAR CORRALES','primernombre',NULL),(9,'clientes','editar id 6 ISABELLA ESCOBAR CORRALES   ','SYSTEM   ','2025-11-01 08:21:39','','1088335208','cedula',NULL),(10,'clientes','editar id 6 ISABELLA ESCOBAR CORRALES   ','SYSTEM   ','2025-11-01 08:21:42','','1088335208','clave',NULL),(11,'clientes','editar id 6 ISABELLA ESCOBAR CORRALES   ','SYSTEM   ','2025-11-01 08:21:47','CLIENTE','ADMINISTRADOR','rol',NULL),(12,'articulos','editar id 1 ','ISABELLA ESCOBAR CORRALES   ','2025-11-01 19:58:54','','HAR','referencia',1),(13,'articulos','Editar id 1 EN ESPERA','ISABELLA ESCOBAR CORRALES   ','2025-11-01 19:59:00',' ','HARINA','descripcionlarga',NULL),(14,'articulos','editar id 1 ','ISABELLA ESCOBAR CORRALES   ','2025-11-01 19:59:02','HAR','HARINA','referencia',1),(15,'clientes','editar id 6 ','SYSTEM   ','2025-11-06 19:41:31',NULL,'0001-05-08','fechadenacimiento',NULL),(16,'clientes','editar id 6 ','SYSTEM   ','2025-11-06 19:41:31','0001-05-08','0019-05-08','fechadenacimiento',NULL),(17,'clientes','editar id 6 ','SYSTEM   ','2025-11-06 19:41:33','0019-05-08','0199-05-08','fechadenacimiento',NULL),(18,'clientes','editar id 6 ','SYSTEM   ','2025-11-06 19:41:33','0199-05-08','1996-05-08','fechadenacimiento',NULL),(19,'clientes','editar id 7    ','SYSTEM   ','2025-11-06 19:43:05','','MARIA JOSE GARCIA V','primernombre',NULL),(20,'clientes','editar id 7 MARIA JOSE GARCIA V   ','SYSTEM   ','2025-11-06 19:43:42','','24555577','cedula',NULL),(21,'clientes','editar id 7 MARIA JOSE GARCIA V   ','SYSTEM   ','2025-11-06 19:43:45','CLIENTE','CAJERA','rol',NULL),(22,'clientes','editar id 7 MARIA JOSE GARCIA V   ','SYSTEM   ','2025-11-06 19:44:16','','24555577','clave',NULL),(23,'clientes','editar id 8    ','SYSTEM   ','2025-11-06 19:47:22','','ANGIE LORENA CAJERA','primernombre',NULL),(24,'clientes','editar id 8 ANGIE LORENA CAJERA   ','SYSTEM   ','2025-11-06 19:47:45','','1004994143','cedula',NULL),(25,'clientes','editar id 8 ANGIE LORENA CAJERA   ','SYSTEM   ','2025-11-06 19:47:49','','1004994143','clave',NULL),(26,'clientes','editar id 8 ANGIE LORENA CAJERA   ','SYSTEM   ','2025-11-06 19:47:56','CLIENTE','CAJERA','rol',NULL),(27,'clientes','editar id 9    ','SYSTEM   ','2025-11-06 19:48:23','','ANGIE LORENA MESERA','primernombre',NULL),(28,'clientes','editar id 9 ANGIE LORENA MESERA   ','SYSTEM   ','2025-11-06 19:48:58','','100499414399','cedula',NULL),(29,'roles','editar id 31 ','SYSTEM   ','2025-11-06 19:51:04','','MESERA','rol',NULL),(30,'clientes','editar id 9 ANGIE LORENA MESERA   ','SYSTEM   ','2025-11-06 19:52:40','CLIENTE','MESERA','rol',NULL),(31,'secciones','Editar: 1','SYSTEM   ','2025-11-06 20:05:12','','DESAYUNOS','seccion',NULL),(32,'secciones','Editar: 2','SYSTEM   ','2025-11-06 20:05:22','','TORTAS','seccion',NULL),(33,'secciones','Editar: 3','SYSTEM   ','2025-11-06 20:05:29','','GALLETAS','seccion',NULL),(34,'secciones','Editar: 4','SYSTEM   ','2025-11-06 20:05:37','','POSTRES','seccion',NULL),(35,'secciones','Editar: 5','SYSTEM   ','2025-11-06 20:05:52','','SNACKS','seccion',NULL),(36,'secciones','Editar: 6','SYSTEM   ','2025-11-06 20:06:08','','BEBIDAS FRIAS','seccion',NULL),(37,'secciones','Editar: 7','SYSTEM   ','2025-11-06 20:07:23','','BEBIDAS CALIENTES','seccion',NULL),(38,'secciones','Editar: 2','SYSTEM   ','2025-11-06 20:08:51','0','1','orden',NULL),(39,'secciones','Editar: 3','SYSTEM   ','2025-11-06 20:08:59','0','2','orden',NULL),(40,'secciones','Editar: 6','SYSTEM   ','2025-11-06 20:09:09','0','3','orden',NULL),(41,'secciones','Editar: 1','SYSTEM   ','2025-11-06 20:09:15','0','4','orden',NULL),(42,'secciones','Editar: 5','SYSTEM   ','2025-11-06 20:09:21','0','5','orden',NULL),(43,'secciones','Editar: 4','SYSTEM   ','2025-11-06 20:09:27','0','6','orden',NULL),(44,'secciones','Editar: 7','SYSTEM   ','2025-11-06 20:09:43','0','7','orden',NULL),(45,'secciones','Editar: 8','SYSTEM   ','2025-11-06 20:11:17','','ASEO','seccion',NULL),(46,'secciones','Editar: 8','SYSTEM   ','2025-11-06 20:11:18','1','0','sevende',NULL),(47,'secciones','Editar: 8','SYSTEM   ','2025-11-06 20:11:19','0','1','sevende',NULL),(48,'secciones','Editar: 8','SYSTEM   ','2025-11-06 20:11:19','1','0','sevende',NULL),(49,'articulos','editar id 1 ','SYSTEM   ','2025-11-06 20:19:14','HARINA','','referencia',1),(50,'articulos','editar id 1 ','SYSTEM   ','2025-11-06 20:19:14','','','referencia',1),(51,'articulos','Editar id 1 EN ESPERA','SYSTEM   ','2025-11-06 20:19:29','EN ESPERA','Pan','descripcion',NULL),(52,'articulos','Editar id 1 Pan','SYSTEM   ','2025-11-06 20:19:45','Pan','Pancakes con huevos y tocineta','descripcion',NULL),(53,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:19:53','HARINA','','descripcionlarga',NULL),(54,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:20:30','','Con Cafe y Jugo','descripcionlarga',NULL),(55,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:20:47','0','12000','valordeventa',NULL),(56,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:21:39','0','1','orden',NULL),(57,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:21:39','0','1','seproduce',NULL),(58,'articulos','Editar id 1 Pancakes con huevos y tocineta','SYSTEM   ','2025-11-06 20:22:03','0','1','idseccion',NULL),(59,'articulos','Editar id 2 ','SYSTEM   ','2025-11-06 20:25:44','','Porcion Red velvet','descripcion',NULL),(60,'articulos','Editar id 2 Porcion Red velvet','SYSTEM   ','2025-11-06 20:25:51','0','9000','valordeventa',NULL),(61,'articulos','Editar id 2 Porcion Red velvet','SYSTEM   ','2025-11-06 20:26:25','0','1','orden',NULL),(62,'articulos','Editar id 2 Porcion Red velvet','SYSTEM   ','2025-11-06 20:26:25','0','1','seproduce',NULL),(63,'articulos','Editar id 2 Porcion Red velvet','SYSTEM   ','2025-11-06 20:26:33','0','2','idseccion',NULL),(64,'articulos','Editar id 3 ','SYSTEM   ','2025-11-06 20:27:03','','Porcion de Chocolate','descripcion',NULL),(65,'articulos','Editar id 3 Porcion de Chocolate','SYSTEM   ','2025-11-06 20:27:08','0','9000','valordeventa',NULL),(66,'articulos','Editar id 3 Porcion de Chocolate','SYSTEM   ','2025-11-06 20:27:13','0','2','orden',NULL),(67,'articulos','Editar id 3 Porcion de Chocolate','SYSTEM   ','2025-11-06 20:27:14','0','1','seproduce',NULL),(68,'articulos','Editar id 3 Porcion de Chocolate','SYSTEM   ','2025-11-06 20:27:19','0','2','idseccion',NULL),(69,'ventasauxiliar','Modificar unidades 2','SYSTEM   ','2025-11-06 20:27:45','1','2','Porcion de Chocolate',NULL),(70,'clientes','editar id 7 MARIA JOSE GARCIA V   ','ISABELLA ESCOBAR CORRALES   ','2025-11-08 11:00:12','MARIA JOSE GARCIA V','MARIA JOSE CAJERA','primernombre',NULL),(71,'clientes','editar id 10    ','ISABELLA ESCOBAR CORRALES   ','2025-11-08 11:00:33','','MARÍA JOSÉ MESERA','primernombre',NULL),(72,'clientes','editar id 11    ','ISABELLA ESCOBAR CORRALES   ','2025-11-08 11:00:56','','MARIO CAJERO','primernombre',NULL),(73,'articulos','Editar id 14 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 03:58:56','','Porción zanahoria','descripcion',NULL),(74,'articulos','Editar id 14 Porción zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 03:59:07','0','7.500','valordeventa',NULL),(75,'articulos','Editar id 14 Porción zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 03:59:07','0','1','seproduce',NULL),(76,'articulos','Editar id 14 Porción zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 03:59:10','0','2','idseccion',NULL),(77,'articulos','Editar id 5 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:00:08','','Porción almojabana','descripcion',NULL),(78,'articulos','Editar id 5 Porción almojabana','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:00:15','0','9000','valordeventa',NULL),(79,'articulos','Editar id 5 Porción almojabana','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:00:16','0','1','seproduce',NULL),(80,'articulos','Editar id 5 Porción almojabana','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:00:19','0','2','idseccion',NULL),(81,'articulos','Editar id 14 Porción zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:00:41','Porción zanahoria','Porción Zanahoria','descripcion',NULL),(82,'articulos','Editar id 5 Porción almojabana','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:01:04','Porción almojabana','Porción Almojabana','descripcion',NULL),(83,'articulos','Editar id 6 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:01:20','','Porción Naranja y Amapola','descripcion',NULL),(84,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:01:23','0','1','seproduce',NULL),(85,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:01:26','0','2','idseccion',NULL),(86,'articulos','Editar id 13 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:02:28','','Macadamia','descripcion',NULL),(87,'articulos','Editar id 13 Macadamia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:02:35','0','8.500','valordeventa',NULL),(88,'articulos','Editar id 13 Macadamia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:02:36','0','1','seproduce',NULL),(89,'articulos','Editar id 13 Macadamia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:02:40','0','3','idseccion',NULL),(90,'articulos','Editar id 12 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:03','','Red Velvet','descripcion',NULL),(91,'articulos','Editar id 12 Red Velvet','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:07','0','8.500','valordeventa',NULL),(92,'articulos','Editar id 12 Red Velvet','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:08','0','1','seproduce',NULL),(93,'articulos','Editar id 12 Red Velvet','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:12','0','3','idseccion',NULL),(94,'articulos','Editar id 11 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:29','','Churro','descripcion',NULL),(95,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:33','0','8.500','valordeventa',NULL),(96,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:35','0','1','seproduce',NULL),(97,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:03:38','0','3','idseccion',NULL),(98,'articulos','Editar id 10 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:09','','Chocolate','descripcion',NULL),(99,'articulos','Editar id 10 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:14','0','8.500','valordeventa',NULL),(100,'articulos','Editar id 10 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:15','0','1','seproduce',NULL),(101,'articulos','Editar id 10 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:18','0','3','idseccion',NULL),(102,'articulos','Editar id 9 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:42','','Almendras','descripcion',NULL),(103,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:47','0','8.500','valordeventa',NULL),(104,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:48','0','1','seproduce',NULL),(105,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:04:51','0','3','idseccion',NULL),(106,'articulos','Editar id 8 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:05','','Ferrero','descripcion',NULL),(107,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:09','0','9.500','valordeventa',NULL),(108,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:10','0','1','seproduce',NULL),(109,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:16','0','3','idseccion',NULL),(110,'articulos','Editar id 7 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:34','','Milo','descripcion',NULL),(111,'articulos','Editar id 7 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:39','0','9.500','valordeventa',NULL),(112,'articulos','Editar id 7 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:05:40','0','1','seproduce',NULL),(113,'articulos','Editar id 4 EN ESPERA','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:06:41','EN ESPERA','Expreso','descripcion',NULL),(114,'articulos','Editar id 4 Expreso','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:06:46','0','3.500','valordeventa',NULL),(115,'articulos','Editar id 4 Expreso','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:06:47','0','1','seproduce',NULL),(116,'articulos','Editar id 4 Expreso','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:06:51','0','7','idseccion',NULL),(117,'articulos','Editar id 15 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:07:14','','Americano','descripcion',NULL),(118,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:07:19','0','3.500','valordeventa',NULL),(119,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:07:21','0','1','seproduce',NULL),(120,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:07:25','0','7','idseccion',NULL),(121,'articulos','Editar id 18 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:08:09','','Te chai en agua','descripcion',NULL),(122,'articulos','Editar id 18 Te chai en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:08:31','0','6.500','valordeventa',NULL),(123,'articulos','Editar id 18 Te chai en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:08:33','0','1','seproduce',NULL),(124,'articulos','Editar id 18 Te chai en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:08:37','0','7','idseccion',NULL),(125,'articulos','Editar id 17 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:08:57','','Te chai en leche','descripcion',NULL),(126,'articulos','Editar id 17 Te chai en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:02','0','7.500','valordeventa',NULL),(127,'articulos','Editar id 17 Te chai en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:03','0','1','seproduce',NULL),(128,'articulos','Editar id 17 Te chai en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:05','0','7','idseccion',NULL),(129,'articulos','Editar id 16 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:24','','Capuchino','descripcion',NULL),(130,'articulos','Editar id 16 Capuchino','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:36','0','7.000','valordeventa',NULL),(131,'articulos','Editar id 16 Capuchino','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:38','0','1','seproduce',NULL),(132,'articulos','Editar id 16 Capuchino','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:09:41','0','7','idseccion',NULL),(133,'articulos','Editar id 20 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:15','','Milo','descripcion',NULL),(134,'articulos','Editar id 20 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:22','0','7.500','valordeventa',NULL),(135,'articulos','Editar id 20 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:24','0','1','seproduce',NULL),(136,'articulos','Editar id 20 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:28','0','7','idseccion',NULL),(137,'articulos','Editar id 21 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:50','','Aromática','descripcion',NULL),(138,'articulos','Editar id 21 Aromática','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:54','0','1','seproduce',NULL),(139,'articulos','Editar id 21 Aromática','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:58','0','7','idseccion',NULL),(140,'articulos','Editar id 21 Aromática','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:10:59','1','','seproduce',NULL),(141,'articulos','Editar id 21 Aromática','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:01','0','1','seproduce',NULL),(142,'articulos','Editar id 19 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:27','','Chocolate','descripcion',NULL),(143,'articulos','Editar id 19 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:31','0','7.500','valordeventa',NULL),(144,'articulos','Editar id 19 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:37','Chocolate','Chocolate en agua','descripcion',NULL),(145,'articulos','Editar id 19 Chocolate en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:46','7.5','6.500','valordeventa',NULL),(146,'articulos','Editar id 19 Chocolate en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:46','0','1','seproduce',NULL),(147,'articulos','Editar id 19 Chocolate en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:11:49','0','7','idseccion',NULL),(148,'articulos','Editar id 23 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:12:30','','Chocolate en leche','descripcion',NULL),(149,'articulos','Editar id 23 Chocolate en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:12:35','0','7.500','valordeventa',NULL),(150,'articulos','Editar id 23 Chocolate en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:12:37','0','1','seproduce',NULL),(151,'articulos','Editar id 23 Chocolate en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:12:42','0','7','idseccion',NULL),(152,'articulos','Editar id 30 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:13:22','','Frape de café','descripcion',NULL),(153,'articulos','Editar id 30 Frape de café','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:13:36','0','8.500','valordeventa',NULL),(154,'articulos','Editar id 30 Frape de café','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:13:36','0','1','seproduce',NULL),(155,'articulos','Editar id 30 Frape de café','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:13:40','0','6','idseccion',NULL),(156,'articulos','Editar id 22 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:13:55','','Milo','descripcion',NULL),(157,'articulos','Editar id 22 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:02','0','8.000','valordeventa',NULL),(158,'articulos','Editar id 22 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:02','0','1','seproduce',NULL),(159,'articulos','Editar id 22 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:05','0','6','idseccion',NULL),(160,'articulos','Editar id 24 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:21','','Limonada de sandia','descripcion',NULL),(161,'articulos','Editar id 24 Limonada de sandia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:31','0','9.500','valordeventa',NULL),(162,'articulos','Editar id 24 Limonada de sandia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:33','0','1','seproduce',NULL),(163,'articulos','Editar id 24 Limonada de sandia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:14:37','0','6','idseccion',NULL),(164,'articulos','Editar id 29 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:02','','Limonada natural','descripcion',NULL),(165,'articulos','Editar id 29 Limonada natural','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:06','0','9.000','valordeventa',NULL),(166,'articulos','Editar id 29 Limonada natural','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:07','0','1','seproduce',NULL),(167,'articulos','Editar id 29 Limonada natural','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:11','0','6','idseccion',NULL),(168,'articulos','Editar id 28 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:37','','Limonada de cereza','descripcion',NULL),(169,'articulos','Editar id 28 Limonada de cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:42','0','9.500','valordeventa',NULL),(170,'articulos','Editar id 28 Limonada de cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:43','0','1','seproduce',NULL),(171,'articulos','Editar id 28 Limonada de cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:15:47','0','6','idseccion',NULL),(172,'articulos','Editar id 27 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:16:53','','Soda maracumango','descripcion',NULL),(173,'articulos','Editar id 27 Soda maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:17:00','0','11.000','valordeventa',NULL),(174,'articulos','Editar id 27 Soda maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:17:01','0','1','seproduce',NULL),(175,'articulos','Editar id 27 Soda maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:17:03','0','6','idseccion',NULL),(176,'secciones','Editar: 9','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:24:15','','Sodas saborizadas','seccion',NULL),(177,'secciones','Editar: 7','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:24:46','7','3','orden',NULL),(178,'secciones','Editar: 6','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:24:52','3','4','orden',NULL),(179,'secciones','Editar: 9','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:30','Sodas saborizadas','SODAS SABORIZADAS','seccion',NULL),(180,'secciones','Editar: 2','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:33','1','0','orden',NULL),(181,'secciones','Editar: 3','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:36','2','0','orden',NULL),(182,'secciones','Editar: 6','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:38','4','0','orden',NULL),(183,'secciones','Editar: 1','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:40','4','0','orden',NULL),(184,'secciones','Editar: 5','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:42','5','0','orden',NULL),(185,'secciones','Editar: 4','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:45','6','0','orden',NULL),(186,'secciones','Editar: 7','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:54','3','0','orden',NULL),(187,'secciones','Editar: 2','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:25:56','0','1','orden',NULL),(188,'secciones','Editar: 3','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:06','0','2','orden',NULL),(189,'secciones','Editar: 7','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:12','0','3','orden',NULL),(190,'secciones','Editar: 6','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:18','0','4','orden',NULL),(191,'secciones','Editar: 9','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:27','0','5','orden',NULL),(192,'secciones','Editar: 5','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:33','0','6','orden',NULL),(193,'secciones','Editar: 1','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:36','0','7','orden',NULL),(194,'secciones','Editar: 4','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:26:43','0','8','orden',NULL),(195,'articulos','Editar id 27 Soda maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:27:08','6','9','idseccion',NULL),(196,'articulos','Editar id 26 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:27:31','','Sandía cereza','descripcion',NULL),(197,'articulos','Editar id 26 Sandía cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:27:37','0','11.000','valordeventa',NULL),(198,'articulos','Editar id 26 Sandía cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:27:38','0','1','seproduce',NULL),(199,'articulos','Editar id 26 Sandía cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:27:43','0','9','idseccion',NULL),(200,'articulos','Editar id 27 Soda maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:00','Soda maracumango','Maracumango','descripcion',NULL),(201,'articulos','Editar id 25 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:13','','Frutos Rojos','descripcion',NULL),(202,'articulos','Editar id 25 Frutos Rojos','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:20','0','11.000','valordeventa',NULL),(203,'articulos','Editar id 25 Frutos Rojos','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:20','0','1','seproduce',NULL),(204,'articulos','Editar id 25 Frutos Rojos','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:22','0','9','idseccion',NULL),(205,'articulos','Editar id 31 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:33','','Lulo','descripcion',NULL),(206,'articulos','Editar id 31 Lulo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:39','0','11.000','valordeventa',NULL),(207,'articulos','Editar id 31 Lulo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:41','0','1','seproduce',NULL),(208,'articulos','Editar id 31 Lulo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:28:44','0','9','idseccion',NULL),(209,'articulos','Editar id 32 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:29:22','','Wrap pollo','descripcion',NULL),(210,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:30:19','','Tortilla, pollo deslechado, tocineta, aguacate, queso, lechuga y salsa. Acompañado de té y platanitos','descripcionlarga',NULL),(211,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:30:29','0','22.500','valordeventa',NULL),(212,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:30:30','0','1','seproduce',NULL),(213,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:30:33','0','5','idseccion',NULL),(214,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:31:32','22.5','22.500','valordeventa',NULL),(215,'ventasauxiliar','Modificar unidades','ISABELLA ESCOBAR CORRALES   ','2025-11-09 04:32:08','1','0','Wrap pollo',NULL),(216,'articulos','Editar id 34 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:30:33','','Botella de agua','descripcion',NULL),(217,'articulos','Editar id 34 Botella de agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:30:40','0','20000','valordeventa',NULL),(218,'articulos','Editar id 34 Botella de agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:30:43','0','1','secompra',NULL),(219,'articulos','Editar id 34 Botella de agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:30:48','0','6','idseccion',NULL),(220,'articulos','Editar id 33 EN ESPERA','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:31:33','EN ESPERA','Wrap desmechado','descripcion',NULL),(221,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:04',' ','Tortilla, carne desmechada, queso, aguacate, lechuga y salsa. Acomoañado de platanitos y té','descripcionlarga',NULL),(222,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:16','Tortilla, carne desmechada, queso, aguacate, lechuga y salsa. Acomoañado de platanitos y té','Tortilla, carne desmechada, queso, aguacate, lechuga y salsa. Acompañado de platanitos y té','descripcionlarga',NULL),(223,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:21','0','22.500','valordeventa',NULL),(224,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:23','0','1','seproduce',NULL),(225,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:26','0','5','idseccion',NULL),(226,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:32:35','22.5','','valordeventa',NULL),(227,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:33:26','22.5','','valordeventa',NULL),(228,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:33:43','0','','valordeventa',NULL),(229,'articulos','Editar id 27 Maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:34:08','11','11.000','valordeventa',NULL),(230,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:34:43','8.5','8500','valordeventa',NULL),(231,'articulos','Editar id 10 Chocolate','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:34:57','8.5','8500','valordeventa',NULL),(232,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:35:13','0','07500','valordeventa',NULL),(233,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:35:17','7500','7500','valordeventa',NULL),(234,'articulos','Editar id 14 Porción Zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:35:31','7.5','7500','valordeventa',NULL),(235,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:36:40','8.5','8500','valordeventa',NULL),(236,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CORRALES   ','2025-11-09 07:37:04','9.5','9500','valordeventa',NULL),(237,'articulos','Editar id 13 Macadamia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:00:43','8.5','8500','valordeventa',NULL),(238,'articulos','Editar id 12 Red Velvet','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:00:56','8.5','8500','valordeventa',NULL),(239,'articulos','Editar id 36 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:01:51','','Milo','descripcion',NULL),(240,'articulos','Editar id 36 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:01:54','0','9.500','valordeventa',NULL),(241,'articulos','Editar id 36 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:01:57','0','1','seproduce',NULL),(242,'articulos','Editar id 36 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:02:00','0','3','idseccion',NULL),(243,'articulos','Editar id 36 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:02:31','9.5','9500','valordeventa',NULL),(244,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:03:23','3.5','3500','valordeventa',NULL),(245,'articulos','Editar id 16 Capuchino','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:04:09','7','7000','valordeventa',NULL),(246,'articulos','Editar id 19 Chocolate en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:04:27','6.5','6500','valordeventa',NULL),(247,'articulos','Editar id 23 Chocolate en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:04:47','7.5','7500','valordeventa',NULL),(248,'articulos','Editar id 4 Expreso','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:05:01','3.5','3500','valordeventa',NULL),(249,'articulos','Editar id 20 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:05:13','7.5','7500','valordeventa',NULL),(250,'articulos','Editar id 18 Te chai en agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:05:22','6.5','6500','valordeventa',NULL),(251,'articulos','Editar id 17 Te chai en leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:05:35','7.5','7500','valordeventa',NULL),(252,'articulos','Editar id 34 Botella de agua','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:05:50','20000','2000','valordeventa',NULL),(253,'articulos','Editar id 30 Frape de café','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:06:02','8.5','8500','valordeventa',NULL),(254,'articulos','Editar id 28 Limonada de cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:06:17','9.5','10000','valordeventa',NULL),(255,'articulos','Editar id 24 Limonada de sandia','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:06:28','9.5','10000','valordeventa',NULL),(256,'articulos','Editar id 29 Limonada natural','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:06:41','9','9000','valordeventa',NULL),(257,'articulos','Editar id 22 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:06:52','8','8500','valordeventa',NULL),(258,'articulos','Editar id 25 Frutos Rojos','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:01','11','11000','valordeventa',NULL),(259,'articulos','Editar id 31 Lulo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:11','11','11000','valordeventa',NULL),(260,'articulos','Editar id 27 Maracumango','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:21','11','11000','valordeventa',NULL),(261,'articulos','Editar id 26 Sandía cereza','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:31','11','11000','valordeventa',NULL),(262,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:48','0','22500','valordeventa',NULL),(263,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:07:55','22500','21500','valordeventa',NULL),(264,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:07','0','21500','valordeventa',NULL),(265,'articulos','Editar id 1 Pancakes con huevos y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:18','Con Cafe y Jugo','Con Cafe o Jugo','descripcionlarga',NULL),(266,'articulos','Editar id 37 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:35','','Omelette con queso y tocineta','descripcion',NULL),(267,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:45','','Acompañado de aguacate y café o jugo','descripcionlarga',NULL),(268,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:50','0','14.000','valordeventa',NULL),(269,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:52','0','1','seproduce',NULL),(270,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:08:56','0','1','idseccion',NULL),(271,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:10:01','14','14000','valordeventa',NULL),(272,'articulos','Editar id 35 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:10:20','','Bowl melcochudo','descripcion',NULL),(273,'articulos','Editar id 35 Bowl melcochudo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:11:06','','Ensalada de lechuga, pollo, tocineta, queso Gouda, crutons y salsa cesar','descripcionlarga',NULL),(274,'articulos','Editar id 35 Bowl melcochudo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:11:12','0','23.000','valordeventa',NULL),(275,'articulos','Editar id 35 Bowl melcochudo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:11:14','0','1','seproduce',NULL),(276,'articulos','Editar id 35 Bowl melcochudo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:11:16','0','5','idseccion',NULL),(277,'articulos','Editar id 38 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:23:13','','Vaso de leche','descripcion',NULL),(278,'articulos','Editar id 38 Vaso de leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:23:22','0','3000','valordeventa',NULL),(279,'articulos','Editar id 38 Vaso de leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:23:26','0','1','secompra',NULL),(280,'articulos','Editar id 38 Vaso de leche','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:23:30','0','6','idseccion',NULL),(281,'articulos','Editar id 40 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:23:58','','Hit','descripcion',NULL),(282,'articulos','Editar id 40 Hit','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:05','0','3500','valordeventa',NULL),(283,'articulos','Editar id 40 Hit','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:08','0','1','secompra',NULL),(284,'articulos','Editar id 40 Hit','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:14','0','6','idseccion',NULL),(285,'articulos','Editar id 39 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:40','','Soda','descripcion',NULL),(286,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:44','0','4000','valordeventa',NULL),(287,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:46','0','1','seproduce',NULL),(288,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:47','0','1','secompra',NULL),(289,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:24:56','0','9','idseccion',NULL),(290,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:25:56','','Con sal y limón','descripcionlarga',NULL),(291,'articulos','Editar id 35 Bowl melcochudo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:05','23','23000','valordeventa',NULL),(292,'articulos','Editar id 42 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:29','','Cheesecake','descripcion',NULL),(293,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:33','','Frutos rojos','descripcionlarga',NULL),(294,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:38','0','12.000','valordeventa',NULL),(295,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:42','12','12000','valordeventa',NULL),(296,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:43','0','1','seproduce',NULL),(297,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:26:46','0','4','idseccion',NULL),(298,'articulos','Editar id 41 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:27:02','','Tiramisú','descripcion',NULL),(299,'articulos','Editar id 41 Tiramisú','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:27:13','0','12000','valordeventa',NULL),(300,'articulos','Editar id 41 Tiramisú','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:27:14','0','1','seproduce',NULL),(301,'articulos','Editar id 41 Tiramisú','ISABELLA ESCOBAR CORRALES   ','2025-11-09 13:27:17','0','4','idseccion',NULL),(302,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:42:21','7500','8000','valordeventa',NULL),(303,'articulos','Editar id 14 Porción Zanahoria','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:42:25','7500','8000','valordeventa',NULL),(304,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:42:56','9500','9000','valordeventa',NULL),(305,'articulos','Editar id 36 Milo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:01','9500','9000','valordeventa',NULL),(306,'articulos','Editar id 44 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:12','','Sni','descripcion',NULL),(307,'articulos','Editar id 44 Sni','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:21','Sni','Sneakers','descripcion',NULL),(308,'articulos','Editar id 44 Sneakers','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:27','0','9000','valordeventa',NULL),(309,'articulos','Editar id 44 Sneakers','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:27','0','1','seproduce',NULL),(310,'articulos','Editar id 44 Sneakers','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:30','0','3','idseccion',NULL),(311,'articulos','Editar id 45 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:54','','Coca cola','descripcion',NULL),(312,'articulos','Editar id 45 Coca cola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:43:58','0','1','secompra',NULL),(313,'articulos','Editar id 45 Coca cola','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:01','0','6','idseccion',NULL),(314,'articulos','Editar id 39 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:27','Soda','Soda con limon','descripcion',NULL),(315,'articulos','Editar id 46 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:35','','Soda','descripcion',NULL),(316,'articulos','Editar id 46 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:39','0','2500','valordeventa',NULL),(317,'articulos','Editar id 46 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:39','0','1','secompra',NULL),(318,'articulos','Editar id 46 Soda','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:44:41','0','6','idseccion',NULL),(319,'articulos','Editar id 33 Wrap desmechado','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:45:47','21500','22000','valordeventa',NULL),(320,'articulos','Editar id 32 Wrap pollo','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:45:52','21500','22000','valordeventa',NULL),(321,'articulos','Editar id 47 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:23','','Arepa con carne desmechada','descripcion',NULL),(322,'articulos','Editar id 47 Arepa con carne desmechada','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:27','0','10000','valordeventa',NULL),(323,'articulos','Editar id 47 Arepa con carne desmechada','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:27','0','1','seproduce',NULL),(324,'articulos','Editar id 47 Arepa con carne desmechada','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:30','0','1','idseccion',NULL),(325,'articulos','Editar id 48 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:53','','Tostadas francesas con huevo y fruta','descripcion',NULL),(326,'articulos','Editar id 48 Tostadas francesas con huevo y fruta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:46:57','0','12000','valordeventa',NULL),(327,'articulos','Editar id 37 Omelette con queso y tocineta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:47:05','14000','12000','valordeventa',NULL),(328,'articulos','Editar id 49 ','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:47:55','','Bowl granola con yogurt y fruta','descripcion',NULL),(329,'articulos','Editar id 49 Bowl granola con yogurt y fruta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:47:57','0','13000','valordeventa',NULL),(330,'articulos','Editar id 49 Bowl granola con yogurt y fruta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:48:02','0','1','idseccion',NULL),(331,'articulos','Editar id 48 Tostadas francesas con huevo y fruta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:48:17','0','1','idseccion',NULL),(332,'articulos','Editar id 49 Bowl granola con yogurt y fruta','ISABELLA ESCOBAR CORRALES   ','2025-11-09 17:48:49','','Fruta sujeta a disponibilidad','descripcionlarga',NULL),(333,'articulos','Editar id 50 ','ISABELLA ESCOBAR CORRALES   ','2025-11-13 18:28:33','','Chocomasmelo','descripcion',NULL),(334,'articulos','Editar id 50 Chocomasmelo','ISABELLA ESCOBAR CORRALES   ','2025-11-13 18:28:38','0','9000','valordeventa',NULL),(335,'articulos','Editar id 50 Chocomasmelo','ISABELLA ESCOBAR CORRALES   ','2025-11-13 18:28:38','0','1','seproduce',NULL),(336,'articulos','Editar id 50 Chocomasmelo','ISABELLA ESCOBAR CORRALES   ','2025-11-13 18:28:42','0','3','idseccion',NULL),(337,'clientes','editar id 6 ISABELLA ESCOBAR CORRALES   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 14:11:59','NO','SI','esproveedor',NULL),(338,'clientes','editar id 7 MARIA JOSE CAJERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:45:22','24555577','1192','cedula',NULL),(339,'clientes','editar id 7 MARIA JOSE CAJERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:45:48','1192','1192730463','cedula',NULL),(340,'clientes','editar id 10 MARÍA JOSÉ MESERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:47:17','','11927304633','cedula',NULL),(341,'clientes','editar id 10 MARÍA JOSÉ MESERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:47:19','','11927304633','clave',NULL),(342,'clientes','editar id 7 MARIA JOSE CAJERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:47:34','192MhHyie6WLg','1192730463','clave',NULL),(343,'clientes','editar id 9 ANGIE LORENA MESERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:50:04','100499414399','10049941433','cedula',NULL),(344,'clientes','editar id 9 ANGIE LORENA MESERA   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 17:50:29','','10049941433','clave',NULL),(345,'clientes','editar id 6 ISABELLA ESCOBAR CORRALES   ','ISABELLA ESCOBAR CORRALES   ','2025-11-18 18:40:31','ISABELLA ESCOBAR CORRALES','ISABELLA ESCOBAR CAJERA','primernombre',NULL),(346,'clientes','editar id 12    ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 18:40:51','','ISABELLA ESCOBAR MESERA','primernombre',NULL),(347,'clientes','editar id 12 ISABELLA ESCOBAR MESERA   ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 18:41:06','','10883352088','cedula',NULL),(348,'clientes','editar id 12 ISABELLA ESCOBAR MESERA   ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 18:41:09','','10883352088','clave',NULL),(349,'clientes','editar id 13    ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 18:42:32','NO','SI','esproveedor',NULL),(350,'clientes','editar id 13    ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 18:42:32','','ISABELLA REPOSTERIA','primernombre',NULL),(351,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:24:23','1','','seproduce',NULL),(352,'articulos','Editar id 9 Almendras','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:24:24','0','1','secompra',NULL),(353,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:24:29','0','1','secompra',NULL),(354,'articulos','Editar id 15 Americano','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:24:31','1','','secompra',NULL),(355,'secciones','Editar: 10','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:25:19','','COCINA','seccion',NULL),(356,'articulos','Editar id 42 Cheesecake','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:19','0','1','secompra',NULL),(357,'articulos','Editar id 10 Chocolate','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:30','0','1','secompra',NULL),(358,'articulos','Editar id 50 Chocomasmelo','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:35','0','1','secompra',NULL),(359,'articulos','Editar id 50 Chocomasmelo','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:36','1','','seproduce',NULL),(360,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:40','0','1','secompra',NULL),(361,'articulos','Editar id 11 Churro','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:41','1','','seproduce',NULL),(362,'articulos','Editar id 8 Ferrero','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:48','0','1','secompra',NULL),(363,'articulos','Editar id 13 Macadamia','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:34:59','0','1','secompra',NULL),(364,'articulos','Editar id 22 Milo','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:35:09','0','1','secompra',NULL),(365,'articulos','Editar id 7 Milo','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:35:15','9.5','9500','valordeventa',NULL),(366,'articulos','Editar id 5 Porción Almojabana','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:44:06','0','1','secompra',NULL),(367,'articulos','Editar id 6 Porción Naranja y Amapola','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:45:14','0','1','secompra',NULL),(368,'articulos','Editar id 14 Porción Zanahoria','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:45:17','0','1','secompra',NULL),(369,'articulos','Editar id 12 Red Velvet','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:45:20','0','1','secompra',NULL),(370,'articulos','Editar id 44 Sneakers','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:45:24','0','1','secompra',NULL),(371,'articulos','Editar id 41 Tiramisú','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:45:40','0','1','secompra',NULL),(372,'articulos','Editar id 2 Porcion Red velvet','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:46:01','0','1','secompra',NULL),(373,'articulos','Editar id 3 Porcion de Chocolate','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:46:04','0','1','secompra',NULL),(374,'compras','eliminar compra  idmayor:2, el proveedor es 13 ','ISABELLA ESCOBAR CAJERA   ','2025-11-18 19:47:05',NULL,NULL,NULL,NULL),(375,'ventasauxiliar','Modificar unidades','ISABELLA ESCOBAR CAJERA   ','2025-11-20 21:28:10','1','0','Omelette con queso y tocineta',NULL),(376,'ventasauxiliar','Modificar unidades 1','ISABELLA ESCOBAR CAJERA   ','2025-11-20 21:28:14','1','2','Omelette con queso y tocineta',NULL);

--
-- Table structure for table `emailenviados`
--

CREATE TABLE `emailenviados` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT NULL,
  `texto` text,
  `destinatarios` text,
  `cantidad` int DEFAULT '1',
  `valorunitario` int DEFAULT '0',
  `valortotal` int DEFAULT '0',
  `response` text,
  PRIMARY KEY (`id`),
  KEY `cc` (`texto`(1024))
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `emailenviados`
--


--
-- Table structure for table `enseres`
--

CREATE TABLE `enseres` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fechacreacion` datetime DEFAULT CURRENT_TIMESTAMP,
  `idusuario` int DEFAULT NULL,
  `enser` varchar(150) DEFAULT NULL,
  `clase` varchar(25) DEFAULT NULL,
  `estado` varchar(25) DEFAULT NULL,
  `valor` double DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `enseres`
--


--
-- Table structure for table `epss`
--

CREATE TABLE `epss` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `eps` varchar(120) NOT NULL DEFAULT '',
  `cc` bigint unsigned NOT NULL DEFAULT '1',
  `pv` varchar(25) DEFAULT 'distrito',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `epss`
--


--
-- Table structure for table `estilos`
--

CREATE TABLE `estilos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(25) DEFAULT NULL,
  `estilo` varchar(250) DEFAULT NULL,
  `js` text,
  `html` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `estilos`
--


--
-- Table structure for table `facturas`
--

CREATE TABLE `facturas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `observaciondelcleinte` varchar(200) DEFAULT NULL,
  `diasemana` varchar(200) DEFAULT NULL,
  `ordendia` int DEFAULT '0',
  `abonoinicial` int DEFAULT '0',
  `aliado` varchar(25) DEFAULT NULL,
  `IDMINUTA` int DEFAULT '0',
  `direccion` varchar(200) DEFAULT NULL,
  `barrio` varchar(50) DEFAULT NULL,
  `celular` varchar(50) DEFAULT NULL,
  `cliente` varchar(100) DEFAULT NULL,
  `horaentregadoaldomiciliario` datetime DEFAULT NULL,
  `horaentregadoalcliente` datetime DEFAULT NULL,
  `fecharesolucion` date DEFAULT NULL,
  `resolucion` varchar(20) DEFAULT NULL,
  `desde` int DEFAULT '1',
  `hasta` int DEFAULT '1',
  `iddomiciliario` int DEFAULT '0',
  `comandaf` varchar(11) DEFAULT NULL,
  `entregado` int DEFAULT '0',
  `despachado` int DEFAULT '0',
  `ese` int DEFAULT '0',
  `tienenc` int DEFAULT '0',
  `consecutivo` int NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `horatotal` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `documento` varchar(2) NOT NULL DEFAULT 'V',
  `saldo` double NOT NULL DEFAULT '0',
  `observacion` text,
  `origen` varchar(25) DEFAULT NULL,
  `entrega` varchar(100) NOT NULL DEFAULT ' ',
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cc` int DEFAULT '2',
  `idmesa` int DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `total` int DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `cerrado` int NOT NULL DEFAULT '0',
  `recibido` double NOT NULL DEFAULT '0',
  `devuelta` double NOT NULL DEFAULT '0',
  `iva` double DEFAULT '0',
  `vigenciadelcredito` int NOT NULL DEFAULT '0',
  `condicion` int NOT NULL DEFAULT '0',
  `fechavencimiento` date DEFAULT NULL,
  `ultimaedicion` datetime DEFAULT CURRENT_TIMESTAMP,
  `pedidonumero` varchar(50) DEFAULT NULL,
  `base` double NOT NULL DEFAULT '0',
  `inquiry` varchar(23) NOT NULL DEFAULT ' ',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1' COMMENT 'este vendedor no hizo toda la venta, solo abriÃ² la mesa',
  `emailenviado` int NOT NULL DEFAULT '0',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `fechaabonado` datetime DEFAULT NULL,
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODFORMAPAGO` varchar(5) DEFAULT '1',
  `codalmacen` varchar(25) DEFAULT '1',
  `TIPODELIVERY` varchar(1) NOT NULL DEFAULT '1',
  `n` varchar(1) NOT NULL DEFAULT 'B',
  `aliasespera` int NOT NULL DEFAULT '0',
  `codvendedor` int NOT NULL DEFAULT '0',
  `impresiones` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `consecutivoenviado` int DEFAULT '0',
  `esbarra` varchar(1) NOT NULL DEFAULT 'F',
  `CODTARIFA` varchar(1) NOT NULL DEFAULT '1',
  `ivainc` varchar(1) NOT NULL DEFAULT 'T',
  `codzona` int NOT NULL DEFAULT '1',
  `domicilio` double NOT NULL DEFAULT '0',
  `cedula` varchar(15) NOT NULL DEFAULT '999999',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `codigopostal` varchar(6) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(25) DEFAULT NULL,
  `ciudad` varchar(25) DEFAULT NULL,
  `cufe` varchar(250) DEFAULT NULL,
  `resoluciondesde` date DEFAULT NULL,
  `resolucionhasta` date DEFAULT NULL,
  `consecutivofe` int DEFAULT '0',
  `prefijofe` varchar(5) DEFAULT NULL,
  `id_tipo_persona` int DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `notacreditofe` int DEFAULT '0',
  `cufenc` varchar(250) DEFAULT NULL,
  `numlineas` int DEFAULT '0',
  `razonsocial` varchar(200) DEFAULT NULL,
  `nombrecomercial` varchar(200) DEFAULT NULL,
  `tipodepersona` int DEFAULT '0',
  `tipo_identificacion` varchar(5) DEFAULT NULL,
  `dv` int DEFAULT NULL,
  `sfiscalresponsibilities` varchar(10) DEFAULT NULL,
  `regimenfiscal` int DEFAULT NULL,
  `contacto` varchar(100) DEFAULT NULL,
  `prefijo` varchar(5) DEFAULT 'FV',
  `conceptoanulado` varchar(150) DEFAULT NULL,
  `garantiahasta` date DEFAULT NULL,
  `cantidadmediosdepago` int DEFAULT '0',
  `snumsop` varchar(25) DEFAULT NULL,
  `inumoper` varchar(25) DEFAULT NULL,
  `revisiones` int DEFAULT '0',
  `valornc` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `numeroabajo` int DEFAULT '0',
  `alergenos` varchar(50) DEFAULT '0',
  `facturatienemodificadores` int DEFAULT '0',
  `conseuctivorappi` varchar(11) DEFAULT NULL,
  `delivery_method` varchar(25) DEFAULT NULL,
  `payment_method` varchar(25) DEFAULT NULL,
  `COD_CLIENTE_FRONT` int DEFAULT '0',
  `tipofactura` varchar(1) DEFAULT 'V' COMMENT 'Tipo de Factura: P=Parking, V=Ventas',
  `ssignature` text,
  `sqr` text,
  `observacionesnovedad` varchar(150) DEFAULT NULL,
  `horapreparado` datetime DEFAULT NULL,
  `resdianfe` varchar(25) DEFAULT NULL,
  `desdefe` int DEFAULT '0',
  `hastafe` int DEFAULT '0',
  `fecharesfe` date DEFAULT NULL,
  `fechafe` date DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `mediodoepagointegracion` varchar(25) DEFAULT NULL,
  `CONFIRMED` datetime DEFAULT NULL,
  `pancaliente` int DEFAULT '0',
  `DISPATCHED` datetime DEFAULT NULL,
  `CONCLUDED` datetime DEFAULT NULL,
  `CANCELLED` datetime DEFAULT NULL,
  `prefijoenviado` varchar(4) DEFAULT NULL,
  `aceptado` bit(1) DEFAULT b'0',
  `horaaceptado` datetime DEFAULT NULL,
  `fecha_registrofactura` datetime DEFAULT CURRENT_TIMESTAMP,
  `enviadoataxxa` bit(1) DEFAULT b'0',
  `horanovedad` datetime DEFAULT NULL,
  `novedad` bit(1) DEFAULT b'0',
  `costofactura` double DEFAULT '0',
  `aceptado_domiciliario` bit(1) DEFAULT b'0',
  `hora_aceptado_domiciliario` datetime DEFAULT NULL,
  `prooduco_recibido_domiciliario` bit(1) DEFAULT b'0',
  `hora_prooduco_recibido_domiciliario` datetime DEFAULT NULL,
  `impreso` bit(1) DEFAULT b'0',
  `pedidorechazado` bit(1) DEFAULT b'0',
  `horapedidorechazado` datetime DEFAULT NULL,
  `domicilioconciliado` bit(1) DEFAULT b'0',
  `fechancdian` datetime DEFAULT NULL,
  `tipodevolucion` varchar(25) DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `nombrecomercialfactura` varchar(50) DEFAULT NULL,
  `clasificacioncliente` varchar(20) DEFAULT 'CLIENTE FINAL',
  `codeudor` varchar(50) DEFAULT NULL,
  `telefonoocodeudor` varchar(30) DEFAULT NULL,
  `parentescocodeudor` varchar(25) DEFAULT NULL,
  `plazo` int DEFAULT NULL,
  `valorcuota` int DEFAULT NULL,
  `valorcuotainicial` int DEFAULT NULL,
  `fechacuotainicial` date DEFAULT NULL,
  `cuotasapartirde` date DEFAULT NULL,
  `modalidad` int DEFAULT NULL,
  `comensales_factura` int DEFAULT '0',
  `identificador` varchar(25) DEFAULT NULL,
  `impazucaradas` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `descuentoporflete` int DEFAULT '0',
  `otrosdescuentos` int DEFAULT '0',
  `sobrecargoeventosf` double DEFAULT '0',
  `forzar2222` varchar(2) DEFAULT 'no',
  `fechafinfe` date DEFAULT NULL,
  `fechahastape` date DEFAULT NULL,
  `prefijope` varchar(4) DEFAULT NULL,
  `fechafinposelectronico` date DEFAULT NULL,
  `fechaposelectronico` date DEFAULT NULL,
  `hastaposelectronico` int DEFAULT '0',
  `desdeposelectronico` int DEFAULT '0',
  `resposelectronico` varchar(25) DEFAULT NULL,
  `cufepos` varchar(250) DEFAULT NULL,
  `consecutivopose` int DEFAULT '0',
  `idmandante` int DEFAULT '0',
  `ZipKey` varchar(50) DEFAULT '',
  `error_taxxa` int DEFAULT '0',
  `repeticionesfe` int DEFAULT '0',
  `wdocumentstatus` varchar(1) DEFAULT NULL,
  `servicio_comedor` varchar(2) DEFAULT 'no',
  `retencion` double DEFAULT '0',
  `ultimafechaimpresionprecuenta` datetime DEFAULT NULL,
  `idusuarioanula` int DEFAULT '0',
  `idusuarioenviadian` int DEFAULT '0',
  `moduloenvia` varchar(25) DEFAULT NULL,
  `clasificacionfactura` varchar(25) DEFAULT NULL,
  `fecha_operacion` date DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  KEY `facturas_ibfk_3` (`idcliente`),
  CONSTRAINT `facturas_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`),
  CONSTRAINT `facturas_ibfk_2` FOREIGN KEY (`idz`) REFERENCES `z` (`id`),
  CONSTRAINT `facturas_ibfk_3` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`),
  CONSTRAINT `facturas_ibfk_4` FOREIGN KEY (`idvendedor`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `facturas`
--

INSERT INTO `facturas` (`id`, `observaciondelcleinte`, `diasemana`, `ordendia`, `abonoinicial`, `aliado`, `IDMINUTA`, `direccion`, `barrio`, `celular`, `cliente`, `horaentregadoaldomiciliario`, `horaentregadoalcliente`, `fecharesolucion`, `resolucion`, `desde`, `hasta`, `iddomiciliario`, `comandaf`, `entregado`, `despachado`, `ese`, `tienenc`, `consecutivo`, `idcliente`, `fechacreacion`, `horatotal`, `documento`, `saldo`, `observacion`, `origen`, `entrega`, `cobra`, `fecha`, `cc`, `idmesa`, `bruto`, `descuento`, `total`, `idusuario`, `idz`, `abonado`, `idfacturaqueabona`, `cerrado`, `recibido`, `devuelta`, `iva`, `vigenciadelcredito`, `condicion`, `fechavencimiento`, `ultimaedicion`, `pedidonumero`, `base`, `inquiry`, `esbolsillo`, `idvendedor`, `emailenviado`, `escortesia`, `idcaja`, `mediodepago`, `nota`, `fechaabonado`, `servicio`, `subido`, `CODFORMAPAGO`, `codalmacen`, `TIPODELIVERY`, `n`, `aliasespera`, `codvendedor`, `impresiones`, `numservicio`, `NUMLINEA`, `consecutivoenviado`, `esbarra`, `CODTARIFA`, `ivainc`, `codzona`, `domicilio`, `cedula`, `codigociudad`, `email`, `codigopostal`, `codigodepartamento`, `departamento`, `ciudad`, `cufe`, `resoluciondesde`, `resolucionhasta`, `consecutivofe`, `prefijofe`, `id_tipo_persona`, `COD_SATELITE`, `notacreditofe`, `cufenc`, `numlineas`, `razonsocial`, `nombrecomercial`, `tipodepersona`, `tipo_identificacion`, `dv`, `sfiscalresponsibilities`, `regimenfiscal`, `contacto`, `prefijo`, `conceptoanulado`, `garantiahasta`, `cantidadmediosdepago`, `snumsop`, `inumoper`, `revisiones`, `valornc`, `domicilioexterno`, `pv`, `numeroabajo`, `alergenos`, `facturatienemodificadores`, `conseuctivorappi`, `delivery_method`, `payment_method`, `COD_CLIENTE_FRONT`, `tipofactura`, `ssignature`, `sqr`, `observacionesnovedad`, `horapreparado`, `resdianfe`, `desdefe`, `hastafe`, `fecharesfe`, `fechafe`, `placa`, `mediodoepagointegracion`, `CONFIRMED`, `pancaliente`, `DISPATCHED`, `CONCLUDED`, `CANCELLED`, `prefijoenviado`, `aceptado`, `horaaceptado`, `fecha_registrofactura`, `enviadoataxxa`, `horanovedad`, `novedad`, `costofactura`, `aceptado_domiciliario`, `hora_aceptado_domiciliario`, `prooduco_recibido_domiciliario`, `hora_prooduco_recibido_domiciliario`, `impreso`, `pedidorechazado`, `horapedidorechazado`, `domicilioconciliado`, `fechancdian`, `tipodevolucion`, `deberecoger`, `nombrecomercialfactura`, `clasificacioncliente`, `codeudor`, `telefonoocodeudor`, `parentescocodeudor`, `plazo`, `valorcuota`, `valorcuotainicial`, `fechacuotainicial`, `cuotasapartirde`, `modalidad`, `comensales_factura`, `identificador`, `impazucaradas`, `impultraprocesados`, `descuentoporflete`, `otrosdescuentos`, `sobrecargoeventosf`, `forzar2222`, `fechafinfe`, `fechahastape`, `prefijope`, `fechafinposelectronico`, `fechaposelectronico`, `hastaposelectronico`, `desdeposelectronico`, `resposelectronico`, `cufepos`, `consecutivopose`, `idmandante`, `ZipKey`, `error_taxxa`, `repeticionesfe`, `wdocumentstatus`, `servicio_comedor`, `retencion`, `ultimafechaimpresionprecuenta`, `idusuarioanula`, `idusuarioenviadian`, `moduloenvia`, `clasificacionfactura`, `fecha_operacion`) VALUES (1,NULL,NULL,0,0,NULL,0,'','',' ','CONSUMIDOR FINAL   ',NULL,NULL,'0000-00-00','',0,0,NULL,'',0,0,0,0,8906,3,'2025-11-18 17:55:10','2025-11-18 17:55:10','V',0,'','MESAS',' ',' ','2025-11-18 17:55:10',2,2,33000,0,33000,8,1,0,0,0,0,0,0,0,2,'2025-11-25','2025-11-18 17:55:10',NULL,33000,' ',0,8,0,0,1,'EFECTIVO','',NULL,0,0,'1','1','1','B',0,0,0,0,1,0,'F','1','T',1,0,'222222222222','66001','','660001','66','RISARALDA','',NULL,'0000-00-00','0000-00-00',0,NULL,0,NULL,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,NULL,NULL,0,0,0,'melcochudos',0,'0',0,NULL,NULL,NULL,0,'V',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,_binary '\0',NULL,'2025-11-18 17:55:10',_binary '\0',NULL,_binary '\0',0,_binary '\0',NULL,_binary '\0',NULL,_binary '\0',_binary '\0',NULL,_binary '\0',NULL,NULL,NULL,'','CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0,0,'',0,0,NULL,'no',0,NULL,0,0,NULL,'',NULL),(2,NULL,NULL,0,0,NULL,0,'','',' ','CONSUMIDOR FINAL   ',NULL,NULL,'0000-00-00','',0,0,NULL,'',0,0,0,0,8907,3,'2025-11-18 18:02:45','2025-11-18 18:02:45','V',0,'','MESAS',' ',' ','2025-11-18 18:02:45',2,7,20000,0,20000,8,1,0,0,0,0,0,0,0,0,'2025-11-25','2025-11-18 18:02:45',NULL,20000,' ',0,8,0,0,1,'EFECTIVO','',NULL,0,0,'1','1','1','B',0,0,0,0,1,0,'F','1','T',1,0,'222222222222','66001','','660001','66','RISARALDA','',NULL,'0000-00-00','0000-00-00',0,NULL,0,NULL,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,NULL,NULL,0,0,0,'melcochudos',0,'0',0,NULL,NULL,NULL,0,'V',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,_binary '\0',NULL,'2025-11-18 18:02:45',_binary '\0',NULL,_binary '\0',0,_binary '\0',NULL,_binary '\0',NULL,_binary '\0',_binary '\0',NULL,_binary '\0',NULL,NULL,NULL,'','CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0,0,'',0,0,NULL,'no',0,NULL,0,0,NULL,'',NULL),(3,NULL,NULL,0,0,NULL,0,'','',' ','CONSUMIDOR FINAL   ',NULL,NULL,'0000-00-00','',0,0,NULL,'',0,0,0,0,8908,3,'2025-11-18 18:03:05','2025-11-18 18:03:05','V',0,'','MESAS',' ',' ','2025-11-18 18:03:05',2,7,12000,0,12000,8,1,0,0,0,0,0,0,0,1,'2025-11-25','2025-11-18 18:03:05',NULL,12000,' ',0,8,0,0,1,'EFECTIVO','',NULL,0,0,'1','1','1','B',0,0,0,0,1,0,'F','1','T',1,0,'222222222222','66001','','660001','66','RISARALDA','',NULL,'0000-00-00','0000-00-00',0,NULL,0,NULL,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,NULL,NULL,0,0,0,'melcochudos',0,'0',0,NULL,NULL,NULL,0,'V',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,_binary '\0',NULL,'2025-11-18 18:03:05',_binary '\0',NULL,_binary '\0',0,_binary '\0',NULL,_binary '\0',NULL,_binary '\0',_binary '\0',NULL,_binary '\0',NULL,NULL,NULL,'','CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0,0,'',0,0,NULL,'no',0,NULL,0,0,NULL,'',NULL),(4,NULL,NULL,0,0,NULL,0,'','',' ','CONSUMIDOR FINAL   ',NULL,NULL,'0000-00-00','',0,0,NULL,'',0,0,0,0,8909,3,'2025-11-20 08:56:46','2025-11-20 08:56:46','V',0,'','MESAS',' ',' ','2025-11-20 08:56:46',2,2,12000,0,12000,6,1,0,0,0,0,0,0,0,1,'2025-11-27','2025-11-20 08:56:46',NULL,12000,' ',0,6,0,0,1,'EFECTIVO','',NULL,0,0,'1','1','1','B',0,0,0,0,1,0,'F','1','T',1,0,'222222222222','66001','','660001','66','RISARALDA','',NULL,'0000-00-00','0000-00-00',0,NULL,0,NULL,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,NULL,NULL,0,0,0,'melcochudos',0,'0',0,NULL,NULL,NULL,0,'V',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,_binary '\0',NULL,'2025-11-20 08:56:46',_binary '\0',NULL,_binary '\0',0,_binary '\0',NULL,_binary '\0',NULL,_binary '\0',_binary '\0',NULL,_binary '\0',NULL,NULL,NULL,'','CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0,0,'',0,0,NULL,'no',0,NULL,0,0,NULL,'',NULL),(5,NULL,NULL,0,0,NULL,0,'','',' ','CONSUMIDOR FINAL   ',NULL,NULL,'0000-00-00','',0,0,NULL,'',0,0,0,0,8910,3,'2025-11-20 21:28:44','2025-11-20 21:28:44','V',0,'','MESAS',' ',' ','2025-11-20 21:28:44',2,2,24000,0,24000,6,1,0,0,0,0,0,0,0,1,'2025-11-27','2025-11-20 21:28:44',NULL,24000,' ',0,6,0,0,1,'EFECTIVO','',NULL,0,0,'1','1','1','B',0,0,0,0,1,0,'F','1','T',1,0,'222222222222','66001','','660001','66','RISARALDA','',NULL,'0000-00-00','0000-00-00',0,NULL,0,NULL,0,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,NULL,NULL,0,0,0,'melcochudos',0,'0',0,NULL,NULL,NULL,0,'V',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,NULL,_binary '\0',NULL,'2025-11-20 21:28:44',_binary '\0',NULL,_binary '\0',0,_binary '\0',NULL,_binary '\0',NULL,_binary '\0',_binary '\0',NULL,_binary '\0',NULL,NULL,NULL,'','CLIENTE FINAL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,0,0,'no',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,0,0,'',0,0,NULL,'no',0,NULL,0,0,NULL,'',NULL);

--
-- Table structure for table `facturas2`
--

CREATE TABLE `facturas2` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `observaciondelcleinte` varchar(200) DEFAULT NULL,
  `diasemana` varchar(200) DEFAULT NULL,
  `ordendia` int DEFAULT '0',
  `MESALIBERADA` int DEFAULT '1',
  `IDMOTIVODTO` int DEFAULT '1',
  `IDMINUTA` int DEFAULT '0',
  `direccion` varchar(200) DEFAULT NULL,
  `barrio` varchar(50) DEFAULT NULL,
  `celular` varchar(50) DEFAULT NULL,
  `cliente` varchar(100) DEFAULT NULL,
  `horaentregadoaldomiciliario` datetime DEFAULT NULL,
  `horaentregadoalcliente` datetime DEFAULT NULL,
  `fecharesolucion` date DEFAULT NULL,
  `resolucion` varchar(20) DEFAULT NULL,
  `desde` int DEFAULT '1',
  `hasta` int DEFAULT '1',
  `iddomiciliario` int DEFAULT '0',
  `comandaf` varchar(11) DEFAULT NULL,
  `entregado` int DEFAULT '0',
  `despachado` int DEFAULT '0',
  `ese` int DEFAULT '0',
  `tienenc` int DEFAULT '0',
  `consecutivo` int NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `horatotal` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `documento` varchar(2) NOT NULL DEFAULT 'V',
  `saldo` double NOT NULL DEFAULT '0',
  `observacion` text,
  `origen` varchar(8) NOT NULL DEFAULT 'MESAS',
  `entrega` varchar(100) NOT NULL DEFAULT ' ',
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cc` bigint unsigned NOT NULL,
  `idmesa` int DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `cerrado` int NOT NULL DEFAULT '0',
  `recibido` double NOT NULL DEFAULT '0',
  `devuelta` double NOT NULL DEFAULT '0',
  `iva` int NOT NULL DEFAULT '0',
  `vigenciadelcredito` int NOT NULL DEFAULT '0',
  `condicion` int NOT NULL DEFAULT '0',
  `fechavencimiento` datetime DEFAULT CURRENT_TIMESTAMP,
  `ultimaedicion` datetime DEFAULT CURRENT_TIMESTAMP,
  `pedidonumero` varchar(10) DEFAULT NULL,
  `base` double NOT NULL DEFAULT '0',
  `inquiry` varchar(23) NOT NULL DEFAULT ' ',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1' COMMENT 'este vendedor no hizo toda la venta, solo abriÃ² la mesa',
  `emailenviado` int NOT NULL DEFAULT '0',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `fechaabonado` datetime DEFAULT NULL,
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODFORMAPAGO` varchar(5) DEFAULT '1',
  `codalmacen` varchar(25) DEFAULT '1',
  `TIPODELIVERY` varchar(1) NOT NULL DEFAULT '1',
  `ESTADODELIVERY` varchar(1) NOT NULL DEFAULT '1',
  `n` varchar(1) NOT NULL DEFAULT 'B',
  `aliasespera` int NOT NULL DEFAULT '0',
  `codvendedor` int NOT NULL DEFAULT '0',
  `impresiones` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `CODTIPOTASA1` varchar(1) NOT NULL DEFAULT '1',
  `esbarra` varchar(1) NOT NULL DEFAULT 'F',
  `CODTARIFA` varchar(1) NOT NULL DEFAULT '1',
  `ivainc` varchar(1) NOT NULL DEFAULT 'T',
  `codzona` int NOT NULL DEFAULT '1',
  `domicilio` double NOT NULL DEFAULT '0',
  `cedula` varchar(15) NOT NULL DEFAULT '999999',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(5) DEFAULT NULL,
  `codigopostal` varchar(5) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(25) DEFAULT NULL,
  `ciudad` varchar(5) DEFAULT NULL,
  `cufe` varchar(250) DEFAULT NULL,
  `resoluciondesde` date DEFAULT NULL,
  `resolucionhasta` date DEFAULT NULL,
  `consecutivofe` int DEFAULT '0',
  `prefijofe` varchar(5) DEFAULT NULL,
  `id_tipo_persona` int DEFAULT '0',
  `fecha_registrofactura` varchar(20) DEFAULT NULL,
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `notacreditofe` int DEFAULT '0',
  `cufenc` varchar(250) DEFAULT NULL,
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'distrito',
  `numeroabajo` int DEFAULT '0',
  `alergenos` varchar(50) DEFAULT '0',
  `impazucaradas` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `placa` varchar(6) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  KEY `facturas_ibfk_3` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `facturas2`
--


--
-- Table structure for table `facturas2021`
--

CREATE TABLE `facturas2021` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `observaciondelcleinte` varchar(200) DEFAULT NULL,
  `diasemana` varchar(200) DEFAULT NULL,
  `ordendia` int DEFAULT '0',
  `MESALIBERADA` int DEFAULT '1',
  `aliado` varchar(25) DEFAULT NULL,
  `IDMINUTA` int DEFAULT '0',
  `direccion` varchar(200) DEFAULT NULL,
  `barrio` varchar(50) DEFAULT NULL,
  `celular` varchar(50) DEFAULT NULL,
  `cliente` varchar(100) DEFAULT NULL,
  `horaentregadoaldomiciliario` datetime DEFAULT NULL,
  `horaentregadoalcliente` datetime DEFAULT NULL,
  `fecharesolucion` date DEFAULT NULL,
  `resolucion` varchar(20) DEFAULT NULL,
  `desde` int DEFAULT '1',
  `hasta` int DEFAULT '1',
  `iddomiciliario` int DEFAULT '0',
  `comandaf` varchar(11) DEFAULT NULL,
  `entregado` int DEFAULT '0',
  `despachado` int DEFAULT '0',
  `ese` int DEFAULT '0',
  `tienenc` int DEFAULT '0',
  `consecutivo` int NOT NULL DEFAULT '0',
  `idcliente` bigint unsigned NOT NULL DEFAULT '1',
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `horatotal` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `documento` varchar(2) NOT NULL DEFAULT 'V',
  `saldo` double NOT NULL DEFAULT '0',
  `observacion` text,
  `origen` varchar(25) DEFAULT NULL,
  `entrega` varchar(100) NOT NULL DEFAULT ' ',
  `cobra` varchar(100) NOT NULL DEFAULT ' ',
  `fecha` datetime DEFAULT CURRENT_TIMESTAMP,
  `cc` int DEFAULT '2',
  `idmesa` int DEFAULT '1',
  `bruto` double NOT NULL DEFAULT '0',
  `descuento` double NOT NULL DEFAULT '0',
  `total` int DEFAULT '0',
  `idusuario` bigint unsigned NOT NULL DEFAULT '1',
  `idz` bigint unsigned NOT NULL DEFAULT '1',
  `abonado` int NOT NULL DEFAULT '0',
  `idfacturaqueabona` int NOT NULL DEFAULT '0',
  `cerrado` int NOT NULL DEFAULT '0',
  `recibido` double NOT NULL DEFAULT '0',
  `devuelta` double NOT NULL DEFAULT '0',
  `iva` double DEFAULT '0',
  `vigenciadelcredito` int NOT NULL DEFAULT '0',
  `condicion` int NOT NULL DEFAULT '0',
  `fechavencimiento` date DEFAULT NULL,
  `ultimaedicion` datetime DEFAULT CURRENT_TIMESTAMP,
  `pedidonumero` varchar(50) DEFAULT NULL,
  `base` double NOT NULL DEFAULT '0',
  `inquiry` varchar(23) NOT NULL DEFAULT ' ',
  `esbolsillo` int NOT NULL DEFAULT '0',
  `idvendedor` bigint unsigned NOT NULL DEFAULT '1' COMMENT 'este vendedor no hizo toda la venta, solo abriÃ² la mesa',
  `emailenviado` int NOT NULL DEFAULT '0',
  `escortesia` int NOT NULL DEFAULT '0',
  `idcaja` bigint unsigned NOT NULL DEFAULT '1',
  `mediodepago` varchar(25) NOT NULL DEFAULT 'EFECTIVO',
  `nota` varchar(25) NOT NULL DEFAULT '',
  `fechaabonado` datetime DEFAULT NULL,
  `servicio` int NOT NULL DEFAULT '0',
  `subido` int NOT NULL DEFAULT '0',
  `CODFORMAPAGO` varchar(5) DEFAULT '1',
  `codalmacen` varchar(25) DEFAULT '1',
  `TIPODELIVERY` varchar(1) NOT NULL DEFAULT '1',
  `ESTADODELIVERY` varchar(1) NOT NULL DEFAULT '1',
  `n` varchar(1) NOT NULL DEFAULT 'B',
  `aliasespera` int NOT NULL DEFAULT '0',
  `codvendedor` int NOT NULL DEFAULT '0',
  `impresiones` int NOT NULL DEFAULT '0',
  `numservicio` int NOT NULL DEFAULT '0',
  `NUMLINEA` int NOT NULL DEFAULT '1',
  `CODTIPOTASA1` varchar(1) NOT NULL DEFAULT '1',
  `esbarra` varchar(1) NOT NULL DEFAULT 'F',
  `CODTARIFA` varchar(1) NOT NULL DEFAULT '1',
  `ivainc` varchar(1) NOT NULL DEFAULT 'T',
  `codzona` int NOT NULL DEFAULT '1',
  `domicilio` double NOT NULL DEFAULT '0',
  `cedula` varchar(15) NOT NULL DEFAULT '999999',
  `codigociudad` varchar(5) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `codigopostal` varchar(6) DEFAULT NULL,
  `codigodepartamento` varchar(5) DEFAULT NULL,
  `departamento` varchar(25) DEFAULT NULL,
  `ciudad` varchar(25) DEFAULT NULL,
  `cufe` varchar(250) DEFAULT NULL,
  `resoluciondesde` date DEFAULT NULL,
  `resolucionhasta` date DEFAULT NULL,
  `consecutivofe` int DEFAULT '0',
  `prefijofe` varchar(5) DEFAULT NULL,
  `id_tipo_persona` int DEFAULT '0',
  `COD_SATELITE` varchar(25) DEFAULT NULL,
  `notacreditofe` int DEFAULT '0',
  `cufenc` varchar(250) DEFAULT NULL,
  `numlineas` int DEFAULT '0',
  `razonsocial` varchar(200) DEFAULT NULL,
  `nombrecomercial` varchar(200) DEFAULT NULL,
  `tipodepersona` int DEFAULT '0',
  `tipo_identificacion` varchar(5) DEFAULT NULL,
  `dv` int DEFAULT NULL,
  `sfiscalresponsibilities` varchar(10) DEFAULT NULL,
  `regimenfiscal` int DEFAULT NULL,
  `contacto` varchar(100) DEFAULT NULL,
  `prefijo` varchar(5) DEFAULT 'FV',
  `conceptoanulado` varchar(150) DEFAULT NULL,
  `garantiahasta` date DEFAULT NULL,
  `cantidadmediosdepago` int DEFAULT '0',
  `snumsop` varchar(25) DEFAULT NULL,
  `inumoper` varchar(25) DEFAULT NULL,
  `despachadoaifood` int DEFAULT '0',
  `valornc` int DEFAULT '0',
  `domicilioexterno` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'extremabelleza',
  `numeroabajo` int DEFAULT '0',
  `alergenos` varchar(50) DEFAULT '0',
  `facturatienemodificadores` int DEFAULT '0',
  `conseuctivorappi` varchar(11) DEFAULT NULL,
  `delivery_method` varchar(25) DEFAULT NULL,
  `payment_method` varchar(25) DEFAULT NULL,
  `COD_CLIENTE_FRONT` int DEFAULT '0',
  `ID_CLIENTE_CONTROL` int DEFAULT '1',
  `ssignature` text,
  `sqr` text,
  `observacionesnovedad` varchar(150) DEFAULT NULL,
  `horapreparado` datetime DEFAULT NULL,
  `resdianfe` varchar(25) DEFAULT NULL,
  `desdefe` int DEFAULT '0',
  `hastafe` int DEFAULT '0',
  `fecharesfe` date DEFAULT NULL,
  `fechafe` date DEFAULT NULL,
  `placa` varchar(6) DEFAULT NULL,
  `mediodoepagointegracion` varchar(25) DEFAULT NULL,
  `CONFIRMED` datetime DEFAULT NULL,
  `READY_TO_PICKUP` datetime DEFAULT NULL,
  `DISPATCHED` datetime DEFAULT NULL,
  `CONCLUDED` datetime DEFAULT NULL,
  `CANCELLED` datetime DEFAULT NULL,
  `CANCELLATION_REQUESTED` datetime DEFAULT NULL,
  `aceptado` bit(1) DEFAULT b'0',
  `horaaceptado` datetime DEFAULT NULL,
  `fecha_registrofactura` datetime DEFAULT NULL,
  `enviadoataxxa` bit(1) DEFAULT b'0',
  `horanovedad` datetime DEFAULT NULL,
  `novedad` bit(1) DEFAULT b'0',
  `costofactura` double DEFAULT '0',
  `aceptado_domiciliario` bit(1) DEFAULT b'0',
  `hora_aceptado_domiciliario` datetime DEFAULT NULL,
  `prooduco_recibido_domiciliario` bit(1) DEFAULT b'0',
  `hora_prooduco_recibido_domiciliario` datetime DEFAULT NULL,
  `impreso` bit(1) DEFAULT b'0',
  `pedidorechazado` bit(1) DEFAULT b'0',
  `horapedidorechazado` datetime DEFAULT NULL,
  `domicilioconciliado` bit(1) DEFAULT b'0',
  `fechancdian` datetime DEFAULT NULL,
  `tipodevolucion` varchar(25) DEFAULT NULL,
  `deberecoger` datetime DEFAULT NULL,
  `nombrecomercialfactura` varchar(50) DEFAULT NULL,
  `clasificacioncliente` varchar(20) DEFAULT 'CLIENTE FINAL',
  `codeudor` varchar(50) DEFAULT NULL,
  `telefonoocodeudor` varchar(30) DEFAULT NULL,
  `parentescocodeudor` varchar(25) DEFAULT NULL,
  `plazo` int DEFAULT NULL,
  `valorcuota` int DEFAULT NULL,
  `valorcuotainicial` int DEFAULT NULL,
  `fechacuotainicial` date DEFAULT NULL,
  `cuotasapartirde` date DEFAULT NULL,
  `modalidad` int DEFAULT NULL,
  `comensales_factura` int DEFAULT '0',
  `identificador` varchar(25) DEFAULT NULL,
  `impazucaradas` int DEFAULT '0',
  `impultraprocesados` int DEFAULT '0',
  `descuentoporflete` int DEFAULT '0',
  `otrosdescuentos` int DEFAULT '0',
  `sobrecargoeventosf` double DEFAULT '0',
  `forzar2222` varchar(2) DEFAULT 'no',
  `fechafinfe` date DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`),
  KEY `idz` (`idz`),
  KEY `idvendedor` (`idvendedor`),
  KEY `facturas_ibfk_3` (`idcliente`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
