-- Mess Menu Items
-- warehouse_id = 2
-- Note: This SQL assumes categories have been inserted first (run 03_mess_menu_categories.sql)
-- For items with variants (Full/Half), separate entries are created

-- Get category IDs (assuming they were inserted in order)
SET @mess_1_lunch = (SELECT id FROM restaurant_menu_categories WHERE name = 'Mess-1 Lunch' AND warehouse_id = 2 LIMIT 1);
SET @mess_1_dinner = (SELECT id FROM restaurant_menu_categories WHERE name = 'Mess-1 Dinner' AND warehouse_id = 2 LIMIT 1);
SET @mess_2_lunch = (SELECT id FROM restaurant_menu_categories WHERE name = 'Mess-2 Lunch' AND warehouse_id = 2 LIMIT 1);
SET @mess_2_dinner = (SELECT id FROM restaurant_menu_categories WHERE name = 'Mess-2 Dinner' AND warehouse_id = 2 LIMIT 1);
SET @paratha_sides = (SELECT id FROM restaurant_menu_categories WHERE name = 'Paratha & Sides' AND warehouse_id = 2 LIMIT 1);
SET @chai = (SELECT id FROM restaurant_menu_categories WHERE name = 'Chai' AND warehouse_id = 2 LIMIT 1);
SET @specialty_drinks = (SELECT id FROM restaurant_menu_categories WHERE name = 'Specialty Drinks' AND warehouse_id = 2 LIMIT 1);
SET @karahi = (SELECT id FROM restaurant_menu_categories WHERE name = 'KARAHI' AND warehouse_id = 2 LIMIT 1);
SET @handi_special = (SELECT id FROM restaurant_menu_categories WHERE name = 'HANDI Special' AND warehouse_id = 2 LIMIT 1);
SET @tawa_dish = (SELECT id FROM restaurant_menu_categories WHERE name = 'TAWA DISH' AND warehouse_id = 2 LIMIT 1);
SET @bar_bq = (SELECT id FROM restaurant_menu_categories WHERE name = 'BAR B.Q' AND warehouse_id = 2 LIMIT 1);
SET @desi_food = (SELECT id FROM restaurant_menu_categories WHERE name = 'DESI FOOD' AND warehouse_id = 2 LIMIT 1);
SET @beverages = (SELECT id FROM restaurant_menu_categories WHERE name = 'Beverages' AND warehouse_id = 2 LIMIT 1);

-- Mess-1 Lunch (7 items @ Rs. 200 each)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHICKEN QOURMA, 3 TANDOORI ROTI', 'Chicken qourma with 3 tandoori roti', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 1, NOW(), NOW()),
('DAAL MASH, 3 ROTI, RAITA, SALAD', 'Daal mash with 3 roti, raita and salad', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 2, NOW(), NOW()),
('ALOO PALAK, 3 ROTI REGULAR COLD DRINK', 'Aloo palak with 3 roti and regular cold drink', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 3, NOW(), NOW()),
('CHICKEN HALEEM, 2 KHAMIRI ROTI', 'Chicken haleem with 2 khamiri roti', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 4, NOW(), NOW()),
('CHICKEN BIRYANI, RAITA, FRUIT TRIFLE', 'Chicken biryani with raita and fruit trifle', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 5, NOW(), NOW()),
('DAAL CHANA, 3 ROTI, SALAD', 'Daal chana with 3 roti and salad', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 6, NOW(), NOW()),
('KARI PAKORA, 2 KHAMIRI ROTI', 'Kari pakora with 2 khamiri roti', 200.00, NULL, @mess_1_lunch, 'Mess-1 Lunch', 2, 1, 7, NOW(), NOW());

-- Mess-1 Dinner (7 items @ Rs. 200 each)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('DAAL MONG, 3 ROTI, SALAD, ZARDA', 'Daal mong with 3 roti, salad and zarda', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 1, NOW(), NOW()),
('CHICKEN PULAO, RAITA', 'Chicken pulao with raita', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 2, NOW(), NOW()),
('MIXED VEGETABLES, 3 ROTI', 'Mixed vegetables with 3 roti', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 3, NOW(), NOW()),
('ANDA KOFTA, 3 ROTI, SALAD', 'Anda kofta with 3 roti and salad', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 4, NOW(), NOW()),
('CHICKEN TIKKA, 2 NAAN', 'Chicken tikka with 2 naan', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 5, NOW(), NOW()),
('LAHORI CHANNEY, 2 NAAN, SALAD', 'Lahori channey with 2 naan and salad', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 6, NOW(), NOW()),
('CHICKEN ACHARI, 2 ROTI', 'Chicken achari with 2 roti', 200.00, NULL, @mess_1_dinner, 'Mess-1 Dinner', 2, 1, 7, NOW(), NOW());

-- Mess-2 Lunch (7 items @ Rs. 200 each)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('DAAL MONG, 3 ROTI, SALAD, ZARDA', 'Daal mong with 3 roti, salad and zarda', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 1, NOW(), NOW()),
('CHICKEN PULAO, RAITA', 'Chicken pulao with raita', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 2, NOW(), NOW()),
('MIXED VEGETABLES, 3 ROTI', 'Mixed vegetables with 3 roti', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 3, NOW(), NOW()),
('ANDA KOFTA, 3 ROTI, SALAD', 'Anda kofta with 3 roti and salad', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 4, NOW(), NOW()),
('CHIKEN TIKKA, 2 NAAN', 'Chicken tikka with 2 naan', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 5, NOW(), NOW()),
('LAHORI CHANNEY, 2 NAN, SALAD', 'Lahori channey with 2 naan and salad', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 6, NOW(), NOW()),
('CHICKEN ACHARI, 2 AROTI', 'Chicken achari with 2 roti', 200.00, NULL, @mess_2_lunch, 'Mess-2 Lunch', 2, 1, 7, NOW(), NOW());

-- Mess-2 Dinner (7 items @ Rs. 200 each)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHICKEN QOURMA, 3 TANDOORI ROTI', 'Chicken qourma with 3 tandoori roti', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 1, NOW(), NOW()),
('DAAL MASH, 3 ROTI, RAITA, SALAD', 'Daal mash with 3 roti, raita and salad', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 2, NOW(), NOW()),
('ALOO PALAK, 3 ROTI REGULAR COLD DRINK', 'Aloo palak with 3 roti and regular cold drink', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 3, NOW(), NOW()),
('CHICKEN HALEEM, 2 KHAMIRI ROTI', 'Chicken haleem with 2 khamiri roti', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 4, NOW(), NOW()),
('CHICKEN BIRYANI, RAITA, FRUIT TRIFLE', 'Chicken biryani with raita and fruit trifle', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 5, NOW(), NOW()),
('DAAL CHANA, 3 ROTI, SALAD', 'Daal chana with 3 roti and salad', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 6, NOW(), NOW()),
('KARI PAKORA, 2 KHAMIRI ROTI', 'Kari pakora with 2 khamiri roti', 200.00, NULL, @mess_2_dinner, 'Mess-2 Dinner', 2, 1, 7, NOW(), NOW());

-- Paratha & Sides
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('PARATHA', 'Plain paratha', 60.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 1, NOW(), NOW()),
('ALLO WALA PARATHA', 'Aloo wala paratha', 90.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 2, NOW(), NOW()),
('ANDY WALA PARATHA', 'Anda wala paratha', 100.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 3, NOW(), NOW()),
('CHICKEN PARATHA', 'Chicken paratha', 250.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 4, NOW(), NOW()),
('CHICKEN CHEESE PARATHA', 'Chicken cheese paratha', 350.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 5, NOW(), NOW()),
('ANDA FRY', 'Anda fry', 50.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 6, NOW(), NOW()),
('OMLET', 'Omelet', 80.00, NULL, @paratha_sides, 'Paratha & Sides', 2, 1, 7, NOW(), NOW());

-- Chai
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHAI', 'Regular tea', 60.00, NULL, @chai, 'Chai', 2, 1, 1, NOW(), NOW()),
('DHOOD PATI', 'Doodh pati tea', 80.00, NULL, @chai, 'Chai', 2, 1, 2, NOW(), NOW()),
('DESSI CHAI', 'Desi chai', 100.00, NULL, @chai, 'Chai', 2, 1, 3, NOW(), NOW()),
('ADRAK WALI CHAI', 'Adrak wali chai', 70.00, NULL, @chai, 'Chai', 2, 1, 4, NOW(), NOW());

-- Specialty Drinks
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Mint Margarita', 'Mint margarita', 250.00, NULL, @specialty_drinks, 'Specialty Drinks', 2, 1, 1, NOW(), NOW()),
('Fresh Lime', 'Fresh lime drink', 250.00, NULL, @specialty_drinks, 'Specialty Drinks', 2, 1, 2, NOW(), NOW());

-- KARAHI (with Full/Half variants)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Chicken Karahi - Full', 'Chicken karahi - full portion', 1700.00, NULL, @karahi, 'KARAHI', 2, 1, 1, NOW(), NOW()),
('Chicken Karahi - Half', 'Chicken karahi - half portion', 900.00, NULL, @karahi, 'KARAHI', 2, 1, 2, NOW(), NOW()),
('White Chicken Karahi - Full', 'White chicken karahi - full portion', 1800.00, NULL, @karahi, 'KARAHI', 2, 1, 3, NOW(), NOW()),
('White Chicken Karahi - Half', 'White chicken karahi - half portion', 1000.00, NULL, @karahi, 'KARAHI', 2, 1, 4, NOW(), NOW()),
('Angara Karari - Full', 'Angara karari - full portion', 1750.00, NULL, @karahi, 'KARAHI', 2, 1, 5, NOW(), NOW()),
('Angara Karari - Half', 'Angara karari - half portion', 1000.00, NULL, @karahi, 'KARAHI', 2, 1, 6, NOW(), NOW()),
('Chicken Achari - Full', 'Chicken achari - full portion', 1800.00, NULL, @karahi, 'KARAHI', 2, 1, 7, NOW(), NOW()),
('Chicken Achari - Half', 'Chicken achari - half portion', 950.00, NULL, @karahi, 'KARAHI', 2, 1, 8, NOW(), NOW()),
('Chicken Makhani - Full', 'Chicken makhani - full portion', 2400.00, NULL, @karahi, 'KARAHI', 2, 1, 9, NOW(), NOW()),
('Chicken Makhani - Half', 'Chicken makhani - half portion', 1350.00, NULL, @karahi, 'KARAHI', 2, 1, 10, NOW(), NOW()),
('Beef Karahi - Full', 'Beef karahi - full portion', 2100.00, NULL, @karahi, 'KARAHI', 2, 1, 11, NOW(), NOW()),
('Beef Karahi - Half', 'Beef karahi - half portion', 1100.00, NULL, @karahi, 'KARAHI', 2, 1, 12, NOW(), NOW()),
('Beef White Karahi - Full', 'Beef white karahi - full portion', 2300.00, NULL, @karahi, 'KARAHI', 2, 1, 13, NOW(), NOW()),
('Beef White Karahi - Half', 'Beef white karahi - half portion', 1150.00, NULL, @karahi, 'KARAHI', 2, 1, 14, NOW(), NOW()),
('Beef Makhani Karahi - Full', 'Beef makhani karahi - full portion', 2300.00, NULL, @karahi, 'KARAHI', 2, 1, 15, NOW(), NOW()),
('Beef Makhani Karahi - Half', 'Beef makhani karahi - half portion', 1150.00, NULL, @karahi, 'KARAHI', 2, 1, 16, NOW(), NOW()),
('Mutton Karahi - Full', 'Mutton karahi - full portion', 4150.00, NULL, @karahi, 'KARAHI', 2, 1, 17, NOW(), NOW()),
('Mutton Karahi - Half', 'Mutton karahi - half portion', 2200.00, NULL, @karahi, 'KARAHI', 2, 1, 18, NOW(), NOW());

-- HANDI Special
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHICKEN HANDI', 'Chicken handi', 1050.00, NULL, @handi_special, 'HANDI Special', 2, 1, 1, NOW(), NOW()),
('SPECIAL MAKHANI HANDI', 'Special makhani handi', 1150.00, NULL, @handi_special, 'HANDI Special', 2, 1, 2, NOW(), NOW()),
('WHITE BONELESS HANDI', 'White boneless handi', 1150.00, NULL, @handi_special, 'HANDI Special', 2, 1, 3, NOW(), NOW()),
('CHICKEN JELFREZI HANDI', 'Chicken jalfrezi handi', 1150.00, NULL, @handi_special, 'HANDI Special', 2, 1, 4, NOW(), NOW()),
('ACHARI HANDI', 'Achari handi', 1150.00, NULL, @handi_special, 'HANDI Special', 2, 1, 5, NOW(), NOW()),
('GINGER HANDI', 'Ginger handi', 1150.00, NULL, @handi_special, 'HANDI Special', 2, 1, 6, NOW(), NOW());

-- TAWA DISH (with Full/Half variants for some items)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('TAWA MALAI PIECE', 'Tawa malai piece', 550.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 1, NOW(), NOW()),
('CHICKEN TAWA PIECE', 'Chicken tawa piece', 550.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 2, NOW(), NOW()),
('SPECIAL TAWA PIECE', 'Special tawa piece', 550.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 3, NOW(), NOW()),
('TAWA KABAB MASALA', 'Tawa kabab masala', 650.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 4, NOW(), NOW()),
('TAWA MALAI BOTI', 'Tawa malai boti', 950.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 5, NOW(), NOW()),
('CHICKEN BOTI MASALA', 'Chicken boti masala', 650.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 6, NOW(), NOW()),
('TAWA CHICKEN KARAHI - Full', 'Tawa chicken karahi - full portion', 1700.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 7, NOW(), NOW()),
('TAWA CHICKEN KARAHI - Half', 'Tawa chicken karahi - half portion', 900.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 8, NOW(), NOW()),
('TAWA WHITE KARAHI - Full', 'Tawa white karahi - full portion', 1800.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 9, NOW(), NOW()),
('TAWA WHITE KARAHI - Half', 'Tawa white karahi - half portion', 1000.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 10, NOW(), NOW()),
('TAWA MAKHANI KARAHI - Full', 'Tawa makhani karahi - full portion', 1900.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 11, NOW(), NOW()),
('TAWA MAKHANI KARAHI - Half', 'Tawa makhani karahi - half portion', 1100.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 12, NOW(), NOW()),
('DAAL FRY', 'Daal fry', 350.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 13, NOW(), NOW()),
('SHAHI DAAL', 'Shahi daal', 300.00, NULL, @tawa_dish, 'TAWA DISH', 2, 1, 14, NOW(), NOW());

-- BAR B.Q (from third image)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHICKEN TIKKA', 'Chicken tikka', 250.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 1, NOW(), NOW()),
('MALAI BOTI', 'Malai boti', 350.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 2, NOW(), NOW()),
('CHICKEN LEG', 'Chicken leg', 320.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 3, NOW(), NOW()),
('MALAI LEG', 'Malai leg', 400.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 4, NOW(), NOW()),
('CHICKEN CHEST', 'Chicken chest', 350.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 5, NOW(), NOW()),
('MALAI CHEST', 'Malai chest', 400.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 6, NOW(), NOW()),
('CHICKEN KABAB', 'Chicken kabab', 150.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 7, NOW(), NOW()),
('BEEF KABAB', 'Beef kabab', 180.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 8, NOW(), NOW()),
('RASHMI KABAB', 'Rashmi kabab', 160.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 9, NOW(), NOW()),
('CHICKEN CHEESE', 'Chicken cheese', 180.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 10, NOW(), NOW()),
('KABAB BIRYANI', 'Kabab biryani', 350.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 11, NOW(), NOW()),
('TIKKA BIRYANI', 'Tikka biryani', 450.00, NULL, @bar_bq, 'BAR B.Q', 2, 1, 12, NOW(), NOW());

-- DESI FOOD (from third image)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('CHICKEN MASALA BIRYANI', 'Chicken masala biryani', 280.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 1, NOW(), NOW()),
('CHICKEN PULAO', 'Chicken pulao', 250.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 2, NOW(), NOW()),
('ALU QEEMA', 'Alu qeema', 250.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 3, NOW(), NOW()),
('MUTTON KALEJI', 'Mutton kaleji', 250.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 4, NOW(), NOW()),
('MIX VEGITABLE', 'Mix vegetable', 150.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 5, NOW(), NOW()),
('DAAL MASH', 'Daal mash', 150.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 6, NOW(), NOW()),
('DAAL CHANA', 'Daal chana', 150.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 7, NOW(), NOW()),
('ALU ANDAA', 'Alu andaa', 150.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 8, NOW(), NOW()),
('KARI PAKOORA', 'Kari pakoora', 150.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 9, NOW(), NOW()),
('CHICKEN QORMA', 'Chicken qorma', 250.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 10, NOW(), NOW()),
('MUTTON QORMA', 'Mutton qorma', 650.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 11, NOW(), NOW()),
('CHICKEN PALAK', 'Chicken palak', 350.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 12, NOW(), NOW()),
('RAITA', 'Raita', 100.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 13, NOW(), NOW()),
('SALAD', 'Salad', 100.00, NULL, @desi_food, 'DESI FOOD', 2, 1, 14, NOW(), NOW());

-- Beverages (from third image)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('COCA COLA', 'Coca Cola', 70.00, NULL, @beverages, 'Beverages', 2, 1, 1, NOW(), NOW()),
('7UP', '7UP', 70.00, NULL, @beverages, 'Beverages', 2, 1, 2, NOW(), NOW()),
('COCA COLA 1.5', 'Coca Cola 1.5 liter', 250.00, NULL, @beverages, 'Beverages', 2, 1, 3, NOW(), NOW()),
('WATER SMALL', 'Small water bottle', 60.00, NULL, @beverages, 'Beverages', 2, 1, 4, NOW(), NOW()),
('WATER L', 'Large water bottle', 150.00, NULL, @beverages, 'Beverages', 2, 1, 5, NOW(), NOW());

