
UPDATE `event_registrations`
SET `status` = 'cancelled', `updated_at` = UTC_TIMESTAMP()
WHERE `status` = 'pending';

ALTER TABLE `event_registrations`
  DROP KEY `registration_reminder_index`,
  DROP COLUMN `confirmed_at`,
  DROP COLUMN `reminder_opt_in`,
  DROP COLUMN `phone`;
