-- Remove tour_type field from tours table

USE tour_management;

-- Drop index first
DROP INDEX IF EXISTS idx_tour_type ON tours;

-- Remove tour_type column
ALTER TABLE tours DROP COLUMN IF EXISTS tour_type;

SELECT 'tour_type field removed successfully!' as message;