SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `hi-sing`.`activitys` ADD COLUMN `is_lyric` tinyint UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否是歌词' AFTER `project_id`;

ALTER TABLE `hi-sing`.`activitys` MODIFY COLUMN `lyric` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '歌词' AFTER `is_lyric`;

ALTER TABLE `hi-sing`.`project_confirmation_times` DROP INDEX `p`;

ALTER TABLE `hi-sing`.`project_confirmation_times` ADD UNIQUE INDEX `p`(`project_id` ASC, `created_at` DESC) USING BTREE;

SET FOREIGN_KEY_CHECKS=1;