Mercurial > thymian

comparison server/sql/dbs-breakfast.sql @ 0:a4671277546c tip

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