-- Migration: Add COMMENT_ADDED to TTM_NOTIFICATION_LOG.NOTIFICATION_TYPE enum
-- Run this ONCE on the database to support comment notifications.
-- If TTM_NOTIFICATION_LOG doesn't exist yet, run schema.sql first.

ALTER TABLE `TTM_NOTIFICATION_LOG`
  MODIFY COLUMN `NOTIFICATION_TYPE` enum(
    'TASK_ASSIGNMENT',
    'REVIEW_PENDING',
    'WORK_APPROVED',
    'WORK_REJECTED',
    'CLARIFICATION_REQUESTED',
    'FUNCTION_COMPLETE',
    'ONE_DAY_BEFORE_DEADLINE',
    'DELAY_ALERT',
    'TRANSFER_NOTIFICATION',
    'DEACTIVATION_NOTIFICATION',
    'COMMENT_ADDED'
  ) NOT NULL;
