SET NAMES utf8mb4;
CREATE TABLE IF NOT EXISTS home_layout_sections (
    section_key VARCHAR(80) NOT NULL, title VARCHAR(255) NOT NULL, section_type VARCHAR(40) NOT NULL,
    source_ref VARCHAR(120) NULL, enabled TINYINT(1) NOT NULL DEFAULT 1, sort_order INT NOT NULL DEFAULT 100,
    item_limit INT NOT NULL DEFAULT 6, style VARCHAR(40) NOT NULL DEFAULT 'list', updated_at DATETIME NOT NULL,
    PRIMARY KEY(section_key), INDEX idx_home_layout_order(enabled,sort_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS content_schedules (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, content_type VARCHAR(30) NOT NULL, content_id VARCHAR(190) NOT NULL,
    mode VARCHAR(30) NOT NULL, starts_at DATETIME NOT NULL, ends_at DATETIME NULL, started_at DATETIME NULL, ended_at DATETIME NULL,
    status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL,
    PRIMARY KEY(id), INDEX idx_schedule_due(status,starts_at,ends_at), INDEX idx_schedule_content(content_type,content_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;