summaryrefslogtreecommitdiff
path: root/README
diff options
context:
space:
mode:
authorcos <cos>2014-01-18 14:59:28 +0100
committercos <cos>2014-01-18 14:59:28 +0100
commit9a9ccd11e0fe68232cc605f9bfdd883f4c0afe4f (patch)
tree24cea60d497fa07b656e232679aae4c9a73dbfb0 /README
parent3e7f9000c6868549b1b9cf8d447aa30bb54624f8 (diff)
downloadmat-9a9ccd11e0fe68232cc605f9bfdd883f4c0afe4f.zip
Store preparation dates in inventory table.
Diffstat (limited to 'README')
-rw-r--r--README2
1 files changed, 1 insertions, 1 deletions
diff --git a/README b/README
index 6ec033e..d556444 100644
--- a/README
+++ b/README
@@ -10,7 +10,7 @@ CREATE TABLE ingredients (id INTEGER PRIMARY KEY AUTOINCREMENT, name, shop_posit
CREATE TABLE contents (recipe_id INTEGER, ingredient_id INTEGER, quantity FLOAT, unit);
CREATE TABLE plan (date DATETIME, mealtype, recipe_id INTEGER, state, comment_id);
CREATE TABLE comments (id INTEGER PRIMARY KEY AUTOINCREMENT, comment);
-CREATE TABLE inventory (id INTEGER PRIMARY KEY AUTOINCREMENT, recipe_id INTEGER, amount INTEGER, storage);
+CREATE TABLE inventory (id INTEGER PRIMARY KEY AUTOINCREMENT, recipe_id INTEGER, preparation_date DATETIME, amount INTEGER, storage);
All basic operations are performed using the perl script mat. It is possible to
get a crude list of commands available by running: "mat help".