-- Migration: Add Risk Assessment and Job Safety Analysis to notification entity types
-- This updates the ENUM type to include the new entity types

-- For MySQL/MariaDB:
ALTER TABLE notifications 
MODIFY COLUMN entityType ENUM(
  'Deviations',
  'Site Monitoring',
  'Case Investigation',
  'SDS',
  'Risk Assessment',
  'Job Safety Analysis'
) NOT NULL COMMENT 'Type of task';

-- Note: If you're using PostgreSQL, use this instead:
-- ALTER TYPE notification_entity_type ADD VALUE 'Risk Assessment';
-- ALTER TYPE notification_entity_type ADD VALUE 'Job Safety Analysis';
