2023-06-11【msg】（消息推送msg）

版本

RG3.PF.Web.StartUsed 7.1.25

已更新应用

1、禅客 (20230618)

全站推送和目标

ALTER TABLE `bs_msg_chat` 
ADD COLUMN `IS_ALL_USER` int NULL DEFAULT '0' COMMENT '全站用户',
ADD COLUMN `IS_ALL_TARGET` int NULL DEFAULT '0' COMMENT '全站目标';

ALTER TABLE `bs_msg_notice` 
ADD COLUMN `IS_ALL_USER` int NULL DEFAULT '0' COMMENT '全站用户' ,
ADD COLUMN `IS_ALL_TARGET` int NULL DEFAULT '0' COMMENT '全站目标' ;

ALTER TABLE `bs_msg_target`
ADD UNIQUE INDEX `idx_uq_bs_msg_target_type_code`(`TYPE_CODE`) USING BTREE;

入库数据

INSERT INTO `bs_msg_target` VALUES ('4188242370304675841', '钉钉', 'dingtalk', '', '', 1, 99999996, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:19:55', '2023-06-11 08:26:51');
INSERT INTO `bs_msg_target` VALUES ('4188242478060539905', '邮箱', 'email', '', '', 1, 99999993, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:20:21', '2023-06-11 08:27:16');
INSERT INTO `bs_msg_target` VALUES ('4188244326947491841', '手机', 'telephone', '', NULL, 1, 99999990, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:27:41', '2023-06-11 08:27:41');
INSERT INTO `bs_msg_target` VALUES ('4188244431758954497', '微信公众号', 'wechat', '', NULL, 1, 99999987, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:06', '2023-06-11 08:28:06');
INSERT INTO `bs_msg_target` VALUES ('4188244505071194113', '企业微信', 'wechatent', '', NULL, 1, 99999984, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:24', '2023-06-11 08:28:24');
INSERT INTO `bs_msg_target` VALUES ('4188244565611778049', '站内信', 'site', '', NULL, 1, 99999981, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:38', '2023-06-11 08:29:19');

bs_msg_target(完整语句，删除表后插入数据，谨慎操作)

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bs_msg_target
-- ----------------------------
DROP TABLE IF EXISTS `bs_msg_target`;
CREATE TABLE `bs_msg_target`  (
  `TYPE_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'newid()' COMMENT '类别ID',
  `TYPE_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类别名称',
  `TYPE_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '助记码 dingtalk email telephone wechat wechatent',
  `SUB_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '子类别名称',
  `PARENT_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级类别',
  `IS_ENABLED` int NULL DEFAULT 1 COMMENT '启用',
  `SORT_ID` int NULL DEFAULT 0 COMMENT '排序',
  `SYS_ID` varchar(1800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '系统ID，关联  BO_SYSTEM',
  `IMG_URL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图片地址',
  `LINK_URL` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '链接地址',
  `CREATE_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建用户 BO_USER_ID',
  `MODIFY_USER_ID` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '修改用户 BO_USER',
  `CREATE_DATE` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `MODIFY_DATE` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`TYPE_ID`) USING BTREE,
  UNIQUE INDEX `idx_uq_bs_news_type`(`TYPE_ID`) USING BTREE,
  INDEX `idx_no_bs_news_type_type_name`(`TYPE_NAME`) USING BTREE,
  UNIQUE INDEX `idx_uq_bs_msg_target_type_code`(`TYPE_CODE`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of bs_msg_target
-- ----------------------------
INSERT INTO `bs_msg_target` VALUES ('4188242370304675841', '钉钉', 'dingtalk', '', '', 1, 99999996, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:19:55', '2023-06-11 08:26:51');
INSERT INTO `bs_msg_target` VALUES ('4188242478060539905', '邮箱', 'email', '', '', 1, 99999993, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:20:21', '2023-06-11 08:27:16');
INSERT INTO `bs_msg_target` VALUES ('4188244326947491841', '手机', 'telephone', '', NULL, 1, 99999990, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:27:41', '2023-06-11 08:27:41');
INSERT INTO `bs_msg_target` VALUES ('4188244431758954497', '微信公众号', 'wechat', '', NULL, 1, 99999987, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:06', '2023-06-11 08:28:06');
INSERT INTO `bs_msg_target` VALUES ('4188244505071194113', '企业微信', 'wechatent', '', NULL, 1, 99999984, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:24', '2023-06-11 08:28:24');
INSERT INTO `bs_msg_target` VALUES ('4188244565611778049', '站内信', 'site', '', NULL, 1, 99999981, '', '', '', 'ptdev', 'ptdev', '2023-06-11 08:28:38', '2023-06-11 08:29:19');

SET FOREIGN_KEY_CHECKS = 1;