xRGk5NjH

1-- MySQL Script generated by MySQL Workbench
2-- Tue Sep 17 22:23:50 2019
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 k82221_testdb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema k82221_testdb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `k82221_testdb` DEFAULT CHARACTER SET utf8 ;
18USE `k82221_testdb` ;
19
20-- -----------------------------------------------------
21-- Table `k82221_testdb`.`auth`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `k82221_testdb`.`auth` ;
24
25CREATE TABLE IF NOT EXISTS `k82221_testdb`.`auth` (
26  `name` VARCHAR(45) NULL,
27  `password` BINARY(60) NULL,
28  `user_id` INT NOT NULL,
29  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
30  PRIMARY KEY (`user_id`),
31  CONSTRAINT `fk_auth_user`
32    FOREIGN KEY (`user_id`)
33    REFERENCES `k82221_testdb`.`user` (`id`)
34    ON DELETE NO ACTION
35    ON UPDATE NO ACTION)
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `k82221_testdb`.`permission`
41-- -----------------------------------------------------
42DROP TABLE IF EXISTS `k82221_testdb`.`permission` ;
43
44CREATE TABLE IF NOT EXISTS `k82221_testdb`.`permission` (
45)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `k82221_testdb`.`product`
51-- -----------------------------------------------------
52DROP TABLE IF EXISTS `k82221_testdb`.`product` ;
53
54CREATE TABLE IF NOT EXISTS `k82221_testdb`.`product` (
55  `id` INT NOT NULL,
56  `product_type_id` INT NOT NULL,
57  `user_id` INT NOT NULL,
58  PRIMARY KEY (`id`),
59  INDEX `fk_product_product_type1_idx` (`product_type_id` ASC),
60  INDEX `fk_product_user1_idx` (`user_id` ASC),
61  CONSTRAINT `fk_product_product_type1`
62    FOREIGN KEY (`product_type_id`)
63    REFERENCES `k82221_testdb`.`product_type` (`id`)
64    ON DELETE NO ACTION
65    ON UPDATE NO ACTION,
66  CONSTRAINT `fk_product_user1`
67    FOREIGN KEY (`user_id`)
68    REFERENCES `k82221_testdb`.`user` (`id`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION)
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `k82221_testdb`.`product_type`
76-- -----------------------------------------------------
77DROP TABLE IF EXISTS `k82221_testdb`.`product_type` ;
78
79CREATE TABLE IF NOT EXISTS `k82221_testdb`.`product_type` (
80  `id` INT NOT NULL,
81  `name` VARCHAR(45) NULL,
82  PRIMARY KEY (`id`))
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `k82221_testdb`.`user`
88-- -----------------------------------------------------
89DROP TABLE IF EXISTS `k82221_testdb`.`user` ;
90
91CREATE TABLE IF NOT EXISTS `k82221_testdb`.`user` (
92  `id` INT NOT NULL AUTO_INCREMENT,
93  `email` VARCHAR(45) NULL,
94  `name_full` VARCHAR(45) NULL,
95  `name_display` VARCHAR(45) NULL,
96  PRIMARY KEY (`id`),
97  UNIQUE INDEX `id_UNIQUE` (`id` ASC))
98ENGINE = InnoDB;
99
100
101SET SQL_MODE=@OLD_SQL_MODE;
102SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
103SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;