· 8 years ago · Nov 23, 2017, 08:12 AM
1-- MySQL Script generated by MySQL Workbench
2-- Thu Nov 23 02:24:57 2017
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema default_schema
12-- -----------------------------------------------------
13-- -----------------------------------------------------
14-- Schema ServitopBD01
15-- -----------------------------------------------------
16DROP SCHEMA IF EXISTS `ServitopBD01` ;
17
18-- -----------------------------------------------------
19-- Schema ServitopBD01
20-- -----------------------------------------------------
21CREATE SCHEMA IF NOT EXISTS `ServitopBD01` DEFAULT CHARACTER SET utf8 ;
22USE `ServitopBD01` ;
23
24-- -----------------------------------------------------
25-- Table `ServitopBD01`.`NumeroTelefono`
26-- -----------------------------------------------------
27CREATE TABLE IF NOT EXISTS `ServitopBD01`.`NumeroTelefono` (
28 `idNumTelf` INT NOT NULL,
29 `Numero` INT(30) NOT NULL,
30 `Estado` CHAR(1) NOT NULL,
31 PRIMARY KEY (`idNumTelf`))
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `ServitopBD01`.`TipoTelefono`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `ServitopBD01`.`TipoTelefono` (
39 `idTipoTelefono` INT NOT NULL,
40 `TipoTelefono` VARCHAR(45) NOT NULL,
41 `Estado` CHAR(1) NOT NULL,
42 `idNumTelf` INT NOT NULL,
43 PRIMARY KEY (`idTipoTelefono`, `idNumTelf`),
44 INDEX `fk_TipoTelefono_NumeroTelefono1_idx` (`idNumTelf` ASC),
45 CONSTRAINT `fk_TipoTelefono_NumeroTelefono1`
46 FOREIGN KEY (`idNumTelf`)
47 REFERENCES `ServitopBD01`.`NumeroTelefono` (`idNumTelf`)
48 ON DELETE NO ACTION
49 ON UPDATE NO ACTION)
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `ServitopBD01`.`Region`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Region` (
57 `idRegion` INT NOT NULL,
58 `NombRegion` VARCHAR(45) NOT NULL,
59 `Estado` CHAR(1) NOT NULL,
60 PRIMARY KEY (`idRegion`))
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `ServitopBD01`.`Provincia`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Provincia` (
68 `idProvincia` INT NOT NULL,
69 `idRegion` INT NOT NULL,
70 `NomProvincia` VARCHAR(45) NOT NULL,
71 `Estado` CHAR(1) NOT NULL,
72 PRIMARY KEY (`idProvincia`, `idRegion`),
73 INDEX `fk_Provincia_Region1_idx` (`idRegion` ASC),
74 CONSTRAINT `fk_Provincia_Region1`
75 FOREIGN KEY (`idRegion`)
76 REFERENCES `ServitopBD01`.`Region` (`idRegion`)
77 ON DELETE NO ACTION
78 ON UPDATE NO ACTION)
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `ServitopBD01`.`Distrito`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Distrito` (
86 `idDistrito` INT NOT NULL,
87 `idRegion` INT NOT NULL,
88 `idProvincia` INT NOT NULL,
89 `NombDistrito` VARCHAR(45) NOT NULL,
90 `Estado` CHAR(1) NOT NULL,
91 PRIMARY KEY (`idDistrito`, `idRegion`, `idProvincia`),
92 INDEX `fk_Distrito_Provincia1_idx` (`idProvincia` ASC, `idRegion` ASC),
93 CONSTRAINT `fk_Distrito_Provincia1`
94 FOREIGN KEY (`idProvincia` , `idRegion`)
95 REFERENCES `ServitopBD01`.`Provincia` (`idProvincia` , `idRegion`)
96 ON DELETE NO ACTION
97 ON UPDATE NO ACTION)
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `ServitopBD01`.`Empresa`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Empresa` (
105 `idEmpresa` INT NOT NULL,
106 `NombEmpresa` VARCHAR(45) NOT NULL,
107 `Estado` CHAR(1) NOT NULL,
108 PRIMARY KEY (`idEmpresa`))
109ENGINE = InnoDB;
110
111
112-- -----------------------------------------------------
113-- Table `ServitopBD01`.`NumeroDNI`
114-- -----------------------------------------------------
115CREATE TABLE IF NOT EXISTS `ServitopBD01`.`NumeroDNI` (
116 `idNumeroDNI` INT NOT NULL,
117 `Numero` INT(30) NOT NULL,
118 `Estado` CHAR(1) NOT NULL,
119 PRIMARY KEY (`idNumeroDNI`))
120ENGINE = InnoDB;
121
122
123-- -----------------------------------------------------
124-- Table `ServitopBD01`.`TipoDNI`
125-- -----------------------------------------------------
126CREATE TABLE IF NOT EXISTS `ServitopBD01`.`TipoDNI` (
127 `idTipoDNI` INT NOT NULL,
128 `Nombre` VARCHAR(45) NOT NULL,
129 `idNumeroDNI` INT NOT NULL,
130 `Estado` CHAR(1) NOT NULL,
131 PRIMARY KEY (`idTipoDNI`, `idNumeroDNI`),
132 INDEX `fk_TipoDNI_NumeroDNI1_idx` (`idNumeroDNI` ASC),
133 CONSTRAINT `fk_TipoDNI_NumeroDNI1`
134 FOREIGN KEY (`idNumeroDNI`)
135 REFERENCES `ServitopBD01`.`NumeroDNI` (`idNumeroDNI`)
136 ON DELETE NO ACTION
137 ON UPDATE NO ACTION)
138ENGINE = InnoDB;
139
140
141-- -----------------------------------------------------
142-- Table `ServitopBD01`.`Contacto`
143-- -----------------------------------------------------
144CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Contacto` (
145 `idContacto` INT NOT NULL,
146 `NombContacto` VARCHAR(45) NOT NULL,
147 `ApeParteno` VARCHAR(45) NOT NULL,
148 `ApeMaterno` VARCHAR(45) NOT NULL,
149 `DNI` INT(30) NOT NULL,
150 `idEmpresa` INT NOT NULL,
151 `E-mail` VARCHAR(45) NOT NULL,
152 `Estado` CHAR(1) NOT NULL,
153 `idTipoDNI` INT NOT NULL,
154 `idNumeroDNI` INT NOT NULL,
155 PRIMARY KEY (`idContacto`, `idEmpresa`),
156 INDEX `fk_Contacto_Empresa1_idx` (`idEmpresa` ASC),
157 INDEX `fk_Contacto_TipoDNI1_idx` (`idTipoDNI` ASC, `idNumeroDNI` ASC),
158 CONSTRAINT `fk_Contacto_Empresa1`
159 FOREIGN KEY (`idEmpresa`)
160 REFERENCES `ServitopBD01`.`Empresa` (`idEmpresa`)
161 ON DELETE NO ACTION
162 ON UPDATE NO ACTION,
163 CONSTRAINT `fk_Contacto_TipoDNI1`
164 FOREIGN KEY (`idTipoDNI` , `idNumeroDNI`)
165 REFERENCES `ServitopBD01`.`TipoDNI` (`idTipoDNI` , `idNumeroDNI`)
166 ON DELETE NO ACTION
167 ON UPDATE NO ACTION)
168ENGINE = InnoDB;
169
170
171-- -----------------------------------------------------
172-- Table `ServitopBD01`.`Cliente`
173-- -----------------------------------------------------
174CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Cliente` (
175 `idCliente` INT NOT NULL,
176 `idContacto` INT NOT NULL,
177 `idEmpresa` INT NOT NULL,
178 `RazonSocial` VARCHAR(45) NOT NULL,
179 `Rubro` VARCHAR(45) NOT NULL,
180 `Direccion` VARCHAR(45) NOT NULL,
181 `idTipoTelefono` INT NOT NULL,
182 `idNumTelf` INT NOT NULL,
183 `E-Mail` VARCHAR(80) NOT NULL,
184 `Estado` CHAR(1) NOT NULL,
185 `idDistrito` INT NOT NULL,
186 `idProvincia` INT NOT NULL,
187 `idRegion` INT NOT NULL,
188 PRIMARY KEY (`idCliente`, `idContacto`, `idEmpresa`),
189 INDEX `fk_Cliente_TipoTelefono1_idx` (`idTipoTelefono` ASC, `idNumTelf` ASC),
190 INDEX `fk_Cliente_Distrito1_idx` (`idDistrito` ASC, `idProvincia` ASC, `idRegion` ASC),
191 INDEX `fk_Cliente_Contacto1_idx` (`idContacto` ASC, `idEmpresa` ASC),
192 CONSTRAINT `fk_Cliente_TipoTelefono1`
193 FOREIGN KEY (`idTipoTelefono` , `idNumTelf`)
194 REFERENCES `ServitopBD01`.`TipoTelefono` (`idTipoTelefono` , `idNumTelf`)
195 ON DELETE NO ACTION
196 ON UPDATE NO ACTION,
197 CONSTRAINT `fk_Cliente_Distrito1`
198 FOREIGN KEY (`idDistrito` , `idProvincia` , `idRegion`)
199 REFERENCES `ServitopBD01`.`Distrito` (`idDistrito` , `idProvincia` , `idRegion`)
200 ON DELETE NO ACTION
201 ON UPDATE NO ACTION,
202 CONSTRAINT `fk_Cliente_Contacto1`
203 FOREIGN KEY (`idContacto` , `idEmpresa`)
204 REFERENCES `ServitopBD01`.`Contacto` (`idContacto` , `idEmpresa`)
205 ON DELETE NO ACTION
206 ON UPDATE NO ACTION)
207ENGINE = InnoDB;
208
209
210-- -----------------------------------------------------
211-- Table `ServitopBD01`.`Rol`
212-- -----------------------------------------------------
213CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Rol` (
214 `idRol` INT NOT NULL,
215 `NombRol` VARCHAR(45) NOT NULL,
216 `Estado` CHAR(1) NOT NULL,
217 PRIMARY KEY (`idRol`))
218ENGINE = InnoDB;
219
220
221-- -----------------------------------------------------
222-- Table `ServitopBD01`.`Area`
223-- -----------------------------------------------------
224CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Area` (
225 `idArea` INT NOT NULL,
226 `NombArea` VARCHAR(45) NOT NULL,
227 `Estado` CHAR(1) NOT NULL,
228 PRIMARY KEY (`idArea`))
229ENGINE = InnoDB;
230
231
232-- -----------------------------------------------------
233-- Table `ServitopBD01`.`Sexo`
234-- -----------------------------------------------------
235CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Sexo` (
236 `idSexo` INT NOT NULL,
237 `NomSexo` VARCHAR(45) NOT NULL,
238 `Estado` VARCHAR(1) NOT NULL,
239 PRIMARY KEY (`idSexo`))
240ENGINE = InnoDB
241DEFAULT CHARACTER SET = swe7;
242
243
244-- -----------------------------------------------------
245-- Table `ServitopBD01`.`EstadoCivil`
246-- -----------------------------------------------------
247CREATE TABLE IF NOT EXISTS `ServitopBD01`.`EstadoCivil` (
248 `idEstadoCivil` INT NOT NULL,
249 `EstadoCivil` VARCHAR(45) NOT NULL,
250 `Estado` CHAR(1) NOT NULL,
251 PRIMARY KEY (`idEstadoCivil`))
252ENGINE = InnoDB;
253
254
255-- -----------------------------------------------------
256-- Table `ServitopBD01`.`Colaborador`
257-- -----------------------------------------------------
258CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Colaborador` (
259 `idColaborador` INT NOT NULL,
260 `NomColabordor` VARCHAR(45) NOT NULL,
261 `ApePaterno` VARCHAR(45) NOT NULL,
262 `ApeMaterno` VARCHAR(45) NOT NULL,
263 `idSexo` INT NOT NULL,
264 `FechaNac` DATE NOT NULL,
265 `idTipoDNI` INT NOT NULL,
266 `idNumeroDNI` INT NOT NULL,
267 `idEstadoCivil` INT NOT NULL,
268 `idTipoTelefono` INT NOT NULL,
269 `idNumTelf` INT NOT NULL,
270 `idArea` INT NOT NULL,
271 `idRol` INT NOT NULL,
272 `idRegion` INT NOT NULL,
273 `idProvincia` INT NOT NULL,
274 `idDistrito` INT NOT NULL,
275 `Direccion` VARCHAR(45) NOT NULL,
276 `Email` VARCHAR(70) NOT NULL,
277 `FechaIngreso` DATE NOT NULL,
278 `Estado` CHAR(1) NOT NULL,
279 PRIMARY KEY (`idColaborador`, `idRol`),
280 INDEX `fk_Colaborador_Rol1_idx` (`idRol` ASC),
281 INDEX `fk_Colaborador_TipoTelefono1_idx` (`idTipoTelefono` ASC, `idNumTelf` ASC),
282 INDEX `fk_Colaborador_TipoDNI1_idx` (`idTipoDNI` ASC, `idNumeroDNI` ASC),
283 INDEX `fk_Colaborador_Area1_idx` (`idArea` ASC),
284 INDEX `fk_Colaborador_Sexo1_idx` (`idSexo` ASC),
285 INDEX `fk_Colaborador_EstadoCivil1_idx` (`idEstadoCivil` ASC),
286 INDEX `fk_Colaborador_Distrito1_idx` (`idDistrito` ASC, `idProvincia` ASC, `idRegion` ASC),
287 CONSTRAINT `fk_Colaborador_Rol1`
288 FOREIGN KEY (`idRol`)
289 REFERENCES `ServitopBD01`.`Rol` (`idRol`)
290 ON DELETE NO ACTION
291 ON UPDATE NO ACTION,
292 CONSTRAINT `fk_Colaborador_TipoTelefono1`
293 FOREIGN KEY (`idTipoTelefono` , `idNumTelf`)
294 REFERENCES `ServitopBD01`.`TipoTelefono` (`idTipoTelefono` , `idNumTelf`)
295 ON DELETE NO ACTION
296 ON UPDATE NO ACTION,
297 CONSTRAINT `fk_Colaborador_TipoDNI1`
298 FOREIGN KEY (`idTipoDNI` , `idNumeroDNI`)
299 REFERENCES `ServitopBD01`.`TipoDNI` (`idTipoDNI` , `idNumeroDNI`)
300 ON DELETE NO ACTION
301 ON UPDATE NO ACTION,
302 CONSTRAINT `fk_Colaborador_Area1`
303 FOREIGN KEY (`idArea`)
304 REFERENCES `ServitopBD01`.`Area` (`idArea`)
305 ON DELETE NO ACTION
306 ON UPDATE NO ACTION,
307 CONSTRAINT `fk_Colaborador_Sexo1`
308 FOREIGN KEY (`idSexo`)
309 REFERENCES `ServitopBD01`.`Sexo` (`idSexo`)
310 ON DELETE NO ACTION
311 ON UPDATE NO ACTION,
312 CONSTRAINT `fk_Colaborador_EstadoCivil1`
313 FOREIGN KEY (`idEstadoCivil`)
314 REFERENCES `ServitopBD01`.`EstadoCivil` (`idEstadoCivil`)
315 ON DELETE NO ACTION
316 ON UPDATE NO ACTION,
317 CONSTRAINT `fk_Colaborador_Distrito1`
318 FOREIGN KEY (`idDistrito` , `idProvincia` , `idRegion`)
319 REFERENCES `ServitopBD01`.`Distrito` (`idDistrito` , `idProvincia` , `idRegion`)
320 ON DELETE NO ACTION
321 ON UPDATE NO ACTION)
322ENGINE = InnoDB;
323
324
325-- -----------------------------------------------------
326-- Table `ServitopBD01`.`Usuario`
327-- -----------------------------------------------------
328CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Usuario` (
329 `idUsuario` INT NOT NULL,
330 `idColaborador` INT NOT NULL,
331 `idRol` INT NOT NULL,
332 `Usuario` VARCHAR(15) NOT NULL,
333 `Contraseña` VARCHAR(8) NOT NULL,
334 `Estado` CHAR(1) NOT NULL,
335 PRIMARY KEY (`idUsuario`),
336 INDEX `fk_Usuario_Colaborador1_idx` (`idColaborador` ASC, `idRol` ASC),
337 CONSTRAINT `fk_Usuario_Colaborador1`
338 FOREIGN KEY (`idColaborador` , `idRol`)
339 REFERENCES `ServitopBD01`.`Colaborador` (`idColaborador` , `idRol`)
340 ON DELETE NO ACTION
341 ON UPDATE NO ACTION)
342ENGINE = InnoDB;
343
344
345-- -----------------------------------------------------
346-- Table `ServitopBD01`.`TipoProveedor`
347-- -----------------------------------------------------
348CREATE TABLE IF NOT EXISTS `ServitopBD01`.`TipoProveedor` (
349 `idTipoProveedor` INT NOT NULL,
350 `NombProveedor` VARCHAR(45) NOT NULL,
351 `Estado` CHAR(1) NOT NULL,
352 PRIMARY KEY (`idTipoProveedor`))
353ENGINE = InnoDB;
354
355
356-- -----------------------------------------------------
357-- Table `ServitopBD01`.`Proveedor`
358-- -----------------------------------------------------
359CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Proveedor` (
360 `idProveedor` INT NOT NULL,
361 `RazonSocial` VARCHAR(45) NOT NULL,
362 `RUC` INT(30) NOT NULL,
363 `Direccion` VARCHAR(45) NOT NULL,
364 `idNumTelf` INT NOT NULL,
365 `idTipoTelefono` INT NOT NULL,
366 `idTipoProveedor` INT NOT NULL,
367 `idDistrito` INT NOT NULL,
368 `idProvincia` INT NOT NULL,
369 `idRegion` INT NOT NULL,
370 `Estado` CHAR(1) NOT NULL,
371 PRIMARY KEY (`idProveedor`),
372 INDEX `fk_Proveedor_TipoTelefono1_idx` (`idTipoTelefono` ASC, `idNumTelf` ASC),
373 INDEX `fk_Proveedor_TipoProveedor1_idx` (`idTipoProveedor` ASC),
374 INDEX `fk_Proveedor_Distrito1_idx` (`idDistrito` ASC, `idProvincia` ASC, `idRegion` ASC),
375 CONSTRAINT `fk_Proveedor_TipoTelefono1`
376 FOREIGN KEY (`idTipoTelefono` , `idNumTelf`)
377 REFERENCES `ServitopBD01`.`TipoTelefono` (`idTipoTelefono` , `idNumTelf`)
378 ON DELETE NO ACTION
379 ON UPDATE NO ACTION,
380 CONSTRAINT `fk_Proveedor_TipoProveedor1`
381 FOREIGN KEY (`idTipoProveedor`)
382 REFERENCES `ServitopBD01`.`TipoProveedor` (`idTipoProveedor`)
383 ON DELETE NO ACTION
384 ON UPDATE NO ACTION,
385 CONSTRAINT `fk_Proveedor_Distrito1`
386 FOREIGN KEY (`idDistrito` , `idProvincia` , `idRegion`)
387 REFERENCES `ServitopBD01`.`Distrito` (`idDistrito` , `idProvincia` , `idRegion`)
388 ON DELETE NO ACTION
389 ON UPDATE NO ACTION)
390ENGINE = InnoDB;
391
392
393-- -----------------------------------------------------
394-- Table `ServitopBD01`.`Categoria`
395-- -----------------------------------------------------
396CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Categoria` (
397 `idCategoria` INT NOT NULL,
398 `NomCategoria` VARCHAR(45) NOT NULL,
399 `Estado` CHAR(1) NOT NULL,
400 PRIMARY KEY (`idCategoria`))
401ENGINE = InnoDB;
402
403
404-- -----------------------------------------------------
405-- Table `ServitopBD01`.`Marca`
406-- -----------------------------------------------------
407CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Marca` (
408 `idMarca` INT NOT NULL,
409 `NombMarca` VARCHAR(45) NOT NULL,
410 `Estado` CHAR(1) NOT NULL,
411 PRIMARY KEY (`idMarca`))
412ENGINE = InnoDB;
413
414
415-- -----------------------------------------------------
416-- Table `ServitopBD01`.`Talla`
417-- -----------------------------------------------------
418CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Talla` (
419 `idTalla` INT NOT NULL,
420 `NombTalla` VARCHAR(45) NOT NULL,
421 `Estado` CHAR(1) NOT NULL,
422 PRIMARY KEY (`idTalla`))
423ENGINE = InnoDB;
424
425
426-- -----------------------------------------------------
427-- Table `ServitopBD01`.`Producto`
428-- -----------------------------------------------------
429CREATE TABLE IF NOT EXISTS `ServitopBD01`.`Producto` (
430 `idProducto` INT NOT NULL,
431 `Categoria` INT NOT NULL,
432 `idMarca` INT NOT NULL,
433 `idTalla` INT NOT NULL,
434 `Descripcion` VARCHAR(45) NOT NULL,
435 `Color` VARCHAR(45) NOT NULL,
436 `PresioUn` DOUBLE NOT NULL,
437 `Stock` INT(11) NOT NULL,
438 `presioTotal` DOUBLE NOT NULL,
439 `Estado` CHAR(1) NOT NULL,
440 PRIMARY KEY (`idProducto`, `Categoria`),
441 INDEX `fk_Producto_Categoria1_idx` (`Categoria` ASC),
442 INDEX `fk_Producto_Marca1_idx` (`idMarca` ASC),
443 INDEX `fk_Producto_Talla1_idx` (`idTalla` ASC),
444 CONSTRAINT `fk_Producto_Categoria1`
445 FOREIGN KEY (`Categoria`)
446 REFERENCES `ServitopBD01`.`Categoria` (`idCategoria`)
447 ON DELETE NO ACTION
448 ON UPDATE NO ACTION,
449 CONSTRAINT `fk_Producto_Marca1`
450 FOREIGN KEY (`idMarca`)
451 REFERENCES `ServitopBD01`.`Marca` (`idMarca`)
452 ON DELETE NO ACTION
453 ON UPDATE NO ACTION,
454 CONSTRAINT `fk_Producto_Talla1`
455 FOREIGN KEY (`idTalla`)
456 REFERENCES `ServitopBD01`.`Talla` (`idTalla`)
457 ON DELETE NO ACTION
458 ON UPDATE NO ACTION)
459ENGINE = InnoDB;
460
461
462-- -----------------------------------------------------
463-- Table `ServitopBD01`.`ContAcceso`
464-- -----------------------------------------------------
465CREATE TABLE IF NOT EXISTS `ServitopBD01`.`ContAcceso` (
466 `idContAcceso` INT NOT NULL AUTO_INCREMENT,
467 `idUsuario` INT NOT NULL,
468 `Fecha` DATE NOT NULL,
469 `HoraIngreso` TIME NOT NULL,
470 `HoraSalida` TIME NOT NULL,
471 `Estado` CHAR(1) NOT NULL,
472 PRIMARY KEY (`idContAcceso`),
473 INDEX `fk_ContAcceso_Usuario1_idx` (`idUsuario` ASC),
474 CONSTRAINT `fk_ContAcceso_Usuario1`
475 FOREIGN KEY (`idUsuario`)
476 REFERENCES `ServitopBD01`.`Usuario` (`idUsuario`)
477 ON DELETE NO ACTION
478 ON UPDATE NO ACTION)
479ENGINE = InnoDB;
480
481
482-- -----------------------------------------------------
483-- Table `ServitopBD01`.`TipoMateriaP`
484-- -----------------------------------------------------
485CREATE TABLE IF NOT EXISTS `ServitopBD01`.`TipoMateriaP` (
486 `idTipoMateriaP` INT NOT NULL,
487 `Nombre` VARCHAR(45) NOT NULL,
488 `Estado` CHAR(1) NOT NULL,
489 PRIMARY KEY (`idTipoMateriaP`))
490ENGINE = InnoDB;
491
492
493-- -----------------------------------------------------
494-- Table `ServitopBD01`.`MateriaPrima`
495-- -----------------------------------------------------
496CREATE TABLE IF NOT EXISTS `ServitopBD01`.`MateriaPrima` (
497 `idMateriaPrima` INT NOT NULL,
498 `idTipoMateriaP` INT NOT NULL,
499 `Descripcion` VARCHAR(45) NOT NULL,
500 `Espesor` DOUBLE NOT NULL,
501 `Largo` DOUBLE NOT NULL,
502 `Ancho` DOUBLE NOT NULL,
503 `Color` VARCHAR(45) NOT NULL,
504 `Stock` INT(11) NOT NULL,
505 `PresioUn` DOUBLE NOT NULL,
506 `PresioTotal` DOUBLE NOT NULL,
507 `Estado` CHAR(1) NOT NULL,
508 PRIMARY KEY (`idMateriaPrima`),
509 INDEX `fk_MateriaPrima_TipoMateriaP1_idx` (`idTipoMateriaP` ASC),
510 CONSTRAINT `fk_MateriaPrima_TipoMateriaP1`
511 FOREIGN KEY (`idTipoMateriaP`)
512 REFERENCES `ServitopBD01`.`TipoMateriaP` (`idTipoMateriaP`)
513 ON DELETE NO ACTION
514 ON UPDATE NO ACTION)
515ENGINE = InnoDB;
516
517
518SET SQL_MODE=@OLD_SQL_MODE;
519SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
520SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;