| 12345678910111213141516171819 |
- -- 为 user_day_statistics 表添加字段
- -- 执行日期: 2026-01-28
- -- MySQL 8.0.23 兼容版本
- USE media_manager;
- -- 添加基础统计字段
- ALTER TABLE user_day_statistics
- ADD COLUMN play_count INT DEFAULT 0 COMMENT '播放数' AFTER works_count,
- ADD COLUMN comment_count INT DEFAULT 0 COMMENT '评论数' AFTER play_count,
- ADD COLUMN fans_increase INT DEFAULT 0 COMMENT '涨粉数' AFTER comment_count,
- ADD COLUMN like_count INT DEFAULT 0 COMMENT '点赞数' AFTER fans_increase;
- -- 添加字符串格式的统计字段
- ALTER TABLE user_day_statistics
- ADD COLUMN cover_click_rate VARCHAR(50) DEFAULT '0' COMMENT '封面点击率' AFTER like_count,
- ADD COLUMN avg_watch_duration VARCHAR(50) DEFAULT '0' COMMENT '平均观看时长（秒）' AFTER cover_click_rate,
- ADD COLUMN total_watch_duration VARCHAR(50) DEFAULT '0' COMMENT '观看总时长（秒）' AFTER avg_watch_duration,
- ADD COLUMN completion_rate VARCHAR(50) DEFAULT '0' COMMENT '视频完播率' AFTER total_watch_duration;
|
