meidu2021/daju/resources-template/message.sql

-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: wuye
-- ------------------------------------------------------
-- Server version	5.7.20-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `m_black_user_list`
--

DROP TABLE IF EXISTS `m_black_user_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_black_user_list` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  `user_account` varchar(255) DEFAULT NULL COMMENT '用户账号',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `in_post_id` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_UNIQUE` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_message`
--

DROP TABLE IF EXISTS `m_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_message` (
  `id` varchar(32) NOT NULL,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `proc_inst_id` varchar(64) DEFAULT NULL,
  `step_name` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `text` longtext COMMENT '内容',
  `send_text` longtext COMMENT '真正发送的文本',
  `send_count` int(11) DEFAULT '0' COMMENT '发送人数',
  `see_count` int(11) DEFAULT '0' COMMENT '已读人数',
  `send_scope` varchar(255) DEFAULT NULL COMMENT '发送范围',
  `send_scope_ids` varchar(2000) DEFAULT NULL COMMENT '范围对应id',
  `send_scope_names` varchar(2000) DEFAULT NULL COMMENT '范围对应名称',
  `send_way` varchar(255) DEFAULT NULL COMMENT '发送方式',
  `message_type` varchar(255) DEFAULT NULL COMMENT '消息类型',
  `send_time` datetime DEFAULT NULL COMMENT '发送时间',
  `send_time_type` int(11) DEFAULT '0' COMMENT '发送时间类型\n0立即\n1定时',
  `plan_send_time` datetime DEFAULT NULL,
  `notice_type` varchar(255) DEFAULT NULL COMMENT '通知类型',
  `is_send` int(11) DEFAULT '0' COMMENT '是否发送\n0未发\n1已发',
  `is_wx` int(11) DEFAULT '0' COMMENT '是否微信发送',
  `is_short` int(11) DEFAULT '0' COMMENT '是否短信发送',
  `is_email` int(11) DEFAULT '0' COMMENT '是否邮件发送',
  `is_site` int(11) DEFAULT '0' COMMENT '状态',
  `status` int(11) DEFAULT '0' COMMENT '-1 审核失败\n0 草稿\n1 审核中\n2 已发布\n3 撤销',
  `template_id` int(11) DEFAULT NULL COMMENT '模板id',
  `template_name` varchar(255) DEFAULT NULL COMMENT '模板名称',
  `template_data` varchar(500) DEFAULT NULL COMMENT '模板数据',
  `host` varchar(255) DEFAULT NULL COMMENT '页面host，生成用户查看地址用',
  PRIMARY KEY (`id`),
  KEY `plan_send_time` (`plan_send_time`,`is_send`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_message_notice_id_increment`
--

DROP TABLE IF EXISTS `m_message_notice_id_increment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_message_notice_id_increment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_type` varchar(45) DEFAULT NULL,
  `type_num` int(11) DEFAULT NULL COMMENT '第几号文件',
  `version` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='消息通知自增表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_message_send_log`
--

DROP TABLE IF EXISTS `m_message_send_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_message_send_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  `message_id` varchar(32) DEFAULT NULL COMMENT '消息id',
  `send_way` varchar(45) DEFAULT NULL COMMENT '发送方式',
  `status` int(11) DEFAULT NULL COMMENT '1成功\n0失败',
  `callback` varchar(500) DEFAULT NULL COMMENT '回调消息',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `ct` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='消息发送日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_message_send_scope`
--

DROP TABLE IF EXISTS `m_message_send_scope`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_message_send_scope` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `message_id` varchar(32) DEFAULT NULL COMMENT '消息id',
  `scope_id` varchar(32) DEFAULT NULL COMMENT '范围id',
  `send_scope` varchar(255) DEFAULT NULL COMMENT '范围 冗余字段 同m_message的 send_scope',
  PRIMARY KEY (`id`),
  KEY `message_id` (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_message_template`
--

DROP TABLE IF EXISTS `m_message_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_message_template` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `name` varchar(255) NOT NULL COMMENT '模板名称',
  `text` longtext NOT NULL COMMENT '模板内容',
  `status` int(11) DEFAULT NULL COMMENT '启用状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_personal_message`
--

DROP TABLE IF EXISTS `m_personal_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_personal_message` (
  `id` varchar(32) NOT NULL,
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  `message_id` varchar(32) DEFAULT NULL COMMENT '消息id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
  `is_read` int(11) DEFAULT '0' COMMENT '0 未读\n1.已读',
  `preview_url` varchar(255) DEFAULT NULL COMMENT '预览地址',
  `preview_url_short` varchar(255) DEFAULT NULL COMMENT '查看短链接',
  `title` varchar(255) DEFAULT NULL COMMENT '消息标题',
  `create_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`message_id`),
  KEY `ct` (`create_time`),
  KEY `messageid` (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='个人信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_regular_receiver`
--

DROP TABLE IF EXISTS `m_regular_receiver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_regular_receiver` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `user_account` varchar(255) DEFAULT NULL COMMENT '用户帐户',
  `group_id` int(11) DEFAULT NULL COMMENT '分组id',
  `in_post_id` varchar(32) DEFAULT NULL COMMENT '岗位id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`group_id`,`user_id`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_regular_receiver_group`
--

DROP TABLE IF EXISTS `m_regular_receiver_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_regular_receiver_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `group_name` varchar(255) DEFAULT NULL COMMENT '分组名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_short_url`
--

DROP TABLE IF EXISTS `m_short_url`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_short_url` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL COMMENT '原地址',
  `short_code` varchar(255) DEFAULT NULL COMMENT '短地址',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `short` (`short_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='消息短链接';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `m_white_ip_list`
--

DROP TABLE IF EXISTS `m_white_ip_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `m_white_ip_list` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_name` varchar(50) DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `sys_org_code` varchar(50) DEFAULT NULL COMMENT '所属部门',
  `sys_company_code` varchar(50) DEFAULT NULL COMMENT '所属公司',
  `bpm_status` varchar(32) DEFAULT '1' COMMENT '流程状态',
  `ip` varchar(32) DEFAULT NULL COMMENT 'ip',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

LOCK TABLES `t_s_typegroup` WRITE;
/*!40000 ALTER TABLE `t_s_typegroup` DISABLE KEYS */;
INSERT ignore INTO `t_s_typegroup` VALUES ('402881e56ae35114016ae35ccf860002','message_notice_type','消息通知类型','2019-05-23 14:24:32','管理员'),('402881e56ae35114016ae36e512e001f','message_send_way','消息发送方式','2019-05-23 14:43:39','管理员'),('402881e56ae35114016ae37e71720035','message_send_time_type','消息发送时间方式','2019-05-23 15:01:16','管理员'),('402881e56ae732ab016ae753790a0011','message_template_status','消息模板状态','2019-05-24 08:52:49','管理员'),('402881e56ae35114016ae3c89416003f','message_send_scope','消息发送范围','2019-06-12 11:06:07','管理员'),('402881e56aee1529016aee4fbf0b0007','message_type','消息类型','2019-06-12 11:06:07','管理员');
/*!40000 ALTER TABLE `t_s_typegroup` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `t_s_type` WRITE;
/*!40000 ALTER TABLE `t_s_type` DISABLE KEYS */;
INSERT ignore INTO `t_s_type` VALUES ('402880ed6b22719c016b22863e580006','message','消息发送审批流程',NULL,'402889fe47eddd340147ede15c070001','2019-06-04 20:45:52','管理员'),('402881e56ae35114016ae35e29430004','meeting','会议通知',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:26:00','管理员'),('402881e56ae35114016ae35ebe5e0006','train','培训通知',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:26:38','管理员'),('402881e56ae35114016ae35f1ddd0008','holiday','放假通知',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:27:03','管理员'),('402881e56ae35114016ae35f3dc9000a','other','其他通知',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:27:11','管理员'),('402881e56ae35114016ae35f5bee000c','red','红头文件',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:27:19','管理员'),('402881e56ae35114016ae35f7fc4000e','system','系统消息',NULL,'402881e56ae35114016ae35ccf860002','2019-05-23 14:27:28','管理员'),('402881e56ae35114016ae37eb5f90037','0','立即',NULL,'402881e56ae35114016ae37e71720035','2019-05-23 15:01:33','管理员'),('402881e56ae35114016ae37ed6070039','1','定时',NULL,'402881e56ae35114016ae37e71720035','2019-05-23 15:01:42','管理员'),('402881e56ae35114016ae3c9bdc90042','role','角色',NULL,'402881e56ae35114016ae3c89416003f','2019-05-23 16:23:31','管理员'),('402881e56ae35114016ae3c9f6990044','dep','部门',NULL,'402881e56ae35114016ae3c89416003f','2019-05-23 16:23:45','管理员'),('402881e56ae35114016ae3ca361d0046','user_group','用户组',NULL,'402881e56ae35114016ae3c89416003f','2019-05-23 16:24:01','管理员'),('402881e56ae35114016ae3ca5b0e0048','user','用户',NULL,'402881e56ae35114016ae3c89416003f','2019-05-23 16:24:11','管理员'),('402881e56ae50616016ae50a10880004','all','全员',NULL,'402881e56ae35114016ae3c89416003f','2019-05-23 22:13:23','管理员'),('402881e56ae732ab016ae753e0680013','0','停用',NULL,'402881e56ae732ab016ae753790a0011','2019-05-24 08:53:15','管理员'),('402881e56ae732ab016ae753fa4c0015','1','启用',NULL,'402881e56ae732ab016ae753790a0011','2019-05-24 08:53:22','管理员'),('402881e56aee1529016aee505d780009','template','模板',NULL,'402881e56aee1529016aee4fbf0b0007','2019-05-25 17:26:45','管理员'),('402881e56aee1529016aee51068a000b','custom','自定义',NULL,'402881e56aee1529016aee4fbf0b0007','2019-05-25 17:27:29','管理员'),('402881e56aee1529016aee514132000d','system','系统',NULL,'402881e56aee1529016aee4fbf0b0007','2019-05-25 17:27:44','管理员'),('402881e56ae35114016ae36e9a5c0021','wx','微信',NULL,'402881e56ae35114016ae36e512e001f','2019-05-23 14:43:58','管理员'),('402881e56ae35114016ae36f86140025','email','邮箱',NULL,'402881e56ae35114016ae36e512e001f','2019-05-23 14:44:58','管理员'),('402881e56b4972b6016b499c1646002a','short_message','短信',NULL,'402881e56ae35114016ae36e512e001f','2019-06-12 10:54:55','管理员'),('402881e56b4972b6016b499c358b002c','site','站内信',NULL,'402881e56ae35114016ae36e512e001f','2019-06-12 10:55:03','管理员');
/*!40000 ALTER TABLE `t_s_type` ENABLE KEYS */;
UNLOCK TABLES;

LOCK TABLES `t_s_function` WRITE;
/*!40000 ALTER TABLE `t_s_function` DISABLE KEYS */;
INSERT INTO `t_s_function` VALUES ('402881e56ae3e7b8016ae3e970730002',NULL,0,'消息平台','49','',NULL,'8a8ab0b246dc81120146dc8180890008','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员','admin','2019-05-23 17:02:14','2019-05-23 16:58:08','管理员'),('402881e56ae3e7b8016ae3eb07de0006',NULL,1,'发送消息','1','mMessageController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员','admin','2019-05-24 12:19:46','2019-05-23 16:59:52','管理员'),('402881e56ae7f9dd016ae81431a70003',NULL,1,'消息模板','2','mMessageTemplateController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-05-24 12:23:19',NULL),('402881e56ae7f9dd016ae81554ea0005',NULL,1,'常用接收人','3','mRegularReceiverGroupController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-05-24 12:24:33',NULL),('402881e56ae7f9dd016ae818047c000a',NULL,1,'黑名单','4','mBlackUserListController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-05-24 12:27:29',NULL),('402881e56ae7f9dd016ae8189619000c',NULL,1,'白名单','5','mWhiteIpListController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-05-24 12:28:07',NULL),('402881e56b3aff9b016b3b01b63d0002',NULL,1,'我的消息','6','mPersonalMessageController.do?list','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-06-09 14:51:36',NULL);
/*!40000 ALTER TABLE `t_s_function` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_p_process` WRITE;
/*!40000 ALTER TABLE `t_p_process` DISABLE KEYS */;
INSERT INTO `t_p_process` VALUES ('402880ed6b22719c016b2287edba000b','message',NULL,'消息审批',NULL,'<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<definitions  xmlns=\"http://www.omg.org/spec/BPMN/20100524/MODEL\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:activiti=\"http://activiti.org/bpmn\" xmlns:bpmndi=\"http://www.omg.org/spec/BPMN/20100524/DI\" xmlns:omgdc=\"http://www.omg.org/spec/DD/20100524/DC\" xmlns:omgdi=\"http://www.omg.org/spec/DD/20100524/DI\" typeLanguage=\"http://www.w3.org/2001/XMLSchema\" expressionLanguage=\"http://www.w3.org/1999/XPath\" targetNamespace=\"http://www.lzt.com.cn\">\r\n    <process  id=\"process1559652397758\" name=\"消息审批\">\r\n        <documentation>流程描述</documentation>\r\n        <extensionElements>\r\n            <activiti:executionListener id=\"402880ed6b269067016b2732aeff0033\" event=\"end\" class=\"cn.com.lzt.message.send.workflow.ProcessEndListener\" >\r\n            </activiti:executionListener>\r\n            <activiti:executionListener id=\"402880e54803a496014805e5d9190012\" event=\"end\" class=\"org.jeecgframework.workflow.listener.execution.ProcessEndListener\" >\r\n            </activiti:executionListener>\r\n        </extensionElements>\r\n        <startEvent  id=\"start1\" name=\"开始节点\" activiti:initiator=\"applyUserId\">\r\n        </startEvent>\r\n        <endEvent  id=\"end\" name=\"结束节点\">\r\n        </endEvent>\r\n        <userTask  id=\"task1559652424217\" name=\"审核\" activiti:candidateUsers=\"${flowUtil.customerUserSelect(BPM_FORM_KEY,BPM_DATA_ID,\'GUARD\')}\" >\r\n        </userTask>\r\n        <userTask  id=\"task1559734434686\" name=\"制单人重填\" activiti:assignee=\"${applyUserId}\" >\r\n        </userTask>\r\n        <sequenceFlow  id=\"flow1559652444344\" name=\"通过\" sourceRef=\"task1559652424217\" targetRef=\"end\">\r\n        </sequenceFlow>\r\n        <sequenceFlow  id=\"flow1559652489785\" name=\"\" sourceRef=\"start1\" targetRef=\"task1559652424217\">\r\n        </sequenceFlow>\r\n        <sequenceFlow  id=\"flow1559734443447\" name=\"驳回\" sourceRef=\"task1559652424217\" targetRef=\"task1559734434686\">\r\n        </sequenceFlow>\r\n        <sequenceFlow  id=\"flow1559734481665\" name=\"填写\" sourceRef=\"task1559734434686\" targetRef=\"task1559652424217\">\r\n        </sequenceFlow>\r\n    </process>\r\n    <bpmndi:BPMNDiagram id=\"BPMNDiagram_process1559652397758\">\r\n        <bpmndi:BPMNPlane bpmnElement=\"process1559652397758\" id=\"BPMNPlane_process1559652397758\">\r\n            <bpmndi:BPMNShape bpmnElement=\"start1\" id=\"BPMNShape_start1\">\r\n                <omgdc:Bounds height=\"30\" width=\"30\" x=\"200\" y=\"50\"/>\r\n            </bpmndi:BPMNShape>\r\n            <bpmndi:BPMNShape bpmnElement=\"end\" id=\"BPMNShape_end\">\r\n                <omgdc:Bounds height=\"30\" width=\"30\" x=\"200\" y=\"400\"/>\r\n            </bpmndi:BPMNShape>\r\n            <bpmndi:BPMNShape bpmnElement=\"task1559652424217\" id=\"BPMNShape_task1559652424217\">\r\n                <omgdc:Bounds height=\"56\" width=\"95\" x=\"381\" y=\"169\"/>\r\n            </bpmndi:BPMNShape>\r\n            <bpmndi:BPMNShape bpmnElement=\"task1559734434686\" id=\"BPMNShape_task1559734434686\">\r\n                <omgdc:Bounds height=\"50\" width=\"90\" x=\"592\" y=\"172\"/>\r\n            </bpmndi:BPMNShape>\r\n            <bpmndi:BPMNEdge bpmnElement=\"flow1559652444344\" id=\"BPMNEdge_flow1559652444344\">\r\n                <omgdi:waypoint x=\"376\" y=\"197\" />\r\n                <omgdi:waypoint x=\"303\" y=\"197\" />\r\n                <omgdi:waypoint x=\"303\" y=\"415\" />\r\n                <omgdi:waypoint x=\"230\" y=\"415\" />\r\n            </bpmndi:BPMNEdge>\r\n            <bpmndi:BPMNEdge bpmnElement=\"flow1559652489785\" id=\"BPMNEdge_flow1559652489785\">\r\n                <omgdi:waypoint x=\"230\" y=\"65\" />\r\n                <omgdi:waypoint x=\"428\" y=\"65\" />\r\n                <omgdi:waypoint x=\"428\" y=\"164\" />\r\n            </bpmndi:BPMNEdge>\r\n            <bpmndi:BPMNEdge bpmnElement=\"flow1559734443447\" id=\"BPMNEdge_flow1559734443447\">\r\n                <omgdi:waypoint x=\"481\" y=\"197\" />\r\n                <omgdi:waypoint x=\"587\" y=\"197\" />\r\n            </bpmndi:BPMNEdge>\r\n            <bpmndi:BPMNEdge bpmnElement=\"flow1559734481665\" id=\"BPMNEdge_flow1559734481665\">\r\n                <omgdi:waypoint x=\"637\" y=\"167\" />\r\n                <omgdi:waypoint x=\"637\" y=\"144\" />\r\n                <omgdi:waypoint x=\"428\" y=\"144\" />\r\n                <omgdi:waypoint x=\"428\" y=\"164\" />\r\n            </bpmndi:BPMNEdge>\r\n        </bpmndi:BPMNPlane>\r\n    </bpmndi:BPMNDiagram>\r\n</definitions>',NULL,NULL,'管理员','2019-06-11 16:28:40','admin','管理员','2019-06-04 20:47:42','admin','process1559652397758',1,'0','');
/*!40000 ALTER TABLE `t_p_process` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_p_processnode` WRITE;
/*!40000 ALTER TABLE `t_p_processnode` DISABLE KEYS */;
INSERT INTO `t_p_processnode` VALUES ('402880ed6b22719c016b2287edd4000d',NULL,'402880ed6b22719c016b2287edba000b','task1559652424217','审核','mMessageController.do?goView','mMessageController.do?goViewMobile',NULL,'402880ed6b25050e016b25d3f437000b','no','0'),('402880ed6b27484e016b276b59ba0009',NULL,'402880ed6b22719c016b2287edba000b','task1559734434686','制单人重填','mMessageController.do?goView&flag=1','mMessageController.do?goViewMobile&flag=1',NULL,'402880ed6b27484e016b276d13ce000b','no','0');
/*!40000 ALTER TABLE `t_p_processnode` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_p_processnode_config` WRITE;
/*!40000 ALTER TABLE `t_p_processnode_config` DISABLE KEYS */;
INSERT INTO `t_p_processnode_config` VALUES ('402880ed6b25050e016b25d3f437000b','message','审批','mMessageController.do?goView','mMessageController.do?goViewMobile'),('402880ed6b27484e016b276d13ce000b','message','制单人重填','mMessageController.do?goView&flag=1','mMessageController.do?goViewMobile&flag=1');
/*!40000 ALTER TABLE `t_p_processnode_config` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_s_busconfig` WRITE;
/*!40000 ALTER TABLE `t_s_busconfig` DISABLE KEYS */;
INSERT INTO `t_s_busconfig` VALUES ('402881e56b459899016b45a8c6ec000e',NULL,'online','','m_message','402880ed6b22719c016b2287edba000b','消息发送审批【${title}】','formdeal','消息发送审批','消息发送审批','402880ed6b25050e016b25d59ac8000d');
/*!40000 ALTER TABLE `t_s_busconfig` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_process_busconfig` WRITE;
/*!40000 ALTER TABLE `t_process_busconfig` DISABLE KEYS */;
INSERT INTO `t_process_busconfig` VALUES ('402880ed6b25050e016b25d59ac8000d','消息发送审批','消息发送审批【${title}】','消息发送审批','m_message','message');
/*!40000 ALTER TABLE `t_process_busconfig` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

LOCK TABLES `t_p_listener` WRITE;
/*!40000 ALTER TABLE `t_p_listener` DISABLE KEYS */;
INSERT INTO `t_p_listener` VALUES ('402880ed6b269067016b2732aeff0033','end','javaClass','cn.com.lzt.message.send.workflow.ProcessEndListener','消息通过',1,1,'message');
/*!40000 ALTER TABLE `t_p_listener` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

-- 6.13 新增
ALTER TABLE `m_message`
CHANGE COLUMN `host` `create_by_id` VARCHAR(32) NULL DEFAULT NULL COMMENT '创建人id' AFTER `create_by`;
ALTER TABLE `m_message`
CHANGE COLUMN `status` `status` INT(11) NULL DEFAULT '0' COMMENT '1 撤回\n0 正常' ;
ALTER TABLE `m_message`
ADD COLUMN `cancel_time` TIMESTAMP NULL COMMENT '撤回时间' AFTER `template_data`;

ALTER TABLE `m_message`
ADD INDEX `title` (`title` ASC),
ADD INDEX `create_date` (`create_date` ASC),
ADD INDEX `create_name` (`create_name` ASC),
ADD INDEX `create_id` (`create_by_id` ASC);

INSERT INTO `t_s_function` (`ID`,`functioniframe`,`functionlevel`,`functionname`,`functionorder`,`functionurl`,`parentfunctionid`,`iconid`,`desk_iconid`,`functiontype`,`function_icon_style`,`create_by`,`create_name`,`update_by`,`update_date`,`create_date`,`update_name`) VALUES ('402880ed6b5adcd1016b5ae841a70002',NULL,1,'发送统计','10','mMessageDataController.do?statisSend','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-06-15 19:31:39',NULL);
INSERT INTO `t_s_function` (`ID`,`functioniframe`,`functionlevel`,`functionname`,`functionorder`,`functionurl`,`parentfunctionid`,`iconid`,`desk_iconid`,`functiontype`,`function_icon_style`,`create_by`,`create_name`,`update_by`,`update_date`,`create_date`,`update_name`) VALUES ('402880ed6b5adcd1016b5ae8f81d0004',NULL,1,'接收统计','11','mMessageDataController.do?statisReceive','402881e56ae3e7b8016ae3e970730002','8a8ab0b246dc81120146dc8180460000','8a8ab0b246dc81120146dc8180dd001e',0,'','admin','管理员',NULL,NULL,'2019-06-15 19:32:26',NULL);


ALTER TABLE `m_message`
ADD COLUMN `api_viewer` VARCHAR(255) NULL COMMENT 'api调用模板页名称' AFTER `cancel_time`;