· 8 years ago · Dec 13, 2017, 09:12 PM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5-- -----------------------------------------------------
6-- Schema mydb
7-- -----------------------------------------------------
8-- -----------------------------------------------------
9-- Schema instalaciones
10-- -----------------------------------------------------
11
12-- -----------------------------------------------------
13-- Schema instalaciones
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `instalaciones` DEFAULT CHARACTER SET latin1 ;
16USE `instalaciones` ;
17
18-- -----------------------------------------------------
19-- Table `instalaciones`.`articulo`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `instalaciones`.`articulo` (
22 `id_articulo` INT(11) NOT NULL,
23 `nombre` VARCHAR(20) NOT NULL,
24 `cantidad` DECIMAL(10,0) NULL DEFAULT NULL,
25 PRIMARY KEY (`id_articulo`))
26ENGINE = InnoDB
27DEFAULT CHARACTER SET = latin1;
28
29
30-- -----------------------------------------------------
31-- Table `instalaciones`.`instalacion`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `instalaciones`.`instalacion` (
34 `id_instalacion` INT(11) NOT NULL,
35 `nombre` VARCHAR(10) NULL DEFAULT NULL,
36 PRIMARY KEY (`id_instalacion`))
37ENGINE = InnoDB
38DEFAULT CHARACTER SET = latin1;
39
40
41-- -----------------------------------------------------
42-- Table `instalaciones`.`socios`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `instalaciones`.`socios` (
45 `id_socio` INT(11) NOT NULL,
46 `nombre` VARCHAR(20) NOT NULL,
47 `apellidos` VARCHAR(40) NOT NULL,
48 `direccion` VARCHAR(120) NOT NULL,
49 `telefono` DECIMAL(9,0) NOT NULL,
50 PRIMARY KEY (`id_socio`))
51ENGINE = InnoDB
52DEFAULT CHARACTER SET = latin1;
53
54
55-- -----------------------------------------------------
56-- Table `instalaciones`.`reserva`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `instalaciones`.`reserva` (
59 `id_reserva` INT(11) NOT NULL,
60 `f_inicio` DATE NULL DEFAULT NULL,
61 `f_fin` DATE NULL DEFAULT NULL,
62 `f_canc` DATE NULL DEFAULT NULL,
63 `socio_id_socio` INT(11) NOT NULL,
64 `instalacion_id_instalacion` INT(11) NOT NULL,
65 PRIMARY KEY (`id_reserva`),
66 INDEX `fkreserva_socio` (`socio_id_socio` ASC),
67 INDEX `fkreserva_instalacion` (`instalacion_id_instalacion` ASC),
68 CONSTRAINT `fkreserva_instalacion`
69 FOREIGN KEY (`instalacion_id_instalacion`)
70 REFERENCES `instalaciones`.`instalacion` (`id_instalacion`),
71 CONSTRAINT `fkreserva_socio`
72 FOREIGN KEY (`socio_id_socio`)
73 REFERENCES `instalaciones`.`socios` (`id_socio`))
74ENGINE = InnoDB
75DEFAULT CHARACTER SET = latin1;
76
77
78-- -----------------------------------------------------
79-- Table `instalaciones`.`articulo_has_reserva`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `instalaciones`.`articulo_has_reserva` (
82 `articulo_id_articulo` INT(11) NOT NULL,
83 `reserva_id_reserva` INT(11) NOT NULL,
84 PRIMARY KEY (`articulo_id_articulo`, `reserva_id_reserva`),
85 INDEX `fk_articulo_has_reserva_reserva1_idx` (`reserva_id_reserva` ASC),
86 INDEX `fk_articulo_has_reserva_articulo1_idx` (`articulo_id_articulo` ASC),
87 CONSTRAINT `fk_articulo_has_reserva_articulo1`
88 FOREIGN KEY (`articulo_id_articulo`)
89 REFERENCES `instalaciones`.`articulo` (`id_articulo`)
90 ON DELETE NO ACTION
91 ON UPDATE NO ACTION,
92 CONSTRAINT `fk_articulo_has_reserva_reserva1`
93 FOREIGN KEY (`reserva_id_reserva`)
94 REFERENCES `instalaciones`.`reserva` (`id_reserva`)
95 ON DELETE NO ACTION
96 ON UPDATE NO ACTION)
97ENGINE = InnoDB
98DEFAULT CHARACTER SET = latin1;
99
100
101SET SQL_MODE=@OLD_SQL_MODE;
102SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
103SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;