diff options
author | cos <cos> | 2015-04-20 21:47:59 +0200 |
---|---|---|
committer | cos <cos> | 2015-04-20 21:47:59 +0200 |
commit | 52cb72ed01bb5c8cc3b8255f289de081268efdfe (patch) | |
tree | 9e1a37a6c206411b4f1c2bca1b2bcfc21138970f /README | |
parent | 2390635012871d02e21d3c6c3b39860159ef862f (diff) | |
download | mat-52cb72ed01bb5c8cc3b8255f289de081268efdfe.zip |
Initial unit conversion support.
Diffstat (limited to 'README')
-rw-r--r-- | README | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -6,7 +6,7 @@ If for some obscure reason, you would like to use this hackish beast, the first thing you need to do is create a sqlite database with the following schema: CREATE TABLE recipes (id INTEGER PRIMARY KEY AUTOINCREMENT, name, uri, servings INTEGER); -CREATE TABLE ingredients (id INTEGER PRIMARY KEY AUTOINCREMENT, name, shop_position INTEGER); +CREATE TABLE ingredients (id INTEGER PRIMARY KEY AUTOINCREMENT, name, shop_position INTEGER, primary_unit, density, piece_weight); 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); |