From 87ae71413e47ef34da57bc1e0b8dddbf84b0c66a Mon Sep 17 00:00:00 2001 From: xengineering Date: Thu, 4 Apr 2024 14:54:21 +0200 Subject: model: Add per-step ingredients --- model/sql/migrate.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'model/sql/migrate.sql') diff --git a/model/sql/migrate.sql b/model/sql/migrate.sql index f931af6..46f9fc6 100644 --- a/model/sql/migrate.sql +++ b/model/sql/migrate.sql @@ -17,3 +17,13 @@ CREATE TABLE steps ( recipe INTEGER NOT NULL, FOREIGN KEY(recipe) REFERENCES recipes(id) ); + +CREATE TABLE ingredients ( + id INTEGER PRIMARY KEY, + 'index' INTEGER NOT NULL, + amount REAL NOT NULL, + unit TEXT NOT NULL, + 'type' TEXT NOT NULL, + step INTEGER NOT NULL, + FOREIGN KEY(step) REFERENCES steps(id) +); -- cgit v1.2.3-70-g09d2