Mercurial > thymian
view server/sql/dbs-sides.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 source
-- food list insert into food(idx, name_source, type, image, food_key) values (83, "fried_potatoes_with_dill_name", 2, "{#rroot}/img/icon.png", "fried_potatoes_with_dill"); insert into food(idx, name_source, type, image, food_key) values (84, "mashed_potatoes_name", 2, "{#rroot}/img/icon.png", "mashed_potatoes"); insert into food(idx, name_source, type, image, food_key) values (85, "potato_with_green_parsley_name", 2, "{#rroot}/img/icon.png", "potato_with_green_parsley"); insert into food(idx, name_source, type, image, food_key) values (86, "fried_potato_with_paprika_name", 2, "{#rroot}/img/icon.png", "fried_potato_with_paprika"); insert into food(idx, name_source, type, image, food_key) values (87, "pommes_frites_name", 2, "{#rroot}/img/icon.png", "pommes_frites"); insert into food(idx, name_source, type, image, food_key) values (88, "green_peas_name", 2, "{#rroot}/img/icon.png", "green_peas"); insert into food(idx, name_source, type, image, food_key) values (89, "celery_sides_name", 2, "{#rroot}/img/icon.png", "celery_sides"); insert into food(idx, name_source, type, image, food_key) values (90, "squash_name", 2, "{#rroot}/img/icon.png", "squash"); insert into food(idx, name_source, type, image, food_key) values (91, "green_beans_name", 2, "{#rroot}/img/icon.png", "green_beans"); insert into food(idx, name_source, type, image, food_key) values (92, "spinach_name", 2, "{#rroot}/img/icon.png", "spinach"); insert into food(idx, name_source, type, image, food_key) values (93, "crushed_beans_name", 2, "{#rroot}/img/icon.png", "crushed_beans"); insert into food(idx, name_source, type, image, food_key) values (94, "cabbage_name", 2, "{#rroot}/img/icon.png", "cabbage"); -- translations for food insert into translations(source, gb) values ("fried_potatoes_with_dill_name", "Fried potatoes with dill"); insert into translations(source, gb) values ("mashed_potatoes_name", "Mashed potatoes"); insert into translations(source, gb) values ("potato_with_green_parsley_name", "Potato with green parsley"); insert into translations(source, gb) values ("fried_potato_with_paprika_name", "Fried potato with paprika"); insert into translations(source, gb) values ("pommes_frites_name", "Pommes frites"); insert into translations(source, gb) values ("green_peas_name", "Green peas"); insert into translations(source, gb) values ("celery_sides_name", "Celery sides"); insert into translations(source, gb) values ("squash_name", "Squash"); insert into translations(source, gb) values ("green_beans_name", "Green beans"); insert into translations(source, gb) values ("spinach_name", "Spinach"); insert into translations(source, gb) values ("crushed_beans_name", "Crushed beans"); insert into translations(source, gb) values ("cabbage_name", "Cabbage"); -- tags of ingredients to food insert into tags(food_id, ingredient_id) values (83, 125); -- potatoes / Fried potatoes with dill insert into tags(food_id, ingredient_id) values (83, 21); -- butter / Fried potatoes with dill insert into tags(food_id, ingredient_id) values (83, 138); -- salt / Fried potatoes with dill insert into tags(food_id, ingredient_id) values (83, 118); -- pepper / Fried potatoes with dill insert into tags(food_id, ingredient_id) values (83, 49); -- dill / Fried potatoes with dill insert into tags(food_id, ingredient_id) values (84, 125); -- potatoes / Mashed potatoes insert into tags(food_id, ingredient_id) values (84, 138); -- salt / Mashed potatoes insert into tags(food_id, ingredient_id) values (84, 99); -- milk / Mashed potatoes insert into tags(food_id, ingredient_id) values (84, 21); -- butter / Mashed potatoes insert into tags(food_id, ingredient_id) values (84, 175); -- vegeta / Mashed potatoes insert into tags(food_id, ingredient_id) values (84, 104); -- oil / Mashed potatoes insert into tags(food_id, ingredient_id) values (85, 125); -- potatoes / Potato with green parsley insert into tags(food_id, ingredient_id) values (85, 21); -- butter / Potato with green parsley insert into tags(food_id, ingredient_id) values (85, 113); -- parsley / Potato with green parsley insert into tags(food_id, ingredient_id) values (85, 138); -- salt / Potato with green parsley insert into tags(food_id, ingredient_id) values (86, 106); -- onion / Fried potato with paprika insert into tags(food_id, ingredient_id) values (86, 125); -- potatoes / Fried potato with paprika insert into tags(food_id, ingredient_id) values (86, 112); -- paprika / Fried potato with paprika insert into tags(food_id, ingredient_id) values (86, 104); -- oil / Fried potato with paprika insert into tags(food_id, ingredient_id) values (87, 125); -- potatoes / Pommes frites insert into tags(food_id, ingredient_id) values (87, 104); -- oil / Pommes frites insert into tags(food_id, ingredient_id) values (88, 116); -- peas / Green peas insert into tags(food_id, ingredient_id) values (88, 104); -- oil / Green peas insert into tags(food_id, ingredient_id) values (88, 60); -- flour / Green peas insert into tags(food_id, ingredient_id) values (88, 137); -- roux / Green peas insert into tags(food_id, ingredient_id) values (88, 113); -- parsley / Green peas insert into tags(food_id, ingredient_id) values (88, 138); -- salt / Green peas insert into tags(food_id, ingredient_id) values (88, 158); -- sugar / Green peas insert into tags(food_id, ingredient_id) values (88, 179); -- vinegar / Green peas insert into tags(food_id, ingredient_id) values (88, 166); -- tomato / Green peas insert into tags(food_id, ingredient_id) values (88, 21); -- butter / Green peas insert into tags(food_id, ingredient_id) values (89, 30); -- celery / Celery sides insert into tags(food_id, ingredient_id) values (89, 21); -- butter / Celery sides insert into tags(food_id, ingredient_id) values (89, 138); -- salt / Celery sides insert into tags(food_id, ingredient_id) values (89, 162); -- tarragon / Celery sides insert into tags(food_id, ingredient_id) values (89, 113); -- parsley / Celery sides insert into tags(food_id, ingredient_id) values (90, 156); -- squashes / Squash insert into tags(food_id, ingredient_id) values (90, 191); -- zucchinis / Squash insert into tags(food_id, ingredient_id) values (90, 49); -- dill / Squash insert into tags(food_id, ingredient_id) values (90, 109); -- oregano / Squash insert into tags(food_id, ingredient_id) values (90, 179); -- vinegar / Squash insert into tags(food_id, ingredient_id) values (90, 60); -- flour / Squash insert into tags(food_id, ingredient_id) values (90, 104); -- oil / Squash insert into tags(food_id, ingredient_id) values (90, 138); -- salt / Squash insert into tags(food_id, ingredient_id) values (90, 112); -- paprika / Squash insert into tags(food_id, ingredient_id) values (91, 12); -- beans / Green beans insert into tags(food_id, ingredient_id) values (91, 106); -- onion / Green beans insert into tags(food_id, ingredient_id) values (91, 168); -- tomatoes / Green beans insert into tags(food_id, ingredient_id) values (91, 113); -- parsley / Green beans insert into tags(food_id, ingredient_id) values (91, 138); -- salt / Green beans insert into tags(food_id, ingredient_id) values (91, 158); -- sugar / Green beans insert into tags(food_id, ingredient_id) values (91, 179); -- vinegar / Green beans insert into tags(food_id, ingredient_id) values (91, 60); -- flour / Green beans insert into tags(food_id, ingredient_id) values (91, 104); -- oil / Green beans insert into tags(food_id, ingredient_id) values (91, 62); -- garlic / Green beans insert into tags(food_id, ingredient_id) values (91, 40); -- cloves / Green beans insert into tags(food_id, ingredient_id) values (91, 112); -- paprika / Green beans insert into tags(food_id, ingredient_id) values (92, 152); -- spinach / Spinach insert into tags(food_id, ingredient_id) values (92, 62); -- garlic / Spinach insert into tags(food_id, ingredient_id) values (92, 40); -- cloves / Spinach insert into tags(food_id, ingredient_id) values (92, 99); -- milk / Spinach insert into tags(food_id, ingredient_id) values (92, 21); -- butter / Spinach insert into tags(food_id, ingredient_id) values (92, 104); -- oil / Spinach insert into tags(food_id, ingredient_id) values (92, 60); -- flour / Spinach insert into tags(food_id, ingredient_id) values (92, 138); -- salt / Spinach insert into tags(food_id, ingredient_id) values (93, 12); -- beans / Crushed beans insert into tags(food_id, ingredient_id) values (93, 106); -- onion / Crushed beans insert into tags(food_id, ingredient_id) values (93, 8); -- bacon / Crushed beans insert into tags(food_id, ingredient_id) values (93, 104); -- oil / Crushed beans insert into tags(food_id, ingredient_id) values (93, 60); -- flour / Crushed beans insert into tags(food_id, ingredient_id) values (93, 138); -- salt / Crushed beans insert into tags(food_id, ingredient_id) values (93, 118); -- pepper / Crushed beans insert into tags(food_id, ingredient_id) values (93, 179); -- vinegar / Crushed beans insert into tags(food_id, ingredient_id) values (93, 113); -- parsley / Crushed beans insert into tags(food_id, ingredient_id) values (94, 23); -- cabbage / Cabbage insert into tags(food_id, ingredient_id) values (94, 106); -- onion / Cabbage insert into tags(food_id, ingredient_id) values (94, 60); -- flour / Cabbage insert into tags(food_id, ingredient_id) values (94, 104); -- oil / Cabbage insert into tags(food_id, ingredient_id) values (94, 138); -- salt / Cabbage insert into tags(food_id, ingredient_id) values (94, 118); -- pepper / Cabbage insert into tags(food_id, ingredient_id) values (94, 112); -- paprika / Cabbage insert into tags(food_id, ingredient_id) values (94, 109); -- oregano / Cabbage insert into tags(food_id, ingredient_id) values (94, 49); -- dill / Cabbage
