-- Marks a notification template as a decision letter template, so multiple
-- variable decision letter templates can be offered. Generation moves from
-- the free-text decision letter compose form to an optional select on the
-- appeal status-update form (admin_form_fields['appeal']), choosing which
-- decision_letter-flagged notification to queue.
--
-- Apply to every environment's database before deploying this change.

ALTER TABLE `notification`
  ADD COLUMN `decision_letter` tinyint(1) NOT NULL DEFAULT 0 AFTER `student_file_copy`;

UPDATE `notification` SET `decision_letter` = 1 WHERE `name` = 'decision_letter_template';
