2024-04-16 23:27:14 +02:00
|
|
|
INSERT INTO Customer(name, address) VALUES
|
|
|
|
|
('Finkakor AB', 'Helsingborg'),
|
|
|
|
|
('Småbröd AB', 'Malmö'),
|
|
|
|
|
('Kaffebröd AB', 'Landskrona'),
|
|
|
|
|
('Bjudkakor AB', 'Ystad'),
|
|
|
|
|
('Kalaskakor AB', 'Trelleborg'),
|
|
|
|
|
('Partykakor AB', 'Kristianstad'),
|
|
|
|
|
('Gästkakor AB', 'Hässleholm'),
|
|
|
|
|
('Skånekakor AB', 'Perstorp');
|
|
|
|
|
|
|
|
|
|
INSERT INTO Cookie(name) VALUES
|
|
|
|
|
('Nut ring'),
|
|
|
|
|
('Nut cookie'),
|
|
|
|
|
('Amneris'),
|
|
|
|
|
('Tango'),
|
|
|
|
|
('Almond delight'),
|
|
|
|
|
('Berliner');
|
|
|
|
|
|
2024-04-17 23:19:51 +02:00
|
|
|
INSERT INTO Ingredient(ingredient_name, stock, unit) VALUES
|
2024-04-16 23:27:14 +02:00
|
|
|
('Bread crumbs', 500000, 'g'),
|
|
|
|
|
('Butter', 500000, 'g'),
|
|
|
|
|
('Chocolate', 500000, 'g'),
|
|
|
|
|
('Chopped almonds', 500000, 'g'),
|
|
|
|
|
('Cinnamon', 500000, 'g'),
|
|
|
|
|
('Egg whites', 500000, 'ml'),
|
|
|
|
|
('Eggs', 500000, 'g'),
|
|
|
|
|
('Fine-ground nuts', 500000, 'g'),
|
|
|
|
|
('Flour', 500000, 'g'),
|
|
|
|
|
('Ground, roasted nuts', 500000, 'g'),
|
|
|
|
|
('Icing sugar', 500000, 'g'),
|
|
|
|
|
('Marzipan', 500000, 'g'),
|
|
|
|
|
('Potato starch', 500000, 'g'),
|
|
|
|
|
('Roasted, chopped nuts', 500000, 'g'),
|
|
|
|
|
('Sodium bicarbonate', 500000, 'g'),
|
|
|
|
|
('Sugar', 500000, 'g'),
|
|
|
|
|
('Vanilla sugar', 500000, 'g'),
|
|
|
|
|
('Vanilla', 500000, 'g'),
|
|
|
|
|
('Wheat flour', 500000, 'g');
|
|
|
|
|
|
2024-04-17 23:19:51 +02:00
|
|
|
INSERT INTO Recipe (ingredient_name, cookie_name, amount) VALUES
|
|
|
|
|
('Butter', 'Nut ring', 450),('Flour', 'Nut ring', 450),('Icing sugar', 'Nut ring', 190),('Roasted, chopped nuts', 'Nut ring', 225),
|
|
|
|
|
('Bread crumbs', 'Nut cookie', 125),('Chocolate', 'Nut cookie', 50),('Egg whites', 'Nut cookie', 350),('Fine-ground nuts', 'Nut cookie', 750),('Ground, roasted nuts', 'Nut cookie', 625),('Sugar', 'Nut cookie', 375),
|
|
|
|
|
('Butter', 'Amneris', 250),('Eggs', 'Amneris', 250),('Marzipan', 'Amneris', 750),('Potato starch', 'Amneris', 25),('Wheat flour', 'Amneris', 25),
|
|
|
|
|
('Butter', 'Tango', 200),('Flour', 'Tango', 300),('Sodium bicarbonate', 'Tango', 4),('Sugar', 'Tango', 250),('Vanilla', 'Tango', 2),
|
|
|
|
|
('Butter', 'Almond delight', 400),('Chopped almonds', 'Almond delight', 279),('Cinnamon', 'Almond delight', 10),('Flour', 'Almond delight', 400),('Sugar', 'Almond delight', 270),
|
|
|
|
|
('Butter', 'Berliner', 250),('Chocolate', 'Berliner', 50),('Eggs', 'Berliner', 50),('Flour', 'Berliner', 350),('Icing sugar', 'Berliner', 100),('Vanilla sugar', 'Berliner', 5);
|
|
|
|
|
|
