· 6 years ago · Jun 27, 2019, 10:40 PM
1ERROR: Error 1022: Can't write; duplicate key in table 'recipes'
2SQL Code:
3 -- -----------------------------------------------------
4 -- Table `our_recipes`.`recipes`
5 -- -----------------------------------------------------
6 CREATE TABLE IF NOT EXISTS `our_recipes`.`recipes` (
7 `recipe_id` INT NOT NULL,
8 `chef_id` INT NOT NULL,
9 `recipe_name` CHAR(25) NULL,
10 `description` LONGTEXT NULL,
11 `min_prep` VARCHAR(25) NULL,
12 `total_time` INT NULL,
13 `servings_min` VARCHAR(25) NULL,
14 `servings_max` VARCHAR(45) NULL,
15 `directions` VARCHAR(45) NULL,
16 `website_id1` VARCHAR(25) NOT NULL,
17 PRIMARY KEY (`recipe_id`),
18 INDEX `chef_id_idx` (`chef_id` ASC),
19 INDEX `website_id_idx` (`website_id1` ASC),
20 UNIQUE INDEX `recipe_id_UNIQUE` (`recipe_id` ASC),
21 CONSTRAINT `chef_id`
22 FOREIGN KEY (`chef_id`)
23 REFERENCES `our_recipes`.`chef` (`chef_id`)
24 ON DELETE NO ACTION
25 ON UPDATE NO ACTION,
26 CONSTRAINT `website_id`
27 FOREIGN KEY (`website_id1`)
28 REFERENCES `our_recipes`.`website` (`website_id`)
29 ON DELETE NO ACTION
30 ON UPDATE NO ACTION)
31 ENGINE = InnoDB