9XctaKta

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
5CREATE SCHEMA IF NOT EXISTS `biblioteca` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `biblioteca` ;
7
8-- -----------------------------------------------------
9-- Table `mydb`.`Users`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `mydb`.`Users` (
12  `login` VARCHAR(30) NOT NULL ,
13  `pass` VARCHAR(30) NULL ,
14  `level` INT(1) NULL ,
15  PRIMARY KEY (`login`) )
16ENGINE = InnoDB;
17
18
19-- -----------------------------------------------------
20-- Table `mydb`.`Personas`
21-- -----------------------------------------------------
22CREATE  TABLE IF NOT EXISTS `mydb`.`Personas` (
23  `idPersonas` INT NOT NULL AUTO_INCREMENT ,
24  `login` VARCHAR(15) NULL ,
25  `nombre` VARCHAR(45) NULL ,
26  `dni` VARCHAR(9) NULL ,
27  `localidad` VARCHAR(30) NULL ,
28  `telefono` INT(9) NULL ,
29  `fechaNacimiento` DATE NULL ,
30  `login` VARCHAR(30) NOT NULL ,
31  PRIMARY KEY (`idPersonas`) ,
32  INDEX `fk_Personas_Users1` (`login` ASC) ,
33  CONSTRAINT `fk_Personas_Users1`
34    FOREIGN KEY (`login` )
35    REFERENCES `mydb`.`Users` (`login` )
36    ON DELETE NO ACTION
37    ON UPDATE NO ACTION)
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `mydb`.`Editorial`
43-- -----------------------------------------------------
44CREATE  TABLE IF NOT EXISTS `mydb`.`Editorial` (
45  `idEditorial` INT NOT NULL AUTO_INCREMENT ,
46  `nombreEditorial` VARCHAR(30) NULL ,
47  `direccion` VARCHAR(50) NULL ,
48  `ciudad` VARCHAR(30) NULL ,
49  `correo` VARCHAR(45) NULL ,
50  `paginaWeb` VARCHAR(45) NULL ,
51  `telefono` INT(9) NULL ,
52  PRIMARY KEY (`idEditorial`) )
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `mydb`.`Autores`
58-- -----------------------------------------------------
59CREATE  TABLE IF NOT EXISTS `mydb`.`Autores` (
60  `idAutores` INT NOT NULL AUTO_INCREMENT ,
61  `nombre` VARCHAR(45) NULL ,
62  `pais` VARCHAR(45) NULL ,
63  PRIMARY KEY (`idAutores`) )
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`Libros`
69-- -----------------------------------------------------
70CREATE  TABLE IF NOT EXISTS `mydb`.`Libros` (
71  `idLibros` INT NOT NULL AUTO_INCREMENT ,
72  `titulo` VARCHAR(45) NULL ,
73  `tema` VARCHAR(20) NULL ,
74  `isbn` VARCHAR(30) NULL ,
75  `fechaAñadido` DATE NULL ,
76  `idioma` VARCHAR(15) NULL ,
77  `cantidad` INT(3) NULL ,
78  `idEditorial` INT NOT NULL ,
79  `idAutores` INT NOT NULL ,
80  PRIMARY KEY (`idLibros`) ,
81  INDEX `fk_Libros_Editorial1` (`idEditorial` ASC) ,
82  INDEX `fk_Libros_Autores1` (`idAutores` ASC) ,
83  CONSTRAINT `fk_Libros_Editorial1`
84    FOREIGN KEY (`idEditorial` )
85    REFERENCES `mydb`.`Editorial` (`idEditorial` )
86    ON DELETE NO ACTION
87    ON UPDATE NO ACTION,
88  CONSTRAINT `fk_Libros_Autores1`
89    FOREIGN KEY (`Autores_idAutores` )
90    REFERENCES `mydb`.`Autores` (`idAutores` )
91    ON DELETE NO ACTION
92    ON UPDATE NO ACTION)
93ENGINE = InnoDB;
94
95
96-- -----------------------------------------------------
97-- Table `mydb`.`Pedidos`
98-- -----------------------------------------------------
99CREATE  TABLE IF NOT EXISTS `mydb`.`Pedidos` (
100  `idPedidos` INT NOT NULL AUTO_INCREMENT ,
101  `fechaPedido` DATE NULL ,
102  `fechaDevolucion` DATE NULL ,
103  `devolucion` TINYINT(1) NULL ,
104  `idPersonas` INT NOT NULL ,
105  `idLibros` INT NOT NULL ,
106  PRIMARY KEY (`idPedidos`, `idPersonas`, `idLibros`) ,
107  INDEX `fk_Pedidos_Personas` (`idPersonas` ASC) ,
108  INDEX `fk_Pedidos_Libros1` (`idLibros` ASC) ,
109  CONSTRAINT `fk_Pedidos_Personas`
110    FOREIGN KEY (`idPersonas` )
111    REFERENCES `mydb`.`Personas` (`idPersonas` )
112    ON DELETE NO ACTION
113    ON UPDATE NO ACTION,
114  CONSTRAINT `fk_Pedidos_Libros1`
115    FOREIGN KEY (`idLibros` )
116    REFERENCES `mydb`.`Libros` (`idLibros` )
117    ON DELETE NO ACTION
118    ON UPDATE NO ACTION)
119ENGINE = InnoDB;
120
121
122
123SET SQL_MODE=@OLD_SQL_MODE;
124SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
125SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;