SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `hi-sing`.`activitys` MODIFY COLUMN `weight` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '权重' AFTER `send_url`;

ALTER TABLE `hi-sing`.`banners` ADD COLUMN `content` json NULL AFTER `type`;

ALTER TABLE `hi-sing`.`banners` MODIFY COLUMN `role` json NULL COMMENT '身份' AFTER `content_picture`;

ALTER TABLE `hi-sing`.`banners` MODIFY COLUMN `scope` tinyint NOT NULL DEFAULT 0 COMMENT '位置' AFTER `role`;

ALTER TABLE `hi-sing`.`banners` MODIFY COLUMN `type` tinyint UNSIGNED NULL DEFAULT 0 COMMENT '是否榜单banner 0:否 1:是' AFTER `status`;


INSERT INTO `hi-sing`.`system_config` (`creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ('12', '0', '试听权限白名单', '-BIGBAR9rPOMwCrw4hIuQ', '189', '{\"type\": \"input\"}', '用户id用英文逗号隔开  如：1,2', '1', '0', '2023-07-03 11:35:13', '2023-07-03 15:16:53', NULL);
INSERT INTO `hi-sing`.`system_config` (`creator_id`, `parent_id`, `name`, `identifier`, `content`, `expand`, `remark`, `status`, `weight`, `created_at`, `updated_at`, `deleted_at`) VALUES ( '12', '0', '试唱&试听权限白名单', 'Jy-zgPbcSXSGnvHIx8moq', '189', '{\"type\": \"input\"}', '用户id用英文逗号隔开 如：1,2', '1', '0', '2023-07-03 11:36:07', '2023-07-03 15:13:53', NULL);


SET FOREIGN_KEY_CHECKS=1;