-- YouTube Live Monitor migration
CREATE TABLE IF NOT EXISTS youtube_live_events (
    video_id VARCHAR(50) NOT NULL,
    title VARCHAR(500) NOT NULL,
    thumbnail VARCHAR(700) NULL,
    watch_url VARCHAR(700) NOT NULL,
    channel_id VARCHAR(100) NOT NULL,
    channel_name VARCHAR(255) NOT NULL,
    category VARCHAR(100) NOT NULL DEFAULT 'general',
    status ENUM('live','upcoming','completed') NOT NULL DEFAULT 'upcoming',
    scheduled_start_at DATETIME NULL,
    actual_start_at DATETIME NULL,
    actual_end_at DATETIME NULL,
    concurrent_viewers BIGINT NOT NULL DEFAULT 0,
    view_count BIGINT NOT NULL DEFAULT 0,
    manual_highlight TINYINT(1) NOT NULL DEFAULT 0,
    auto_highlight TINYINT(1) NOT NULL DEFAULT 0,
    is_pinned TINYINT(1) NOT NULL DEFAULT 0,
    highlight TINYINT(1) NOT NULL DEFAULT 0,
    highlight_order INT NOT NULL DEFAULT 100,
    first_seen_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL,
    PRIMARY KEY (video_id),
    INDEX idx_live_status (status, updated_at),
    INDEX idx_live_channel (channel_id, status),
    INDEX idx_live_highlight (highlight, highlight_order, updated_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;