-- Update hotel_info structure to include order field
-- This is a migration file to be applied to existing database

-- Note: Since hotel_info is a JSON field, we don't need to ALTER the table structure.
-- The JSON structure will be:
-- [
--   {
--     "name": "Exclusive Hotel Sarajevo",
--     "stars": 5,
--     "nights": 1,
--     "order": 1,  -- NEW FIELD for chronological ordering
--     "location": "Saraybosna, Bosna Hersek",
--     "image": "hotel-image-url.jpg",
--     "description": "Otel açıklaması...",
--     "maps_iframe": "<iframe...>",
--     "features": ["WiFi", "Havuz", "Spa"]
--   }
-- ]

-- No SQL changes needed, just documenting the new JSON structure.
-- Admin panel and frontend will handle the order field.

SELECT 'Hotel info structure updated. Order field added to JSON schema.' AS message;
