diff server/sql/dbs-mains.sql @ 0:a4671277546c tip

created the repository for the thymian project
author ferencd
date Tue, 17 Aug 2021 11:19:54 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/server/sql/dbs-mains.sql	Tue Aug 17 11:19:54 2021 +0200
@@ -0,0 +1,429 @@
+-- food list
+insert into food(idx, name_source, type, image, food_key) values (55, "ratatouille_from_transylvania_name", 100, "{#rroot}/img/icon.png", "ratatouille_from_transylvania");
+insert into food(idx, name_source, type, image, food_key) values (56, "gipsy_ratatouille_name", 100, "{#rroot}/img/icon.png", "gipsy_ratatouille");
+insert into food(idx, name_source, type, image, food_key) values (57, "potato_goulash_name", 100, "{#rroot}/img/icon.png", "potato_goulash");
+insert into food(idx, name_source, type, image, food_key) values (58, "mixed_stew_name", 100, "{#rroot}/img/icon.png", "mixed_stew");
+insert into food(idx, name_source, type, image, food_key) values (59, "risotto_ala_transylvania_name", 100, "{#rroot}/img/icon.png", "risotto_ala_transylvania");
+insert into food(idx, name_source, type, image, food_key) values (60, "schnitzel_name", 100, "{#rroot}/img/icon.png", "schnitzel");
+insert into food(idx, name_source, type, image, food_key) values (61, "butter_fried_chicken_name", 100, "{#rroot}/img/icon.png", "butter_fried_chicken");
+insert into food(idx, name_source, type, image, food_key) values (62, "meat_roasted_with_onions_name", 100, "{#rroot}/img/icon.png", "meat_roasted_with_onions");
+insert into food(idx, name_source, type, image, food_key) values (63, "roasted_meat_ala_brasov_name", 100, "{#rroot}/img/icon.png", "roasted_meat_ala_brasov");
+insert into food(idx, name_source, type, image, food_key) values (64, "meatballs_name", 100, "{#rroot}/img/icon.png", "meatballs");
+insert into food(idx, name_source, type, image, food_key) values (65, "smalls_name", 100, "{#rroot}/img/icon.png", "smalls");
+insert into food(idx, name_source, type, image, food_key) values (66, "lamb_cake_name", 100, "{#rroot}/img/icon.png", "lamb_cake");
+insert into food(idx, name_source, type, image, food_key) values (67, "grill_ala_transylvania_name", 100, "{#rroot}/img/icon.png", "grill_ala_transylvania");
+insert into food(idx, name_source, type, image, food_key) values (68, "chicken_paprikas_name", 100, "{#rroot}/img/icon.png", "chicken_paprikas");
+insert into food(idx, name_source, type, image, food_key) values (69, "pepper_tokany_name", 100, "{#rroot}/img/icon.png", "pepper_tokany");
+insert into food(idx, name_source, type, image, food_key) values (70, "mixed_stew_name", 100, "{#rroot}/img/icon.png", "mixed_stew");
+insert into food(idx, name_source, type, image, food_key) values (71, "mushroom_paprikas_name", 100, "{#rroot}/img/icon.png", "mushroom_paprikas");
+insert into food(idx, name_source, type, image, food_key) values (72, "roast_pork_a_la_transylvania_name", 100, "{#rroot}/img/icon.png", "roast_pork_a_la_transylvania");
+insert into food(idx, name_source, type, image, food_key) values (73, "fried_chicken_name", 100, "{#rroot}/img/icon.png", "fried_chicken");
+insert into food(idx, name_source, type, image, food_key) values (74, "szekely_goulash_name", 100, "{#rroot}/img/icon.png", "szekely_goulash");
+insert into food(idx, name_source, type, image, food_key) values (75, "layered_cabbage_name", 100, "{#rroot}/img/icon.png", "layered_cabbage");
+insert into food(idx, name_source, type, image, food_key) values (76, "stuffed_cabbage_name", 100, "{#rroot}/img/icon.png", "stuffed_cabbage");
+insert into food(idx, name_source, type, image, food_key) values (77, "fried_liver_name", 100, "{#rroot}/img/icon.png", "fried_liver");
+insert into food(idx, name_source, type, image, food_key) values (78, "layered_potatoes_name", 100, "{#rroot}/img/icon.png", "layered_potatoes");
+insert into food(idx, name_source, type, image, food_key) values (79, "chulent_name", 100, "{#rroot}/img/icon.png", "chulent");
+insert into food(idx, name_source, type, image, food_key) values (80, "hunters_dish_name", 100, "{#rroot}/img/icon.png", "hunters_dish");
+insert into food(idx, name_source, type, image, food_key) values (81, "chicken_with_carrot_name", 100, "{#rroot}/img/icon.png", "chicken_with_carrot");
+insert into food(idx, name_source, type, image, food_key) values (82, "fish_with_vegetables_name", 100, "{#rroot}/img/icon.png", "fish_with_vegetables");
+-- translations for food
+insert into translations(source, gb) values ("ratatouille_from_transylvania_name", "Ratatouille from Transylvania");
+insert into translations(source, gb) values ("gipsy_ratatouille_name", "Gipsy ratatouille");
+insert into translations(source, gb) values ("potato_goulash_name", "Potato goulash");
+insert into translations(source, gb) values ("mixed_stew_name", "Mixed stew");
+insert into translations(source, gb) values ("risotto_ala_transylvania_name", "Risotto a’la Transylvania");
+insert into translations(source, gb) values ("schnitzel_name", "Schnitzel");
+insert into translations(source, gb) values ("butter_fried_chicken_name", "Butter-fried chicken");
+insert into translations(source, gb) values ("meat_roasted_with_onions_name", "Meat roasted with onions");
+insert into translations(source, gb) values ("roasted_meat_ala_brasov_name", "Roasted meat a’la Braşov");
+insert into translations(source, gb) values ("meatballs_name", "Meatballs");
+insert into translations(source, gb) values ("smalls_name", "Smalls");
+insert into translations(source, gb) values ("lamb_cake_name", "Lamb-cake");
+insert into translations(source, gb) values ("grill_ala_transylvania_name", "Grill a’la Transylvania");
+insert into translations(source, gb) values ("chicken_paprikas_name", "Chicken “paprikás”");
+insert into translations(source, gb) values ("pepper_tokany_name", "Pepper “tokány”");
+insert into translations(source, gb) values ("mixed_stew_name", "Mixed stew");
+insert into translations(source, gb) values ("mushroom_paprikas_name", "Mushroom “paprikas”");
+insert into translations(source, gb) values ("roast_pork_a_la_transylvania_name", "Roast pork à la Transylvania");
+insert into translations(source, gb) values ("fried_chicken_name", "Fried chicken");
+insert into translations(source, gb) values ("szekely_goulash_name", "Székely goulash");
+insert into translations(source, gb) values ("layered_cabbage_name", "Layered cabbage");
+insert into translations(source, gb) values ("stuffed_cabbage_name", "Stuffed cabbage");
+insert into translations(source, gb) values ("fried_liver_name", "Fried liver");
+insert into translations(source, gb) values ("layered_potatoes_name", "Layered potatoes");
+insert into translations(source, gb) values ("chulent_name", "Chulent");
+insert into translations(source, gb) values ("hunters_dish_name", "Hunter’s dish");
+insert into translations(source, gb) values ("chicken_with_carrot_name", "Chicken with carrot");
+insert into translations(source, gb) values ("fish_with_vegetables_name", "Fish with vegetables");
+-- tags of ingredients to food
+insert into tags(food_id, ingredient_id) values (55, 133); -- rice / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (55, 107); -- onions / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (55, 118); -- pepper / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (55, 168); -- tomatoes / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (55, 104); -- oil / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (55, 138); -- salt / Ratatouille from Transylvania
+insert into tags(food_id, ingredient_id) values (56, 112); -- paprika / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 168); -- tomatoes / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 107); -- onions / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 23); -- cabbage / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 101); -- mushrooms / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 35); -- chicken / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 85); -- legs / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 187); -- wings / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 138); -- salt / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 118); -- pepper / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 62); -- garlic / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 149); -- smoked / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 8); -- bacon / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (56, 83); -- lard / Gipsy ratatouille
+insert into tags(food_id, ingredient_id) values (57, 125); -- potatoes / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 106); -- onion / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 143); -- sausages / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 112); -- paprika / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 46); -- csabai / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 67); -- gyulai / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 38); -- chorizo / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 97); -- meat / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 79); -- kielbasa / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 8); -- bacon / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 122); -- pork / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 118); -- pepper / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 138); -- salt / Potato goulash
+insert into tags(food_id, ingredient_id) values (57, 104); -- oil / Potato goulash
+insert into tags(food_id, ingredient_id) values (58, 13); -- beef / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 163); -- tenderloin / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 122); -- pork / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 149); -- smoked / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 8); -- bacon / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 99); -- milk / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 106); -- onion / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 60); -- flour / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 186); -- wine / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 101); -- mushrooms / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 138); -- salt / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 118); -- pepper / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 93); -- marjoram / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 48); -- cumin / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 112); -- paprika / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 104); -- oil / Mixed stew
+insert into tags(food_id, ingredient_id) values (58, 83); -- lard / Mixed stew
+insert into tags(food_id, ingredient_id) values (59, 106); -- onion / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 97); -- meat / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 133); -- rice / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 138); -- salt / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 118); -- pepper / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 176); -- vegetable / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 104); -- oil / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 35); -- chicken / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 13); -- beef / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 19); -- broth / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 181); -- water / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 101); -- mushrooms / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 25); -- carrot / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 113); -- parsley / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 30); -- celery / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 107); -- onions / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 116); -- peas / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 6); -- asparagus / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 12); -- beans / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 168); -- tomatoes / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 131); -- raisins / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 5); -- apricots / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 2); -- almonds / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 27); -- cashews / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 109); -- oregano / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 165); -- thyme / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (59, 136); -- rosemary / Risotto a’la Transylvania
+insert into tags(food_id, ingredient_id) values (60, 53); -- eggs / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 60); -- flour / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 18); -- breadcrumbs / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 97); -- meat / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 35); -- chicken / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 122); -- pork / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 102); -- neck / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 163); -- tenderloin / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 174); -- veal / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 178); -- vienna / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 138); -- salt / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 118); -- pepper / Schnitzel
+insert into tags(food_id, ingredient_id) values (60, 104); -- oil / Schnitzel
+insert into tags(food_id, ingredient_id) values (61, 35); -- chicken / Butter-fried chicken
+insert into tags(food_id, ingredient_id) values (61, 148); -- skin / Butter-fried chicken
+insert into tags(food_id, ingredient_id) values (61, 21); -- butter / Butter-fried chicken
+insert into tags(food_id, ingredient_id) values (61, 118); -- pepper / Butter-fried chicken
+insert into tags(food_id, ingredient_id) values (61, 138); -- salt / Butter-fried chicken
+insert into tags(food_id, ingredient_id) values (62, 107); -- onions / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 58); -- fillets / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 13); -- beef / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 54); -- entrecote / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 163); -- tenderloin / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 138); -- salt / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 118); -- pepper / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 104); -- oil / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (62, 112); -- paprika / Meat roasted with onions
+insert into tags(food_id, ingredient_id) values (63, 122); -- pork / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 89); -- liver / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 132); -- ribs / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 101); -- mushrooms / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 32); -- chanterelle / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 107); -- onions / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 186); -- wine / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 166); -- tomato / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 75); -- juice / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 138); -- salt / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 118); -- pepper / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 113); -- parsley / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 60); -- flour / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (63, 104); -- oil / Roasted meat a’la Braşov
+insert into tags(food_id, ingredient_id) values (64, 97); -- meat / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 122); -- pork / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 13); -- beef / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 106); -- onion / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 62); -- garlic / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 124); -- potato / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 17); -- bread / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 99); -- milk / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 52); -- egg / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 138); -- salt / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 118); -- pepper / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 25); -- carrot / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 113); -- parsley / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 49); -- dill / Meatballs
+insert into tags(food_id, ingredient_id) values (64, 18); -- breadcrumbs / Meatballs
+insert into tags(food_id, ingredient_id) values (65, 122); -- pork / Smalls
+insert into tags(food_id, ingredient_id) values (65, 13); -- beef / Smalls
+insert into tags(food_id, ingredient_id) values (65, 82); -- lamb / Smalls
+insert into tags(food_id, ingredient_id) values (65, 97); -- meat / Smalls
+insert into tags(food_id, ingredient_id) values (65, 138); -- salt / Smalls
+insert into tags(food_id, ingredient_id) values (65, 118); -- pepper / Smalls
+insert into tags(food_id, ingredient_id) values (65, 151); -- soda / Smalls
+insert into tags(food_id, ingredient_id) values (65, 86); -- lemon / Smalls
+insert into tags(food_id, ingredient_id) values (65, 75); -- juice / Smalls
+insert into tags(food_id, ingredient_id) values (65, 181); -- water / Smalls
+insert into tags(food_id, ingredient_id) values (65, 109); -- oregano / Smalls
+insert into tags(food_id, ingredient_id) values (65, 1); -- allspice / Smalls
+insert into tags(food_id, ingredient_id) values (65, 42); -- coriander / Smalls
+insert into tags(food_id, ingredient_id) values (65, 112); -- paprika / Smalls
+insert into tags(food_id, ingredient_id) values (65, 62); -- garlic / Smalls
+insert into tags(food_id, ingredient_id) values (65, 40); -- cloves / Smalls
+insert into tags(food_id, ingredient_id) values (65, 104); -- oil / Smalls
+insert into tags(food_id, ingredient_id) values (65, 179); -- vinegar / Smalls
+insert into tags(food_id, ingredient_id) values (66, 82); -- lamb / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 50); -- dough / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 89); -- liver / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 53); -- eggs / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 17); -- bread / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 99); -- milk / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 70); -- herbs / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 113); -- parsley / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 49); -- dill / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 90); -- lovage / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 93); -- marjoram / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 62); -- garlic / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 40); -- cloves / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 106); -- onion / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 138); -- salt / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 118); -- pepper / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 97); -- meat / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 77); -- kidney / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 91); -- lung / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 69); -- heart / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 153); -- spleen / Lamb-cake
+insert into tags(food_id, ingredient_id) values (66, 119); -- peritoneum / Lamb-cake
+insert into tags(food_id, ingredient_id) values (67, 122); -- pork / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 102); -- neck / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 163); -- tenderloin / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 132); -- ribs / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 97); -- meat / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 138); -- salt / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 118); -- pepper / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 83); -- lard / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 104); -- oil / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 62); -- garlic / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (67, 186); -- wine / Grill a’la Transylvania
+insert into tags(food_id, ingredient_id) values (68, 35); -- chicken / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 97); -- meat / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 187); -- wings / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 106); -- onion / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 118); -- pepper / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 138); -- salt / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 112); -- paprika / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 62); -- garlic / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 113); -- parsley / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 60); -- flour / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 183); -- whipped / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 99); -- milk / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 104); -- oil / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 83); -- lard / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 101); -- mushrooms / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 166); -- tomato / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 53); -- eggs / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (68, 181); -- water / Chicken “paprikás”
+insert into tags(food_id, ingredient_id) values (69, 122); -- pork / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 106); -- onion / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 97); -- meat / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 104); -- oil / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 118); -- pepper / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 138); -- salt / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (69, 186); -- wine / Pepper “tokány”
+insert into tags(food_id, ingredient_id) values (70, 122); -- pork / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 35); -- chicken / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 97); -- meat / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 120); -- pig / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 82); -- lamb / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 13); -- beef / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 89); -- liver / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 101); -- mushrooms / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 32); -- chanterelle / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 107); -- onions / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 104); -- oil / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 83); -- lard / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 138); -- salt / Mixed stew
+insert into tags(food_id, ingredient_id) values (70, 118); -- pepper / Mixed stew
+insert into tags(food_id, ingredient_id) values (71, 106); -- onion / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (71, 99); -- milk / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (71, 60); -- flour / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (71, 138); -- salt / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (71, 118); -- pepper / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (71, 113); -- parsley / Mushroom “paprikas”
+insert into tags(food_id, ingredient_id) values (72, 122); -- pork / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 55); -- fat / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 107); -- onions / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 147); -- shallots / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 40); -- cloves / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 62); -- garlic / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 83); -- lard / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 104); -- oil / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 138); -- salt / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (72, 118); -- pepper / Roast pork à la Transylvania
+insert into tags(food_id, ingredient_id) values (73, 35); -- chicken / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 148); -- skin / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 3); -- apple / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 107); -- onions / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 62); -- garlic / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 40); -- cloves / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 104); -- oil / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 138); -- salt / Fried chicken
+insert into tags(food_id, ingredient_id) values (73, 118); -- pepper / Fried chicken
+insert into tags(food_id, ingredient_id) values (74, 140); -- sauerkraut / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 122); -- pork / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 97); -- meat / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 55); -- fat / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 106); -- onion / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 138); -- salt / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 118); -- pepper / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 112); -- paprika / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 48); -- cumin / Székely goulash
+insert into tags(food_id, ingredient_id) values (74, 104); -- oil / Székely goulash
+insert into tags(food_id, ingredient_id) values (75, 122); -- pork / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 13); -- beef / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 106); -- onion / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 62); -- garlic / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 40); -- cloves / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 140); -- sauerkraut / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 133); -- rice / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 104); -- oil / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 112); -- paprika / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 138); -- salt / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 118); -- pepper / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 8); -- bacon / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 48); -- cumin / Layered cabbage
+insert into tags(food_id, ingredient_id) values (75, 109); -- oregano / Layered cabbage
+insert into tags(food_id, ingredient_id) values (76, 140); -- sauerkraut / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 122); -- pork / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 106); -- onion / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 133); -- rice / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 138); -- salt / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 118); -- pepper / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 143); -- sausages / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 112); -- paprika / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 149); -- smoked / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 132); -- ribs / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 80); -- knuckle / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 8); -- bacon / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 62); -- garlic / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 40); -- cloves / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (76, 48); -- cumin / Stuffed cabbage
+insert into tags(food_id, ingredient_id) values (77, 104); -- oil / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 118); -- pepper / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 138); -- salt / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 122); -- pork / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 89); -- liver / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 13); -- beef / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 82); -- lamb / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 35); -- chicken / Fried liver
+insert into tags(food_id, ingredient_id) values (77, 65); -- goose / Fried liver
+insert into tags(food_id, ingredient_id) values (78, 125); -- potatoes / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 53); -- eggs / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 33); -- cheese / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 56); -- feta / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 138); -- salt / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 118); -- pepper / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 21); -- butter / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 18); -- breadcrumbs / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 105); -- olives / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 143); -- sausages / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 112); -- paprika / Layered potatoes
+insert into tags(food_id, ingredient_id) values (78, 8); -- bacon / Layered potatoes
+insert into tags(food_id, ingredient_id) values (79, 68); -- haricot / Chulent
+insert into tags(food_id, ingredient_id) values (79, 12); -- beans / Chulent
+insert into tags(food_id, ingredient_id) values (79, 106); -- onion / Chulent
+insert into tags(food_id, ingredient_id) values (79, 60); -- flour / Chulent
+insert into tags(food_id, ingredient_id) values (79, 62); -- garlic / Chulent
+insert into tags(food_id, ingredient_id) values (79, 40); -- cloves / Chulent
+insert into tags(food_id, ingredient_id) values (79, 122); -- pork / Chulent
+insert into tags(food_id, ingredient_id) values (79, 13); -- beef / Chulent
+insert into tags(food_id, ingredient_id) values (79, 163); -- tenderloin / Chulent
+insert into tags(food_id, ingredient_id) values (79, 149); -- smoked / Chulent
+insert into tags(food_id, ingredient_id) values (79, 8); -- bacon / Chulent
+insert into tags(food_id, ingredient_id) values (79, 97); -- meat / Chulent
+insert into tags(food_id, ingredient_id) values (79, 138); -- salt / Chulent
+insert into tags(food_id, ingredient_id) values (79, 118); -- pepper / Chulent
+insert into tags(food_id, ingredient_id) values (79, 162); -- tarragon / Chulent
+insert into tags(food_id, ingredient_id) values (79, 10); -- basil / Chulent
+insert into tags(food_id, ingredient_id) values (79, 104); -- oil / Chulent
+insert into tags(food_id, ingredient_id) values (80, 97); -- meat / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 13); -- beef / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 122); -- pork / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 35); -- chicken / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 128); -- rabbit / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 26); -- carrots / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 114); -- parsnips / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 113); -- parsley / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 30); -- celery / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 76); -- kale / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 62); -- garlic / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 40); -- cloves / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 106); -- onion / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 138); -- salt / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 118); -- pepper / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 86); -- lemon / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 75); -- juice / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 60); -- flour / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 104); -- oil / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (80, 92); -- macaroni / Hunter’s dish
+insert into tags(food_id, ingredient_id) values (81, 35); -- chicken / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 25); -- carrot / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 106); -- onion / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 64); -- ginger / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 138); -- salt / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 118); -- pepper / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 104); -- oil / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 162); -- tarragon / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 179); -- vinegar / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (81, 109); -- oregano / Chicken with carrot
+insert into tags(food_id, ingredient_id) values (82, 113); -- parsley / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 135); -- roots / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 26); -- carrots / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 116); -- peas / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 106); -- onion / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 59); -- fish / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 41); -- cod / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 52); -- egg / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 21); -- butter / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 60); -- flour / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 162); -- tarragon / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 109); -- oregano / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 138); -- salt / Fish with vegetables
+insert into tags(food_id, ingredient_id) values (82, 179); -- vinegar / Fish with vegetables