playlet/sql/song/song_update_20240717.sql

CREATE TABLE `play_praise` (
                               `id` varchar(50) NOT NULL,
                               `user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
                               `play_id` varchar(50) DEFAULT NULL COMMENT '歌单id',
                               `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               PRIMARY KEY (`id`),
                               KEY `user_id_playlist_id_idx` (`user_id`,`play_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='歌单点赞表';


CREATE TABLE `song_praise` (
                               `id` varchar(50) NOT NULL,
                               `user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
                               `song_id` varchar(50) DEFAULT NULL COMMENT '歌曲id',
                               `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               PRIMARY KEY (`id`),
                               KEY `user_id_song_id_idx` (`user_id`,`song_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='歌曲点赞表';

alter table song_info
    add column amount_praise int(11) DEFAULT 0 COMMENT '点赞数';

alter table song_info
    add column amount_share int(11) DEFAULT 0 COMMENT '分享数';
alter table song_info
    add column amount_play int(11) DEFAULT 0 COMMENT '播放数';

alter table playlist
    add column amount_play_song int(11) DEFAULT 0 COMMENT '实际播放数';