27 lines
564 B
MySQL
27 lines
564 B
MySQL
|
|
||
|
|
INSERT INTO ingredient (name, icon, price)
|
||
|
|
VALUES
|
||
|
|
('potato', 'potato.png', 399),
|
||
|
|
('tomato', 'tomato.png', 199),
|
||
|
|
('flour', 'flour.png', 050),
|
||
|
|
('water', 'waterglass.png', 005);
|
||
|
|
|
||
|
|
INSERT INTO recipe (name, icon)
|
||
|
|
VALUES
|
||
|
|
('bread', 'bread.png'),
|
||
|
|
('pizza', 'pizza.png'),
|
||
|
|
('cookie', 'cookie.png'),
|
||
|
|
('pasta', 'pasta.png');
|
||
|
|
|
||
|
|
INSERT INTO recipe_ingredient (recipe_id, ingredient_d, amount)
|
||
|
|
VALUES
|
||
|
|
(1, 1, 340),
|
||
|
|
(1, 2, 894),
|
||
|
|
(1, 3, 123),
|
||
|
|
(1, 4, 9),
|
||
|
|
(2, 2, 1),
|
||
|
|
(2, 3, 79),
|
||
|
|
(3, 1, 64),
|
||
|
|
(3, 3, 241),
|
||
|
|
(3, 2, 99);
|