-- Links each queued/sent notification back to the decision_letter it was
-- generated from, so the appeal admin view can show accurate per-recipient
-- delivery status (queued/sent/cancelled) instead of a static "sent by
-- email" claim, and link into the Notification Queue screen to manage it.
--
-- Apply to every environment's database before deploying this change.

ALTER TABLE `notification_queue`
  ADD COLUMN `decision_letter` int(10) UNSIGNED DEFAULT NULL AFTER `notification`;
