aCeJGt5C

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`.`Tester`
39-- -----------------------------------------------------
40CREATE TABLE IF NOT EXISTS `IssueDB`.`Tester` (
41  `Name` VARCHAR(45) NOT NULL,
42  PRIMARY KEY (`Name`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `IssueDB`.`Developer`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `IssueDB`.`Developer` (
50  `Name` VARCHAR(45) NOT NULL,
51  PRIMARY KEY (`Name`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `IssueDB`.`Issue`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `IssueDB`.`Issue` (
59  `Comment` TEXT(1024) NOT NULL,
60  `Priority` INT NOT NULL,
61  `Status` VARCHAR(6) NOT NULL,
62  `ID` INT NOT NULL AUTO_INCREMENT,
63  `AssignedTo` VARCHAR(45) NULL,
64  `OpenedBy` VARCHAR(45) NULL,
65  PRIMARY KEY (`ID`, `Priority`, `Status`),
66  INDEX `fk_verzinzelf1_idx` (`Priority` ASC),
67  INDEX `fk_verzinzelf2_idx` (`Status` ASC),
68  INDEX `Name_idx` (`OpenedBy` ASC),
69  INDEX `Name_idx1` (`AssignedTo` ASC),
70  CONSTRAINT `fk_verzinzelf1`
71    FOREIGN KEY (`Priority`)
72    REFERENCES `IssueDB`.`Priority` (`Priority`)
73    ON DELETE NO ACTION
74    ON UPDATE NO ACTION,
75  CONSTRAINT `fk_verzinzelf2`
76    FOREIGN KEY (`Status`)
77    REFERENCES `IssueDB`.`Status` (`Status`)
78    ON DELETE NO ACTION
79    ON UPDATE NO ACTION,
80  CONSTRAINT `Name`
81    FOREIGN KEY (`OpenedBy`)
82    REFERENCES `IssueDB`.`Tester` (`Name`)
83    ON DELETE NO ACTION
84    ON UPDATE NO ACTION,
85  CONSTRAINT `Name`
86    FOREIGN KEY (`AssignedTo`)
87    REFERENCES `IssueDB`.`Developer` (`Name`)
88    ON DELETE NO ACTION
89    ON UPDATE NO ACTION)
90ENGINE = InnoDB;
91
92
93SET SQL_MODE=@OLD_SQL_MODE;
94SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
95SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;