-- 已创建 video_discovery_candidate 时执行一次。
-- MySQL 5.7+ / 8.0+

ALTER TABLE `video_discovery_candidate`
  ADD COLUMN `age_normalization_json` TEXT NULL
    COMMENT '双侧年龄画像标准化结果 JSON'
    AFTER `account_age_evidence_json`,
  ADD COLUMN `detail_verified` TINYINT NOT NULL DEFAULT 0
    COMMENT '是否已核验视频详情'
    AFTER `age_normalization_json`,
  ADD COLUMN `content_portrait_attempted` TINYINT NOT NULL DEFAULT 0
    COMMENT '是否已尝试视频点赞画像'
    AFTER `detail_verified`,
  ADD COLUMN `account_portrait_attempted` TINYINT NOT NULL DEFAULT 0
    COMMENT '是否已尝试作者粉丝画像'
    AFTER `content_portrait_attempted`,
  ADD COLUMN `age_portraits_normalized` TINYINT NOT NULL DEFAULT 0
    COMMENT '是否已执行年龄画像标准化'
    AFTER `account_portrait_attempted`,
  ADD COLUMN `content_analysis_verified` TINYINT NOT NULL DEFAULT 0
    COMMENT '是否已核验真实视频内容'
    AFTER `content_analysis`,
  ADD COLUMN `expansion_worthy_tags_json` TEXT NULL
    COMMENT '值得继续搜索的标签 JSON'
    AFTER `content_analysis_verified`;