|
ferencd@0
|
1 -- food list
|
|
ferencd@0
|
2 insert into food(idx, name_source, type, image, food_key) values (1, "furry_bread_name", 100, "{#rroot}/img/icon.png", "furry_bread");
|
|
ferencd@0
|
3 insert into food(idx, name_source, type, image, food_key) values (2, "bread_cake_name", 100, "{#rroot}/img/icon.png", "bread_cake");
|
|
ferencd@0
|
4 insert into food(idx, name_source, type, image, food_key) values (3, "fried_mushrooms_name", 100, "{#rroot}/img/icon.png", "fried_mushrooms");
|
|
ferencd@0
|
5 insert into food(idx, name_source, type, image, food_key) values (4, "jewish_eggs_name", 100, "{#rroot}/img/icon.png", "jewish_eggs");
|
|
ferencd@0
|
6 insert into food(idx, name_source, type, image, food_key) values (5, "mushroom_pancake_name", 100, "{#rroot}/img/icon.png", "mushroom_pancake");
|
|
ferencd@0
|
7 insert into food(idx, name_source, type, image, food_key) values (6, "mashed_aubergine_name", 100, "{#rroot}/img/icon.png", "mashed_aubergine");
|
|
ferencd@0
|
8 insert into food(idx, name_source, type, image, food_key) values (7, "boiled_bacon_name", 100, "{#rroot}/img/icon.png", "boiled_bacon");
|
|
ferencd@0
|
9 insert into food(idx, name_source, type, image, food_key) values (8, "vegetable_spread_name", 100, "{#rroot}/img/icon.png", "vegetable_spread");
|
|
ferencd@0
|
10 insert into food(idx, name_source, type, image, food_key) values (9, "homemade_pate_name", 100, "{#rroot}/img/icon.png", "homemade_pate");
|
|
ferencd@0
|
11 insert into food(idx, name_source, type, image, food_key) values (10, "transylvanian_omelette_name", 100, "{#rroot}/img/icon.png", "transylvanian_omelette");
|
|
ferencd@0
|
12 insert into food(idx, name_source, type, image, food_key) values (11, "beef_salad_name", 100, "{#rroot}/img/icon.png", "beef_salad");
|
|
ferencd@0
|
13 insert into food(idx, name_source, type, image, food_key) values (12, "polenta_with_cheese_name", 100, "{#rroot}/img/icon.png", "polenta_with_cheese");
|
|
ferencd@0
|
14 -- translations for food
|
|
ferencd@0
|
15 insert into translations(source, gb) values ("furry_bread_name", "Furry bread");
|
|
ferencd@0
|
16 insert into translations(source, gb) values ("bread_cake_name", "Bread-cake");
|
|
ferencd@0
|
17 insert into translations(source, gb) values ("fried_mushrooms_name", "Fried mushrooms");
|
|
ferencd@0
|
18 insert into translations(source, gb) values ("jewish_eggs_name", "Jewish eggs");
|
|
ferencd@0
|
19 insert into translations(source, gb) values ("mushroom_pancake_name", "Mushroom pancake");
|
|
ferencd@0
|
20 insert into translations(source, gb) values ("mashed_aubergine_name", "Mashed aubergine");
|
|
ferencd@0
|
21 insert into translations(source, gb) values ("boiled_bacon_name", "Boiled bacon");
|
|
ferencd@0
|
22 insert into translations(source, gb) values ("vegetable_spread_name", "Vegetable spread");
|
|
ferencd@0
|
23 insert into translations(source, gb) values ("homemade_pate_name", "Homemade Pâté");
|
|
ferencd@0
|
24 insert into translations(source, gb) values ("transylvanian_omelette_name", "Transylvanian omelette");
|
|
ferencd@0
|
25 insert into translations(source, gb) values ("beef_salad_name", "Beef salad");
|
|
ferencd@0
|
26 insert into translations(source, gb) values ("polenta_with_cheese_name", "Polenta with cheese");
|
|
ferencd@0
|
27 -- tags of ingredients to food
|
|
ferencd@0
|
28 insert into tags(food_id, ingredient_id) values (1, 17); -- bread / Furry bread
|
|
ferencd@0
|
29 insert into tags(food_id, ingredient_id) values (1, 53); -- eggs / Furry bread
|
|
ferencd@0
|
30 insert into tags(food_id, ingredient_id) values (1, 99); -- milk / Furry bread
|
|
ferencd@0
|
31 insert into tags(food_id, ingredient_id) values (1, 138); -- salt / Furry bread
|
|
ferencd@0
|
32 insert into tags(food_id, ingredient_id) values (1, 118); -- pepper / Furry bread
|
|
ferencd@0
|
33 insert into tags(food_id, ingredient_id) values (1, 104); -- oil / Furry bread
|
|
ferencd@0
|
34 insert into tags(food_id, ingredient_id) values (1, 74); -- jam / Furry bread
|
|
ferencd@0
|
35 insert into tags(food_id, ingredient_id) values (1, 33); -- cheese / Furry bread
|
|
ferencd@0
|
36 insert into tags(food_id, ingredient_id) values (1, 29); -- cayennepepper / Furry bread
|
|
ferencd@0
|
37 insert into tags(food_id, ingredient_id) values (10, 53); -- eggs / Transylvanian omelette
|
|
ferencd@0
|
38 insert into tags(food_id, ingredient_id) values (10, 8); -- bacon / Transylvanian omelette
|
|
ferencd@0
|
39 insert into tags(food_id, ingredient_id) values (10, 104); -- oil / Transylvanian omelette
|
|
ferencd@0
|
40 insert into tags(food_id, ingredient_id) values (10, 83); -- lard / Transylvanian omelette
|
|
ferencd@0
|
41 insert into tags(food_id, ingredient_id) values (10, 138); -- salt / Transylvanian omelette
|
|
ferencd@0
|
42 insert into tags(food_id, ingredient_id) values (10, 17); -- bread / Transylvanian omelette
|
|
ferencd@0
|
43 insert into tags(food_id, ingredient_id) values (10, 177); -- vegetables / Transylvanian omelette
|
|
ferencd@0
|
44 insert into tags(food_id, ingredient_id) values (10, 118); -- pepper / Transylvanian omelette
|
|
ferencd@0
|
45 insert into tags(food_id, ingredient_id) values (10, 107); -- onions / Transylvanian omelette
|
|
ferencd@0
|
46 insert into tags(food_id, ingredient_id) values (10, 101); -- mushrooms / Transylvanian omelette
|
|
ferencd@0
|
47 insert into tags(food_id, ingredient_id) values (10, 33); -- cheese / Transylvanian omelette
|
|
ferencd@0
|
48 insert into tags(food_id, ingredient_id) values (11, 26); -- carrots / Beef salad
|
|
ferencd@0
|
49 insert into tags(food_id, ingredient_id) values (11, 114); -- parsnips / Beef salad
|
|
ferencd@0
|
50 insert into tags(food_id, ingredient_id) values (11, 30); -- celery / Beef salad
|
|
ferencd@0
|
51 insert into tags(food_id, ingredient_id) values (11, 113); -- parsley / Beef salad
|
|
ferencd@0
|
52 insert into tags(food_id, ingredient_id) values (11, 125); -- potatoes / Beef salad
|
|
ferencd@0
|
53 insert into tags(food_id, ingredient_id) values (11, 116); -- peas / Beef salad
|
|
ferencd@0
|
54 insert into tags(food_id, ingredient_id) values (11, 12); -- beans / Beef salad
|
|
ferencd@0
|
55 insert into tags(food_id, ingredient_id) values (11, 170); -- turnips / Beef salad
|
|
ferencd@0
|
56 insert into tags(food_id, ingredient_id) values (11, 47); -- cucumber / Beef salad
|
|
ferencd@0
|
57 insert into tags(food_id, ingredient_id) values (11, 105); -- olives / Beef salad
|
|
ferencd@0
|
58 insert into tags(food_id, ingredient_id) values (11, 97); -- meat / Beef salad
|
|
ferencd@0
|
59 insert into tags(food_id, ingredient_id) values (11, 13); -- beef / Beef salad
|
|
ferencd@0
|
60 insert into tags(food_id, ingredient_id) values (11, 96); -- mayonnaise / Beef salad
|
|
ferencd@0
|
61 insert into tags(food_id, ingredient_id) values (12, 43); -- corn / Polenta with cheese
|
|
ferencd@0
|
62 insert into tags(food_id, ingredient_id) values (12, 60); -- flour / Polenta with cheese
|
|
ferencd@0
|
63 insert into tags(food_id, ingredient_id) values (12, 138); -- salt / Polenta with cheese
|
|
ferencd@0
|
64 insert into tags(food_id, ingredient_id) values (12, 33); -- cheese / Polenta with cheese
|
|
ferencd@0
|
65 insert into tags(food_id, ingredient_id) values (12, 181); -- water / Polenta with cheese
|
|
ferencd@0
|
66 insert into tags(food_id, ingredient_id) values (2, 17); -- bread / Bread-cake
|
|
ferencd@0
|
67 insert into tags(food_id, ingredient_id) values (2, 8); -- bacon / Bread-cake
|
|
ferencd@0
|
68 insert into tags(food_id, ingredient_id) values (2, 52); -- egg / Bread-cake
|
|
ferencd@0
|
69 insert into tags(food_id, ingredient_id) values (2, 99); -- milk / Bread-cake
|
|
ferencd@0
|
70 insert into tags(food_id, ingredient_id) values (2, 33); -- cheese / Bread-cake
|
|
ferencd@0
|
71 insert into tags(food_id, ingredient_id) values (2, 138); -- salt / Bread-cake
|
|
ferencd@0
|
72 insert into tags(food_id, ingredient_id) values (2, 118); -- pepper / Bread-cake
|
|
ferencd@0
|
73 insert into tags(food_id, ingredient_id) values (2, 106); -- onion / Bread-cake
|
|
ferencd@0
|
74 insert into tags(food_id, ingredient_id) values (2, 105); -- olives / Bread-cake
|
|
ferencd@0
|
75 insert into tags(food_id, ingredient_id) values (2, 113); -- parsley / Bread-cake
|
|
ferencd@0
|
76 insert into tags(food_id, ingredient_id) values (3, 101); -- mushrooms / Fried mushrooms
|
|
ferencd@0
|
77 insert into tags(food_id, ingredient_id) values (3, 107); -- onions / Fried mushrooms
|
|
ferencd@0
|
78 insert into tags(food_id, ingredient_id) values (3, 62); -- garlic / Fried mushrooms
|
|
ferencd@0
|
79 insert into tags(food_id, ingredient_id) values (3, 40); -- cloves / Fried mushrooms
|
|
ferencd@0
|
80 insert into tags(food_id, ingredient_id) values (3, 21); -- butter / Fried mushrooms
|
|
ferencd@0
|
81 insert into tags(food_id, ingredient_id) values (3, 138); -- salt / Fried mushrooms
|
|
ferencd@0
|
82 insert into tags(food_id, ingredient_id) values (3, 118); -- pepper / Fried mushrooms
|
|
ferencd@0
|
83 insert into tags(food_id, ingredient_id) values (4, 53); -- eggs / Jewish eggs
|
|
ferencd@0
|
84 insert into tags(food_id, ingredient_id) values (4, 106); -- onion / Jewish eggs
|
|
ferencd@0
|
85 insert into tags(food_id, ingredient_id) values (4, 138); -- salt / Jewish eggs
|
|
ferencd@0
|
86 insert into tags(food_id, ingredient_id) values (4, 118); -- pepper / Jewish eggs
|
|
ferencd@0
|
87 insert into tags(food_id, ingredient_id) values (4, 104); -- oil / Jewish eggs
|
|
ferencd@0
|
88 insert into tags(food_id, ingredient_id) values (4, 65); -- goose / Jewish eggs
|
|
ferencd@0
|
89 insert into tags(food_id, ingredient_id) values (4, 51); -- duck / Jewish eggs
|
|
ferencd@0
|
90 insert into tags(food_id, ingredient_id) values (4, 89); -- liver / Jewish eggs
|
|
ferencd@0
|
91 insert into tags(food_id, ingredient_id) values (5, 106); -- onion / Mushroom pancake
|
|
ferencd@0
|
92 insert into tags(food_id, ingredient_id) values (5, 101); -- mushrooms / Mushroom pancake
|
|
ferencd@0
|
93 insert into tags(food_id, ingredient_id) values (5, 52); -- egg / Mushroom pancake
|
|
ferencd@0
|
94 insert into tags(food_id, ingredient_id) values (5, 21); -- butter / Mushroom pancake
|
|
ferencd@0
|
95 insert into tags(food_id, ingredient_id) values (5, 60); -- flour / Mushroom pancake
|
|
ferencd@0
|
96 insert into tags(food_id, ingredient_id) values (5, 104); -- oil / Mushroom pancake
|
|
ferencd@0
|
97 insert into tags(food_id, ingredient_id) values (5, 138); -- salt / Mushroom pancake
|
|
ferencd@0
|
98 insert into tags(food_id, ingredient_id) values (5, 118); -- pepper / Mushroom pancake
|
|
ferencd@0
|
99 insert into tags(food_id, ingredient_id) values (5, 112); -- paprika / Mushroom pancake
|
|
ferencd@0
|
100 insert into tags(food_id, ingredient_id) values (5, 113); -- parsley / Mushroom pancake
|
|
ferencd@0
|
101 insert into tags(food_id, ingredient_id) values (5, 179); -- vinegar / Mushroom pancake
|
|
ferencd@0
|
102 insert into tags(food_id, ingredient_id) values (5, 99); -- milk / Mushroom pancake
|
|
ferencd@0
|
103 insert into tags(food_id, ingredient_id) values (6, 7); -- aubergine / Mashed aubergine
|
|
ferencd@0
|
104 insert into tags(food_id, ingredient_id) values (6, 104); -- oil / Mashed aubergine
|
|
ferencd@0
|
105 insert into tags(food_id, ingredient_id) values (6, 138); -- salt / Mashed aubergine
|
|
ferencd@0
|
106 insert into tags(food_id, ingredient_id) values (6, 106); -- onion / Mashed aubergine
|
|
ferencd@0
|
107 insert into tags(food_id, ingredient_id) values (6, 96); -- mayonnaise / Mashed aubergine
|
|
ferencd@0
|
108 insert into tags(food_id, ingredient_id) values (6, 62); -- garlic / Mashed aubergine
|
|
ferencd@0
|
109 insert into tags(food_id, ingredient_id) values (6, 40); -- cloves / Mashed aubergine
|
|
ferencd@0
|
110 insert into tags(food_id, ingredient_id) values (6, 75); -- juice / Mashed aubergine
|
|
ferencd@0
|
111 insert into tags(food_id, ingredient_id) values (6, 86); -- lemon / Mashed aubergine
|
|
ferencd@0
|
112 insert into tags(food_id, ingredient_id) values (7, 8); -- bacon / Boiled bacon
|
|
ferencd@0
|
113 insert into tags(food_id, ingredient_id) values (7, 62); -- garlic / Boiled bacon
|
|
ferencd@0
|
114 insert into tags(food_id, ingredient_id) values (7, 40); -- cloves / Boiled bacon
|
|
ferencd@0
|
115 insert into tags(food_id, ingredient_id) values (7, 112); -- paprika / Boiled bacon
|
|
ferencd@0
|
116 insert into tags(food_id, ingredient_id) values (7, 138); -- salt / Boiled bacon
|
|
ferencd@0
|
117 insert into tags(food_id, ingredient_id) values (7, 118); -- pepper / Boiled bacon
|
|
ferencd@0
|
118 insert into tags(food_id, ingredient_id) values (8, 106); -- onion / Vegetable spread
|
|
ferencd@0
|
119 insert into tags(food_id, ingredient_id) values (8, 168); -- tomatoes / Vegetable spread
|
|
ferencd@0
|
120 insert into tags(food_id, ingredient_id) values (8, 12); -- beans / Vegetable spread
|
|
ferencd@0
|
121 insert into tags(food_id, ingredient_id) values (8, 118); -- pepper / Vegetable spread
|
|
ferencd@0
|
122 insert into tags(food_id, ingredient_id) values (8, 138); -- salt / Vegetable spread
|
|
ferencd@0
|
123 insert into tags(food_id, ingredient_id) values (8, 104); -- oil / Vegetable spread
|
|
ferencd@0
|
124 insert into tags(food_id, ingredient_id) values (9, 122); -- pork / Homemade Pâté
|
|
ferencd@0
|
125 insert into tags(food_id, ingredient_id) values (9, 89); -- liver / Homemade Pâté
|
|
ferencd@0
|
126 insert into tags(food_id, ingredient_id) values (9, 97); -- meat / Homemade Pâté
|
|
ferencd@0
|
127 insert into tags(food_id, ingredient_id) values (9, 102); -- neck / Homemade Pâté
|
|
ferencd@0
|
128 insert into tags(food_id, ingredient_id) values (9, 15); -- bones / Homemade Pâté
|
|
ferencd@0
|
129 insert into tags(food_id, ingredient_id) values (9, 55); -- fat / Homemade Pâté
|
|
ferencd@0
|
130 insert into tags(food_id, ingredient_id) values (9, 8); -- bacon / Homemade Pâté
|
|
ferencd@0
|
131 insert into tags(food_id, ingredient_id) values (9, 107); -- onions / Homemade Pâté
|
|
ferencd@0
|
132 insert into tags(food_id, ingredient_id) values (9, 1); -- allspice / Homemade Pâté
|
|
ferencd@0
|
133 insert into tags(food_id, ingredient_id) values (9, 103); -- nutmeg / Homemade Pâté
|
|
ferencd@0
|
134 insert into tags(food_id, ingredient_id) values (9, 138); -- salt / Homemade Pâté
|
|
ferencd@0
|
135 insert into tags(food_id, ingredient_id) values (9, 118); -- pepper / Homemade Pâté
|
|
ferencd@0
|
136 insert into tags(food_id, ingredient_id) values (9, 104); -- oil / Homemade Pâté
|
