fP5tVVws

1/*
2SQLyog Ultimate v12.09 (64 bit)
3MySQL - 10.1.19-MariaDB : Database - siap
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16CREATE DATABASE /*!32312 IF NOT EXISTS*/`siap` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci */;
17
18USE `siap`;
19
20/*Table structure for table `cat_cajeros` */
21
22DROP TABLE IF EXISTS `cat_cajeros`;
23
24CREATE TABLE `cat_cajeros` (
25  `id_cajero` smallint(4) NOT NULL AUTO_INCREMENT,
26  `num_serie` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
27  `numero` smallint(5) DEFAULT NULL,
28  `estado` varchar(35) COLLATE utf8_spanish_ci DEFAULT NULL,
29  `municipio` varchar(80) COLLATE utf8_spanish_ci DEFAULT NULL,
30  `ubicacion_fisica` tinytext COLLATE utf8_spanish_ci,
31  `calle` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
32  `num_ext` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
33  `num_int` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
34  `colonia` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
35  `cp` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
36  `referencia` tinytext COLLATE utf8_spanish_ci,
37  `acta_entrega` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
38  `fecha_alta` date DEFAULT NULL,
39  `folio_ini_control` int(11) DEFAULT NULL,
40  `folio_fin_control` int(11) DEFAULT NULL,
41  `folio_ini_recibo` int(11) DEFAULT NULL,
42  `folio_fin_recibo` int(11) DEFAULT NULL,
43  `id_proyecto` tinyint(2) DEFAULT NULL,
44  `mac_address` varchar(22) COLLATE utf8_spanish_ci DEFAULT NULL,
45  `id_teamviewer` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
46  `pw_teamviewer` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
47  `estatus` tinyint(1) DEFAULT NULL,
48  PRIMARY KEY (`id_cajero`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
50
51/*Data for the table `cat_cajeros` */
52
53/*Table structure for table `cat_estatuscajeros` */
54
55DROP TABLE IF EXISTS `cat_estatuscajeros`;
56
57CREATE TABLE `cat_estatuscajeros` (
58  `id_estatuscajero` int(6) NOT NULL AUTO_INCREMENT,
59  `desc_estatus` tinytext COLLATE utf8_spanish_ci,
60  `observaciones` tinytext COLLATE utf8_spanish_ci,
61  PRIMARY KEY (`id_estatuscajero`)
62) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
63
64/*Data for the table `cat_estatuscajeros` */
65
66/*Table structure for table `cat_personaloperacion` */
67
68DROP TABLE IF EXISTS `cat_personaloperacion`;
69
70CREATE TABLE `cat_personaloperacion` (
71  `id_personaloperacion` tinyint(3) NOT NULL AUTO_INCREMENT,
72  `nombres` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
73  `ap_paterno` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
74  `ap_materno` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
75  `celular1` varchar(16) COLLATE utf8_spanish_ci DEFAULT NULL,
76  `celular2` varchar(16) COLLATE utf8_spanish_ci DEFAULT NULL,
77  `estado` varchar(35) COLLATE utf8_spanish_ci DEFAULT NULL,
78  `municipio` varchar(80) COLLATE utf8_spanish_ci DEFAULT NULL,
79  `estatus` tinyint(1) DEFAULT NULL,
80  `email` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
81  `fecha_alta` date DEFAULT NULL,
82  `hora_alta` time DEFAULT NULL,
83  `usuario` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
84  `pwd` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
85  `calle_direccion` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
86  `num_ext_direccion` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
87  `num_int_direccion` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
88  `col_direccion` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
89  `localidad_direccion` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
90  `ciudad_direccion` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
91  `estado_direccion` varchar(35) COLLATE utf8_spanish_ci DEFAULT NULL,
92  `pais_direccion` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
93  `id_expediente` int(11) DEFAULT NULL,
94  `id_empleado_cifo` tinyint(3) DEFAULT NULL,
95  PRIMARY KEY (`id_personaloperacion`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
97
98/*Data for the table `cat_personaloperacion` */
99
100/*Table structure for table `cat_proyectos` */
101
102DROP TABLE IF EXISTS `cat_proyectos`;
103
104CREATE TABLE `cat_proyectos` (
105  `id_proyecto` tinyint(2) NOT NULL AUTO_INCREMENT,
106  `clave_proyecto` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
107  `descripcion` tinytext COLLATE utf8_spanish_ci,
108  `estatus` tinyint(1) DEFAULT NULL,
109  `fecha_alta` date DEFAULT NULL,
110  `observaciones` tinytext COLLATE utf8_spanish_ci,
111  `municipio` varchar(80) COLLATE utf8_spanish_ci DEFAULT NULL,
112  `estado` varchar(35) COLLATE utf8_spanish_ci DEFAULT NULL,
113  `id_tipoproyecto` tinyint(2) DEFAULT NULL,
114  `num_cajeros` smallint(4) DEFAULT NULL,
115  PRIMARY KEY (`id_proyecto`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
117
118/*Data for the table `cat_proyectos` */
119
120/*Table structure for table `cat_servicios` */
121
122DROP TABLE IF EXISTS `cat_servicios`;
123
124CREATE TABLE `cat_servicios` (
125  `id_servicios` tinyint(2) NOT NULL AUTO_INCREMENT,
126  `desc_servicios` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
127  `clave_cliente` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
128  `precio_servicio` double DEFAULT NULL,
129  `estatus` tinyint(1) DEFAULT NULL,
130  `vigencia_precio` date DEFAULT NULL,
131  `fecha_alta` date DEFAULT NULL,
132  PRIMARY KEY (`id_servicios`)
133) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
134
135/*Data for the table `cat_servicios` */
136
137/*Table structure for table `cat_tipoproyecto` */
138
139DROP TABLE IF EXISTS `cat_tipoproyecto`;
140
141CREATE TABLE `cat_tipoproyecto` (
142  `id_tipoproyecto` tinyint(2) NOT NULL AUTO_INCREMENT,
143  `tipo` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
144  `estatus` tinyint(1) DEFAULT NULL,
145  PRIMARY KEY (`id_tipoproyecto`)
146) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
147
148/*Data for the table `cat_tipoproyecto` */
149
150/*Table structure for table `cat_usuarios` */
151
152DROP TABLE IF EXISTS `cat_usuarios`;
153
154CREATE TABLE `cat_usuarios` (
155  `id_usuario` tinyint(3) NOT NULL AUTO_INCREMENT,
156  `usuario` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
157  `pwd` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
158  `estatus` tinyint(1) DEFAULT NULL,
159  `vigencia` date DEFAULT NULL,
160  `id_perfil` tinyint(2) DEFAULT NULL,
161  `fecha_alta` date DEFAULT NULL,
162  `hora_alta` time DEFAULT NULL,
163  `ap_paterno` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
164  `ap_materno` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
165  `nombres` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
166  `telefono` varchar(16) COLLATE utf8_spanish_ci DEFAULT NULL,
167  `celular` varchar(16) COLLATE utf8_spanish_ci DEFAULT NULL,
168  `email` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
169  `id_proyecto` tinyint(2) DEFAULT NULL,
170  PRIMARY KEY (`id_usuario`)
171) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
172
173/*Data for the table `cat_usuarios` */
174
175/*Table structure for table `det_cajerosservicios` */
176
177DROP TABLE IF EXISTS `det_cajerosservicios`;
178
179CREATE TABLE `det_cajerosservicios` (
180  `id_cajerosservicios` mediumint(6) NOT NULL AUTO_INCREMENT,
181  `id_servicios` tinyint(2) DEFAULT NULL,
182  `id_cajeros` smallint(4) DEFAULT NULL,
183  PRIMARY KEY (`id_cajerosservicios`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
185
186/*Data for the table `det_cajerosservicios` */
187
188/*Table structure for table `det_monitoreo` */
189
190DROP TABLE IF EXISTS `det_monitoreo`;
191
192CREATE TABLE `det_monitoreo` (
193  `id_monitoreo` int(6) DEFAULT NULL,
194  `num_cajero` smallint(5) DEFAULT NULL,
195  `fecha` date DEFAULT NULL,
196  `hora` time DEFAULT NULL,
197  `id_proyecto` tinyint(2) DEFAULT NULL,
198  `estatus_cajero` tinyint(1) DEFAULT NULL,
199  `disp_bill50` smallint(5) DEFAULT NULL,
200  `disp_mon1p` smallint(5) DEFAULT NULL,
201  `disp_mon5p` smallint(5) DEFAULT NULL,
202  `disp_mon10p` smallint(5) DEFAULT NULL,
203  `bandeja1` tinytext COLLATE utf8_spanish_ci,
204  `bandeja2` tinytext COLLATE utf8_spanish_ci
205) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
206
207/*Data for the table `det_monitoreo` */
208
209/*Table structure for table `det_operacioncajeros` */
210
211DROP TABLE IF EXISTS `det_operacioncajeros`;
212
213CREATE TABLE `det_operacioncajeros` (
214  `id_operacioncajero` int(11) NOT NULL AUTO_INCREMENT,
215  `num_cajero` smallint(5) DEFAULT NULL,
216  `folio_control` int(11) DEFAULT NULL,
217  `folio_recibo` int(11) DEFAULT NULL,
218  `identificador_cliente` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
219  `fecha` date DEFAULT NULL,
220  `hora` time DEFAULT NULL,
221  `estatus` tinyint(1) DEFAULT NULL,
222  `importe_total` double DEFAULT NULL,
223  `usuario_cancelo` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
224  `usuario_alta` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
225  `id_servicio` tinyint(2) DEFAULT NULL,
226  `desc_servicio` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
227  `contribuyente` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
228  `forma_valorada` int(11) DEFAULT NULL,
229  `id_proyecto` tinyint(2) DEFAULT NULL,
230  `observaciones` tinytext COLLATE utf8_spanish_ci,
231  PRIMARY KEY (`id_operacioncajero`)
232) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
233
234/*Data for the table `det_operacioncajeros` */
235
236/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
237/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
238/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
239/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;