· 6 years ago · Aug 30, 2019, 08:16 PM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Versión del servidor: 5.7.26-log - MySQL Community Server (GPL)
4-- SO del servidor: Win64
5-- HeidiSQL Versión: 10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Volcando estructura para tabla descargasat_local.cfdi
15CREATE TABLE IF NOT EXISTS `cfdi` (
16 `version` bigint(20) NOT NULL,
17 `id` bigint(20) NOT NULL,
18 `folio` varchar(36) COLLATE utf8_spanish_ci NOT NULL,
19 `rfcEmisor` varchar(13) COLLATE utf8_spanish_ci NOT NULL,
20 `razonSocialEmisor` text COLLATE utf8_spanish_ci,
21 `rfcReceptor` varchar(13) COLLATE utf8_spanish_ci NOT NULL,
22 `razonSocialReceptor` text COLLATE utf8_spanish_ci,
23 `rfcPACCertificador` varchar(13) COLLATE utf8_spanish_ci NOT NULL,
24 `razonSocialPACCertificador` text COLLATE utf8_spanish_ci,
25 `fechaEmision` datetime NOT NULL,
26 `fechaCertificacion` datetime NOT NULL,
27 `total` decimal(20,2) NOT NULL,
28 `tipo` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
29 `status` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
30 `url` text COLLATE utf8_spanish_ci,
31 `fechaCancelacion` datetime DEFAULT NULL,
32 PRIMARY KEY (`id`),
33 UNIQUE KEY `folio` (`folio`),
34 KEY `CFDI_fechaEmision` (`fechaEmision`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
36
37-- Volcando datos para la tabla descargasat_local.cfdi: ~0 rows (aproximadamente)
38/*!40000 ALTER TABLE `cfdi` DISABLE KEYS */;
39/*!40000 ALTER TABLE `cfdi` ENABLE KEYS */;
40
41-- Volcando estructura para tabla descargasat_local.cfdiquery
42CREATE TABLE IF NOT EXISTS `cfdiquery` (
43 `version` bigint(20) NOT NULL,
44 `id` bigint(20) NOT NULL,
45 `folio` varchar(36) COLLATE utf8_spanish_ci NOT NULL,
46 `usuario` varchar(13) COLLATE utf8_spanish_ci NOT NULL,
47 `password` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
48 `status` varchar(40) COLLATE utf8_spanish_ci NOT NULL,
49 `rfcEmisor` varchar(13) COLLATE utf8_spanish_ci DEFAULT NULL,
50 `razonSocialEmisor` text COLLATE utf8_spanish_ci,
51 `rfcReceptor` varchar(13) COLLATE utf8_spanish_ci DEFAULT NULL,
52 `razonSocialReceptor` text COLLATE utf8_spanish_ci,
53 `statusComprobante` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
54 `fechaInicio` datetime DEFAULT NULL,
55 `fechaFin` datetime DEFAULT NULL,
56 `fechaSolicitado` datetime NOT NULL,
57 `fechaCompletado` datetime DEFAULT NULL,
58 `tipo` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
59 `limite` int(11) NOT NULL DEFAULT '0',
60 `complementos` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
61 `tipoBusqueda` varchar(20) COLLATE utf8_spanish_ci NOT NULL DEFAULT 'NORMAL',
62 `metadatos` tinyint(1) NOT NULL DEFAULT '0',
63 `folios` text COLLATE utf8_spanish_ci,
64 PRIMARY KEY (`id`),
65 UNIQUE KEY `folio` (`folio`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
67
68-- Volcando datos para la tabla descargasat_local.cfdiquery: ~0 rows (aproximadamente)
69/*!40000 ALTER TABLE `cfdiquery` DISABLE KEYS */;
70/*!40000 ALTER TABLE `cfdiquery` ENABLE KEYS */;
71
72-- Volcando estructura para tabla descargasat_local.cfdiquerystat
73CREATE TABLE IF NOT EXISTS `cfdiquerystat` (
74 `version` bigint(20) NOT NULL,
75 `id` bigint(20) NOT NULL,
76 `cfdiQueryId` bigint(20) NOT NULL,
77 `fechaMismoHorario` datetime NOT NULL,
78 PRIMARY KEY (`id`),
79 KEY `fk_CFDIQueryStat_cfdiQueryId` (`cfdiQueryId`),
80 CONSTRAINT `fk_CFDIQueryStat_cfdiQueryId` FOREIGN KEY (`cfdiQueryId`) REFERENCES `cfdiquery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
81) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
82
83-- Volcando datos para la tabla descargasat_local.cfdiquerystat: ~0 rows (aproximadamente)
84/*!40000 ALTER TABLE `cfdiquerystat` DISABLE KEYS */;
85/*!40000 ALTER TABLE `cfdiquerystat` ENABLE KEYS */;
86
87-- Volcando estructura para tabla descargasat_local.cfdiresultado
88CREATE TABLE IF NOT EXISTS `cfdiresultado` (
89 `version` bigint(20) NOT NULL,
90 `id` bigint(20) NOT NULL,
91 `queryId` bigint(20) NOT NULL,
92 `cfdiId` bigint(20) NOT NULL,
93 `status` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
94 `descargado` tinyint(1) NOT NULL,
95 `fecha` datetime NOT NULL,
96 PRIMARY KEY (`id`),
97 UNIQUE KEY `u_CFDIResultado_cfdiId_queryId` (`queryId`,`cfdiId`),
98 KEY `fk_CFDIResultado_cfdiId` (`cfdiId`),
99 CONSTRAINT `fk_CFDIResultado_cfdiId` FOREIGN KEY (`cfdiId`) REFERENCES `cfdi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
100 CONSTRAINT `fk_CFDIResultado_queryId` FOREIGN KEY (`queryId`) REFERENCES `cfdiquery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
101) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
102
103-- Volcando datos para la tabla descargasat_local.cfdiresultado: ~0 rows (aproximadamente)
104/*!40000 ALTER TABLE `cfdiresultado` DISABLE KEYS */;
105/*!40000 ALTER TABLE `cfdiresultado` ENABLE KEYS */;
106
107-- Volcando estructura para tabla descargasat_local.complementocfdi
108CREATE TABLE IF NOT EXISTS `complementocfdi` (
109 `version` int(11) NOT NULL DEFAULT '1',
110 `id` bigint(20) NOT NULL,
111 `clave` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
112 `nombre` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
113 PRIMARY KEY (`id`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
115
116-- Volcando datos para la tabla descargasat_local.complementocfdi: ~31 rows (aproximadamente)
117/*!40000 ALTER TABLE `complementocfdi` DISABLE KEYS */;
118INSERT INTO `complementocfdi` (`version`, `id`, `clave`, `nombre`) VALUES
119 (1, 1, '8', 'Estándar'),
120 (1, 2, '4294967296', 'Acreditamiento de IEPS'),
121 (1, 3, '8388608', 'Aerolíneas'),
122 (1, 4, '1073741824', 'Certificado de Destrucción'),
123 (1, 5, '17179869184', 'Comercio Exterior'),
124 (1, 6, '4', 'Compra Venta de Divisas'),
125 (1, 7, '16777216', 'Consumo de Combustibles'),
126 (1, 8, '64', 'Donatarias'),
127 (1, 9, '256', 'Estado de Cuenta Bancario'),
128 (1, 10, '8589934592', 'Estado de cuenta de combustibles de monederos electrónicos'),
129 (1, 11, '68719476736', 'INE 1.1'),
130 (1, 12, '1024', 'Educativas Privadas (Pago de colegiatura)'),
131 (1, 13, '4096', 'Leyendas Fiscales'),
132 (1, 14, '524288', 'Mis Cuentas'),
133 (1, 15, '67108864', 'Notarios Públicos'),
134 (1, 16, '536870912', 'Obras de artes y agüedades'),
135 (1, 17, '2048', 'Otros Derechos e Impuestos'),
136 (1, 18, '4194304', 'Pago en Especie'),
137 (1, 19, '8192', 'Persona Física Integrante de Coordinado'),
138 (1, 20, '128', 'Recibo de donativo'),
139 (1, 21, '1048576', 'Recibo de Pago de Salarios'),
140 (1, 22, '32', 'Sector de Ventas al Detalle (Detallista)'),
141 (1, 23, '268435456', 'Servicios de construccón'),
142 (1, 24, '16384', 'SPEI de Tercero a Tercero'),
143 (1, 25, '2147483648', 'Sustitución y renovación vehicular'),
144 (1, 26, '32768', 'Terceros'),
145 (1, 27, '65536', 'Terceros'),
146 (1, 28, '16', 'Turista o Pasajero Extranjero'),
147 (1, 29, '33554432', 'Vales de Despensa'),
148 (1, 30, '134217728', 'Vehículo Usado'),
149 (1, 31, '2097152', 'Venta de Vehículos');
150/*!40000 ALTER TABLE `complementocfdi` ENABLE KEYS */;
151
152-- Volcando estructura para tabla descargasat_local.id_gen
153CREATE TABLE IF NOT EXISTS `id_gen` (
154 `ID_NAME` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
155 `ID_VAL` bigint(20) NOT NULL,
156 PRIMARY KEY (`ID_NAME`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
158
159-- Volcando datos para la tabla descargasat_local.id_gen: ~6 rows (aproximadamente)
160/*!40000 ALTER TABLE `id_gen` DISABLE KEYS */;
161INSERT INTO `id_gen` (`ID_NAME`, `ID_VAL`) VALUES
162 ('cfdiId', 0),
163 ('cfdiMetaId', 0),
164 ('cfdiQueryId', 0),
165 ('cfdiQueryStatId', 0),
166 ('cfdiResultadoId', 0),
167 ('complementoCFDIId', 31);
168/*!40000 ALTER TABLE `id_gen` ENABLE KEYS */;
169
170-- Volcando estructura para tabla descargasat_local.schema_version
171CREATE TABLE IF NOT EXISTS `schema_version` (
172 `version_rank` int(11) NOT NULL,
173 `installed_rank` int(11) NOT NULL,
174 `version` varchar(50) NOT NULL,
175 `description` varchar(200) NOT NULL,
176 `type` varchar(20) NOT NULL,
177 `script` varchar(1000) NOT NULL,
178 `checksum` int(11) DEFAULT NULL,
179 `installed_by` varchar(100) NOT NULL,
180 `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
181 `execution_time` int(11) NOT NULL,
182 `success` tinyint(1) NOT NULL,
183 PRIMARY KEY (`version`),
184 KEY `schema_version_vr_idx` (`version_rank`),
185 KEY `schema_version_ir_idx` (`installed_rank`),
186 KEY `schema_version_s_idx` (`success`)
187) ENGINE=InnoDB DEFAULT CHARSET=latin1;
188
189-- Volcando datos para la tabla descargasat_local.schema_version: ~13 rows (aproximadamente)
190/*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
191INSERT INTO `schema_version` (`version_rank`, `installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`, `installed_on`, `execution_time`, `success`) VALUES
192 (1, 1, '1', 'initial state', 'SQL', 'V1__initial_state.sql', -315288605, 'descargasat', '2019-08-30 13:57:20', 77, 1),
193 (2, 2, '1.1', 'primer update', 'SQL', 'V1.1__primer_update.sql', -1306901559, 'descargasat', '2019-08-30 13:57:20', 28, 1),
194 (3, 3, '1.2', 'alter status cfdiquery', 'SQL', 'V1.2__alter_status_cfdiquery.sql', -1300726059, 'descargasat', '2019-08-30 13:57:20', 11, 1),
195 (4, 4, '1.3', 'agregado cfdiquerystat', 'SQL', 'V1.3__agregado_cfdiquerystat.sql', -661746519, 'descargasat', '2019-08-30 13:57:20', 19, 1),
196 (5, 5, '1.4', 'cambio cfdiMeta flyway', 'SQL', 'V1.4__cambio_cfdiMeta_flyway.sql', -1823428023, 'descargasat', '2019-08-30 13:57:20', 5, 1),
197 (6, 6, '1.5', 'agregar complementos', 'SQL', 'V1.5__agregar_complementos.sql', -1379962202, 'descargasat', '2019-08-30 13:57:20', 75, 1),
198 (7, 7, '1.6', 'search params tipo busqueda', 'SQL', 'V1.6__search_params_tipo_busqueda.sql', -1205012369, 'descargasat', '2019-08-30 13:57:20', 29, 1),
199 (8, 8, '1.7', 'incrementar decimal total cfdi', 'SQL', 'V1.7__incrementar_decimal_total_cfdi.sql', -1327165646, 'descargasat', '2019-08-30 13:57:20', 33, 1),
200 (9, 9, '1.8', 'fecha cancelacion', 'SQL', 'V1.8__fecha_cancelacion.sql', -136529451, 'descargasat', '2019-08-30 13:57:20', 36, 1),
201 (10, 10, '1.9', 'fechaEmision index', 'SQL', 'V1.9__fechaEmision_index.sql', 361838783, 'descargasat', '2019-08-30 13:57:20', 12, 1),
202 (11, 11, '1538977034305', 'metadatos', 'SQL', 'V1538977034305__metadatos.sql', 2107514272, 'descargasat', '2019-08-30 13:57:20', 28, 1),
203 (12, 12, '1548121585827', 'search params folios', 'SQL', 'V1548121585827__search_params_folios.sql', 969046597, 'descargasat', '2019-08-30 13:57:20', 26, 1),
204 (13, 13, '1548126442496', 'search params fechas', 'SQL', 'V1548126442496__search_params_fechas.sql', -1435336034, 'descargasat', '2019-08-30 13:57:20', 53, 1);
205/*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
206
207/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
208/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
209/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;