1 files changed, 6 insertions, 1 deletions
diff --git a/README b/README
index 2edcd96..c86f394 100644
--- a/README
+++ b/README
@@ -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".