uW10R8RB

1-- MySQL Script generated by MySQL Workbench
2-- Wed Apr 11 18:04:59 2018
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-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Film`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Film` (
24  `idFilm` INT NOT NULL,
25  `Tytuł` VARCHAR(45) NULL,
26  `Gatunek` VARCHAR(45) NULL,
27  `Reżyser` VARCHAR(45) NULL,
28  `Czas trwania` INT NULL,
29  `Rok produkcji` INT NULL,
30  `Opis` VARCHAR(500) NULL,
31  PRIMARY KEY (`idFilm`))
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `mydb`.`Sala_kinowa`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `mydb`.`Sala_kinowa` (
39  `idSala_kinowa` INT NOT NULL,
40  `Nazwa` VARCHAR(45) NULL,
41  `Ilość_miejsc` INT NULL,
42  PRIMARY KEY (`idSala_kinowa`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `mydb`.`Seans`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`Seans` (
50  `idSeans` INT NOT NULL,
51  `Data` DATETIME NULL,
52  `Godzina` DATETIME NULL,
53  `Film_idFilm` INT NOT NULL,
54  `Sala_kinowa_idSala_kinowa` INT NOT NULL,
55  PRIMARY KEY (`idSeans`),
56  INDEX `fk_Seans_Film_idx` (`Film_idFilm` ASC),
57  INDEX `fk_Seans_Sala_kinowa1_idx` (`Sala_kinowa_idSala_kinowa` ASC),
58  CONSTRAINT `fk_Seans_Film`
59    FOREIGN KEY (`Film_idFilm`)
60    REFERENCES `mydb`.`Film` (`idFilm`)
61    ON DELETE NO ACTION
62    ON UPDATE NO ACTION,
63  CONSTRAINT `fk_Seans_Sala_kinowa1`
64    FOREIGN KEY (`Sala_kinowa_idSala_kinowa`)
65    REFERENCES `mydb`.`Sala_kinowa` (`idSala_kinowa`)
66    ON DELETE NO ACTION
67    ON UPDATE NO ACTION)
68ENGINE = InnoDB;
69
70
71-- -----------------------------------------------------
72-- Table `mydb`.`Rezerwacja`
73-- -----------------------------------------------------
74CREATE TABLE IF NOT EXISTS `mydb`.`Rezerwacja` (
75  `idRezerwacja` INT NOT NULL,
76  `E-mail` VARCHAR(45) NULL,
77  `Cena` FLOAT NULL,
78  `Liczba_biletów` INT NULL,
79  `Rezerwacjacol` VARCHAR(45) NULL,
80  `Seans_idSeans` INT NOT NULL,
81  PRIMARY KEY (`idRezerwacja`),
82  INDEX `fk_Rezerwacja_Seans1_idx` (`Seans_idSeans` ASC),
83  CONSTRAINT `fk_Rezerwacja_Seans1`
84    FOREIGN KEY (`Seans_idSeans`)
85    REFERENCES `mydb`.`Seans` (`idSeans`)
86    ON DELETE NO ACTION
87    ON UPDATE NO ACTION)
88ENGINE = InnoDB;
89
90
91SET SQL_MODE=@OLD_SQL_MODE;
92SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
93SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;