adjust schema so registrations can be time-tracked