-- Account deletion request grace period fields
ALTER TABLE `users`
  ADD COLUMN `deletionRequestedAt` DATETIME(3) NULL,
  ADD COLUMN `deletionScheduledFor` DATETIME(3) NULL,
  ADD COLUMN `deletionReason` TEXT NULL;

CREATE INDEX `users_deletionScheduledFor_idx` ON `users`(`deletionScheduledFor`);