Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/sample/schema2.sql
blob: 17bb3c7c890e971b9237ddd7b6e3b4b1bd1ef4b2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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
);