f298v80U

1ALTER TABLE `e-shop`.`objednavka_na_zbozi` 
2ADD COLUMN `zbozi_sklad_ID_zbozi_sklad` INT(10) UNSIGNED NOT NULL AFTER `pocet`,
3ADD INDEX `fk_objednavka_na_zbozi_zbozi_sklad1_idx` (`zbozi_sklad_ID_zbozi_sklad` ASC) VISIBLE;
4;
5
6ALTER TABLE `e-shop`.`zakaznik` 
7ADD COLUMN `dopravce_ID_dopravce` INT(10) UNSIGNED NOT NULL AFTER `ID_mesta`,
8ADD INDEX `fk_zakaznik_dopravce1_idx` (`dopravce_ID_dopravce` ASC) VISIBLE;
9;
10
11CREATE TABLE IF NOT EXISTS `e-shop`.`objednavka` (
12  `objednavka_na_zbozi_ID_Objednavka_na_zbozi` INT(10) UNSIGNED NOT NULL,
13  `zakaznik_ID_zakaznik` INT(10) UNSIGNED NOT NULL,
14  INDEX `fk_objednavka_objednavka_na_zbozi1_idx` (`objednavka_na_zbozi_ID_Objednavka_na_zbozi` ASC) VISIBLE, ???
15  INDEX `fk_objednavka_zakaznik1_idx` (`zakaznik_ID_zakaznik` ASC) VISIBLE,  ???
16  CONSTRAINT `fk_objednavka_objednavka_na_zbozi1`
17    FOREIGN KEY (`objednavka_na_zbozi_ID_Objednavka_na_zbozi`)
18    REFERENCES `e-shop`.`objednavka_na_zbozi` (`ID_Objednavka_na_zbozi`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION,
21  CONSTRAINT `fk_objednavka_zakaznik1`
22    FOREIGN KEY (`zakaznik_ID_zakaznik`)
23    REFERENCES `e-shop`.`zakaznik` (`ID_zakaznik`)
24    ON DELETE NO ACTION
25    ON UPDATE NO ACTION)
26ENGINE = InnoDB
27DEFAULT CHARACTER SET = cp1250
28COLLATE = cp1250_czech_cs;
29
30ALTER TABLE `e-shop`.`objednavka_na_zbozi` 
31ADD CONSTRAINT `fk_objednavka_na_zbozi_zbozi_sklad1`
32  FOREIGN KEY (`zbozi_sklad_ID_zbozi_sklad`)
33  REFERENCES `e-shop`.`zbozi_sklad` (`ID_zbozi_sklad`)
34  ON DELETE NO ACTION
35  ON UPDATE NO ACTION;
36
37ALTER TABLE `e-shop`.`zakaznik` 
38ADD CONSTRAINT `fk_zakaznik_dopravce1`
39  FOREIGN KEY (`dopravce_ID_dopravce`)
40  REFERENCES `e-shop`.`dopravce` (`ID_dopravce`)
41  ON DELETE NO ACTION
42  ON UPDATE NO ACTION;