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 '所有者';