ALTER TABLE ohs_incidents
    ALTER COLUMN classification TYPE VARCHAR(100);
-- The column was already VARCHAR in PostgreSQL, but this keeps compatibility
-- For MySQL, update enum options
ALTER TABLE ohs_incidents
    MODIFY COLUMN classification ENUM('injury','property_damage','environmental','near_miss','first_aid','medical_treatment','lti','fatality') NOT NULL DEFAULT 'injury';
