|
ferencd@0
|
1 -- food list
|
|
ferencd@0
|
2 insert into food(idx, name_source, type, image, food_key) values (83, "fried_potatoes_with_dill_name", 2, "{#rroot}/img/icon.png", "fried_potatoes_with_dill");
|
|
ferencd@0
|
3 insert into food(idx, name_source, type, image, food_key) values (84, "mashed_potatoes_name", 2, "{#rroot}/img/icon.png", "mashed_potatoes");
|
|
ferencd@0
|
4 insert into food(idx, name_source, type, image, food_key) values (85, "potato_with_green_parsley_name", 2, "{#rroot}/img/icon.png", "potato_with_green_parsley");
|
|
ferencd@0
|
5 insert into food(idx, name_source, type, image, food_key) values (86, "fried_potato_with_paprika_name", 2, "{#rroot}/img/icon.png", "fried_potato_with_paprika");
|
|
ferencd@0
|
6 insert into food(idx, name_source, type, image, food_key) values (87, "pommes_frites_name", 2, "{#rroot}/img/icon.png", "pommes_frites");
|
|
ferencd@0
|
7 insert into food(idx, name_source, type, image, food_key) values (88, "green_peas_name", 2, "{#rroot}/img/icon.png", "green_peas");
|
|
ferencd@0
|
8 insert into food(idx, name_source, type, image, food_key) values (89, "celery_sides_name", 2, "{#rroot}/img/icon.png", "celery_sides");
|
|
ferencd@0
|
9 insert into food(idx, name_source, type, image, food_key) values (90, "squash_name", 2, "{#rroot}/img/icon.png", "squash");
|
|
ferencd@0
|
10 insert into food(idx, name_source, type, image, food_key) values (91, "green_beans_name", 2, "{#rroot}/img/icon.png", "green_beans");
|
|
ferencd@0
|
11 insert into food(idx, name_source, type, image, food_key) values (92, "spinach_name", 2, "{#rroot}/img/icon.png", "spinach");
|
|
ferencd@0
|
12 insert into food(idx, name_source, type, image, food_key) values (93, "crushed_beans_name", 2, "{#rroot}/img/icon.png", "crushed_beans");
|
|
ferencd@0
|
13 insert into food(idx, name_source, type, image, food_key) values (94, "cabbage_name", 2, "{#rroot}/img/icon.png", "cabbage");
|
|
ferencd@0
|
14 -- translations for food
|
|
ferencd@0
|
15 insert into translations(source, gb) values ("fried_potatoes_with_dill_name", "Fried potatoes with dill");
|
|
ferencd@0
|
16 insert into translations(source, gb) values ("mashed_potatoes_name", "Mashed potatoes");
|
|
ferencd@0
|
17 insert into translations(source, gb) values ("potato_with_green_parsley_name", "Potato with green parsley");
|
|
ferencd@0
|
18 insert into translations(source, gb) values ("fried_potato_with_paprika_name", "Fried potato with paprika");
|
|
ferencd@0
|
19 insert into translations(source, gb) values ("pommes_frites_name", "Pommes frites");
|
|
ferencd@0
|
20 insert into translations(source, gb) values ("green_peas_name", "Green peas");
|
|
ferencd@0
|
21 insert into translations(source, gb) values ("celery_sides_name", "Celery sides");
|
|
ferencd@0
|
22 insert into translations(source, gb) values ("squash_name", "Squash");
|
|
ferencd@0
|
23 insert into translations(source, gb) values ("green_beans_name", "Green beans");
|
|
ferencd@0
|
24 insert into translations(source, gb) values ("spinach_name", "Spinach");
|
|
ferencd@0
|
25 insert into translations(source, gb) values ("crushed_beans_name", "Crushed beans");
|
|
ferencd@0
|
26 insert into translations(source, gb) values ("cabbage_name", "Cabbage");
|
|
ferencd@0
|
27 -- tags of ingredients to food
|
|
ferencd@0
|
28 insert into tags(food_id, ingredient_id) values (83, 125); -- potatoes / Fried potatoes with dill
|
|
ferencd@0
|
29 insert into tags(food_id, ingredient_id) values (83, 21); -- butter / Fried potatoes with dill
|
|
ferencd@0
|
30 insert into tags(food_id, ingredient_id) values (83, 138); -- salt / Fried potatoes with dill
|
|
ferencd@0
|
31 insert into tags(food_id, ingredient_id) values (83, 118); -- pepper / Fried potatoes with dill
|
|
ferencd@0
|
32 insert into tags(food_id, ingredient_id) values (83, 49); -- dill / Fried potatoes with dill
|
|
ferencd@0
|
33 insert into tags(food_id, ingredient_id) values (84, 125); -- potatoes / Mashed potatoes
|
|
ferencd@0
|
34 insert into tags(food_id, ingredient_id) values (84, 138); -- salt / Mashed potatoes
|
|
ferencd@0
|
35 insert into tags(food_id, ingredient_id) values (84, 99); -- milk / Mashed potatoes
|
|
ferencd@0
|
36 insert into tags(food_id, ingredient_id) values (84, 21); -- butter / Mashed potatoes
|
|
ferencd@0
|
37 insert into tags(food_id, ingredient_id) values (84, 175); -- vegeta / Mashed potatoes
|
|
ferencd@0
|
38 insert into tags(food_id, ingredient_id) values (84, 104); -- oil / Mashed potatoes
|
|
ferencd@0
|
39 insert into tags(food_id, ingredient_id) values (85, 125); -- potatoes / Potato with green parsley
|
|
ferencd@0
|
40 insert into tags(food_id, ingredient_id) values (85, 21); -- butter / Potato with green parsley
|
|
ferencd@0
|
41 insert into tags(food_id, ingredient_id) values (85, 113); -- parsley / Potato with green parsley
|
|
ferencd@0
|
42 insert into tags(food_id, ingredient_id) values (85, 138); -- salt / Potato with green parsley
|
|
ferencd@0
|
43 insert into tags(food_id, ingredient_id) values (86, 106); -- onion / Fried potato with paprika
|
|
ferencd@0
|
44 insert into tags(food_id, ingredient_id) values (86, 125); -- potatoes / Fried potato with paprika
|
|
ferencd@0
|
45 insert into tags(food_id, ingredient_id) values (86, 112); -- paprika / Fried potato with paprika
|
|
ferencd@0
|
46 insert into tags(food_id, ingredient_id) values (86, 104); -- oil / Fried potato with paprika
|
|
ferencd@0
|
47 insert into tags(food_id, ingredient_id) values (87, 125); -- potatoes / Pommes frites
|
|
ferencd@0
|
48 insert into tags(food_id, ingredient_id) values (87, 104); -- oil / Pommes frites
|
|
ferencd@0
|
49 insert into tags(food_id, ingredient_id) values (88, 116); -- peas / Green peas
|
|
ferencd@0
|
50 insert into tags(food_id, ingredient_id) values (88, 104); -- oil / Green peas
|
|
ferencd@0
|
51 insert into tags(food_id, ingredient_id) values (88, 60); -- flour / Green peas
|
|
ferencd@0
|
52 insert into tags(food_id, ingredient_id) values (88, 137); -- roux / Green peas
|
|
ferencd@0
|
53 insert into tags(food_id, ingredient_id) values (88, 113); -- parsley / Green peas
|
|
ferencd@0
|
54 insert into tags(food_id, ingredient_id) values (88, 138); -- salt / Green peas
|
|
ferencd@0
|
55 insert into tags(food_id, ingredient_id) values (88, 158); -- sugar / Green peas
|
|
ferencd@0
|
56 insert into tags(food_id, ingredient_id) values (88, 179); -- vinegar / Green peas
|
|
ferencd@0
|
57 insert into tags(food_id, ingredient_id) values (88, 166); -- tomato / Green peas
|
|
ferencd@0
|
58 insert into tags(food_id, ingredient_id) values (88, 21); -- butter / Green peas
|
|
ferencd@0
|
59 insert into tags(food_id, ingredient_id) values (89, 30); -- celery / Celery sides
|
|
ferencd@0
|
60 insert into tags(food_id, ingredient_id) values (89, 21); -- butter / Celery sides
|
|
ferencd@0
|
61 insert into tags(food_id, ingredient_id) values (89, 138); -- salt / Celery sides
|
|
ferencd@0
|
62 insert into tags(food_id, ingredient_id) values (89, 162); -- tarragon / Celery sides
|
|
ferencd@0
|
63 insert into tags(food_id, ingredient_id) values (89, 113); -- parsley / Celery sides
|
|
ferencd@0
|
64 insert into tags(food_id, ingredient_id) values (90, 156); -- squashes / Squash
|
|
ferencd@0
|
65 insert into tags(food_id, ingredient_id) values (90, 191); -- zucchinis / Squash
|
|
ferencd@0
|
66 insert into tags(food_id, ingredient_id) values (90, 49); -- dill / Squash
|
|
ferencd@0
|
67 insert into tags(food_id, ingredient_id) values (90, 109); -- oregano / Squash
|
|
ferencd@0
|
68 insert into tags(food_id, ingredient_id) values (90, 179); -- vinegar / Squash
|
|
ferencd@0
|
69 insert into tags(food_id, ingredient_id) values (90, 60); -- flour / Squash
|
|
ferencd@0
|
70 insert into tags(food_id, ingredient_id) values (90, 104); -- oil / Squash
|
|
ferencd@0
|
71 insert into tags(food_id, ingredient_id) values (90, 138); -- salt / Squash
|
|
ferencd@0
|
72 insert into tags(food_id, ingredient_id) values (90, 112); -- paprika / Squash
|
|
ferencd@0
|
73 insert into tags(food_id, ingredient_id) values (91, 12); -- beans / Green beans
|
|
ferencd@0
|
74 insert into tags(food_id, ingredient_id) values (91, 106); -- onion / Green beans
|
|
ferencd@0
|
75 insert into tags(food_id, ingredient_id) values (91, 168); -- tomatoes / Green beans
|
|
ferencd@0
|
76 insert into tags(food_id, ingredient_id) values (91, 113); -- parsley / Green beans
|
|
ferencd@0
|
77 insert into tags(food_id, ingredient_id) values (91, 138); -- salt / Green beans
|
|
ferencd@0
|
78 insert into tags(food_id, ingredient_id) values (91, 158); -- sugar / Green beans
|
|
ferencd@0
|
79 insert into tags(food_id, ingredient_id) values (91, 179); -- vinegar / Green beans
|
|
ferencd@0
|
80 insert into tags(food_id, ingredient_id) values (91, 60); -- flour / Green beans
|
|
ferencd@0
|
81 insert into tags(food_id, ingredient_id) values (91, 104); -- oil / Green beans
|
|
ferencd@0
|
82 insert into tags(food_id, ingredient_id) values (91, 62); -- garlic / Green beans
|
|
ferencd@0
|
83 insert into tags(food_id, ingredient_id) values (91, 40); -- cloves / Green beans
|
|
ferencd@0
|
84 insert into tags(food_id, ingredient_id) values (91, 112); -- paprika / Green beans
|
|
ferencd@0
|
85 insert into tags(food_id, ingredient_id) values (92, 152); -- spinach / Spinach
|
|
ferencd@0
|
86 insert into tags(food_id, ingredient_id) values (92, 62); -- garlic / Spinach
|
|
ferencd@0
|
87 insert into tags(food_id, ingredient_id) values (92, 40); -- cloves / Spinach
|
|
ferencd@0
|
88 insert into tags(food_id, ingredient_id) values (92, 99); -- milk / Spinach
|
|
ferencd@0
|
89 insert into tags(food_id, ingredient_id) values (92, 21); -- butter / Spinach
|
|
ferencd@0
|
90 insert into tags(food_id, ingredient_id) values (92, 104); -- oil / Spinach
|
|
ferencd@0
|
91 insert into tags(food_id, ingredient_id) values (92, 60); -- flour / Spinach
|
|
ferencd@0
|
92 insert into tags(food_id, ingredient_id) values (92, 138); -- salt / Spinach
|
|
ferencd@0
|
93 insert into tags(food_id, ingredient_id) values (93, 12); -- beans / Crushed beans
|
|
ferencd@0
|
94 insert into tags(food_id, ingredient_id) values (93, 106); -- onion / Crushed beans
|
|
ferencd@0
|
95 insert into tags(food_id, ingredient_id) values (93, 8); -- bacon / Crushed beans
|
|
ferencd@0
|
96 insert into tags(food_id, ingredient_id) values (93, 104); -- oil / Crushed beans
|
|
ferencd@0
|
97 insert into tags(food_id, ingredient_id) values (93, 60); -- flour / Crushed beans
|
|
ferencd@0
|
98 insert into tags(food_id, ingredient_id) values (93, 138); -- salt / Crushed beans
|
|
ferencd@0
|
99 insert into tags(food_id, ingredient_id) values (93, 118); -- pepper / Crushed beans
|
|
ferencd@0
|
100 insert into tags(food_id, ingredient_id) values (93, 179); -- vinegar / Crushed beans
|
|
ferencd@0
|
101 insert into tags(food_id, ingredient_id) values (93, 113); -- parsley / Crushed beans
|
|
ferencd@0
|
102 insert into tags(food_id, ingredient_id) values (94, 23); -- cabbage / Cabbage
|
|
ferencd@0
|
103 insert into tags(food_id, ingredient_id) values (94, 106); -- onion / Cabbage
|
|
ferencd@0
|
104 insert into tags(food_id, ingredient_id) values (94, 60); -- flour / Cabbage
|
|
ferencd@0
|
105 insert into tags(food_id, ingredient_id) values (94, 104); -- oil / Cabbage
|
|
ferencd@0
|
106 insert into tags(food_id, ingredient_id) values (94, 138); -- salt / Cabbage
|
|
ferencd@0
|
107 insert into tags(food_id, ingredient_id) values (94, 118); -- pepper / Cabbage
|
|
ferencd@0
|
108 insert into tags(food_id, ingredient_id) values (94, 112); -- paprika / Cabbage
|
|
ferencd@0
|
109 insert into tags(food_id, ingredient_id) values (94, 109); -- oregano / Cabbage
|
|
ferencd@0
|
110 insert into tags(food_id, ingredient_id) values (94, 49); -- dill / Cabbage
|
