dUN97EC5

1DROP DATABASE IF EXISTS recipeDb;
2CREATE DATABASE recipeDb;
3
4USE recipeDb;
5
6DROP TABLE IF EXISTS recipe;
7CREATE TABLE recipe (
8id int NOT NULL,
9recipeTitle varchar(30),
10description varchar(255),
11cookTime int,
12ingredientID int,
13stepID int,
14
15PRIMARY KEY(id)
16);
17
18ALTER TABLE recipe
19ADD FOREIGN KEY (ingredientID) REFERENCES ingredient(id);
20ADD FOREIGN KEY (stepID) REFERENCES step(id);
21
22DROP TABLE IF EXISTS category;
23CREATE TABLE category (
24id int NOT NULL,
25categoryTitle varchar(20),
26
27PRIMARY KEY(id)
28);
29
30DROP TABLE IF EXISTS recipe_category;
31CREATE TABLE recipe_category (
32recipeID int,
33categoryID int
34);
35
36DROP TABLE IF EXISTS step;
37CREATE TABLE step (
38id int NOT NULL,
39stepDesctiption varchar(255),
40
41PRIMARY KEY(id)
42);
43
44DROP TABLE IF EXISTS ingredient;
45CREATE TABLE ingredient (
46id int NOT NULL,
47ingredientName varchar(255),
48
49PRIMARY KEY(id)
50);