Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/sample/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sample/schema.sql')
-rw-r--r--sample/schema.sql29
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
+);