QgR9nPvT

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='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema IssueDB
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema IssueDB
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `IssueDB` DEFAULT CHARACTER SET utf8 ;
15USE `IssueDB` ;
16
17-- -----------------------------------------------------
18-- Table `IssueDB`.`Priority`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `IssueDB`.`Priority` (
21  `Priority` INT NOT NULL,
22  `Description` VARCHAR(45) NULL,
23  PRIMARY KEY (`Priority`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `IssueDB`.`Status`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `IssueDB`.`Status` (
31  `Status` VARCHAR(6) NOT NULL,
32  `Description` VARCHAR(45) NULL,
33  PRIMARY KEY (`Status`))
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `IssueDB`.`User`
39-- -----------------------------------------------------
40CREATE TABLE IF NOT EXISTS `IssueDB`.`User` (
41  `Name` VARCHAR(45) NOT NULL,
42  PRIMARY KEY (`Name`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `IssueDB`.`Issue`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `IssueDB`.`Issue` (
50  `Comment` TEXT(1024) NOT NULL,
51  `Priority` INT NOT NULL,
52  `Status` VARCHAR(6) NOT NULL,
53  `ID` INT NOT NULL AUTO_INCREMENT,
54  `OpenedBy` VARCHAR(45) NOT NULL,
55  `AssignedTo` VARCHAR(45) NOT NULL,
56  PRIMARY KEY (`ID`, `Priority`, `Status`),
57  INDEX `fk_verzinzelf1_idx` (`Priority` ASC),
58  INDEX `fk_verzinzelf2_idx` (`Status` ASC),
59  INDEX `fk_verzinzelf3_idx` (`OpenedBy` ASC),
60  INDEX `fk_verzinzelf4_idx` (`AssignedTo` ASC),
61  CONSTRAINT `fk_verzinzelf1`
62    FOREIGN KEY (`Priority`)
63    REFERENCES `IssueDB`.`Priority` (`Priority`)
64    ON DELETE NO ACTION
65    ON UPDATE NO ACTION,
66  CONSTRAINT `fk_verzinzelf2`
67    FOREIGN KEY (`Status`)
68    REFERENCES `IssueDB`.`Status` (`Status`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION,
71  CONSTRAINT `fk_verzinzelf3`
72    FOREIGN KEY (`OpenedBy`)
73    REFERENCES `IssueDB`.`User` (`Name`)
74    ON DELETE NO ACTION
75    ON UPDATE NO ACTION,
76  CONSTRAINT `fk_verzinzelf4`
77    FOREIGN KEY (`AssignedTo`)
78    REFERENCES `IssueDB`.`User` (`Name`)
79    ON DELETE NO ACTION
80    ON UPDATE NO ACTION)
81ENGINE = InnoDB;
82
83
84SET SQL_MODE=@OLD_SQL_MODE;
85SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
86SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;