-- Add new columns to the service_requests table for detailed case information
ALTER TABLE `service_requests`
ADD COLUMN `case_title` VARCHAR(255) NULL AFTER `email`,
ADD COLUMN `case_type` VARCHAR(100) NULL AFTER `case_title`,
ADD COLUMN `urgency` VARCHAR(50) NULL AFTER `case_type`,
ADD COLUMN `services_required` VARCHAR(255) NULL AFTER `urgency`;