-- Recipient link opt-out + report/abuse flags (MySQL)
-- Adds refusal/reporting metadata without needing to read encrypted capsule content.

ALTER TABLE capsule_recipient_links
  ADD COLUMN refused_at DATETIME NULL,
  ADD COLUMN refusal_reason VARCHAR(255) NULL,
  ADD COLUMN reported_at DATETIME NULL,
  ADD COLUMN report_category VARCHAR(80) NULL,
  ADD COLUMN report_note TEXT NULL,
  ADD COLUMN disabled_at DATETIME NULL,
  ADD KEY idx_capsule_recipient_links_disabled (disabled_at),
  ADD KEY idx_capsule_recipient_links_refused (refused_at),
  ADD KEY idx_capsule_recipient_links_reported (reported_at);

