/* Navicat Premium Data Transfer Source Server : server mysql mio Source Server Type : MySQL Source Server Version : 50717 (5.7.17-log) Source Host : 45.236.90.151:3306 Source Schema : makato Target Server Type : MySQL Target Server Version : 50717 (5.7.17-log) File Encoding : 65001 Date: 08/08/2026 08:34:58 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for abonos -- ---------------------------- DROP TABLE IF EXISTS `abonos`; CREATE TABLE `abonos` ( `monto` decimal(15, 0) NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `numdoc` decimal(15, 0) NULL DEFAULT NULL, `codigo` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nrocheq` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `feccobr` date NULL DEFAULT NULL, `nrodoc` decimal(15, 0) NULL DEFAULT NULL, `caja` decimal(2, 0) NULL DEFAULT NULL, `nombre` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `estado` bit(1) NULL DEFAULT NULL, `corpago` decimal(15, 0) NULL DEFAULT NULL, `codprima` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`codprima`) USING BTREE, UNIQUE INDEX `ux_abonos_codprima`(`codprima`) USING BTREE, INDEX `rut`(`rut`) USING BTREE, INDEX `idx_b52_abonos_cliente_documento`(`rut`, `numdoc`, `estado`, `fecha`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for actualiza -- ---------------------------- DROP TABLE IF EXISTS `actualiza`; CREATE TABLE `actualiza` ( `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `nombre` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `version` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `actualizado` int(1) NULL DEFAULT NULL, `fecact` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `actualiza` int(1) NULL DEFAULT NULL, PRIMARY KEY (`rut`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for anexo_fcomregi -- ---------------------------- DROP TABLE IF EXISTS `anexo_fcomregi`; CREATE TABLE `anexo_fcomregi` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` float(13, 2) NULL DEFAULT NULL, `SBTOTAL` int(15) NULL DEFAULT NULL, `CANTIDAD` float(15, 3) NULL DEFAULT NULL, `DOCU` decimal(15, 0) NULL DEFAULT NULL, `DESC1` float(10, 6) NULL DEFAULT NULL, `DESC2` float(10, 6) NULL DEFAULT NULL, `DESC3` float(10, 6) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `TIPPRE` int(1) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `RECIBIDO` int(12) NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `COSTOUS` float(13, 2) NULL DEFAULT NULL, `COSTOCIF` float(13, 2) NULL DEFAULT NULL, `PRBRUTO` float(13, 3) NULL DEFAULT NULL, `PRVENTA` int(9) NULL DEFAULT NULL, `PRVENTAANT` int(9) NULL DEFAULT NULL, `TIPODOC` int(5) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRECIO1` float(13, 3) NULL DEFAULT NULL, `PRECIO2` float(13, 3) NULL DEFAULT NULL, `PRECIO3` float(13, 3) NULL DEFAULT NULL, `PRECIO4` float(13, 3) NULL DEFAULT NULL, `FACTURA` int(12) NULL DEFAULT NULL, `VALIMP` float(12, 3) NULL DEFAULT NULL, `FACTURAPAR` int(12) NULL DEFAULT NULL, `VAR1` int(12) NULL DEFAULT NULL, `VAR2` int(12) NULL DEFAULT NULL, `VAR3` float(12, 3) NULL DEFAULT NULL, `VAR4` int(1) NULL DEFAULT NULL, `VAR5` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `factcom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `folioconta` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for anulacom -- ---------------------------- DROP TABLE IF EXISTS `anulacom`; CREATE TABLE `anulacom` ( `docu` decimal(12, 0) NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `tipomov` decimal(2, 0) NULL DEFAULT NULL, `local` decimal(2, 0) NULL DEFAULT NULL, `estado` bit(1) NULL DEFAULT NULL, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`codunico`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for arcmovi -- ---------------------------- DROP TABLE IF EXISTS `arcmovi`; CREATE TABLE `arcmovi` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRVENTA` float(10, 2) NULL DEFAULT NULL, `SBTOTAL` float(15, 2) NULL DEFAULT NULL, `CANTIDAD` float(15, 3) NULL DEFAULT NULL, `DOCU` decimal(15, 0) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TIPPRE` int(1) NULL DEFAULT NULL, `UTIPROD` int(10) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `VENDEDOR` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `DESC1` float(5, 2) NULL DEFAULT NULL, `LOCORI` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCFIN` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` float(10, 2) NULL DEFAULT NULL, `DESC2` float(5, 2) NULL DEFAULT NULL, `DESC3` float(5, 2) NULL DEFAULT NULL, `DESCGLOBAL` float(5, 2) NULL DEFAULT NULL, `DESCGLOBA2` float(5, 2) NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `CAJERO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `DESCRIP` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `ENTIDAD` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`CODUNICO`) USING BTREE, UNIQUE INDEX `ux_arcmovi_codunico`(`CODUNICO`) USING BTREE, INDEX `FECHA`(`FECHA`) USING BTREE, INDEX `DOCU`(`DOCU`) USING BTREE, INDEX `CODIGO`(`CODIGO`) USING BTREE, INDEX `idx_arcmovi_b8_docu`(`DOCU`) USING BTREE, INDEX `idx_arcmovi_b8_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_arcmovi_b9_docu`(`DOCU`) USING BTREE, INDEX `idx_arcmovi_b9_codunico`(`CODUNICO`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for arcpagtrxs -- ---------------------------- DROP TABLE IF EXISTS `arcpagtrxs`; CREATE TABLE `arcpagtrxs` ( `CODIGO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TIPO` int(2) NULL DEFAULT NULL, `SBTOTAL` int(10) NULL DEFAULT NULL, `DOCU` int(10) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DIFPAGO` int(10) NULL DEFAULT NULL, `EMPRESAS` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TURNO` int(2) NULL DEFAULT NULL, `FECHACOBR` date NULL DEFAULT NULL, `NROCHEQ` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RESUMEN` int(10) NULL DEFAULT NULL, `ENTIDAD` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `CUENTA` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `CANCELADA` bit(1) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `numtrtbk` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `corpago` decimal(15, 0) NULL DEFAULT NULL, `despacha` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `parcial` decimal(12, 0) NULL DEFAULT NULL, `cornota` decimal(10, 0) NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `rut`(`RUT`) USING BTREE, INDEX `idx_arcpag_b8_docu`(`DOCU`) USING BTREE, INDEX `idx_arcpag_b9_docu`(`DOCU`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for articen -- ---------------------------- DROP TABLE IF EXISTS `articen`; CREATE TABLE `articen` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREEMP1` float(12, 3) NULL DEFAULT NULL, `PREEMP2` float(12, 3) NULL DEFAULT NULL, `PREEMP3` float(12, 3) NULL DEFAULT NULL, `PREEMP4` float(12, 3) NULL DEFAULT NULL, `PREEMP5` float(12, 3) NULL DEFAULT NULL, `PREMBRU` float(11, 2) NULL DEFAULT NULL, `PREMCO1` float(11, 2) NULL DEFAULT NULL, `BOTON` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERIES` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPRESORA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKCRI` int(4) NULL DEFAULT NULL, `SIGLA` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLETE` float(7, 2) NULL DEFAULT NULL, `IMAGEN` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPUESTO` int(2) NULL DEFAULT NULL, `TIPO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL06EM1` float(12, 3) NULL DEFAULT NULL, `STKL07EM1` float(12, 3) NULL DEFAULT NULL, `STKL08EM1` float(12, 3) NULL DEFAULT NULL, `STKL09EM1` float(12, 3) NULL DEFAULT NULL, `STKL11EM1` float(12, 3) NULL DEFAULT NULL, `STKL12EM1` float(12, 3) NULL DEFAULT NULL, `STKL13EM1` float(12, 3) NULL DEFAULT NULL, `STKL14EM1` float(12, 3) NULL DEFAULT NULL, `STKL15EM1` float(12, 3) NULL DEFAULT NULL, `STKL10EM1` float(12, 3) NULL DEFAULT NULL, `STOCK` float(10, 3) NULL DEFAULT NULL, `COSTOUS` float(10, 2) NULL DEFAULT NULL, `COSTOCIF` float(10, 2) NULL DEFAULT NULL, `PRECAN1` int(4) NULL DEFAULT NULL, `PROVEEDOR2` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR3` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR4` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESBASICO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COSTOPROV1` float(9, 2) NULL DEFAULT NULL, `COSTOPROV2` float(9, 2) NULL DEFAULT NULL, `COSTOPROV3` float(9, 2) NULL DEFAULT NULL, `COSTOPROV4` float(9, 2) NULL DEFAULT NULL, `STKL01EM1` float(12, 3) NULL DEFAULT NULL, `STKL02EM1` float(12, 3) NULL DEFAULT NULL, `STKL03EM1` float(12, 3) NULL DEFAULT NULL, `STKL04EM1` float(12, 3) NULL DEFAULT NULL, `STKL05EM1` float(12, 3) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `ESINGRED` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VALQUITA` int(5) NULL DEFAULT NULL, `VALAGRE` int(5) NULL DEFAULT NULL, `SIGLAPREC1` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC2` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC3` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC4` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `AFECTAINV` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORDETA` float(6, 2) NULL DEFAULT NULL, `PORMAYO` float(6, 2) NULL DEFAULT NULL, `POROFER` float(6, 2) NULL DEFAULT NULL, `PORDESP` float(6, 2) NULL DEFAULT NULL, `PORGERE` float(6, 2) NULL DEFAULT NULL, `ENVASES` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORC1` float(5, 2) NULL DEFAULT NULL, `PORC2` float(5, 2) NULL DEFAULT NULL, `CREDITO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODIMP` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHACOMP` date NULL DEFAULT NULL, `DESCORT` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLUCTUA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PESO` float(10, 3) NULL DEFAULT NULL, `SIGLA1` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLA2` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UTILPROD1` float(10, 2) NULL DEFAULT NULL, `UTILPROD2` float(10, 2) NULL DEFAULT NULL, `MARGEN` float(7, 2) NULL DEFAULT NULL, `PREMCO2` float(10, 2) NULL DEFAULT NULL, `PRECAN2` int(7) NULL DEFAULT NULL, `PRECAN3` int(7) NULL DEFAULT NULL, `PRECAN4` int(7) NULL DEFAULT NULL, `PRECAN5` int(7) NULL DEFAULT NULL, `VAR01` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR02` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR03` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR04` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR05` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR06` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UNIDXCAJA` int(10) NULL DEFAULT NULL, `DESCALT` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL16EM1` float(12, 3) NULL DEFAULT NULL, `STKL17EM1` float(12, 3) NULL DEFAULT NULL, `STKL18EM1` float(12, 3) NULL DEFAULT NULL, `STKL19EM1` float(12, 3) NULL DEFAULT NULL, `STKL20EM1` float(12, 3) NULL DEFAULT NULL, `STKL21EM1` float(12, 3) NULL DEFAULT NULL, `STKL22EM1` float(12, 3) NULL DEFAULT NULL, `STKL23EM1` float(12, 3) NULL DEFAULT NULL, `STKL24EM1` float(12, 3) NULL DEFAULT NULL, `STKL25EM1` float(12, 3) NULL DEFAULT NULL, `STKL26EM1` float(12, 3) NULL DEFAULT NULL, `STKL27EM1` float(12, 3) NULL DEFAULT NULL, `STKL28EM1` float(12, 3) NULL DEFAULT NULL, `STKL29EM1` float(12, 3) NULL DEFAULT NULL, `STKL30EM1` float(12, 3) NULL DEFAULT NULL, `VAR30` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR31` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR32` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DUMP14` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CARTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MATERIAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `INVENCAJA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKMIN` float(10, 2) NULL DEFAULT NULL, `STKMAX` float(10, 2) NULL DEFAULT NULL, `PRECAN` int(10) NULL DEFAULT NULL, `CODART1` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODART2` int(13) NULL DEFAULT NULL, `VAR1` int(1) NULL DEFAULT NULL, `VAR2` int(1) NULL DEFAULT NULL, `VAR13` int(2) NULL DEFAULT NULL, `VAR14` float(12, 3) NULL DEFAULT NULL, `VAR15` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR16` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR17` float(10, 3) NULL DEFAULT NULL, `CODPROV2` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV3` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV4` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `env01` decimal(1, 0) NULL DEFAULT NULL, `env02` decimal(1, 0) NULL DEFAULT NULL, `env03` decimal(1, 0) NULL DEFAULT NULL, `env04` decimal(1, 0) NULL DEFAULT NULL, `env05` decimal(1, 0) NULL DEFAULT NULL, `env06` decimal(1, 0) NULL DEFAULT NULL, `env07` decimal(1, 0) NULL DEFAULT NULL, `env08` decimal(1, 0) NULL DEFAULT NULL, `env09` decimal(1, 0) NULL DEFAULT NULL, `env10` decimal(1, 0) NULL DEFAULT NULL, PRIMARY KEY (`CODIGO`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for articulo -- ---------------------------- DROP TABLE IF EXISTS `articulo`; CREATE TABLE `articulo` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREEMP1` float NULL DEFAULT NULL, `PREEMP2` float NULL DEFAULT NULL, `PREEMP3` float NULL DEFAULT NULL, `PREEMP4` float NULL DEFAULT NULL, `PREEMP5` float NULL DEFAULT NULL, `PREMBRU` float(11, 2) NULL DEFAULT NULL, `PREMCO1` float(11, 2) NULL DEFAULT NULL, `BOTON` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERIES` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPRESORA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKCRI` int(4) NULL DEFAULT NULL, `SIGLA` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLETE` float(7, 2) NULL DEFAULT NULL, `IMAGEN` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPUESTO` int(2) NULL DEFAULT NULL, `TIPO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL06EM1` float(12, 3) NULL DEFAULT NULL, `STKL07EM1` float(12, 3) NULL DEFAULT NULL, `STKL08EM1` float(12, 3) NULL DEFAULT NULL, `STKL09EM1` float(12, 3) NULL DEFAULT NULL, `STKL11EM1` float(12, 3) NULL DEFAULT NULL, `STKL12EM1` float(12, 3) NULL DEFAULT NULL, `STKL13EM1` float(12, 3) NULL DEFAULT NULL, `STKL14EM1` float(12, 3) NULL DEFAULT NULL, `STKL15EM1` float(12, 3) NULL DEFAULT NULL, `STKL10EM1` float(12, 3) NULL DEFAULT NULL, `STOCK` float(10, 3) NULL DEFAULT NULL, `COSTOUS` float(10, 2) NULL DEFAULT NULL, `COSTOCIF` float(10, 2) NULL DEFAULT NULL, `PRECAN1` int(4) NULL DEFAULT NULL, `PROVEEDOR2` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR3` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR4` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESBASICO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COSTOPROV1` float(9, 2) NULL DEFAULT NULL, `COSTOPROV2` float(9, 2) NULL DEFAULT NULL, `COSTOPROV3` float(9, 2) NULL DEFAULT NULL, `COSTOPROV4` float(9, 2) NULL DEFAULT NULL, `STKL01EM1` float(12, 3) NULL DEFAULT NULL, `STKL02EM1` float(12, 3) NULL DEFAULT NULL, `STKL03EM1` float(12, 3) NULL DEFAULT NULL, `STKL04EM1` float(12, 3) NULL DEFAULT NULL, `STKL05EM1` float(12, 3) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `ESINGRED` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VALQUITA` int(5) NULL DEFAULT NULL, `VALAGRE` int(5) NULL DEFAULT NULL, `SIGLAPREC1` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC2` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC3` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC4` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `AFECTAINV` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORDETA` float(6, 2) NULL DEFAULT NULL, `PORMAYO` float(6, 2) NULL DEFAULT NULL, `POROFER` float(6, 2) NULL DEFAULT NULL, `PORDESP` float(6, 2) NULL DEFAULT NULL, `PORGERE` float(6, 2) NULL DEFAULT NULL, `ENVASES` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORC1` float(5, 2) NULL DEFAULT NULL, `PORC2` float(5, 2) NULL DEFAULT NULL, `CREDITO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODIMP` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHACOMP` date NULL DEFAULT NULL, `DESCORT` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLUCTUA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PESO` float(10, 3) NULL DEFAULT NULL, `SIGLA1` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLA2` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UTILPROD1` float(10, 2) NULL DEFAULT NULL, `UTILPROD2` float(10, 2) NULL DEFAULT NULL, `MARGEN` float(7, 2) NULL DEFAULT NULL, `PREMCO2` float(10, 2) NULL DEFAULT NULL, `PRECAN2` int(7) NULL DEFAULT NULL, `PRECAN3` int(7) NULL DEFAULT NULL, `PRECAN4` int(7) NULL DEFAULT NULL, `PRECAN5` int(7) NULL DEFAULT NULL, `VAR01` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR02` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR03` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR04` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR05` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR06` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UNIDXCAJA` int(10) NULL DEFAULT NULL, `DESCALT` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL16EM1` float(12, 3) NULL DEFAULT NULL, `STKL17EM1` float(12, 3) NULL DEFAULT NULL, `STKL18EM1` float(12, 3) NULL DEFAULT NULL, `STKL19EM1` float(12, 3) NULL DEFAULT NULL, `STKL20EM1` float(12, 3) NULL DEFAULT NULL, `STKL21EM1` float(12, 3) NULL DEFAULT NULL, `STKL22EM1` float(12, 3) NULL DEFAULT NULL, `STKL23EM1` float(12, 3) NULL DEFAULT NULL, `STKL24EM1` float(12, 3) NULL DEFAULT NULL, `STKL25EM1` float(12, 3) NULL DEFAULT NULL, `STKL26EM1` float(12, 3) NULL DEFAULT NULL, `STKL27EM1` float(12, 3) NULL DEFAULT NULL, `STKL28EM1` float(12, 3) NULL DEFAULT NULL, `STKL29EM1` float(12, 3) NULL DEFAULT NULL, `STKL30EM1` float(12, 3) NULL DEFAULT NULL, `VAR30` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR31` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR32` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DUMP14` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CARTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MATERIAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `INVENCAJA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKMIN` float(10, 2) NULL DEFAULT NULL, `STKMAX` float(10, 2) NULL DEFAULT NULL, `PRECAN` int(10) NULL DEFAULT NULL, `CODART1` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODART2` int(13) NULL DEFAULT NULL, `VAR1` int(1) NULL DEFAULT NULL, `VAR2` int(1) NULL DEFAULT NULL, `VAR13` int(2) NULL DEFAULT NULL, `VAR14` float(12, 3) NULL DEFAULT NULL, `VAR15` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR16` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR17` float(10, 3) NULL DEFAULT NULL, `CODPROV2` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV3` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV4` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `env01` decimal(1, 0) NULL DEFAULT NULL, `env02` decimal(1, 0) NULL DEFAULT NULL, `env03` decimal(1, 0) NULL DEFAULT NULL, `env04` decimal(1, 0) NULL DEFAULT NULL, `env05` decimal(1, 0) NULL DEFAULT NULL, `env06` decimal(1, 0) NULL DEFAULT NULL, `env07` decimal(1, 0) NULL DEFAULT NULL, `env08` decimal(1, 0) NULL DEFAULT NULL, `env09` decimal(1, 0) NULL DEFAULT NULL, `env10` decimal(1, 0) NULL DEFAULT NULL, `dolar` decimal(14, 2) NULL DEFAULT NULL, `slider` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `esweb` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `actualiza` tinyint(1) NULL DEFAULT 1, `ENV11` decimal(1, 0) NULL DEFAULT NULL, `ENV12` decimal(1, 0) NULL DEFAULT NULL, `ENV13` decimal(1, 0) NULL DEFAULT NULL, `ENV14` decimal(1, 0) NULL DEFAULT NULL, `ENV15` decimal(1, 0) NULL DEFAULT NULL, `ENV16` decimal(1, 0) NULL DEFAULT NULL, `ENV17` decimal(1, 0) NULL DEFAULT NULL, `ENV18` decimal(1, 0) NULL DEFAULT NULL, `ENV19` decimal(1, 0) NULL DEFAULT NULL, `ENV20` decimal(1, 0) NULL DEFAULT NULL, `COSTOPROM` decimal(15, 3) NULL DEFAULT NULL, `PORCFLETE` decimal(5, 2) NULL DEFAULT NULL, `COMB` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREMCOVEN` decimal(15, 3) NULL DEFAULT NULL, `PARABAL` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAVEN` date NULL DEFAULT NULL, `DIASVEN` int(6) NULL DEFAULT NULL, PRIMARY KEY (`CODIGO`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for articulo01 -- ---------------------------- DROP TABLE IF EXISTS `articulo01`; CREATE TABLE `articulo01` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PREEMP1` float(12, 3) NULL DEFAULT NULL, `PREEMP2` float(12, 3) NULL DEFAULT NULL, `PREEMP3` float(12, 3) NULL DEFAULT NULL, `PREEMP4` float(12, 3) NULL DEFAULT NULL, `PREEMP5` float(12, 3) NULL DEFAULT NULL, `PREMBRU` float(11, 2) NULL DEFAULT NULL, `PREMCO1` float(11, 2) NULL DEFAULT NULL, `BOTON` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERIES` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPRESORA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKCRI` int(4) NULL DEFAULT NULL, `SIGLA` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLETE` float(7, 2) NULL DEFAULT NULL, `IMAGEN` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPUESTO` int(2) NULL DEFAULT NULL, `TIPO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL06EM1` float(12, 3) NULL DEFAULT NULL, `STKL07EM1` float(12, 3) NULL DEFAULT NULL, `STKL08EM1` float(12, 3) NULL DEFAULT NULL, `STKL09EM1` float(12, 3) NULL DEFAULT NULL, `STKL11EM1` float(12, 3) NULL DEFAULT NULL, `STKL12EM1` float(12, 3) NULL DEFAULT NULL, `STKL13EM1` float(12, 3) NULL DEFAULT NULL, `STKL14EM1` float(12, 3) NULL DEFAULT NULL, `STKL15EM1` float(12, 3) NULL DEFAULT NULL, `STKL10EM1` float(12, 3) NULL DEFAULT NULL, `STOCK` float(10, 3) NULL DEFAULT NULL, `COSTOUS` float(10, 2) NULL DEFAULT NULL, `COSTOCIF` float(10, 2) NULL DEFAULT NULL, `PRECAN1` int(4) NULL DEFAULT NULL, `PROVEEDOR2` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR3` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PROVEEDOR4` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESBASICO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COSTOPROV1` float(9, 2) NULL DEFAULT NULL, `COSTOPROV2` float(9, 2) NULL DEFAULT NULL, `COSTOPROV3` float(9, 2) NULL DEFAULT NULL, `COSTOPROV4` float(9, 2) NULL DEFAULT NULL, `STKL01EM1` float(12, 3) NULL DEFAULT NULL, `STKL02EM1` float(12, 3) NULL DEFAULT NULL, `STKL03EM1` float(12, 3) NULL DEFAULT NULL, `STKL04EM1` float(12, 3) NULL DEFAULT NULL, `STKL05EM1` float(12, 3) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `ESINGRED` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VALQUITA` int(5) NULL DEFAULT NULL, `VALAGRE` int(5) NULL DEFAULT NULL, `SIGLAPREC1` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC2` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC3` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLAPREC4` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `AFECTAINV` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORDETA` float(6, 2) NULL DEFAULT NULL, `PORMAYO` float(6, 2) NULL DEFAULT NULL, `POROFER` float(6, 2) NULL DEFAULT NULL, `PORDESP` float(6, 2) NULL DEFAULT NULL, `PORGERE` float(6, 2) NULL DEFAULT NULL, `ENVASES` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PORC1` float(5, 2) NULL DEFAULT NULL, `PORC2` float(5, 2) NULL DEFAULT NULL, `CREDITO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODIMP` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHACOMP` date NULL DEFAULT NULL, `DESCORT` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FLUCTUA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PESO` float(10, 3) NULL DEFAULT NULL, `SIGLA1` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SIGLA2` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UTILPROD1` float(10, 2) NULL DEFAULT NULL, `UTILPROD2` float(10, 2) NULL DEFAULT NULL, `MARGEN` float(7, 2) NULL DEFAULT NULL, `PREMCO2` float(10, 2) NULL DEFAULT NULL, `PRECAN2` int(7) NULL DEFAULT NULL, `PRECAN3` int(7) NULL DEFAULT NULL, `PRECAN4` int(7) NULL DEFAULT NULL, `PRECAN5` int(7) NULL DEFAULT NULL, `VAR01` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR02` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR03` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR04` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR05` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR06` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UNIDXCAJA` int(10) NULL DEFAULT NULL, `DESCALT` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKL16EM1` float(12, 3) NULL DEFAULT NULL, `STKL17EM1` float(12, 3) NULL DEFAULT NULL, `STKL18EM1` float(12, 3) NULL DEFAULT NULL, `STKL19EM1` float(12, 3) NULL DEFAULT NULL, `STKL20EM1` float(12, 3) NULL DEFAULT NULL, `STKL21EM1` float(12, 3) NULL DEFAULT NULL, `STKL22EM1` float(12, 3) NULL DEFAULT NULL, `STKL23EM1` float(12, 3) NULL DEFAULT NULL, `STKL24EM1` float(12, 3) NULL DEFAULT NULL, `STKL25EM1` float(12, 3) NULL DEFAULT NULL, `STKL26EM1` float(12, 3) NULL DEFAULT NULL, `STKL27EM1` float(12, 3) NULL DEFAULT NULL, `STKL28EM1` float(12, 3) NULL DEFAULT NULL, `STKL29EM1` float(12, 3) NULL DEFAULT NULL, `STKL30EM1` float(12, 3) NULL DEFAULT NULL, `VAR30` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR31` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR32` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DUMP14` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CARTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MATERIAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `INVENCAJA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STKMIN` float(10, 2) NULL DEFAULT NULL, `STKMAX` float(10, 2) NULL DEFAULT NULL, `PRECAN` int(10) NULL DEFAULT NULL, `CODART1` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODART2` int(13) NULL DEFAULT NULL, `VAR1` int(1) NULL DEFAULT NULL, `VAR2` int(1) NULL DEFAULT NULL, `VAR13` int(2) NULL DEFAULT NULL, `VAR14` float(12, 3) NULL DEFAULT NULL, `VAR15` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR16` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR17` float(10, 3) NULL DEFAULT NULL, `CODPROV2` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV3` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROV4` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `env01` decimal(1, 0) NULL DEFAULT NULL, `env02` decimal(1, 0) NULL DEFAULT NULL, `env03` decimal(1, 0) NULL DEFAULT NULL, `env04` decimal(1, 0) NULL DEFAULT NULL, `env05` decimal(1, 0) NULL DEFAULT NULL, `env06` decimal(1, 0) NULL DEFAULT NULL, `env07` decimal(1, 0) NULL DEFAULT NULL, `env08` decimal(1, 0) NULL DEFAULT NULL, `env09` decimal(1, 0) NULL DEFAULT NULL, `env10` decimal(1, 0) NULL DEFAULT NULL, PRIMARY KEY (`CODIGO`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for articulo_precios_log -- ---------------------------- DROP TABLE IF EXISTS `articulo_precios_log`; CREATE TABLE `articulo_precios_log` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `codigo` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `descrip` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `campo` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `valor_anterior` decimal(18, 4) NULL DEFAULT NULL, `valor_nuevo` decimal(18, 4) NULL DEFAULT NULL, `usuario` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `origen` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha_cambio` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `ip` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_codigo_fecha`(`codigo`, `fecha_cambio`) USING BTREE, INDEX `idx_usuario_fecha`(`usuario`, `fecha_cambio`) USING BTREE, INDEX `idx_campo_fecha`(`campo`, `fecha_cambio`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 156 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for autperfil -- ---------------------------- DROP TABLE IF EXISTS `autperfil`; CREATE TABLE `autperfil` ( `codigo` int(3) NOT NULL, `funcion` int(3) NULL DEFAULT NULL, `descrip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`codunico`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for bancos -- ---------------------------- DROP TABLE IF EXISTS `bancos`; CREATE TABLE `bancos` ( `codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, UNIQUE INDEX `uq_bancos_codigo`(`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for bcom2gastos -- ---------------------------- DROP TABLE IF EXISTS `bcom2gastos`; CREATE TABLE `bcom2gastos` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `CODUNICO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `TIPODOC` int(3) NOT NULL DEFAULT 39, `FOLIO` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `FECHA` date NOT NULL, `RUT_PROVEEDOR` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `PROVEEDOR` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `LOCAL` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `NETO` decimal(14, 2) NOT NULL DEFAULT 0.00, `IVA` decimal(14, 2) NOT NULL DEFAULT 0.00, `EXENTO` decimal(14, 2) NOT NULL DEFAULT 0.00, `TOTAL` decimal(14, 2) NOT NULL DEFAULT 0.00, `CONDICION_PAGO` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'CONTADO', `FORMA_PAGO` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `FECHA_VENCIMIENTO` date NULL DEFAULT NULL, `TOTAL_PAGADO` decimal(14, 2) NOT NULL DEFAULT 0.00, `PENDNC` tinyint(1) NOT NULL DEFAULT 0, `MONTO_NC_PENDIENTE` decimal(14, 2) NOT NULL DEFAULT 0.00, `MOTIVO_NC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `ESTADO_NC` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `MONTO_NC_RECIBIDO` decimal(14, 2) NOT NULL DEFAULT 0.00, `ANULADO` tinyint(1) NOT NULL DEFAULT 0, `OBSERVACION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `USUARIO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `UPDATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_bcom2gastos_codunico`(`CODUNICO`) USING BTREE, UNIQUE INDEX `uk_bcom2gastos_documento`(`TIPODOC`, `FOLIO`, `RUT_PROVEEDOR`, `LOCAL`) USING BTREE, INDEX `idx_bcom2gastos_fecha_local`(`FECHA`, `LOCAL`) USING BTREE, INDEX `idx_bcom2gastos_proveedor`(`RUT_PROVEEDOR`) USING BTREE, INDEX `idx_bcom2gastos_nc`(`PENDNC`, `ESTADO_NC`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for boledob -- ---------------------------- DROP TABLE IF EXISTS `boledob`; CREATE TABLE `boledob` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `FL` int(10) NULL DEFAULT NULL, `LOCAL` int(3) NULL DEFAULT NULL, `CAJA` int(1) NULL DEFAULT NULL, `ILA0` int(10) NULL DEFAULT NULL, `ILA1` int(10) NULL DEFAULT NULL, `ILA2` int(10) NULL DEFAULT NULL, `ILA3` int(10) NULL DEFAULT NULL, `ILA4` int(10) NULL DEFAULT NULL, `ILA5` int(10) NULL DEFAULT NULL, `ILA9` int(10) NULL DEFAULT NULL, `IVA` int(10) NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `VAR01` float(12, 3) NULL DEFAULT NULL, `VAR02` int(12) NULL DEFAULT NULL, `VAR03` int(12) NULL DEFAULT NULL, `VAR04` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR05` bit(1) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`CODUNICO`) USING BTREE, INDEX `idx_boledob_b8_codigo`(`CODIGO`) USING BTREE, INDEX `idx_boledob_b9_codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for bolepdf -- ---------------------------- DROP TABLE IF EXISTS `bolepdf`; CREATE TABLE `bolepdf` ( `codigo` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pdf` blob NULL, `fecha` date NULL DEFAULT NULL, `dtes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `empresa` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codunico`) USING BTREE, INDEX `codigo`(`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for botones -- ---------------------------- DROP TABLE IF EXISTS `botones`; CREATE TABLE `botones` ( `codigo` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descort` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `prventa` decimal(8, 0) NULL DEFAULT NULL, `nombreboto` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `colboton` decimal(10, 0) NULL DEFAULT NULL, `boton` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `backcolor` decimal(10, 0) NULL DEFAULT NULL, `nomfont` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tamfont` decimal(10, 0) NULL DEFAULT NULL, `nombmp` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipo` decimal(2, 0) NULL DEFAULT NULL, `estadoboto` bit(1) NULL DEFAULT NULL, `modificado` decimal(1, 0) NULL DEFAULT NULL, `mostrar` decimal(1, 0) NULL DEFAULT NULL, `nomfuncion` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nropantall` decimal(4, 0) NULL DEFAULT NULL, `pictpos` decimal(10, 0) NULL DEFAULT NULL, PRIMARY KEY (`boton`) USING BTREE, INDEX `boton`(`boton`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for bottip -- ---------------------------- DROP TABLE IF EXISTS `bottip`; CREATE TABLE `bottip` ( `codigo` varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip6` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip7` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for br0_orders -- ---------------------------- DROP TABLE IF EXISTS `br0_orders`; CREATE TABLE `br0_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `invoice_id` int(11) NULL DEFAULT 0, `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `subscriber_id` int(11) NULL DEFAULT 0, `order_subtotal` decimal(12, 2) NULL DEFAULT NULL, `order_tax` decimal(12, 2) NULL DEFAULT 0.00, `order_discount` decimal(12, 2) NULL DEFAULT 0.00, `order_total` decimal(12, 2) NULL DEFAULT NULL, `order_commission` float NULL DEFAULT 0, `tax_percent` decimal(11, 2) NULL DEFAULT NULL, `including_tax` tinyint(1) NULL DEFAULT 0, `currency_code` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `currency_symbol` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `payment_method` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `payment_status` tinyint(1) NULL DEFAULT 0, `wallets` float NULL DEFAULT 0, `wallets_refund` datetime NULL DEFAULT NULL, `transaction_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `payment_id` int(11) NULL DEFAULT NULL, `payment_details` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `shipment_status` tinyint(1) NULL DEFAULT 0, `item` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `qty` int(11) NULL DEFAULT 1, `comments` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `notes` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `is_invoiced` tinyint(1) NULL DEFAULT 0, `date_paid` date NULL DEFAULT NULL, `next_invoice_date` date NULL DEFAULT NULL, `expires_on` date NULL DEFAULT NULL, `affiliate_id` bigint(20) NULL DEFAULT 0, `affiliate_commission` float NULL DEFAULT 0, `commission_module` tinyint(1) NULL DEFAULT 0, `cronrun_on` datetime NULL DEFAULT NULL, `created_on` datetime NULL DEFAULT CURRENT_TIMESTAMP, `modified_on` datetime NULL DEFAULT CURRENT_TIMESTAMP, `ip_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` tinyint(1) NULL DEFAULT 0, `deleted` tinyint(1) NULL DEFAULT 0, `send_mail` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `invoice_id`(`invoice_id`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `deleted`(`deleted`) USING BTREE, INDEX `status_deleted`(`status`, `deleted`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for caf_uploads -- ---------------------------- DROP TABLE IF EXISTS `caf_uploads`; CREATE TABLE `caf_uploads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `local` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `td` int(11) NOT NULL, `rut_emisor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `folio_desde` int(11) NULL DEFAULT NULL, `folio_hasta` int(11) NULL DEFAULT NULL, `fa` date NULL DEFAULT NULL, `idk` int(11) NULL DEFAULT NULL, `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `caf_xml` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `clave_pem` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `uploaded_by` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `uploaded_at` datetime NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_local_td`(`local`, `td`) USING BTREE, INDEX `idx_uploaded_at`(`uploaded_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for cajas -- ---------------------------- DROP TABLE IF EXISTS `cajas`; CREATE TABLE `cajas` ( `id` int(11) NOT NULL, `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for camiones -- ---------------------------- DROP TABLE IF EXISTS `camiones`; CREATE TABLE `camiones` ( `codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `chofer` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta1` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta2` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta3` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `patente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `marca` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `tipo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `estado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `Vencim_RT` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `vencim_pc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `vencim_soap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for choferes -- ---------------------------- DROP TABLE IF EXISTS `choferes`; CREATE TABLE `choferes` ( `codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `descrip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `comision` decimal(7, 0) NULL DEFAULT NULL, `Licencia` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fech_venc_licen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `estado` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `activo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `condicion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fech_adq_licen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for cierres -- ---------------------------- DROP TABLE IF EXISTS `cierres`; CREATE TABLE `cierres` ( `CIERRE` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `FECHA` date NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `codunico` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, INDEX `fecha`(`FECHA`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for clientes -- ---------------------------- DROP TABLE IF EXISTS `clientes`; CREATE TABLE `clientes` ( `CODIGO` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DIREC` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FONO` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CORRELASUC` int(1) NULL DEFAULT NULL, `MAIL` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COMUNASTR` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIUDADSTR` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `GIROSTR` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MAILDTE` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `credito` int(10) NULL DEFAULT NULL, `comuna` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudad` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `despacha` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `mail2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `var1` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `vendedor` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODIGO`) USING BTREE, UNIQUE INDEX `ux_clientes_codigo`(`CODIGO`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for clientes_condiciones -- ---------------------------- DROP TABLE IF EXISTS `clientes_condiciones`; CREATE TABLE `clientes_condiciones` ( `rut` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `limite_credito` decimal(15, 0) NOT NULL DEFAULT 0, `dias_credito` int(11) NOT NULL DEFAULT 30, `bloqueado_credito` tinyint(1) NOT NULL DEFAULT 0, `observacion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `responsable` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `fecha_actualizacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`rut`) USING BTREE, INDEX `idx_clientes_condiciones_bloqueado`(`bloqueado_credito`) USING BTREE, INDEX `idx_clientes_condiciones_actualizacion`(`fecha_actualizacion`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for com2gastos_detalle -- ---------------------------- DROP TABLE IF EXISTS `com2gastos_detalle`; CREATE TABLE `com2gastos_detalle` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `CODUNICO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `ORIGEN_DOCUMENTO` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `LINEA` int(10) NOT NULL DEFAULT 1, `DESCRIPCION` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CANTIDAD` decimal(14, 3) NOT NULL DEFAULT 1.000, `VALOR_UNITARIO` decimal(14, 2) NOT NULL DEFAULT 0.00, `NETO` decimal(14, 2) NOT NULL DEFAULT 0.00, `IVA` decimal(14, 2) NOT NULL DEFAULT 0.00, `EXENTO` decimal(14, 2) NOT NULL DEFAULT 0.00, `TOTAL` decimal(14, 2) NOT NULL DEFAULT 0.00, `CLASIFICACION` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'GASTO GENERAL', `ES_ACTIVO_FIJO` tinyint(1) NOT NULL DEFAULT 0, `CATEGORIA_ACTIVO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `RESPONSABLE_ACTIVO` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `OBSERVACION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_com2gastos_linea`(`CODUNICO`, `LINEA`) USING BTREE, INDEX `idx_com2gastos_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_com2gastos_clasificacion`(`CLASIFICACION`) USING BTREE, INDEX `idx_com2gastos_activo`(`ES_ACTIVO_FIJO`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for conexion -- ---------------------------- DROP TABLE IF EXISTS `conexion`; CREATE TABLE `conexion` ( `empresa` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fechault` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `caja` decimal(2, 0) NULL DEFAULT NULL, `pagina` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `actualiza` int(1) NULL DEFAULT NULL, `ultfecact` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `necesitabol` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fechabol` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `necesitafac` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fechafac` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idanyd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cafbol` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `caffac` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `cafnot` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `cafgui` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `idbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idfac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idnot` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `idgui` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rangobol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rangofac` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rangogui` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rangonot` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `version` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `certificado` blob NULL, `fonosoporte` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for cont_activos_fijos -- ---------------------------- DROP TABLE IF EXISTS `cont_activos_fijos`; CREATE TABLE `cont_activos_fijos` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `codigo_activo` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `fecha_compra` date NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `categoria` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `descripcion` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `proveedor` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `rut_proveedor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_documento` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `folio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `codunico_compra` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `detalle_compra_id` bigint(20) UNSIGNED NULL DEFAULT NULL, `valor_compra` decimal(14, 2) NOT NULL DEFAULT 0.00, `responsable` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `estado` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ACTIVO', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_cont_activos_codigo`(`codigo_activo`) USING BTREE, INDEX `idx_cont_activos_fecha_local`(`fecha_compra`, `local`) USING BTREE, INDEX `idx_cont_activos_estado`(`estado`) USING BTREE, INDEX `idx_cont_activos_categoria`(`categoria`) USING BTREE, INDEX `idx_cont_activos_compra`(`codunico_compra`) USING BTREE, INDEX `idx_cont_activos_detalle`(`detalle_compra_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_clasificacion_compra -- ---------------------------- DROP TABLE IF EXISTS `cont_clasificacion_compra`; CREATE TABLE `cont_clasificacion_compra` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `doc_key` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `codunico` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_dte` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `folio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `rut_proveedor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `fecha` date NULL DEFAULT NULL, `categoria` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Pendiente revisión', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_cont_clas_doc`(`doc_key`) USING BTREE, INDEX `idx_cont_clas_categoria`(`categoria`) USING BTREE, INDEX `idx_cont_clas_docdata`(`tipo_dte`, `folio`, `rut_proveedor`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_gastos_generales -- ---------------------------- DROP TABLE IF EXISTS `cont_gastos_generales`; CREATE TABLE `cont_gastos_generales` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `fecha` date NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_gasto_id` int(10) UNSIGNED NOT NULL DEFAULT 0, `proveedor` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `rut_proveedor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_documento` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `folio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `neto` decimal(14, 2) NOT NULL DEFAULT 0.00, `iva` decimal(14, 2) NOT NULL DEFAULT 0.00, `exento` decimal(14, 2) NOT NULL DEFAULT 0.00, `total` decimal(14, 2) NOT NULL DEFAULT 0.00, `medio_pago` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `estado` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `archivo_adjunto` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cont_gastos_fecha_local`(`fecha`, `local`) USING BTREE, INDEX `idx_cont_gastos_tipo`(`tipo_gasto_id`) USING BTREE, INDEX `idx_cont_gastos_estado`(`estado`) USING BTREE, INDEX `idx_cont_gastos_doc`(`rut_proveedor`, `folio`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_obligaciones_mensuales -- ---------------------------- DROP TABLE IF EXISTS `cont_obligaciones_mensuales`; CREATE TABLE `cont_obligaciones_mensuales` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `periodo` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_obligacion` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `fecha_vencimiento` date NOT NULL, `monto_estimado` decimal(14, 2) NOT NULL DEFAULT 0.00, `monto_pagado` decimal(14, 2) NOT NULL DEFAULT 0.00, `estado` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cont_obl_periodo_local`(`periodo`, `local`) USING BTREE, INDEX `idx_cont_obl_vencimiento`(`fecha_vencimiento`) USING BTREE, INDEX `idx_cont_obl_estado`(`estado`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_remuneraciones_resumen -- ---------------------------- DROP TABLE IF EXISTS `cont_remuneraciones_resumen`; CREATE TABLE `cont_remuneraciones_resumen` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `periodo` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `trabajador` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `rut` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `haberes` decimal(14, 2) NOT NULL DEFAULT 0.00, `descuentos` decimal(14, 2) NOT NULL DEFAULT 0.00, `liquido_pagar` decimal(14, 2) NOT NULL DEFAULT 0.00, `cotizaciones` decimal(14, 2) NOT NULL DEFAULT 0.00, `aporte_empleador` decimal(14, 2) NOT NULL DEFAULT 0.00, `costo_empresa` decimal(14, 2) NOT NULL DEFAULT 0.00, `estado_pago` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cont_rem_periodo_local`(`periodo`, `local`) USING BTREE, INDEX `idx_cont_rem_rut`(`rut`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_rendiciones_caja -- ---------------------------- DROP TABLE IF EXISTS `cont_rendiciones_caja`; CREATE TABLE `cont_rendiciones_caja` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `periodo` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `responsable` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `fondo_inicial` decimal(14, 2) NOT NULL DEFAULT 0.00, `estado` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ABIERTA', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario_apertura` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario_cierre` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `fecha_apertura` date NULL DEFAULT NULL, `fecha_cierre` date NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cont_rend_periodo_local`(`periodo`, `local`) USING BTREE, INDEX `idx_cont_rend_estado`(`estado`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_rendiciones_caja_detalle -- ---------------------------- DROP TABLE IF EXISTS `cont_rendiciones_caja_detalle`; CREATE TABLE `cont_rendiciones_caja_detalle` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `rendicion_id` bigint(20) UNSIGNED NOT NULL, `fecha` date NOT NULL, `tipo_gasto_id` int(10) UNSIGNED NOT NULL DEFAULT 0, `proveedor` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `rut_proveedor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `tipo_documento` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `folio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `neto` decimal(14, 2) NOT NULL DEFAULT 0.00, `iva` decimal(14, 2) NOT NULL DEFAULT 0.00, `exento` decimal(14, 2) NOT NULL DEFAULT 0.00, `total` decimal(14, 2) NOT NULL DEFAULT 0.00, `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `usuario` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cont_rend_det_rend`(`rendicion_id`) USING BTREE, INDEX `idx_cont_rend_det_fecha`(`fecha`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cont_tipo_gasto -- ---------------------------- DROP TABLE IF EXISTS `cont_tipo_gasto`; CREATE TABLE `cont_tipo_gasto` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `codigo` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `nombre` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `iva_credito` tinyint(1) NOT NULL DEFAULT 1, `activo` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_cont_tipo_gasto_codigo`(`codigo`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for control_critico -- ---------------------------- DROP TABLE IF EXISTS `control_critico`; CREATE TABLE `control_critico` ( `CODIGO` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `LOCAL` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `STKCRI` decimal(18, 3) NOT NULL DEFAULT 0.000, `STKMIN` decimal(18, 3) NOT NULL DEFAULT 0.000, `STKIDEAL` decimal(18, 3) NOT NULL DEFAULT 0.000, `ACTUALIZA` tinyint(1) NOT NULL DEFAULT 1, `USUARIO` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `FECHA_ACTUALIZA` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`CODIGO`, `LOCAL`) USING BTREE, INDEX `IDX_CC_LOCAL`(`LOCAL`) USING BTREE, INDEX `IDX_CC_ACTUALIZA`(`ACTUALIZA`) USING BTREE, INDEX `IDX_CC_FECHA`(`FECHA_ACTUALIZA`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for correla -- ---------------------------- DROP TABLE IF EXISTS `correla`; CREATE TABLE `correla` ( `ID` int(11) NOT NULL DEFAULT 1, `NOTAVENTA` int(11) NULL DEFAULT 1, PRIMARY KEY (`ID`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for correlativo -- ---------------------------- DROP TABLE IF EXISTS `correlativo`; CREATE TABLE `correlativo` ( `prefactura` decimal(10, 0) NULL DEFAULT NULL, `guiadesp` decimal(10, 0) NULL DEFAULT NULL, `cotizacion` decimal(10, 0) NULL DEFAULT NULL, `resumen` decimal(10, 0) NULL DEFAULT NULL, `codcli` decimal(10, 0) NULL DEFAULT NULL, `compras` decimal(10, 0) NULL DEFAULT NULL, `ajustes` decimal(10, 0) NULL DEFAULT NULL, `traspasos` decimal(10, 0) NULL DEFAULT NULL, `tomas` decimal(10, 0) NULL DEFAULT NULL, `notac` decimal(10, 0) NULL DEFAULT NULL, `ote` decimal(10, 0) NULL DEFAULT NULL, `notacpra` decimal(10, 0) NULL DEFAULT NULL, `var1` decimal(10, 0) NULL DEFAULT NULL, `var2` decimal(10, 0) NULL DEFAULT NULL, `var3` decimal(10, 0) NULL DEFAULT NULL, `correcom` decimal(10, 0) NULL DEFAULT NULL, `corretras` decimal(10, 0) NULL DEFAULT NULL, `correajus` decimal(10, 0) NULL DEFAULT NULL, `corretoma` decimal(10, 0) NULL DEFAULT NULL, `corredevoc` decimal(10, 0) NULL DEFAULT NULL, `corredevop` decimal(10, 0) NULL DEFAULT NULL, `corpago` decimal(10, 0) NULL DEFAULT NULL, `id` decimal(1, 0) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_correlativo_id`(`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for correlativo_ped -- ---------------------------- DROP TABLE IF EXISTS `correlativo_ped`; CREATE TABLE `correlativo_ped` ( `id` int(11) NOT NULL, `yy` tinyint(3) UNSIGNED NOT NULL, `yday` smallint(5) UNSIGNED NOT NULL, `seq` int(10) UNSIGNED NOT NULL, `last_key` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE INDEX `uniq_yy_yday`(`yy`, `yday`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for correlativos_pedcliente -- ---------------------------- DROP TABLE IF EXISTS `correlativos_pedcliente`; CREATE TABLE `correlativos_pedcliente` ( `nombre` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `actual` int(10) UNSIGNED NOT NULL DEFAULT 0, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`nombre`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for correos -- ---------------------------- DROP TABLE IF EXISTS `correos`; CREATE TABLE `correos` ( `codigo` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email1` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email2` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email3` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `direc` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for cuentas -- ---------------------------- DROP TABLE IF EXISTS `cuentas`; CREATE TABLE `cuentas` ( `codigo` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `bancos` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, UNIQUE INDEX `uq_cuentas_codigo`(`codigo`) USING BTREE, INDEX `idx_cuentas_banco`(`bancos`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for dbclient -- ---------------------------- DROP TABLE IF EXISTS `dbclient`; CREATE TABLE `dbclient` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `TIPODOC` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MESCONTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `EXENTO` int(12) NULL DEFAULT NULL, `VAR2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for dbprovee -- ---------------------------- DROP TABLE IF EXISTS `dbprovee`; CREATE TABLE `dbprovee` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `FL` int(10) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `FOLIOFAC` int(10) NULL DEFAULT NULL, `TIPODOC` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MESCONTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR1` int(3) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for despacha -- ---------------------------- DROP TABLE IF EXISTS `despacha`; CREATE TABLE `despacha` ( `codigo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for detabonos -- ---------------------------- DROP TABLE IF EXISTS `detabonos`; CREATE TABLE `detabonos` ( `codigo` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `fechacob` date NULL DEFAULT NULL, `monto` decimal(15, 0) NULL DEFAULT NULL, `completo` bit(1) NULL DEFAULT NULL, `nrocheq` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cuenta` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `corpago` decimal(15, 0) NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `local` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `hora` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `docu` decimal(15, 0) NULL DEFAULT NULL, PRIMARY KEY (`codunico`) USING BTREE, INDEX `rut`(`rut`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for detapla -- ---------------------------- DROP TABLE IF EXISTS `detapla`; CREATE TABLE `detapla` ( `codigo` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pantalla` decimal(1, 0) NULL DEFAULT NULL, `codpan` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nroboton` decimal(2, 0) NULL DEFAULT NULL, `desboton` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codorigen` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nrosel` decimal(2, 0) NULL DEFAULT NULL, `salta` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`codunico`) USING BTREE, INDEX `codunico`(`codunico`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for detmov -- ---------------------------- DROP TABLE IF EXISTS `detmov`; CREATE TABLE `detmov` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` float(13, 2) NULL DEFAULT NULL, `SBTOTAL` int(15) NULL DEFAULT NULL, `CANTIDAD` float(15, 3) NULL DEFAULT NULL, `DOCU` decimal(15, 0) NULL DEFAULT NULL, `DESC1` float(10, 6) NULL DEFAULT NULL, `DESC2` float(10, 6) NULL DEFAULT NULL, `DESC3` float(10, 6) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `TIPPRE` int(1) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `RECIBIDO` int(12) NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `COSTOUS` float(13, 2) NULL DEFAULT NULL, `COSTOCIF` float(13, 2) NULL DEFAULT NULL, `PRBRUTO` float(13, 3) NULL DEFAULT NULL, `PRVENTA` int(9) NULL DEFAULT NULL, `PRVENTAANT` int(9) NULL DEFAULT NULL, `TIPODOC` int(5) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRECIO1` float(13, 3) NULL DEFAULT NULL, `PRECIO2` float(13, 3) NULL DEFAULT NULL, `PRECIO3` float(13, 3) NULL DEFAULT NULL, `PRECIO4` float(13, 3) NULL DEFAULT NULL, `FACTURA` int(12) NULL DEFAULT NULL, `VALIMP` float(12, 3) NULL DEFAULT NULL, `FACTURAPAR` int(12) NULL DEFAULT NULL, `VAR1` int(12) NULL DEFAULT NULL, `VAR2` int(12) NULL DEFAULT NULL, `VAR3` float(12, 3) NULL DEFAULT NULL, `VAR4` int(1) NULL DEFAULT NULL, `VAR5` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `imp` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for display_last -- ---------------------------- DROP TABLE IF EXISTS `display_last`; CREATE TABLE `display_last` ( `id` tinyint(4) NOT NULL, `fecha` date NOT NULL, `caja_id` int(11) NOT NULL, `modulo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `numero` tinyint(3) UNSIGNED NOT NULL, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `fk_display_last_cajas`(`caja_id`) USING BTREE, CONSTRAINT `fk_display_last_cajas` FOREIGN KEY (`caja_id`) REFERENCES `cajas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for docmeta -- ---------------------------- DROP TABLE IF EXISTS `docmeta`; CREATE TABLE `docmeta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `codunico` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `docu` int(11) NOT NULL, `tipomov` int(11) NOT NULL, `tipodoc` int(11) NOT NULL, `local` int(11) NOT NULL, `caja` int(11) NOT NULL, `ind_traslado` int(11) NULL DEFAULT NULL, `rut_cli` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `nom_cli` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `ref_codunico` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ref_docu` int(11) NULL DEFAULT NULL, `ref_tipodoc` int(11) NULL DEFAULT NULL, `ref_tipomov` int(11) NULL DEFAULT NULL, `ref_reason` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ref_folio` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ref_fch` date NULL DEFAULT NULL, `dir_cli` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fono_cli` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `mail_cli` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `comuna_cli` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ciudad_cli` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giro_cli` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_codunico`(`codunico`) USING BTREE, INDEX `idx_local_fecha`(`local`, `created_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for docupagos -- ---------------------------- DROP TABLE IF EXISTS `docupagos`; CREATE TABLE `docupagos` ( `docu` decimal(10, 0) NOT NULL, `rut` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cliente` char(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `total` decimal(10, 0) NULL DEFAULT NULL, `fecha_pago` date NULL DEFAULT NULL, `estado_pago` decimal(1, 0) NULL DEFAULT NULL, `forma_pago` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipomov` decimal(10, 0) NULL DEFAULT NULL, PRIMARY KEY (`docu`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for dte_estado_sii -- ---------------------------- DROP TABLE IF EXISTS `dte_estado_sii`; CREATE TABLE `dte_estado_sii` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `local_codigo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `tipo_dte` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `folio` bigint(20) NOT NULL, `codunico` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rut_emisor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rut_receptor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fecha_emision` date NULL DEFAULT NULL, `total` decimal(14, 2) NOT NULL DEFAULT 0.00, `estado_sii` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `estado_envio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `track_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `xml_ruta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pdf_ruta` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `xml_hash` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fecha_xml` datetime NULL DEFAULT NULL, `fecha_envio_sii` datetime NULL DEFAULT NULL, `fecha_estado_sii` datetime NULL DEFAULT NULL, `fecha_sync` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_dte_estado_doc`(`local_codigo`, `tipo_dte`, `folio`) USING BTREE, UNIQUE INDEX `uq_dte_estado_codunico`(`codunico`) USING BTREE, INDEX `idx_estado_sii`(`estado_sii`) USING BTREE, INDEX `idx_track_id`(`track_id`) USING BTREE, INDEX `idx_fecha_emision`(`fecha_emision`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for dte_observaciones -- ---------------------------- DROP TABLE IF EXISTS `dte_observaciones`; CREATE TABLE `dte_observaciones` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `codunico` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `usuario` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_codunico`(`codunico`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for enviodte -- ---------------------------- DROP TABLE IF EXISTS `enviodte`; CREATE TABLE `enviodte` ( `RUTCLI` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CLIENTE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DOCU` int(12) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `FECHAENVIO` date NULL DEFAULT NULL, `HORAENVIO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DTES` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `NETO` int(13) NULL DEFAULT NULL, `IVA` int(13) NULL DEFAULT NULL, `IMPADI` int(13) NULL DEFAULT NULL, `TOTAL` int(13) NULL DEFAULT NULL, `FOLIO` int(13) NULL DEFAULT NULL, `TIPODOC` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `dtesc` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `rutempresa` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `NOMBREDOC` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `GLOSASII` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'MODO DEMO', `TOKENTAB` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `ERRCOD` int(11) NULL DEFAULT 0, `PDF` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `ENVIAMAIL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `IDENENVIO` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', PRIMARY KEY (`codunico`) USING BTREE, INDEX `idx_enviodte_b8_folio_tipo`(`FOLIO`, `TIPODOC`) USING BTREE, INDEX `idx_enviodte_b9_folio_tipo`(`FOLIO`, `TIPODOC`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for factcomregi -- ---------------------------- DROP TABLE IF EXISTS `factcomregi`; CREATE TABLE `factcomregi` ( `DOCU` decimal(13, 0) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOTDOC` int(12) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `FORMPAGO` int(2) NULL DEFAULT NULL, `TIPODOC` int(8) NULL DEFAULT NULL, `DES1` float(5, 2) NULL DEFAULT NULL, `DES2` float(5, 2) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RECDETC` int(12) NULL DEFAULT NULL, `RECDETT` int(12) NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCORI` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCFIN` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CRED` bit(1) NULL DEFAULT NULL, `RESUMEN` int(10) NULL DEFAULT NULL, `IVA` int(10) NULL DEFAULT NULL, `CUENTAS` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `ILA1` int(10) NULL DEFAULT NULL, `ILA2` int(10) NULL DEFAULT NULL, `ILA3` int(10) NULL DEFAULT NULL, `ILA4` int(10) NULL DEFAULT NULL, `ILA5` int(10) NULL DEFAULT NULL, `ILA6` int(10) NULL DEFAULT NULL, `FLETE` int(10) NULL DEFAULT NULL, `FOLIOFAC` int(10) NULL DEFAULT NULL, `TIPODOCU` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FACTURA` int(12) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `responsable` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fpago` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `anexo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `banco` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cuenta` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `numedoc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `odcom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `plazo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `totalanexo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `totalfact` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOTALPAGO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PENDnc` decimal(2, 0) NULL DEFAULT NULL, `NUMERONC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETONC` decimal(18, 2) NOT NULL DEFAULT 0.00, `IVANC` decimal(18, 2) NOT NULL DEFAULT 0.00, `TOTALNC` decimal(18, 2) NOT NULL DEFAULT 0.00, `ABONO1` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO1` date NULL DEFAULT NULL, `FECHAVENC1` date NULL DEFAULT NULL, `BANCO1` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA1` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO1` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC1` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO2` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO2` date NULL DEFAULT NULL, `FECHAVENC2` date NULL DEFAULT NULL, `BANCO2` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA2` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO2` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC2` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO3` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS3` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO3` date NULL DEFAULT NULL, `FECHAVENC3` date NULL DEFAULT NULL, `BANCO3` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA3` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO3` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC3` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC3` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO4` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS4` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO4` date NULL DEFAULT NULL, `FECHAVENC4` date NULL DEFAULT NULL, `BANCO4` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA4` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO4` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC4` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC4` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION4` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO5` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS5` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO5` date NULL DEFAULT NULL, `FECHAVENC5` date NULL DEFAULT NULL, `BANCO5` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA5` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO5` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC5` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC5` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO6` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS6` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO6` date NULL DEFAULT NULL, `FECHAVENC6` date NULL DEFAULT NULL, `BANCO6` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA6` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO6` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC6` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC6` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION6` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO7` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS7` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO7` date NULL DEFAULT NULL, `FECHAVENC7` date NULL DEFAULT NULL, `BANCO7` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA7` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO7` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC7` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC7` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION7` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO8` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS8` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO8` date NULL DEFAULT NULL, `FECHAVENC8` date NULL DEFAULT NULL, `BANCO8` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA8` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO8` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC8` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC8` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION8` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO9` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS9` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO9` date NULL DEFAULT NULL, `FECHAVENC9` date NULL DEFAULT NULL, `BANCO9` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA9` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO9` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC9` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC9` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION9` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO10` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS10` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO10` date NULL DEFAULT NULL, `FECHAVENC10` date NULL DEFAULT NULL, `BANCO10` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA10` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO10` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC10` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC10` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION10` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO11` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS11` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO11` date NULL DEFAULT NULL, `FECHAVENC11` date NULL DEFAULT NULL, `BANCO11` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA11` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO11` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC11` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC11` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION11` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO12` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS12` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO12` date NULL DEFAULT NULL, `FECHAVENC12` date NULL DEFAULT NULL, `BANCO12` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA12` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO12` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC12` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC12` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION12` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO13` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS13` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO13` date NULL DEFAULT NULL, `FECHAVENC13` date NULL DEFAULT NULL, `BANCO13` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA13` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO13` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC13` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC13` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION13` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO14` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS14` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO14` date NULL DEFAULT NULL, `FECHAVENC14` date NULL DEFAULT NULL, `BANCO14` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA14` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO14` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC14` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC14` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION14` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO15` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS15` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO15` date NULL DEFAULT NULL, `FECHAVENC15` date NULL DEFAULT NULL, `BANCO15` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA15` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO15` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC15` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC15` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION15` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO16` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS16` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO16` date NULL DEFAULT NULL, `FECHAVENC16` date NULL DEFAULT NULL, `BANCO16` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA16` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO16` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC16` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC16` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION16` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO17` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS17` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO17` date NULL DEFAULT NULL, `FECHAVENC17` date NULL DEFAULT NULL, `BANCO17` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA17` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO17` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC17` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC17` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION17` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO18` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS18` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO18` date NULL DEFAULT NULL, `FECHAVENC18` date NULL DEFAULT NULL, `BANCO18` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA18` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO18` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC18` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC18` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION18` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO19` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS19` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO19` date NULL DEFAULT NULL, `FECHAVENC19` date NULL DEFAULT NULL, `BANCO19` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA19` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO19` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC19` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC19` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION19` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO20` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS20` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO20` date NULL DEFAULT NULL, `FECHAVENC20` date NULL DEFAULT NULL, `BANCO20` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA20` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO20` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC20` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC20` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION20` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO21` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS21` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO21` date NULL DEFAULT NULL, `FECHAVENC21` date NULL DEFAULT NULL, `BANCO21` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA21` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO21` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC21` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC21` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION21` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO22` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS22` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO22` date NULL DEFAULT NULL, `FECHAVENC22` date NULL DEFAULT NULL, `BANCO22` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA22` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO22` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC22` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC22` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION22` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO23` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS23` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO23` date NULL DEFAULT NULL, `FECHAVENC23` date NULL DEFAULT NULL, `BANCO23` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA23` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO23` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC23` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC23` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION23` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ABONO24` decimal(18, 2) NOT NULL DEFAULT 0.00, `FPAGOS24` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAPAGO24` date NULL DEFAULT NULL, `FECHAVENC24` date NULL DEFAULT NULL, `BANCO24` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA24` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADO24` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `NUMDOC24` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESTADODOC24` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION24` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, UNIQUE INDEX `uq_factcomregi_docu_rut`(`DOCU`, `RUT`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `idx_b52_cxp_proveedor_fecha`(`RUT`, `FECHA`, `ESTADO`, `DOCU`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for factcomregi_pago_log -- ---------------------------- DROP TABLE IF EXISTS `factcomregi_pago_log`; CREATE TABLE `factcomregi_pago_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `codunico` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `usuario` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `accion` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `motivo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `antes_json` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `despues_json` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_cod`(`codunico`) USING BTREE, INDEX `idx_user_date`(`usuario`, `created_at`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for factcomregi_pagos -- ---------------------------- DROP TABLE IF EXISTS `factcomregi_pagos`; CREATE TABLE `factcomregi_pagos` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `NRO_CUOTA` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `FORMPAGO_CODIGO` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FORMPAGO_DESCRIP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `BANCO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CUENTA` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NUMEDOC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA_VENCIMIENTO` date NULL DEFAULT NULL, `FECHA_PAGO` date NULL DEFAULT NULL, `MONTO` decimal(18, 2) NOT NULL DEFAULT 0.00, `ESTADO` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'PENDIENTE', `ESTADO_DOCUMENTO` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSERVACION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ORIGEN` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'MANUAL', `USUARIO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `UPDATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uq_factcomregi_pago_cuota`(`CODUNICO`, `NRO_CUOTA`) USING BTREE, INDEX `idx_factcomregi_pago_estado`(`ESTADO`) USING BTREE, INDEX `idx_factcomregi_pago_vencimiento`(`FECHA_VENCIMIENTO`) USING BTREE, INDEX `idx_factcomregi_pago_fecha`(`FECHA_PAGO`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for factdob -- ---------------------------- DROP TABLE IF EXISTS `factdob`; CREATE TABLE `factdob` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `LOCAL` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `VAR2` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `EXENTO` int(12) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FL` int(11) NULL DEFAULT 0, `VAR1` decimal(15, 2) NULL DEFAULT 0.00, `VAR02` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `VAR3` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `VAR4` decimal(15, 3) NULL DEFAULT 0.000, `TF` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `ENVIADO` tinyint(1) NULL DEFAULT 0, `FECHAENV` datetime NULL DEFAULT NULL, `IEB1` decimal(15, 2) NULL DEFAULT 0.00, `IEV1` decimal(15, 2) NULL DEFAULT 0.00, `IEB2` decimal(15, 2) NULL DEFAULT 0.00, `IEV2` decimal(15, 2) NULL DEFAULT 0.00, `IEB3` decimal(15, 2) NULL DEFAULT 0.00, `IEV3` decimal(15, 2) NULL DEFAULT 0.00, `IEB4` decimal(15, 2) NULL DEFAULT 0.00, `IEV4` decimal(15, 2) NULL DEFAULT 0.00, PRIMARY KEY (`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for factpdf -- ---------------------------- DROP TABLE IF EXISTS `factpdf`; CREATE TABLE `factpdf` ( `dtes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codigo` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha` date NULL DEFAULT NULL, `pdf` blob NULL, `codunico` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipodoc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for fcom2gastos -- ---------------------------- DROP TABLE IF EXISTS `fcom2gastos`; CREATE TABLE `fcom2gastos` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `CODUNICO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `TIPODOC` int(3) NOT NULL DEFAULT 33, `FOLIO` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `FECHA` date NOT NULL, `RUT_PROVEEDOR` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `PROVEEDOR` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `LOCAL` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `NETO` decimal(14, 2) NOT NULL DEFAULT 0.00, `IVA` decimal(14, 2) NOT NULL DEFAULT 0.00, `EXENTO` decimal(14, 2) NOT NULL DEFAULT 0.00, `TOTAL` decimal(14, 2) NOT NULL DEFAULT 0.00, `CONDICION_PAGO` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'CONTADO', `FORMA_PAGO` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `FECHA_VENCIMIENTO` date NULL DEFAULT NULL, `TOTAL_PAGADO` decimal(14, 2) NOT NULL DEFAULT 0.00, `PENDNC` tinyint(1) NOT NULL DEFAULT 0, `MONTO_NC_PENDIENTE` decimal(14, 2) NOT NULL DEFAULT 0.00, `MOTIVO_NC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `ESTADO_NC` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `MONTO_NC_RECIBIDO` decimal(14, 2) NOT NULL DEFAULT 0.00, `ANULADO` tinyint(1) NOT NULL DEFAULT 0, `OBSERVACION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `USUARIO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `UPDATED_AT` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_fcom2gastos_codunico`(`CODUNICO`) USING BTREE, UNIQUE INDEX `uk_fcom2gastos_documento`(`TIPODOC`, `FOLIO`, `RUT_PROVEEDOR`, `LOCAL`) USING BTREE, INDEX `idx_fcom2gastos_fecha_local`(`FECHA`, `LOCAL`) USING BTREE, INDEX `idx_fcom2gastos_proveedor`(`RUT_PROVEEDOR`) USING BTREE, INDEX `idx_fcom2gastos_nc`(`PENDNC`, `ESTADO_NC`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for fcomdob -- ---------------------------- DROP TABLE IF EXISTS `fcomdob`; CREATE TABLE `fcomdob` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `CANCELADO` bit(1) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `FOLIOFAC` int(10) NULL DEFAULT NULL, `TIPODOC` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR1` int(10) NULL DEFAULT NULL, `VAR2` int(10) NULL DEFAULT NULL, `VAR3` int(10) NULL DEFAULT NULL, `VAR4` int(10) NULL DEFAULT NULL, `VAR5` int(10) NULL DEFAULT NULL, `MESCONTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IVACOMUN` int(15) NULL DEFAULT NULL, `IVARETENID` int(15) NULL DEFAULT NULL, `IVANORECUP` int(15) NULL DEFAULT NULL, `IMPIVARET` float(13, 3) NULL DEFAULT NULL, `NUMIVACOM` int(10) NULL DEFAULT NULL, `NUMRET` int(10) NULL DEFAULT NULL, `NUMIVANORE` int(10) NULL DEFAULT NULL, `TOTIVARET` int(15) NULL DEFAULT NULL, `TOTAL2` int(15) NULL DEFAULT NULL, `OBS` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, INDEX `idx_b52_compras_periodo_proveedor`(`FECHA`, `CANCELADO`, `RUT`, `TIPODOC`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for firmacaf -- ---------------------------- DROP TABLE IF EXISTS `firmacaf`; CREATE TABLE `firmacaf` ( `cafmemo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `timbre` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `firmatim` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprima` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmemonot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmemoguia` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmemoexen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprimano` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprimagu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprimaex` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprimnd` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmemond` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmfe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmne` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmnd` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmge` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmfex` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `nuevocpo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `caf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `folionotaini` decimal(14, 0) NULL DEFAULT NULL, `folionotafin` decimal(14, 0) NULL DEFAULT NULL, `foliofacini` decimal(14, 0) NULL DEFAULT NULL, `foliofacfin` decimal(14, 0) NULL DEFAULT NULL, `foliondini` decimal(14, 0) NULL DEFAULT NULL, `foliondfin` decimal(14, 0) NULL DEFAULT NULL, `foliofacexini` decimal(14, 0) NULL DEFAULT NULL, `foliofacexfin` decimal(14, 0) NULL DEFAULT NULL, `folioguiaini` decimal(14, 0) NULL DEFAULT NULL, `folioguiafin` decimal(14, 0) NULL DEFAULT NULL, `cafmemoliq` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claprimliq` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprimliq` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `cafmliq` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `folioliqini` decimal(12, 0) NULL DEFAULT NULL, `folioliqfin` decimal(12, 0) NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, UNIQUE INDEX `uq_firmacaf_local`(`local`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for firmacafbol -- ---------------------------- DROP TABLE IF EXISTS `firmacafbol`; CREATE TABLE `firmacafbol` ( `cafmemo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `timbre` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `firmatim` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `claveprima` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `bolini` decimal(14, 0) NULL DEFAULT NULL, `bolfin` decimal(14, 0) NULL DEFAULT NULL, `cafmbo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `local` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, UNIQUE INDEX `uq_firmacafbol_local`(`local`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for folios -- ---------------------------- DROP TABLE IF EXISTS `folios`; CREATE TABLE `folios` ( `tipodte` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `caf` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `idcaf` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', `actcaf` decimal(1, 0) UNSIGNED ZEROFILL NULL DEFAULT NULL, `fecact` date NULL DEFAULT NULL, `local` decimal(2, 0) NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for foliosact -- ---------------------------- DROP TABLE IF EXISTS `foliosact`; CREATE TABLE `foliosact` ( `folioactfac` decimal(14, 0) NULL DEFAULT NULL, `folioactnota` decimal(14, 0) NULL DEFAULT NULL, `folioactguia` decimal(14, 0) NULL DEFAULT NULL, `folioactnd` decimal(14, 0) NULL DEFAULT NULL, `folioactface` decimal(14, 0) NULL DEFAULT NULL, `folioactbol` decimal(14, 0) NULL DEFAULT NULL, `folioactliq` decimal(12, 0) NULL DEFAULT NULL, `folioactfc` decimal(12, 0) NULL DEFAULT NULL, `folioactbole` decimal(12, 0) NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, UNIQUE INDEX `uq_foliosact_local`(`local`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for foliosbolsii -- ---------------------------- DROP TABLE IF EXISTS `foliosbolsii`; CREATE TABLE `foliosbolsii` ( `id` int(11) NOT NULL AUTO_INCREMENT, `codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `caf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `clapri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `bolini` decimal(12, 0) NULL DEFAULT NULL, `bolfin` decimal(12, 0) NULL DEFAULT NULL, `codint` datetime NULL DEFAULT NULL, `actual` decimal(1, 0) NULL DEFAULT NULL, `folio` decimal(12, 0) NULL DEFAULT NULL, `bien` tinyint(1) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for foliossii -- ---------------------------- DROP TABLE IF EXISTS `foliossii`; CREATE TABLE `foliossii` ( `id` int(11) NOT NULL AUTO_INCREMENT, `CODIGO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODSUCSII` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FOLIOFACIN` int(14) NULL DEFAULT NULL, `FOLIOFACFI` int(14) NULL DEFAULT NULL, `FOLIONOTAI` int(14) NULL DEFAULT NULL, `FOLIONOTAF` int(14) NULL DEFAULT NULL, `FOLIOFACEX` int(14) NULL DEFAULT NULL, `FOLIOFACE2` int(14) NULL DEFAULT NULL, `FOLIOGUIAI` int(14) NULL DEFAULT NULL, `FOLIOGUIAF` int(14) NULL DEFAULT NULL, `FOLIONDINI` int(14) NULL DEFAULT NULL, `FOLIONDFIN` int(14) NULL DEFAULT NULL, `FOLIOACTFA` int(14) NULL DEFAULT NULL, `FOLIOACTF2` int(14) NULL DEFAULT NULL, `FOLIOACTGU` int(14) NULL DEFAULT NULL, `FOLIOACTNO` int(14) NULL DEFAULT NULL, `FOLIOACTND` int(14) NULL DEFAULT NULL, `CODINT` datetime NULL DEFAULT NULL, `FOLIOBOLIN` int(14) NULL DEFAULT NULL, `FOLIOBOLFI` int(14) NULL DEFAULT NULL, `ACTUAL33` int(4) NULL DEFAULT NULL, `CAF33` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CAF61` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CAF56` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CAF52` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CAF34` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `ACTUAL61` int(1) NULL DEFAULT NULL, `ACTUAL56` int(1) NULL DEFAULT NULL, `ACTUAL52` int(1) NULL DEFAULT NULL, `ACTUAL34` int(1) NULL DEFAULT NULL, `BIEN33` bit(1) NULL DEFAULT NULL, `BIEN61` bit(1) NULL DEFAULT NULL, `BIEN56` bit(1) NULL DEFAULT NULL, `BIEN52` bit(1) NULL DEFAULT NULL, `BIEN34` bit(1) NULL DEFAULT NULL, `CLAPRI33` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CLAPRI61` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CLAPRI56` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CLAPRI52` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CLAPRI34` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `FOLIOLFINI` int(12) NULL DEFAULT NULL, `FOLIOLFFIN` int(12) NULL DEFAULT NULL, `CAF43` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `CLAPRI43` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `ACTUAL43` int(1) NULL DEFAULT NULL, `FOLIOLIQFI` int(12) NULL DEFAULT NULL, `FOLIOLIQIN` int(12) NULL DEFAULT NULL, `FOLIOACTLI` int(12) NULL DEFAULT NULL, `BIEN43` bit(1) NULL DEFAULT NULL, `CLAPRIMLIQ` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codfolios` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for foliostmpbol -- ---------------------------- DROP TABLE IF EXISTS `foliostmpbol`; CREATE TABLE `foliostmpbol` ( `codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `caf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `clapri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `bolini` decimal(12, 0) NULL DEFAULT NULL, `bolfin` decimal(12, 0) NULL DEFAULT NULL, `codint` datetime NULL DEFAULT NULL, `actual` decimal(1, 0) NULL DEFAULT NULL, `folio` decimal(12, 0) NULL DEFAULT NULL, `bien` tinyint(1) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for foxuser -- ---------------------------- DROP TABLE IF EXISTS `foxuser`; CREATE TABLE `foxuser` ( `TYPE` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ID` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NAME` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `READONLY` bit(1) NULL DEFAULT NULL, `CKVAL` int(6) NULL DEFAULT NULL, `DATA` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `UPDATED` date NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for fpagos -- ---------------------------- DROP TABLE IF EXISTS `fpagos`; CREATE TABLE `fpagos` ( `codigo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `formapago` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for fpagos_cfg -- ---------------------------- DROP TABLE IF EXISTS `fpagos_cfg`; CREATE TABLE `fpagos_cfg` ( `codigo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `exige_ref` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for grupos -- ---------------------------- DROP TABLE IF EXISTS `grupos`; CREATE TABLE `grupos` ( `codigo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id` int(3) NULL DEFAULT NULL, `cantprod` int(10) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for guia_traslado_det -- ---------------------------- DROP TABLE IF EXISTS `guia_traslado_det`; CREATE TABLE `guia_traslado_det` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `guia_id` bigint(20) UNSIGNED NOT NULL, `linea` int(11) NOT NULL DEFAULT 0, `codigo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `descripcion` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `codbar` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dun14` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `unidad` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cantidad` decimal(14, 3) NOT NULL DEFAULT 0.000, `cantidad_movimiento` decimal(14, 3) NOT NULL DEFAULT 0.000, `costo_referencia` decimal(14, 2) NOT NULL DEFAULT 0.00, `total_referencia` decimal(14, 2) NOT NULL DEFAULT 0.00, `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_guia_det_guia`(`guia_id`) USING BTREE, INDEX `idx_guia_det_codigo`(`codigo`) USING BTREE, INDEX `idx_guia_det_codbar`(`codbar`) USING BTREE, INDEX `idx_guia_det_dun14`(`dun14`) USING BTREE, CONSTRAINT `fk_guia_det_head` FOREIGN KEY (`guia_id`) REFERENCES `guia_traslado_head` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for guia_traslado_head -- ---------------------------- DROP TABLE IF EXISTS `guia_traslado_head`; CREATE TABLE `guia_traslado_head` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `folio` bigint(20) UNSIGNED NULL DEFAULT NULL, `fecha` date NOT NULL, `hora` time NOT NULL, `local` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `usuario_login` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario_nombre` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `concepto` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `responsable` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'AJUSTE GUIA DESPACHO', `observacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `estado` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'EMITIDA', `total_items` int(11) NOT NULL DEFAULT 0, `total_unidades` decimal(14, 3) NOT NULL DEFAULT 0.000, `tabla_movimiento` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `numero_movimiento` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `referencia_movimiento` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `impresa` tinyint(1) NOT NULL DEFAULT 0, `fecha_impresion` datetime NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_guia_traslado_folio`(`folio`) USING BTREE, INDEX `idx_guia_fecha`(`fecha`) USING BTREE, INDEX `idx_guia_local_fecha`(`local`, `fecha`) USING BTREE, INDEX `idx_guia_estado`(`estado`) USING BTREE, INDEX `idx_guia_movimiento`(`numero_movimiento`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for guia_traslado_log -- ---------------------------- DROP TABLE IF EXISTS `guia_traslado_log`; CREATE TABLE `guia_traslado_log` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `guia_id` bigint(20) UNSIGNED NOT NULL, `accion` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `usuario_login` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `detalle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_guia_log_guia`(`guia_id`) USING BTREE, INDEX `idx_guia_log_accion`(`accion`) USING BTREE, INDEX `idx_guia_log_fecha`(`created_at`) USING BTREE, CONSTRAINT `fk_guia_log_head` FOREIGN KEY (`guia_id`) REFERENCES `guia_traslado_head` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for guiapdf -- ---------------------------- DROP TABLE IF EXISTS `guiapdf`; CREATE TABLE `guiapdf` ( `dtes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codigo` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha` date NULL DEFAULT NULL, `pdf` blob NULL, `codunico` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipodoc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_abonos -- ---------------------------- DROP TABLE IF EXISTS `hc_abonos`; CREATE TABLE `hc_abonos` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cuadratura_id` int(10) UNSIGNED NOT NULL, `carga_id` int(10) UNSIGNED NOT NULL, `docu` decimal(10, 0) NOT NULL, `tipomov` decimal(10, 0) NOT NULL, `fecha_doc` date NOT NULL, `monto` decimal(12, 0) NOT NULL, `forma_pago` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `referencia` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_abono_doc`(`docu`, `tipomov`, `fecha_doc`) USING BTREE, INDEX `idx_abono_carga`(`carga_id`) USING BTREE, INDEX `fk_abono_cuad`(`cuadratura_id`) USING BTREE, CONSTRAINT `fk_abono_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT `fk_abono_cuad` FOREIGN KEY (`cuadratura_id`) REFERENCES `hc_cuadraturas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_carga_control -- ---------------------------- DROP TABLE IF EXISTS `hc_carga_control`; CREATE TABLE `hc_carga_control` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `estado_logistico` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ABIERTO', `fecha_preparado` datetime NULL DEFAULT NULL, `fecha_salida` datetime NULL DEFAULT NULL, `fecha_regreso` datetime NULL DEFAULT NULL, `fecha_cuadrado` datetime NULL DEFAULT NULL, `km_salida` decimal(12, 1) NULL DEFAULT NULL, `km_regreso` decimal(12, 1) NULL DEFAULT NULL, `numero_sello` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario_prepara` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario_autoriza_salida` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario_recibe_regreso` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion_salida` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion_regreso` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `actualizado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_hc_control_carga`(`carga_id`) USING BTREE, INDEX `idx_hc_control_estado`(`estado_logistico`) USING BTREE, CONSTRAINT `fk_hc_control_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for hc_carga_docs -- ---------------------------- DROP TABLE IF EXISTS `hc_carga_docs`; CREATE TABLE `hc_carga_docs` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `docu` decimal(10, 0) NOT NULL, `tipomov` decimal(10, 0) NOT NULL, `fecha_doc` date NOT NULL, `rut` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cliente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `comuna` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ciudad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `total_bruto` decimal(12, 0) NULL DEFAULT NULL, `total_neto` decimal(12, 0) NULL DEFAULT NULL, `total` decimal(12, 0) NULL DEFAULT NULL, `formapago_codigo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `formapago_nombre` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cond_pago` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `orden_entrega` int(11) NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `dest_direc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dest_comuna` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dest_ciudad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_hc_doc`(`carga_id`, `docu`, `tipomov`, `fecha_doc`) USING BTREE, INDEX `idx_hc_carga`(`carga_id`) USING BTREE, INDEX `idx_hc_fecha_doc`(`fecha_doc`) USING BTREE, CONSTRAINT `fk_hc_docs_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_carga_items -- ---------------------------- DROP TABLE IF EXISTS `hc_carga_items`; CREATE TABLE `hc_carga_items` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `carga_doc_id` int(10) UNSIGNED NOT NULL, `linea` int(10) UNSIGNED NOT NULL DEFAULT 1, `docu` decimal(12, 0) NOT NULL, `tipomov` int(11) NOT NULL, `fecha_doc` date NOT NULL, `codigo` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `descripcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `cantidad` decimal(15, 4) NOT NULL DEFAULT 0.0000, `precio_unitario` decimal(15, 4) NOT NULL DEFAULT 0.0000, `subtotal` decimal(15, 0) NOT NULL DEFAULT 0, `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_hc_item_linea`(`carga_doc_id`, `linea`) USING BTREE, INDEX `idx_hc_items_carga`(`carga_id`) USING BTREE, INDEX `idx_hc_items_doc`(`docu`, `tipomov`, `fecha_doc`) USING BTREE, CONSTRAINT `fk_hc_items_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `fk_hc_items_doc` FOREIGN KEY (`carga_doc_id`) REFERENCES `hc_carga_docs` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for hc_carga_movimientos -- ---------------------------- DROP TABLE IF EXISTS `hc_carga_movimientos`; CREATE TABLE `hc_carga_movimientos` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `tipo_evento` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `estado_anterior` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `estado_nuevo` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `detalle` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `creado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_hc_mov_carga_fecha`(`carga_id`, `creado_en`) USING BTREE, CONSTRAINT `fk_hc_mov_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for hc_cargas -- ---------------------------- DROP TABLE IF EXISTS `hc_cargas`; CREATE TABLE `hc_cargas` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `fecha_crea` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `estado` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ABIERTO', `origen_direccion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `camion_codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `camion_descrip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `camion_patente` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `chofer_codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `chofer_nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta1_codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta1_nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta2_codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta2_nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta3_codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `pioneta3_nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `obs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `local_codigo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `local_descrip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `origen_direc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `origen_ciudad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `origen_comuna` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_hc_estado`(`estado`) USING BTREE, INDEX `idx_hc_fecha`(`fecha_crea`) USING BTREE, INDEX `idx_hc_camion`(`camion_codigo`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_cuadratura_docs -- ---------------------------- DROP TABLE IF EXISTS `hc_cuadratura_docs`; CREATE TABLE `hc_cuadratura_docs` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cuadratura_id` int(10) UNSIGNED NOT NULL, `docu` decimal(10, 0) NOT NULL, `tipomov` decimal(10, 0) NOT NULL, `fecha_doc` date NOT NULL, `estado_entrega` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `cancelado_credito_simple` tinyint(1) NOT NULL DEFAULT 0, `monto_total_doc` decimal(12, 0) NULL DEFAULT NULL, `total_abonado` decimal(12, 0) NOT NULL DEFAULT 0, `saldo` decimal(12, 0) NOT NULL DEFAULT 0, `forma_pago_final` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `nc_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab6_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab6_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab6_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab6_fecha` date NULL DEFAULT NULL, `nc_docu` decimal(10, 0) NULL DEFAULT NULL, `nc_fecha` date NULL DEFAULT NULL, `nc_tipomov` decimal(10, 0) NOT NULL DEFAULT 20, `ab1_fecha` date NULL DEFAULT NULL, `ab1_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab1_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab1_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab2_fecha` date NULL DEFAULT NULL, `ab2_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab2_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab2_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab3_fecha` date NULL DEFAULT NULL, `ab3_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab3_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab3_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab4_fecha` date NULL DEFAULT NULL, `ab4_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab4_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab4_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab5_fecha` date NULL DEFAULT NULL, `ab5_monto` decimal(12, 0) NOT NULL DEFAULT 0, `ab5_fp` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ab5_ref` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_cuad_doc`(`cuadratura_id`, `docu`, `tipomov`, `fecha_doc`) USING BTREE, INDEX `idx_cuad_docu`(`docu`) USING BTREE, CONSTRAINT `fk_cuad_doc_cuad` FOREIGN KEY (`cuadratura_id`) REFERENCES `hc_cuadraturas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_cuadraturas -- ---------------------------- DROP TABLE IF EXISTS `hc_cuadraturas`; CREATE TABLE `hc_cuadraturas` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `fecha_crea` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `estado` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ABIERTO', `obs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_cuad_carga`(`carga_id`) USING BTREE, INDEX `idx_cuad_estado`(`estado`) USING BTREE, CONSTRAINT `fk_cuad_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hc_entregas -- ---------------------------- DROP TABLE IF EXISTS `hc_entregas`; CREATE TABLE `hc_entregas` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `carga_id` int(10) UNSIGNED NOT NULL, `carga_doc_id` int(10) UNSIGNED NOT NULL, `estado_entrega` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `fecha_evento` datetime NULL DEFAULT NULL, `recibido_por` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rut_recibe` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `motivo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `observacion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usuario` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `actualizado_en` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_hc_entrega_doc`(`carga_doc_id`) USING BTREE, INDEX `idx_hc_entrega_carga_estado`(`carga_id`, `estado_entrega`) USING BTREE, INDEX `idx_hc_entrega_fecha`(`fecha_evento`) USING BTREE, CONSTRAINT `fk_hc_entrega_carga` FOREIGN KEY (`carga_id`) REFERENCES `hc_cargas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_hc_entrega_doc` FOREIGN KEY (`carga_doc_id`) REFERENCES `hc_carga_docs` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for hdprecios -- ---------------------------- DROP TABLE IF EXISTS `hdprecios`; CREATE TABLE `hdprecios` ( `codigo` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for headmov -- ---------------------------- DROP TABLE IF EXISTS `headmov`; CREATE TABLE `headmov` ( `DOCU` decimal(12, 0) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOTDOC` int(12) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `FORMPAGO` int(2) NULL DEFAULT NULL, `TIPODOC` int(8) NULL DEFAULT NULL, `DES1` float(5, 2) NULL DEFAULT NULL, `DES2` float(5, 2) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RECDETC` int(12) NULL DEFAULT NULL, `RECDETT` int(12) NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `LOCORI` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCFIN` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CRED` bit(1) NULL DEFAULT NULL, `RESUMEN` int(10) NULL DEFAULT NULL, `IVA` int(10) NULL DEFAULT NULL, `CUENTAS` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `ILA1` int(10) NULL DEFAULT NULL, `ILA2` int(10) NULL DEFAULT NULL, `ILA3` int(10) NULL DEFAULT NULL, `ILA4` int(10) NULL DEFAULT NULL, `ILA5` int(10) NULL DEFAULT NULL, `ILA6` int(10) NULL DEFAULT NULL, `FLETE` int(10) NULL DEFAULT NULL, `FOLIOFAC` int(10) NULL DEFAULT NULL, `TIPODOCU` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FACTURA` int(12) NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `responsable` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `imp` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for headped -- ---------------------------- DROP TABLE IF EXISTS `headped`; CREATE TABLE `headped` ( `DOCU` double(18, 0) NOT NULL, `FECHA` date NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOTDOC` int(11) NULL DEFAULT NULL, `ESTADO` tinyint(4) NULL DEFAULT NULL, `TIPOMOV` int(11) NULL DEFAULT NULL, `FORMPAGO` int(11) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TIPODOC` int(11) NULL DEFAULT NULL, `HORA` int(11) NULL DEFAULT NULL, `CAJA` int(11) NULL DEFAULT NULL, `LOCAL` int(11) NULL DEFAULT NULL, `FECHAVEN` date NULL DEFAULT NULL, `RECDETC` int(11) NULL DEFAULT NULL, `RECDETT` int(11) NULL DEFAULT NULL, `LOCORI` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCFIN` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CRED` tinyint(4) NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA` int(11) NULL DEFAULT NULL, `IA` int(11) NULL DEFAULT NULL, `IVA` int(11) NULL DEFAULT NULL, `UTILIDAD` int(11) NULL DEFAULT NULL, `DES1` double NULL DEFAULT NULL, `PREFACTU` int(11) NULL DEFAULT NULL, `ORIGEN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CHOFER` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RESUMEN` int(11) NULL DEFAULT NULL, `TURNO` int(11) NULL DEFAULT NULL, `HORAREAL` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` tinyint(4) NULL DEFAULT NULL, `TELEFONO` bigint(20) NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DONACION` int(11) NULL DEFAULT NULL, `PROPINA` int(11) NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `codunico` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `operador` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `estadoped` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `obserdes` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `usuario` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`DOCU`) USING BTREE, INDEX `idx_headped_fecha`(`FECHA`) USING BTREE, INDEX `idx_headped_codvend`(`CODVEND`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for headtrxs -- ---------------------------- DROP TABLE IF EXISTS `headtrxs`; CREATE TABLE `headtrxs` ( `DOCU` int(10) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOTDOC` int(9) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `FORMPAGO` int(1) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TIPODOC` int(8) NULL DEFAULT NULL, `HORA` int(2) NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `LOCAL` int(2) NULL DEFAULT NULL, `FECHAVEN` date NULL DEFAULT NULL, `RECDETC` int(8) NULL DEFAULT NULL, `RECDETT` int(8) NULL DEFAULT NULL, `LOCORI` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `LOCFIN` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CRED` bit(1) NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DES1` float(8, 2) NULL DEFAULT NULL, `ORIGEN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CHOFER` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RESUMEN` int(10) NULL DEFAULT NULL, `TURNO` int(2) NULL DEFAULT NULL, `HORAREAL` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `TELEFONO` int(12) NULL DEFAULT NULL, `OBSERDES` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RECEPCION` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CORRESUC` int(3) NULL DEFAULT NULL, `ENTIDAD` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `DESCUENTO` int(10) NULL DEFAULT NULL, `RAZONREF` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NUMNOTA` int(12) NULL DEFAULT NULL, `TIPONOTA` int(10) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `facturatexto` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CORPAGO` int(11) NULL DEFAULT 0, PRIMARY KEY (`CODUNICO`) USING BTREE, UNIQUE INDEX `ux_headtrxs_codunico`(`CODUNICO`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `idx_headtrxs_b8_docu`(`DOCU`) USING BTREE, INDEX `idx_headtrxs_b8_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_headtrxs_b9_docu`(`DOCU`) USING BTREE, INDEX `idx_headtrxs_b9_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_b52_creditos_cliente`(`RUT`, `FORMPAGO`, `ESTADO`, `TIPOMOV`, `FECHA`, `DOCU`) USING BTREE, INDEX `idx_b52_documentos_periodo`(`FECHA`, `TIPOMOV`, `ESTADO`, `LOCAL`, `RUT`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hoja_carga -- ---------------------------- DROP TABLE IF EXISTS `hoja_carga`; CREATE TABLE `hoja_carga` ( `id` int(11) NOT NULL AUTO_INCREMENT, `estado` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ABIERTA', `local_codigo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `camion_codigo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `chofer_codigo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta3` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `observacion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for hoja_carga_docs -- ---------------------------- DROP TABLE IF EXISTS `hoja_carga_docs`; CREATE TABLE `hoja_carga_docs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `hoja_id` int(11) NOT NULL, `tipomov` int(11) NOT NULL, `docu` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha_doc` date NOT NULL, `cliente_codigo` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cliente_nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `direccion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comuna` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudad` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `formpago_codigo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `formpago_nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `condpago` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `total_bruto` decimal(14, 2) NULL DEFAULT NULL, `total_neto` decimal(14, 2) NULL DEFAULT NULL, `total_doc` decimal(14, 2) NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_hoja_doc`(`hoja_id`, `tipomov`, `docu`, `fecha_doc`) USING BTREE, INDEX `idx_hoja`(`hoja_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for impuesto -- ---------------------------- DROP TABLE IF EXISTS `impuesto`; CREATE TABLE `impuesto` ( `codigo` decimal(2, 0) NULL DEFAULT NULL, `descrip` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `valor` decimal(4, 2) NULL DEFAULT NULL, `valpes` decimal(2, 2) NULL DEFAULT NULL, `sigla` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for leqsisweb -- ---------------------------- DROP TABLE IF EXISTS `leqsisweb`; CREATE TABLE `leqsisweb` ( `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `servidor` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `basedatos` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `clave` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `usuariobase` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `clavebase` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombrefan` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correlaped` decimal(12, 0) NULL DEFAULT NULL, `pagado` decimal(1, 0) NULL DEFAULT NULL, `tienesop` decimal(1, 0) NULL DEFAULT NULL, `fechacob` date NULL DEFAULT NULL, `puerto` decimal(5, 0) NULL DEFAULT NULL, `fonosoporte` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, INDEX `rut`(`rut`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for listaprecios -- ---------------------------- DROP TABLE IF EXISTS `listaprecios`; CREATE TABLE `listaprecios` ( `codigo` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `preemp1` double(12, 3) NULL DEFAULT NULL, `preemp2` double(12, 3) NULL DEFAULT NULL, `preemp3` double(12, 3) NULL DEFAULT NULL, `preemp4` double(12, 3) NULL DEFAULT NULL, `preemp5` double(12, 3) NULL DEFAULT NULL, `precan2` int(3) NULL DEFAULT NULL, `precan3` int(3) NULL DEFAULT NULL, `precan4` int(3) NULL DEFAULT NULL, `precan5` int(3) NULL DEFAULT NULL, `prembru` double(14, 3) NULL DEFAULT NULL, `codbar` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `lista` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fluctua` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fechaini` date NULL DEFAULT NULL, `fechafin` date NULL DEFAULT NULL, `enviado` bit(1) NULL DEFAULT NULL, `activa` bit(1) NULL DEFAULT NULL, `unidxcaja` int(6) NULL DEFAULT NULL, `nomlista` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `stock` decimal(15, 3) NULL DEFAULT NULL, `parabal` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipo` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `series` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `proveedor` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descort` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `premco1` decimal(13, 3) NULL DEFAULT NULL, PRIMARY KEY (`codunico`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for locales -- ---------------------------- DROP TABLE IF EXISTS `locales`; CREATE TABLE `locales` ( `CODIGO` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DIREC` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIUDAD` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FONO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAN01` float(12, 3) NULL DEFAULT NULL, `CAN02` float(12, 3) NULL DEFAULT NULL, `CAN03` float(12, 3) NULL DEFAULT NULL, `CAN04` float(12, 3) NULL DEFAULT NULL, `CAN05` float(12, 3) NULL DEFAULT NULL, `CAN06` float(12, 3) NULL DEFAULT NULL, `CAN07` float(12, 3) NULL DEFAULT NULL, `CAN08` float(12, 3) NULL DEFAULT NULL, `CAN09` float(12, 3) NULL DEFAULT NULL, `CAN10` float(12, 3) NULL DEFAULT NULL, `CAN11` float(12, 3) NULL DEFAULT NULL, `CAN12` float(12, 3) NULL DEFAULT NULL, `CAN13` float(12, 3) NULL DEFAULT NULL, `CAN14` float(12, 3) NULL DEFAULT NULL, `CAN15` float(12, 3) NULL DEFAULT NULL, `CAN16` float(12, 3) NULL DEFAULT NULL, `CAN17` float(12, 3) NULL DEFAULT NULL, `CAN18` float(12, 3) NULL DEFAULT NULL, `VEN01` int(8) NULL DEFAULT NULL, `VEN02` int(8) NULL DEFAULT NULL, `VEN03` int(8) NULL DEFAULT NULL, `VEN04` int(8) NULL DEFAULT NULL, `VEN05` int(8) UNSIGNED ZEROFILL NULL DEFAULT NULL, `VEN06` int(8) NULL DEFAULT NULL, `VEN07` int(8) NULL DEFAULT NULL, `VEN08` int(8) NULL DEFAULT NULL, `VEN09` int(8) NULL DEFAULT NULL, `VEN10` int(8) NULL DEFAULT NULL, `VEN11` int(8) NULL DEFAULT NULL, `VEN12` int(8) NULL DEFAULT NULL, `VEN13` int(8) NULL DEFAULT NULL, `VEN14` int(8) NULL DEFAULT NULL, `VEN15` int(8) NULL DEFAULT NULL, `VEN16` int(8) NULL DEFAULT NULL, `VEN17` int(8) NULL DEFAULT NULL, `VEN18` int(8) NULL DEFAULT NULL, `DIRECTORIO` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERVPRECIO` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERVMODEM` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERVCENTRA` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `USAMESA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPCOCINA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPBAR` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMPREPORTE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `SERVMESAS` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `ENC1` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENC2` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENC3` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENC4` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENC5` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `USAMER` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESCAJA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESBAR` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESCOCINA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESREPORTE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PUERTOBOL` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TIPFISCAL` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PIDEGAR` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESLAVAN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DIRIMAGE` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PUERTOVIS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COMUNA` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `USUARIO` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CLAVE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STOCK` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESCIER` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR4` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR3` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESPROP` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ESCAMBIO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IMAGEN` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for loginapp -- ---------------------------- DROP TABLE IF EXISTS `loginapp`; CREATE TABLE `loginapp` ( `usuario` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `clave` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `Nombre` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fono` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rutfactura` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `razon` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `direc` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `giro` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comuna` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudad` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `local` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `referencia` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `esfactura` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correla` decimal(12, 0) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for ncclient -- ---------------------------- DROP TABLE IF EXISTS `ncclient`; CREATE TABLE `ncclient` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `EXENTO` int(10) NULL DEFAULT NULL, `VAR2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipodocnota` int(3) NULL DEFAULT NULL, `ENVIADO` tinyint(1) NULL DEFAULT 0, `FECHAENV` date NULL DEFAULT NULL, `FACTURANOTA` int(11) NULL DEFAULT 0, PRIMARY KEY (`CODUNICO`) USING BTREE, UNIQUE INDEX `ux_ncclient_codunico`(`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for ncprovee -- ---------------------------- DROP TABLE IF EXISTS `ncprovee`; CREATE TABLE `ncprovee` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ILA1` int(8) NULL DEFAULT NULL, `IVA` int(8) NULL DEFAULT NULL, `ILA2` int(8) NULL DEFAULT NULL, `ILA3` int(8) NULL DEFAULT NULL, `ILA4` int(8) NULL DEFAULT NULL, `ILA5` int(8) NULL DEFAULT NULL, `ILA9` int(8) NULL DEFAULT NULL, `ILA0` int(8) NULL DEFAULT NULL, `FL` int(10) NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `FOLIOFAC` int(10) NULL DEFAULT NULL, `TIPODOC` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR1` int(10) NULL DEFAULT NULL, `VAR2` int(10) NULL DEFAULT NULL, `VAR3` int(10) NULL DEFAULT NULL, `VAR4` int(10) NULL DEFAULT NULL, `MESCONTA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCFACT` int(15) NULL DEFAULT NULL, `FACTDESC` int(15) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for ndclient -- ---------------------------- DROP TABLE IF EXISTS `ndclient`; CREATE TABLE `ndclient` ( `CODIGO` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `TOTAL` int(10) NULL DEFAULT NULL, `FL` int(10) NULL DEFAULT NULL, `LOCAL` int(3) NULL DEFAULT NULL, `CAJA` int(1) NULL DEFAULT NULL, `ILA0` int(10) NULL DEFAULT NULL, `ILA1` int(10) NULL DEFAULT NULL, `ILA2` int(10) NULL DEFAULT NULL, `ILA3` int(10) NULL DEFAULT NULL, `ILA4` int(10) NULL DEFAULT NULL, `ILA5` int(10) NULL DEFAULT NULL, `ILA9` int(10) NULL DEFAULT NULL, `IVA` int(10) NULL DEFAULT NULL, `NETO` int(10) NULL DEFAULT NULL, `VAR01` float(12, 3) NULL DEFAULT NULL, `VAR02` int(12) NULL DEFAULT NULL, `VAR03` int(12) NULL DEFAULT NULL, `VAR04` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR05` bit(1) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for notacpdf -- ---------------------------- DROP TABLE IF EXISTS `notacpdf`; CREATE TABLE `notacpdf` ( `dtes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codigo` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha` date NULL DEFAULT NULL, `pdf` blob NULL, `codunico` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipodoc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for notadpdf -- ---------------------------- DROP TABLE IF EXISTS `notadpdf`; CREATE TABLE `notadpdf` ( `dtes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `codigo` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fecha` date NULL DEFAULT NULL, `pdf` blob NULL, `codunico` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `empresa` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipodoc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for oc_factura_vinculo -- ---------------------------- DROP TABLE IF EXISTS `oc_factura_vinculo`; CREATE TABLE `oc_factura_vinculo` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `OC_ID` bigint(20) UNSIGNED NOT NULL, `ORIGEN` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `ORIGEN_KEY` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `DOCU` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `RUT` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `LOCAL` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `FECHA` date NULL DEFAULT NULL, `TOTAL` decimal(18, 2) NOT NULL DEFAULT 0.00, `ESTADO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDIENTE', `OBSERVACION` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_oc_factura`(`OC_ID`, `ORIGEN`, `ORIGEN_KEY`) USING BTREE, INDEX `idx_factura_vinculo_doc`(`DOCU`, `RUT`, `LOCAL`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for oc_proveedor -- ---------------------------- DROP TABLE IF EXISTS `oc_proveedor`; CREATE TABLE `oc_proveedor` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `FOLIO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `FECHA` date NOT NULL, `RUT_PROVEEDOR` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `PROVEEDOR` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `LOCAL` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `FECHA_ESPERADA` date NULL DEFAULT NULL, `CONDICION_PAGO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `AFECTO` tinyint(1) NOT NULL DEFAULT 1, `ESTADO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'BORRADOR', `NETO` decimal(18, 2) NOT NULL DEFAULT 0.00, `IVA` decimal(18, 2) NOT NULL DEFAULT 0.00, `TOTAL` decimal(18, 2) NOT NULL DEFAULT 0.00, `OBSERVACION` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `USUARIO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `UPDATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_oc_folio`(`FOLIO`) USING BTREE, INDEX `idx_oc_fecha`(`FECHA`) USING BTREE, INDEX `idx_oc_proveedor`(`RUT_PROVEEDOR`) USING BTREE, INDEX `idx_oc_local_estado`(`LOCAL`, `ESTADO`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for oc_proveedor_detalle -- ---------------------------- DROP TABLE IF EXISTS `oc_proveedor_detalle`; CREATE TABLE `oc_proveedor_detalle` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `OC_ID` bigint(20) UNSIGNED NOT NULL, `LINEA` int(10) UNSIGNED NOT NULL DEFAULT 1, `CODIGO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `DESCRIPCION` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CANTIDAD` decimal(18, 3) NOT NULL DEFAULT 0.000, `COSTO_UNITARIO` decimal(18, 3) NOT NULL DEFAULT 0.000, `DESCUENTO` decimal(8, 3) NOT NULL DEFAULT 0.000, `TOTAL_LINEA` decimal(18, 2) NOT NULL DEFAULT 0.00, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_oc_linea`(`OC_ID`, `LINEA`) USING BTREE, INDEX `idx_oc_det_codigo`(`CODIGO`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for oc_recepcion -- ---------------------------- DROP TABLE IF EXISTS `oc_recepcion`; CREATE TABLE `oc_recepcion` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `OC_ID` bigint(20) UNSIGNED NOT NULL, `FOLIO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `FECHA` date NOT NULL, `GUIA` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `ESTADO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'RECIBIDA', `OBSERVACION` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `USUARIO` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_recepcion_folio`(`FOLIO`) USING BTREE, INDEX `idx_recepcion_oc`(`OC_ID`) USING BTREE, INDEX `idx_recepcion_fecha`(`FECHA`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for oc_recepcion_detalle -- ---------------------------- DROP TABLE IF EXISTS `oc_recepcion_detalle`; CREATE TABLE `oc_recepcion_detalle` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `RECEPCION_ID` bigint(20) UNSIGNED NOT NULL, `OC_DETALLE_ID` bigint(20) UNSIGNED NOT NULL, `CANTIDAD_RECIBIDA` decimal(18, 3) NOT NULL DEFAULT 0.000, `CANTIDAD_RECHAZADA` decimal(18, 3) NOT NULL DEFAULT 0.000, `OBSERVACION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_recepcion_detalle`(`RECEPCION_ID`, `OC_DETALLE_ID`) USING BTREE, INDEX `idx_recepcion_det_oc`(`OC_DETALLE_ID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ofertas -- ---------------------------- DROP TABLE IF EXISTS `ofertas`; CREATE TABLE `ofertas` ( `id_producto` int(13) NULL DEFAULT NULL, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `img_producto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `precio` int(12) NULL DEFAULT NULL, `precioreal` int(12) NULL DEFAULT NULL, `id_categoria` int(12) NULL DEFAULT NULL, `stock` int(12) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for paginaweb -- ---------------------------- DROP TABLE IF EXISTS `paginaweb`; CREATE TABLE `paginaweb` ( `pagina` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for paramgen -- ---------------------------- DROP TABLE IF EXISTS `paramgen`; CREATE TABLE `paramgen` ( `rut` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `logoship` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `logoweb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codigo` int(12) NULL DEFAULT NULL, `mapa` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `nomweb` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `dirweb` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudadweb` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comunaweb` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fonoweb` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `celweb` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correoweb` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id` int(13) NULL DEFAULT NULL, `jsp1` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `jsp2` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `topjsp1` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `topjsp2` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `palaclave` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cuenta` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `rutt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `banco` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `anombre` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correot` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correlaid` int(15) NULL DEFAULT NULL, `tpslider` int(1) NULL DEFAULT NULL, `tpprod` int(1) NULL DEFAULT NULL, `aviso` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tpbanner` int(1) NULL DEFAULT NULL, `tpaviso` int(1) NULL DEFAULT NULL, `reembolso` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `terminos` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `politica` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `esweipay` int(1) NULL DEFAULT NULL, `tpizq` int(1) NULL DEFAULT NULL, `tpnroitem` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `linkwebp` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tipofor` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for paramsii -- ---------------------------- DROP TABLE IF EXISTS `paramsii`; CREATE TABLE `paramsii` ( `valoriva` decimal(8, 0) NULL DEFAULT NULL, `valorint` decimal(8, 0) NULL DEFAULT NULL, `valormar` decimal(5, 0) NULL DEFAULT NULL, `valcodbar` decimal(10, 0) NULL DEFAULT NULL, `valorfle` decimal(8, 0) NULL DEFAULT NULL, `valordol` decimal(10, 0) NULL DEFAULT NULL, `nombre` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rut` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giro` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `servima` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `servact` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `imainicio` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `imadentro` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `tipoimp` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `local` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `correpro` decimal(6, 0) NULL DEFAULT NULL, `maestroemp` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var3` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var4` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var5` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var6` decimal(1, 0) NULL DEFAULT NULL, `var7` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var8` decimal(1, 0) NULL DEFAULT NULL, `correorden` decimal(10, 0) NULL DEFAULT NULL, `var9` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var10` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var11` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var12` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var13` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var15` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var16` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var14` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var17` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var18` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var19` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var20` decimal(10, 0) NULL DEFAULT NULL, `var21` decimal(10, 0) NULL DEFAULT NULL, `var22` decimal(10, 0) NULL DEFAULT NULL, `var23` decimal(10, 0) NULL DEFAULT NULL, `var24` decimal(10, 0) NULL DEFAULT NULL, `var25` decimal(10, 0) NULL DEFAULT NULL, `var26` decimal(1, 0) NULL DEFAULT NULL, `var27` decimal(1, 0) NULL DEFAULT NULL, `var28` decimal(1, 0) NULL DEFAULT NULL, `var29` decimal(10, 0) NULL DEFAULT NULL, `var30` decimal(1, 0) NULL DEFAULT NULL, `logo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `var31` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var32` decimal(13, 0) NULL DEFAULT NULL, `var33` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var34` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var35` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var36` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var37` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var38` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var39` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var40` decimal(10, 0) NULL DEFAULT NULL, `var41` decimal(10, 0) NULL DEFAULT NULL, `var42` decimal(1, 0) NULL DEFAULT NULL, `var43` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var44` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var45` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var46` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `comunacas` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ciudadcas` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `hotcorreo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `usercorreoenvio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ClaveCorreoenvio` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var50` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `var51` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `correoenviodte` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fonoempresa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `correodte` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `basedatos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `bodegarecepcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `rutrecepcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `fechacert` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giroadic1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giroadic2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giroadic3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giroadic4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `giroadic5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for perfiles -- ---------------------------- DROP TABLE IF EXISTS `perfiles`; CREATE TABLE `perfiles` ( `codigo` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `descrip` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `domcaja` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for permisos -- ---------------------------- DROP TABLE IF EXISTS `permisos`; CREATE TABLE `permisos` ( `menu` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `modulos` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for permisos_perfil -- ---------------------------- DROP TABLE IF EXISTS `permisos_perfil`; CREATE TABLE `permisos_perfil` ( `id` int(11) NOT NULL AUTO_INCREMENT, `perfil` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `menu` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `modulos` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `unq_perfil_menu_mod`(`perfil`, `menu`, `modulos`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4213 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pionetas -- ---------------------------- DROP TABLE IF EXISTS `pionetas`; CREATE TABLE `pionetas` ( `codigo` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `descrip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `comision` decimal(7, 0) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pos_caja_mov -- ---------------------------- DROP TABLE IF EXISTS `pos_caja_mov`; CREATE TABLE `pos_caja_mov` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `turno_id` bigint(20) UNSIGNED NOT NULL, `tipo` enum('IN','OUT') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `monto` decimal(15, 0) NOT NULL, `motivo` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `usuario_codigo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_turno`(`turno_id`) USING BTREE, CONSTRAINT `fk_pos_caja_mov_turno` FOREIGN KEY (`turno_id`) REFERENCES `pos_turnos` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pos_dias -- ---------------------------- DROP TABLE IF EXISTS `pos_dias`; CREATE TABLE `pos_dias` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `business_date` date NOT NULL, `local_codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `estado` enum('OPEN','CLOSED') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'OPEN', `opened_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `opened_by` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `closed_at` datetime NULL DEFAULT NULL, `closed_by` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_day_local`(`business_date`, `local_codigo`) USING BTREE, INDEX `idx_local_estado`(`local_codigo`, `estado`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pos_pendientes -- ---------------------------- DROP TABLE IF EXISTS `pos_pendientes`; CREATE TABLE `pos_pendientes` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_updated_at`(`updated_at`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pos_terminales -- ---------------------------- DROP TABLE IF EXISTS `pos_terminales`; CREATE TABLE `pos_terminales` ( `terminal_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `alias` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `local_codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `caja_num` tinyint(3) UNSIGNED NOT NULL, `activo` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`terminal_uuid`) USING BTREE, INDEX `idx_local_caja`(`local_codigo`, `caja_num`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pos_turnos -- ---------------------------- DROP TABLE IF EXISTS `pos_turnos`; CREATE TABLE `pos_turnos` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `business_date` date NOT NULL, `local_codigo` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `caja_num` tinyint(3) UNSIGNED NOT NULL, `terminal_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `usuario_codigo` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `turno_num` tinyint(3) UNSIGNED NOT NULL, `estado` enum('OPEN','CLOSED','EXPIRED') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'OPEN', `opened_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `closed_at` datetime NULL DEFAULT NULL, `cash_opening` decimal(15, 0) NOT NULL DEFAULT 0, `cash_counted` decimal(15, 0) NULL DEFAULT NULL, `open_key` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_open_key`(`open_key`) USING BTREE, INDEX `idx_day_local_caja`(`business_date`, `local_codigo`, `caja_num`, `estado`) USING BTREE, INDEX `idx_terminal`(`terminal_uuid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for productos -- ---------------------------- DROP TABLE IF EXISTS `productos`; CREATE TABLE `productos` ( `id_producto` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `img_producto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `id_categoria` int(11) NOT NULL, `precio` int(11) NOT NULL, `stock` int(11) NOT NULL, `slider` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id_producto`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for promocion -- ---------------------------- DROP TABLE IF EXISTS `promocion`; CREATE TABLE `promocion` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODPROMO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CANTIDAD` decimal(13, 3) NULL DEFAULT NULL, `PRCOSTO` decimal(12, 3) NULL DEFAULT NULL, `SBTOTAL` decimal(13, 0) NULL DEFAULT NULL, `SIGLA` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NOMSIGLA` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRVENTA` decimal(12, 0) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for propiedades -- ---------------------------- DROP TABLE IF EXISTS `propiedades`; CREATE TABLE `propiedades` ( `CODIGO` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DIREC` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FONO` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `GIRO` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIUDAD` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `AUTORIZADO` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FONO2` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CREDITO` int(11) NULL DEFAULT NULL, `MAIL` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `OBSER` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COMUNASTR` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIUDADSTR` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `GIROSTR` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `GASTOCOMUN` bigint(20) NULL DEFAULT NULL, `CANONUF` double NULL DEFAULT NULL, `CANONPESOS` bigint(20) NULL DEFAULT NULL, `PROPIETARIO` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for prov_nc_prov -- ---------------------------- DROP TABLE IF EXISTS `prov_nc_prov`; CREATE TABLE `prov_nc_prov` ( `id` int(11) NOT NULL AUTO_INCREMENT, `codunico_fact` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `docu_fact` decimal(13, 0) NULL DEFAULT NULL, `rutprov` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `numeronc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `totalnc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `netonc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ivanc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `responsable` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_fact`(`codunico_fact`) USING BTREE, INDEX `idx_rut_fecha`(`rutprov`, `fecha`) USING BTREE, INDEX `idx_numeronc`(`numeronc`(40)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for proveedor -- ---------------------------- DROP TABLE IF EXISTS `proveedor`; CREATE TABLE `proveedor` ( `codigo` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `descrip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comuna` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudad` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `direc` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fono` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `mail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `maildte` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codint` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for resumen -- ---------------------------- DROP TABLE IF EXISTS `resumen`; CREATE TABLE `resumen` ( `codigo` decimal(15, 0) NULL DEFAULT NULL, `camion` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta1` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pioneta3` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fecha` date NULL DEFAULT NULL, `chofer` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `hora` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `carganeta` decimal(12, 0) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for series -- ---------------------------- DROP TABLE IF EXISTS `series`; CREATE TABLE `series` ( `codigo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cod_grupo` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id` int(3) NULL DEFAULT NULL, `id_grupo` int(3) NULL DEFAULT NULL, `cantprod` int(10) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for servicios_proveedor -- ---------------------------- DROP TABLE IF EXISTS `servicios_proveedor`; CREATE TABLE `servicios_proveedor` ( `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `CODIGO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `DESCRIPCION` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `PRECIO` decimal(18, 2) NOT NULL DEFAULT 0.00, `AFECTO` tinyint(1) NOT NULL DEFAULT 1, `PRECIO_EDITABLE` tinyint(1) NOT NULL DEFAULT 1, `ACTIVO` tinyint(1) NOT NULL DEFAULT 1, `OBSERVACION` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `CREATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `UPDATED_AT` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) USING BTREE, UNIQUE INDEX `uk_servicio_proveedor_codigo`(`CODIGO`) USING BTREE, INDEX `idx_servicio_proveedor_activo`(`ACTIVO`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for siglas -- ---------------------------- DROP TABLE IF EXISTS `siglas`; CREATE TABLE `siglas` ( `CODIGO` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sliderbanner -- ---------------------------- DROP TABLE IF EXISTS `sliderbanner`; CREATE TABLE `sliderbanner` ( `codigo` bigint(11) NULL DEFAULT NULL, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id_producto` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `img_producto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id_categoria` int(11) NULL DEFAULT NULL, `precio` int(15) NULL DEFAULT NULL, `stock` int(15) NULL DEFAULT NULL, `precio2` int(11) NULL DEFAULT NULL, `precio3` int(11) NULL DEFAULT NULL, `precio4` int(11) NULL DEFAULT NULL, `precio5` int(11) NULL DEFAULT NULL, `precan2` int(6) NULL DEFAULT NULL, `precan3` int(6) NULL DEFAULT NULL, `precan4` int(6) NULL DEFAULT NULL, `precioact` int(11) NULL DEFAULT NULL, `nombre_adic1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sigla` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sliderprod -- ---------------------------- DROP TABLE IF EXISTS `sliderprod`; CREATE TABLE `sliderprod` ( `codigo` bigint(11) NULL DEFAULT NULL, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id_producto` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `img_producto` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id_categoria` int(11) NULL DEFAULT NULL, `precio` int(15) NULL DEFAULT NULL, `stock` int(15) NULL DEFAULT NULL, `precio2` int(11) NULL DEFAULT NULL, `precio3` int(11) NULL DEFAULT NULL, `precio4` int(11) NULL DEFAULT NULL, `precio5` int(11) NULL DEFAULT NULL, `precan2` int(6) NULL DEFAULT NULL, `precan3` int(6) NULL DEFAULT NULL, `precan4` int(6) NULL DEFAULT NULL, `precioact` int(11) NULL DEFAULT NULL, `nombre_adic1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre_adic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sigla` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sqlite -- ---------------------------- DROP TABLE IF EXISTS `sqlite`; CREATE TABLE `sqlite` ( `tabla` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `campo` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for subclases -- ---------------------------- DROP TABLE IF EXISTS `subclases`; CREATE TABLE `subclases` ( `codigo` decimal(3, 0) NULL DEFAULT NULL, `descrip` char(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tabladb -- ---------------------------- DROP TABLE IF EXISTS `tabladb`; CREATE TABLE `tabladb` ( `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `servidor` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `puerto` decimal(5, 0) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tipodoc -- ---------------------------- DROP TABLE IF EXISTS `tipodoc`; CREATE TABLE `tipodoc` ( `codigo` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descrip` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tipomov -- ---------------------------- DROP TABLE IF EXISTS `tipomov`; CREATE TABLE `tipomov` ( `codigo` decimal(2, 0) NULL DEFAULT NULL, `descrip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp1` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp2` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp3` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp4` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp5` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp6` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp7` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp8` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp9` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp10` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp11` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `cp12` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tipos -- ---------------------------- DROP TABLE IF EXISTS `tipos`; CREATE TABLE `tipos` ( `codigo` decimal(1, 0) NULL DEFAULT NULL, `descrip` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `porcen` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tranped -- ---------------------------- DROP TABLE IF EXISTS `tranped`; CREATE TABLE `tranped` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRVENTA` double NULL DEFAULT NULL, `SBTOTAL` double NULL DEFAULT NULL, `CANTIDAD` double NULL DEFAULT NULL, `DOCU` double(18, 0) NULL DEFAULT NULL, `TIPOMOV` int(11) NULL DEFAULT NULL, `ESTADO` tinyint(4) NULL DEFAULT NULL, `TIPPRE` int(11) NULL DEFAULT NULL, `UTIPROD` int(11) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PCANT` int(11) NULL DEFAULT NULL, `DESC1` double NULL DEFAULT NULL, `SIGLA` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` double NULL DEFAULT NULL, `TP` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESC2` double NULL DEFAULT NULL, `DESC3` double NULL DEFAULT NULL, `PRAUX` int(11) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJA` int(11) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ORIGEN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` tinyint(4) NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TURNO` int(11) NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `ZETA` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ZETAIMP` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIF` double NULL DEFAULT NULL, `UNIMED` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UNID` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PARTIDA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ITEM` int(11) NULL DEFAULT NULL, `NAC` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COSTO` double NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CLIENTE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DOLAR` double NULL DEFAULT NULL, `IMPUESTO` int(11) NULL DEFAULT NULL, `CANENT` int(11) NULL DEFAULT NULL, `CIFTOT` double NULL DEFAULT NULL, `ALTO` double NULL DEFAULT NULL, `ANCHO` double NULL DEFAULT NULL, `CANTALAN` double NULL DEFAULT NULL, `PRECALAN` double NULL DEFAULT NULL, `CANTREAL` double NULL DEFAULT NULL, `DESCADI` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `coment` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `operador` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `estadoped` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codimp` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codunico`) USING BTREE, INDEX `idx_tranped_docu`(`DOCU`) USING BTREE, INDEX `idx_tranped_codunico`(`codunico`) USING BTREE, INDEX `idx_tranped_b8_docu`(`DOCU`) USING BTREE, INDEX `idx_tranped_b9_docu`(`DOCU`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for tranpedr -- ---------------------------- DROP TABLE IF EXISTS `tranpedr`; CREATE TABLE `tranpedr` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRVENTA` double NULL DEFAULT NULL, `SBTOTAL` double NULL DEFAULT NULL, `CANTIDAD` double NULL DEFAULT NULL, `DOCU` int(11) NULL DEFAULT NULL, `TIPOMOV` int(11) NULL DEFAULT NULL, `ESTADO` tinyint(4) NULL DEFAULT NULL, `TIPPRE` int(11) NULL DEFAULT NULL, `UTIPROD` int(11) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PCANT` int(11) NULL DEFAULT NULL, `DESC1` double NULL DEFAULT NULL, `SIGLA` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` double NULL DEFAULT NULL, `TP` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESC2` double NULL DEFAULT NULL, `DESC3` double NULL DEFAULT NULL, `PRAUX` int(11) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJA` int(11) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ORIGEN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` tinyint(4) NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TURNO` int(11) NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `ZETA` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ZETAIMP` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CIF` double NULL DEFAULT NULL, `UNIMED` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `UNID` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PARTIDA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ITEM` int(11) NULL DEFAULT NULL, `NAC` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `COSTO` double NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CLIENTE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DOLAR` double NULL DEFAULT NULL, `IMPUESTO` int(11) NULL DEFAULT NULL, `CANENT` int(11) NULL DEFAULT NULL, `CIFTOT` double NULL DEFAULT NULL, `ALTO` double NULL DEFAULT NULL, `ANCHO` double NULL DEFAULT NULL, `CANTALAN` double NULL DEFAULT NULL, `PRECALAN` double NULL DEFAULT NULL, `CANTREAL` double NULL DEFAULT NULL, `DESCADI` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codunico` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `coment` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `operador` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `estadoped` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for transatrxs -- ---------------------------- DROP TABLE IF EXISTS `transatrxs`; CREATE TABLE `transatrxs` ( `CODIGO` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRVENTA` float(13, 3) NULL DEFAULT NULL, `SBTOTAL` float(10, 2) NULL DEFAULT NULL, `CANTIDAD` float(10, 3) NULL DEFAULT NULL, `DOCU` int(10) NULL DEFAULT NULL, `TIPOMOV` int(2) NULL DEFAULT NULL, `ESTADO` bit(1) NULL DEFAULT NULL, `TIPPRE` int(1) NULL DEFAULT NULL, `UTIPROD` int(10) NULL DEFAULT NULL, `FECHA` date NULL DEFAULT NULL, `LOCAL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PCANT` int(11) NULL DEFAULT NULL, `DESC1` float(13, 2) NULL DEFAULT NULL, `SIGLA` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRCOSTO` float(10, 2) NULL DEFAULT NULL, `TP` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESC2` float(5, 2) NULL DEFAULT NULL, `DESC3` float(5, 2) NULL DEFAULT NULL, `PRAUX` int(10) NULL DEFAULT NULL, `RUT` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CAJA` int(2) NULL DEFAULT NULL, `CODVEND` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ORIGEN` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESPACHA` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `DESCRIP` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ENVIADO` bit(1) NULL DEFAULT NULL, `CAJERO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CODBAR` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TURNO` int(2) NULL DEFAULT NULL, `RECEPCION` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `RESUMEN` int(10) NULL DEFAULT NULL, `ENTIDAD` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PRBRUTO` int(10) NULL DEFAULT NULL, `PROVEEDOR` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STOCK` int(10) NULL DEFAULT NULL, `COMIPROD` float(10, 2) NULL DEFAULT NULL, `COMILIN` float(10, 2) NULL DEFAULT NULL, `PORCLINEA` float(6, 2) NULL DEFAULT NULL, `PORCPROD` float(6, 2) NULL DEFAULT NULL, `FECHAJOR` date NULL DEFAULT NULL, `VAR01` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `VAR02` float(13, 3) NULL DEFAULT NULL, `VAR03` int(10) NULL DEFAULT NULL, `VAR04` int(10) NULL DEFAULT NULL, `VAR05` int(10) NULL DEFAULT NULL, `NETOORI` float(13, 3) NULL DEFAULT NULL, `SUBTOTSII` int(13) NULL DEFAULT NULL, `CODUNICO` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `RUTEMPRESA` varchar(9) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODUNICO`) USING BTREE, UNIQUE INDEX `ux_transatrxs_codunico`(`CODUNICO`) USING BTREE, INDEX `fecha`(`FECHA`) USING BTREE, INDEX `codigo`(`CODIGO`) USING BTREE, INDEX `docu`(`DOCU`) USING BTREE, INDEX `idx_trans_b8_docu`(`DOCU`) USING BTREE, INDEX `idx_trans_b8_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_trans_b9_docu`(`DOCU`) USING BTREE, INDEX `idx_trans_b9_codunico`(`CODUNICO`) USING BTREE, INDEX `idx_b52_ventas_fecha_tipo_estado_local_rut_cod`(`FECHA`, `TIPOMOV`, `ESTADO`, `LOCAL`, `RUT`, `CODIGO`) USING BTREE, INDEX `idx_b52_ventas_producto_local_estado_fecha`(`CODIGO`, `LOCAL`, `ESTADO`, `TIPOMOV`, `FECHA`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for turno_reservas -- ---------------------------- DROP TABLE IF EXISTS `turno_reservas`; CREATE TABLE `turno_reservas` ( `numero` tinyint(3) UNSIGNED NOT NULL, `caja_nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `expires_at` datetime NOT NULL, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`numero`) USING BTREE, INDEX `idx_expires`(`expires_at`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for turnomatico -- ---------------------------- DROP TABLE IF EXISTS `turnomatico`; CREATE TABLE `turnomatico` ( `fecha` date NOT NULL, `tipo` enum('GLOBAL','CAJA','LAST') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `caja_nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `numero` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `intentos` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `expires_at` datetime NULL DEFAULT NULL, `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `last_caja` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`tipo`, `caja_nombre`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for usuarios -- ---------------------------- DROP TABLE IF EXISTS `usuarios`; CREATE TABLE `usuarios` ( `CODIGO` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIP` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `PERFIL` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CLAVE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`CODIGO`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for vendedor -- ---------------------------- DROP TABLE IF EXISTS `vendedor`; CREATE TABLE `vendedor` ( `codigo` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `descrip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `entidad` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `codapp` decimal(20, 0) NULL DEFAULT NULL, `fono` decimal(11, 0) NULL DEFAULT NULL, `clave` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comicion` decimal(3, 3) NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for wbbloq -- ---------------------------- DROP TABLE IF EXISTS `wbbloq`; CREATE TABLE `wbbloq` ( `codigo` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `descrip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`codigo`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for web_det -- ---------------------------- DROP TABLE IF EXISTS `web_det`; CREATE TABLE `web_det` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `web_head_id` bigint(20) UNSIGNED NOT NULL, `sku` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `nombre_snapshot` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `precio_unit` decimal(12, 2) NOT NULL, `qty` decimal(12, 2) NOT NULL, `subtotal_linea` decimal(12, 2) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `ix_web_det_head`(`web_head_id`) USING BTREE, INDEX `ix_web_det_sku`(`sku`) USING BTREE, CONSTRAINT `fk_web_det_head` FOREIGN KEY (`web_head_id`) REFERENCES `web_head` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for web_head -- ---------------------------- DROP TABLE IF EXISTS `web_head`; CREATE TABLE `web_head` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `order_code` char(21) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `created_at` datetime(6) NOT NULL, `status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `rut` bigint(20) UNSIGNED NOT NULL, `usuario` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fono` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `comuna` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ciudad` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `direccion` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nota` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `subtotal` decimal(12, 2) NOT NULL DEFAULT 0.00, `envio` decimal(12, 2) NOT NULL DEFAULT 0.00, `total` decimal(12, 2) NOT NULL DEFAULT 0.00, `webpay_buy_order` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `webpay_token` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `webpay_status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `webpay_auth_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `paid_at` datetime(6) NULL DEFAULT NULL, `mob_correlativo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `mob_estado` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `mob_error_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uq_web_head_order_code`(`order_code`) USING BTREE, UNIQUE INDEX `uq_web_head_buy_order`(`webpay_buy_order`) USING BTREE, UNIQUE INDEX `uq_web_head_token`(`webpay_token`) USING BTREE, INDEX `ix_web_head_rut`(`rut`) USING BTREE, INDEX `ix_web_head_created`(`created_at`) USING BTREE, INDEX `ix_web_head_status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Procedure structure for demo_add_column_b6 -- ---------------------------- DROP PROCEDURE IF EXISTS `demo_add_column_b6`; delimiter ;; CREATE PROCEDURE `demo_add_column_b6`(IN p_table VARCHAR(64), IN p_col VARCHAR(64), IN p_def TEXT) BEGIN IF NOT EXISTS ( SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = p_table AND COLUMN_NAME = p_col ) THEN SET @s = CONCAT('ALTER TABLE `', p_table, '` ADD COLUMN `', p_col, '` ', p_def); PREPARE stmt FROM @s; EXECUTE stmt; DEALLOCATE PREPARE stmt; END IF; END ;; delimiter ; -- ---------------------------- -- Procedure structure for demo_add_index_b6 -- ---------------------------- DROP PROCEDURE IF EXISTS `demo_add_index_b6`; delimiter ;; CREATE PROCEDURE `demo_add_index_b6`(IN p_table VARCHAR(64), IN p_index VARCHAR(64), IN p_cols TEXT) BEGIN IF NOT EXISTS ( SELECT 1 FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = p_table AND INDEX_NAME = p_index ) THEN SET @s = CONCAT('ALTER TABLE `', p_table, '` ADD INDEX `', p_index, '` (', p_cols, ')'); PREPARE stmt FROM @s; EXECUTE stmt; DEALLOCATE PREPARE stmt; END IF; END ;; delimiter ; -- ---------------------------- -- Procedure structure for selectProducto -- ---------------------------- DROP PROCEDURE IF EXISTS `selectProducto`; delimiter ;; CREATE PROCEDURE `selectProducto`(IN _id_producto int) BEGIN SELECT * FROM productos WHERE id_producto = _id_producto; END ;; delimiter ; -- ---------------------------- -- Procedure structure for selectProductos -- ---------------------------- DROP PROCEDURE IF EXISTS `selectProductos`; delimiter ;; CREATE PROCEDURE `selectProductos`() BEGIN SELECT * FROM productos; END ;; delimiter ; -- ---------------------------- -- Triggers structure for table arcmovi -- ---------------------------- DROP TRIGGER IF EXISTS `arcmovi_bi`; delimiter ;; CREATE TRIGGER `arcmovi_bi` BEFORE INSERT ON `arcmovi` FOR EACH ROW BEGIN -- Si no viene seteado, usa FECHA (de negocio) + hora actual IF NEW.created_at IS NULL THEN SET NEW.created_at = TIMESTAMP(COALESCE(NEW.FECHA, CURRENT_DATE()), CURRENT_TIME()); END IF; IF NEW.updated_at IS NULL THEN SET NEW.updated_at = TIMESTAMP(COALESCE(NEW.FECHA, CURRENT_DATE()), CURRENT_TIME()); END IF; END ;; delimiter ; -- ---------------------------- -- Triggers structure for table arcmovi -- ---------------------------- DROP TRIGGER IF EXISTS `arcmovi_bu`; delimiter ;; CREATE TRIGGER `arcmovi_bu` BEFORE UPDATE ON `arcmovi` FOR EACH ROW BEGIN -- updated_at siempre se refresca con la fecha de negocio y hora actual SET NEW.updated_at = TIMESTAMP(COALESCE(NEW.FECHA, OLD.FECHA, CURRENT_DATE()), CURRENT_TIME()); END ;; delimiter ; SET FOREIGN_KEY_CHECKS = 1;