5RARwaPq

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Kategorie`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Kategorie` (
21  `id_kategorie` INT NOT NULL AUTO_INCREMENT,
22  `nazev` VARCHAR(45) NOT NULL,
23  PRIMARY KEY (`id_kategorie`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `mydb`.`Dodavatel`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `mydb`.`Dodavatel` (
31  `id_dodavatel` INT NOT NULL AUTO_INCREMENT,
32  `nazev` VARCHAR(45) NOT NULL,
33  `email` VARCHAR(45) NOT NULL,
34  `telefon` VARCHAR(14) NOT NULL,
35  PRIMARY KEY (`id_dodavatel`))
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `mydb`.`Produkt`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `mydb`.`Produkt` (
43  `id_produkt` INT NOT NULL AUTO_INCREMENT,
44  `nazev` VARCHAR(45) NOT NULL,
45  `cena` INT NOT NULL,
46  `id_kategorie` INT NOT NULL,
47  `id_dodavatel` INT NOT NULL,
48  PRIMARY KEY (`id_produkt`),
49  INDEX `fk_Produkt_Kategorie1_idx` (`id_kategorie` ASC),
50  INDEX `fk_Produkt_Dodavatel1_idx` (`id_dodavatel` ASC),
51  CONSTRAINT `fk_Produkt_Kategorie1`
52    FOREIGN KEY (`id_kategorie`)
53    REFERENCES `mydb`.`Kategorie` (`id_kategorie`)
54    ON DELETE NO ACTION
55    ON UPDATE NO ACTION,
56  CONSTRAINT `fk_Produkt_Dodavatel1`
57    FOREIGN KEY (`id_dodavatel`)
58    REFERENCES `mydb`.`Dodavatel` (`id_dodavatel`)
59    ON DELETE NO ACTION
60    ON UPDATE NO ACTION)
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `mydb`.`Zakaznik`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `mydb`.`Zakaznik` (
68  `id_zakaznik` INT NOT NULL AUTO_INCREMENT,
69  `jmeno` VARCHAR(45) NOT NULL,
70  `prijmeni` VARCHAR(45) NOT NULL,
71  `firma` VARCHAR(45) NULL,
72  `ico` INT NULL,
73  `ulice` VARCHAR(45) NOT NULL,
74  `mesto` VARCHAR(45) NOT NULL,
75  `psc` VARCHAR(10) NOT NULL,
76  `stat` VARCHAR(45) NOT NULL,
77  PRIMARY KEY (`id_zakaznik`))
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `mydb`.`Zasilkova_sluzba`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `mydb`.`Zasilkova_sluzba` (
85  `id_zasilkova_sluzba` INT NOT NULL AUTO_INCREMENT,
86  `nazev` VARCHAR(45) NOT NULL,
87  `email` VARCHAR(45) NOT NULL,
88  `telefon` VARCHAR(14) NOT NULL,
89  PRIMARY KEY (`id_zasilkova_sluzba`))
90ENGINE = InnoDB;
91
92
93-- -----------------------------------------------------
94-- Table `mydb`.`Objednavka`
95-- -----------------------------------------------------
96CREATE TABLE IF NOT EXISTS `mydb`.`Objednavka` (
97  `id_objednavka` INT NOT NULL AUTO_INCREMENT,
98  `id_zakaznik` INT NOT NULL,
99  `id_zasilkova_sluzba` INT NOT NULL,
100  PRIMARY KEY (`id_objednavka`),
101  INDEX `fk_Objednavka_Zakaznik1_idx` (`id_zakaznik` ASC),
102  INDEX `fk_Objednavka_Zasilkova_sluzba1_idx` (`id_zasilkova_sluzba` ASC),
103  CONSTRAINT `fk_Objednavka_Zakaznik1`
104    FOREIGN KEY (`id_zakaznik`)
105    REFERENCES `mydb`.`Zakaznik` (`id_zakaznik`)
106    ON DELETE NO ACTION
107    ON UPDATE NO ACTION,
108  CONSTRAINT `fk_Objednavka_Zasilkova_sluzba1`
109    FOREIGN KEY (`id_zasilkova_sluzba`)
110    REFERENCES `mydb`.`Zasilkova_sluzba` (`id_zasilkova_sluzba`)
111    ON DELETE NO ACTION
112    ON UPDATE NO ACTION)
113ENGINE = InnoDB;
114
115
116-- -----------------------------------------------------
117-- Table `mydb`.`Polozka_objednavky`
118-- -----------------------------------------------------
119CREATE TABLE IF NOT EXISTS `mydb`.`Polozka_objednavky` (
120  `id_produkt` INT NOT NULL,
121  `id_objednavka` INT NOT NULL,
122  `pocet` INT NOT NULL,
123  PRIMARY KEY (`id_produkt`, `id_objednavka`),
124  INDEX `fk_Produkt_has_Objednavka_Objednavka1_idx` (`id_objednavka` ASC),
125  CONSTRAINT `fk_Produkt_has_Objednavka_Produkt1`
126    FOREIGN KEY (`id_produkt` , `id_objednavka`)
127    REFERENCES `mydb`.`Produkt` (`id_produkt` , `id_produkt`)
128    ON DELETE NO ACTION
129    ON UPDATE NO ACTION,
130  CONSTRAINT `fk_Produkt_has_Objednavka_Objednavka1`
131    FOREIGN KEY (`id_objednavka`)
132    REFERENCES `mydb`.`Objednavka` (`id_objednavka`)
133    ON DELETE NO ACTION
134    ON UPDATE NO ACTION)
135ENGINE = InnoDB;
136
137
138SET SQL_MODE=@OLD_SQL_MODE;
139SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
140SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;