h0GWE9GW

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `Movies` DEFAULT CHARACTER SET latin1 ;
6USE `Movies` ;
7
8-- -----------------------------------------------------
9-- Table `Movies`.`Movies`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `Movies`.`Movies` (
12  `ID` INT(11) NOT NULL AUTO_INCREMENT ,
13  `IMDB-ID` INT(11) NOT NULL ,
14  `Name` VARCHAR(60) NOT NULL ,
15  `Poster_Path` TINYTEXT NOT NULL ,
16  `Release_Date` DATE NOT NULL ,
17  `Rate` FLOAT NULL ,
18  `Director` VARCHAR(45) NULL ,
19  `Overview` TEXT NULL DEFAULT NULL ,
20  PRIMARY KEY (`ID`, `IMDB-ID`) ,
21  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) )
22ENGINE = InnoDB
23DEFAULT CHARACTER SET = latin1;
24
25
26-- -----------------------------------------------------
27-- Table `Movies`.`Cast`
28-- -----------------------------------------------------
29CREATE  TABLE IF NOT EXISTS `Movies`.`Cast` (
30  `idCast` INT(11) NOT NULL AUTO_INCREMENT ,
31  `MovieID` INT(11) NOT NULL ,
32  `Name` VARCHAR(45) NULL ,
33  PRIMARY KEY (`idCast`, `MovieID`) ,
34  INDEX `fk_cast` (`MovieID` ASC) ,
35  CONSTRAINT `fk_cast`
36    FOREIGN KEY (`MovieID` )
37    REFERENCES `Movies`.`Movies` (`IMDB-ID` )
38    ON DELETE CASCADE
39    ON UPDATE CASCADE)
40ENGINE = InnoDB
41DEFAULT CHARACTER SET = latin1
42COMMENT = 'Cast names';
43
44
45
46SET SQL_MODE=@OLD_SQL_MODE;
47SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
48SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;