W7r6HKDy

1-- MySQL Script generated by MySQL Workbench
2-- Mon Nov  4 14:29:58 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='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `mydb` ;
14
15-- -----------------------------------------------------
16-- Schema mydb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
19USE `mydb` ;
20
21-- -----------------------------------------------------
22-- Table `mydb`.`Speaker`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `mydb`.`Speaker` ;
25
26CREATE TABLE IF NOT EXISTS `mydb`.`Speaker` (
27  `idSpeaker` INT UNSIGNED NOT NULL AUTO_INCREMENT,
28  `speakerFirstName` VARCHAR(45) NOT NULL,
29  `speakerEmail` VARCHAR(45) NOT NULL,
30  `speakerLastName` VARCHAR(45) NOT NULL,
31  PRIMARY KEY (`idSpeaker`),
32  UNIQUE INDEX `speakerEmail_UNIQUE` (`speakerEmail` ASC))
33ENGINE = InnoDB;
34
35
36-- -----------------------------------------------------
37-- Table `mydb`.`Room`
38-- -----------------------------------------------------
39DROP TABLE IF EXISTS `mydb`.`Room` ;
40
41CREATE TABLE IF NOT EXISTS `mydb`.`Room` (
42  `idRoom` INT UNSIGNED NOT NULL AUTO_INCREMENT,
43  `roomName` VARCHAR(45) NOT NULL,
44  `roomCapacity` INT NOT NULL,
45  PRIMARY KEY (`idRoom`),
46  UNIQUE INDEX `roomName_UNIQUE` (`roomName` ASC))
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `mydb`.`TimeSlot`
52-- -----------------------------------------------------
53DROP TABLE IF EXISTS `mydb`.`TimeSlot` ;
54
55CREATE TABLE IF NOT EXISTS `mydb`.`TimeSlot` (
56  `idTimeSlot` INT UNSIGNED NOT NULL AUTO_INCREMENT,
57  `endTime` DATETIME NULL,
58  `startTime` DATETIME NULL,
59  PRIMARY KEY (`idTimeSlot`),
60  UNIQUE INDEX `idTimeSlot_UNIQUE` (`idTimeSlot` ASC))
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `mydb`.`Presentation`
66-- -----------------------------------------------------
67DROP TABLE IF EXISTS `mydb`.`Presentation` ;
68
69CREATE TABLE IF NOT EXISTS `mydb`.`Presentation` (
70  `idSpeech` INT UNSIGNED NOT NULL AUTO_INCREMENT,
71  `presentationSpeaker` INT UNSIGNED NULL,
72  `presentationRoom` INT UNSIGNED NULL,
73  `presentationTimeSlot` INT UNSIGNED NULL,
74  `topic` VARCHAR(45) NULL,
75  PRIMARY KEY (`idSpeech`),
76  UNIQUE INDEX `idSpeech_UNIQUE` (`idSpeech` ASC),
77  INDEX `speaker_idx` (`presentationSpeaker` ASC),
78  INDEX `room_idx` (`presentationRoom` ASC),
79  INDEX `timeslot_idx` (`presentationTimeSlot` ASC),
80  CONSTRAINT `speaker`
81    FOREIGN KEY (`presentationSpeaker`)
82    REFERENCES `mydb`.`Speaker` (`idSpeaker`)
83    ON DELETE NO ACTION
84    ON UPDATE NO ACTION,
85  CONSTRAINT `room`
86    FOREIGN KEY (`presentationRoom`)
87    REFERENCES `mydb`.`Room` (`idRoom`)
88    ON DELETE NO ACTION
89    ON UPDATE NO ACTION,
90  CONSTRAINT `timeslot`
91    FOREIGN KEY (`presentationTimeSlot`)
92    REFERENCES `mydb`.`TimeSlot` (`idTimeSlot`)
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;