Xf3gdb4X

1-- MySQL Script generated by MySQL Workbench
2-- 01/10/17 11:01:07
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 mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`user`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`user` (
24  `id` INT UNSIGNED NOT NULL,
25  `login` NVARCHAR(10) NULL,
26  `password` VARCHAR(10) NULL,
27  `email` VARCHAR(20) NULL,
28  `role` VARCHAR(10) NULL,
29  PRIMARY KEY (`id`),
30  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
31  UNIQUE INDEX `id_UNIQUE` (`id` ASC))
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `mydb`.`language`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `mydb`.`language` (
39  `id` INT NOT NULL,
40  `language` VARCHAR(5) NULL,
41  PRIMARY KEY (`id`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `mydb`.`textProject`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `mydb`.`textProject` (
49  `id` INT NOT NULL,
50  `name` VARCHAR(20) NULL,
51  `languageTo` INT NOT NULL,
52  `languageFrom` INT NOT NULL,
53  PRIMARY KEY (`id`, `languageTo`, `languageFrom`),
54  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
55  INDEX `fk_textProject_language_idx` (`languageTo` ASC),
56  INDEX `fk_textProject_language1_idx` (`languageFrom` ASC),
57  CONSTRAINT `fk_textProject_language`
58    FOREIGN KEY (`languageTo`)
59    REFERENCES `mydb`.`language` (`id`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION,
62  CONSTRAINT `fk_textProject_language1`
63    FOREIGN KEY (`languageFrom`)
64    REFERENCES `mydb`.`language` (`id`)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `mydb`.`textPart`
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS `mydb`.`textPart` (
74  `id` INT NOT NULL,
75  `name` VARCHAR(20) NULL,
76  `body` LONGTEXT NULL,
77  `textProject_id` INT NOT NULL,
78  `textProject_languageTo` INT NOT NULL,
79  `textProject_languageFrom` INT NOT NULL,
80  `user_id` INT UNSIGNED NOT NULL,
81  PRIMARY KEY (`id`, `textProject_id`, `textProject_languageTo`, `textProject_languageFrom`, `user_id`),
82  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
83  INDEX `fk_textPart_textProject1_idx` (`textProject_id` ASC, `textProject_languageTo` ASC, `textProject_languageFrom` ASC),
84  INDEX `fk_textPart_user1_idx` (`user_id` ASC),
85  CONSTRAINT `fk_textPart_textProject1`
86    FOREIGN KEY (`textProject_id` , `textProject_languageTo` , `textProject_languageFrom`)
87    REFERENCES `mydb`.`textProject` (`id` , `languageTo` , `languageFrom`)
88    ON DELETE NO ACTION
89    ON UPDATE NO ACTION,
90  CONSTRAINT `fk_textPart_user1`
91    FOREIGN KEY (`user_id`)
92    REFERENCES `mydb`.`user` (`id`)
93    ON DELETE NO ACTION
94    ON UPDATE NO ACTION)
95ENGINE = InnoDB;
96
97
98SET SQL_MODE=@OLD_SQL_MODE;
99SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
100SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;