CREATE TABLE IF NOT EXISTS radio_schedule_slots (
    id INT AUTO_INCREMENT PRIMARY KEY,
    radio_id INT NOT NULL,
    playlist_id INT NOT NULL,
    day_of_week TINYINT NOT NULL,
    start_minute SMALLINT NOT NULL,
    end_minute SMALLINT NOT NULL,
    color VARCHAR(20) NOT NULL DEFAULT '#77d09b',
    takeover_mode VARCHAR(40) NOT NULL DEFAULT 'finish_current',
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL,
    INDEX idx_radio_day_time (radio_id, day_of_week, start_minute, end_minute),
    INDEX idx_playlist (playlist_id)
);
