Mercurial > thymian

comparison server/sql/dbs-sides.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 (83, "fried_potatoes_with_dill_name", 2, "{#rroot}/img/icon.png", "fried_potatoes_with_dill");
3 insert into food(idx, name_source, type, image, food_key) values (84, "mashed_potatoes_name", 2, "{#rroot}/img/icon.png", "mashed_potatoes");
4 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");
5 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");
6 insert into food(idx, name_source, type, image, food_key) values (87, "pommes_frites_name", 2, "{#rroot}/img/icon.png", "pommes_frites");
7 insert into food(idx, name_source, type, image, food_key) values (88, "green_peas_name", 2, "{#rroot}/img/icon.png", "green_peas");
8 insert into food(idx, name_source, type, image, food_key) values (89, "celery_sides_name", 2, "{#rroot}/img/icon.png", "celery_sides");
9 insert into food(idx, name_source, type, image, food_key) values (90, "squash_name", 2, "{#rroot}/img/icon.png", "squash");
10 insert into food(idx, name_source, type, image, food_key) values (91, "green_beans_name", 2, "{#rroot}/img/icon.png", "green_beans");
11 insert into food(idx, name_source, type, image, food_key) values (92, "spinach_name", 2, "{#rroot}/img/icon.png", "spinach");
12 insert into food(idx, name_source, type, image, food_key) values (93, "crushed_beans_name", 2, "{#rroot}/img/icon.png", "crushed_beans");
13 insert into food(idx, name_source, type, image, food_key) values (94, "cabbage_name", 2, "{#rroot}/img/icon.png", "cabbage");
14 -- translations for food
15 insert into translations(source, gb) values ("fried_potatoes_with_dill_name", "Fried potatoes with dill");
16 insert into translations(source, gb) values ("mashed_potatoes_name", "Mashed potatoes");
17 insert into translations(source, gb) values ("potato_with_green_parsley_name", "Potato with green parsley");
18 insert into translations(source, gb) values ("fried_potato_with_paprika_name", "Fried potato with paprika");
19 insert into translations(source, gb) values ("pommes_frites_name", "Pommes frites");
20 insert into translations(source, gb) values ("green_peas_name", "Green peas");
21 insert into translations(source, gb) values ("celery_sides_name", "Celery sides");
22 insert into translations(source, gb) values ("squash_name", "Squash");
23 insert into translations(source, gb) values ("green_beans_name", "Green beans");
24 insert into translations(source, gb) values ("spinach_name", "Spinach");
25 insert into translations(source, gb) values ("crushed_beans_name", "Crushed beans");
26 insert into translations(source, gb) values ("cabbage_name", "Cabbage");
27 -- tags of ingredients to food
28 insert into tags(food_id, ingredient_id) values (83, 125); -- potatoes / Fried potatoes with dill
29 insert into tags(food_id, ingredient_id) values (83, 21); -- butter / Fried potatoes with dill
30 insert into tags(food_id, ingredient_id) values (83, 138); -- salt / Fried potatoes with dill
31 insert into tags(food_id, ingredient_id) values (83, 118); -- pepper / Fried potatoes with dill
32 insert into tags(food_id, ingredient_id) values (83, 49); -- dill / Fried potatoes with dill
33 insert into tags(food_id, ingredient_id) values (84, 125); -- potatoes / Mashed potatoes
34 insert into tags(food_id, ingredient_id) values (84, 138); -- salt / Mashed potatoes
35 insert into tags(food_id, ingredient_id) values (84, 99); -- milk / Mashed potatoes
36 insert into tags(food_id, ingredient_id) values (84, 21); -- butter / Mashed potatoes
37 insert into tags(food_id, ingredient_id) values (84, 175); -- vegeta / Mashed potatoes
38 insert into tags(food_id, ingredient_id) values (84, 104); -- oil / Mashed potatoes
39 insert into tags(food_id, ingredient_id) values (85, 125); -- potatoes / Potato with green parsley
40 insert into tags(food_id, ingredient_id) values (85, 21); -- butter / Potato with green parsley
41 insert into tags(food_id, ingredient_id) values (85, 113); -- parsley / Potato with green parsley
42 insert into tags(food_id, ingredient_id) values (85, 138); -- salt / Potato with green parsley
43 insert into tags(food_id, ingredient_id) values (86, 106); -- onion / Fried potato with paprika
44 insert into tags(food_id, ingredient_id) values (86, 125); -- potatoes / Fried potato with paprika
45 insert into tags(food_id, ingredient_id) values (86, 112); -- paprika / Fried potato with paprika
46 insert into tags(food_id, ingredient_id) values (86, 104); -- oil / Fried potato with paprika
47 insert into tags(food_id, ingredient_id) values (87, 125); -- potatoes / Pommes frites
48 insert into tags(food_id, ingredient_id) values (87, 104); -- oil / Pommes frites
49 insert into tags(food_id, ingredient_id) values (88, 116); -- peas / Green peas
50 insert into tags(food_id, ingredient_id) values (88, 104); -- oil / Green peas
51 insert into tags(food_id, ingredient_id) values (88, 60); -- flour / Green peas
52 insert into tags(food_id, ingredient_id) values (88, 137); -- roux / Green peas
53 insert into tags(food_id, ingredient_id) values (88, 113); -- parsley / Green peas
54 insert into tags(food_id, ingredient_id) values (88, 138); -- salt / Green peas
55 insert into tags(food_id, ingredient_id) values (88, 158); -- sugar / Green peas
56 insert into tags(food_id, ingredient_id) values (88, 179); -- vinegar / Green peas
57 insert into tags(food_id, ingredient_id) values (88, 166); -- tomato / Green peas
58 insert into tags(food_id, ingredient_id) values (88, 21); -- butter / Green peas
59 insert into tags(food_id, ingredient_id) values (89, 30); -- celery / Celery sides
60 insert into tags(food_id, ingredient_id) values (89, 21); -- butter / Celery sides
61 insert into tags(food_id, ingredient_id) values (89, 138); -- salt / Celery sides
62 insert into tags(food_id, ingredient_id) values (89, 162); -- tarragon / Celery sides
63 insert into tags(food_id, ingredient_id) values (89, 113); -- parsley / Celery sides
64 insert into tags(food_id, ingredient_id) values (90, 156); -- squashes / Squash
65 insert into tags(food_id, ingredient_id) values (90, 191); -- zucchinis / Squash
66 insert into tags(food_id, ingredient_id) values (90, 49); -- dill / Squash
67 insert into tags(food_id, ingredient_id) values (90, 109); -- oregano / Squash
68 insert into tags(food_id, ingredient_id) values (90, 179); -- vinegar / Squash
69 insert into tags(food_id, ingredient_id) values (90, 60); -- flour / Squash
70 insert into tags(food_id, ingredient_id) values (90, 104); -- oil / Squash
71 insert into tags(food_id, ingredient_id) values (90, 138); -- salt / Squash
72 insert into tags(food_id, ingredient_id) values (90, 112); -- paprika / Squash
73 insert into tags(food_id, ingredient_id) values (91, 12); -- beans / Green beans
74 insert into tags(food_id, ingredient_id) values (91, 106); -- onion / Green beans
75 insert into tags(food_id, ingredient_id) values (91, 168); -- tomatoes / Green beans
76 insert into tags(food_id, ingredient_id) values (91, 113); -- parsley / Green beans
77 insert into tags(food_id, ingredient_id) values (91, 138); -- salt / Green beans
78 insert into tags(food_id, ingredient_id) values (91, 158); -- sugar / Green beans
79 insert into tags(food_id, ingredient_id) values (91, 179); -- vinegar / Green beans
80 insert into tags(food_id, ingredient_id) values (91, 60); -- flour / Green beans
81 insert into tags(food_id, ingredient_id) values (91, 104); -- oil / Green beans
82 insert into tags(food_id, ingredient_id) values (91, 62); -- garlic / Green beans
83 insert into tags(food_id, ingredient_id) values (91, 40); -- cloves / Green beans
84 insert into tags(food_id, ingredient_id) values (91, 112); -- paprika / Green beans
85 insert into tags(food_id, ingredient_id) values (92, 152); -- spinach / Spinach
86 insert into tags(food_id, ingredient_id) values (92, 62); -- garlic / Spinach
87 insert into tags(food_id, ingredient_id) values (92, 40); -- cloves / Spinach
88 insert into tags(food_id, ingredient_id) values (92, 99); -- milk / Spinach
89 insert into tags(food_id, ingredient_id) values (92, 21); -- butter / Spinach
90 insert into tags(food_id, ingredient_id) values (92, 104); -- oil / Spinach
91 insert into tags(food_id, ingredient_id) values (92, 60); -- flour / Spinach
92 insert into tags(food_id, ingredient_id) values (92, 138); -- salt / Spinach
93 insert into tags(food_id, ingredient_id) values (93, 12); -- beans / Crushed beans
94 insert into tags(food_id, ingredient_id) values (93, 106); -- onion / Crushed beans
95 insert into tags(food_id, ingredient_id) values (93, 8); -- bacon / Crushed beans
96 insert into tags(food_id, ingredient_id) values (93, 104); -- oil / Crushed beans
97 insert into tags(food_id, ingredient_id) values (93, 60); -- flour / Crushed beans
98 insert into tags(food_id, ingredient_id) values (93, 138); -- salt / Crushed beans
99 insert into tags(food_id, ingredient_id) values (93, 118); -- pepper / Crushed beans
100 insert into tags(food_id, ingredient_id) values (93, 179); -- vinegar / Crushed beans
101 insert into tags(food_id, ingredient_id) values (93, 113); -- parsley / Crushed beans
102 insert into tags(food_id, ingredient_id) values (94, 23); -- cabbage / Cabbage
103 insert into tags(food_id, ingredient_id) values (94, 106); -- onion / Cabbage
104 insert into tags(food_id, ingredient_id) values (94, 60); -- flour / Cabbage
105 insert into tags(food_id, ingredient_id) values (94, 104); -- oil / Cabbage
106 insert into tags(food_id, ingredient_id) values (94, 138); -- salt / Cabbage
107 insert into tags(food_id, ingredient_id) values (94, 118); -- pepper / Cabbage
108 insert into tags(food_id, ingredient_id) values (94, 112); -- paprika / Cabbage
109 insert into tags(food_id, ingredient_id) values (94, 109); -- oregano / Cabbage
110 insert into tags(food_id, ingredient_id) values (94, 49); -- dill / Cabbage