fTdDENQ1

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema firstModel
9-- -----------------------------------------------------
10DROP SCHEMA IF EXISTS `firstModel` ;
11
12-- -----------------------------------------------------
13-- Schema firstModel
14-- -----------------------------------------------------
15CREATE SCHEMA IF NOT EXISTS `firstModel` DEFAULT CHARACTER SET utf8 ;
16USE `firstModel` ;
17
18-- -----------------------------------------------------
19-- Table `firstModel`.`user`
20-- -----------------------------------------------------
21DROP TABLE IF EXISTS `firstModel`.`user` ;
22
23CREATE TABLE IF NOT EXISTS `firstModel`.`user` (
24  `id` INT NOT NULL AUTO_INCREMENT,
25  `firstname` VARCHAR(45) NOT NULL,
26  `secondname` VARCHAR(45) NOT NULL,
27  PRIMARY KEY (`id`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `firstModel`.`product`
33-- -----------------------------------------------------
34DROP TABLE IF EXISTS `firstModel`.`product` ;
35
36CREATE TABLE IF NOT EXISTS `firstModel`.`product` (
37  `idproduct` INT NOT NULL AUTO_INCREMENT,
38  `title` VARCHAR(100) NOT NULL,
39  `description` TEXT NULL,
40  PRIMARY KEY (`idproduct`))
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `firstModel`.`invoice`
46-- -----------------------------------------------------
47DROP TABLE IF EXISTS `firstModel`.`invoice` ;
48
49CREATE TABLE IF NOT EXISTS `firstModel`.`invoice` (
50  `idinvoice` INT NOT NULL AUTO_INCREMENT,
51  `userid` INT NOT NULL,
52  `productid` INT NOT NULL,
53  `cost` DECIMAL(10,2) NOT NULL,
54  PRIMARY KEY (`idinvoice`),
55  INDEX `user_idx` (`userid` ASC) VISIBLE,
56  INDEX `product_idx` (`productid` ASC) VISIBLE,
57  CONSTRAINT `user`
58    FOREIGN KEY (`userid`)
59    REFERENCES `firstModel`.`user` (`id`)
60    ON DELETE CASCADE
61    ON UPDATE CASCADE,
62  CONSTRAINT `prod`
63    FOREIGN KEY (`productid`)
64    REFERENCES `firstModel`.`product` (`idproduct`)
65    ON DELETE CASCADE
66    ON UPDATE CASCADE)
67ENGINE = InnoDB;
68
69
70SET SQL_MODE=@OLD_SQL_MODE;
71SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
72SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
73