SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `hi-sing`.`banners` ADD COLUMN `permission` json NULL COMMENT '权限' AFTER `scope`;

ALTER TABLE `hi-sing`.`users` ADD COLUMN `register_type` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0:无，1:自行注册，2:推荐注册' AFTER `user_tag_id`;

ALTER TABLE `hi-sing`.`users` ADD COLUMN `register_remark` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' AFTER `register_type`;

ALTER TABLE `hi-sing`.`users` ADD COLUMN `inviter_id` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册邀请人' AFTER `register_remark`;

ALTER TABLE `hi-sing`.`users` MODIFY COLUMN `cover` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://hising-cdn.hikoon.com/file/20231116/vbhr3e6yk4l1700102812011wg18xstw9m.jpg' COMMENT '背景封面' AFTER `intro`;

ALTER TABLE `hi-sing`.`users` MODIFY COLUMN `business_id` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '商务id' AFTER `email`;

ALTER TABLE `hi-sing`.`users` MODIFY COLUMN `is_home` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否进入主页 0：未进入 1：已进入' AFTER `creator_id`;

ALTER TABLE `hi-sing`.`users` MODIFY COLUMN `chat_mode` tinyint NOT NULL DEFAULT 0 COMMENT '0:自主沟通  1：代理沟通' AFTER `im_status`;

ALTER TABLE `hi-sing`.`users` MODIFY COLUMN `identity` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0:游客  1：音乐人 2：经纪人 3：音乐人+经纪人' AFTER `last_login`;

SET FOREIGN_KEY_CHECKS=1;