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