xRPiPjgY

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 mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`authors`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`authors` (
21  `id` INT NOT NULL AUTO_INCREMENT,
22  `firstName` VARCHAR(100) NULL,
23  `LastName` VARCHAR(100) NULL,
24  PRIMARY KEY (`id`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`genres`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mydb`.`genres` (
32  `id` INT NOT NULL AUTO_INCREMENT,
33  `name` VARCHAR(100) NULL,
34  PRIMARY KEY (`id`))
35ENGINE = InnoDB;
36
37
38-- -----------------------------------------------------
39-- Table `mydb`.`Books`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `mydb`.`Books` (
42  `id` INT NOT NULL AUTO_INCREMENT,
43  `title` VARCHAR(100) NULL,
44  `author` INT NULL,
45  `genre` INT NULL,
46  `releaseDate` DATE NULL,
47  `lastUpdate` DATETIME NULL,
48  `picture` VARCHAR(100) NULL,
49  PRIMARY KEY (`id`),
50  INDEX `fk_Books_authors_idx` (`author` ASC),
51  INDEX `fk_Books_genres1_idx` (`genre` ASC),
52  CONSTRAINT `fk_Books_authors`
53    FOREIGN KEY (`author`)
54    REFERENCES `mydb`.`authors` (`id`)
55    ON DELETE NO ACTION
56    ON UPDATE NO ACTION,
57  CONSTRAINT `fk_Books_genres1`
58    FOREIGN KEY (`genre`)
59    REFERENCES `mydb`.`genres` (`id`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION)
62ENGINE = InnoDB;
63
64
65SET SQL_MODE=@OLD_SQL_MODE;
66SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
67SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;