· 8 years ago · May 19, 2018, 05:46 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';
4
5DROP SCHEMA IF EXISTS `mydb` ;
6CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
7USE `mydb` ;
8
9-- -----------------------------------------------------
10-- Table `mydb`.`tbSalas`
11-- -----------------------------------------------------
12DROP TABLE IF EXISTS `mydb`.`tbSalas` ;
13
14CREATE TABLE IF NOT EXISTS `mydb`.`tbSalas` (
15 `idsala` INT NOT NULL AUTO_INCREMENT ,
16 `sala` VARCHAR(50) NULL ,
17 PRIMARY KEY (`idsala`) )
18ENGINE = InnoDB;
19
20
21-- -----------------------------------------------------
22-- Table `mydb`.`tbMesas`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `mydb`.`tbMesas` ;
25
26CREATE TABLE IF NOT EXISTS `mydb`.`tbMesas` (
27 `idmesa` INT NOT NULL ,
28 `mesa` INT NULL ,
29 `tbSalas_idsala` INT NOT NULL ,
30 PRIMARY KEY (`idmesa`) ,
31 INDEX `fk_tbMesas_tbSalas` (`tbSalas_idsala` ASC) ,
32 CONSTRAINT `fk_tbMesas_tbSalas`
33 FOREIGN KEY (`tbSalas_idsala` )
34 REFERENCES `mydb`.`tbSalas` (`idsala` )
35 ON DELETE NO ACTION
36 ON UPDATE NO ACTION)
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table `mydb`.`tbOcupacion`
42-- -----------------------------------------------------
43DROP TABLE IF EXISTS `mydb`.`tbOcupacion` ;
44
45CREATE TABLE IF NOT EXISTS `mydb`.`tbOcupacion` (
46 `idocupacion` INT NOT NULL AUTO_INCREMENT ,
47 `fecha_hora` DATETIME NULL ,
48 `comensales` INT NULL ,
49 PRIMARY KEY (`idocupacion`) )
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `mydb`.`tbReservas`
55-- -----------------------------------------------------
56DROP TABLE IF EXISTS `mydb`.`tbReservas` ;
57
58CREATE TABLE IF NOT EXISTS `mydb`.`tbReservas` (
59 `idreserva` INT NOT NULL ,
60 `nombre_contacto` VARCHAR(50) NULL ,
61 `telefono_contacto` VARCHAR(45) NULL ,
62 `tbReservascol` VARCHAR(45) NULL ,
63 PRIMARY KEY (`idreserva`) )
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`tbBebidas`
69-- -----------------------------------------------------
70DROP TABLE IF EXISTS `mydb`.`tbBebidas` ;
71
72CREATE TABLE IF NOT EXISTS `mydb`.`tbBebidas` (
73 `idbebida` INT NOT NULL AUTO_INCREMENT ,
74 `bebida` VARCHAR(50) NULL ,
75 `precio` FLOAT NULL ,
76 PRIMARY KEY (`idbebida`) )
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `mydb`.`tbtiposPlatos`
82-- -----------------------------------------------------
83DROP TABLE IF EXISTS `mydb`.`tbtiposPlatos` ;
84
85CREATE TABLE IF NOT EXISTS `mydb`.`tbtiposPlatos` (
86 `idtipoplato` INT NOT NULL AUTO_INCREMENT ,
87 `tipo` VARCHAR(50) NULL ,
88 PRIMARY KEY (`idtipoplato`) )
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `mydb`.`tbPlatos`
94-- -----------------------------------------------------
95DROP TABLE IF EXISTS `mydb`.`tbPlatos` ;
96
97CREATE TABLE IF NOT EXISTS `mydb`.`tbPlatos` (
98 `idplato` INT NOT NULL AUTO_INCREMENT ,
99 `plato` VARCHAR(50) NULL ,
100 `descripcion` TEXT NULL ,
101 `precio` FLOAT NULL ,
102 `tbtiposPlatos_idtipoplato` INT NOT NULL ,
103 PRIMARY KEY (`idplato`) ,
104 INDEX `fk_tbPlatos_tbtiposPlatos1` (`tbtiposPlatos_idtipoplato` ASC) ,
105 CONSTRAINT `fk_tbPlatos_tbtiposPlatos1`
106 FOREIGN KEY (`tbtiposPlatos_idtipoplato` )
107 REFERENCES `mydb`.`tbtiposPlatos` (`idtipoplato` )
108 ON DELETE NO ACTION
109 ON UPDATE NO ACTION)
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `mydb`.`tbCamareros`
115-- -----------------------------------------------------
116DROP TABLE IF EXISTS `mydb`.`tbCamareros` ;
117
118CREATE TABLE IF NOT EXISTS `mydb`.`tbCamareros` (
119 `idcamarero` INT NOT NULL AUTO_INCREMENT ,
120 `camarero` VARCHAR(50) NULL ,
121 PRIMARY KEY (`idcamarero`) )
122ENGINE = InnoDB;
123
124
125-- -----------------------------------------------------
126-- Table `mydb`.`tbMesas_ocupacion`
127-- -----------------------------------------------------
128DROP TABLE IF EXISTS `mydb`.`tbMesas_ocupacion` ;
129
130CREATE TABLE IF NOT EXISTS `mydb`.`tbMesas_ocupacion` (
131 `tbMesas_idmesa` INT NOT NULL ,
132 `tbOcupacion_idocupacion` INT NOT NULL ,
133 PRIMARY KEY (`tbMesas_idmesa`, `tbOcupacion_idocupacion`) ,
134 INDEX `fk_tbMesas_has_tbOcupacion_tbOcupacion1` (`tbOcupacion_idocupacion` ASC) ,
135 INDEX `fk_tbMesas_has_tbOcupacion_tbMesas1` (`tbMesas_idmesa` ASC) ,
136 CONSTRAINT `fk_tbMesas_has_tbOcupacion_tbMesas1`
137 FOREIGN KEY (`tbMesas_idmesa` )
138 REFERENCES `mydb`.`tbMesas` (`idmesa` )
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION,
141 CONSTRAINT `fk_tbMesas_has_tbOcupacion_tbOcupacion1`
142 FOREIGN KEY (`tbOcupacion_idocupacion` )
143 REFERENCES `mydb`.`tbOcupacion` (`idocupacion` )
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB;
147
148
149-- -----------------------------------------------------
150-- Table `mydb`.`tbOcupacion_reserva`
151-- -----------------------------------------------------
152DROP TABLE IF EXISTS `mydb`.`tbOcupacion_reserva` ;
153
154CREATE TABLE IF NOT EXISTS `mydb`.`tbOcupacion_reserva` (
155 `tbReservas_idreserva` INT NOT NULL ,
156 `tbOcupacion_idocupacion` INT NOT NULL ,
157 PRIMARY KEY (`tbReservas_idreserva`, `tbOcupacion_idocupacion`) ,
158 INDEX `fk_tbReservas_has_tbOcupacion_tbOcupacion1` (`tbOcupacion_idocupacion` ASC) ,
159 INDEX `fk_tbReservas_has_tbOcupacion_tbReservas1` (`tbReservas_idreserva` ASC) ,
160 CONSTRAINT `fk_tbReservas_has_tbOcupacion_tbReservas1`
161 FOREIGN KEY (`tbReservas_idreserva` )
162 REFERENCES `mydb`.`tbReservas` (`idreserva` )
163 ON DELETE NO ACTION
164 ON UPDATE NO ACTION,
165 CONSTRAINT `fk_tbReservas_has_tbOcupacion_tbOcupacion1`
166 FOREIGN KEY (`tbOcupacion_idocupacion` )
167 REFERENCES `mydb`.`tbOcupacion` (`idocupacion` )
168 ON DELETE NO ACTION
169 ON UPDATE NO ACTION)
170ENGINE = InnoDB;
171
172
173-- -----------------------------------------------------
174-- Table `mydb`.`tbCamareros_ocupacion`
175-- -----------------------------------------------------
176DROP TABLE IF EXISTS `mydb`.`tbCamareros_ocupacion` ;
177
178CREATE TABLE IF NOT EXISTS `mydb`.`tbCamareros_ocupacion` (
179 `tbCamareros_idcamarero` INT NOT NULL ,
180 `tbOcupacion_idocupacion` INT NOT NULL ,
181 PRIMARY KEY (`tbCamareros_idcamarero`, `tbOcupacion_idocupacion`) ,
182 INDEX `fk_tbCamareros_has_tbOcupacion_tbOcupacion1` (`tbOcupacion_idocupacion` ASC) ,
183 INDEX `fk_tbCamareros_has_tbOcupacion_tbCamareros1` (`tbCamareros_idcamarero` ASC) ,
184 CONSTRAINT `fk_tbCamareros_has_tbOcupacion_tbCamareros1`
185 FOREIGN KEY (`tbCamareros_idcamarero` )
186 REFERENCES `mydb`.`tbCamareros` (`idcamarero` )
187 ON DELETE NO ACTION
188 ON UPDATE NO ACTION,
189 CONSTRAINT `fk_tbCamareros_has_tbOcupacion_tbOcupacion1`
190 FOREIGN KEY (`tbOcupacion_idocupacion` )
191 REFERENCES `mydb`.`tbOcupacion` (`idocupacion` )
192 ON DELETE NO ACTION
193 ON UPDATE NO ACTION)
194ENGINE = InnoDB;
195
196
197-- -----------------------------------------------------
198-- Table `mydb`.`tbReservas_platos`
199-- -----------------------------------------------------
200DROP TABLE IF EXISTS `mydb`.`tbReservas_platos` ;
201
202CREATE TABLE IF NOT EXISTS `mydb`.`tbReservas_platos` (
203 `tbReservas_idreserva` INT NOT NULL ,
204 `tbPlatos_idplato` INT NOT NULL ,
205 PRIMARY KEY (`tbReservas_idreserva`, `tbPlatos_idplato`) ,
206 INDEX `fk_tbReservas_has_tbPlatos_tbPlatos1` (`tbPlatos_idplato` ASC) ,
207 INDEX `fk_tbReservas_has_tbPlatos_tbReservas1` (`tbReservas_idreserva` ASC) ,
208 CONSTRAINT `fk_tbReservas_has_tbPlatos_tbReservas1`
209 FOREIGN KEY (`tbReservas_idreserva` )
210 REFERENCES `mydb`.`tbReservas` (`idreserva` )
211 ON DELETE NO ACTION
212 ON UPDATE NO ACTION,
213 CONSTRAINT `fk_tbReservas_has_tbPlatos_tbPlatos1`
214 FOREIGN KEY (`tbPlatos_idplato` )
215 REFERENCES `mydb`.`tbPlatos` (`idplato` )
216 ON DELETE NO ACTION
217 ON UPDATE NO ACTION)
218ENGINE = InnoDB;
219
220
221-- -----------------------------------------------------
222-- Table `mydb`.`tbReservas_bebidas`
223-- -----------------------------------------------------
224DROP TABLE IF EXISTS `mydb`.`tbReservas_bebidas` ;
225
226CREATE TABLE IF NOT EXISTS `mydb`.`tbReservas_bebidas` (
227 `tbReservas_idreserva` INT NOT NULL ,
228 `tbBebidas_idbebida` INT NOT NULL ,
229 PRIMARY KEY (`tbReservas_idreserva`, `tbBebidas_idbebida`) ,
230 INDEX `fk_tbReservas_has_tbBebidas_tbBebidas1` (`tbBebidas_idbebida` ASC) ,
231 INDEX `fk_tbReservas_has_tbBebidas_tbReservas1` (`tbReservas_idreserva` ASC) ,
232 CONSTRAINT `fk_tbReservas_has_tbBebidas_tbReservas1`
233 FOREIGN KEY (`tbReservas_idreserva` )
234 REFERENCES `mydb`.`tbReservas` (`idreserva` )
235 ON DELETE NO ACTION
236 ON UPDATE NO ACTION,
237 CONSTRAINT `fk_tbReservas_has_tbBebidas_tbBebidas1`
238 FOREIGN KEY (`tbBebidas_idbebida` )
239 REFERENCES `mydb`.`tbBebidas` (`idbebida` )
240 ON DELETE NO ACTION
241 ON UPDATE NO ACTION)
242ENGINE = InnoDB;
243
244
245
246SET SQL_MODE=@OLD_SQL_MODE;
247SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
248SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;