-- Add tour_type field to differentiate between regular tours and Umre tours

USE tour_management;

-- Add tour_type column
ALTER TABLE tours
ADD COLUMN tour_type ENUM('regular', 'umre') DEFAULT 'regular' AFTER sub_category_id;

-- Add index for filtering
CREATE INDEX idx_tour_type ONA tours(tour_type);

-- Update existing tours to be 'regular' type
UPDATE tours SET tour_type = 'regular' WHERE tour_type IS NULL;