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