-- Add email-open and letter-view tracking to the detail table
ALTER TABLE `balance_confirmation_detail`
  ADD COLUMN `email_opened`     varchar(5)  DEFAULT 'NO'  AFTER `aws_ses_msg`,
  ADD COLUMN `email_open_date`  datetime    DEFAULT NULL   AFTER `email_opened`,
  ADD COLUMN `letter_viewed`    varchar(5)  DEFAULT 'NO'  AFTER `email_open_date`,
  ADD COLUMN `letter_view_date` datetime    DEFAULT NULL   AFTER `letter_viewed`;
