· 10 years ago · Sep 13, 2016, 08:36 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema freejobs
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema freejobs
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `freejobs` DEFAULT CHARACTER SET utf8 ;
15USE `freejobs` ;
16
17-- -----------------------------------------------------
18-- Table `freejobs`.`usuario`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `freejobs`.`usuario` (
21 `idusuario` INT(11) NOT NULL AUTO_INCREMENT,
22 `estado` INT(11) NULL DEFAULT NULL,
23 `nombre` VARCHAR(200) NULL DEFAULT NULL,
24 `apellido` VARCHAR(200) NULL DEFAULT NULL,
25 `contrasena` VARCHAR(50) NULL DEFAULT NULL,
26 `fechadenacimiento` DATE NULL DEFAULT NULL,
27 `correo` VARCHAR(100) NULL DEFAULT NULL,
28 `telefonofijo` VARCHAR(45) NULL DEFAULT NULL,
29 `telefonocelular` VARCHAR(45) NULL DEFAULT NULL,
30 `ciudad` VARCHAR(50) NULL DEFAULT NULL,
31 `foto` VARCHAR(250) NULL DEFAULT NULL,
32 PRIMARY KEY (`idusuario`))
33ENGINE = InnoDB
34AUTO_INCREMENT = 6
35DEFAULT CHARACTER SET = utf8;
36
37
38-- -----------------------------------------------------
39-- Table `freejobs`.`contratista`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `freejobs`.`contratista` (
42 `idcontratista` INT(11) NOT NULL AUTO_INCREMENT,
43 `idusuario` INT(11) NOT NULL,
44 `documentoidentidad` VARCHAR(200) NULL DEFAULT NULL,
45 `tipodocumento` VARCHAR(50) NULL DEFAULT NULL,
46 `direccion` VARCHAR(100) NULL DEFAULT NULL,
47 `tarifaporhora` BIGINT(11) NULL DEFAULT NULL,
48 `foto` VARCHAR(250) NULL DEFAULT NULL,
49 `estadocivil` VARCHAR(100) NULL DEFAULT NULL,
50 PRIMARY KEY (`idcontratista`),
51 INDEX `fk_contratista_usuario1_idx` (`idusuario` ASC),
52 CONSTRAINT `fk_contratista_usuario1`
53 FOREIGN KEY (`idusuario`)
54 REFERENCES `freejobs`.`usuario` (`idusuario`)
55 ON DELETE NO ACTION
56 ON UPDATE NO ACTION)
57ENGINE = InnoDB
58AUTO_INCREMENT = 4
59DEFAULT CHARACTER SET = utf8;
60
61
62-- -----------------------------------------------------
63-- Table `freejobs`.`calificacion`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `freejobs`.`calificacion` (
66 `idcalificacion` INT(11) NOT NULL AUTO_INCREMENT,
67 `idusuario` INT(11) NOT NULL,
68 `calificacion` INT(11) NULL DEFAULT NULL,
69 `comentario` VARCHAR(250) NULL DEFAULT NULL,
70 `idcontratista` INT(11) NOT NULL,
71 PRIMARY KEY (`idcalificacion`),
72 INDEX `fk_calificacion_contratista1_idx` (`idcontratista` ASC),
73 INDEX `fk_calificacion_usuario1_idx` (`idusuario` ASC),
74 CONSTRAINT `fk_calificacion_contratista1`
75 FOREIGN KEY (`idcontratista`)
76 REFERENCES `freejobs`.`contratista` (`idcontratista`)
77 ON DELETE NO ACTION
78 ON UPDATE NO ACTION,
79 CONSTRAINT `fk_calificacion_usuario1`
80 FOREIGN KEY (`idusuario`)
81 REFERENCES `freejobs`.`usuario` (`idusuario`)
82 ON DELETE NO ACTION
83 ON UPDATE NO ACTION)
84ENGINE = InnoDB
85DEFAULT CHARACTER SET = utf8;
86
87
88-- -----------------------------------------------------
89-- Table `freejobs`.`chat`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `freejobs`.`chat` (
92 `idchat` INT(11) NOT NULL AUTO_INCREMENT,
93 `envia` INT(11) NULL DEFAULT NULL,
94 `recibe` INT(11) NULL DEFAULT NULL,
95 `visto` INT(11) NULL DEFAULT NULL,
96 `mensaje` VARCHAR(250) NULL DEFAULT NULL,
97 `fecha` DATE NULL DEFAULT NULL,
98 `hora` VARCHAR(50) NULL DEFAULT NULL,
99 PRIMARY KEY (`idchat`))
100ENGINE = InnoDB
101AUTO_INCREMENT = 3
102DEFAULT CHARACTER SET = utf8;
103
104
105-- -----------------------------------------------------
106-- Table `freejobs`.`chatauditoria`
107-- -----------------------------------------------------
108CREATE TABLE IF NOT EXISTS `freejobs`.`chatauditoria` (
109 `idchatauditoria` INT(11) NOT NULL AUTO_INCREMENT,
110 `envia` INT(11) NULL DEFAULT NULL,
111 `recibe` INT(11) NULL DEFAULT NULL,
112 `visto` INT(11) NULL DEFAULT NULL,
113 `mensaje` VARCHAR(250) NULL DEFAULT NULL,
114 `fecha` DATE NULL DEFAULT NULL,
115 `hora` VARCHAR(50) NULL DEFAULT NULL,
116 `estado` INT(11) NULL DEFAULT NULL COMMENT 'saber cuales están en funcionamiento',
117 PRIMARY KEY (`idchatauditoria`))
118ENGINE = InnoDB
119DEFAULT CHARACTER SET = utf8;
120
121
122-- -----------------------------------------------------
123-- Table `freejobs`.`tiposervicio`
124-- -----------------------------------------------------
125CREATE TABLE IF NOT EXISTS `freejobs`.`tiposervicio` (
126 `idtiposervicio` INT(11) NOT NULL AUTO_INCREMENT,
127 `estado` INT(11) NULL DEFAULT NULL,
128 `nombreservicio` VARCHAR(100) NULL DEFAULT NULL,
129 PRIMARY KEY (`idtiposervicio`))
130ENGINE = InnoDB
131AUTO_INCREMENT = 6
132DEFAULT CHARACTER SET = utf8
133COMMENT = 'Tabla admin';
134
135
136-- -----------------------------------------------------
137-- Table `freejobs`.`servicio`
138-- -----------------------------------------------------
139CREATE TABLE IF NOT EXISTS `freejobs`.`servicio` (
140 `idservicio` INT(11) NOT NULL AUTO_INCREMENT,
141 `idtiposervicio` INT(11) NOT NULL,
142 `nombreservicio` VARCHAR(45) NULL DEFAULT NULL,
143 `visitas` BIGINT(11) NULL,
144 PRIMARY KEY (`idservicio`),
145 INDEX `fk_servicio_tiposervicio1_idx` (`idtiposervicio` ASC),
146 CONSTRAINT `fk_servicio_tiposervicio1`
147 FOREIGN KEY (`idtiposervicio`)
148 REFERENCES `freejobs`.`tiposervicio` (`idtiposervicio`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB
152AUTO_INCREMENT = 4
153DEFAULT CHARACTER SET = utf8;
154
155
156-- -----------------------------------------------------
157-- Table `freejobs`.`especialidad`
158-- -----------------------------------------------------
159CREATE TABLE IF NOT EXISTS `freejobs`.`especialidad` (
160 `idespecialidad` INT(11) NOT NULL AUTO_INCREMENT,
161 `idservicio` INT(11) NOT NULL,
162 `estado` INT(11) NULL DEFAULT NULL,
163 `nombreespecialidad` VARCHAR(250) NULL DEFAULT NULL,
164 `descripcion` VARCHAR(250) NULL DEFAULT NULL,
165 `precio` BIGINT(11) NULL,
166 PRIMARY KEY (`idespecialidad`),
167 INDEX `fk_especialidad_servicio1_idx` (`idservicio` ASC),
168 CONSTRAINT `fk_especialidad_servicio1`
169 FOREIGN KEY (`idservicio`)
170 REFERENCES `freejobs`.`servicio` (`idservicio`)
171 ON DELETE NO ACTION
172 ON UPDATE NO ACTION)
173ENGINE = InnoDB
174DEFAULT CHARACTER SET = utf8;
175
176
177-- -----------------------------------------------------
178-- Table `freejobs`.`publicacion`
179-- -----------------------------------------------------
180CREATE TABLE IF NOT EXISTS `freejobs`.`publicacion` (
181 `idpublicacion` INT(11) NOT NULL AUTO_INCREMENT,
182 `titulo` VARCHAR(250) NULL DEFAULT NULL,
183 `imagen` VARCHAR(250) NULL DEFAULT NULL,
184 `descripcion` VARCHAR(500) NULL DEFAULT NULL,
185 `fecha` DATE NULL DEFAULT NULL,
186 PRIMARY KEY (`idpublicacion`))
187ENGINE = InnoDB
188AUTO_INCREMENT = 3
189DEFAULT CHARACTER SET = utf8;
190
191
192-- -----------------------------------------------------
193-- Table `freejobs`.`contratista_especialidad`
194-- -----------------------------------------------------
195CREATE TABLE IF NOT EXISTS `freejobs`.`contratista_especialidad` (
196 `id_contratista_especialidad_publicacion` INT(11) NOT NULL AUTO_INCREMENT,
197 `idcontratista` INT(11) NOT NULL,
198 `idespecialidad` INT(11) NOT NULL,
199 `idpublicacion` INT(11) NOT NULL,
200 INDEX `fk_table1_contratista1_idx` (`idcontratista` ASC),
201 INDEX `fk_table1_especialidad1_idx` (`idespecialidad` ASC),
202 INDEX `fk_table1_publicacion1_idx` (`idpublicacion` ASC),
203 CONSTRAINT `fk_table1_contratista1`
204 FOREIGN KEY (`idcontratista`)
205 REFERENCES `freejobs`.`contratista` (`idcontratista`)
206 ON DELETE NO ACTION
207 ON UPDATE NO ACTION,
208 CONSTRAINT `fk_table1_especialidad1`
209 FOREIGN KEY (`idespecialidad`)
210 REFERENCES `freejobs`.`especialidad` (`idespecialidad`)
211 ON DELETE NO ACTION
212 ON UPDATE NO ACTION,
213 CONSTRAINT `fk_table1_publicacion1`
214 FOREIGN KEY (`idpublicacion`)
215 REFERENCES `freejobs`.`publicacion` (`idpublicacion`)
216 ON DELETE NO ACTION
217 ON UPDATE NO ACTION)
218ENGINE = InnoDB
219DEFAULT CHARACTER SET = utf8;
220
221
222-- -----------------------------------------------------
223-- Table `freejobs`.`ubicacion`
224-- -----------------------------------------------------
225CREATE TABLE IF NOT EXISTS `freejobs`.`ubicacion` (
226 `id_ubicacion` INT NOT NULL AUTO_INCREMENT,
227 `ubicacion_nombre` VARCHAR(45) NULL,
228 `latitud` VARCHAR(45) NULL,
229 `longitud` VARCHAR(45) NULL,
230 PRIMARY KEY (`id_ubicacion`))
231ENGINE = InnoDB;
232
233
234-- -----------------------------------------------------
235-- Table `freejobs`.`contratista_ubicacion`
236-- -----------------------------------------------------
237CREATE TABLE IF NOT EXISTS `freejobs`.`contratista_ubicacion` (
238 `idcontratista_ubicacion` INT(11) NOT NULL AUTO_INCREMENT,
239 `idcontratista` INT(11) NOT NULL,
240 `id_ubicacion` INT NOT NULL,
241 PRIMARY KEY (`idcontratista_ubicacion`, `id_ubicacion`),
242 INDEX `fk_contratista_ubicacion_contratista1_idx` (`idcontratista` ASC),
243 INDEX `fk_contratista_ubicacion_ubicacion1_idx` (`id_ubicacion` ASC),
244 CONSTRAINT `fk_contratista_ubicacion_contratista1`
245 FOREIGN KEY (`idcontratista`)
246 REFERENCES `freejobs`.`contratista` (`idcontratista`)
247 ON DELETE NO ACTION
248 ON UPDATE NO ACTION,
249 CONSTRAINT `fk_contratista_ubicacion_ubicacion1`
250 FOREIGN KEY (`id_ubicacion`)
251 REFERENCES `freejobs`.`ubicacion` (`id_ubicacion`)
252 ON DELETE NO ACTION
253 ON UPDATE NO ACTION)
254ENGINE = InnoDB
255DEFAULT CHARACTER SET = utf8;
256
257
258-- -----------------------------------------------------
259-- Table `freejobs`.`disponibilidad`
260-- -----------------------------------------------------
261CREATE TABLE IF NOT EXISTS `freejobs`.`disponibilidad` (
262 `iddisponibilidad` INT(11) NOT NULL AUTO_INCREMENT,
263 `idcontratista` INT(11) NOT NULL,
264 `disponibilidad` VARCHAR(50) NULL DEFAULT NULL,
265 `online` INT(11) NULL DEFAULT NULL COMMENT 'Este campo servirá para determinar si el contratista se encuentra en linea o no.',
266 `lunes` INT(11) NULL DEFAULT NULL,
267 `martes` INT(11) NULL DEFAULT NULL,
268 `miercoles` INT(11) NULL DEFAULT NULL,
269 `jueves` INT(11) NULL DEFAULT NULL,
270 `viernes` INT(11) NULL DEFAULT NULL,
271 `sabado` INT(11) NULL DEFAULT NULL,
272 `domingo` INT(11) NULL DEFAULT NULL,
273 `horainicio` VARCHAR(45) NULL DEFAULT NULL,
274 `horafin` VARCHAR(45) NULL DEFAULT NULL,
275 PRIMARY KEY (`iddisponibilidad`),
276 INDEX `fk_disponibilidad_contratista1_idx` (`idcontratista` ASC),
277 CONSTRAINT `fk_disponibilidad_contratista1`
278 FOREIGN KEY (`idcontratista`)
279 REFERENCES `freejobs`.`contratista` (`idcontratista`)
280 ON DELETE NO ACTION
281 ON UPDATE NO ACTION)
282ENGINE = InnoDB
283DEFAULT CHARACTER SET = utf8;
284
285
286-- -----------------------------------------------------
287-- Table `freejobs`.`favorito`
288-- -----------------------------------------------------
289CREATE TABLE IF NOT EXISTS `freejobs`.`favorito` (
290 `idfavorito` INT(11) NOT NULL AUTO_INCREMENT,
291 `idusuario` INT(11) NOT NULL,
292 `idpublicacion` INT(11) NOT NULL,
293 PRIMARY KEY (`idfavorito`),
294 INDEX `fk_favorito_usuario1_idx` (`idusuario` ASC),
295 INDEX `fk_favorito_publicacion1_idx` (`idpublicacion` ASC),
296 CONSTRAINT `fk_favorito_publicacion1`
297 FOREIGN KEY (`idpublicacion`)
298 REFERENCES `freejobs`.`publicacion` (`idpublicacion`)
299 ON DELETE NO ACTION
300 ON UPDATE NO ACTION,
301 CONSTRAINT `fk_favorito_usuario1`
302 FOREIGN KEY (`idusuario`)
303 REFERENCES `freejobs`.`usuario` (`idusuario`)
304 ON DELETE NO ACTION
305 ON UPDATE NO ACTION)
306ENGINE = InnoDB
307DEFAULT CHARACTER SET = utf8;
308
309
310-- -----------------------------------------------------
311-- Table `freejobs`.`fidelizacioncompras`
312-- -----------------------------------------------------
313CREATE TABLE IF NOT EXISTS `freejobs`.`fidelizacioncompras` (
314 `idfidelizacioncompras` INT(11) NOT NULL AUTO_INCREMENT,
315 `nivelmaximo` INT(11) NULL DEFAULT NULL,
316 `compras` BIGINT(11) NULL DEFAULT NULL,
317 `nivel1` BIGINT(11) NULL DEFAULT NULL,
318 `nivel2` BIGINT(11) NULL DEFAULT NULL,
319 `nivel3` BIGINT(11) NULL DEFAULT NULL,
320 `nivel4` BIGINT(11) NULL DEFAULT NULL,
321 `nivel5` BIGINT(11) NULL DEFAULT NULL,
322 PRIMARY KEY (`idfidelizacioncompras`))
323ENGINE = InnoDB
324DEFAULT CHARACTER SET = utf8;
325
326
327-- -----------------------------------------------------
328-- Table `freejobs`.`fidelizacionreferidos`
329-- -----------------------------------------------------
330CREATE TABLE IF NOT EXISTS `freejobs`.`fidelizacionreferidos` (
331 `idfidelizacionreferidos` INT(11) NOT NULL AUTO_INCREMENT,
332 `nivelmaximo` INT(11) NULL DEFAULT NULL,
333 `nivel1` INT(11) NULL DEFAULT NULL,
334 `nivel2` INT(11) NULL DEFAULT NULL,
335 `nivel3` INT(11) NULL DEFAULT NULL,
336 `nivel4` INT(11) NULL DEFAULT NULL,
337 `nivel5` INT(11) NULL DEFAULT NULL,
338 PRIMARY KEY (`idfidelizacionreferidos`))
339ENGINE = InnoDB
340DEFAULT CHARACTER SET = utf8;
341
342
343-- -----------------------------------------------------
344-- Table `freejobs`.`historialservicio`
345-- -----------------------------------------------------
346CREATE TABLE IF NOT EXISTS `freejobs`.`historialservicio` (
347 `idhistorial` INT(11) NOT NULL AUTO_INCREMENT,
348 `idusuario` INT(11) NOT NULL,
349 `idservicio` INT(11) NOT NULL,
350 `idcontratista` INT(11) NOT NULL,
351 `fecha` DATE NULL DEFAULT NULL,
352 PRIMARY KEY (`idhistorial`),
353 INDEX `fk_historialservicio_usuario1_idx` (`idusuario` ASC),
354 INDEX `fk_historialservicio_servicio1_idx` (`idservicio` ASC),
355 INDEX `fk_historialservicio_contratista1_idx` (`idcontratista` ASC),
356 CONSTRAINT `fk_historialservicio_contratista1`
357 FOREIGN KEY (`idcontratista`)
358 REFERENCES `freejobs`.`contratista` (`idcontratista`)
359 ON DELETE NO ACTION
360 ON UPDATE NO ACTION,
361 CONSTRAINT `fk_historialservicio_servicio1`
362 FOREIGN KEY (`idservicio`)
363 REFERENCES `freejobs`.`servicio` (`idservicio`)
364 ON DELETE NO ACTION
365 ON UPDATE NO ACTION,
366 CONSTRAINT `fk_historialservicio_usuario1`
367 FOREIGN KEY (`idusuario`)
368 REFERENCES `freejobs`.`usuario` (`idusuario`)
369 ON DELETE NO ACTION
370 ON UPDATE NO ACTION)
371ENGINE = InnoDB
372AUTO_INCREMENT = 4
373DEFAULT CHARACTER SET = utf8;
374
375
376-- -----------------------------------------------------
377-- Table `freejobs`.`historialtransaccion`
378-- -----------------------------------------------------
379CREATE TABLE IF NOT EXISTS `freejobs`.`historialtransaccion` (
380 `idhistorialtransaccion` INT(11) NOT NULL AUTO_INCREMENT,
381 `idusuario` INT(11) NOT NULL,
382 `idcontratista` INT(11) NOT NULL,
383 `idservicio` INT(11) NOT NULL,
384 `fecha` DATE NULL DEFAULT NULL,
385 `valor` BIGINT(11) NULL DEFAULT NULL,
386 PRIMARY KEY (`idhistorialtransaccion`),
387 INDEX `fk_historialtransaccion_usuario1_idx` (`idusuario` ASC),
388 INDEX `fk_historialtransaccion_contratista1_idx` (`idcontratista` ASC),
389 INDEX `fk_historialtransaccion_servicio1_idx` (`idservicio` ASC),
390 CONSTRAINT `fk_historialtransaccion_contratista1`
391 FOREIGN KEY (`idcontratista`)
392 REFERENCES `freejobs`.`contratista` (`idcontratista`)
393 ON DELETE NO ACTION
394 ON UPDATE NO ACTION,
395 CONSTRAINT `fk_historialtransaccion_servicio1`
396 FOREIGN KEY (`idservicio`)
397 REFERENCES `freejobs`.`servicio` (`idservicio`)
398 ON DELETE NO ACTION
399 ON UPDATE NO ACTION,
400 CONSTRAINT `fk_historialtransaccion_usuario1`
401 FOREIGN KEY (`idusuario`)
402 REFERENCES `freejobs`.`usuario` (`idusuario`)
403 ON DELETE NO ACTION
404 ON UPDATE NO ACTION)
405ENGINE = InnoDB
406DEFAULT CHARACTER SET = utf8;
407
408
409-- -----------------------------------------------------
410-- Table `freejobs`.`ingresoauditoria`
411-- -----------------------------------------------------
412CREATE TABLE IF NOT EXISTS `freejobs`.`ingresoauditoria` (
413 `idingresoauditoria` INT(11) NOT NULL AUTO_INCREMENT,
414 `idusuario` INT(11) NOT NULL,
415 `fecha` DATETIME(6) NULL DEFAULT NULL,
416 `descripcion` VARCHAR(200) NULL DEFAULT NULL,
417 `ip` VARCHAR(45) NULL,
418 PRIMARY KEY (`idingresoauditoria`),
419 INDEX `fk_ingresoauditoria_usuario1_idx` (`idusuario` ASC),
420 CONSTRAINT `fk_ingresoauditoria_usuario1`
421 FOREIGN KEY (`idusuario`)
422 REFERENCES `freejobs`.`usuario` (`idusuario`)
423 ON DELETE NO ACTION
424 ON UPDATE NO ACTION)
425ENGINE = InnoDB
426DEFAULT CHARACTER SET = utf8;
427
428
429-- -----------------------------------------------------
430-- Table `freejobs`.`lugaresfavoritos`
431-- -----------------------------------------------------
432CREATE TABLE IF NOT EXISTS `freejobs`.`lugaresfavoritos` (
433 `idlugaresfavoritos` INT(11) NOT NULL AUTO_INCREMENT,
434 `idusuario` INT(11) NOT NULL,
435 `nombre` VARCHAR(45) NULL DEFAULT NULL,
436 `direccion` VARCHAR(45) NULL DEFAULT NULL,
437 PRIMARY KEY (`idlugaresfavoritos`),
438 INDEX `fk_lugaresfavoritos_usuario1_idx` (`idusuario` ASC),
439 CONSTRAINT `fk_lugaresfavoritos_usuario1`
440 FOREIGN KEY (`idusuario`)
441 REFERENCES `freejobs`.`usuario` (`idusuario`)
442 ON DELETE NO ACTION
443 ON UPDATE NO ACTION)
444ENGINE = InnoDB
445DEFAULT CHARACTER SET = utf8;
446
447
448-- -----------------------------------------------------
449-- Table `freejobs`.`referido`
450-- -----------------------------------------------------
451CREATE TABLE IF NOT EXISTS `freejobs`.`referido` (
452 `idreferido` INT(11) NOT NULL AUTO_INCREMENT,
453 `correoreferido` VARCHAR(100) NULL DEFAULT NULL,
454 `puntosdados` INT(11) NULL DEFAULT NULL,
455 `contratantepadre` INT(11) NULL DEFAULT NULL,
456 `estado` INT(11) NULL DEFAULT NULL,
457 `fecharecepcion` DATE NULL DEFAULT NULL,
458 `fechaexpiracion` DATE NULL DEFAULT NULL,
459 PRIMARY KEY (`idreferido`))
460ENGINE = InnoDB
461AUTO_INCREMENT = 4
462DEFAULT CHARACTER SET = utf8;
463
464
465-- -----------------------------------------------------
466-- Table `freejobs`.`registroauditoria`
467-- -----------------------------------------------------
468CREATE TABLE IF NOT EXISTS `freejobs`.`registroauditoria` (
469 `idregistroauditoria` INT(11) NOT NULL AUTO_INCREMENT,
470 `idusuario` INT(11) NOT NULL,
471 `fecha` DATETIME(6) NULL DEFAULT NULL,
472 `descripcion` VARCHAR(200) NULL DEFAULT NULL,
473 PRIMARY KEY (`idregistroauditoria`),
474 INDEX `fk_registroauditoria_usuario1_idx` (`idusuario` ASC),
475 CONSTRAINT `fk_registroauditoria_usuario1`
476 FOREIGN KEY (`idusuario`)
477 REFERENCES `freejobs`.`usuario` (`idusuario`)
478 ON DELETE NO ACTION
479 ON UPDATE NO ACTION)
480ENGINE = InnoDB
481DEFAULT CHARACTER SET = utf8;
482
483
484-- -----------------------------------------------------
485-- Table `freejobs`.`rol`
486-- -----------------------------------------------------
487CREATE TABLE IF NOT EXISTS `freejobs`.`rol` (
488 `idrol` INT(11) NOT NULL AUTO_INCREMENT,
489 `descripcion` VARCHAR(250) NULL DEFAULT NULL,
490 PRIMARY KEY (`idrol`))
491ENGINE = InnoDB
492DEFAULT CHARACTER SET = utf8;
493
494
495-- -----------------------------------------------------
496-- Table `freejobs`.`solicitud`
497-- -----------------------------------------------------
498CREATE TABLE IF NOT EXISTS `freejobs`.`solicitud` (
499 `idsolicitud` INT(11) NOT NULL AUTO_INCREMENT,
500 `idusuario` INT(11) NOT NULL,
501 `idservicio` INT(11) NOT NULL,
502 `estadoservicio` INT(11) NULL DEFAULT NULL,
503 `fecha` VARCHAR(45) NULL DEFAULT NULL,
504 `hora` VARCHAR(45) NULL DEFAULT NULL,
505 `idcontratista` INT(11) NOT NULL,
506 PRIMARY KEY (`idsolicitud`),
507 INDEX `fk_solicitud_servicio1_idx` (`idservicio` ASC),
508 INDEX `fk_solicitud_usuario1_idx` (`idusuario` ASC),
509 INDEX `fk_solicitud_contratista1_idx` (`idcontratista` ASC),
510 CONSTRAINT `fk_solicitud_servicio1`
511 FOREIGN KEY (`idservicio`)
512 REFERENCES `freejobs`.`servicio` (`idservicio`)
513 ON DELETE NO ACTION
514 ON UPDATE NO ACTION,
515 CONSTRAINT `fk_solicitud_usuario1`
516 FOREIGN KEY (`idusuario`)
517 REFERENCES `freejobs`.`usuario` (`idusuario`)
518 ON DELETE NO ACTION
519 ON UPDATE NO ACTION,
520 CONSTRAINT `fk_solicitud_contratista1`
521 FOREIGN KEY (`idcontratista`)
522 REFERENCES `freejobs`.`contratista` (`idcontratista`)
523 ON DELETE NO ACTION
524 ON UPDATE NO ACTION)
525ENGINE = InnoDB
526DEFAULT CHARACTER SET = utf8;
527
528
529-- -----------------------------------------------------
530-- Table `freejobs`.`usuario_referido`
531-- -----------------------------------------------------
532CREATE TABLE IF NOT EXISTS `freejobs`.`usuario_referido` (
533 `idusuario` INT(11) NOT NULL,
534 `idreferido` INT(11) NOT NULL,
535 INDEX `fk_usuario_referido_usuario1_idx` (`idusuario` ASC),
536 INDEX `fk_usuario_referido_referido1_idx` (`idreferido` ASC),
537 CONSTRAINT `fk_usuario_referido_referido1`
538 FOREIGN KEY (`idreferido`)
539 REFERENCES `freejobs`.`referido` (`idreferido`)
540 ON DELETE NO ACTION
541 ON UPDATE NO ACTION,
542 CONSTRAINT `fk_usuario_referido_usuario1`
543 FOREIGN KEY (`idusuario`)
544 REFERENCES `freejobs`.`usuario` (`idusuario`)
545 ON DELETE NO ACTION
546 ON UPDATE NO ACTION)
547ENGINE = InnoDB
548DEFAULT CHARACTER SET = utf8;
549
550
551-- -----------------------------------------------------
552-- Table `freejobs`.`usuario_rol`
553-- -----------------------------------------------------
554CREATE TABLE IF NOT EXISTS `freejobs`.`usuario_rol` (
555 `idrol` INT(11) NOT NULL,
556 `idusuario` INT(11) NOT NULL,
557 PRIMARY KEY (`idrol`, `idusuario`),
558 INDEX `fk_rol_has_usuario_usuario1_idx` (`idusuario` ASC),
559 INDEX `fk_rol_has_usuario_rol1_idx` (`idrol` ASC),
560 CONSTRAINT `fk_rol_has_usuario_rol1`
561 FOREIGN KEY (`idrol`)
562 REFERENCES `freejobs`.`rol` (`idrol`)
563 ON DELETE NO ACTION
564 ON UPDATE NO ACTION,
565 CONSTRAINT `fk_rol_has_usuario_usuario1`
566 FOREIGN KEY (`idusuario`)
567 REFERENCES `freejobs`.`usuario` (`idusuario`)
568 ON DELETE NO ACTION
569 ON UPDATE NO ACTION)
570ENGINE = InnoDB
571DEFAULT CHARACTER SET = utf8;
572
573
574SET SQL_MODE=@OLD_SQL_MODE;
575SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
576SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;