2023-06-12【msg】（消息推送，用户显示名字段添加）

版本

RG3.PF.Web.StartUsed 7.1.25

已更新应用

1、禅客 (20230618)

ALTER TABLE `bs_msg_chat_site` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;

ALTER TABLE `bs_msg_chat_telephone` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_chat_wechat` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;

ALTER TABLE `bs_msg_chat_wechatent` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_chat_dingtalk` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_chat_email` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;

ALTER TABLE `bs_msg_notice_site` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;

ALTER TABLE `bs_msg_notice_telephone` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_notice_wechat` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_notice_wechatent` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_notice_dingtalk` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;


ALTER TABLE `bs_msg_notice_email` 
ADD COLUMN `USER_SHOW_NAME` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户显示名称' AFTER `USER_ID`;

ALTER TABLE `bs_msg_notice_rel_target` 
CHANGE COLUMN `TYPE_ID` `TARGET_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '目标ID' AFTER `REL_ID`;