-- Phase 3 idempotent seed for Crowne Plaza Riyadh RDC Hotel & Convention.
-- Supported execution path: php bin/seed.php (it also creates the admin password hash and secure QR records).

INSERT INTO hotels (public_id,code,name,short_name,city,country,country_code,currency,timezone,default_language,additional_language,status)
VALUES ('43505249594144485244433031','CP_RIYADH_RDC','Crowne Plaza Riyadh RDC Hotel & Convention','Crowne Plaza Riyadh RDC','Riyadh','Saudi Arabia','SA','SAR','Asia/Riyadh','en','ar','ACTIVE')
ON DUPLICATE KEY UPDATE name=VALUES(name),short_name=VALUES(short_name),city=VALUES(city),country=VALUES(country),currency=VALUES(currency),timezone=VALUES(timezone),default_language=VALUES(default_language),additional_language=VALUES(additional_language),status=VALUES(status);

INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'logo_path','/assets/images/hotel-logo.svg','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value),value_type=VALUES(value_type);
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'wifi_ssid','CrownePlaza_Guest','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value),value_type=VALUES(value_type);
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'wifi_password','','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value),value_type=VALUES(value_type);

INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'menu_prices_include_tax','1','BOOLEAN' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value),value_type=VALUES(value_type);

INSERT INTO tax_rates (hotel_id,code,name,rate,status)
SELECT id,'SA_VAT','Saudi VAT',15.0000,'ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE name=VALUES(name),rate=VALUES(rate),status=VALUES(status);

INSERT INTO kitchens (hotel_id,code,name,type,status)
SELECT id,'MOSAIQUE_KITCHEN','Mosaique Kitchen','RESTAURANT','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchens (hotel_id,code,name,type,status) SELECT id,'KOI_KITCHEN','KOI Kitchen','RESTAURANT','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchens (hotel_id,code,name,type,status) SELECT id,'WILDFIRE_KITCHEN','Wildfire Kitchen','RESTAURANT','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchens (hotel_id,code,name,type,status) SELECT id,'SKYLITE_KITCHEN','SkyLite Kitchen','RESTAURANT','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchens (hotel_id,code,name,type,status) SELECT id,'TEA_GARDEN_KITCHEN','Tea Garden Kitchen','RESTAURANT','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchens (hotel_id,code,name,type,status) SELECT id,'CENTRAL_ROOM_SERVICE_KITCHEN','Central Room Service Kitchen','ROOM_SERVICE','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);

INSERT INTO kitchen_stations (kitchen_id,code,name,display_order,status)
SELECT id,'HOT','Hot Kitchen',10,'ACTIVE' FROM kitchens WHERE code='MOSAIQUE_KITCHEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchen_stations (kitchen_id,code,name,display_order,status) SELECT id,'COLD','Cold Kitchen',20,'ACTIVE' FROM kitchens WHERE code='MOSAIQUE_KITCHEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchen_stations (kitchen_id,code,name,display_order,status) SELECT id,'GRILL','Grill Station',10,'ACTIVE' FROM kitchens WHERE code='WILDFIRE_KITCHEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchen_stations (kitchen_id,code,name,display_order,status) SELECT id,'BEVERAGE','Beverage Station',10,'ACTIVE' FROM kitchens WHERE code='SKYLITE_KITCHEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO kitchen_stations (kitchen_id,code,name,display_order,status) SELECT id,'DISPATCH','Dispatch',90,'ACTIVE' FROM kitchens WHERE code='CENTRAL_ROOM_SERVICE_KITCHEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);

INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'4D4F5341495155453030303031',k.id,'MOSAIQUE','Mosaique','RESTAURANT','International dining restaurant.',10,1,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='MOSAIQUE_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),type=VALUES(type),description=VALUES(description),display_order=VALUES(display_order),discoverable=VALUES(discoverable),status=VALUES(status);
INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'4B4F4930303030303030303031',k.id,'KOI','KOI','RESTAURANT','Japanese–Peruvian / Nikkei dining outlet.',20,1,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='KOI_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),description=VALUES(description),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'57494C44464952453030303031',k.id,'WILDFIRE','Wildfire','RESTAURANT','Brazilian steakhouse.',30,1,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='WILDFIRE_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),description=VALUES(description),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'534B594C495445303030303031',k.id,'SKYLITE','SkyLite Lobby Café','CAFE','Lobby café serving beverages, snacks and café items.',40,1,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='SKYLITE_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),type=VALUES(type),description=VALUES(description),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'54454147415244454E30303031',k.id,'TEA_GARDEN','Tea Garden','CAFE','Tea lounge / café.',50,1,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='TEA_GARDEN_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),type=VALUES(type),description=VALUES(description),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO restaurants (hotel_id,public_id,kitchen_id,code,name,type,description,display_order,discoverable,status)
SELECT h.id,'524F4F4D534552564943453031',k.id,'IN_ROOM_DINING','In-Room Dining','ROOM_SERVICE','Hotel room-service channel.',60,0,'ACTIVE' FROM hotels h JOIN kitchens k ON k.hotel_id=h.id AND k.code='CENTRAL_ROOM_SERVICE_KITCHEN' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE kitchen_id=VALUES(kitchen_id),name=VALUES(name),type=VALUES(type),description=VALUES(description),display_order=VALUES(display_order),discoverable=VALUES(discoverable),status=VALUES(status);

INSERT INTO restaurant_service_channels (restaurant_id,service_type,enabled)
SELECT id,'DINE_IN',1 FROM restaurants WHERE code IN ('MOSAIQUE','KOI','WILDFIRE','SKYLITE','TEA_GARDEN') AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE enabled=1;
INSERT INTO restaurant_service_channels (restaurant_id,service_type,enabled)
SELECT id,'PRE_ORDER',1 FROM restaurants WHERE code IN ('MOSAIQUE','KOI','WILDFIRE','SKYLITE','TEA_GARDEN') AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE enabled=1;
INSERT INTO restaurant_service_channels (restaurant_id,service_type,enabled)
SELECT id,'TAKEAWAY',1 FROM restaurants WHERE code IN ('MOSAIQUE','KOI','WILDFIRE','SKYLITE','TEA_GARDEN') AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE enabled=1;
INSERT INTO restaurant_service_channels (restaurant_id,service_type,enabled)
SELECT id,'ROOM_SERVICE',1 FROM restaurants WHERE code='IN_ROOM_DINING' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE enabled=1;

-- Default demo hours are intentionally editable and not represented as official hotel operating hours.
INSERT INTO restaurant_hours (restaurant_id,weekday,opens_at,closes_at,is_closed)
SELECT r.id,d.day,'06:00:00','23:00:00',0 FROM restaurants r JOIN (SELECT 1 day UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7) d WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND NOT EXISTS (SELECT 1 FROM restaurant_hours h WHERE h.restaurant_id=r.id AND h.weekday=d.day AND h.valid_from IS NULL AND h.valid_to IS NULL);

-- Demo physical tables.

INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303100000000000000','M01','Table M01',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303200000000000000','M02','Table M02',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303300000000000000','M03','Table M03',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303400000000000000','M04','Table M04',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303500000000000000','M05','Table M05',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303600000000000000','M06','Table M06',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303700000000000000','M07','Table M07',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303800000000000000','M08','Table M08',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D303900000000000000','M09','Table M09',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4D4F534D313000000000000000','M10','Table M10',4,1,4,'AVAILABLE' FROM restaurants WHERE code='MOSAIQUE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303100000000000000','K01','Table K01',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303200000000000000','K02','Table K02',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303300000000000000','K03','Table K03',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303400000000000000','K04','Table K04',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303500000000000000','K05','Table K05',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303600000000000000','K06','Table K06',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303700000000000000','K07','Table K07',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'4B4F494B303800000000000000','K08','Table K08',4,1,4,'AVAILABLE' FROM restaurants WHERE code='KOI' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303100000000000000','W01','Table W01',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303200000000000000','W02','Table W02',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303300000000000000','W03','Table W03',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303400000000000000','W04','Table W04',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303500000000000000','W05','Table W05',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303600000000000000','W06','Table W06',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303700000000000000','W07','Table W07',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'57494C57303800000000000000','W08','Table W08',4,1,4,'AVAILABLE' FROM restaurants WHERE code='WILDFIRE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303100000000000000','S01','Table S01',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303200000000000000','S02','Table S02',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303300000000000000','S03','Table S03',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303400000000000000','S04','Table S04',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303500000000000000','S05','Table S05',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'534B5953303600000000000000','S06','Table S06',4,1,4,'AVAILABLE' FROM restaurants WHERE code='SKYLITE' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303100000000000000','T01','Table T01',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303200000000000000','T02','Table T02',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303300000000000000','T03','Table T03',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303400000000000000','T04','Table T04',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303500000000000000','T05','Table T05',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO restaurant_tables (restaurant_id,public_id,code,name,capacity,minimum_capacity,maximum_capacity,status) SELECT id,'54454154303600000000000000','T06','Table T06',4,1,4,'AVAILABLE' FROM restaurants WHERE code='TEA_GARDEN' AND hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);

-- Demo rooms.

INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230310000000000','1201','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230320000000000','1202','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230330000000000','1203','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230340000000000','1204','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230350000000000','1205','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230360000000000','1206','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230370000000000','1207','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230380000000000','1208','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313230390000000000','1209','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);
INSERT INTO hotel_rooms (hotel_id,public_id,room_number,floor,status) SELECT id,'524F4F4D313231300000000000','1210','12','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE floor=VALUES(floor),status=VALUES(status);

-- Database-driven permissions and roles.
INSERT INTO permissions (code,name) VALUES
('*','All permissions'),
('hotel.manage','Manage hotel settings'),
('restaurants.view','View restaurants'),
('restaurants.manage','Manage restaurants'),
('rooms.view','View rooms'),
('rooms.manage','Manage rooms'),
('tables.view','View tables'),
('tables.manage','Manage tables'),
('qr.manage','Manage and print QR codes'),
('kitchen.view','View kitchen information'),
('reports.view','View reports')
ON DUPLICATE KEY UPDATE name=VALUES(name);

INSERT INTO roles (hotel_id,code,name)
SELECT id,'SUPER_ADMIN','Super Admin' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'HOTEL_ADMIN','Hotel Admin' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'RESTAURANT_MANAGER','Restaurant Manager' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'KITCHEN_MANAGER','Kitchen Manager' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'KITCHEN_STAFF','Kitchen Staff' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'ROOM_SERVICE_MANAGER','Room Service Manager' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'ROOM_SERVICE_STAFF','Room Service Staff' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'WAITER','Waiter' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'CASHIER','Cashier' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'BILLING_STAFF','Billing Staff' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'IT_ADMINISTRATOR','IT Administrator' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT INTO roles (hotel_id,code,name) SELECT id,'READ_ONLY_MANAGER','Read Only Manager' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name);

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN');

-- The supported PHP seed runner immediately replaces this disabled placeholder with a password_hash() value from .env.
INSERT INTO users (hotel_id,email,username,password_hash,name,status)
SELECT id,'admin@example.com','admin','__GENERATED_BY_SEED_RUNNER__','Hotel Administrator','DISABLED' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE hotel_id=VALUES(hotel_id),name=VALUES(name);

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('restaurants.view','restaurants.manage','tables.view','tables.manage','qr.manage')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='RESTAURANT_MANAGER';
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('restaurants.view','tables.view','kitchen.view')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('KITCHEN_MANAGER','KITCHEN_STAFF');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('rooms.view','restaurants.view')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('ROOM_SERVICE_MANAGER','ROOM_SERVICE_STAFF');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('restaurants.view','tables.view')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='WAITER';
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('hotel.manage','restaurants.view','restaurants.manage','rooms.view','rooms.manage','tables.view','tables.manage','qr.manage')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='IT_ADMINISTRATOR';
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r JOIN permissions p ON p.code IN ('restaurants.view','rooms.view','tables.view','reports.view')
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='READ_ONLY_MANAGER';

-- ===== PHASE 2 MENU SEED =====
-- Demo categories/items only. They are intentionally editable and are not represented as the hotel's official complete menu.
INSERT INTO permissions (code,name) VALUES ('menu.view','View menu configuration'),('menu.manage','Manage menu configuration') ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id) SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN') AND p.code IN ('menu.view','menu.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id) SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='RESTAURANT_MANAGER' AND p.code IN ('menu.view','menu.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id) SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('KITCHEN_MANAGER','KITCHEN_STAFF','ROOM_SERVICE_MANAGER','ROOM_SERVICE_STAFF','READ_ONLY_MANAGER') AND p.code='menu.view';
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'CHICKEN','Chicken','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'BEEF','Beef','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'SALMON','Salmon','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'LETTUCE','Lettuce','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'TOMATO','Tomato','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'MILK','Milk','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'COFFEE','Coffee','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'TEA','Tea','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'WHEAT','Wheat','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'EGG','Egg','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'CHOCOLATE','Chocolate','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO ingredients (hotel_id,code,name,status) SELECT id,'ORANGE','Orange','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'GLUTEN','Gluten','Contains gluten cereals.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'DAIRY','Dairy','Contains milk or dairy.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'EGG','Egg','Contains egg.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'FISH','Fish','Contains fish.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'SOY','Soy','Contains soy.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'SESAME','Sesame','Contains sesame.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO allergens (hotel_id,code,name,description,status) SELECT id,'NUTS','Tree Nuts','May contain tree nuts.','ACTIVE' FROM hotels WHERE code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),description=VALUES(description),status=VALUES(status);
INSERT INTO addons (public_id,hotel_id,tax_rate_id,code,name,price,status) SELECT '5BB5B06E2B468C1899B1BCCA8C',h.id,t.id,'EXTRA_CHEESE','Extra Cheese',8.00,'ACTIVE' FROM hotels h JOIN tax_rates t ON t.hotel_id=h.id AND t.code='SA_VAT' WHERE h.code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),price=VALUES(price),tax_rate_id=VALUES(tax_rate_id),status=VALUES(status);
INSERT INTO addons (public_id,hotel_id,tax_rate_id,code,name,price,status) SELECT 'C837C2416946F217CD6FA39C0D',h.id,t.id,'EXTRA_SAUCE','Extra Sauce',5.00,'ACTIVE' FROM hotels h JOIN tax_rates t ON t.hotel_id=h.id AND t.code='SA_VAT' WHERE h.code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),price=VALUES(price),tax_rate_id=VALUES(tax_rate_id),status=VALUES(status);
INSERT INTO addons (public_id,hotel_id,tax_rate_id,code,name,price,status) SELECT '6CC412BE391440C114ACF87254',h.id,t.id,'AVOCADO','Avocado',10.00,'ACTIVE' FROM hotels h JOIN tax_rates t ON t.hotel_id=h.id AND t.code='SA_VAT' WHERE h.code='CP_RIYADH_RDC' ON DUPLICATE KEY UPDATE name=VALUES(name),price=VALUES(price),tax_rate_id=VALUES(tax_rate_id),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '11579D3C45124E199999CAE0B3',r.id,'BREAKFAST','Breakfast',10,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '7E3868629F3D6A5C6BD04BAEA0',r.id,'STARTERS','Starters',20,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '7414AB90EC2052A4B8DE320D9E',r.id,'SOUPS','Soups',30,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '06DEF87C871A6A0AACE19D9D46',r.id,'SALADS','Salads',40,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'B56CDED60B3BBF7D4F2332F846',r.id,'MAIN_COURSE','Main Course',50,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '5D1A949143BA0177A7022EBF29',r.id,'DESSERTS','Desserts',60,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1AACAC6E79721CE5D378D8ABCB',r.id,'BEVERAGES','Beverages',70,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'C1BF48F167BA6C1D0825CB44A8',r.id,'COFFEE','Coffee',80,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1581DC211261D928C9404B7523',r.id,'TEA','Tea',90,'ACTIVE' FROM restaurants r WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '2ACD9EF0D98EAB2B0B496D7FD2',r.id,'SUSHI','Sushi',10,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '13EB48FBA3A9867E448F104DFD',r.id,'SASHIMI','Sashimi',20,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'E3B61351B8A6857EECBE1F4955',r.id,'JAPANESE','Japanese',30,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '18221DDBA90C9BC623E40AE425',r.id,'PERUVIAN','Peruvian',40,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1EA9902C23F0B70A6512CBECEA',r.id,'NIKKEI','Nikkei',50,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '042D1CDEF6CF783D9F51EAAAE8',r.id,'STARTERS','Starters',60,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '5E67F43297F9AC5CA024DE872B',r.id,'MAIN_COURSE','Main Course',70,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'A710F2A547EAD191F15144AEAE',r.id,'DESSERTS','Desserts',80,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '6607CB3082C4F46C3789DB3B60',r.id,'BEVERAGES','Beverages',90,'ACTIVE' FROM restaurants r WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1E30648C08773E13E4D74C920B',r.id,'STARTERS','Starters',10,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '01718041F4F4F2143337490017',r.id,'SALADS','Salads',20,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '80F1FA0DC0DB9F8E6293E52AB8',r.id,'SOUPS','Soups',30,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '5B3F4EF59A1E59DAB86E44D51C',r.id,'BRAZILIAN_GRILL','Brazilian Grill',40,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'A4873D591853BF5BD5D0C117EC',r.id,'STEAK','Steak',50,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '0349D554CD0FA7ED75312C3C1D',r.id,'CHICKEN','Chicken',60,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '23DE8AFB76C0A46D805B2661A0',r.id,'SEAFOOD','Seafood',70,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '4762F400FDF2C80F5176BA4F32',r.id,'SIDES','Sides',80,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '90DCCED53BDC09601A973FF26C',r.id,'DESSERTS','Desserts',90,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '31CE432DE989B60CA0AC1C67E4',r.id,'BEVERAGES','Beverages',100,'ACTIVE' FROM restaurants r WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'FC5C7E0AAC6AE07981BC209114',r.id,'COFFEE','Coffee',10,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'DC02A7E8AD4951F4D089436355',r.id,'TEA','Tea',20,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '8891430EE6054F030151FA34D3',r.id,'COLD_BEVERAGES','Cold Beverages',30,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'CAABE61AB370F43228DC923416',r.id,'FRESH_JUICE','Fresh Juice',40,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '6217DE02896783DB5110E2E33C',r.id,'PASTRIES','Pastries',50,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'C1097A333F9DE42B1B4E269969',r.id,'CAKES','Cakes',60,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'D2A02EFD286C25388F13D75641',r.id,'SANDWICHES','Sandwiches',70,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '692C8FED8C1F7E22A76F87F719',r.id,'SNACKS','Snacks',80,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '499604C15C9A5198E4CA91E4FA',r.id,'DESSERTS','Desserts',90,'ACTIVE' FROM restaurants r WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1F3C5B880C9DF929DB7F22B19F',r.id,'TEA','Tea',10,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'F8FB54A1E3F157BB437EFAD35A',r.id,'COFFEE','Coffee',20,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1CDFE11768BBE28A12EA44C2F3',r.id,'AFTERNOON_TEA','Afternoon Tea',30,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '1FBB45C55DCCCCF0613AC4D7B9',r.id,'PASTRIES','Pastries',40,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '0EB47073463E330BA567C5F990',r.id,'CAKES','Cakes',50,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'A874E974F6D6C474C914CCD700',r.id,'SANDWICHES','Sandwiches',60,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'E8BACE16859E2E6D4C178F8696',r.id,'LIGHT_MEALS','Light Meals',70,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'DC6DBEAE1AB7A588F03ECFF9BA',r.id,'DESSERTS','Desserts',80,'ACTIVE' FROM restaurants r WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '8F81CB076093BBA370B0A1ED65',r.id,'BREAKFAST','Breakfast',10,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '0279FB74E5699E405C09309342',r.id,'ALL_DAY_DINING','All Day Dining',20,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '89B18AAC59AC085DCEF9932944',r.id,'STARTERS','Starters',30,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'FB02CE063A5899D93502C24DB5',r.id,'MAIN_COURSE','Main Course',40,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '5D74E3DFF21D65287840A1C2DA',r.id,'SANDWICHES','Sandwiches',50,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '033F38984E357378AD9FCE0E52',r.id,'DESSERTS','Desserts',60,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '41E66C538AC728C02EB17560E7',r.id,'BEVERAGES','Beverages',70,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT 'BACB663090A4E6FAD0704BA6BB',r.id,'COFFEE','Coffee',80,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '61D4BCA1E44BD02A676E7C683D',r.id,'TEA','Tea',90,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO categories (public_id,restaurant_id,code,name,display_order,status) SELECT '60EC575BB4D8A26A707B950C69',r.id,'KIDS_MENU','Kids Menu',100,'ACTIVE' FROM restaurants r WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE name=VALUES(name),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '689EAA0ED2413B052254CFC9CF',r.id,c.id,t.id,'Continental Breakfast','Selection of breakfast favourites for development/testing.',85.00,620,15,15,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BREAKFAST' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '6CB0BF43FF51EA5030DD5DBED7',r.id,c.id,t.id,'Chicken Caesar Salad','Classic Caesar-style salad with grilled chicken.',68.00,510,12,12,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SALADS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '3EE460F5FDA19A63A196735557',r.id,c.id,t.id,'Grilled Chicken','Grilled chicken main course.',95.00,560,20,20,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='MAIN_COURSE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '9E98233AE705703F64B9C3FFB0',r.id,c.id,t.id,'Chocolate Cake','Chocolate cake slice.',42.00,430,5,5,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='DESSERTS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '6A498D545586674F27E1D3C3DA',r.id,c.id,t.id,'Fresh Orange Juice','Fresh orange juice.',28.00,120,4,4,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BEVERAGES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'FA7BFE0FF891E25B7C43ABC0C3',r.id,c.id,t.id,'Arabic Coffee','Traditional Arabic coffee.',24.00,30,5,5,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='COFFEE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='MOSAIQUE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '45B7E59983A29AA06B9E119794',r.id,c.id,t.id,'Salmon Sushi','Demo salmon sushi selection.',72.00,340,15,15,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SUSHI' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '321506FC7C27EDA07052C48C53',r.id,c.id,t.id,'Chicken Yakitori','Grilled chicken skewers, demo item.',78.00,420,18,18,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='JAPANESE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'CC7E18AD023F21FD8CB9C0DC3D',r.id,c.id,t.id,'Beef Teriyaki','Beef teriyaki, demo item.',110.00,650,22,22,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='MAIN_COURSE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '01FDE980DEA8FBDAA0A8ACF0F7',r.id,c.id,t.id,'Miso Soup','Miso soup.',36.00,120,8,8,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='STARTERS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '82455684194C06346ACE104379',r.id,c.id,t.id,'Mango Mochi','Mango mochi dessert.',44.00,290,5,5,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='DESSERTS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '646A37A5C55594984C64C42B92',r.id,c.id,t.id,'Green Tea','Green tea.',22.00,5,4,4,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BEVERAGES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='KOI' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '31935987ECEE3353A8D9F38379',r.id,c.id,t.id,'Grilled Beef','Brazilian-style grilled beef, demo item.',145.00,780,25,25,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BRAZILIAN_GRILL' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '4A8F32CEA6D0A1D8179D242FA0',r.id,c.id,t.id,'Chicken Skewer','Grilled chicken skewer.',82.00,460,18,18,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='CHICKEN' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '012D3DE45D333FF3A8DED02236',r.id,c.id,t.id,'Brazilian Sausage','Brazilian-style sausage, demo item.',74.00,520,15,15,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BRAZILIAN_GRILL' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '3974AC485CA0C79DA1626A336A',r.id,c.id,t.id,'Grilled Vegetables','Seasonal grilled vegetables.',38.00,210,12,12,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SIDES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '13833EC4C8D7F701E1FE65956C',r.id,c.id,t.id,'Chocolate Dessert','Chocolate dessert.',48.00,440,6,6,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='DESSERTS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'CCF3F2565C51E7E1CB6951E7AA',r.id,c.id,t.id,'Fresh Juice','Fresh juice.',30.00,130,4,4,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BEVERAGES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='WILDFIRE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'C029A15B7E66C71558A8841DC1',r.id,c.id,t.id,'Cappuccino','Espresso with steamed milk.',26.00,110,5,5,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='COFFEE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '9AFBEFCB99FDFAF960C57C01D4',r.id,c.id,t.id,'Latte','Espresso with steamed milk.',28.00,150,5,5,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='COFFEE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '6507527DC0D61E00F214FB064D',r.id,c.id,t.id,'Americano','Espresso with hot water.',22.00,15,4,4,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='COFFEE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '324E641863638FAA1D12F1AAD6',r.id,c.id,t.id,'Fresh Orange Juice','Fresh orange juice.',28.00,120,4,4,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='FRESH_JUICE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'ECD606E3A340F1DC2D954CC6E6',r.id,c.id,t.id,'Cheesecake','Cheesecake slice.',38.00,390,5,5,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='CAKES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '7D01FAEF55670E2E3EF113E8A9',r.id,c.id,t.id,'Club Sandwich','Classic club sandwich.',58.00,650,15,15,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SANDWICHES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='SKYLITE' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'D3C5520C04E17E3D9A07C72086',r.id,c.id,t.id,'Arabic Tea','Arabic tea.',22.00,10,4,4,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='TEA' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'C27221278EFF84C3575C5DFD86',r.id,c.id,t.id,'English Tea','English tea.',22.00,10,4,4,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='TEA' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '784E544537E3CD783C21B0D300',r.id,c.id,t.id,'Afternoon Tea','Demo afternoon tea set.',165.00,900,20,20,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='AFTERNOON_TEA' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'E408A0D5CA63F8163760AB6F46',r.id,c.id,t.id,'Chocolate Cake','Chocolate cake slice.',42.00,430,5,5,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='CAKES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '596747059E9B307CFFF1BC4A2A',r.id,c.id,t.id,'Croissant','Butter croissant.',24.00,280,5,5,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='PASTRIES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '89F947E0DC39B1674A0B86C907',r.id,c.id,t.id,'Sandwich','Light sandwich, demo item.',48.00,460,12,12,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SANDWICHES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='TEA_GARDEN' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '34E323769C8DCF16FFFBD742EF',r.id,c.id,t.id,'Club Sandwich','Room-service club sandwich.',65.00,680,18,18,10,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='SANDWICHES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'FB1019D0E4B8855BB45B73FDFF',r.id,c.id,t.id,'Chicken Burger','Chicken burger with accompaniments.',72.00,740,20,20,20,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='MAIN_COURSE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'FBF24EF37B182D9016623F64F1',r.id,c.id,t.id,'Caesar Salad','Caesar salad.',56.00,380,12,12,30,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='STARTERS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '989993153216A3C5B194A74771',r.id,c.id,t.id,'Margherita Pizza','Margherita pizza.',68.00,760,22,22,40,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='MAIN_COURSE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT '3BE74F365440DA72676C1FEF27',r.id,c.id,t.id,'Fruit Plate','Fresh fruit plate.',46.00,220,8,8,50,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='DESSERTS' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'A6998DC32DE56416B75FE6A159',r.id,c.id,t.id,'Coffee','Freshly brewed coffee.',24.00,20,5,5,60,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='COFFEE' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'DEE47E1E787728FFAC08F2D812',r.id,c.id,t.id,'Tea','Tea selection.',22.00,10,5,5,70,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='TEA' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_items (public_id,restaurant_id,category_id,tax_rate_id,name,description,price,calories,preparation_time,serving_time,display_order,featured,status) SELECT 'F9BA28FD75B23C11AEEFABA2DC',r.id,c.id,t.id,'Fresh Juice','Fresh juice.',30.00,130,5,5,80,0,'ACTIVE' FROM restaurants r JOIN categories c ON c.restaurant_id=r.id AND c.code='BEVERAGES' JOIN tax_rates t ON t.hotel_id=r.hotel_id AND t.code='SA_VAT' WHERE r.code='IN_ROOM_DINING' AND r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') ON DUPLICATE KEY UPDATE category_id=VALUES(category_id),tax_rate_id=VALUES(tax_rate_id),name=VALUES(name),description=VALUES(description),price=VALUES(price),calories=VALUES(calories),preparation_time=VALUES(preparation_time),serving_time=VALUES(serving_time),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'SMALL','Small',0.00,10,'ACTIVE' FROM menu_items WHERE public_id='C029A15B7E66C71558A8841DC1' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'MEDIUM','Medium',4.00,20,'ACTIVE' FROM menu_items WHERE public_id='C029A15B7E66C71558A8841DC1' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'LARGE','Large',8.00,30,'ACTIVE' FROM menu_items WHERE public_id='C029A15B7E66C71558A8841DC1' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'SMALL','Small',0.00,10,'ACTIVE' FROM menu_items WHERE public_id='A6998DC32DE56416B75FE6A159' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'MEDIUM','Medium',4.00,20,'ACTIVE' FROM menu_items WHERE public_id='A6998DC32DE56416B75FE6A159' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'LARGE','Large',8.00,30,'ACTIVE' FROM menu_items WHERE public_id='A6998DC32DE56416B75FE6A159' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'SMALL','Small',0.00,10,'ACTIVE' FROM menu_items WHERE public_id='6A498D545586674F27E1D3C3DA' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_variants (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'LARGE','Large',8.00,20,'ACTIVE' FROM menu_items WHERE public_id='6A498D545586674F27E1D3C3DA' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_flavours (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'VANILLA','Vanilla',3.00,10,'ACTIVE' FROM menu_items WHERE public_id='9AFBEFCB99FDFAF960C57C01D4' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_flavours (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'CARAMEL','Caramel',3.00,20,'ACTIVE' FROM menu_items WHERE public_id='9AFBEFCB99FDFAF960C57C01D4' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_flavours (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'VANILLA','Vanilla',3.00,10,'ACTIVE' FROM menu_items WHERE public_id='A6998DC32DE56416B75FE6A159' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO menu_item_flavours (menu_item_id,code,name,price_delta,display_order,status) SELECT id,'CHOCOLATE','Chocolate',3.00,20,'ACTIVE' FROM menu_items WHERE public_id='A6998DC32DE56416B75FE6A159' ON DUPLICATE KEY UPDATE name=VALUES(name),price_delta=VALUES(price_delta),display_order=VALUES(display_order),status=VALUES(status);
INSERT INTO availability_rules (menu_item_id,name,weekday_mask,month_mask,time_from,time_to,display_order,status) SELECT mi.id,'Breakfast Hours',0,0,'06:00:00','11:00:00',10,'ACTIVE' FROM menu_items mi WHERE mi.public_id='689EAA0ED2413B052254CFC9CF' AND NOT EXISTS (SELECT 1 FROM availability_rules ar WHERE ar.menu_item_id=mi.id AND ar.name='Breakfast Hours');
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='CHICKEN' WHERE mi.public_id='6CB0BF43FF51EA5030DD5DBED7';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='LETTUCE' WHERE mi.public_id='6CB0BF43FF51EA5030DD5DBED7';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='DAIRY' WHERE mi.public_id='6CB0BF43FF51EA5030DD5DBED7';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='EGG' WHERE mi.public_id='6CB0BF43FF51EA5030DD5DBED7';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='WHEAT' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='EGG' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='CHOCOLATE' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='GLUTEN' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='DAIRY' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='EGG' WHERE mi.public_id='9E98233AE705703F64B9C3FFB0';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='SALMON' WHERE mi.public_id='45B7E59983A29AA06B9E119794';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='FISH' WHERE mi.public_id='45B7E59983A29AA06B9E119794';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='COFFEE' WHERE mi.public_id='C029A15B7E66C71558A8841DC1';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='MILK' WHERE mi.public_id='C029A15B7E66C71558A8841DC1';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='DAIRY' WHERE mi.public_id='C029A15B7E66C71558A8841DC1';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='CHICKEN' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='WHEAT' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='EGG' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='GLUTEN' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='EGG' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='WHEAT' WHERE mi.public_id='596747059E9B307CFFF1BC4A2A';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='EGG' WHERE mi.public_id='596747059E9B307CFFF1BC4A2A';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='GLUTEN' WHERE mi.public_id='596747059E9B307CFFF1BC4A2A';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='DAIRY' WHERE mi.public_id='596747059E9B307CFFF1BC4A2A';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='EGG' WHERE mi.public_id='596747059E9B307CFFF1BC4A2A';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='CHICKEN' WHERE mi.public_id='FB1019D0E4B8855BB45B73FDFF';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='WHEAT' WHERE mi.public_id='FB1019D0E4B8855BB45B73FDFF';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='GLUTEN' WHERE mi.public_id='FB1019D0E4B8855BB45B73FDFF';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='COFFEE' WHERE mi.public_id='A6998DC32DE56416B75FE6A159';
INSERT IGNORE INTO menu_item_ingredients (menu_item_id,ingredient_id) SELECT mi.id,i.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN ingredients i ON i.hotel_id=r.hotel_id AND i.code='MILK' WHERE mi.public_id='A6998DC32DE56416B75FE6A159';
INSERT IGNORE INTO menu_item_allergens (menu_item_id,allergen_id) SELECT mi.id,a.id FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN allergens a ON a.hotel_id=r.hotel_id AND a.code='DAIRY' WHERE mi.public_id='A6998DC32DE56416B75FE6A159';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,10 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_CHEESE' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,20 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_SAUCE' WHERE mi.public_id='7D01FAEF55670E2E3EF113E8A9';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,10 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_CHEESE' WHERE mi.public_id='34E323769C8DCF16FFFBD742EF';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,20 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_SAUCE' WHERE mi.public_id='34E323769C8DCF16FFFBD742EF';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,10 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_CHEESE' WHERE mi.public_id='FB1019D0E4B8855BB45B73FDFF';
INSERT IGNORE INTO menu_item_addons (menu_item_id,addon_id,required,min_qty,max_qty,display_order) SELECT mi.id,a.id,0,0,2,20 FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id JOIN addons a ON a.hotel_id=r.hotel_id AND a.code='EXTRA_SAUCE' WHERE mi.public_id='FB1019D0E4B8855BB45B73FDFF';
INSERT INTO kitchen_routing (restaurant_id,menu_item_id,kitchen_id,station_id,priority,status) SELECT mi.restaurant_id,mi.id,r.kitchen_id,NULL,10,'ACTIVE' FROM menu_items mi JOIN restaurants r ON r.id=mi.restaurant_id WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.kitchen_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM kitchen_routing kr WHERE kr.menu_item_id=mi.id);


-- Phase 3 database-driven ordering permissions.
INSERT INTO permissions (code,name) VALUES
('orders.view','View orders'),
('orders.manage','Manage orders')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','RESTAURANT_MANAGER','ROOM_SERVICE_MANAGER')
  AND p.code IN ('orders.view','orders.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('WAITER','ROOM_SERVICE_STAFF','KITCHEN_MANAGER','READ_ONLY_MANAGER')
  AND p.code='orders.view';

-- Phase 5 room-service delivery configuration and permissions.
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'room_service_delivery_minutes','10','INTEGER' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'room_service_schedule_lead_minutes','30','INTEGER' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO permissions (code,name) VALUES
('room_service.view','View room-service delivery operations'),
('room_service.manage','Manage room-service delivery operations')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','ROOM_SERVICE_MANAGER')
  AND p.code IN ('room_service.view','room_service.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='ROOM_SERVICE_STAFF'
  AND p.code IN ('room_service.view','room_service.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='READ_ONLY_MANAGER'
  AND p.code='room_service.view';

-- Phase 6 restaurant reservation settings and permissions.
INSERT INTO reservation_settings (restaurant_id,enabled,slot_minutes,duration_minutes,turnover_minutes,hold_minutes,minimum_party_size,maximum_party_size,advance_days,max_combined_tables)
SELECT r.id,1,30,90,15,5,1,20,30,3 FROM restaurants r
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.type IN ('RESTAURANT','CAFE')
ON DUPLICATE KEY UPDATE restaurant_id=VALUES(restaurant_id);
INSERT INTO permissions (code,name) VALUES
('reservations.view','View restaurant reservations'),
('reservations.manage','Manage restaurant reservations'),
('reservations.settings','Configure reservation settings')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','RESTAURANT_MANAGER')
  AND p.code IN ('reservations.view','reservations.manage','reservations.settings');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='WAITER' AND p.code IN ('reservations.view','reservations.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('ROOM_SERVICE_MANAGER','READ_ONLY_MANAGER') AND p.code='reservations.view';

-- Phase 7 billing, payment and room-charge configuration.
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'room_charge_verification_method','STAFF_APPROVAL','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'online_payment_enabled','0','BOOLEAN' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO permissions (code,name) VALUES
('billing.view','View bills and bill allocations'),
('billing.manage','Manage bills and split allocations'),
('payments.view','View payment records'),
('payments.manage','Record and manage payments'),
('room_charge.approve','Approve or reject room-charge requests')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','CASHIER','BILLING_STAFF')
  AND p.code IN ('billing.view','billing.manage','payments.view','payments.manage','room_charge.approve');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('RESTAURANT_MANAGER','ROOM_SERVICE_MANAGER','READ_ONLY_MANAGER')
  AND p.code IN ('billing.view','payments.view');

-- Phase 8 integration architecture and permissions.
INSERT INTO permissions (code,name) VALUES
('integrations.view','View PMS, POS and ERP integration status and logs'),
('integrations.manage','Configure and operate PMS, POS and ERP integrations')
ON DUPLICATE KEY UPDATE name=VALUES(name);

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','IT_ADMINISTRATOR')
  AND p.code IN ('integrations.view','integrations.manage');

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='READ_ONLY_MANAGER' AND p.code='integrations.view';

INSERT INTO integration_connections (public_id,hotel_id,integration_type,provider,adapter_key,display_name,status,config_json)
SELECT LEFT(REPLACE(UUID(),'-',''),26),id,'PMS','MOCK','mock','Mock PMS','ACTIVE',JSON_OBJECT('mode','local_database')
FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE provider=provider;

INSERT INTO integration_connections (public_id,hotel_id,integration_type,provider,adapter_key,display_name,status,config_json)
SELECT LEFT(REPLACE(UUID(),'-',''),26),id,'POS','NONE','null','POS Integration','DISABLED',JSON_OBJECT()
FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE provider=provider;

INSERT INTO integration_connections (public_id,hotel_id,integration_type,provider,adapter_key,display_name,status,config_json)
SELECT LEFT(REPLACE(UUID(),'-',''),26),id,'ERP','NONE','null','ERP Integration','DISABLED',JSON_OBJECT()
FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE provider=provider;

INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'pms_adapter','mock','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'pos_adapter','null','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'erp_adapter','null','STRING' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO hotel_settings (hotel_id,setting_key,setting_value,value_type)
SELECT id,'pms_auto_room_session_sync','1','BOOLEAN' FROM hotels WHERE code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE setting_value=setting_value;


-- Phase 9 reporting, analytics and audit permissions.
INSERT INTO permissions (code,name) VALUES
('reports.view','View operational, sales, tax and performance reports'),
('reports.export','Export reports to CSV'),
('audit.view','View audit history and security activity')
ON DUPLICATE KEY UPDATE name=VALUES(name);

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN')
  AND p.code IN ('reports.view','reports.export','audit.view');

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='READ_ONLY_MANAGER' AND p.code IN ('reports.view','audit.view');

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code IN ('CASHIER','BILLING_STAFF') AND p.code='reports.view';

INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC')
  AND r.code='IT_ADMINISTRATOR' AND p.code='audit.view';


-- PHASE 11 DEMO ENGAGEMENT
INSERT INTO permissions (code,name) VALUES
('promotions.view','View promotions, hotel events and engagement analytics'),
('promotions.manage','Manage promotions, hotel events and waiting-time cards')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','RESTAURANT_MANAGER','ROOM_SERVICE_MANAGER') AND p.code IN ('promotions.view','promotions.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='READ_ONLY_MANAGER' AND p.code='promotions.view';

INSERT INTO promotions (public_id,hotel_id,restaurant_id,menu_item_id,title,subtitle,description,promotion_type,discount_type,discount_value,audience,start_at,end_at,weekday_mask,time_from,time_to,priority,status)
SELECT 'PH11WEEKEND000000000000001',h.id,NULL,NULL,'Weekend Dining Highlights','Discover this weekend at Crowne Plaza Riyadh RDC','Demo promotional content for development/testing. Replace with hotel-approved campaigns before production.','WEEKEND_SPECIAL','NONE',0,'ALL',NOW(),DATE_ADD(NOW(),INTERVAL 180 DAY),48,NULL,NULL,50,'ACTIVE' FROM hotels h WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE title=VALUES(title),description=VALUES(description),status=VALUES(status);
INSERT INTO hotel_events (public_id,hotel_id,restaurant_id,title,description,location,starts_at,ends_at,priority,status)
SELECT 'PH11EVENT00000000000000001',h.id,r.id,'Upcoming Hotel Dining Experience','Demo upcoming event for testing the guest waiting-time experience. Replace with an approved hotel event.','Crowne Plaza Riyadh RDC',DATE_ADD(NOW(),INTERVAL 21 DAY),DATE_ADD(DATE_ADD(NOW(),INTERVAL 21 DAY),INTERVAL 3 HOUR),50,'ACTIVE' FROM hotels h LEFT JOIN restaurants r ON r.hotel_id=h.id AND r.code='WILDFIRE' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE title=VALUES(title),starts_at=VALUES(starts_at),status=VALUES(status);
INSERT INTO engagement_cards (public_id,hotel_id,promotion_id,event_id,restaurant_id,title,body,audience,min_wait_minutes,max_wait_minutes,cta_label,cta_type,display_order,status)
SELECT 'PH11CARDWKND00000000000001',h.id,p.id,NULL,NULL,NULL,NULL,'ROOM_GUESTS',5,NULL,'Discover','LOCAL_URL',10,'ACTIVE' FROM hotels h JOIN promotions p ON p.hotel_id=h.id AND p.public_id='PH11WEEKEND000000000000001' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE status=VALUES(status);
UPDATE engagement_cards SET cta_url='/reservations' WHERE public_id='PH11CARDWKND00000000000001';
INSERT INTO engagement_cards (public_id,hotel_id,promotion_id,event_id,restaurant_id,title,body,audience,min_wait_minutes,max_wait_minutes,cta_label,cta_type,display_order,status)
SELECT 'PH11CARDEVT000000000000001',h.id,NULL,e.id,e.restaurant_id,NULL,NULL,'ROOM_GUESTS',8,NULL,'Reserve a table','RESERVATION',20,'ACTIVE' FROM hotels h JOIN hotel_events e ON e.hotel_id=h.id AND e.public_id='PH11EVENT00000000000000001' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE status=VALUES(status);


-- Demo special dish engagement. Display-only promotion; it does not alter billing totals automatically.
INSERT INTO promotions (public_id,hotel_id,restaurant_id,menu_item_id,title,subtitle,description,promotion_type,discount_type,discount_value,audience,start_at,end_at,weekday_mask,priority,status)
SELECT 'PH11SPECIALDISH00000000001',h.id,r.id,mi.id,'Today''s Featured Dish','A suggestion while you wait','Demo special-dish promotion for development/testing. Replace with a hotel-approved promotion before production.','SPECIAL_DISH','NONE',0,'DINE_IN',NOW(),DATE_ADD(NOW(),INTERVAL 180 DAY),0,30,'ACTIVE'
FROM hotels h JOIN restaurants r ON r.hotel_id=h.id AND r.code='MOSAIQUE' JOIN menu_items mi ON mi.restaurant_id=r.id AND mi.name='Chocolate Cake' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE restaurant_id=VALUES(restaurant_id),menu_item_id=VALUES(menu_item_id),title=VALUES(title),status=VALUES(status);
INSERT INTO engagement_cards (public_id,hotel_id,promotion_id,event_id,restaurant_id,title,body,audience,min_wait_minutes,max_wait_minutes,cta_label,cta_type,display_order,status)
SELECT 'PH11CARDSPECIAL00000000001',h.id,p.id,NULL,p.restaurant_id,NULL,NULL,'DINE_IN',3,NULL,'View dish','MENU_ITEM',5,'ACTIVE'
FROM hotels h JOIN promotions p ON p.hotel_id=h.id AND p.public_id='PH11SPECIALDISH00000000001' WHERE h.code='CP_RIYADH_RDC'
ON DUPLICATE KEY UPDATE promotion_id=VALUES(promotion_id),restaurant_id=VALUES(restaurant_id),status=VALUES(status);

-- Phase 12 commercial licensing permissions. No license is seeded; production requires a vendor-signed license.
INSERT INTO permissions (code,name) VALUES
('license.view','View software license and deployment identity'),
('license.manage','Install and manage software license')
ON DUPLICATE KEY UPDATE name=VALUES(name);
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code IN ('SUPER_ADMIN','HOTEL_ADMIN','IT_ADMINISTRATOR') AND p.code IN ('license.view','license.manage');
INSERT IGNORE INTO role_permissions (role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.hotel_id=(SELECT id FROM hotels WHERE code='CP_RIYADH_RDC') AND r.code='READ_ONLY_MANAGER' AND p.code='license.view';