summaryrefslogtreecommitdiff
path: root/model/sql
diff options
context:
space:
mode:
Diffstat (limited to 'model/sql')
-rw-r--r--model/sql/migrate.sql29
1 files changed, 0 insertions, 29 deletions
diff --git a/model/sql/migrate.sql b/model/sql/migrate.sql
deleted file mode 100644
index 46f9fc6..0000000
--- a/model/sql/migrate.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-PRAGMA foreign_keys = ON;
-
-CREATE TABLE recipes (
- id INTEGER PRIMARY KEY,
- title TEXT NOT NULL,
- portions INTEGER NOT NULL,
- url TEXT NOT NULL,
- notes TEXT NOT NULL,
- created INTEGER NOT NULL, -- Unix time stamp
- last_changed INTEGER NOT NULL -- Unix time stamp
-);
-
-CREATE TABLE steps (
- id INTEGER PRIMARY KEY,
- 'index' INTEGER NOT NULL,
- text TEXT NOT NULL,
- 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)
-);