-- =====================================================
-- QUICK INSERT - Food Items Only
-- Copy and paste this in Supabase SQL Editor
-- =====================================================

-- Delete existing food items (optional - uncomment if needed)
-- DELETE FROM food_items;

-- Insert all 12 food items
INSERT INTO food_items (name, category, price, prep_time, description, availability)
VALUES 
  -- BREAKFAST
  ('Masala Dosa', 'breakfast', 40.00, 15, 'Crispy dosa with potato filling', 'available'),
  ('Idli Sambar', 'breakfast', 30.00, 10, 'Steamed rice cakes with sambar', 'available'),
  ('Poha', 'breakfast', 25.00, 10, 'Flattened rice with spices', 'available'),
  
  -- LUNCH
  ('Veg Thali', 'lunch', 60.00, 20, 'Complete vegetarian meal', 'available'),
  ('Dal Rice', 'lunch', 50.00, 15, 'Lentils with steamed rice', 'available'),
  ('Chole Bhature', 'lunch', 55.00, 20, 'Chickpea curry with fried bread', 'available'),
  
  -- SNACKS
  ('Samosa', 'snacks', 15.00, 5, 'Crispy fried pastry with filling', 'available'),
  ('Vada Pav', 'snacks', 20.00, 5, 'Spiced potato fritter in bun', 'available'),
  ('Pav Bhaji', 'snacks', 45.00, 15, 'Vegetable curry with bread', 'available'),
  
  -- BEVERAGES
  ('Chai', 'beverages', 10.00, 5, 'Indian spiced tea', 'available'),
  ('Coffee', 'beverages', 15.00, 5, 'Hot filter coffee', 'available'),
  ('Cold Coffee', 'beverages', 30.00, 5, 'Chilled coffee with ice cream', 'available');

-- Verify insertion
SELECT category, COUNT(*) as count 
FROM food_items 
GROUP BY category 
ORDER BY category;
