ALTER TABLE reminders ADD COLUMN `status_change_time` DATETIME;

-- This is a best-guess as to the status change time.
UPDATE reminders SET `status_change_time` = `utc_time` WHERE `status` != 'pending';