NtvWyAWg

1Executing SQL script in server
2ERROR: Error 1005: Can't create table `mydb`.`polozka_objednavky` (errno: 150 "Foreign key constraint is incorrectly formed")
3SQL Code:
4        -- -----------------------------------------------------
5        -- Table `mydb`.`Polozka_objednavky`
6        -- -----------------------------------------------------
7        CREATE TABLE IF NOT EXISTS `mydb`.`Polozka_objednavky` (
8          `id_produkt` INT NOT NULL,
9          `id_objednavka` INT NOT NULL,
10          `pocet` INT NOT NULL,
11          PRIMARY KEY (`id_produkt`, `id_objednavka`),
12          INDEX `fk_Produkt_has_Objednavka_Objednavka1_idx` (`id_objednavka` ASC),
13          CONSTRAINT `fk_Produkt_has_Objednavka_Produkt1`
14            FOREIGN KEY (`id_produkt` , `id_objednavka`)
15            REFERENCES `mydb`.`Produkt` (`id_produkt` , `id_produkt`)
16            ON DELETE NO ACTION
17            ON UPDATE NO ACTION,
18          CONSTRAINT `fk_Produkt_has_Objednavka_Objednavka1`
19            FOREIGN KEY (`id_objednavka`)
20            REFERENCES `mydb`.`Objednavka` (`id_objednavka`)
21            ON DELETE NO ACTION
22            ON UPDATE NO ACTION)
23        ENGINE = InnoDB
24
25SQL script execution finished: statements: 11 succeeded, 1 failed
26
27Fetching back view definitions in final form.
28Nothing to fetch