-- Migration to add guest details fields to booking_guests table
-- Run this script on your database

ALTER TABLE booking_guests 
ADD COLUMN group_type VARCHAR(100) DEFAULT NULL COMMENT 'Type of group: Family, Friends, Business, Solo, etc.',
ADD COLUMN purpose_of_visit VARCHAR(255) DEFAULT NULL COMMENT 'Purpose: Leisure, Business, Wedding, Event, etc.';

-- Add some sample group types and purposes for reference
-- Common group types: 'Family', 'Friends', 'Business', 'Solo', 'Couple', 'Group'
-- Common purposes: 'Leisure', 'Business', 'Wedding', 'Event', 'Vacation', 'Work Travel' 