myself/sql/song/song_update_20240725.sql

create index create_time_index
    on song_info (create_time);

create index task_id_index
    on song_info (task_id);

create index created_time_index
    on fox_song (created_time);

create index start_time_index
    on fox_song_generate_log (start_time);

create index ssid_index
    on fox_song_generate_log (ssid);
CREATE TABLE `share_point` (
                               `id` int(11) NOT NULL AUTO_INCREMENT,
                               `user_id` varchar(50) DEFAULT NULL,
                               `song_id` varchar(50) DEFAULT NULL,
                               `share_type` varchar(20) DEFAULT NULL,
                               `score` int(11) DEFAULT '0' COMMENT '积分',
                               `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
                               `share_time` date DEFAULT NULL COMMENT '分享时间',
                               PRIMARY KEY (`id`),
                               KEY `user_id_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

alter table playlist
    add column owner varchar(20) COMMENT '所有者';