| 12345678910111213 |
- -- 为 work_day_statistics 表添加扩展字段的迁移脚本
- -- 执行日期: 2026-02-02
- USE media_manager;
- ALTER TABLE work_day_statistics
- ADD COLUMN impression_count INT DEFAULT 0 COMMENT '曝光数/展现量' AFTER play_count,
- ADD COLUMN rise_fans_count INT DEFAULT 0 COMMENT '涨粉数' AFTER collect_count,
- ADD COLUMN cover_click_rate VARCHAR(50) DEFAULT '0' COMMENT '封面点击率' AFTER rise_fans_count,
- ADD COLUMN avg_watch_duration VARCHAR(50) DEFAULT '0' COMMENT '平均观看时长（秒）' AFTER cover_click_rate,
- ADD COLUMN finish_rate VARCHAR(50) DEFAULT '0' COMMENT '完播率' AFTER avg_watch_duration,
- ADD COLUMN exit_view2s_rate VARCHAR(50) DEFAULT '0' COMMENT '2秒退出率' AFTER finish_rate;
|
