-- Migration: Add 'Leave Request' to notifications.entityType ENUM
-- Run on existing databases after deploying leave-request notifications.

ALTER TABLE `notifications`
MODIFY COLUMN `entityType` ENUM(
  'Deviations',
  'Site Monitoring',
  'Case Investigation',
  'SDS',
  'Risk Assessment',
  'Job Safety Analysis',
  'Training',
  'Leave Request'
) NOT NULL COMMENT 'Type of task';
