SQGWGFti

1-- MySQL Script generated by MySQL Workbench
2-- 12/02/16 11:39:43
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 Brett's Movies
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema Brett's Movies
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `Brett's Movies` DEFAULT CHARACTER SET utf8 ;
18USE `Brett's Movies` ;
19
20
21
22-- -----------------------------------------------------
23-- Table `Brett's Movies`.`Directors`
24-- -----------------------------------------------------
25CREATE TABLE IF NOT EXISTS `Brett's Movies`.`Directors` (
26  `Directors_id` INT NOT NULL AUTO_INCREMENT,
27  `Director_Lastname` VARCHAR(45) NULL,
28  `Director_Firstname` VARCHAR(45) NULL,
29  PRIMARY KEY (`Directors_id`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `Brett's Movies`.`Movies_Actors_Starred_In`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `Brett's Movies`.`Movies_Actors_Starred_In` (
37  `Actor_id` INT NOT NULL,
38  `Movies_id` INT NOT NULL,
39  INDEX `Actor_id_idx` (`Actor_id` ASC),
40  INDEX `Movies_id_idx` (`Movies_id` ASC),
41  CONSTRAINT `Actor_id`
42    FOREIGN KEY (`Actor_id`)
43    REFERENCES `Brett's Movies`.`Actors` (`Actor_id`)
44    ON DELETE NO ACTION
45    ON UPDATE NO ACTION,
46  CONSTRAINT `Movies_id`
47    FOREIGN KEY (`Movies_id`)
48    REFERENCES `Brett's Movies`.`Movies` (`Movies_id`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION)
51ENGINE = InnoDB;
52
53
54SET SQL_MODE=@OLD_SQL_MODE;
55SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
56SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;