· 7 years ago · Sep 25, 2018, 07:08 AM
1-- MySQL Script generated by MySQL Workbench
2-- 09/25/18 09:03:26
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`.`ucitel`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`ucitel` (
24 `iducitel` INT NOT NULL AUTO_INCREMENT,
25 `jmeno` VARCHAR(45) NOT NULL,
26 `prijmeni` VARCHAR(45) NOT NULL,
27 `zkratka` VARCHAR(45) NOT NULL,
28 PRIMARY KEY (`iducitel`),
29 UNIQUE INDEX `iducitel_UNIQUE` (`iducitel` ASC))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`trida`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`trida` (
37 `idtrida` INT NOT NULL AUTO_INCREMENT,
38 `nazev` VARCHAR(45) NOT NULL,
39 `tridniUcitel` INT NOT NULL,
40 PRIMARY KEY (`idtrida`),
41 UNIQUE INDEX `idtrida_UNIQUE` (`idtrida` ASC),
42 UNIQUE INDEX `nazev_UNIQUE` (`nazev` ASC),
43 INDEX `fk_trida_ucitel1_idx` (`tridniUcitel` ASC),
44 CONSTRAINT `fk_trida_ucitel1`
45 FOREIGN KEY (`tridniUcitel`)
46 REFERENCES `mydb`.`ucitel` (`iducitel`)
47 ON DELETE NO ACTION
48 ON UPDATE NO ACTION)
49ENGINE = InnoDB;
50
51
52-- -----------------------------------------------------
53-- Table `mydb`.`zak`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `mydb`.`zak` (
56 `idzak` INT NOT NULL AUTO_INCREMENT,
57 `jmeno` VARCHAR(45) NOT NULL,
58 `prijmeni` VARCHAR(45) NOT NULL,
59 `trida_idtrida` INT NOT NULL,
60 PRIMARY KEY (`idzak`),
61 UNIQUE INDEX `idzak_UNIQUE` (`idzak` ASC),
62 INDEX `fk_zak_trida_idx` (`trida_idtrida` ASC),
63 CONSTRAINT `fk_zak_trida`
64 FOREIGN KEY (`trida_idtrida`)
65 REFERENCES `mydb`.`trida` (`idtrida`)
66 ON DELETE NO ACTION
67 ON UPDATE NO ACTION)
68ENGINE = InnoDB;
69
70
71-- -----------------------------------------------------
72-- Table `mydb`.`predmet`
73-- -----------------------------------------------------
74CREATE TABLE IF NOT EXISTS `mydb`.`predmet` (
75 `idpredmet` INT NOT NULL AUTO_INCREMENT,
76 `nazev` VARCHAR(45) NOT NULL,
77 `zkratka` VARCHAR(45) NOT NULL,
78 PRIMARY KEY (`idpredmet`),
79 UNIQUE INDEX `idpredmet_UNIQUE` (`idpredmet` ASC),
80 UNIQUE INDEX `nazev_UNIQUE` (`nazev` ASC),
81 UNIQUE INDEX `zkratka_UNIQUE` (`zkratka` ASC))
82ENGINE = InnoDB;
83
84
85-- -----------------------------------------------------
86-- Table `mydb`.`predmet_has_ucitel`
87-- -----------------------------------------------------
88CREATE TABLE IF NOT EXISTS `mydb`.`predmet_has_ucitel` (
89 `predmet_idpredmet` INT NOT NULL,
90 `ucitel_iducitel` INT NOT NULL,
91 `trida_idtrida` INT NOT NULL,
92 PRIMARY KEY (`predmet_idpredmet`, `ucitel_iducitel`, `trida_idtrida`),
93 INDEX `fk_predmet_has_ucitel_ucitel1_idx` (`ucitel_iducitel` ASC),
94 INDEX `fk_predmet_has_ucitel_predmet1_idx` (`predmet_idpredmet` ASC),
95 INDEX `fk_predmet_has_ucitel_trida1_idx` (`trida_idtrida` ASC),
96 CONSTRAINT `fk_predmet_has_ucitel_predmet1`
97 FOREIGN KEY (`predmet_idpredmet`)
98 REFERENCES `mydb`.`predmet` (`idpredmet`)
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION,
101 CONSTRAINT `fk_predmet_has_ucitel_ucitel1`
102 FOREIGN KEY (`ucitel_iducitel`)
103 REFERENCES `mydb`.`ucitel` (`iducitel`)
104 ON DELETE NO ACTION
105 ON UPDATE NO ACTION,
106 CONSTRAINT `fk_predmet_has_ucitel_trida1`
107 FOREIGN KEY (`trida_idtrida`)
108 REFERENCES `mydb`.`trida` (`idtrida`)
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION)
111ENGINE = InnoDB;
112
113
114SET SQL_MODE=@OLD_SQL_MODE;
115SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
116SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;