1 files changed, 10 insertions, 0 deletions
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)
+);