nSaV6ZA8

1DROP TABLE IF EXISTS recipe_ingredient;
2DROP TABLE IF EXISTS ingredient;
3DROP TABLE IF EXISTS recipe;
4
5CREATE TABLE recipe (
6  recipe_id INT(255) PRIMARY KEY AUTO_INCREMENT,
7  name VARCHAR(255) NOT NULL,
8  description VARCHAR(2048)
9);
10
11CREATE TABLE ingredient (
12  ingredient_id INT(255) PRIMARY KEY AUTO_INCREMENT,
13  recipe_id INT (255),
14  name VARCHAR(255) NOT NULL,
15  FOREIGN KEY (recipe_id)
16  REFERENCES recipe(recipe_id)
17  ON UPDATE CASCADE ON DELETE CASCADE
18);
19
20INSERT INTO recipe (name, description)
21VALUES ("Kake med sitron", "Bake kake!!");
22
23INSERT INTO recipe (name, description)
24VALUES ("Kake med pølse", "Bake kake med pølse!!");
25
26INSERT INTO recipe (name, description)
27VALUES ("Kake med torst", "Bake kake med fisk!!");
28
29INSERT INTO ingredient (recipe_id, name)
30VALUES (1, "Mel");
31
32INSERT INTO ingredient (recipe_id, name)
33VALUES (2, "Mel");
34
35INSERT INTO ingredient (recipe_id, name)
36VALUES (3, "Mel");
37
38INSERT INTO ingredient (recipe_id, name)
39VALUES (2, "Pølse");
40
41INSERT INTO ingredient (recipe_id, name)
42VALUES (1, "Sitron");
43
44INSERT INTO ingredient (recipe_id, name)
45VALUES (1, "Sukker");
46
47INSERT INTO ingredient (recipe_id, name)
48VALUES (2, "Sukker");
49
50INSERT INTO ingredient (recipe_id, name)
51VALUES (3, "Sukker");
52
53INSERT INTO ingredient (recipe_id, name)
54VALUES (2, "Torsk");