byb0gF1T

1
2CREATE TABLE IF NOT EXISTS users (
3id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
4username varchar(50),
5password varchar(255),
6created datetime DEFAULT NULL,
7modified datetime DEFAULT NULL
8);
9CREATE TABLE recipes (
10id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
11name VARCHAR(50),
12description TEXT,
13creator_id INT UNSIGNED NOT NULL,
14created datetime DEFAULT NULL,
15modified datetime DEFAULT NULL,
16FOREIGN KEY (creator_id) REFERENCES users(id)
17);
18CREATE TABLE ingredients (
19id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
20name VARCHAR(50),
21recipe_id INT UNSIGNED NOT NULL,
22created datetime DEFAULT NULL,
23modified datetime DEFAULT NULL,
24FOREIGN KEY (recipe_id) REFERENCES recipes(id)
25);