M9U8txY8

1CREATE DATABASE IF NOT EXISTS `recipe`;
2
3USE recipe;
4
5CREATE TABLE IF NOT EXISTS `category` (
6	`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
7	`title` VARCHAR(25) NOT NULL,
8	`parent_id` INT
9	);
10
11CREATE TABLE IF NOT EXISTS `ingredient` (
12	`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
13	`title` VARCHAR(25) NOT NULL
14	);
15
16CREATE TABLE IF NOT EXISTS `recipe` (
17	`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
18	`title` VARCHAR(100) NOT NULL,
19	`author` VARCHAR(25),
20	`method` BLOB NOT NULL,
21	`vegetarian` TINYINT(1) NULL
22	);
23
24CREATE TABLE IF NOT EXISTS `recipe_ingredients` (
25	`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
26	`recipe_id` INT NOT NULL,
27	`ingredient_amount` VARCHAR(5) NOT NULL,
28	`ingredient_id` INT NOT NULL
29	);