|
ferencd@0
|
1 -- food list
|
|
ferencd@0
|
2 insert into food(idx, name_source, type, image, food_key) values (99, "donuts_from_transylvania_name", 4, "{#rroot}/img/icon.png", "donuts_from_transylvania");
|
|
ferencd@0
|
3 insert into food(idx, name_source, type, image, food_key) values (100, "apple_cake_with_meringue_name", 4, "{#rroot}/img/icon.png", "apple_cake_with_meringue");
|
|
ferencd@0
|
4 insert into food(idx, name_source, type, image, food_key) values (101, "classic_apple_cake_name", 4, "{#rroot}/img/icon.png", "classic_apple_cake");
|
|
ferencd@0
|
5 insert into food(idx, name_source, type, image, food_key) values (102, "quick_apple_cake_name", 4, "{#rroot}/img/icon.png", "quick_apple_cake");
|
|
ferencd@0
|
6 insert into food(idx, name_source, type, image, food_key) values (103, "lemon_cake_name", 4, "{#rroot}/img/icon.png", "lemon_cake");
|
|
ferencd@0
|
7 insert into food(idx, name_source, type, image, food_key) values (104, "linzer_cookies_name", 4, "{#rroot}/img/icon.png", "linzer_cookies");
|
|
ferencd@0
|
8 insert into food(idx, name_source, type, image, food_key) values (105, "pretzel_name", 4, "{#rroot}/img/icon.png", "pretzel");
|
|
ferencd@0
|
9 insert into food(idx, name_source, type, image, food_key) values (106, "walnut_cake_name", 4, "{#rroot}/img/icon.png", "walnut_cake");
|
|
ferencd@0
|
10 insert into food(idx, name_source, type, image, food_key) values (107, "cottage_cheese_dumplings_name", 4, "{#rroot}/img/icon.png", "cottage_cheese_dumplings");
|
|
ferencd@0
|
11 insert into food(idx, name_source, type, image, food_key) values (108, "plum_dumplings_name", 4, "{#rroot}/img/icon.png", "plum_dumplings");
|
|
ferencd@0
|
12 insert into food(idx, name_source, type, image, food_key) values (109, "pancakes_name", 4, "{#rroot}/img/icon.png", "pancakes");
|
|
ferencd@0
|
13 insert into food(idx, name_source, type, image, food_key) values (110, "fried_pancake_name", 4, "{#rroot}/img/icon.png", "fried_pancake");
|
|
ferencd@0
|
14 insert into food(idx, name_source, type, image, food_key) values (111, "birds_milk_name", 4, "{#rroot}/img/icon.png", "birds_milk");
|
|
ferencd@0
|
15 -- translations for food
|
|
ferencd@0
|
16 insert into translations(source, gb) values ("donuts_from_transylvania_name", "Donuts from Transylvania");
|
|
ferencd@0
|
17 insert into translations(source, gb) values ("apple_cake_with_meringue_name", "Apple cake with meringue");
|
|
ferencd@0
|
18 insert into translations(source, gb) values ("classic_apple_cake_name", "Classic apple cake");
|
|
ferencd@0
|
19 insert into translations(source, gb) values ("quick_apple_cake_name", "Quick apple cake");
|
|
ferencd@0
|
20 insert into translations(source, gb) values ("lemon_cake_name", "Lemon cake");
|
|
ferencd@0
|
21 insert into translations(source, gb) values ("linzer_cookies_name", "Linzer cookies");
|
|
ferencd@0
|
22 insert into translations(source, gb) values ("pretzel_name", "Pretzel");
|
|
ferencd@0
|
23 insert into translations(source, gb) values ("walnut_cake_name", "Walnut cake");
|
|
ferencd@0
|
24 insert into translations(source, gb) values ("cottage_cheese_dumplings_name", "Cottage cheese dumplings");
|
|
ferencd@0
|
25 insert into translations(source, gb) values ("plum_dumplings_name", "Plum dumplings");
|
|
ferencd@0
|
26 insert into translations(source, gb) values ("pancakes_name", "Pancakes");
|
|
ferencd@0
|
27 insert into translations(source, gb) values ("fried_pancake_name", "Fried pancake");
|
|
ferencd@0
|
28 insert into translations(source, gb) values ("birds_milk_name", "Bird's milk");
|
|
ferencd@0
|
29 -- tags of ingredients to food
|
|
ferencd@0
|
30 insert into tags(food_id, ingredient_id) values (100, 4); -- apples / Apple cake with meringue
|
|
ferencd@0
|
31 insert into tags(food_id, ingredient_id) values (100, 60); -- flour / Apple cake with meringue
|
|
ferencd@0
|
32 insert into tags(food_id, ingredient_id) values (100, 21); -- butter / Apple cake with meringue
|
|
ferencd@0
|
33 insert into tags(food_id, ingredient_id) values (100, 86); -- lemon / Apple cake with meringue
|
|
ferencd@0
|
34 insert into tags(food_id, ingredient_id) values (100, 75); -- juice / Apple cake with meringue
|
|
ferencd@0
|
35 insert into tags(food_id, ingredient_id) values (100, 186); -- wine / Apple cake with meringue
|
|
ferencd@0
|
36 insert into tags(food_id, ingredient_id) values (100, 53); -- eggs / Apple cake with meringue
|
|
ferencd@0
|
37 insert into tags(food_id, ingredient_id) values (100, 158); -- sugar / Apple cake with meringue
|
|
ferencd@0
|
38 insert into tags(food_id, ingredient_id) values (100, 74); -- jam / Apple cake with meringue
|
|
ferencd@0
|
39 insert into tags(food_id, ingredient_id) values (100, 39); -- cinnamon / Apple cake with meringue
|
|
ferencd@0
|
40 insert into tags(food_id, ingredient_id) values (101, 60); -- flour / Classic apple cake
|
|
ferencd@0
|
41 insert into tags(food_id, ingredient_id) values (101, 21); -- butter / Classic apple cake
|
|
ferencd@0
|
42 insert into tags(food_id, ingredient_id) values (101, 53); -- eggs / Classic apple cake
|
|
ferencd@0
|
43 insert into tags(food_id, ingredient_id) values (101, 99); -- milk / Classic apple cake
|
|
ferencd@0
|
44 insert into tags(food_id, ingredient_id) values (101, 188); -- yeast / Classic apple cake
|
|
ferencd@0
|
45 insert into tags(food_id, ingredient_id) values (101, 158); -- sugar / Classic apple cake
|
|
ferencd@0
|
46 insert into tags(food_id, ingredient_id) values (101, 4); -- apples / Classic apple cake
|
|
ferencd@0
|
47 insert into tags(food_id, ingredient_id) values (101, 39); -- cinnamon / Classic apple cake
|
|
ferencd@0
|
48 insert into tags(food_id, ingredient_id) values (102, 53); -- eggs / Quick apple cake
|
|
ferencd@0
|
49 insert into tags(food_id, ingredient_id) values (102, 171); -- vanilla / Quick apple cake
|
|
ferencd@0
|
50 insert into tags(food_id, ingredient_id) values (102, 158); -- sugar / Quick apple cake
|
|
ferencd@0
|
51 insert into tags(food_id, ingredient_id) values (102, 60); -- flour / Quick apple cake
|
|
ferencd@0
|
52 insert into tags(food_id, ingredient_id) values (102, 99); -- milk / Quick apple cake
|
|
ferencd@0
|
53 insert into tags(food_id, ingredient_id) values (102, 138); -- salt / Quick apple cake
|
|
ferencd@0
|
54 insert into tags(food_id, ingredient_id) values (102, 86); -- lemon / Quick apple cake
|
|
ferencd@0
|
55 insert into tags(food_id, ingredient_id) values (102, 75); -- juice / Quick apple cake
|
|
ferencd@0
|
56 insert into tags(food_id, ingredient_id) values (102, 3); -- apple / Quick apple cake
|
|
ferencd@0
|
57 insert into tags(food_id, ingredient_id) values (102, 39); -- cinnamon / Quick apple cake
|
|
ferencd@0
|
58 insert into tags(food_id, ingredient_id) values (103, 60); -- flour / Lemon cake
|
|
ferencd@0
|
59 insert into tags(food_id, ingredient_id) values (103, 21); -- butter / Lemon cake
|
|
ferencd@0
|
60 insert into tags(food_id, ingredient_id) values (103, 158); -- sugar / Lemon cake
|
|
ferencd@0
|
61 insert into tags(food_id, ingredient_id) values (103, 99); -- milk / Lemon cake
|
|
ferencd@0
|
62 insert into tags(food_id, ingredient_id) values (103, 52); -- egg / Lemon cake
|
|
ferencd@0
|
63 insert into tags(food_id, ingredient_id) values (103, 86); -- lemon / Lemon cake
|
|
ferencd@0
|
64 insert into tags(food_id, ingredient_id) values (103, 75); -- juice / Lemon cake
|
|
ferencd@0
|
65 insert into tags(food_id, ingredient_id) values (104, 60); -- flour / Linzer cookies
|
|
ferencd@0
|
66 insert into tags(food_id, ingredient_id) values (104, 21); -- butter / Linzer cookies
|
|
ferencd@0
|
67 insert into tags(food_id, ingredient_id) values (104, 158); -- sugar / Linzer cookies
|
|
ferencd@0
|
68 insert into tags(food_id, ingredient_id) values (104, 52); -- egg / Linzer cookies
|
|
ferencd@0
|
69 insert into tags(food_id, ingredient_id) values (104, 86); -- lemon / Linzer cookies
|
|
ferencd@0
|
70 insert into tags(food_id, ingredient_id) values (105, 60); -- flour / Pretzel
|
|
ferencd@0
|
71 insert into tags(food_id, ingredient_id) values (105, 99); -- milk / Pretzel
|
|
ferencd@0
|
72 insert into tags(food_id, ingredient_id) values (105, 188); -- yeast / Pretzel
|
|
ferencd@0
|
73 insert into tags(food_id, ingredient_id) values (105, 158); -- sugar / Pretzel
|
|
ferencd@0
|
74 insert into tags(food_id, ingredient_id) values (105, 138); -- salt / Pretzel
|
|
ferencd@0
|
75 insert into tags(food_id, ingredient_id) values (105, 104); -- oil / Pretzel
|
|
ferencd@0
|
76 insert into tags(food_id, ingredient_id) values (105, 151); -- soda / Pretzel
|
|
ferencd@0
|
77 insert into tags(food_id, ingredient_id) values (105, 52); -- egg / Pretzel
|
|
ferencd@0
|
78 insert into tags(food_id, ingredient_id) values (105, 33); -- cheese / Pretzel
|
|
ferencd@0
|
79 insert into tags(food_id, ingredient_id) values (105, 181); -- water / Pretzel
|
|
ferencd@0
|
80 insert into tags(food_id, ingredient_id) values (106, 60); -- flour / Walnut cake
|
|
ferencd@0
|
81 insert into tags(food_id, ingredient_id) values (106, 21); -- butter / Walnut cake
|
|
ferencd@0
|
82 insert into tags(food_id, ingredient_id) values (106, 158); -- sugar / Walnut cake
|
|
ferencd@0
|
83 insert into tags(food_id, ingredient_id) values (106, 99); -- milk / Walnut cake
|
|
ferencd@0
|
84 insert into tags(food_id, ingredient_id) values (106, 188); -- yeast / Walnut cake
|
|
ferencd@0
|
85 insert into tags(food_id, ingredient_id) values (106, 52); -- egg / Walnut cake
|
|
ferencd@0
|
86 insert into tags(food_id, ingredient_id) values (106, 189); -- yolks / Walnut cake
|
|
ferencd@0
|
87 insert into tags(food_id, ingredient_id) values (106, 86); -- lemon / Walnut cake
|
|
ferencd@0
|
88 insert into tags(food_id, ingredient_id) values (106, 108); -- orange / Walnut cake
|
|
ferencd@0
|
89 insert into tags(food_id, ingredient_id) values (106, 171); -- vanilla / Walnut cake
|
|
ferencd@0
|
90 insert into tags(food_id, ingredient_id) values (107, 33); -- cheese / Cottage cheese dumplings
|
|
ferencd@0
|
91 insert into tags(food_id, ingredient_id) values (107, 53); -- eggs / Cottage cheese dumplings
|
|
ferencd@0
|
92 insert into tags(food_id, ingredient_id) values (107, 21); -- butter / Cottage cheese dumplings
|
|
ferencd@0
|
93 insert into tags(food_id, ingredient_id) values (107, 138); -- salt / Cottage cheese dumplings
|
|
ferencd@0
|
94 insert into tags(food_id, ingredient_id) values (107, 145); -- semolina / Cottage cheese dumplings
|
|
ferencd@0
|
95 insert into tags(food_id, ingredient_id) values (107, 104); -- oil / Cottage cheese dumplings
|
|
ferencd@0
|
96 insert into tags(food_id, ingredient_id) values (107, 18); -- breadcrumbs / Cottage cheese dumplings
|
|
ferencd@0
|
97 insert into tags(food_id, ingredient_id) values (107, 158); -- sugar / Cottage cheese dumplings
|
|
ferencd@0
|
98 insert into tags(food_id, ingredient_id) values (108, 125); -- potatoes / Plum dumplings
|
|
ferencd@0
|
99 insert into tags(food_id, ingredient_id) values (108, 60); -- flour / Plum dumplings
|
|
ferencd@0
|
100 insert into tags(food_id, ingredient_id) values (108, 158); -- sugar / Plum dumplings
|
|
ferencd@0
|
101 insert into tags(food_id, ingredient_id) values (108, 39); -- cinnamon / Plum dumplings
|
|
ferencd@0
|
102 insert into tags(food_id, ingredient_id) values (108, 138); -- salt / Plum dumplings
|
|
ferencd@0
|
103 insert into tags(food_id, ingredient_id) values (108, 21); -- butter / Plum dumplings
|
|
ferencd@0
|
104 insert into tags(food_id, ingredient_id) values (108, 18); -- breadcrumbs / Plum dumplings
|
|
ferencd@0
|
105 insert into tags(food_id, ingredient_id) values (109, 60); -- flour / Pancakes
|
|
ferencd@0
|
106 insert into tags(food_id, ingredient_id) values (109, 53); -- eggs / Pancakes
|
|
ferencd@0
|
107 insert into tags(food_id, ingredient_id) values (109, 138); -- salt / Pancakes
|
|
ferencd@0
|
108 insert into tags(food_id, ingredient_id) values (109, 99); -- milk / Pancakes
|
|
ferencd@0
|
109 insert into tags(food_id, ingredient_id) values (109, 181); -- water / Pancakes
|
|
ferencd@0
|
110 insert into tags(food_id, ingredient_id) values (109, 23); -- cabbage / Pancakes
|
|
ferencd@0
|
111 insert into tags(food_id, ingredient_id) values (109, 152); -- spinach / Pancakes
|
|
ferencd@0
|
112 insert into tags(food_id, ingredient_id) values (109, 33); -- cheese / Pancakes
|
|
ferencd@0
|
113 insert into tags(food_id, ingredient_id) values (109, 52); -- egg / Pancakes
|
|
ferencd@0
|
114 insert into tags(food_id, ingredient_id) values (110, 60); -- flour / Fried pancake
|
|
ferencd@0
|
115 insert into tags(food_id, ingredient_id) values (110, 188); -- yeast / Fried pancake
|
|
ferencd@0
|
116 insert into tags(food_id, ingredient_id) values (110, 52); -- egg / Fried pancake
|
|
ferencd@0
|
117 insert into tags(food_id, ingredient_id) values (110, 99); -- milk / Fried pancake
|
|
ferencd@0
|
118 insert into tags(food_id, ingredient_id) values (110, 33); -- cheese / Fried pancake
|
|
ferencd@0
|
119 insert into tags(food_id, ingredient_id) values (110, 49); -- dill / Fried pancake
|
|
ferencd@0
|
120 insert into tags(food_id, ingredient_id) values (110, 138); -- salt / Fried pancake
|
|
ferencd@0
|
121 insert into tags(food_id, ingredient_id) values (110, 104); -- oil / Fried pancake
|
|
ferencd@0
|
122 insert into tags(food_id, ingredient_id) values (111, 52); -- egg / Bird's milk
|
|
ferencd@0
|
123 insert into tags(food_id, ingredient_id) values (111, 189); -- yolks / Bird's milk
|
|
ferencd@0
|
124 insert into tags(food_id, ingredient_id) values (111, 158); -- sugar / Bird's milk
|
|
ferencd@0
|
125 insert into tags(food_id, ingredient_id) values (111, 99); -- milk / Bird's milk
|
|
ferencd@0
|
126 insert into tags(food_id, ingredient_id) values (111, 171); -- vanilla / Bird's milk
|
|
ferencd@0
|
127 insert into tags(food_id, ingredient_id) values (99, 60); -- flour / Donuts from Transylvania
|
|
ferencd@0
|
128 insert into tags(food_id, ingredient_id) values (99, 158); -- sugar / Donuts from Transylvania
|
|
ferencd@0
|
129 insert into tags(food_id, ingredient_id) values (99, 138); -- salt / Donuts from Transylvania
|
|
ferencd@0
|
130 insert into tags(food_id, ingredient_id) values (99, 52); -- egg / Donuts from Transylvania
|
|
ferencd@0
|
131 insert into tags(food_id, ingredient_id) values (99, 104); -- oil / Donuts from Transylvania
|
|
ferencd@0
|
132 insert into tags(food_id, ingredient_id) values (99, 188); -- yeast / Donuts from Transylvania
|
|
ferencd@0
|
133 insert into tags(food_id, ingredient_id) values (99, 99); -- milk / Donuts from Transylvania
|
