1 files changed, 14 insertions, 0 deletions
diff --git a/model/sql/migrate.sql b/model/sql/migrate.sql
new file mode 100644
index 0000000..6ca4d0f
--- /dev/null
+++ b/model/sql/migrate.sql
@@ -0,0 +1,14 @@
+CREATE TABLE 'recipes' (
+	'id' integer PRIMARY KEY AUTOINCREMENT,
+	'title' text DEFAULT '',
+	'portions' text DEFAULT '',  -- FIXME has to be integer
+	'url' text DEFAULT '',
+	'notes' text DEFAULT ''
+);
+
+CREATE TABLE 'recipe_steps' (
+	'id' integer PRIMARY KEY,
+	'recipe_id' integer DEFAULT NULL,
+	'rank' integer DEFAULT NULL,
+	'text' text DEFAULT ''
+);