-- Track one-shot reminder email for unpaid capsules (see scripts/remind_unpaid_capsules.php)

ALTER TABLE capsules
  ADD COLUMN unpaid_payment_reminder_sent_at DATETIME NULL AFTER paid_at,
  ADD KEY idx_capsules_unpaid_reminder (paid_at, deleted_at, unpaid_payment_reminder_sent_at, created_at);
