add status.json

5 files changed, 60 insertions, 0 deletions

diff --git a/DATABASE3 b/DATABASE3
index 8d8c913..35207cb 100644
--- a/DATABASE3
+++ b/DATABASE3
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
+);
diff --git a/sample/schema2.sql b/sample/schema2.sql
new file mode 100644
index 0000000..17bb3c7
--- /dev/null
+++ b/sample/schema2.sql
@@ -0,0 +1,30 @@
+drop table if exists aliments;
+create table aliments(
+	id integer primary key autoincrement,
+	title string not null,
+	path string not null,
+	quantity string not null,
+	unit 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
+);
diff --git a/sample/status.json b/sample/status.json
new file mode 100644
index 0000000..f759aea
--- /dev/null
+++ b/sample/status.json
@@ -0,0 +1 @@
+{"vit_e": 0.0, "copper": 0.0, "vit_a": 0.0, "vit_c": 0.0, "vit_d": 0.0, "folate_tot": 0.0, "zinc": 0.0, "niacin": 0.0, "sodium": 0.0, "thiamin": 0.0, "vit_b6": 0.0, "vit_total": 0.0, "panto_acid": 0.0, "energie": 0.0, "potassium": 0.0, "vit_b12": 0.0, "construction": 0.0, "phosphorus": 0.0, "water": 16.59428571428571, "calcium": 0.0, "riboflavin": 0.0, "magnesium": 0.0, "iron": 0.0}
\ No newline at end of file
diff --git a/static/images/journal/bubblefruits.png b/static/images/journal/bubblefruits.png
index fba0bfe..e2fbd4c 100644
--- a/static/images/journal/bubblefruits.png
+++ b/static/images/journal/bubblefruits.png