diff options
Diffstat (limited to 'sample/schema.sql')
-rw-r--r-- | sample/schema.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sample/schema.sql b/sample/schema.sql new file mode 100644 index 0000000..fab8d9a --- /dev/null +++ b/sample/schema.sql @@ -0,0 +1,29 @@ +drop table if exists entries; +create table entries( + id integer primary key autoincrement, + title string not null, + water string not null, + energie string not null, + calcium string not null, + iron string not null, + magnesium string not null, + phosphorus string not null, + potassium string not null, + sodium string not null, + zinc string not null, + copper string not null, + vit_c string not null, + thiamin string not null, + riboflavin string not null, + niacin string not null, + panto_acid string not null, + vit_b6 string not null, + folate_tot string not null, + vit_b12 string not null, + vit_a string not null, + vit_e string not null, + vit_d string not null, + protein string not null, + path string, + scenario string +); |