SUMhgj1d

1-- MySQL Script generated by MySQL Workbench
2-- Mon May 28 12:47:30 2018
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='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema test_db
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema test_db
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `test_db` DEFAULT CHARACTER SET utf8 ;
18USE `test_db` ;
19
20-- -----------------------------------------------------
21-- Table `test_db`.`Users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `test_db`.`Users` (
24  `idUser` INT NOT NULL AUTO_INCREMENT,
25  `name` VARCHAR(45) NOT NULL,
26  `password` VARCHAR(64) NOT NULL,
27  PRIMARY KEY (`idUser`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `test_db`.`Posts`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `test_db`.`Posts` (
35  `idPost` INT NOT NULL AUTO_INCREMENT,
36  `title` VARCHAR(32) NOT NULL,
37  `text` VARCHAR(128) NOT NULL,
38  `Users_idUser` INT NOT NULL,
39  PRIMARY KEY (`idPost`, `Users_idUser`),
40  INDEX `fk_Posts_Users1_idx` (`Users_idUser` ASC),
41  CONSTRAINT `fk_Posts_Users1`
42    FOREIGN KEY (`Users_idUser`)
43    REFERENCES `test_db`.`Users` (`idUser`)
44    ON DELETE NO ACTION
45    ON UPDATE NO ACTION)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `test_db`.`Tags`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `test_db`.`Tags` (
53  `idTag` INT NOT NULL AUTO_INCREMENT,
54  `name` VARCHAR(45) NOT NULL,
55  PRIMARY KEY (`idTag`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `test_db`.`Posts_has_Tags`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `test_db`.`Posts_has_Tags` (
63  `Posts_idPost` INT NOT NULL,
64  `Tags_idTag` INT NOT NULL,
65  PRIMARY KEY (`Posts_idPost`, `Tags_idTag`),
66  INDEX `fk_Posts_has_Tags_Tags1_idx` (`Tags_idTag` ASC),
67  INDEX `fk_Posts_has_Tags_Posts_idx` (`Posts_idPost` ASC),
68  CONSTRAINT `fk_Posts_has_Tags_Posts`
69    FOREIGN KEY (`Posts_idPost`)
70    REFERENCES `test_db`.`Posts` (`idPost`)
71    ON DELETE NO ACTION
72    ON UPDATE NO ACTION,
73  CONSTRAINT `fk_Posts_has_Tags_Tags1`
74    FOREIGN KEY (`Tags_idTag`)
75    REFERENCES `test_db`.`Tags` (`idTag`)
76    ON DELETE NO ACTION
77    ON UPDATE NO ACTION)
78ENGINE = InnoDB;
79
80
81SET SQL_MODE=@OLD_SQL_MODE;
82SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
83SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;