Spaces:
Sleeping
Sleeping
File size: 11,983 Bytes
56fb0d1 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 | -- Additional Menu Items for KIIT KAFE
-- Run this script to add more food items to the database
USE kiit_kaffe_db;
-- Insert new menu items
INSERT INTO foods (name, description, price, category, image_url) VALUES
-- Beverages
('Pepsi', '400ml Cold Bottle', 40.00, 'Beverages', 'https://images.unsplash.com/photo-1624517452488-04869289c4ca?w=300&q=80'),
('Sprite', '400ml Cold Bottle', 40.00, 'Beverages', 'https://images.unsplash.com/photo-1629203851122-3726ec73a02f?w=300&q=80'),
('Fanta', '400ml Cold Bottle', 40.00, 'Beverages', 'https://images.unsplash.com/photo-1625772452859-1c03d5bf1137?w=300&q=80'),
('Mineral Water', '1L Bisleri', 20.00, 'Beverages', 'https://images.unsplash.com/photo-1560023907-5f339617ea30?w=300&q=80'),
('Fresh Lime Soda', 'Sweet & Tangy', 50.00, 'Beverages', 'https://images.unsplash.com/photo-1513558161099-b9096474a08b?w=300&q=80'),
('Mango Lassi', 'Traditional Yogurt Drink', 60.00, 'Beverages', 'https://images.unsplash.com/photo-1546173159-315724a31696?w=300&q=80'),
-- Coffee & Drinks
('Espresso', 'Single Shot', 70.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1510591509098-f4fdc6d0ff04?w=300&q=80'),
('Cappuccino', 'Espresso with Steamed Milk', 100.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1572442388796-11668a67e53d?w=300&q=80'),
('Americano', 'Black Coffee', 80.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1514432324607-a09d9b4aefdd?w=300&q=80'),
('Mocha', 'Chocolate Coffee Blend', 110.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1578314675249-a6910f80cc4e?w=300&q=80'),
('Caramel Macchiato', 'Vanilla & Caramel', 120.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1485808191679-5f8c7c8f37e9?w=300&q=80'),
('Green Tea', 'Organic Herbal', 50.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1597481499750-3e6b22637e12?w=300&q=80'),
('Hot Chocolate', 'Rich Cocoa Drink', 90.00, 'Coffee & Drinks', 'https://images.unsplash.com/photo-1544787219-7f47ccb76574?w=300&q=80'),
-- Snacks
('French Fries', 'Crispy Salted Fries', 80.00, 'Snacks', 'https://images.unsplash.com/photo-1573080496987-a199f8cd4054?w=300&q=80'),
('Veg Burger', 'Classic Veg Patty', 100.00, 'Snacks', 'https://images.unsplash.com/photo-1520072959219-c595dc870360?w=300&q=80'),
('Cheese Burger', 'Double Cheese Patty', 130.00, 'Snacks', 'https://images.unsplash.com/photo-1568901346375-23c9450c58cd?w=300&q=80'),
('Veg Momos', 'Steamed Dumplings (8pcs)', 90.00, 'Snacks', 'https://images.unsplash.com/photo-1625220194771-7ebdea0b70b9?w=300&q=80'),
('Chicken Momos', 'Steamed Dumplings (8pcs)', 120.00, 'Snacks', 'https://images.unsplash.com/photo-1534422298391-e4f8c172dddb?w=300&q=80'),
('Garlic Bread', 'Toasted with Butter', 70.00, 'Snacks', 'https://images.unsplash.com/photo-1573140247631-fa9115d713fb?w=300&q=80'),
('Nachos', 'Tortilla Chips with Salsa', 100.00, 'Snacks', 'https://images.unsplash.com/photo-1513456852971-30c0b8199d4d?w=300&q=80'),
('Spring Rolls', 'Crispy Veg Rolls', 90.00, 'Snacks', 'https://images.unsplash.com/photo-1548690312-e3b507d8c110?w=300&q=80'),
('Pasta', 'Italian White Sauce', 150.00, 'Snacks', 'https://images.unsplash.com/photo-1473093295043-cdd812d0e601?w=300&q=80'),
('Chicken Pasta', 'Creamy Alfredo', 180.00, 'Snacks', 'https://images.unsplash.com/photo-1551183053-bf91a1d81141?w=300&q=80'),
-- Desserts
('Chocolate Brownie', 'Warm with Ice Cream', 120.00, 'Desserts', 'https://images.unsplash.com/photo-1606313564200-e75d5e30476d?w=300&q=80'),
('Gulab Jamun', 'Traditional Sweet (3pcs)', 60.00, 'Desserts', 'https://images.unsplash.com/photo-1593251445173-168940875873?w=300&q=80'),
('Ice Cream Sundae', 'Chocolate/Strawberry', 100.00, 'Desserts', 'https://images.unsplash.com/photo-1563805042-7684c019e1cb?w=300&q=80'),
('Choco Lava Cake', 'Molten Chocolate Cake', 110.00, 'Desserts', 'https://images.unsplash.com/photo-1624353365286-3f8d62daad51?w=300&q=80'),
('Fruit Salad', 'Fresh Seasonal Fruits', 80.00, 'Desserts', 'https://images.unsplash.com/photo-1519915028121-7d3463d20b13?w=300&q=80'),
-- Meals
('Veg Thali', 'Complete Indian Meal', 180.00, 'Meals', 'https://images.unsplash.com/photo-1512621776951-a57141f2eefd?w=300&q=80'),
('Chicken Biryani', 'Hyderabadi Style', 200.00, 'Meals', 'https://images.unsplash.com/photo-1563379091339-03b21ab4a4f8?w=300&q=80'),
('Veg Fried Rice', 'Indo-Chinese Style', 140.00, 'Meals', 'https://images.unsplash.com/photo-1603133832894-0267195e09b5?w=300&q=80'),
('Egg Fried Rice', 'With Scrambled Eggs', 150.00, 'Meals', 'https://images.unsplash.com/photo-1603133832894-0267195e09b5?w=300&q=80'),
('Chicken Fried Rice', 'Classic Chinese', 170.00, 'Meals', 'https://images.unsplash.com/photo-1603133832894-0267195e09b5?w=300&q=80'),
('Paneer Butter Masala', 'With Naan', 180.00, 'Meals', 'https://images.unsplash.com/photo-1565557623262-b51c2513a641?w=300&q=80'),
('Butter Chicken', 'With Naan', 200.00, 'Meals', 'https://images.unsplash.com/photo-1588166524941-3bf61a9c41db?w=300&q=80');
-- Add stock for new items (starting from food_id 8)
-- Getting the max food_id first and adding stock for new items
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Pepsi' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Pepsi'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Sprite' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Sprite'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Fanta' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Fanta'));
INSERT INTO stock (food_id, quantity)
SELECT id, 25 FROM foods WHERE name = 'Mineral Water' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Mineral Water'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'Fresh Lime Soda' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Fresh Lime Soda'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Mango Lassi' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Mango Lassi'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'Espresso' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Espresso'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Cappuccino' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Cappuccino'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Americano' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Americano'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Mocha' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Mocha'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Caramel Macchiato' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Caramel Macchiato'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'Green Tea' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Green Tea'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Hot Chocolate' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Hot Chocolate'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'French Fries' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'French Fries'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Veg Burger' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Veg Burger'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Cheese Burger' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Cheese Burger'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Veg Momos' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Veg Momos'));
INSERT INTO stock (food_id, quantity)
SELECT id, 12 FROM foods WHERE name = 'Chicken Momos' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Chicken Momos'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'Garlic Bread' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Garlic Bread'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Nachos' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Nachos'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Spring Rolls' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Spring Rolls'));
INSERT INTO stock (food_id, quantity)
SELECT id, 12 FROM foods WHERE name = 'Pasta' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Pasta'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Chicken Pasta' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Chicken Pasta'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Chocolate Brownie' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Chocolate Brownie'));
INSERT INTO stock (food_id, quantity)
SELECT id, 20 FROM foods WHERE name = 'Gulab Jamun' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Gulab Jamun'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Ice Cream Sundae' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Ice Cream Sundae'));
INSERT INTO stock (food_id, quantity)
SELECT id, 12 FROM foods WHERE name = 'Choco Lava Cake' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Choco Lava Cake'));
INSERT INTO stock (food_id, quantity)
SELECT id, 15 FROM foods WHERE name = 'Fruit Salad' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Fruit Salad'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Veg Thali' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Veg Thali'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Chicken Biryani' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Chicken Biryani'));
INSERT INTO stock (food_id, quantity)
SELECT id, 12 FROM foods WHERE name = 'Veg Fried Rice' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Veg Fried Rice'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Egg Fried Rice' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Egg Fried Rice'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Chicken Fried Rice' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Chicken Fried Rice'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Paneer Butter Masala' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Paneer Butter Masala'));
INSERT INTO stock (food_id, quantity)
SELECT id, 10 FROM foods WHERE name = 'Butter Chicken' AND NOT EXISTS (SELECT 1 FROM stock WHERE food_id = (SELECT id FROM foods WHERE name = 'Butter Chicken'));
|