-- Migration: Add Training to notifications.entityType ENUM
-- Run on existing databases after deploying the Training notification type.
-- (New installs: DATABASE_FULL_SETUP.sql already includes 'Training'.)

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