diff options
author | cos <cos> | 2015-04-06 21:57:17 +0200 |
---|---|---|
committer | cos <cos> | 2015-04-06 21:57:17 +0200 |
commit | 2390635012871d02e21d3c6c3b39860159ef862f (patch) | |
tree | 7a05c00d38a18b4de08b911e9df6eb5a4be3705b /README | |
parent | 3aebdbef6738993be68da3e86b8bea58f40e2c28 (diff) | |
download | mat-2390635012871d02e21d3c6c3b39860159ef862f.zip |
Update TODO & README.
Diffstat (limited to 'README')
-rw-r--r-- | README | 7 |
1 files changed, 6 insertions, 1 deletions
@@ -10,8 +10,13 @@ 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, preparation_date DATETIME, amount INTEGER, storage); +CREATE TABLE inventory (id INTEGER PRIMARY KEY AUTOINCREMENT, recipe_id INTEGER, amount INTEGER, storage, preparation_date DATETIME, energy INTEGER); CREATE TABLE queue (id INTEGER PRIMARY KEY, recipe_id INTEGER, servings INTEGER); +CREATE TABLE mealtypes (id INTEGER PRIMARY KEY AUTOINCREMENT, mealtype); +CREATE TABLE typemap (recipe_id INTEGER, mealtype_id INTEGER); +CREATE TABLE stock (product_id TEXT, quantity FLOAT, unit TEXT, up_to_date DATETIME); +CREATE TABLE products (id TEXT PRIMARY KEY, ingredient_id INTEGER, description TEXT); +CREATE TABLE cookings (recipe_id INTEGER, date DATETIME, specific_energy INTEGER); 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". |