-- Adds optional CC/BCC fields to notification templates, mirroring the same
-- recipient options as the `recipient` field (student / organization_email
-- / organization_email_level_2). Neither is required.
--
-- Apply to every environment's database before deploying this change.

ALTER TABLE `notification`
  ADD COLUMN `cc` varchar(255) DEFAULT NULL AFTER `recipient`,
  ADD COLUMN `bcc` varchar(255) DEFAULT NULL AFTER `cc`;
