-- Add confirmation token support for per-occurrence completion links
ALTER TABLE notification_history ADD COLUMN confirm_token TEXT;
ALTER TABLE notification_history ADD COLUMN confirmed_at TEXT;

CREATE UNIQUE INDEX IF NOT EXISTS ux_notification_history_confirm_token
ON notification_history(confirm_token);
