ALTER TABLE events
    ADD COLUMN time_background_color CHAR(7) NOT NULL DEFAULT '#ffd709' AFTER day_title_color,
    ADD COLUMN time_text_color CHAR(7) NOT NULL DEFAULT '#000000' AFTER time_background_color;

UPDATE events
SET time_background_color = primary_color,
    time_text_color = text_on_primary;