-- Alter emergency_reports table to add priority field
ALTER TABLE emergency_reports 
ADD COLUMN priority ENUM('low', 'medium', 'high', 'critical') DEFAULT 'medium' 
AFTER longitude; 