--
-- Host: localhost    Database: elencantoo
-- ------------------------------------------------------


--
-- 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 'KALDI',
  `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,
  `idrecibogeneral` int DEFAULT '0',
  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 'KALDI',
  `mediodepago` varchar(25) DEFAULT NULL,
  `afectacaja` int DEFAULT '1',
  `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 `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 'KALDI',
  `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 'KALDI',
  `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 'KALDI',
  `afectacaja` int DEFAULT '0',
  `observaciones` varchar(100) DEFAULT NULL,
  `abonado` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `abonosprestamosin` (`id`, `valor`, `saldoinicial`, `saldofinal`, `idz`, `idusuario`, `fechacreacion`, `idprestamo`, `consecutivo`, `idcliente`, `cc`, `mediodepago`, `pv`, `afectacaja`, `observaciones`, `abonado`) VALUES (1,25000,0,NULL,562,2,'2025-04-24 19:29:37',1,NULL,0,0,'EFECTIVO','KALDI',1,'asd fasdfasdf',0);

--
-- 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 'KALDI',
  `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 'KALDI',
  `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` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idarticulo_2` (`idarticulo`,`idadicional`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idadicional` (`idadicional`),
  KEY `idusuario` (`idusuario`),
  CONSTRAINT `adicionales_ibfk_1` FOREIGN KEY (`idadicional`) REFERENCES `articulos` (`id`),
  CONSTRAINT `adicionales_ibfk_2` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`),
  CONSTRAINT `adicionales_ibfk_3` FOREIGN KEY (`idadicional`) REFERENCES `articulos` (`id`),
  CONSTRAINT `adicionales_ibfk_4` FOREIGN KEY (`idusuario`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=458 DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `adicionales_grupo`
--

CREATE TABLE `adicionales_grupo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idgrupo` int NOT NULL,
  `idadicional` bigint unsigned NOT NULL,
  `incremento` decimal(5,2) DEFAULT '0.00',
  `fechacreacion` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idgrupo_adicional` (`idgrupo`,`idadicional`),
  KEY `idgrupo` (`idgrupo`),
  KEY `idadicional` (`idadicional`),
  CONSTRAINT `adicionales_grupo_ibfk_1` FOREIGN KEY (`idgrupo`) REFERENCES `grupos_adicionales` (`id`),
  CONSTRAINT `adicionales_grupo_ibfk_2` FOREIGN KEY (`idadicional`) REFERENCES `articulos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `adicionales_grupo`
--


--
-- 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 'KALDI',
  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 'KALDI',
  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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `ajustesdeinventario` (`id`, `idarticulo`, `descripcion`, `fechacreacion`, `cantidad`, `detalle`, `idusuario`, `cc`, `pv`) VALUES (1,2,'PAQUETE MASAJES * 10','2025-07-16 15:46:08',5555,'Seleccione',1,2,'KALDI');

--
-- Table structure for table `anamnesis`
--

CREATE TABLE `anamnesis` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idusuario` bigint unsigned NOT NULL,
  `primeravez` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `idhistoria` int NOT NULL,
  `idcliente` int NOT NULL DEFAULT '0',
  `fechaultimoexamen` varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
  `usarx` varchar(2) COLLATE utf8mb4_bin DEFAULT 'NO',
  `tiporx` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
  `rxenusood` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
  `rxenusoiz` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
  `addrx` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
  `claserx` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
  `observacionesrx` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idhistoria` (`idhistoria`),
  KEY `idusuario` (`idusuario`),
  CONSTRAINT `anamnesis_ibfk_1` FOREIGN KEY (`idhistoria`) REFERENCES `historiaclinica` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `anamnesis`
--

INSERT INTO `anamnesis` (`id`, `idusuario`, `primeravez`, `idhistoria`, `idcliente`, `fechaultimoexamen`, `usarx`, `tiporx`, `rxenusood`, `rxenusoiz`, `addrx`, `claserx`, `observacionesrx`) VALUES (10,2,'SI',15,13,NULL,'NO','','','','','','');

--
-- Table structure for table `antecedentes`
--

CREATE TABLE `antecedentes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idusuario` bigint unsigned NOT NULL,
  `idhistoria` int NOT NULL,
  `hta` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `diabetes` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `trigliceridos` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `pterigio` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `glaucoma` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `cx_ocular` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `otros` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL,
  `idcliente` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idhistoria` (`idhistoria`),
  KEY `idusuario` (`idusuario`),
  KEY `idcliente` (`idcliente`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `antecedentes`
--

INSERT INTO `antecedentes` (`id`, `idusuario`, `idhistoria`, `hta`, `diabetes`, `trigliceridos`, `pterigio`, `glaucoma`, `cx_ocular`, `otros`, `idcliente`) VALUES (9,2,14,'NO','NO','NO','NO','NO','NO',NULL,2),(10,2,15,'NO','NO','NO','NO','NO','NO',NULL,13),(11,2,16,'NO','NO','NO','NO','NO','NO',NULL,13);

--
-- 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `anticipos` (`id`, `fechacreacion`, `valor`, `mediodepago`, `afectacaja`, `observaciones`, `idorden`, `idusuario`, `consecutivo`, `idz`, `idfactura`, `idcliente`, `anticpoencm`) VALUES (1,'2024-08-13',500,'EFECTIVO',1,NULL,2,1,1,562,47740,3161,0),(2,'2024-08-13',100,'EFECTIVO',1,NULL,2,1,3,562,47740,3161,0),(3,'2024-08-13',3000,'TRANSFERENCIA',1,NULL,7,1,4,562,47741,3161,0),(4,'2024-08-13',5000,'TRANSFERENCIA',0,NULL,7,1,5,562,47741,3161,0);

--
-- 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` decimal(5,2) DEFAULT '0.00',
  `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',
  `secompra` int DEFAULT '0',
  `marca` varchar(25) DEFAULT NULL,
  `talla` varchar(5) DEFAULT NULL,
  `referenciacruzada` varchar(25) DEFAULT NULL,
  `pv` varchar(25) DEFAULT 'KALDI',
  `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',
  `idifood` varchar(50) DEFAULT NULL,
  `valordeventaregular` int DEFAULT '0',
  `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` decimal(5,2) DEFAULT NULL,
  `porcentajeutilidad2` decimal(5,2) DEFAULT NULL,
  `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` double 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,
  `division` int DEFAULT '1',
  `varlorventa1` int DEFAULT '0',
  `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`),
  CONSTRAINT `articulos_ibfk_3` FOREIGN KEY (`idunidaddemedida`) REFERENCES `unidadesdemedida` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 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`, `secompra`, `marca`, `talla`, `referenciacruzada`, `pv`, `COD_SATELITE_ARTICULO`, `fabricante`, `modelo`, `serial`, `usuarioedita`, `ultimaedicion`, `cantidad2`, `situacioncocina2`, `idifood`, `valordeventaregular`, `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`, `division`, `varlorventa1`, `referencia2`, `compromisoactual`) VALUES (1,1,_binary '',0,1,2,'GENERAL',0,'SPA-1','','','','CAJA','MASAJE RELAJANTE SENCILLO',' ','SELECCIONE',80000,-1,0,'2025-07-16 12:29:18',' ',2,0,0,1,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-16 12:29:18',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(2,1,_binary '',1,1,1,'GENERAL',0,'CORPORAL-1','','','','CAJA','PAQUETE MASAJE REDUCTOR X10 SESIONES','','SELECCIONE',300000,5550,0,'2025-07-16 12:29:29',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-16 12:29:29',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(3,1,_binary '',0,1,2,'GENERAL',0,'SPA-2','','','','CAJA','MASAJE RELAJANTE CON EXFOLIACIÓN','','SELECCIONE',110000,-3,0,'2025-07-18 11:32:36',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 11:32:36',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(4,1,_binary '',0,1,2,'GENERAL',0,'SPA-6','','','','CAJA','MASAJE RELAJANTE PLAN PAREJA CON EXFOLIACIÓN +CHOCOTERAPIA',' ','SELECCIONE',250000,0,0,'2025-07-18 11:42:49',' ',2,0,0,1,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 11:42:49',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(5,1,_binary '',0,1,2,'GENERAL',0,'SPA-3','','','','CAJA','MASAJE REPAJANTE CON EXFOLIACIÓN Y CHOCOTERAPIA','','SELECCIONE',140000,-3,0,'2025-07-18 14:21:31',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 14:21:31',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(6,1,_binary '',0,1,2,'GENERAL',0,'SPA-5','','','','CAJA','MASAJE RELAJANTE CON EXFOLIACIÓN PAREJA','','SELECCIONE',200000,0,0,'2025-07-18 14:22:51',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 14:22:51',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(7,1,_binary '',0,1,2,'GENERAL',0,'SPA-4','','','','CAJA','MASAJE RELAJANTE PLAN PAREJA','','SELECCIONE',150000,0,0,'2025-07-18 14:22:52',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 14:22:52',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(8,1,_binary '',0,1,0,'GENERAL',0,'CORPORAL-3','','','','CAJA','APLICACIÓN DE HIDROLIPOCLASIA X 1 SESIÓN','','SELECCIONE',100000,-1,0,'2025-07-18 14:30:38',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 14:30:38',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(9,1,_binary '',0,1,1,'GENERAL',0,'CORPORAL-2','','','','CAJA','PAQUETE DE LEVANTAMIENTO DE GLUTEOS X10 SESIONES',' ','SELECCIONE',300000,-13,0,'2025-07-18 16:38:21',' ',2,0,0,1,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-18 16:38:21',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(10,1,_binary '',0,1,1,'GENERAL',0,'CORPORAL-4','','','','CAJA','APLICACIÓN DE QUEMADOR DURANTE TTO',' ','SELECCIONE',50000,0,0,'2025-07-19 18:10:01',' ',2,0,0,1,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:10:01',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(11,1,_binary '',0,1,5,'GENERAL',0,'SUERO-1','','','','CAJA','COCTEL MULTIVITAMINICO 110','','SELECCIONE',110000,0,0,'2025-07-19 18:11:06',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:11:06',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(12,1,_binary '',0,1,5,'GENERAL',0,'SUERO-2','','','','CAJA','SUEROTERAPIA DETOX','','SELECCIONE',60000,0,0,'2025-07-19 18:11:27',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:11:27',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(13,1,_binary '',0,1,5,'GENERAL',0,'SUERO-3','','','','CAJA','SUEROTERAPIA DEPORTIVA','','SELECCIONE',120000,0,0,'2025-07-19 18:11:44',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:11:44',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(14,1,_binary '',0,1,5,'GENERAL',0,'SUERO-4','','','','CAJA','COCTEL DE MYERS','','SELECCIONE',120000,0,0,'2025-07-19 18:12:03',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:12:03',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(15,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-1','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO-AXILAS','','SELECCIONE',20000,0,0,'2025-07-19 18:12:21',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:12:21',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(16,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-2','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO -PIERNA COMPELTA','','SELECCIONE',50000,0,0,'2025-07-19 18:13:35',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:13:35',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(17,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-3','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO - MEDIA PIERNA','','SELECCIONE',25000,0,0,'2025-07-19 18:13:52',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:13:52',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(18,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-4','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO- BIGOTE','','SELECCIONE',10000,0,0,'2025-07-19 18:14:13',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:14:13',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(19,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-5','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO - BIKINI','','SELECCIONE',30000,0,0,'2025-07-19 18:14:49',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:14:49',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(20,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-6','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO- BIKINI VAGI SPA','','SELECCIONE',40000,0,0,'2025-07-19 18:15:14',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:15:14',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(21,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-7','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO - BIKINI CON PERINEAL','','SELECCIONE',35000,0,0,'2025-07-19 18:15:51',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:15:51',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(22,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-8','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO- CEJAS CON DISEÑO','','SELECCIONE',20000,0,0,'2025-07-19 18:16:46',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:16:46',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(23,1,_binary '',0,1,3,'GENERAL',0,'DEPILACIÓN-9','','','','CAJA','DEPILACIÓN CON CERA A BASE DE AZULENO- CEJAS SIN DISEÑO','','SELECCIONE',10000,0,0,'2025-07-19 18:17:14',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:17:14',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(24,1,_binary '',0,1,4,'GENERAL',0,'FACIAL-1','','','','CAJA','LIMPIEZA FACIAL PROFUNDA','','SELECCIONE',80000,0,0,'2025-07-19 18:35:41',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:35:41',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(25,1,_binary '',0,1,4,'GENERAL',0,'FACIAL-2','','','','CAJA','HIDRATACIÓN FACIAL','','SELECCIONE',50000,0,0,'2025-07-19 18:36:06',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:36:06',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(26,1,_binary '',0,1,4,'GENERAL',0,'FACIAL-3','','','','CAJA','PPR FACIAL CON DERMAPEN','','SELECCIONE',100000,0,0,'2025-07-19 18:36:26',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:36:26',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(27,1,_binary '',0,1,4,'GENERAL',0,'FACIAL-4','','','','CAJA','PPR FACIAL EN MESOTERPIA','','SELECCIONE',90000,0,0,'2025-07-19 18:37:38',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:37:38',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(28,1,_binary '',0,1,4,'GENERAL',0,'FACIAL-5','','','','CAJA','DERMAPEN CON VITAMINAS','','SELECCIONE',110000,0,0,'2025-07-19 18:38:26',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:38:26',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(29,1,_binary '',0,1,7,'GENERAL',0,'CAPILAR-1','','','','CAJA','MSOTERAPIA CAPILAR CON PPR','','SELECCIONE',120000,0,0,'2025-07-19 18:39:07',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:39:07',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(30,1,_binary '',0,1,7,'GENERAL',0,'CAPILAR-2','','','','CAJA','DERMAPEN CAPILAR CON PPR','','SELECCIONE',100000,0,0,'2025-07-19 18:39:28',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:39:28',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(31,1,_binary '',0,1,7,'GENERAL',0,'CAPILAR-3','','','','CAJA','MESOTERAPIA CAPILAR CON HAIR FACTOR','','SELECCIONE',130000,0,0,'2025-07-19 18:39:52',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:39:52',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(32,1,_binary '',0,1,7,'GENERAL',0,'CAPILAR-4','','','','CAJA','DERMAPEN CAPILAR CON HAIR FACTOR','','SELECCIONE',140000,0,0,'2025-07-19 18:40:14',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:40:14',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(33,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-1','','','','CAJA','CAUTERIZACIÓN DE ACROCORDONES- ZONA CUELLO','','SELECCIONE',60000,0,0,'2025-07-19 18:40:36',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:40:36',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(34,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-2','','','','CAJA','CAUTERIZACIÓN DE ACROCORDONES- ZONA AXILAS','','SELECCIONE',40000,0,0,'2025-07-19 18:41:15',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:41:15',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(35,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-3','','','','CAJA','CAUTERIZACIÓN DE 1 VERRUGA','','SELECCIONE',30000,0,0,'2025-07-19 18:41:42',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:41:42',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(36,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-4','','','','CAJA','CAUTERIZACIÓN DE 2-5 VERRUGAS','','SELECCIONE',60000,0,0,'2025-07-19 18:42:15',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:42:15',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(37,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-5','','','','CAJA','CAUTERIZACIÓN 1 LUNAR','','SELECCIONE',30000,0,0,'2025-07-19 18:42:59',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:42:59',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(38,1,_binary '',0,1,6,'GENERAL',0,'CAUTERIZACIÓN-6','','','','CAJA','CAUTERIZACIÓN DE 2-5 LUNARES','','SELECCIONE',60000,0,0,'2025-07-19 18:43:21',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-19 18:43:21',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(39,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','EN ESPERA',' ','SELECCIONE',0,0,0,'2025-07-20 19:15:10',' ',2,0,0,1,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,'-1','KALDI',NULL,NULL,NULL,NULL,NULL,'2025-07-20 19:15:10',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(40,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:33',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:33',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(41,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:35',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:35',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(42,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:39',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:39',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(43,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:49',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:49',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(44,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:50',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:50',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(45,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:51',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:51',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0),(46,1,_binary '',0,1,0,'GENERAL',0,'','','','','CAJA','','','SELECCIONE',0,0,0,'2025-09-10 09:02:52',' ',0,0,0,2,1,1,0,0,0,1,0.00,'SELECCIONE','SELECCIONE',0,0,0,0,0,0,0,NULL,0,0,0,1,NULL,0,0,0,NULL,NULL,NULL,'KALDI',NULL,NULL,NULL,NULL,NULL,'2025-09-10 09:02:52',0,'SELECCIONE',NULL,0,0,NULL,NULL,NULL,NULL,NULL,'https://susoftware.es/imagenes/susoftware.png',NULL,_binary '',NULL,NULL,NULL,_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,1,0,NULL,0);

--
-- Table structure for table `articulos_grupos`
--

CREATE TABLE `articulos_grupos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idarticulo` bigint unsigned NOT NULL,
  `idgrupo` int NOT NULL,
  `fechacreacion` datetime DEFAULT NULL,
  `idusuario` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idarticulo_grupo` (`idarticulo`,`idgrupo`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idgrupo` (`idgrupo`),
  CONSTRAINT `articulos_grupos_ibfk_1` FOREIGN KEY (`idarticulo`) REFERENCES `articulos` (`id`),
  CONSTRAINT `articulos_grupos_ibfk_2` FOREIGN KEY (`idgrupo`) REFERENCES `grupos_adicionales` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articulos_grupos`
--


--
-- 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 'KALDI',
  `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 `asignacionarticulosturnos`
--

CREATE TABLE `asignacionarticulosturnos` (
  `id` bigint unsigned NOT NULL,
  `idarticulo` int NOT NULL,
  `idturno` int NOT NULL,
  `fechacreacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cc` int NOT NULL DEFAULT '0',
  `idarticulooriginal` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `asignacionarticulosturnos`
--


--
-- 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`),
  CONSTRAINT `asignacionclientesturnos_ibfk_3` FOREIGN KEY (`idturno`) REFERENCES `turnos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- 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 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 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=49 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `asignacionseccionesterceros` (`idcliente`, `idseccion`, `activo`, `id`) VALUES (2,1,1,2),(1,1,1,4),(5,1,1,5),(1,4,1,7),(1,3,1,8),(1,2,1,9),(2,4,1,10),(2,3,1,11),(2,2,1,12),(5,4,1,13),(5,3,1,14),(5,2,1,15),(1,6,1,23),(1,5,1,24),(2,6,1,25),(2,5,1,26),(5,6,1,27),(5,5,1,28),(1,7,1,30),(2,7,1,31),(5,7,1,32);

--
-- 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=19 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `asignacionzonasterceros` (`id`, `idcliente`, `idzona`, `activo`) VALUES (1,2,1,1),(2,5,1,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 AUTO_INCREMENT=12 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 'KALDI',
  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 'KALDI',
  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 'KALDI',
  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 'KALDI',
  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=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `barrios` (`barrio`, `id`, `incremento`) VALUES ('',1,0),('PEÑARANDA',3,0),('El refugio',4,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 'texasburgers',
  `usuario` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idz` (`idz`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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


--
-- 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 'KALDI',
  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 'KALDI',
  `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 'KALDI',
  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,'KALDI'),(2,'1',2,'KALDI');

--
-- 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 AUTO_INCREMENT=560 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `calendario` (`id`, `descripcion`, `titulo`, `start`, `fechacreacion`, `end`, `profesional`, `estado`) VALUES (1,NULL,'masaje','2025-07-16 12:31:00',NULL,'2025-07-16 13:00:00',NULL,'PENDIENTE'),(2,NULL,'masaje','2025-07-16 13:01:00',NULL,'2025-07-16 13:31:00',NULL,'PENDIENTE'),(3,NULL,'JUAN JOSE LIMPIEZA FACIAL','2025-07-18 14:00:00',NULL,'2025-07-18 14:30:00',NULL,'PENDIENTE'),(4,NULL,'JUAN JOSE LIMPIEZA FACIAL','2025-07-18 14:00:00',NULL,'2025-07-18 14:30:00',NULL,'PENDIENTE'),(5,NULL,'ELIZABETH','2025-07-18 16:00:00',NULL,'2025-07-18 16:30:00',NULL,'PENDIENTE'),(6,NULL,'JUAN JOSE','2025-07-18 14:30:00',NULL,'2025-07-18 15:00:00',NULL,'PENDIENTE'),(7,NULL,'JUAN JOSE','2025-07-18 15:00:00',NULL,'2025-07-18 15:30:00',NULL,'PENDIENTE'),(8,NULL,'JUAN JOSE','2025-07-18 15:30:00',NULL,'2025-07-18 16:00:00',NULL,'PENDIENTE'),(9,NULL,'ELIZABETH','2025-07-18 16:30:00',NULL,'2025-07-18 17:00:00',NULL,'PENDIENTE'),(10,NULL,'ISABELLA','2025-07-18 17:00:00',NULL,'2025-07-18 17:30:00',NULL,'PENDIENTE'),(11,NULL,'KAREN CONDE','2025-07-18 18:30:00',NULL,'2025-07-18 19:00:00',NULL,'PENDIENTE'),(12,NULL,'Juan José','2025-07-21 14:00:00',NULL,'2025-07-21 16:30:00',NULL,'PENDIENTE'),(13,NULL,'JOHANNA REDUCTOR','2025-07-21 07:00:00',NULL,'2025-07-21 07:30:00',NULL,'PENDIENTE'),(14,NULL,'JOHANNA CAUTERIZACIÓN','2025-07-21 08:30:00',NULL,'2025-07-21 09:00:00',NULL,'PENDIENTE'),(15,NULL,'CRISTINA','2025-07-21 10:00:00',NULL,'2025-07-21 10:30:00',NULL,'PENDIENTE'),(16,NULL,'JAZMIN','2025-07-21 16:30:00',NULL,'2025-07-21 17:00:00',NULL,'PENDIENTE'),(17,NULL,'KAREN CONDE','2025-07-21 18:30:00',NULL,'2025-07-21 19:00:00',NULL,'PENDIENTE'),(18,NULL,'YURI','2025-07-21 17:00:00',NULL,'2025-07-21 17:30:00',NULL,'PENDIENTE'),(19,NULL,'ELIZABETH','2025-07-21 19:30:00',NULL,'2025-07-21 20:00:00',NULL,'PENDIENTE'),(20,NULL,'JOHANNA MASAJE','2025-07-22 07:00:00',NULL,'2025-07-22 07:30:00',NULL,'INCUMPLIDO'),(21,NULL,'PESTAÑAS','2025-07-22 08:00:00',NULL,'2025-07-22 08:30:00',NULL,'PENDIENTE'),(22,NULL,'HORACIO','2025-07-22 10:30:00',NULL,'2025-07-22 11:00:00',NULL,'PENDIENTE'),(23,NULL,'SUERO AMAR','2025-07-23 16:30:00',NULL,'2025-07-23 17:00:00',NULL,'PENDIENTE'),(24,NULL,'ISABELLA PEELING','2025-07-25 16:00:00',NULL,'2025-07-25 16:30:00',NULL,'PENDIENTE'),(25,NULL,'AMIGA DE YURI','2025-07-25 16:30:00',NULL,'2025-07-25 17:00:00',NULL,'PENDIENTE'),(26,NULL,'prueba raul','2025-07-01 03:00:00',NULL,'2025-07-01 03:30:00',NULL,'PENDIENTE'),(27,NULL,'prueba raul','2025-07-01 03:00:00',NULL,'2025-07-01 03:30:00',NULL,'PENDIENTE'),(28,NULL,'prueba raul','2025-07-01 03:00:00',NULL,'2025-07-01 03:30:00',NULL,'PENDIENTE'),(29,NULL,'prueba raul','2025-07-01 03:00:00',NULL,'2025-07-01 03:30:00',NULL,'PENDIENTE'),(30,NULL,'prueba raul','2025-07-01 03:00:00',NULL,'2025-07-01 03:30:00',NULL,'PENDIENTE'),(31,NULL,'prueba raul.','2025-07-01 03:30:00',NULL,'2025-07-01 04:00:00',NULL,'PENDIENTE'),(32,NULL,'prueba raul.','2025-07-01 03:30:00',NULL,'2025-07-01 04:00:00',NULL,'PENDIENTE'),(33,NULL,'prueba raul.','2025-07-01 03:30:00',NULL,'2025-07-01 04:00:00',NULL,'PENDIENTE'),(34,NULL,'prueba raul.','2025-07-01 03:30:00',NULL,'2025-07-01 04:00:00',NULL,'PENDIENTE'),(35,NULL,'prueba raul','2025-07-01 02:30:00',NULL,'2025-07-01 03:00:00',NULL,'PENDIENTE'),(36,NULL,'prueba raul','2025-07-01 04:00:00',NULL,'2025-07-01 04:30:00',NULL,'PENDIENTE'),(37,NULL,'prueba raul','2025-07-01 04:00:00',NULL,'2025-07-01 04:30:00',NULL,'PENDIENTE'),(38,NULL,'Prueba raul','2025-07-01 06:30:00',NULL,'2025-07-01 06:30:00',NULL,'PENDIENTE'),(39,NULL,'prueba raul','2025-07-01 08:00:00',NULL,'2025-07-01 08:00:00',NULL,'PENDIENTE'),(40,NULL,'prueba raul','2025-07-01 07:30:00',NULL,'2025-07-01 07:30:00',NULL,'PENDIENTE'),(41,NULL,'prueba raul','2025-07-01 08:30:00',NULL,'2025-07-01 08:30:00',NULL,'PENDIENTE'),(42,NULL,'raul','2025-07-01 06:00:00',NULL,'2025-07-01 06:00:00',NULL,'PENDIENTE'),(43,NULL,'raul','2025-07-01 07:00:00',NULL,'2025-07-01 07:00:00',NULL,'PENDIENTE'),(44,NULL,'raul','2025-07-01 09:00:00',NULL,'2025-07-01 09:00:00',NULL,'PENDIENTE'),(45,NULL,'raul','2025-07-01 10:00:00',NULL,'2025-07-01 10:00:00',NULL,'PENDIENTE'),(46,NULL,'raul','2025-07-01 11:00:00',NULL,'2025-07-01 11:00:00',NULL,'PENDIENTE'),(47,NULL,'raul¿','2025-07-01 12:30:00',NULL,'2025-07-01 12:30:00',NULL,'PENDIENTE'),(48,NULL,'Thhhy','2025-07-01 16:00:00',NULL,'2025-07-01 16:00:00',NULL,'PENDIENTE'),(49,NULL,'Tyjj','2025-07-01 19:30:00',NULL,'2025-07-01 19:30:00',NULL,'PENDIENTE'),(50,NULL,'asfdasdf','2025-07-01 12:00:00',NULL,'2025-07-01 12:00:00',NULL,'PENDIENTE'),(51,NULL,'asfasdf','2025-07-01 17:30:00',NULL,'2025-07-01 17:30:00',NULL,'PENDIENTE'),(52,NULL,'asdfasdf','2025-07-01 17:00:00',NULL,'2025-07-01 17:00:00',NULL,'PENDIENTE'),(53,NULL,'Tyt','2025-07-01 15:00:00',NULL,'2025-07-01 15:00:00',NULL,'PENDIENTE'),(54,NULL,'sdfghjk','2025-07-01 18:00:00',NULL,'2025-07-01 18:00:00',NULL,'PENDIENTE'),(55,NULL,'6','2025-07-01 14:00:00',NULL,'2025-07-01 14:00:00',NULL,'PENDIENTE'),(56,NULL,'6','2025-07-01 19:00:00',NULL,'2025-07-01 19:00:00',NULL,'PENDIENTE'),(57,NULL,'s','2025-07-01 13:00:00',NULL,'2025-07-01 13:00:00',NULL,'PENDIENTE'),(58,NULL,'w','2025-07-01 20:00:00',NULL,'2025-07-01 20:00:00',NULL,'PENDIENTE'),(59,NULL,'d','2025-07-01 21:00:00',NULL,'2025-07-01 21:00:00',NULL,'PENDIENTE'),(60,NULL,'d','2025-07-01 22:30:00',NULL,'2025-07-01 22:30:00',NULL,'PENDIENTE'),(61,NULL,'de','2025-07-01 22:00:00',NULL,'2025-07-01 22:00:00',NULL,'PENDIENTE'),(62,NULL,'d','2025-07-01 23:00:00',NULL,'2025-07-01 23:00:00',NULL,'PENDIENTE'),(63,NULL,'d','2025-07-01 05:30:00',NULL,'2025-07-01 05:30:00',NULL,'PENDIENTE'),(64,NULL,'d','2025-07-01 05:00:00',NULL,'2025-07-01 05:00:00',NULL,'PENDIENTE'),(65,NULL,'d','2025-07-01 04:30:00',NULL,'2025-07-01 04:30:00',NULL,'PENDIENTE'),(66,NULL,'r','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(67,NULL,'re','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(68,NULL,'w','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(69,NULL,'w3','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(70,NULL,'3','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(71,NULL,'e','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(72,NULL,'ee','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(73,NULL,'s','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(74,NULL,'ds','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(75,NULL,'sdsd','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(76,NULL,'sdsdsd','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(77,NULL,'dsdsd','2025-07-01 09:30:00',NULL,'2025-07-01 09:30:00',NULL,'PENDIENTE'),(78,NULL,'Tuf','2025-07-01 10:30:00',NULL,'2025-07-01 10:30:00',NULL,'PENDIENTE'),(79,NULL,'Tyyy','2025-07-01 00:00:00',NULL,'2025-07-01 00:00:00',NULL,'PENDIENTE'),(80,NULL,'Guig8','2025-07-02 08:00:00',NULL,'2025-07-02 08:00:00',NULL,'PENDIENTE'),(81,NULL,'Gufig','2025-07-02 09:00:00',NULL,'2025-07-02 09:00:00',NULL,'PENDIENTE'),(83,NULL,'Johana sesión 2 plasma','2025-07-30 09:00:00',NULL,'0000-00-00 00:00:00',NULL,'CUMPLIDO'),(85,NULL,'Yumping','2025-07-29 08:30:00',NULL,'2025-07-29 08:30:00',NULL,'PENDIENTE'),(86,NULL,'Iliana','2025-07-29 15:00:00',NULL,'2025-07-29 15:00:00',NULL,'PENDIENTE'),(87,NULL,'Cristina','2025-07-29 16:00:00',NULL,'2025-07-29 16:00:00',NULL,'PENDIENTE'),(88,NULL,'Ariana','2025-07-29 18:00:00',NULL,'2025-07-29 18:00:00',NULL,'PENDIENTE'),(89,NULL,'Karen','2025-07-29 19:00:00',NULL,'2025-07-29 19:00:00',NULL,'PENDIENTE'),(93,NULL,'Yumping','2025-08-01 07:30:00',NULL,'2025-08-01 07:30:00',NULL,'PENDIENTE'),(94,NULL,'Aleja depilación','2025-08-02 09:00:00',NULL,'2025-08-02 09:00:00',NULL,'PENDIENTE'),(95,NULL,'Faisury inicia paquete','2025-07-30 07:30:00',NULL,'0000-00-00 00:00:00',NULL,'CUMPLIDO'),(98,NULL,'Seminario plasma','2025-08-01 09:00:00',NULL,'2025-08-01 09:00:00',NULL,'PENDIENTE'),(100,NULL,'Iliana','2025-07-30 17:00:00',NULL,'2025-07-30 17:00:00',NULL,'PENDIENTE'),(101,NULL,'Ariana','2025-07-30 18:00:00',NULL,'2025-07-30 18:00:00',NULL,'PENDIENTE'),(102,NULL,'Karen','2025-07-30 19:00:00',NULL,'2025-07-30 19:00:00',NULL,'PENDIENTE'),(103,NULL,'Cristina','2025-07-30 15:30:00',NULL,'0000-00-00 00:00:00',NULL,'INCUMPLIDO'),(104,NULL,'Faisury 2 masaje','2025-07-31 09:00:00',NULL,'2025-07-31 09:00:00',NULL,'PENDIENTE'),(105,NULL,'Comida con aleja y con ili','2025-07-31 16:00:00',NULL,'2025-07-31 16:00:00',NULL,'PENDIENTE'),(106,NULL,'Torta familia','2025-07-31 19:00:00',NULL,'2025-07-31 19:00:00',NULL,'PENDIENTE'),(107,NULL,'Johanna 3 plasma','2025-08-06 08:00:00',NULL,'2025-08-06 08:00:00',NULL,'PENDIENTE'),(108,NULL,'Misa','2025-07-31 06:30:00',NULL,'2025-07-31 06:30:00',NULL,'PENDIENTE'),(109,NULL,'Cris','2025-07-31 14:30:00',NULL,'2025-07-31 14:30:00',NULL,'PENDIENTE'),(111,NULL,'Samuel','2025-08-02 10:30:00',NULL,'2025-08-02 10:30:00',NULL,'PENDIENTE'),(113,NULL,'Ariana','2025-08-01 18:30:00',NULL,'2025-08-01 18:30:00',NULL,'PENDIENTE'),(115,NULL,'Faisury','2025-08-01 15:00:00',NULL,'2025-08-01 15:00:00',NULL,'PENDIENTE'),(116,NULL,'Dahiannna','2025-08-02 11:30:00',NULL,'2025-08-02 11:30:00',NULL,'PENDIENTE'),(118,NULL,'Mono suero','2025-08-05 09:00:00',NULL,'2025-08-05 09:00:00',NULL,'PENDIENTE'),(119,NULL,'Recordar suero Paola','2025-08-13 08:00:00',NULL,'2025-08-13 08:00:00',NULL,'PENDIENTE'),(121,NULL,'Faisury masaje','2025-08-04 09:00:00',NULL,'2025-08-04 09:00:00',NULL,'PENDIENTE'),(122,NULL,'Limpieza + plasma','2025-08-02 14:00:00',NULL,'2025-08-02 14:00:00',NULL,'PENDIENTE'),(123,NULL,'Masaje','2025-08-02 15:30:00',NULL,'2025-08-02 15:30:00',NULL,'PENDIENTE'),(124,NULL,'Suero viviana','2025-08-02 17:00:00',NULL,'2025-08-02 17:00:00',NULL,'PENDIENTE'),(125,NULL,'Plasma abdomen Katerine','2025-08-05 14:00:00',NULL,'2025-08-05 14:00:00',NULL,'PENDIENTE'),(126,NULL,'Santy','2025-08-04 14:30:00',NULL,'2025-08-04 14:30:00',NULL,'PENDIENTE'),(128,NULL,'Isabella','2025-08-04 14:00:00',NULL,'2025-08-04 14:00:00',NULL,'PENDIENTE'),(129,NULL,'Cris','2025-08-04 15:30:00',NULL,'2025-08-04 15:30:00',NULL,'PENDIENTE'),(130,NULL,'Ariana','2025-08-04 18:00:00',NULL,'2025-08-04 18:00:00',NULL,'PENDIENTE'),(131,NULL,'Karen','2025-08-04 19:30:00',NULL,'2025-08-04 19:30:00',NULL,'PENDIENTE'),(132,NULL,'Faisury','2025-08-05 11:00:00',NULL,'0000-00-00 00:00:00',NULL,'INCUMPLIDO'),(133,NULL,'Cris','2025-08-05 15:30:00',NULL,'2025-08-05 15:30:00',NULL,'PENDIENTE'),(135,NULL,'Aria a','2025-08-05 18:00:00',NULL,'2025-08-05 18:00:00',NULL,'PENDIENTE'),(136,NULL,'Faisury','2025-08-06 09:30:00',NULL,'2025-08-06 09:30:00',NULL,'PENDIENTE'),(137,NULL,'Santy','2025-08-06 14:00:00',NULL,'2025-08-06 14:00:00',NULL,'PENDIENTE'),(138,NULL,'Cris','2025-08-06 15:30:00',NULL,'2025-08-06 15:30:00',NULL,'PENDIENTE'),(139,NULL,'Ariana','2025-08-06 18:00:00',NULL,'2025-08-06 18:00:00',NULL,'PENDIENTE'),(140,NULL,'Katherine sesión 2','2025-08-07 09:30:00',NULL,'2025-08-07 09:30:00',NULL,'PENDIENTE'),(141,NULL,'Jumping','2025-08-08 09:00:00',NULL,'2025-08-08 09:00:00',NULL,'PENDIENTE'),(142,NULL,'Ariana','2025-08-07 08:30:00',NULL,'2025-08-07 08:30:00',NULL,'PENDIENTE'),(143,NULL,'Faisury','2025-08-07 10:30:00',NULL,'2025-08-07 10:30:00',NULL,'PENDIENTE'),(145,NULL,'Faisury','2025-08-08 10:30:00',NULL,'2025-08-08 10:30:00',NULL,'PENDIENTE'),(146,NULL,'Faisury','2025-08-09 08:00:00',NULL,'2025-08-09 08:00:00',NULL,'PENDIENTE'),(147,NULL,'Kate','2025-08-09 10:30:00',NULL,'2025-08-09 10:30:00',NULL,'PENDIENTE'),(148,NULL,'Kate sesión 3 plasma','2025-08-11 17:30:00',NULL,'2025-08-11 17:30:00',NULL,'PENDIENTE'),(149,NULL,'Faisury','2025-08-11 12:30:00',NULL,'2025-08-11 12:30:00',NULL,'PENDIENTE'),(150,NULL,'Diana prima suero','2025-08-12 17:30:00',NULL,'2025-08-12 17:30:00',NULL,'PENDIENTE'),(151,NULL,'Camila','2025-08-13 15:00:00',NULL,'2025-08-13 15:00:00',NULL,'PENDIENTE'),(152,NULL,'Diana calidad masaje 1','2025-08-18 09:00:00',NULL,'2025-08-18 09:00:00',NULL,'PENDIENTE'),(153,NULL,'6:50 am Rosario','2025-08-13 06:30:00',NULL,'2025-08-13 06:30:00',NULL,'PENDIENTE'),(154,NULL,'Juliana Gutiérrez','2025-08-12 15:00:00',NULL,'2025-08-12 15:00:00',NULL,'PENDIENTE'),(156,NULL,'Rosario','2025-08-14 06:30:00',NULL,'2025-08-14 06:30:00',NULL,'PENDIENTE'),(157,NULL,'Faisury','2025-08-14 08:30:00',NULL,'2025-08-14 08:30:00',NULL,'PENDIENTE'),(158,NULL,'Gladys facial','2025-08-16 07:00:00',NULL,'2025-08-16 07:00:00',NULL,'PENDIENTE'),(159,NULL,'Gladys suero','2025-08-16 08:00:00',NULL,'2025-08-16 08:00:00',NULL,'PENDIENTE'),(161,NULL,'Johanna plasma 4','2025-08-15 09:00:00',NULL,'2025-08-15 09:00:00',NULL,'PENDIENTE'),(162,NULL,'Iliana','2025-08-14 15:30:00',NULL,'2025-08-14 15:30:00',NULL,'PENDIENTE'),(163,NULL,'Camila','2025-08-14 14:30:00',NULL,'2025-08-14 14:30:00',NULL,'PENDIENTE'),(164,NULL,'Cris','2025-08-14 16:30:00',NULL,'2025-08-14 16:30:00',NULL,'PENDIENTE'),(165,NULL,'Karen conde','2025-08-14 18:30:00',NULL,'2025-08-14 18:30:00',NULL,'PENDIENTE'),(166,NULL,'Rosario 3','2025-08-15 06:30:00',NULL,'2025-08-15 06:30:00',NULL,'PENDIENTE'),(167,NULL,'Faisury','2025-08-15 10:00:00',NULL,'2025-08-15 10:00:00',NULL,'PENDIENTE'),(168,NULL,'Isabella','2025-08-15 11:30:00',NULL,'2025-08-15 11:30:00',NULL,'PENDIENTE'),(169,NULL,'Masaje PAM','2025-08-15 16:00:00',NULL,'2025-08-15 16:00:00',NULL,'PENDIENTE'),(170,NULL,'Mauricio Cauterización','2025-08-16 17:00:00',NULL,'0000-00-00 00:00:00',NULL,'INCUMPLIDO'),(171,NULL,'Katerine','2025-08-15 08:00:00',NULL,'2025-08-15 08:00:00',NULL,'PENDIENTE'),(172,NULL,'Iliana limpieza + plasma','2025-08-15 14:00:00',NULL,'2025-08-15 14:00:00',NULL,'PENDIENTE'),(173,NULL,'Juliana suero','2025-08-16 10:00:00',NULL,'2025-08-16 10:00:00',NULL,'PENDIENTE'),(174,NULL,'Faisury','2025-08-16 14:00:00',NULL,'2025-08-16 14:00:00',NULL,'PENDIENTE'),(175,NULL,'Alexandra Depilación','2025-08-15 17:30:00',NULL,'2025-08-15 17:30:00',NULL,'PENDIENTE'),(176,NULL,'Yeni Jiménez inicia paquete','2025-08-19 14:00:00',NULL,'2025-08-19 14:00:00',NULL,'PENDIENTE'),(177,NULL,'Juan novio de Camila','2025-08-18 11:00:00',NULL,'2025-08-18 11:00:00',NULL,'PENDIENTE'),(178,NULL,'Valoración Daniela Ortega 6:20','2025-08-19 18:00:00',NULL,'2025-08-19 18:00:00',NULL,'PENDIENTE'),(179,NULL,'Alexandra depilación','2025-08-19 17:30:00',NULL,'2025-08-19 17:30:00',NULL,'PENDIENTE'),(180,NULL,'Camila 4 masaje','2025-08-16 15:30:00',NULL,'2025-08-16 15:30:00',NULL,'PENDIENTE'),(182,NULL,'Juliana 10:00 inicia paquete','2025-08-19 10:00:00',NULL,'0000-00-00 00:00:00',NULL,'INCUMPLIDO'),(183,NULL,'Juliana sesión 2 DNA','2025-08-23 09:00:00',NULL,'2025-08-23 09:00:00',NULL,'PENDIENTE'),(184,NULL,'Juliana masaje','2025-08-23 11:00:00',NULL,'2025-08-23 11:00:00',NULL,'PENDIENTE'),(186,NULL,'Faisury inicia nuevo paquete 1','2025-08-19 15:00:00',NULL,'2025-08-19 15:00:00',NULL,'PENDIENTE'),(187,NULL,'Dermapen','2025-08-19 16:00:00',NULL,'2025-08-19 16:00:00',NULL,'PENDIENTE'),(188,NULL,'Camila 5','2025-08-19 17:00:00',NULL,'2025-08-19 17:00:00',NULL,'PENDIENTE'),(191,NULL,'Diana prima DÑA+ (2)','2025-08-18 08:30:00',NULL,'2025-08-18 08:30:00',NULL,'PENDIENTE'),(192,NULL,'PAM','2025-08-20 16:00:00',NULL,'2025-08-20 16:00:00',NULL,'PENDIENTE'),(193,NULL,'Pam','2025-08-20 17:00:00',NULL,'2025-08-20 17:00:00',NULL,'PENDIENTE'),(194,NULL,'Pam','2025-08-20 18:00:00',NULL,'2025-08-20 18:00:00',NULL,'PENDIENTE'),(195,NULL,'Prima Diana inicia paquete','2025-08-21 13:30:00',NULL,'2025-08-21 13:30:00',NULL,'PENDIENTE'),(197,NULL,'Diana calidad','2025-08-21 18:00:00',NULL,'2025-08-21 18:00:00',NULL,'PENDIENTE'),(198,NULL,'Paula suero','2025-08-13 09:00:00',NULL,'2025-08-13 09:00:00',NULL,'PENDIENTE'),(200,NULL,'Andrés novio prima','2025-08-21 14:30:00',NULL,'2025-08-21 14:30:00',NULL,'PENDIENTE'),(201,NULL,'Boletín Santy','2025-08-20 10:30:00',NULL,'2025-08-20 10:30:00',NULL,'PENDIENTE'),(202,NULL,'Sebastián depilación','2025-08-23 08:00:00',NULL,'2025-08-23 08:00:00',NULL,'PENDIENTE'),(203,NULL,'Yenni Jiménez','2025-08-20 14:00:00',NULL,'2025-08-20 14:00:00',NULL,'PENDIENTE'),(204,NULL,'Rosario 4','2025-08-20 07:00:00',NULL,'2025-08-20 07:00:00',NULL,'PENDIENTE'),(205,NULL,'Paula suero','2025-08-22 09:00:00',NULL,'2025-08-22 09:00:00',NULL,'PENDIENTE'),(206,NULL,'Rosario','2025-08-22 07:00:00',NULL,'2025-08-22 07:00:00',NULL,'PENDIENTE'),(208,NULL,'Rosario 5','2025-08-21 07:00:00',NULL,'2025-08-21 07:00:00',NULL,'PENDIENTE'),(209,NULL,'Camila','2025-08-20 15:00:00',NULL,'2025-08-20 15:00:00',NULL,'PENDIENTE'),(210,NULL,'Limpieza Yuli','2025-08-23 16:00:00',NULL,'2025-08-23 16:00:00',NULL,'PENDIENTE'),(211,NULL,'No agenda','2025-08-23 17:00:00',NULL,'2025-08-23 17:00:00',NULL,'PENDIENTE'),(213,NULL,'Valoración Daniela Ortega','2025-08-21 19:00:00',NULL,'2025-08-21 19:00:00',NULL,'PENDIENTE'),(214,NULL,'Faisury','2025-08-21 10:00:00',NULL,'2025-08-21 10:00:00',NULL,'PENDIENTE'),(215,NULL,'Johanna','2025-08-21 08:30:00',NULL,'2025-08-21 08:30:00',NULL,'PENDIENTE'),(218,NULL,'Camila','2025-08-21 11:00:00',NULL,'2025-08-21 11:00:00',NULL,'PENDIENTE'),(222,NULL,'Yenni Jiménez 3','2025-08-22 14:30:00',NULL,'2025-08-22 14:30:00',NULL,'PENDIENTE'),(223,NULL,'Kate','2025-08-21 17:30:00',NULL,'2025-08-21 17:30:00',NULL,'PENDIENTE'),(224,NULL,'Dahianna','2025-08-21 16:00:00',NULL,'2025-08-21 16:00:00',NULL,'PENDIENTE'),(226,NULL,'Cris 2 resveratrol','2025-08-22 17:30:00',NULL,'2025-08-22 17:30:00',NULL,'PENDIENTE'),(227,NULL,'Rosario 7','2025-08-23 07:00:00',NULL,'2025-08-23 07:00:00',NULL,'PENDIENTE'),(228,NULL,'Diana calidad','2025-08-23 10:00:00',NULL,'2025-08-23 10:00:00',NULL,'PENDIENTE'),(230,NULL,'Faysuri','2025-08-22 10:30:00',NULL,'2025-08-22 10:30:00',NULL,'PENDIENTE'),(233,NULL,'Rosario 8','2025-08-25 06:30:00',NULL,'2025-08-25 06:30:00',NULL,'PENDIENTE'),(234,NULL,'Johanna glúteos 1','2025-08-25 07:30:00',NULL,'2025-08-25 07:30:00',NULL,'PENDIENTE'),(235,NULL,'Faysuri sesión 2','2025-08-23 12:00:00',NULL,'2025-08-23 12:00:00',NULL,'PENDIENTE'),(236,NULL,'Prima Diana 9am sesión 2','2025-08-23 13:00:00',NULL,'2025-08-23 13:00:00',NULL,'PENDIENTE'),(238,NULL,'Rosario 8','2025-08-26 07:30:00',NULL,'2025-08-26 07:30:00',NULL,'PENDIENTE'),(239,NULL,'María José Valoración','2025-08-22 18:30:00',NULL,'2025-08-22 18:30:00',NULL,'PENDIENTE'),(240,NULL,'Estudiar','2025-08-25 08:30:00',NULL,'2025-08-25 08:30:00',NULL,'PENDIENTE'),(241,NULL,'Estudiar','2025-08-25 10:00:00',NULL,'2025-08-25 10:00:00',NULL,'PENDIENTE'),(242,NULL,'Estudiar','2025-08-25 11:30:00',NULL,'2025-08-25 11:30:00',NULL,'PENDIENTE'),(244,NULL,'Yansi','2025-08-25 16:30:00',NULL,'2025-08-25 16:30:00',NULL,'PENDIENTE'),(246,NULL,'Valentina depilación','2025-08-26 09:00:00',NULL,'2025-08-26 09:00:00',NULL,'PENDIENTE'),(248,NULL,'Cesar relajante','2025-08-27 15:00:00',NULL,'2025-08-27 15:00:00',NULL,'PENDIENTE'),(249,NULL,'Faysuri','2025-08-25 15:00:00',NULL,'2025-08-25 15:00:00',NULL,'PENDIENTE'),(250,NULL,'Diana sesión 3','2025-08-25 13:30:00',NULL,'2025-08-25 13:30:00',NULL,'PENDIENTE'),(252,NULL,'Yenni sesión 4','2025-08-25 14:30:00',NULL,'2025-08-25 14:30:00',NULL,'PENDIENTE'),(253,NULL,'Sandra limpieza + plasma','2025-08-25 17:30:00',NULL,'2025-08-25 17:30:00',NULL,'PENDIENTE'),(254,NULL,'Curso suero','2025-08-28 10:00:00',NULL,'2025-08-28 10:00:00',NULL,'PENDIENTE'),(255,NULL,'Curso suero','2025-08-28 11:00:00',NULL,'2025-08-28 11:00:00',NULL,'PENDIENTE'),(256,NULL,'Rosario 9','2025-08-27 06:30:00',NULL,'2025-08-27 06:30:00',NULL,'PENDIENTE'),(260,NULL,'Diana prima 4','2025-08-26 13:00:00',NULL,'2025-08-26 13:00:00',NULL,'PENDIENTE'),(261,NULL,'Yenni 5','2025-08-26 14:00:00',NULL,'2025-08-26 14:00:00',NULL,'PENDIENTE'),(262,NULL,'Faisury 4','2025-08-26 15:00:00',NULL,'2025-08-26 15:00:00',NULL,'PENDIENTE'),(264,NULL,'Camila','2025-08-26 10:00:00',NULL,'2025-08-26 10:00:00',NULL,'PENDIENTE'),(265,NULL,'Angeline','2025-08-26 18:00:00',NULL,'2025-08-26 18:00:00',NULL,'PENDIENTE'),(266,NULL,'Johanna 2','2025-08-27 07:30:00',NULL,'2025-08-27 07:30:00',NULL,'PENDIENTE'),(269,NULL,'Cris resveratrol 3','2025-08-29 17:00:00',NULL,'2025-08-29 17:00:00',NULL,'PENDIENTE'),(271,NULL,'Dahianna pelling 1','2025-08-28 18:00:00',NULL,'2025-08-28 18:00:00',NULL,'PENDIENTE'),(272,NULL,'No agendar','2025-08-30 07:00:00',NULL,'2025-08-30 07:00:00',NULL,'PENDIENTE'),(273,NULL,'Cita oftalmo','2025-08-29 10:00:00',NULL,'2025-08-29 10:00:00',NULL,'PENDIENTE'),(274,NULL,'Salida Cartago','2025-08-29 08:00:00',NULL,'2025-08-29 08:00:00',NULL,'PENDIENTE'),(277,NULL,'Faisury 5','2025-08-27 10:00:00',NULL,'2025-08-27 10:00:00',NULL,'PENDIENTE'),(281,NULL,'Prima Diana 5','2025-08-28 13:30:00',NULL,'2025-08-28 13:30:00',NULL,'PENDIENTE'),(283,NULL,'Faisury 6','2025-08-28 15:00:00',NULL,'2025-08-28 15:00:00',NULL,'PENDIENTE'),(284,NULL,'Camila 3 y 30','2025-08-28 16:00:00',NULL,'2025-08-28 16:00:00',NULL,'PENDIENTE'),(285,NULL,'Sebastián depilación','2025-08-29 15:30:00',NULL,'2025-08-29 15:30:00',NULL,'PENDIENTE'),(287,NULL,'Suero resveratrol 3','2025-09-02 14:00:00',NULL,'2025-09-02 14:00:00',NULL,'PENDIENTE'),(288,NULL,'Prima Diana 8','2025-11-04 13:00:00',NULL,'2025-11-04 13:00:00',NULL,'PENDIENTE'),(292,NULL,'Yenni 6','2025-09-01 14:30:00',NULL,'2025-09-01 14:30:00',NULL,'PENDIENTE'),(293,NULL,'Angela. Cauterización','2025-09-01 15:30:00',NULL,'2025-09-01 15:30:00',NULL,'PENDIENTE'),(294,NULL,'Mauro Beto','2025-09-01 17:00:00',NULL,'2025-09-01 17:00:00',NULL,'PENDIENTE'),(296,NULL,'Juliana','2025-09-02 10:00:00',NULL,'2025-09-02 10:00:00',NULL,'PENDIENTE'),(297,NULL,'Prima Diana 6','2025-09-02 13:00:00',NULL,'2025-09-02 13:00:00',NULL,'PENDIENTE'),(298,NULL,'Daniela limpieza +plasma 80.000','2025-09-05 17:00:00',NULL,'2025-09-05 17:00:00',NULL,'PENDIENTE'),(299,NULL,'Fay 7','2025-08-29 16:30:00',NULL,'2025-08-29 16:30:00',NULL,'PENDIENTE'),(300,NULL,'Fay 8','2025-09-02 08:00:00',NULL,'2025-09-02 08:00:00',NULL,'PENDIENTE'),(303,NULL,'Depilación Andrea Martínez','2025-09-02 12:30:00',NULL,'2025-09-02 12:30:00',NULL,'PENDIENTE'),(304,NULL,'Yenni 7 2 y 30','2025-09-02 15:00:00',NULL,'2025-09-02 15:00:00',NULL,'PENDIENTE'),(305,NULL,'Limpieza Elena','2025-09-02 16:00:00',NULL,'2025-09-02 16:00:00',NULL,'PENDIENTE'),(307,NULL,'Camila','2025-09-02 09:00:00',NULL,'2025-09-02 09:00:00',NULL,'PENDIENTE'),(308,NULL,'Ariana','2025-09-02 17:00:00',NULL,'2025-09-02 17:00:00',NULL,'PENDIENTE'),(309,NULL,'Diana calidad','2025-09-02 18:00:00',NULL,'2025-09-02 18:00:00',NULL,'PENDIENTE'),(310,NULL,'Johanna 3','2025-09-03 07:00:00',NULL,'2025-09-03 07:00:00',NULL,'PENDIENTE'),(311,NULL,'Fay 9','2025-09-03 10:00:00',NULL,'2025-09-03 10:00:00',NULL,'PENDIENTE'),(313,NULL,'Prima Diana 7','2025-09-03 13:00:00',NULL,'2025-09-03 13:00:00',NULL,'PENDIENTE'),(314,NULL,'Yenni 8','2025-09-03 14:00:00',NULL,'2025-09-03 14:00:00',NULL,'PENDIENTE'),(315,NULL,'Dahianna peeling 2','2025-09-03 17:00:00',NULL,'2025-09-03 17:00:00',NULL,'PENDIENTE'),(317,NULL,'Juliana 1 Ininia paquete','2025-09-04 08:30:00',NULL,'2025-09-04 08:30:00',NULL,'PENDIENTE'),(318,NULL,'Hermana de Yuri inicia paquete 380','2025-09-09 08:00:00',NULL,'2025-09-09 08:00:00',NULL,'PENDIENTE'),(320,NULL,'Johanna 4','2025-09-04 07:00:00',NULL,'2025-09-04 07:00:00',NULL,'PENDIENTE'),(323,NULL,'Diana prima 8','2025-09-04 13:30:00',NULL,'2025-09-04 13:30:00',NULL,'PENDIENTE'),(324,NULL,'Yenni 9','2025-09-04 14:30:00',NULL,'2025-09-04 14:30:00',NULL,'PENDIENTE'),(325,NULL,'Camila masaje más depilación','2025-09-04 16:00:00',NULL,'2025-09-04 16:00:00',NULL,'PENDIENTE'),(326,NULL,'Diana 4','2025-09-04 18:00:00',NULL,'2025-09-04 18:00:00',NULL,'PENDIENTE'),(327,NULL,'Ariana 10','2025-09-04 19:00:00',NULL,'2025-09-04 19:00:00',NULL,'PENDIENTE'),(328,NULL,'Katherine 2','2025-09-04 11:00:00',NULL,'2025-09-04 11:00:00',NULL,'PENDIENTE'),(329,NULL,'Curso','2025-09-05 10:00:00',NULL,'2025-09-05 10:00:00',NULL,'PENDIENTE'),(330,NULL,'Verónica Ramírez inicia paquete','2025-09-05 11:00:00',NULL,'2025-09-05 11:00:00',NULL,'PENDIENTE'),(331,NULL,'Curso','2025-09-05 09:00:00',NULL,'2025-09-05 09:00:00',NULL,'PENDIENTE'),(332,NULL,'Johanna 6','2025-09-05 07:00:00',NULL,'2025-09-05 07:00:00',NULL,'PENDIENTE'),(335,NULL,'Yenni 10','2025-09-05 14:30:00',NULL,'2025-09-05 14:30:00',NULL,'PENDIENTE'),(336,NULL,'Cami','2025-09-05 15:30:00',NULL,'2025-09-05 15:30:00',NULL,'PENDIENTE'),(337,NULL,'Diana.','2025-09-05 18:30:00',NULL,'2025-09-05 18:30:00',NULL,'PENDIENTE'),(338,NULL,'Juliana 3','2025-09-06 09:00:00',NULL,'2025-09-06 09:00:00',NULL,'PENDIENTE'),(339,NULL,'Juliana depilación','2025-09-06 10:00:00',NULL,'2025-09-06 10:00:00',NULL,'PENDIENTE'),(340,NULL,'Juliana 2','2025-09-05 16:30:00',NULL,'2025-09-05 16:30:00',NULL,'PENDIENTE'),(341,NULL,'Inicia María 4 y 20 pm reductor','2025-09-08 16:30:00',NULL,'2025-09-08 16:30:00',NULL,'PENDIENTE'),(343,NULL,'Johanna 7','2025-09-08 07:00:00',NULL,'2025-09-08 07:00:00',NULL,'PENDIENTE'),(344,NULL,'Verónica 3','2025-09-08 11:00:00',NULL,'2025-09-08 11:00:00',NULL,'PENDIENTE'),(345,NULL,'Camila','2025-09-08 15:30:00',NULL,'2025-09-08 15:30:00',NULL,'PENDIENTE'),(347,NULL,'Prima Diana 9','2025-09-08 13:30:00',NULL,'2025-09-08 13:30:00',NULL,'PENDIENTE'),(348,NULL,'Esposo 1','2025-09-08 18:00:00',NULL,'2025-09-08 18:00:00',NULL,'PENDIENTE'),(349,NULL,'Juliana 4','2025-09-08 08:00:00',NULL,'2025-09-08 08:00:00',NULL,'PENDIENTE'),(350,NULL,'Verónica 4','2025-09-09 11:00:00',NULL,'2025-09-09 11:00:00',NULL,'PENDIENTE'),(351,NULL,'Cami','2025-09-09 15:00:00',NULL,'2025-09-09 15:00:00',NULL,'PENDIENTE'),(352,NULL,'Prima Diana','2025-09-09 13:00:00',NULL,'2025-09-09 13:00:00',NULL,'PENDIENTE'),(353,NULL,'María 2','2025-09-09 14:00:00',NULL,'2025-09-09 14:00:00',NULL,'PENDIENTE'),(354,NULL,'Mi esposo 2','2025-09-09 18:00:00',NULL,'2025-09-09 18:00:00',NULL,'PENDIENTE'),(355,NULL,'Katherine depilación + 3 masaje','2025-09-09 16:00:00',NULL,'2025-09-09 16:00:00',NULL,'PENDIENTE'),(357,NULL,'Juliana','2025-09-09 07:30:00',NULL,'2025-09-09 07:30:00',NULL,'PENDIENTE'),(358,NULL,'Johanna 8','2025-09-10 07:00:00',NULL,'2025-09-10 07:00:00',NULL,'PENDIENTE'),(361,NULL,'Alexandra depilación','2025-09-09 17:00:00',NULL,'2025-09-09 17:00:00',NULL,'PENDIENTE'),(363,NULL,'Verónica 5','2025-09-10 11:00:00',NULL,'2025-09-10 11:00:00',NULL,'PENDIENTE'),(364,NULL,'Kate 4','2025-09-10 12:00:00',NULL,'2025-09-10 12:00:00',NULL,'PENDIENTE'),(365,NULL,'Cami','2025-09-10 14:00:00',NULL,'2025-09-10 14:00:00',NULL,'PENDIENTE'),(366,NULL,'Dahia depilación','2025-09-10 18:00:00',NULL,'2025-09-10 18:00:00',NULL,'PENDIENTE'),(369,NULL,'Kate 5','2025-09-11 11:00:00',NULL,'2025-09-11 11:00:00',NULL,'PENDIENTE'),(372,NULL,'Prima Diana 11','2025-09-11 13:30:00',NULL,'2025-09-11 13:30:00',NULL,'PENDIENTE'),(376,NULL,'María 3','2025-09-10 15:00:00',NULL,'2025-09-10 15:00:00',NULL,'PENDIENTE'),(377,NULL,'María 4','2025-09-11 16:30:00',NULL,'2025-09-11 16:30:00',NULL,'PENDIENTE'),(378,NULL,'Cris NAD y depilación','2025-09-15 17:00:00',NULL,'2025-09-15 17:00:00',NULL,'PENDIENTE'),(379,NULL,'Yessica 2/1','2025-09-10 08:00:00',NULL,'2025-09-10 08:00:00',NULL,'PENDIENTE'),(380,NULL,'Yesica 3 /1','2025-09-11 08:00:00',NULL,'2025-09-11 08:00:00',NULL,'PENDIENTE'),(381,NULL,'Verónica 6','2025-09-12 11:00:00',NULL,'2025-09-12 11:00:00',NULL,'PENDIENTE'),(382,NULL,'Uñas','2025-09-12 13:30:00',NULL,'2025-09-12 13:30:00',NULL,'PENDIENTE'),(383,NULL,'Kate','2025-09-12 10:00:00',NULL,'2025-09-12 10:00:00',NULL,'PENDIENTE'),(385,NULL,'Johanna 9','2025-09-12 07:00:00',NULL,'2025-09-12 07:00:00',NULL,'PENDIENTE'),(389,NULL,'Ana depilacion','2025-09-13 08:00:00',NULL,'2025-09-13 08:00:00',NULL,'PENDIENTE'),(390,NULL,'Curso','2025-09-13 09:00:00',NULL,'2025-09-13 09:00:00',NULL,'PENDIENTE'),(391,NULL,'Pao suero','2025-09-12 15:00:00',NULL,'2025-09-12 15:00:00',NULL,'PENDIENTE'),(392,NULL,'María  5','2025-09-12 16:00:00',NULL,'2025-09-12 16:00:00',NULL,'PENDIENTE'),(393,NULL,'Mamá de late kenacort','2025-09-12 17:00:00',NULL,'2025-09-12 17:00:00',NULL,'PENDIENTE'),(394,NULL,'Mi esposo 4','2025-09-12 18:00:00',NULL,'2025-09-12 18:00:00',NULL,'PENDIENTE'),(395,NULL,'Cami','2025-09-12 09:00:00',NULL,'2025-09-12 09:00:00',NULL,'PENDIENTE'),(396,NULL,'Leydi Depilación','2025-09-17 15:00:00',NULL,'2025-09-17 15:00:00',NULL,'PENDIENTE'),(397,NULL,'Pao depilación','2025-09-13 07:30:00',NULL,'2025-09-13 07:30:00',NULL,'PENDIENTE'),(398,NULL,'Paquete NAD 1 Paola','2025-09-16 10:00:00',NULL,'2025-09-16 10:00:00',NULL,'PENDIENTE'),(399,NULL,'Hija de Sara sierra limpieza niña 15 años','2025-09-15 16:00:00',NULL,'2025-09-15 16:00:00',NULL,'PENDIENTE'),(402,NULL,'Concepción facial','2025-09-19 17:00:00',NULL,'2025-09-19 17:00:00',NULL,'PENDIENTE'),(403,NULL,'Johanna 10','2025-09-15 07:00:00',NULL,'2025-09-15 07:00:00',NULL,'PENDIENTE'),(404,NULL,'Yessica 4-2','2025-09-15 08:00:00',NULL,'2025-09-15 08:00:00',NULL,'PENDIENTE'),(406,NULL,'Prima Diana 12','2025-09-15 13:30:00',NULL,'2025-09-15 13:30:00',NULL,'PENDIENTE'),(407,NULL,'Esposo 5','2025-09-15 18:00:00',NULL,'2025-09-15 18:00:00',NULL,'PENDIENTE'),(408,NULL,'Suero mecánico','2025-09-15 19:00:00',NULL,'2025-09-15 19:00:00',NULL,'PENDIENTE'),(409,NULL,'Juliana 6','2025-09-15 09:00:00',NULL,'2025-09-15 09:00:00',NULL,'PENDIENTE'),(410,NULL,'Cita odontologia','2025-09-16 17:00:00',NULL,'2025-09-16 17:00:00',NULL,'PENDIENTE'),(416,NULL,'Post Qx Maryuri','2025-09-16 14:30:00',NULL,'2025-09-16 14:30:00',NULL,'PENDIENTE'),(417,NULL,'Verónica 7','2025-09-16 11:00:00',NULL,'2025-09-16 11:00:00',NULL,'PENDIENTE'),(418,NULL,'María 7','2025-09-16 16:00:00',NULL,'2025-09-16 16:00:00',NULL,'PENDIENTE'),(420,NULL,'Pao NAD 2','2025-09-23 10:00:00',NULL,'2025-09-23 10:00:00',NULL,'PENDIENTE'),(421,NULL,'Cita calza Santy','2025-09-25 15:30:00',NULL,'2025-09-25 15:30:00',NULL,'PENDIENTE'),(422,NULL,'Verónica 8','2025-09-17 10:00:00',NULL,'2025-09-17 10:00:00',NULL,'PENDIENTE'),(423,NULL,'Maryuri 2','2025-09-17 11:00:00',NULL,'2025-09-17 11:00:00',NULL,'PENDIENTE'),(425,NULL,'María 8','2025-09-17 16:00:00',NULL,'2025-09-17 16:00:00',NULL,'PENDIENTE'),(426,NULL,'Diana 13','2025-09-17 13:30:00',NULL,'2025-09-17 13:30:00',NULL,'PENDIENTE'),(427,NULL,'Maryuri 3','2025-09-18 13:30:00',NULL,'2025-09-18 13:30:00',NULL,'PENDIENTE'),(428,NULL,'Luz Karime','2025-09-18 17:00:00',NULL,'2025-09-18 17:00:00',NULL,'PENDIENTE'),(429,NULL,'Diana 14','2025-09-19 13:30:00',NULL,'2025-09-19 13:30:00',NULL,'PENDIENTE'),(430,NULL,'Maryuri 4','2025-09-19 14:30:00',NULL,'2025-09-19 14:30:00',NULL,'PENDIENTE'),(431,NULL,'María 9','2025-09-19 16:00:00',NULL,'2025-09-19 16:00:00',NULL,'PENDIENTE'),(432,NULL,'Yessica 4/2','2025-09-19 09:00:00',NULL,'2025-09-19 09:00:00',NULL,'PENDIENTE'),(433,NULL,'Maryuri 5','2025-09-20 07:00:00',NULL,'2025-09-20 07:00:00',NULL,'PENDIENTE'),(434,NULL,'Dahianna','2025-09-20 12:00:00',NULL,'2025-09-20 12:00:00',NULL,'PENDIENTE'),(435,NULL,'Limpieza novio de pao','2025-09-23 14:00:00',NULL,'2025-09-23 14:00:00',NULL,'PENDIENTE'),(437,NULL,'Verónica 9','2025-09-22 09:00:00',NULL,'2025-09-22 09:00:00',NULL,'PENDIENTE'),(438,NULL,'Maryuri 6','2025-09-22 13:30:00',NULL,'2025-09-22 13:30:00',NULL,'PENDIENTE'),(439,NULL,'Diana 15','2025-09-22 14:30:00',NULL,'2025-09-22 14:30:00',NULL,'PENDIENTE'),(440,NULL,'María 10','2025-09-22 16:00:00',NULL,'2025-09-22 16:00:00',NULL,'PENDIENTE'),(441,NULL,'Verónica 10','2025-09-23 09:00:00',NULL,'2025-09-23 09:00:00',NULL,'PENDIENTE'),(444,NULL,'Diana prima 16','2025-09-23 15:00:00',NULL,'2025-09-23 15:00:00',NULL,'PENDIENTE'),(445,NULL,'Fay limpieza + plasma','2025-09-23 11:00:00',NULL,'2025-09-23 11:00:00',NULL,'PENDIENTE'),(446,NULL,'Maryuri 7','2025-09-23 07:00:00',NULL,'2025-09-23 07:00:00',NULL,'PENDIENTE'),(447,NULL,'Maryuri 8','2025-09-24 07:30:00',NULL,'2025-09-24 07:30:00',NULL,'PENDIENTE'),(448,NULL,'Regalo María','2025-09-23 17:00:00',NULL,'2025-09-23 17:00:00',NULL,'PENDIENTE'),(449,NULL,'Faisury','2025-09-24 10:30:00',NULL,'2025-09-24 10:30:00',NULL,'PENDIENTE'),(450,NULL,'Verónica','2025-09-24 09:00:00',NULL,'2025-09-24 09:00:00',NULL,'PENDIENTE'),(451,NULL,'Hermana de Mafe limpieza pago','2025-09-29 10:00:00',NULL,'2025-09-29 10:00:00',NULL,'PENDIENTE'),(453,NULL,'Maryuri suero','2025-09-25 08:30:00',NULL,'2025-09-25 08:30:00',NULL,'PENDIENTE'),(454,NULL,'Maryuri masaje  9','2025-09-25 07:30:00',NULL,'2025-09-25 07:30:00',NULL,'PENDIENTE'),(455,NULL,'Mamá de Maryuri suero','2025-09-25 09:30:00',NULL,'2025-09-25 09:30:00',NULL,'PENDIENTE'),(456,NULL,'Masaje novio Paola','2025-09-25 14:00:00',NULL,'2025-09-25 14:00:00',NULL,'PENDIENTE'),(459,NULL,'Limpieza sobrino de Jorge novio Pao','2025-09-25 11:00:00',NULL,'2025-09-25 11:00:00',NULL,'PENDIENTE'),(460,NULL,'Limpieza laura - pao','2025-09-26 10:00:00',NULL,'2025-09-26 10:00:00',NULL,'PENDIENTE'),(464,NULL,'Fay inicia pqt x12','2025-09-26 08:00:00',NULL,'2025-09-26 08:00:00',NULL,'PENDIENTE'),(466,NULL,'Consuelo la villa Cauterización 40.','2025-09-27 10:00:00',NULL,'2025-09-27 10:00:00',NULL,'PENDIENTE'),(467,NULL,'Jorge novio Pao sesión 1','2025-09-26 11:00:00',NULL,'2025-09-26 11:00:00',NULL,'PENDIENTE'),(468,NULL,'Natalia inicia 1','2025-09-26 17:30:00',NULL,'2025-09-26 17:30:00',NULL,'PENDIENTE'),(469,NULL,'Maryuri 10','2025-09-26 13:30:00',NULL,'2025-09-26 13:30:00',NULL,'PENDIENTE'),(470,NULL,'Juliana limpieza','2025-09-26 15:00:00',NULL,'2025-09-26 15:00:00',NULL,'PENDIENTE'),(472,NULL,'Limpieza javier y Yuli','2025-09-30 10:00:00',NULL,'2025-09-30 10:00:00',NULL,'PENDIENTE'),(473,NULL,'Limpieza Javier y Yuli','2025-09-30 11:00:00',NULL,'2025-09-30 11:00:00',NULL,'PENDIENTE'),(474,NULL,'Pao limpieza y nad','2025-10-01 10:00:00',NULL,'2025-10-01 10:00:00',NULL,'PENDIENTE'),(475,NULL,'Jorge sesión 2 /1','2025-09-27 08:00:00',NULL,'2025-09-27 08:00:00',NULL,'PENDIENTE'),(476,NULL,'Maryuri 11','2025-09-27 13:30:00',NULL,'2025-09-27 13:30:00',NULL,'PENDIENTE'),(477,NULL,'Yessica hermana Yuri','2025-09-27 11:00:00',NULL,'2025-09-27 11:00:00',NULL,'PENDIENTE'),(478,NULL,'Natalia 2','2025-09-27 09:00:00',NULL,'2025-09-27 09:00:00',NULL,'PENDIENTE'),(481,NULL,'Kate 1','2025-09-29 15:30:00',NULL,'2025-09-29 15:30:00',NULL,'PENDIENTE'),(483,NULL,'Fay 2','2025-09-29 08:30:00',NULL,'2025-09-29 08:30:00',NULL,'PENDIENTE'),(485,NULL,'Maryuri 11','2025-09-29 13:00:00',NULL,'2025-09-29 13:00:00',NULL,'PENDIENTE'),(487,NULL,'Diana prima 17','2025-09-29 14:00:00',NULL,'2025-09-29 14:00:00',NULL,'PENDIENTE'),(488,NULL,'Jorge 2 y 30 sesión 3/2','2025-09-29 15:00:00',NULL,'2025-09-29 15:00:00',NULL,'PENDIENTE'),(489,NULL,'Jorge','2025-09-30 07:00:00',NULL,'2025-09-30 07:00:00',NULL,'PENDIENTE'),(492,NULL,'Paula Andrea','2025-09-30 17:00:00',NULL,'2025-09-30 17:00:00',NULL,'PENDIENTE'),(493,NULL,'Maryuri 12 y nad 1','2025-09-30 08:00:00',NULL,'2025-09-30 08:00:00',NULL,'PENDIENTE'),(494,NULL,'Diana 18','2025-09-30 13:30:00',NULL,'2025-09-30 13:30:00',NULL,'PENDIENTE'),(495,NULL,'Amiga Diana 1','2025-09-30 16:00:00',NULL,'2025-09-30 16:00:00',NULL,'PENDIENTE'),(496,NULL,'Natalia 3','2025-09-30 18:00:00',NULL,'2025-09-30 18:00:00',NULL,'PENDIENTE'),(497,NULL,'4 pm Kate depilación','2025-09-30 15:00:00',NULL,'2025-09-30 15:00:00',NULL,'PENDIENTE'),(498,NULL,'9 :45 Kate masaje 2','2025-09-30 09:30:00',NULL,'2025-09-30 09:30:00',NULL,'PENDIENTE'),(500,NULL,'Paula Andrea limpieza','2025-10-02 17:00:00',NULL,'2025-10-02 17:00:00',NULL,'PENDIENTE'),(501,NULL,'Pao NAD 3 + limpieza','2025-10-02 10:00:00',NULL,'2025-10-02 10:00:00',NULL,'PENDIENTE'),(503,NULL,'Mónica 2','2025-10-02 16:00:00',NULL,'2025-10-02 16:00:00',NULL,'PENDIENTE'),(504,NULL,'Jorge 4/3','2025-10-06 08:00:00',NULL,'2025-10-06 08:00:00',NULL,'PENDIENTE'),(505,NULL,'Kate','2025-10-02 15:00:00',NULL,'2025-10-02 15:00:00',NULL,'PENDIENTE'),(506,NULL,'Valeria rojas peeling','2025-10-04 10:00:00',NULL,'2025-10-04 10:00:00',NULL,'PENDIENTE'),(507,NULL,'Cris','2025-10-04 11:00:00',NULL,'2025-10-04 11:00:00',NULL,'PENDIENTE'),(508,NULL,'Kate 4','2025-10-03 14:30:00',NULL,'2025-10-03 14:30:00',NULL,'PENDIENTE'),(510,NULL,'Diana','2025-10-06 13:30:00',NULL,'2025-10-06 13:30:00',NULL,'PENDIENTE'),(511,NULL,'Mónica 3','2025-10-06 14:30:00',NULL,'2025-10-06 14:30:00',NULL,'PENDIENTE'),(512,NULL,'Marcela Vagi spa','2025-10-11 08:00:00',NULL,'2025-10-11 08:00:00',NULL,'PENDIENTE'),(513,NULL,'Leydi Johanna','2025-10-04 08:30:00',NULL,'2025-10-04 08:30:00',NULL,'PENDIENTE'),(514,NULL,'Maryuri 2','2025-10-04 07:00:00',NULL,'2025-10-04 07:00:00',NULL,'PENDIENTE'),(515,NULL,'Ximena inicia (1)','2025-10-04 08:00:00',NULL,'2025-10-04 08:00:00',NULL,'PENDIENTE'),(516,NULL,'Maryuri 1','2025-10-03 13:30:00',NULL,'2025-10-03 13:30:00',NULL,'PENDIENTE'),(517,NULL,'Kate','2025-10-06 09:00:00',NULL,'2025-10-06 09:00:00',NULL,'PENDIENTE'),(518,NULL,'Katerine depilación','2025-10-06 16:00:00',NULL,'2025-10-06 16:00:00',NULL,'PENDIENTE'),(519,NULL,'Milena 1','2025-10-04 12:00:00',NULL,'2025-10-04 12:00:00',NULL,'PENDIENTE'),(520,NULL,'Milena 3','2025-10-06 10:00:00',NULL,'2025-10-06 10:00:00',NULL,'PENDIENTE'),(521,NULL,'Maryuri depilación','2025-10-06 17:00:00',NULL,'2025-10-06 17:00:00',NULL,'PENDIENTE'),(522,NULL,'Maryuri','2025-10-06 13:00:00',NULL,'2025-10-06 13:00:00',NULL,'PENDIENTE'),(524,NULL,'Ximena 5 pm','2025-10-06 18:00:00',NULL,'2025-10-06 18:00:00',NULL,'PENDIENTE'),(525,NULL,'Natalia 6 pm','2025-10-06 19:00:00',NULL,'2025-10-06 19:00:00',NULL,'PENDIENTE'),(528,NULL,'Milena 4','2025-10-07 10:00:00',NULL,'2025-10-07 10:00:00',NULL,'PENDIENTE'),(531,NULL,'Maryuri','2025-10-07 07:30:00',NULL,'2025-10-07 07:30:00',NULL,'PENDIENTE'),(533,NULL,'Kate 5','2025-10-07 14:00:00',NULL,'2025-10-07 14:00:00',NULL,'PENDIENTE'),(534,NULL,'Mónica 3','2025-10-07 15:00:00',NULL,'2025-10-07 15:00:00',NULL,'PENDIENTE'),(535,NULL,'Ximena 2','2025-10-07 17:00:00',NULL,'2025-10-07 17:00:00',NULL,'PENDIENTE'),(537,NULL,'Nata 3','2025-10-03 18:00:00',NULL,'2025-10-03 18:00:00',NULL,'PENDIENTE'),(538,NULL,'Nata 4','2025-10-07 18:00:00',NULL,'2025-10-07 18:00:00',NULL,'PENDIENTE'),(539,NULL,'Pao NAD 4','2025-10-08 09:00:00',NULL,'2025-10-08 09:00:00',NULL,'PENDIENTE'),(541,NULL,'Milena 5','2025-10-08 10:00:00',NULL,'2025-10-08 10:00:00',NULL,'PENDIENTE'),(542,NULL,'Mónica 4','2025-10-08 14:00:00',NULL,'2025-10-08 14:00:00',NULL,'PENDIENTE'),(543,NULL,'Andrea yaneth inicia 1','2025-10-08 15:00:00',NULL,'2025-10-08 15:00:00',NULL,'PENDIENTE'),(544,NULL,'Ximena 3','2025-10-08 16:00:00',NULL,'2025-10-08 16:00:00',NULL,'PENDIENTE'),(545,NULL,'Natalia','2025-10-08 18:00:00',NULL,'2025-10-08 18:00:00',NULL,'PENDIENTE'),(546,NULL,'Aleja didi','2025-10-09 08:30:00',NULL,'2025-10-09 08:30:00',NULL,'PENDIENTE'),(547,NULL,'Milena 6','2025-10-09 10:00:00',NULL,'2025-10-09 10:00:00',NULL,'PENDIENTE'),(550,NULL,'Ximena 4','2025-10-09 17:00:00',NULL,'2025-10-09 17:00:00',NULL,'PENDIENTE'),(551,NULL,'Mónica 5','2025-10-09 14:00:00',NULL,'2025-10-09 14:00:00',NULL,'PENDIENTE'),(552,NULL,'Kate 6','2025-10-09 15:00:00',NULL,'2025-10-09 15:00:00',NULL,'PENDIENTE'),(553,NULL,'Kate 7','2025-10-10 09:00:00',NULL,'2025-10-10 09:00:00',NULL,'PENDIENTE'),(554,NULL,'Milena 7','2025-10-10 10:00:00',NULL,'2025-10-10 10:00:00',NULL,'PENDIENTE'),(556,NULL,'Mónica 6','2025-10-10 08:00:00',NULL,'2025-10-10 08:00:00',NULL,'PENDIENTE'),(558,NULL,'Kate 8','2025-10-14 15:00:00',NULL,'2025-10-14 15:00:00',NULL,'PENDIENTE'),(559,NULL,'Isabel facial','2025-10-15 08:00:00',NULL,'2025-10-15 08:00:00',NULL,'PENDIENTE');

--
-- 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(25) DEFAULT NULL,
  `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',
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `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(25) DEFAULT NULL,
  `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',
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `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(25) DEFAULT NULL,
  `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',
  `domicilio` int DEFAULT '0',
  `enviaraproduccion` int DEFAULT '0',
  `pv` varchar(25) DEFAULT 'KALDI',
  `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 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `cargos` (`id`, `cargo`, `cc`, `pv`) VALUES (3,'MESERO',2,'KALDI'),(8,'',2,'KALDI');

--
-- 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 DEFAULT CHARSET=utf8mb3;

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


--
-- Table structure for table `cc`
--

CREATE TABLE `cc` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `nombrecc` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `cc`
--

INSERT INTO `cc` (`id`, `nombrecc`) VALUES (19,'MERCADO LIBRE G NATECH'),(22,'PAGINA WEB'),(23,'RAPPI NATECH'),(24,'MERCADO LIBRE G COMERCIA'),(25,'LUEGO PAGO'),(26,'RAPPI G COMERCIA'),(27,'ADDI'),(28,'FALABELLA G COMERCIA');

--
-- 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,
  `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',
  `endpoint_taxxa` varchar(200) DEFAULT 'https://demo1.taxxa.co/api.djson',
  `prefijonc` varchar(2) DEFAULT NULL,
  `token_taxxa` varchar(150) DEFAULT NULL,
  `prefijofe` varchar(5) 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',
  `pv` varchar(25) DEFAULT 'texasburgers',
  `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,
  `usuarioTaxxa` varchar(150) DEFAULT NULL,
  `claveTaxxa` varchar(15) 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,
  `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 '',
  `parking_moto` int DEFAULT '3000',
  `firmadigital` text,
  `clavefirmadigital` varchar(50) DEFAULT NULL,
  `parking_carro` int DEFAULT '3000',
  `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=4 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`, `codigodepartamento`, `codigomunicipio`, `ciudad`, `departamento`, `id_tipo_persona`, `tipo_identificacion`, `endpoint_taxxa`, `prefijonc`, `token_taxxa`, `prefijofe`, `puedeusar`, `descuento`, `descuentodeldia`, `alerta`, `hastafe`, `fechahastafe`, `satelitecallcenter`, `tituloimpuestos`, `nombreimpuesto`, `pv`, `zonapostal`, `prefijodocequivalente`, `responsabilidades`, `tipo_persona`, `resdianfe`, `desdefe`, `fechafe`, `usuarioTaxxa`, `claveTaxxa`, `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`, `desdeposelectronico`, `hastaposelectronico`, `fechaposelectronico`, `fechafinposelectronico`, `prefijope`, `fechahastape`, `registromercantil`, `digitodeverificacion`, `tokenapidian`, `idsoftware`, `parking_moto`, `firmadigital`, `clavefirmadigital`, `parking_carro`, `modulo`, `SoftwareID`, `clavefirma`, `nombrecomercialcc`, `porcentaje_ganancia_en_venta`, `snotetop`) VALUES (2,2,32,'','Recibo',0,0,0,2,'','76270357','CENTRO DE ESTETICA EL ENCANTO','2020-12-24 19:28:24','JAVIER FERNANDEZ ZAPATA',1,1,'','PERSONA NATURAL','GRACIAS POR SU VISITA',0,'18764070336005',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Tienes 10 facturas pendientes por tramitar a la Dian',NULL,NULL,10,'12',NULL,NULL,NULL,'66','66001','','VALLE DEL CAUCA',2,'NIT','https://demo1.taxxa.co/api2.djson',NULL,NULL,NULL,2,0,0,NULL,NULL,NULL,'SELECCIONE','','IMPOCONSUMO','texasburgers','','DSE','O-49','person',NULL,NULL,NULL,NULL,NULL,NULL,0,0,_binary '',NULL,NULL,'2025-10-30 01:17:47','2025-10-22',NULL,'total',NULL,NULL,11,'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,1,NULL,1,500,'2024-05-29','2026-05-29','PT1','2026-05-29',NULL,NULL,NULL,'',2500,NULL,NULL,3000,1,NULL,NULL,'',NULL,NULL),(3,2,32,'Cra 14  9-07','FACTURA DE VENTA',0,0,0,2,'','901402281','FERRE COSTOS LA 14','2020-12-24 19:28:24','JUAN ALARCON',1,1,'raulotalvaro@gmail.com','PERSONA NATURAL','GRACIAS POR SU COMPRA la propina es voluntaria',0,'18764070336005',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Tienes 10 facturas pendientes por tramitar a la Dian',NULL,NULL,10,'12',NULL,NULL,NULL,'66','66001','PEREIRA','RISARALDA',2,'NIT','https://demo1.taxxa.co/api2.djson',NULL,NULL,NULL,2,0,0,NULL,NULL,NULL,'SELECCIONE','','IMPOCONSUMO','texasburgers','660001','DSE','O-49','person',NULL,NULL,NULL,NULL,NULL,NULL,0,0,_binary '',NULL,NULL,'2025-10-30 01:17:47','2025-10-22',NULL,'total',NULL,NULL,5,'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,1,NULL,1,500,'2024-05-29','2026-05-29','PT1','2026-05-29',NULL,NULL,NULL,'',2500,NULL,NULL,3000,1,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 DEFAULT CHARSET=utf8mb3;

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


--
-- 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 'KALDI',
  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 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `idx_ciudad` (`ciudad`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `ciudades` (`id`, `ciudad`, `cc`, `codigodepartamento`, `departamento`, `codigociudad`, `codigopostal`, `pv`) VALUES (1,'SALENTO',2,'63','QUINDIO','63690','631020','KALDI'),(2,'POPAYAN ',2,'19','CAUCA','19001','190001','KALDI'),(3,'PEREIRA',2,'66','RISARALDA','66001','660001','KALDI'),(5,'IBAGUE',2,'73','TOLIMA','73001','730010','KALDI'),(6,'MEDELLIN',2,'05','ANTIOQUIA','05001','050001','KALDI'),(7,'CUCUTA',2,'54','NORTE DE SANTANDER','54001','540011','KALDI'),(10,'CHIA',2,'25','CUNDINAMARCA','25175','250001','KALDI'),(13,'ARMENIA',2,'63','QUINDIO','63001','630003','KALDI'),(15,'BOGOTA D.C',2,'11','BOGOTA  D.C','11001','110011','KALDI'),(16,'CALI',2,'76','VALLE DEL CAUCA','76001','760030','KALDI'),(17,'ITAGUI',2,'05','ANTIOQUIA','05360','055411','KALDI'),(18,'YUMBO ',2,'76','VALLE DEL CAUCA ','76892','760501','KALDI'),(19,'CANDELARIA',2,'76','VALLE DEL CAUCA','76130','763570','KALDI'),(20,'ALCALA ',2,'76','VALLE DEL CAUCA ','76020','762040','KALDI'),(21,'QUIBDO',2,'27','CHOCO ','27001','270001','KALDI'),(22,'TENJO',2,'25','CUNDINAMARCA','25779','250201','KALDI'),(23,'MANIZALES',2,'17','CALDAS','17001','170001','KALDI'),(24,'NEIVA',2,'41','HUILA','41001','410010','KALDI'),(25,'NARIÑO',2,'05','PASTO','05483','054840','KALDI'),(26,'CALARCA ',2,'63','QUINDIO ','63130','632001','KALDI'),(27,'SABANETA',2,'05','ANTIOQUIA ','05631','055450','KALDI'),(28,'COTA ',2,'25','CUNDINAMARCA ','25214','250010','KALDI'),(29,'LA ESTRELLA',2,'05','ANTIOQUIA','05380','055460','KALDI'),(30,'BARRANQUILLA ',2,'8','ATLÁNTICO','08001','080001','KALDI'),(31,'PALMIRA',2,'76','VALLE DEL CAUCA ','76520','763531','KALDI');

--
-- 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(25) DEFAULT 'PEREIRA',
  `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(7) DEFAULT '66001',
  `codigodepartamento` varchar(7) DEFAULT '66',
  `codigopostal` varchar(7) DEFAULT '660001',
  `segundonombre` varchar(25) DEFAULT NULL,
  `segundoapellido` varchar(25) DEFAULT NULL,
  `legalidad` int DEFAULT '0',
  `tipo_identificacion` varchar(5) DEFAULT 'CC',
  `razonsocial` varchar(200) DEFAULT NULL,
  `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 'texasburgers',
  `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,
  `tokendispositivo` varchar(250) DEFAULT NULL,
  `diacontacto1` int DEFAULT '0',
  `diacontacto2` int DEFAULT '0',
  `urlfotocliente` varchar(170) 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,
  `ocupacion` varchar(50) DEFAULT NULL,
  `origen_cliente` varchar(3) DEFAULT 'CON',
  `proximallamada` date DEFAULT NULL,
  `idpadre` int DEFAULT '0',
  `responsable` varchar(50) DEFAULT NULL,
  `campovalor_cliente` varchar(25) DEFAULT 'valordeventa',
  `aplicaretencion` int DEFAULT '0',
  `clientes_bloqueados` varchar(150) DEFAULT NULL,
  `puedehacerpedido` int DEFAULT '1',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=19 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`, `segundonombre`, `segundoapellido`, `legalidad`, `tipo_identificacion`, `razonsocial`, `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`, `tokendispositivo`, `diacontacto1`, `diacontacto2`, `urlfotocliente`, `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`, `ocupacion`, `origen_cliente`, `proximallamada`, `idpadre`, `responsable`, `campovalor_cliente`, `aplicaretencion`, `clientes_bloqueados`, `puedehacerpedido`) VALUES (1,'SYSTEM',NULL,NULL,NULL,'',0,'','MZ 1 c 13 Perla del sur','2006-06-11','3117326824','2017-12-20 22:34:05','Pereira','QUINDIO','$1$xgEatvV1$Hkc2Q63sQZbuLulxyZLwq1','ADMINISTRADOR',NULL,NULL,0,'MASCULINO','CC',0,1,1,'NO',0,39000,NULL,NULL,1,1,'','2',8,0,0,0,NULL,NULL,'66001','66','0',NULL,NULL,0,'NIT','',NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers','7t68310josoe272brrp9adaop8',NULL,0,NULL,'hola',NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'45.225.224.36',NULL,_binary '',NULL,NULL,0,0,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','{\"endpoint\":\"https://fcm.googleapis.com/fcm/send/ec8ixJx90-U:APA91bGIfxdD2y46eMr0fPqySCcRD0YfU44w1QlY4HlyhZrOMLnMjueBhSurY-ODiB7Zpsr9UgHuBPm_QmT3q8RGWMb9-LZZgM7sYH9Ytz5Sp70aC8uRZGO4SLQ4E0CSlpwPlqaUVk1b\",\"expirationTime\":null,\"keys\":{\"p256dh\":\"BCehCIq-UnRkArB1w_n95QCjCX2Xfz5XohWpNKEWbvrUsEGygIaq42Fnx-rzvNWwM-7nEkASDjMw_TnENuK-630\",\"auth\":\"EQHrz1JVq2-0c51TyFhtnw\"}}',NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(2,'YULI','',NULL,NULL,'',2,'1116255614','Cra 14  9-07','2050-12-12','','2022-12-06 06:58:59','PEREIRA','RISARALDA','11GrU7qBbvdn6','ADMINISTRADOR','raulotalvaro@gmail.com','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'CONSUMIDOR FINAL','',0,0,NULL,'2',0,0,0,0,NULL,NULL,'66001','66','660001','','',0,'CC','','',0,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers','uv1e4gtg1ghe2ducjna3rk7hs7',NULL,0,NULL,'hola',NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'46.6.213.132',NULL,_binary '\0',NULL,NULL,0,0,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','{\"endpoint\":\"https://fcm.googleapis.com/fcm/send/fM_tPAPzgj8:APA91bFdHiizjdm7p0F3BJpYzweb9_vChdeWaru-yTDQ2JrAr1CkyoVlGcv52xxEZ9jvUsXHAGxKsUu4YNqhTpPiz6hq4Lf3wGYKj-IL6eQbl-Jfh0PfOmRhqHwMp2VSr53KyZMeS7AI\",\"expirationTime\":null,\"keys\":{\"p256dh\":\"BJBZ5Tq_PuKfWuKTiwCEz8RJs2gfynvatMK5tO_aCS7wIZlqpaPWWr6MNKh3-qRUeT7uhxtDQz0ncsOtBM89xw8\",\"auth\":\"_O9A41l21O0Lqo6S3XYnnA\"}}',NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(5,'',NULL,NULL,NULL,'',2,'','',NULL,'','2025-07-09 10:39:29','PEREIRA','RISARALDA','14JIcyOOIQ3dA','CAJERO (A)','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,1,NULL,NULL,'66001','66','660001',NULL,NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers','uf9q0n9aeqhpnogvvokvhh5v1l',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'152.207.246.20',NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(7,'CONSUMIDOR FINAL',NULL,NULL,NULL,'',2,'222222222222','',NULL,'','2025-07-16 12:29:18','PEREIRA','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,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(8,'VENTA DIRECTA',NULL,NULL,NULL,'',2,'VENTADIRECTA','',NULL,'','2025-07-16 12:29:18','PEREIRA','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,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(9,'Maria',NULL,NULL,NULL,'Suarez',2,'','',NULL,'','2025-07-16 15:29:20','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','',NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(10,'YURI','PEÑARANDA',NULL,NULL,'GIRALDO',2,'1116263514','CRA 28 A # 11-16','1994-06-23','3116137886','2025-07-18 12:12:50','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','VANESSA','PABÓN',0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(11,'ELIZABET',NULL,NULL,NULL,'',2,'3053607047','','2008-08-12','','2025-07-18 12:16:10','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers','ql7aeve2eh54mvfcslde7k0sm1',NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(12,'JOHANNA',NULL,NULL,NULL,'',2,'3168190709','',NULL,'','2025-07-18 12:16:44','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001',NULL,NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(13,'KAREN',NULL,NULL,NULL,'',2,'3132621213','',NULL,'','2025-07-18 12:17:14','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','CONDE',NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(14,'MARIA',NULL,NULL,NULL,'LOPEZ',2,'','',NULL,'','2025-08-07 16:55:13','PEREIRA','RISARALDA',NULL,'CLIENTE','','',0,'MASCULINO','CC',0,0,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','','',0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(15,'Maria','El refugio',NULL,NULL,'Valencia',2,'1117349890','Calle 14 # 9 A 18','2005-06-28','3178447678','2025-08-13 17:01:43','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','Camila','Mosquera',0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,'Tuluá',0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(16,'',NULL,NULL,NULL,'Tavera',2,'','',NULL,'643114279','2025-08-26 07:00:20','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,1,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','Nairobi',NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(17,'Dirley',NULL,NULL,NULL,'delgadillo',2,'31793086','Vivero','1980-11-05','','2025-08-26 17:23:17','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','johanna',NULL,0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1),(18,'Yessica',NULL,NULL,NULL,'Giraldo',2,'1116278217','CRA 28 # 11-16','1998-02-28','3226828123','2025-09-10 08:54:09','PEREIRA','RISARALDA','','CLIENTE','','',0,'MASCULINO','CC',0,2,2,'NO',0,0,'','',0,0,NULL,NULL,0,0,0,0,NULL,NULL,'66001','66','660001','Lorena','Pavón',0,'CC',NULL,NULL,NULL,'R-99-PN',49,NULL,NULL,NULL,NULL,NULL,NULL,'texasburgers',NULL,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,_binary '\0',NULL,NULL,0,0,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,NULL,'CON',NULL,0,NULL,'valordeventa',0,NULL,1);

--
-- 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 `colonterapia`
--

CREATE TABLE `colonterapia` (
  `id` int NOT NULL AUTO_INCREMENT,
  `primernombre` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primerapellido` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cc` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_nacimiento` date DEFAULT NULL,
  `edad` int DEFAULT NULL,
  `direccion` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ocupacion` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `celular` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `habitos` text COLLATE utf8mb4_unicode_ci,
  `fum` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pedo` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `talla` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `imc` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intestinales` text COLLATE utf8mb4_unicode_ci,
  `patologias` text COLLATE utf8mb4_unicode_ci,
  `fecha_exoneracion` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identificacion_exoneracion` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acepta_fotografias` tinyint DEFAULT '0',
  `observaciones` text COLLATE utf8mb4_unicode_ci,
  `recomendaciones` text COLLATE utf8mb4_unicode_ci,
  `firma_esteticista` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firma_paciente` longtext COLLATE utf8mb4_unicode_ci,
  `fechacreacion` datetime DEFAULT NULL,
  `fecha_actualizacion` datetime DEFAULT NULL,
  `fecha_firma` datetime DEFAULT NULL,
  `idcliente` bigint unsigned DEFAULT NULL,
  `segundonombre` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `segundoapellido` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alteracion_cutanea` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alteracion_cutanea_especifica` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eritema` tinyint DEFAULT '0',
  `varices` tinyint DEFAULT '0',
  `vasodilatacion` tinyint DEFAULT '0',
  `otros_alteracion_cutanea` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toma_medicamento` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicamento_especifica` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `antecedentes_personales` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `antecedentes_especifica` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_producto` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_contacto_cremas` tinyint DEFAULT '0',
  `hipersensibilidad_contacto_aceites` tinyint DEFAULT '0',
  `hipersensibilidad_contacto_otro` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_inhalado_cremas` tinyint DEFAULT '0',
  `hipersensibilidad_inhalado_aceites` tinyint DEFAULT '0',
  `hipersensibilidad_inhalado_otro` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `protocolo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firma_estudiante` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_cremas` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_contacto` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_aceites` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_otro` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hipersensibilidad_inhalado` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_cc` (`cc`),
  KEY `idx_fecha_creacion` (`fechacreacion`),
  KEY `idcliente` (`idcliente`),
  CONSTRAINT `colonterapia_ibfk_1` FOREIGN KEY (`idcliente`) REFERENCES `clientes` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `colonterapia`
--

INSERT INTO `colonterapia` (`id`, `primernombre`, `primerapellido`, `cc`, `fecha_nacimiento`, `edad`, `direccion`, `ocupacion`, `celular`, `email`, `habitos`, `fum`, `pedo`, `talla`, `imc`, `intestinales`, `patologias`, `fecha_exoneracion`, `identificacion_exoneracion`, `acepta_fotografias`, `observaciones`, `recomendaciones`, `firma_esteticista`, `firma_paciente`, `fechacreacion`, `fecha_actualizacion`, `fecha_firma`, `idcliente`, `segundonombre`, `segundoapellido`, `tipo`, `alteracion_cutanea`, `alteracion_cutanea_especifica`, `eritema`, `varices`, `vasodilatacion`, `otros_alteracion_cutanea`, `toma_medicamento`, `medicamento_especifica`, `antecedentes_personales`, `antecedentes_especifica`, `hipersensibilidad_producto`, `hipersensibilidad_contacto_cremas`, `hipersensibilidad_contacto_aceites`, `hipersensibilidad_contacto_otro`, `hipersensibilidad_inhalado_cremas`, `hipersensibilidad_inhalado_aceites`, `hipersensibilidad_inhalado_otro`, `protocolo`, `firma_estudiante`, `hipersensibilidad_cremas`, `hipersensibilidad_contacto`, `hipersensibilidad_aceites`, `hipersensibilidad_otro`, `hipersensibilidad_inhalado`) VALUES (10,'af','dfqd','e',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,11,'wqq','fdd','Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'sds',NULL,NULL,NULL,'2025-08-10 13:55:39',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 13:56:27',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:12:28',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'ELIZABETH','t','t','2022-03-30',NULL,'6','6','6',NULL,'6','6','6','6','6','6','CARDIOPATIAS,OBESIDAD,HIPERTENSIÓN','6','6',0,'6','6','6','data:image/png;base64,[encoded data, 4280 characters]','2025-08-10 14:13:57',NULL,'2025-08-10 14:34:46',11,'hy','t','Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:14:06',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:16:49',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:16:55',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:26:29',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:27:28',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'ELIZABETH','',NULL,NULL,NULL,'d',NULL,'s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:27:51',NULL,NULL,11,'l',NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:27:57',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:28:31',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:31:41',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'ELIZABETH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:33:14',NULL,NULL,11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'ELIZABETH','dfghj','234567',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-10 14:33:24',NULL,NULL,11,NULL,'ertj','Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'ELIZABETH','',NULL,'2000-06-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HIPERTENSIÓN,TIROIDES',NULL,NULL,0,NULL,NULL,NULL,'data:image/png;base64,[encoded data, 8036 characters]','2025-08-10 14:44:32',NULL,'2025-08-10 14:45:54',11,NULL,NULL,'Colonterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'ELIZABET','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jkl','jlkj',0,'kj','lkj',NULL,'data:image/png;base64,[encoded data, 4872 characters]','2025-08-26 18:57:00',NULL,'2025-08-26 19:59:49',11,NULL,NULL,'Bambu','si','ertyu',1,1,1,'1',NULL,'de',NULL,'d',NULL,0,0,NULL,0,0,'jlee',NULL,'lkj','rtyuiopérew','srs','erty','sertdf','dfd'),(29,'ELIZABET','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-26 21:24:54',NULL,NULL,11,NULL,NULL,'Bambu',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'ELIZABET','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-08-27 21:27:44',NULL,NULL,11,NULL,NULL,'Aromaterapia',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Yessica','Giraldo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-09-11 10:30:06',NULL,NULL,18,'Lorena','Pavón','Corporal',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'Yessica','Giraldo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-09-11 10:30:32',NULL,NULL,18,'Lorena','Pavón','Nutrición',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'Yessica','Giraldo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2025-09-11 10:31:36',NULL,NULL,18,'Lorena','Pavón','Bambu',NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- 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 'KALDI',
  `idpapaifood` varchar(50) DEFAULT NULL,
  `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 'KALDI',
  `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 DEFAULT CHARSET=utf8mb3;

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


--
-- 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 'KALDI',
  `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=103 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 (19,76,'2025-04-05 10:05:03',1,0,3,2300,'2025-04-05 10:05:03',15,19,0,0,1,0,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(20,76,'2025-04-05 10:08:01',1,0,3,2300,'2025-04-05 10:08:01',15,19,0,0,1,0,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(21,127,'2025-04-05 10:08:10',1,0,3,2300,'2025-04-05 10:08:10',15,19,0,0,1,0,1,0,1,2,1,'KALDI',0.09,3,'SIN INCLUIR','IVA','','0000-00-00',0,0,0,0,0,0),(22,76,'2025-04-05 10:09:06',1,0,2,2300,'2025-04-05 10:09:06',15,19,0,0,1,0,1,0,1,2,1,'KALDI',0.06,3,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(23,76,'2025-04-05 10:09:11',1,0,2,2300,'2025-04-05 10:09:11',15,19,0,0,1,0,1,0,1,2,1,'KALDI',0.06,3,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(24,76,'2025-04-05 10:10:18',1,0.97,1,2300,'2025-04-05 10:10:18',15,19,0.8151260504201681,0.15487394957983194,1,0.97,1,0,1,2,1,'KALDI',0.03,3,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,98.6229071804703,0),(25,1786,'2025-04-07 05:27:33',2,159224.793,79612.3965,325,'2025-04-07 05:27:33',3730,5,151642.66,7582.133000000001,1,79612.3965,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(26,2153,'2025-04-07 05:27:33',1,331094.1795,331094.1795,325,'2025-04-07 05:27:33',3730,5,315327.79000000004,15766.389500000001,1,331094.1795,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(27,1798,'2025-04-07 05:27:33',2,228688.572,114344.286,325,'2025-04-07 05:27:33',3730,5,217798.63999999998,10889.931999999999,1,114344.286,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(28,2859,'2025-04-07 05:27:33',3,339673.69800000003,113224.566,325,'2025-04-07 05:27:33',3730,5,323498.76,16174.938,1,113224.566,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(29,2716,'2025-04-07 05:27:33',6,160164,26694,325,'2025-04-07 05:27:33',3730,0,160164,0,1,26694,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(30,985,'2025-04-07 05:27:33',6,484123.19999999995,80687.2,325,'2025-04-07 05:27:33',3730,0,484123.19999999995,0,1,80687.2,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(31,2582,'2025-04-07 05:27:33',2,88823.53,44411.765,325,'2025-04-07 05:27:33',3730,0,88823.53,0,1,44411.765,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(32,2516,'2025-04-07 05:27:33',1,72166.5,72166.5,325,'2025-04-07 05:27:33',3730,5,68730,3436.5,1,72166.5,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(33,2334,'2025-04-07 05:27:33',6,349411.74,58235.29,325,'2025-04-07 05:27:33',3730,0,349411.74,0,1,58235.29,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(34,982,'2025-04-07 05:27:33',8,569384.64,71173.08,325,'2025-04-07 05:27:33',3730,0,569384.64,0,1,71173.08,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(35,2335,'2025-04-07 05:27:33',1,91344.54,91344.54,325,'2025-04-07 05:27:33',3730,0,91344.54,0,1,91344.54,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(36,2855,'2025-04-07 05:27:33',1,55543.22,55543.22,325,'2025-04-07 05:27:33',3730,0,55543.22,0,1,55543.22,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(37,1641,'2025-04-07 05:27:33',10,438582.39999999997,43858.24,325,'2025-04-07 05:27:33',3730,0,438582.39999999997,0,1,43858.24,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(38,2983,'2025-04-07 05:27:33',2,593533.332,296766.666,325,'2025-04-07 05:27:33',3730,5,565269.8400000001,28263.492000000002,1,296766.666,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(39,978,'2025-04-07 05:27:33',6,181821.54,30303.59,325,'2025-04-07 05:27:33',3730,0,181821.54,0,1,30303.59,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(40,2524,'2025-04-07 05:27:33',5,230630,46126,325,'2025-04-07 05:27:33',3730,0,230630,0,1,46126,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(41,1786,'2025-04-07 05:27:38',2,159224.793,79612.3965,325,'2025-04-07 05:27:38',3730,5,151642.66,7582.133000000001,1,79612.3965,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(42,2153,'2025-04-07 05:27:38',1,331094.1795,331094.1795,325,'2025-04-07 05:27:38',3730,5,315327.79000000004,15766.389500000001,1,331094.1795,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(43,1798,'2025-04-07 05:27:38',2,228688.572,114344.286,325,'2025-04-07 05:27:38',3730,5,217798.63999999998,10889.931999999999,1,114344.286,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(44,2859,'2025-04-07 05:27:38',3,339673.69800000003,113224.566,325,'2025-04-07 05:27:38',3730,5,323498.76,16174.938,1,113224.566,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(45,2716,'2025-04-07 05:27:38',6,160164,26694,325,'2025-04-07 05:27:38',3730,0,160164,0,1,26694,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(46,985,'2025-04-07 05:27:38',6,484123.19999999995,80687.2,325,'2025-04-07 05:27:38',3730,0,484123.19999999995,0,1,80687.2,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(47,2582,'2025-04-07 05:27:38',2,88823.53,44411.765,325,'2025-04-07 05:27:38',3730,0,88823.53,0,1,44411.765,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(48,2516,'2025-04-07 05:27:38',1,72166.5,72166.5,325,'2025-04-07 05:27:38',3730,5,68730,3436.5,1,72166.5,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(49,2334,'2025-04-07 05:27:38',6,349411.74,58235.29,325,'2025-04-07 05:27:38',3730,0,349411.74,0,1,58235.29,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(50,982,'2025-04-07 05:27:38',8,569384.64,71173.08,325,'2025-04-07 05:27:38',3730,0,569384.64,0,1,71173.08,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(51,2335,'2025-04-07 05:27:38',1,91344.54,91344.54,325,'2025-04-07 05:27:38',3730,0,91344.54,0,1,91344.54,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(52,2855,'2025-04-07 05:27:38',1,55543.22,55543.22,325,'2025-04-07 05:27:38',3730,0,55543.22,0,1,55543.22,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(53,1641,'2025-04-07 05:27:38',10,438582.39999999997,43858.24,325,'2025-04-07 05:27:38',3730,0,438582.39999999997,0,1,43858.24,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(54,2983,'2025-04-07 05:27:38',2,593533.332,296766.666,325,'2025-04-07 05:27:38',3730,5,565269.8400000001,28263.492000000002,1,296766.666,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(55,978,'2025-04-07 05:27:38',6,181821.54,30303.59,325,'2025-04-07 05:27:38',3730,0,181821.54,0,1,30303.59,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(56,2524,'2025-04-07 05:27:38',5,230630,46126,325,'2025-04-07 05:27:38',3730,0,230630,0,1,46126,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(57,1786,'2025-04-07 05:27:50',2,159224.793,79612.3965,325,'2025-04-07 05:27:50',3730,5,151642.66,7582.133000000001,1,79612.3965,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(58,2153,'2025-04-07 05:27:50',1,331094.1795,331094.1795,325,'2025-04-07 05:27:50',3730,5,315327.79000000004,15766.389500000001,1,331094.1795,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(59,1798,'2025-04-07 05:27:50',2,228688.572,114344.286,325,'2025-04-07 05:27:50',3730,5,217798.63999999998,10889.931999999999,1,114344.286,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(60,2859,'2025-04-07 05:27:50',3,339673.69800000003,113224.566,325,'2025-04-07 05:27:50',3730,5,323498.76,16174.938,1,113224.566,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(61,2716,'2025-04-07 05:27:50',6,160164,26694,325,'2025-04-07 05:27:50',3730,0,160164,0,1,26694,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(62,985,'2025-04-07 05:27:50',6,484123.19999999995,80687.2,325,'2025-04-07 05:27:50',3730,0,484123.19999999995,0,1,80687.2,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(63,2582,'2025-04-07 05:27:50',2,88823.53,44411.765,325,'2025-04-07 05:27:50',3730,0,88823.53,0,1,44411.765,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(64,2516,'2025-04-07 05:27:50',1,72166.5,72166.5,325,'2025-04-07 05:27:50',3730,5,68730,3436.5,1,72166.5,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(65,2334,'2025-04-07 05:27:50',6,349411.74,58235.29,325,'2025-04-07 05:27:50',3730,0,349411.74,0,1,58235.29,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(66,982,'2025-04-07 05:27:50',8,569384.64,71173.08,325,'2025-04-07 05:27:50',3730,0,569384.64,0,1,71173.08,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(67,2335,'2025-04-07 05:27:50',1,91344.54,91344.54,325,'2025-04-07 05:27:50',3730,0,91344.54,0,1,91344.54,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(68,2855,'2025-04-07 05:27:50',1,55543.22,55543.22,325,'2025-04-07 05:27:50',3730,0,55543.22,0,1,55543.22,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(69,1641,'2025-04-07 05:27:50',10,438582.39999999997,43858.24,325,'2025-04-07 05:27:50',3730,0,438582.39999999997,0,1,43858.24,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(70,2983,'2025-04-07 05:27:50',2,593533.332,296766.666,325,'2025-04-07 05:27:50',3730,5,565269.8400000001,28263.492000000002,1,296766.666,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(71,978,'2025-04-07 05:27:50',6,181821.54,30303.59,325,'2025-04-07 05:27:50',3730,0,181821.54,0,1,30303.59,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(72,2524,'2025-04-07 05:27:50',5,230630,46126,325,'2025-04-07 05:27:50',3730,0,230630,0,1,46126,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(73,1786,'2025-04-07 05:28:17',2,159224.793,79612.3965,325,'2025-04-07 05:28:17',3730,5,151642.66,7582.133000000001,1,79612.3965,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(74,2153,'2025-04-07 05:28:17',1,331094.1795,331094.1795,325,'2025-04-07 05:28:17',3730,5,315327.79000000004,15766.389500000001,1,331094.1795,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(75,1798,'2025-04-07 05:28:17',2,228688.572,114344.286,325,'2025-04-07 05:28:17',3730,5,217798.63999999998,10889.931999999999,1,114344.286,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(76,2859,'2025-04-07 05:28:17',3,339673.69800000003,113224.566,325,'2025-04-07 05:28:17',3730,5,323498.76,16174.938,1,113224.566,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(77,2716,'2025-04-07 05:28:17',6,160164,26694,325,'2025-04-07 05:28:17',3730,0,160164,0,1,26694,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(78,985,'2025-04-07 05:28:17',6,484123.19999999995,80687.2,325,'2025-04-07 05:28:17',3730,0,484123.19999999995,0,1,80687.2,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(79,2582,'2025-04-07 05:28:17',2,88823.53,44411.765,325,'2025-04-07 05:28:17',3730,0,88823.53,0,1,44411.765,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(80,2516,'2025-04-07 05:28:17',1,72166.5,72166.5,325,'2025-04-07 05:28:17',3730,5,68730,3436.5,1,72166.5,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(81,2334,'2025-04-07 05:28:17',6,349411.74,58235.29,325,'2025-04-07 05:28:17',3730,0,349411.74,0,1,58235.29,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(82,982,'2025-04-07 05:28:17',8,569384.64,71173.08,325,'2025-04-07 05:28:17',3730,0,569384.64,0,1,71173.08,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(83,2335,'2025-04-07 05:28:17',1,91344.54,91344.54,325,'2025-04-07 05:28:17',3730,0,91344.54,0,1,91344.54,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(84,2855,'2025-04-07 05:28:17',1,55543.22,55543.22,325,'2025-04-07 05:28:17',3730,0,55543.22,0,1,55543.22,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(85,1641,'2025-04-07 05:28:17',10,438582.39999999997,43858.24,325,'2025-04-07 05:28:17',3730,0,438582.39999999997,0,1,43858.24,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(86,2983,'2025-04-07 05:28:17',2,593533.332,296766.666,325,'2025-04-07 05:28:17',3730,5,565269.8400000001,28263.492000000002,1,296766.666,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(87,978,'2025-04-07 05:28:17',6,181821.54,30303.59,325,'2025-04-07 05:28:17',3730,0,181821.54,0,1,30303.59,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(88,2524,'2025-04-07 05:28:17',5,230630,46126,325,'2025-04-07 05:28:17',3730,0,230630,0,1,46126,1,0,1,2,1,'KALDI',0,0,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,0,0),(89,76,'2025-05-05 01:43:32',74,81066.852,1231,2300,'2025-05-04 23:59:59',17,22,66448.2393442623,14618.612655737705,1,1098.498,1,0,1,2,1,'KALDI',135.502,11.007473598700244,'INCLUIDO','IVA','','0000-00-00',1,2,0,0,74.92060092165899,0),(90,154,'2025-05-05 01:43:40',1,2296.14,2343,2300,'2025-05-04 23:59:59',17,19,1929.5294117647059,366.61058823529413,1,2296.14,1,0,1,2,1,'KALDI',46.86,2,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,55689.80699999999,0),(91,127,'2025-05-05 01:43:48',4,16018.923200000001,3434,2300,'2025-05-04 23:59:59',17,19,13461.28,2557.6432,1,4004.7308000000003,1,0,1,2,1,'KALDI',68.68,2,'SIN INCLUIR','IVA','','0000-00-00',0,0,0,0,8246.554358271236,0),(92,143,'2025-05-05 02:32:08',2,842625.42,434343,2300,'2025-05-04 23:59:59',17,0,842625.42,0,1,421312.71,1,0,1,2,1,'KALDI',13030.29,3,'INCLUIDO','IVA','','0000-00-00',0,0,0,0,10117.390638722554,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,
  `idcliente` bigint unsigned NOT NULL,
  `consecutivo` int DEFAULT '0',
  `calculadodesde` date DEFAULT NULL,
  `calculadohasta` date DEFAULT NULL,
  `diaslaborados` int DEFAULT '0',
  `ingreso` int DEFAULT '0',
  `deducciones` int DEFAULT '0',
  `valorapgar` int DEFAULT '0',
  `idz` int DEFAULT '0',
  `salario` int DEFAULT '0',
  `mediodepago` varchar(25) DEFAULT NULL,
  `afectacaja` int DEFAULT '0',
  `desde` date DEFAULT NULL,
  `hasta` date DEFAULT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `nombre` varchar(150) DEFAULT NULL,
  `comisiones` int DEFAULT '0',
  `transporte` int DEFAULT '0',
  `pension` int DEFAULT '0',
  `salud` int DEFAULT '0',
  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 AUTO_INCREMENT=2 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 'KALDI',
  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,'KALDI'),(14,'IMPREVISTOS',1,'KALDI');

--
-- Table structure for table `conducta`
--

CREATE TABLE `conducta` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idusuario` bigint unsigned NOT NULL,
  `idhistoria` int NOT NULL,
  `idcliente` int NOT NULL DEFAULT '0',
  `control12meses` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'SI',
  `control6meses` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `continuarepp` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'SI',
  `emisionoftalmologica` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'SI',
  `remisionortoptica` varchar(2) COLLATE utf8mb4_bin DEFAULT 'NO',
  `correccionuso` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT 'NO',
  `correcciotipo` varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idhistoria` (`idhistoria`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `conducta`
--

INSERT INTO `conducta` (`id`, `idusuario`, `idhistoria`, `idcliente`, `control12meses`, `control6meses`, `continuarepp`, `emisionoftalmologica`, `remisionortoptica`, `correccionuso`, `correcciotipo`) VALUES (12,2,15,13,'SI','NO','SI','SI','NO','NO',NULL),(13,1,18,11,'SI','NO','SI','SI','NO','NO',NULL);

--
-- 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=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `configuracion` (`id`, `clave`, `valor`, `descripcion`) VALUES (16,'Ajustes de inventario','Hay mas unidades en el inventario físico',''),(17,'Ajustes de inventario','Hay menos en el inventario físico',''),(18,'Ajustes de inventario','Se le da de baja por descomposición',''),(19,'Ajustes de inventario','Se le da de baja por mala presentación',''),(20,'Ajustes de inventario','Sale como degustación',''),(21,'Ajustes de inventario','Sale como promoción',''),(22,'Ajustes de inventario','Descontado para cocina',''),(23,'Edición en regularizaciones','Modificando la cantidad','Modificando la cantidad/Agregando la cantidad'),(24,'Descontar inventario en venta','Del módulo de artículos','Del módulo de artículos/Del inventario del vendedor'),(25,'qr_login','','Permite poner un código QR en la pantalla de login'),(26,'Tipo de impresion abonos cartera','Carta','Carta, Media carta, Tirilla'),(27,'Imprimir comentario tirilla abonos cartera','Si','Si, No'),(28,'Fecha para guardar ventas a la madrugada','Fecha real','<ul><li>Fecha real</li><li>Fecha del turno actual</li></ul>'),(29,'Puede repetir celular en el callcenter','Si','<ul><li>Si</li><li>No</li></ul>'),(30,'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 NULL,
  `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=3 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 (2,12,12,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'tabladondeseeejecutaelprocedimiento',80,12,20,12,20,10,10,12,20,12,20,10,10,0,1,0,'pendiente','html','YYYY-MM-dd','pendiente',0,'5',NULL,NULL,NULL,'7',0,0,0,0,12,12,12,12,12,12,30,NULL,NULL,1,NULL,0,'B',NULL,NULL,'host',NULL,NULL,'.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,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 'KALDI',
  UNIQUE KEY `id` (`id`),
  KEY `cc` (`cc`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `consecutivos` (`id`, `consecutivo`, `cc`, `fechacreacion`, `tipo`, `idusuario`, `pv`) VALUES (1,71,1,'2020-12-24 19:28:24','VENTAS',1,'KALDI'),(2,7,2,'2020-12-24 19:28:24','VENTAS',1,'KALDI'),(3,980,1,'2020-12-24 19:28:24','Z',1,'KALDI'),(4,1,2,'2020-12-24 19:28:24','Z',1,'KALDI'),(5,181,1,'2020-12-24 19:28:24','ABONOS',1,'KALDI'),(6,1,2,'2020-12-24 19:28:24','ABONOS',1,'KALDI'),(7,1,1,'2020-12-24 19:28:24','NOTASCREDITO',1,'KALDI'),(8,1,2,'2020-12-24 19:28:24','NOTASCREDITO',1,'KALDI'),(9,1,1,'2020-12-24 19:28:24','NOTASDEBITO',1,'KALDI'),(10,1,2,'2020-12-24 19:28:24','NOTASDEBITO',1,'KALDI'),(11,1,1,'2020-12-24 19:28:24','CORTESIAS',1,'KALDI'),(12,1,2,'2020-12-24 19:28:24','CORTESIAS',1,'KALDI'),(13,2,1,'2020-12-24 19:28:24','COMPROBANTE DE EGRESOS',1,'KALDI'),(14,1,2,'2020-12-24 19:28:24','COMPROBANTE DE EGRESOS',1,'KALDI'),(15,1,1,'2020-12-24 19:28:24','SEPARADOS',1,'KALDI'),(16,1,2,'2020-12-24 19:28:24','SEPARADOS',1,'KALDI'),(17,1,1,'2020-12-24 19:28:24','PRODUCCION',1,'KALDI'),(18,1,2,'2020-12-24 19:28:24','PRODUCCION',1,'KALDI'),(19,1,2,'2020-12-24 19:28:24','SOLICITUDES',1,'KALDI'),(20,1,2,'2020-12-24 19:28:24','SOLICITUDES',1,'KALDI'),(21,16,1,'2021-04-04 18:41:42','BAJAS',1,'KALDI'),(22,1,2,'2021-04-04 18:41:52','BAJAS',1,'KALDI'),(23,1,2,'2021-08-31 05:13:46','ABONOS PRESTAMOS',1,'KALDI'),(24,1,2,'2021-09-02 21:51:07','ABONOS SEPARADOS',1,'KALDI'),(25,1,2,'2021-10-09 01:38:11','RecepcionEquipo',1,'KALDI'),(26,1,2,'2022-01-16 08:30:58','TRASLADOS',1,'KALDI'),(27,1,2,'2022-01-24 12:25:47','PrecuentaCallcenter',1,'KALDI'),(28,1,2,'2022-02-04 19:54:59','FICHA DE REGISTRO',1,'KALDI'),(29,1,2,'2022-08-12 19:58:36','DOCUMENTO SOPORTE',1,'KALDI'),(30,1,2,'2023-01-26 09:53:10','DEVOLUCIONES POR PAGAR',1,'KALDI'),(31,1,2,'2023-02-26 05:14:06','FE',1,'KALDI'),(32,1,2,'2024-01-16 18:29:10','NOTACREDITOFE',1,'KALDI'),(33,1,2,'2024-06-01 17:53:45','POS ELECTRONICO',1,'KALDI'),(34,1,2,'2024-08-13 10:13:50','ANTICIPOS',1,'KALDI'),(35,34,0,'2025-03-13 16:29:02','RECIBO GENERAL',1,'KALDI'),(36,44,0,'2025-03-30 00:31:37','RUTAS',1,'KALDI'),(37,2,0,'2025-05-03 19:57:10','ABONOS COMPRAS',1,'KALDI'),(41,8,0,'2025-05-16 03:33:14','PEDIDOS',1,'KALDI'),(42,1,2,'2025-05-26 13:43:49','FEN',1,'KALDI'),(43,1,0,'2025-06-18 04:23:09','NOMINA',1,'KALDI');

--
-- Table structure for table `consultas`
--

CREATE TABLE `consultas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `consulta` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `consultas`
--


--
-- 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` decimal(11,2) DEFAULT '0.00',
  `credito` decimal(11,2) DEFAULT '0.00',
  `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 'KALDI',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `cotizaciondereceta` (`idarticulo`, `cantidad`, `idusuario`, `id`, `revisado`, `pv`) VALUES (20,1,1,13,1,'KALDI');

--
-- 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',
  `numlinea` text,
  `unidaddemedida` text,
  `talla` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `idmayor` (`idmayor`),
  KEY `idarticulo` (`idarticulo`),
  KEY `idcliente` (`idcliente`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `cotizaciones` (`id`, `idmayor`, `consecutivo`, `idarticulo`, `cantidad`, `valorunitario`, `bruto`, `descuento`, `valortotal`, `fechacreacion`, `idcliente`, `idusuario`, `escortesiadeconvenio`, `fechaabonado`, `descripcion`, `porcentajedescuento`, `porcentajeiva`, `base`, `impuesto`, `numlinea`, `unidaddemedida`, `talla`) VALUES (1,5,0,0,0,7532000,0,0,0,'2025-04-14 17:59:25',0,1,0,NULL,'DISEÑO Y FABRICACIÓN DE M',0,0.00,0,0,'1','gl',NULL),(2,5,0,0,0,5000000,0,0,0,'2025-04-14 17:59:25',0,1,0,NULL,'FABRICACIÓN DE RODILLO SE',0,0.00,0,0,'2','gl',NULL),(3,6,0,0,0,7532000,0,0,0,'2025-04-14 18:37:15',0,1,0,NULL,'DISEÑO Y FABRICACIÓN DE M',0,0.00,0,0,'1','gl',NULL),(4,6,0,0,0,5000000,0,0,0,'2025-04-14 18:37:15',0,1,0,NULL,'FABRICACIÓN DE RODILLO SE',0,0.00,0,0,'2','gl',NULL),(5,6,0,0,0,10000,0,0,0,'2025-04-14 18:37:15',0,1,0,NULL,'as fñalds fañsfljkañsflk',0,0.00,0,0,'3','gl',NULL);

--
