ALTER TABLE activity_types
    ADD COLUMN background_color CHAR(7) NULL AFTER color,
    ADD COLUMN icon_color CHAR(7) NULL AFTER background_color;

UPDATE activity_types
SET background_color = CASE code
        WHEN 'APERTURA' THEN '#f4f4f4'
        WHEN 'PAUSA' THEN '#2d2d2d'
        WHEN 'CIERRE' THEN '#ffd709'
        WHEN 'PREMIACION' THEN '#3f2d10'
        WHEN 'RECORRIDA' THEN '#12351f'
        WHEN 'FIESTA' THEN '#251942'
        ELSE color
    END,
    icon_color = CASE code
        WHEN 'APERTURA' THEN '#ffd709'
        WHEN 'PAUSA' THEN '#ffd709'
        WHEN 'CIERRE' THEN '#0e0e0e'
        WHEN 'PREMIACION' THEN '#f59e0b'
        WHEN 'RECORRIDA' THEN '#43b97f'
        WHEN 'FIESTA' THEN '#a66cff'
        ELSE color
    END;

CREATE TABLE event_activity_type_styles (
    event_id CHAR(36) NOT NULL,
    activity_type VARCHAR(40) NOT NULL,
    background_color CHAR(7) NOT NULL,
    icon_color CHAR(7) NOT NULL,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (event_id, activity_type),
    CONSTRAINT fk_event_type_styles_event FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE CASCADE,
    CONSTRAINT fk_event_type_styles_type FOREIGN KEY (activity_type) REFERENCES activity_types(code) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;