diff options
author | cos <cos> | 2014-01-18 14:59:28 +0100 |
---|---|---|
committer | cos <cos> | 2014-01-18 14:59:28 +0100 |
commit | 9a9ccd11e0fe68232cc605f9bfdd883f4c0afe4f (patch) | |
tree | 24cea60d497fa07b656e232679aae4c9a73dbfb0 /README | |
parent | 3e7f9000c6868549b1b9cf8d447aa30bb54624f8 (diff) | |
download | mat-9a9ccd11e0fe68232cc605f9bfdd883f4c0afe4f.zip |
Store preparation dates in inventory table.
Diffstat (limited to 'README')
-rw-r--r-- | README | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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". |