From 87ae71413e47ef34da57bc1e0b8dddbf84b0c66a Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
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

