-- MySQL dump 10.13  Distrib 5.6.23, for Win64 (x86_64)
--
-- ------------------------------------------------------
-- Server version	5.6.21-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 `sys_app`
--

DROP TABLE IF EXISTS `sys_app`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `description` varchar(2000) DEFAULT NULL,
  `version` varchar(20) NOT NULL,
  `developer_id` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `status` smallint(6) DEFAULT NULL,
  `deploy` varchar(10) DEFAULT NULL,
  `terminal` varchar(45) DEFAULT NULL,
  `url_phone` varchar(500) DEFAULT NULL,
  `url_pad` varchar(500) DEFAULT NULL,
  `url_web` varchar(500) DEFAULT NULL,
  `icon_path` varchar(500) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `lastupdate` datetime DEFAULT NULL,
  `mark` int(11) DEFAULT NULL,
  `install_count` int(11) DEFAULT NULL,
  `market_status` int(11) DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  `url_phone_detail` varchar(500) DEFAULT NULL,
  `url_pad_detail` varchar(500) DEFAULT NULL,
  `url_web_detail` varchar(500) DEFAULT NULL,
  `icon_code` varchar(45) DEFAULT NULL,
  `titlebar_color` varchar(10) DEFAULT NULL,
  `init_service` varchar(100) DEFAULT NULL,
  `default` smallint(6) DEFAULT NULL,
  `free` smallint(6) DEFAULT NULL,
  `msg_group` smallint(6) DEFAULT NULL,
  `get_badge_service` varchar(300) DEFAULT NULL,
  `pc_open_type` smallint(6) DEFAULT NULL,
  `pc_show_on_sysbar` smallint(6) DEFAULT NULL,
  `url_pc` varchar(500) DEFAULT NULL,
  `url_pc_detail` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app`
--

LOCK TABLES `sys_app` WRITE;
/*!40000 ALTER TABLE `sys_app` DISABLE KEYS */;
INSERT INTO `sys_app` VALUES (1,'sys/org','组织结构',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/dep/index.html','/images/icon/70/org.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/dep/index.html',NULL),(2,'sys/role','系统群组',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/role/index.html','/images/icon/70/role.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/role/index.html',NULL),(3,'sys/appManage','应用管理',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/app/index.html','/images/icon/70/app_manager.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/app/index.html',NULL),(4,'sys/scheduleTask','计划任务','','1.0.000',1,1,0,'server','web',NULL,NULL,'sys/scheduled_task/index.html','/images/icon/70/scheduled_task.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/scheduled_task/index.html',NULL),(5,'sys/bgService','后台服务',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/bg_service/index.html','/images/icon/70/bgservice.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/bg_service/index.html',NULL),(8,'sys/log','系统日志',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/log/index.html','/images/icon/70/log.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/log/index.html',NULL),(9,'sys/setting','系统设置',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/setting/index.html','/images/icon/70/setting.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sys/setting/index.html',NULL),(10,'sys/info','系统信息',NULL,'1.0.000',1,1,0,'server','web',NULL,NULL,'sys/setting/sysinfo.html','/images/icon/70/sysinfo.png','2015-10-13 15:16:31','2015-10-13 15:16:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'sys/setting/sysinfo.html',NULL);
/*!40000 ALTER TABLE `sys_app` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_app_attach`
--

DROP TABLE IF EXISTS `sys_app_attach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `size` int(11) NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `app_code` varchar(20) NOT NULL,
  `app_data_id` int(11) DEFAULT NULL,
  `uploader_id` int(11) NOT NULL,
  `upload_time` datetime NOT NULL,
  `save_path` varchar(500) NOT NULL,
  `org_id` int(11) NOT NULL,
  `uploader_name` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app_attach`
--

LOCK TABLES `sys_app_attach` WRITE;
/*!40000 ALTER TABLE `sys_app_attach` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_app_attach` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_app_auth`
--

DROP TABLE IF EXISTS `sys_app_auth`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL,
  `app_id` int(11) DEFAULT NULL,
  `owner_type` varchar(10) DEFAULT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `opration_id` int(11) DEFAULT NULL,
  `terminal` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app_auth`
--

LOCK TABLES `sys_app_auth` WRITE;
/*!40000 ALTER TABLE `sys_app_auth` DISABLE KEYS */;
INSERT INTO `sys_app_auth` VALUES (1,1,1,'role',1,NULL,'web'),(2,1,2,'role',1,NULL,'web'),(3,1,3,'role',1,NULL,'web'),(4,1,4,'role',1,NULL,'web'),(5,1,5,'role',1,NULL,'web'),(6,1,8,'role',1,NULL,'web'),(9,1,9,'role',1,NULL,'web'),(10,1,10,'role',1,NULL,'web');
/*!40000 ALTER TABLE `sys_app_auth` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_app_category`
--

DROP TABLE IF EXISTS `sys_app_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `icon_code` varchar(45) DEFAULT NULL,
  `group_apps` smallint(4) DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app_category`
--

LOCK TABLES `sys_app_category` WRITE;
/*!40000 ALTER TABLE `sys_app_category` DISABLE KEYS */;
INSERT INTO `sys_app_category` VALUES (1,'系统维护',0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_app_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_app_opration`
--

DROP TABLE IF EXISTS `sys_app_opration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app_opration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `service_path` varchar(50) NOT NULL,
  `terminal` varchar(10) DEFAULT NULL COMMENT 'all,pc,mobile',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app_opration`
--

LOCK TABLES `sys_app_opration` WRITE;
/*!40000 ALTER TABLE `sys_app_opration` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_app_opration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_app_update`
--

DROP TABLE IF EXISTS `sys_app_update`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_app_update` (
  `app_id` int(11) NOT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `version` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_app_update`
--

LOCK TABLES `sys_app_update` WRITE;
/*!40000 ALTER TABLE `sys_app_update` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_app_update` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dep`
--

DROP TABLE IF EXISTS `sys_dep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dep` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fullname` varchar(200) DEFAULT NULL,
  `org_id` int(11) NOT NULL,
  `status` smallint(4) NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `creater_id` int(11) NOT NULL,
  `createtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dep`
--

LOCK TABLES `sys_dep` WRITE;
/*!40000 ALTER TABLE `sys_dep` DISABLE KEYS */;
INSERT INTO `sys_dep` VALUES (1,'1001','默认部门','默认部门',1,0,'',0,1,'2015-03-09 18:59:26');
/*!40000 ALTER TABLE `sys_dep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dep_user`
--

DROP TABLE IF EXISTS `sys_dep_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dep_user` (
  `org_id` int(11) NOT NULL,
  `dep_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`org_id`,`dep_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dep_user`
--

LOCK TABLES `sys_dep_user` WRITE;
/*!40000 ALTER TABLE `sys_dep_user` DISABLE KEYS */;
INSERT INTO `sys_dep_user` VALUES (1,1,1,1,'2015-04-30 13:22:16');
/*!40000 ALTER TABLE `sys_dep_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_download`
--

DROP TABLE IF EXISTS `sys_log_download`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_download` (
  `id` varchar(20) NOT NULL,
  `file_id` int(11) DEFAULT NULL,
  `file_code` varchar(45) DEFAULT NULL,
  `file_name` varchar(200) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `file_path` varchar(500) DEFAULT NULL,
  `app_code` varchar(100) DEFAULT NULL,
  `app_data_id` int(11) DEFAULT NULL,
  `thumbnail` smallint(6) DEFAULT NULL,
  `session_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_download`
--

LOCK TABLES `sys_log_download` WRITE;
/*!40000 ALTER TABLE `sys_log_download` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_download` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_error`
--

DROP TABLE IF EXISTS `sys_log_error`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_error` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `req_id` varchar(20) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `message` varchar(500) DEFAULT NULL,
  `stack` text,
  `time` datetime DEFAULT NULL,
  `session_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_error`
--

LOCK TABLES `sys_log_error` WRITE;
/*!40000 ALTER TABLE `sys_log_error` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_error` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_request`
--

DROP TABLE IF EXISTS `sys_log_request`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_request` (
  `id` varchar(20) NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `req_time` datetime DEFAULT NULL,
  `req_ms` smallint(6) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `path` varchar(500) DEFAULT NULL,
  `protocol` varchar(5) DEFAULT NULL,
  `method` varchar(4) DEFAULT NULL,
  `user_agent` varchar(200) DEFAULT NULL,
  `response_code` int(11) DEFAULT NULL,
  `response_message` varchar(500) DEFAULT NULL,
  `res_time` datetime DEFAULT NULL,
  `res_ms` smallint(6) DEFAULT NULL,
  `use_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_request`
--

LOCK TABLES `sys_log_request` WRITE;
/*!40000 ALTER TABLE `sys_log_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_request` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_service`
--

DROP TABLE IF EXISTS `sys_log_service`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_service` (
  `id` varchar(20) NOT NULL,
  `session_id` varchar(45) DEFAULT NULL,
  `path` varchar(500) DEFAULT NULL,
  `req_data` text,
  `res_data` text,
  `res_code` smallint(6) DEFAULT NULL,
  `err_msg` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_service`
--

LOCK TABLES `sys_log_service` WRITE;
/*!40000 ALTER TABLE `sys_log_service` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_service` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_sql`
--

DROP TABLE IF EXISTS `sys_log_sql`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_sql` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `req_id` varchar(20) DEFAULT NULL,
  `session_id` varchar(45) DEFAULT NULL,
  `sql` text,
  `params` text,
  `start_time` datetime DEFAULT NULL,
  `start_ms` smallint(6) DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `end_ms` smallint(6) DEFAULT NULL,
  `use_time` int(11) DEFAULT NULL,
  `err_code` tinyint(4) DEFAULT NULL,
  `err_msg` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_sql`
--

LOCK TABLES `sys_log_sql` WRITE;
/*!40000 ALTER TABLE `sys_log_sql` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_sql` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_static`
--

DROP TABLE IF EXISTS `sys_log_static`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_static` (
  `id` varchar(20) NOT NULL,
  `content_type` varchar(45) DEFAULT NULL,
  `content_size` int(11) DEFAULT NULL,
  `range_start` int(11) DEFAULT NULL,
  `range_end` int(11) DEFAULT NULL,
  `compress_type` varchar(45) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_static`
--

LOCK TABLES `sys_log_static` WRITE;
/*!40000 ALTER TABLE `sys_log_static` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_static` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_log_upload`
--

DROP TABLE IF EXISTS `sys_log_upload`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_log_upload` (
  `id` varchar(20) NOT NULL,
  `file_code` varchar(45) NOT NULL,
  `file_name` varchar(200) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `app_code` varchar(200) DEFAULT NULL,
  `app_data_id` int(11) DEFAULT NULL,
  `session_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`,`file_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_log_upload`
--

LOCK TABLES `sys_log_upload` WRITE;
/*!40000 ALTER TABLE `sys_log_upload` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_log_upload` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_msg`
--

DROP TABLE IF EXISTS `sys_msg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_msg` (
  `id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `sender_ctype` varchar(20) DEFAULT NULL,
  `send_time` datetime NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `summary` varchar(500) DEFAULT NULL,
  `icon` varchar(200) DEFAULT NULL,
  `sound` varchar(200) DEFAULT NULL,
  `open_type` smallint(6) DEFAULT NULL,
  `open_content` varchar(200) DEFAULT NULL,
  `group_display` smallint(6) DEFAULT NULL,
  `receiver_ctype` varchar(20) DEFAULT NULL,
  `to_self` smallint(6) DEFAULT NULL,
  `to_all` smallint(6) DEFAULT NULL,
  `retain_days` int(11) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_msg`
--

LOCK TABLES `sys_msg` WRITE;
/*!40000 ALTER TABLE `sys_msg` DISABLE KEYS */;
INSERT INTO `sys_msg` VALUES (3346,1,'im',1,'PC','2020-06-28 17:42:26','管理员','12312',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUsers\":[]}'),(3347,1,'im',1,'PC','2020-06-28 18:41:27','管理员','[管理员]萨芬撒旦法',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3348,1,'im',2,'PC','2020-06-28 19:30:47','默认部门','[塔迈信息]1234567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"groupType\":\"dep\",\"groupId\":\"1\"}'),(3349,1,'im',1,'PC','2020-06-28 19:44:06','管理员','[管理员]21341234',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3350,1,'im',1,'PC','2020-06-28 21:08:39','管理员','[管理员]414124',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3351,1,'im',1,'PC','2020-06-28 21:18:57','管理员','[管理员]撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3352,1,'im',1,'PC','2020-06-28 21:27:58','管理员','[管理员]1234',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3353,1,'im',1,'PC','2020-06-28 22:03:59','管理员','[管理员]人情味认为去',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[]}'),(3354,1,'im',1,'PC','2020-06-28 22:36:53','管理员','[管理员]21312',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[],\"content\":\"21312\",\"receiverId\":\"2\"}'),(3355,1,'im',1,'PC','2020-06-28 22:42:57','管理员','[管理员]暗室逢灯',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[],\"content\":\"暗室逢灯\",\"receiverId\":\"2\"}'),(3356,1,'im',2,'PC','2020-06-28 22:44:24','塔迈信息','[塔迈信息]121323',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[],\"content\":\"121323\",\"receiverId\":\"1\"}'),(3357,1,'im',1,'PC','2020-06-28 22:44:33','管理员','[管理员][强]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":1,\"atUserIds\":[],\"content\":\"[强]\",\"receiverId\":\"2\"}'),(3358,1,'im',1,'PC','2020-07-01 21:03:34','管理员','[管理员]23456',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"23456\",\"receiverId\":\"2\"}'),(3359,1,'im',1,'PC','2020-07-01 21:03:57','管理员','[管理员][强]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"[强]\",\"receiverId\":\"2\"}'),(3360,1,'im',2,'PC','2020-07-01 21:29:25','塔迈信息','[塔迈信息]撒旦飞洒',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"撒旦飞洒\",\"receiverId\":\"1\"}'),(3361,1,'im',1,'PC','2020-07-01 21:29:35','管理员','[管理员]撒旦法  撒旦法\r\nsdafas \r\nsad发',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"撒旦法  撒旦法\\r\\nsdafas \\r\\nsad发\",\"receiverId\":\"2\"}'),(3362,1,'im',1,'PC','2020-07-01 21:29:41','管理员','[管理员][快哭了]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"[快哭了]\",\"receiverId\":\"2\"}'),(3363,1,'im',2,'PC','2020-07-02 11:33:43','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"d420f940bc1411ea871c7bbe1be1a3a5\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"1\"}'),(3364,1,'im',2,'PC','2020-07-02 11:34:54','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"fe5a25b0bc1411ea871c7bbe1be1a3a5\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"1\"}'),(3365,1,'im',2,'PC','2020-07-02 11:37:07','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"4d1c8030bc1511ea871c7bbe1be1a3a5\",\"fileName\":\"新建文本文档.txt\",\"fileType\":\"file\",\"fileSize\":4415,\"receiverId\":\"1\"}'),(3366,1,'im',2,'PC','2020-07-02 11:39:05','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"image\",\"receiversCount\":2,\"fileCode\":\"93e3b3d0bc1511ea871c7bbe1be1a3a5\",\"fileName\":\"93e3b3d0bc1511ea871c7bbe1be1a3a5.png\",\"fileType\":\"image\",\"fileSize\":29764,\"receiverId\":\"1\"}'),(3367,1,'im',2,'PC','2020-07-02 11:39:17','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"image\",\"receiversCount\":2,\"fileCode\":\"9b25eaf0bc1511ea871c7bbe1be1a3a5\",\"fileName\":\"9b25eaf0bc1511ea871c7bbe1be1a3a5.png\",\"fileType\":\"image\",\"fileSize\":5477,\"receiverId\":\"1\"}'),(3368,1,'im',2,'PC','2020-07-02 11:39:28','塔迈信息','[塔迈信息][礼物]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"[礼物]\",\"receiverId\":\"1\"}'),(3369,1,'im',2,'PC','2020-07-02 13:28:43','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"e48075d0bc2411ea9a3c89af666e8338\",\"fileName\":\"package.json\",\"fileType\":\"file\",\"fileSize\":196,\"receiverId\":\"1\"}'),(3370,1,'im',2,'PC','2020-07-02 13:33:15','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"86e09b20bc2511eabd94ad6c0a5451d2\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"1\"}'),(3371,1,'im',2,'PC','2020-07-02 13:36:09','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"ee32cd20bc2511ea8b301d164824b629\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"1\"}'),(3372,1,'im',1,'PC','2020-07-02 15:04:33','管理员','[管理员]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"482e4500bc3211ea8dfd4f92bcf18a89\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"2\"}'),(3373,1,'im',2,'PC','2020-07-02 15:45:29','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"ffbcae00bc3711ea8db5718a08d8742e\",\"fileName\":\"TaskMsgServer_FatalError.txt\",\"fileType\":\"file\",\"fileSize\":588,\"receiverId\":\"1\"}'),(3374,1,'im',2,'PC','2020-07-02 15:51:40','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"dcbe9750bc3811ea8db5718a08d8742e\",\"fileName\":\"Logger.rar\",\"fileType\":\"file\",\"fileSize\":4713,\"receiverId\":\"1\"}'),(3375,1,'im',1,'PC','2020-07-02 15:53:14','管理员','[管理员]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"14d93b40bc3911ea92bbe7789c50eb28\",\"fileName\":\"微信图片_20200701164125.rar\",\"fileType\":\"file\",\"fileSize\":1785578,\"receiverId\":\"2\"}'),(3376,1,'im',2,'PC','2020-07-02 15:53:31','塔迈信息','[塔迈信息]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"1ed6e8e0bc3911ea8db5718a08d8742e\",\"fileName\":\"微信图片_20200701164125.rar\",\"fileType\":\"file\",\"fileSize\":1785578,\"receiverId\":\"1\"}'),(3377,1,'im',1,'PC','2020-07-02 16:14:50','管理员','[管理员]',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"15879c50bc3c11eaa5c2e1d09ca03af7\",\"fileName\":\"调整尺寸4.pdf\",\"fileType\":\"file\",\"fileSize\":79675416,\"receiverId\":\"2\"}'),(3378,1,'im',2,'PC','2020-07-03 11:28:01','塔迈信息','[塔迈信息]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"31bd5f30bcdd11ea8f7789f3719a3495\",\"fileName\":\"云空间账号密码.docx\",\"fileType\":\"file\",\"fileSize\":11566,\"receiverId\":\"1\"}'),(3379,1,'im',1,'PC','2020-07-03 11:37:57','管理员','[管理员]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"image\",\"receiversCount\":2,\"fileCode\":\"95c775a0bcde11ea8aee853ae3a80678\",\"fileName\":\"95c775a0bcde11ea8aee853ae3a80678.png\",\"fileType\":\"image\",\"fileSize\":25055,\"receiverId\":\"2\"}'),(3380,1,'im',1,'pc','2020-07-04 17:36:25','管理员','[管理员]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"d2d9e670bdd911ea900641aaf3062a01\",\"fileName\":\"云空间账号密码.docx\",\"fileType\":\"file\",\"fileSize\":11566,\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":24}}'),(3381,1,'im',1,'pc','2020-07-06 16:30:54','管理员','[管理员]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"01e31bf0bf6311ea97a52bd87766e270\",\"fileName\":\"云空间账号密码.docx\",\"fileType\":\"file\",\"fileSize\":11566,\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":24}}'),(3382,1,'im',1,'pc','2020-07-07 09:59:41','管理员','[管理员]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"84e75fb0bff511ea80bd473bbc8492aa\",\"fileName\":\"aes.js\",\"fileType\":\"file\",\"fileSize\":8187,\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":24}}'),(3383,1,'im',1,'pc','2020-07-07 09:59:52','管理员','[管理员]文件',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"file\",\"receiversCount\":2,\"fileCode\":\"86eec870bff511ea80bd473bbc8492aa\",\"fileName\":\"调整尺寸4.pdf\",\"fileType\":\"file\",\"fileSize\":79675416,\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":24}}'),(3384,1,'im',1,'pc','2020-07-11 15:38:40','管理员','[管理员]21313',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"21313\",\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":31}}'),(3385,1,'im',1,'pc','2020-07-11 15:38:49','管理员','[管理员]王企鹅全文',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"王企鹅全文\",\"receiverId\":\"5\",\"receiver\":{\"name\":\"张三\",\"sex\":1,\"headId\":0}}'),(3386,1,'im',2,'pc','2020-07-11 15:48:57','塔迈信息','[塔迈信息]1111',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"1111\",\"receiverId\":\"1\",\"receiver\":{\"name\":\"管理员\",\"sex\":0,\"headId\":27}}'),(3388,1,'im',2,'pc','2020-07-11 16:23:31','塔迈信息','[塔迈信息]2222',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"2222\",\"receiverId\":\"1\",\"receiver\":{\"name\":\"管理员\",\"sex\":0,\"headId\":27}}'),(3390,1,'im',1,'pc','2020-07-11 16:25:05','管理员','[管理员]5444',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"5444\",\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":31}}'),(3392,1,'im',2,'pc','2020-07-11 16:25:09','塔迈信息','[塔迈信息]4455',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"4455\",\"receiverId\":\"1\",\"receiver\":{\"name\":\"管理员\",\"sex\":0,\"headId\":27}}'),(3394,1,'im.chat',1,'pc','2020-07-11 18:59:04','管理员','[管理员]4234',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"4234\",\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":31}}'),(3395,1,'im.read',2,'pc','2020-07-11 18:59:57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"appCode\":\"im.chat\",\"dataId\":3394}'),(3396,1,'im.chat',2,'pc','2020-07-11 19:02:54','塔迈信息','[塔迈信息]撒的发斯蒂芬',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"撒的发斯蒂芬\",\"receiverId\":\"1\",\"receiver\":{\"name\":\"管理员\",\"sex\":0,\"headId\":27}}'),(3397,1,'im.read',1,'pc','2020-07-11 19:02:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"appCode\":\"im.chat\",\"dataId\":3396}'),(3398,1,'im.chat',1,'pc','2020-07-11 19:05:27','管理员','[管理员]热特图吧',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"type\":\"text\",\"receiversCount\":2,\"atUserIds\":[],\"content\":\"热特图吧\",\"receiverId\":\"2\",\"receiver\":{\"name\":\"塔迈信息\",\"sex\":1,\"headId\":31}}'),(3399,1,'im.read',2,'pc','2020-07-11 19:05:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"appCode\":\"im.chat\",\"dataId\":3398}'),(3400,1,'im.read',2,'pc','2020-07-13 14:47:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3401,1,'im.chat',2,'pc','2020-07-13 14:52:28','塔迈信息','2233',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3402,1,'im.read',1,'pc','2020-07-13 14:59:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3403,1,'im.chat',2,'pc','2020-07-13 15:08:12','塔迈信息','ddddd',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3404,1,'im.read',1,'pc','2020-07-13 15:08:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3405,1,'im.chat',1,'pc','2020-07-13 15:33:00','管理员','34234',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3406,1,'im.read',2,'pc','2020-07-13 15:33:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3407,1,'im.chat',1,'pc','2020-07-13 15:51:21','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3408,1,'im.read',2,'pc','2020-07-13 15:53:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3409,1,'im.chat',2,'pc','2020-07-13 15:54:33','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3410,1,'im.read',1,'pc','2020-07-13 15:54:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3411,1,'im.chat',2,'pc','2020-07-13 17:23:00','塔迈信息','二对人体',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3412,1,'im.chat',2,'pc','2020-07-13 17:24:26','塔迈信息','点对点',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3413,1,'im.chat',2,'pc','2020-07-13 17:25:13','塔迈信息','人头',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3414,1,'im.chat',2,'pc','2020-07-13 17:25:39','塔迈信息','3456',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3415,1,'im.chat',2,'pc','2020-07-13 17:26:15','塔迈信息','4567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3416,1,'im.chat',2,'pc','2020-07-13 17:31:18','塔迈信息','45678',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3417,1,'im.chat',2,'pc','2020-07-13 17:33:40','塔迈信息','9876',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3418,1,'im.revoke',2,'pc','2020-07-13 17:33:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3419,1,'im.chat',2,'pc','2020-07-13 17:35:03','塔迈信息','111111',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3420,1,'im.revoke',2,'pc','2020-07-13 17:35:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3421,1,'im.chat',1,'pc','2020-07-13 17:35:57','管理员','1234',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3422,1,'im.read',2,'pc','2020-07-13 17:35:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3423,1,'im.revoke',1,'pc','2020-07-13 17:36:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3424,1,'im.chat',2,'pc','2020-07-13 18:01:53','塔迈信息','46556',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3425,1,'im.read',1,'pc','2020-07-13 18:01:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3426,1,'im.chat',2,'pc','2020-07-13 18:04:56','塔迈信息','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3427,1,'im.read',1,'pc','2020-07-13 18:04:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3428,1,'im.revoke',2,'pc','2020-07-13 18:04:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3429,1,'im.chat',2,'pc','2020-07-14 09:26:09','塔迈信息','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3430,1,'im.chat',2,'pc','2020-07-14 09:26:17','塔迈信息','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3431,1,'im.chat',2,'pc','2020-07-14 09:26:21','塔迈信息','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3432,1,'im.revoke',2,'pc','2020-07-14 09:26:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3433,1,'im.chat',2,'pc','2020-07-14 09:26:26','塔迈信息','1222',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3434,1,'im.revoke',2,'pc','2020-07-14 09:26:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3435,1,'im.chat',2,'pc','2020-07-16 08:19:24','塔迈信息','123',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3436,1,'im.read',1,'pc','2020-07-16 08:40:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3437,1,'im.chat',2,'pc','2020-07-16 08:40:40','塔迈信息','6677',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3438,1,'im.read',1,'pc','2020-07-16 08:40:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3439,1,'im.chat',1,'pc','2020-07-16 08:40:52','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3440,1,'im.read',2,'pc','2020-07-16 08:40:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3441,1,'im.chat',1,'pc','2020-07-16 14:41:33','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3442,1,'im.read',2,'pc','2020-07-16 14:41:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3443,1,'im.chat',2,'pc','2020-07-16 21:10:53','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3444,1,'im.chat',1,'pc','2020-07-16 21:13:21','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3445,1,'im.read',2,'pc','2020-07-16 21:15:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3446,1,'im.read',2,'pc','2020-07-16 21:15:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3447,1,'im.chat',2,'pc','2020-07-16 21:30:55','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3448,1,'im.chat',2,'pc','2020-07-16 21:33:18','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3449,1,'im.chat',2,'pc','2020-07-16 21:37:48','塔迈信息','23456789',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3450,1,'im.read',1,'pc','2020-07-16 21:38:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3451,1,'im.chat',1,'pc','2020-07-17 22:30:42','管理员、塔迈信息、张三','是否',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3452,1,'im.chat',1,'pc','2020-07-18 13:10:37','管理员、塔迈信息、张三','3456789',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3453,1,'im.chat',1,'pc','2020-07-18 14:12:17','管理员、塔迈信息、张三','是撒地方撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3454,1,'im.chat',1,'pc','2020-07-18 14:35:28','管理员、塔迈信息、张三','65432',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3455,1,'im.chat',1,'pc','2020-07-18 15:08:59','管理员、塔迈信息、张三','5555',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3456,1,'im.read',2,'pc','2020-07-18 15:09:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3457,1,'im.chat',2,'pc','2020-07-18 15:09:13','管理员、塔迈信息、张三','323',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3458,1,'im.read',1,'pc','2020-07-18 15:09:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3459,1,'im.chat',1,'pc','2020-07-18 15:09:40','管理员、塔迈信息、张三','666',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3460,1,'im.read',2,'pc','2020-07-18 15:09:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3461,1,'im.chat',2,'pc','2020-07-18 15:09:50','管理员、塔迈信息、张三','777',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3462,1,'im.read',1,'pc','2020-07-18 15:09:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3463,1,'im.chat',1,'pc','2020-07-18 15:10:21','管理员、塔迈信息、张三','888',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3464,1,'im.read',2,'pc','2020-07-18 15:10:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3465,1,'im.chat',2,'pc','2020-07-18 15:10:28','管理员、塔迈信息、张三','999',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3466,1,'im.read',1,'pc','2020-07-18 15:10:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3467,1,'im.chat',1,'pc','2020-07-18 15:10:44','管理员、塔迈信息、张三','000',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3468,1,'im.read',2,'pc','2020-07-18 15:10:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3469,1,'im.chat',1,'pc','2020-07-18 15:10:49','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3470,1,'im.read',2,'pc','2020-07-18 15:10:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3471,1,'im.read',2,'pc','2020-07-18 15:10:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3472,1,'im.chat',2,'pc','2020-07-18 15:11:11','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3473,1,'im.read',1,'pc','2020-07-18 15:11:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3474,1,'im.chat',2,'pc','2020-07-18 15:13:55','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3475,1,'im.read',1,'pc','2020-07-18 15:13:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3476,1,'im.chat',1,'pc','2020-07-18 15:14:56','管理员、塔迈信息、张三','34567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3477,1,'im.read',2,'pc','2020-07-18 15:15:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3478,1,'im.chat',2,'pc','2020-07-18 15:15:09','管理员、塔迈信息、张三','让天禹IT与IO',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3479,1,'im.read',1,'pc','2020-07-18 15:15:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3480,1,'im.chat',2,'pc','2020-07-18 15:15:25','管理员、塔迈信息、张三','45678',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3481,1,'im.read',1,'pc','2020-07-18 15:15:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3482,1,'im.chat',1,'pc','2020-07-18 15:15:35','管理员、塔迈信息、张三','567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3483,1,'im.read',2,'pc','2020-07-18 15:15:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3486,1,'im.group.addUser',1,'pc','2020-07-18 19:01:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3487,1,'im.chat',2,'pc','2020-07-18 22:55:24','管理员、塔迈信息、张三','3333',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3488,1,'im.read',1,'pc','2020-07-18 22:55:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3489,1,'im.group.deleteUser',1,'pc','2020-07-18 22:55:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3490,1,'im.chat',2,'pc','2020-07-18 23:32:50','管理员、塔迈信息、张三','222',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3491,1,'im.read',1,'pc','2020-07-18 23:32:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3492,1,'im.group.addUser',1,'pc','2020-07-18 23:33:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3493,1,'im.group.deleteUser',1,'pc','2020-07-18 23:34:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3494,1,'im.chat',2,'pc','2020-07-19 13:07:30','管理员、塔迈信息、张三','尔尔',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3495,1,'im.read',1,'pc','2020-07-19 13:07:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3496,1,'im.chat',2,'pc','2020-07-19 13:27:42','塔迈信息、张三、管理员','删除',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3497,1,'im.read',1,'pc','2020-07-19 13:27:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3498,1,'im.group.addUser',2,'pc','2020-07-19 13:38:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3499,1,'im.chat',1,'pc','2020-07-19 14:34:10','管理员、塔迈信息、张三','132',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3500,1,'im.read',2,'pc','2020-07-19 14:34:13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3501,1,'im.group.addUser',1,'pc','2020-07-19 14:34:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3502,1,'im.chat',2,'pc','2020-07-19 16:33:01','管理员、塔迈信息、张三','是否',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3503,1,'im.read',1,'pc','2020-07-19 16:33:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3504,1,'im.chat',1,'pc','2020-07-19 16:33:48','管理员、塔迈信息、张三','2212',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3505,1,'im.read',2,'pc','2020-07-19 16:33:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3506,1,'im.chat',2,'pc','2020-07-20 09:43:08','塔迈信息、张三、管理员','是分散的',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3507,1,'im.read',1,'pc','2020-07-20 09:43:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3508,1,'im.group.addUser',2,'pc','2020-07-20 09:43:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3509,1,'im.chat',2,'pc','2020-07-20 10:10:55','塔迈信息、张三、管理员','333',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3510,1,'im.read',1,'pc','2020-07-20 10:11:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3511,1,'im.group.addUser',2,'pc','2020-07-20 10:11:06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3512,1,'im.chat',2,'pc','2020-07-20 10:17:59','塔迈信息、张三、管理员','44',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3513,1,'im.read',1,'pc','2020-07-20 10:18:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3514,1,'im.group.addUser',2,'pc','2020-07-20 10:18:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3515,1,'im.chat',1,'pc','2020-07-20 10:22:42','管理员、塔迈信息、张三','广告',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3516,1,'im.read',2,'pc','2020-07-20 10:22:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3517,1,'im.group.addUser',1,'pc','2020-07-20 10:22:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3518,1,'im.chat',1,'pc','2020-07-20 10:22:58','管理员、塔迈信息、张三','发',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3519,1,'im.read',2,'pc','2020-07-20 10:22:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3520,1,'im.chat',1,'pc','2020-07-20 10:23:44','管理员、塔迈信息、张三','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3521,1,'im.read',2,'pc','2020-07-20 10:23:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3522,1,'im.group.addUser',1,'pc','2020-07-20 10:23:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3523,1,'im.chat',1,'pc','2020-07-20 10:23:58','管理员、塔迈信息、张三','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3524,1,'im.read',2,'pc','2020-07-20 10:23:59',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3525,1,'im.group.deleteUser',1,'pc','2020-07-20 10:24:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3526,1,'im.chat',1,'pc','2020-07-20 10:25:19','管理员、塔迈信息、张三','7654',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3527,1,'im.read',2,'pc','2020-07-20 10:25:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3528,1,'im.group.addUser',1,'pc','2020-07-20 10:25:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3529,1,'im.chat',1,'pc','2020-07-20 10:25:29','管理员、塔迈信息、张三','44',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3530,1,'im.read',2,'pc','2020-07-20 10:25:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3531,1,'im.group.deleteUser',1,'pc','2020-07-20 10:25:33',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3532,1,'im.group.addUser',1,'pc','2020-07-20 10:25:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3533,1,'im.group.deleteUser',1,'pc','2020-07-20 10:28:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3534,1,'im.group.addUser',1,'pc','2020-07-20 10:28:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3535,1,'im.group.deleteUser',1,'pc','2020-07-20 10:45:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3536,1,'im.group.delete',2,'pc','2020-07-20 10:50:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3537,1,'im.chat',1,'pc','2020-07-20 10:54:16','管理员、塔迈信息、张三等','云应用',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3538,1,'im.read',2,'pc','2020-07-20 10:54:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3539,1,'im.group.delete',1,'pc','2020-07-20 10:54:25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3540,1,'im.chat',1,'pc','2020-07-20 11:24:05','管理员、塔迈信息、张三','333',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3541,1,'im.read',2,'pc','2020-07-20 11:24:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3542,1,'im.group.delete',2,'pc','2020-07-20 11:24:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3543,1,'im.group.delete',1,'pc','2020-07-20 11:24:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3544,1,'im.group.favorite',2,'pc','2020-07-20 14:37:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3545,1,'im.group.favorite',2,'pc','2020-07-20 14:38:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3546,1,'im.group.cancelFavorite',2,'pc','2020-07-20 14:38:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3547,1,'im.group.favorite',2,'pc','2020-07-20 14:39:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3548,1,'im.chat',2,'pc','2020-07-20 14:39:51','塔迈信息、张三、李四','123',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3549,1,'im.group.cancelFavorite',2,'pc','2020-07-20 14:39:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3550,1,'im.group.favorite',2,'pc','2020-07-20 14:40:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3551,1,'im.group.addUser',2,'pc','2020-07-20 14:40:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3552,1,'im.chat',2,'pc','2020-07-20 14:40:18','塔迈信息、张三、李四','6543',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3553,1,'im.read',1,'pc','2020-07-20 14:40:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3554,1,'im.group.favorite',1,'pc','2020-07-20 14:40:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3555,1,'im.group.cancelFavorite',1,'pc','2020-07-20 14:40:32',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3556,1,'im.group.delete',1,'pc','2020-07-20 14:42:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3557,1,'im.chat',2,'pc','2020-07-20 14:42:56','塔迈信息、张三、管理员','水电费费',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3558,1,'im.read',1,'pc','2020-07-20 14:43:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3559,1,'im.group.quit',1,'pc','2020-07-20 14:43:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3560,1,'im.chat',2,'pc','2020-07-20 14:43:15','塔迈信息、张三、李四','第三方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3561,1,'im.group.addUser',2,'pc','2020-07-20 14:43:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3562,1,'im.chat',2,'pc','2020-07-20 14:43:33','塔迈信息、张三、李四','地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3563,1,'im.read',1,'pc','2020-07-20 14:43:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3564,1,'im.group.deleteUser',2,'pc','2020-07-20 14:43:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3565,1,'im.group.delete',1,'pc','2020-07-20 14:43:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3566,1,'im.chat',1,'pc','2020-07-20 15:17:48','管理员','567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3567,1,'im.read',2,'pc','2020-07-20 15:17:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3568,1,'im.group.update',1,'pc','2020-07-20 15:21:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3569,1,'im.group.update',1,'pc','2020-07-21 09:05:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3570,1,'im.group.addUser',1,'pc','2020-07-21 09:08:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3571,1,'im.group.deleteUser',1,'pc','2020-07-21 09:09:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3572,1,'im.group.update',1,'pc','2020-07-21 09:12:25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3573,1,'im.group.mute',1,'pc','2020-07-21 10:03:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3574,1,'im.group.mute',1,'pc','2020-07-21 10:03:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3575,1,'im.group.mute',1,'pc','2020-07-21 10:03:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3576,1,'im.group.mute',1,'pc','2020-07-21 10:04:13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3577,1,'im.chat',1,'pc','2020-07-21 10:34:18','管理员','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3578,1,'im.chat',1,'pc','2020-07-21 10:57:24','管理员、塔迈信息、张三等','的地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3580,1,'im.chat',1,'pc','2020-07-21 10:59:23','管理员、塔迈信息、张三等','5',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3581,1,'im.group.deleteUser',1,'pc','2020-07-21 10:59:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"groupId\":15,\"groupName\":\"管理员、塔迈信息、张三等\",\"delUserIds\":[5],\"receivers\":[2,6,1]}'),(3582,1,'im.group.addUser',1,'pc','2020-07-21 11:00:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"groupId\":15,\"groupName\":\"管理员、塔迈信息、张三等\",\"newUsers\":[[5,\"1234\",\"张三\",0,1]]}'),(3583,1,'im.chat',1,'pc','2020-07-21 11:06:00','管理员、塔迈信息、张三等','7788',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3584,1,'im.chat',1,'pc','2020-07-21 11:06:11','管理员','9876',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3585,1,'im.chat',1,'pc','2020-07-21 11:27:17','管理员','7654',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3586,1,'im.chat',1,'pc','2020-07-21 11:27:51','管理员','87',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3587,1,'im.chat',1,'pc','2020-07-21 11:29:13','管理员','的的',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3588,1,'im.chat',1,'pc','2020-07-21 11:29:24','管理员、塔迈信息、张三等','撒地方阿斯蒂芬',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3589,1,'im.chat',1,'pc','2020-07-21 11:38:20','管理员、塔迈信息、张三等','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3590,1,'im.chat',1,'pc','2020-07-21 11:41:03','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3591,1,'im.chat',1,'pc','2020-07-21 11:41:47','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3592,1,'im.chat',1,'pc','2020-07-21 11:45:59','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3593,1,'im.chat',1,'pc','2020-07-21 11:47:19','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3594,1,'im.chat',1,'pc','2020-07-21 11:50:13','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3595,1,'im.chat',1,'pc','2020-07-21 11:50:22','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3596,1,'im.chat',1,'pc','2020-07-21 11:50:28','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3597,1,'im.chat',1,'pc','2020-07-21 11:51:21','管理员、塔迈信息、张三等',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3598,1,'im.chat',1,'pc','2020-07-21 15:07:25','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3599,1,'im.chat',1,'pc','2020-07-21 15:15:01','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3600,1,'im.chat',1,'pc','2020-07-21 15:15:17','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3601,1,'im.chat',1,'pc','2020-07-21 15:16:57','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3602,1,'im.chat',1,'pc','2020-07-21 15:17:15','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3603,1,'im.chat',1,'pc','2020-07-21 15:17:47','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3604,1,'im.chat',1,'pc','2020-07-21 15:18:04','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3605,1,'im.chat',1,'pc','2020-07-21 15:18:11','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3606,1,'im.read',2,'pc','2020-07-21 15:18:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3605}'),(3607,1,'im.read',2,'pc','2020-07-21 15:18:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3605}'),(3608,1,'im.chat',2,'pc','2020-07-21 16:27:54','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3609,1,'im.chat',2,'pc','2020-07-21 16:28:56','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3610,1,'im.chat',2,'pc','2020-07-21 16:30:05','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3611,1,'im.chat',2,'pc','2020-07-21 16:32:52','塔迈信息','765',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3612,1,'im.chat',2,'pc','2020-07-21 16:33:02','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3613,1,'im.chat',2,'pc','2020-07-21 16:33:48','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3614,1,'im.chat',2,'pc','2020-07-21 16:33:58','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3615,1,'im.read',1,'pc','2020-07-21 16:37:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3611}'),(3616,1,'im.chat',2,'pc','2020-07-21 16:48:03','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3617,1,'im.read',1,'pc','2020-07-21 16:48:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3613}'),(3618,1,'im.read',1,'pc','2020-07-21 16:48:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3613}'),(3619,1,'im.read',1,'pc','2020-07-21 17:04:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3616}'),(3620,1,'im.chat',1,'pc','2020-07-21 17:07:57','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3621,1,'im.read',2,'pc','2020-07-21 17:17:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3620}'),(3622,1,'im.read',2,'pc','2020-07-21 17:24:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3620}'),(3623,1,'im.chat',2,'pc','2020-07-21 17:26:36','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3624,1,'im.read',1,'pc','2020-07-21 17:29:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3623}'),(3625,1,'im.read',1,'pc','2020-07-21 17:31:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3623}'),(3626,1,'im.chat',2,'pc','2020-07-21 18:15:46','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3627,1,'im.read',1,'pc','2020-07-21 18:17:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3626}'),(3628,1,'im.read',1,'pc','2020-07-21 18:17:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3626}'),(3629,1,'im.chat',2,'pc','2020-07-21 18:18:27','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3630,1,'im.read',1,'pc','2020-07-21 18:18:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3629}'),(3631,1,'im.read',1,'pc','2020-07-21 18:18:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3629}'),(3632,1,'im.chat',2,'pc','2020-07-21 18:19:43','管理员、塔迈信息、张三','会话',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3633,1,'im.read',1,'pc','2020-07-21 18:19:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3632}'),(3634,1,'im.chat',2,'pc','2020-07-21 18:19:48','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3635,1,'im.read',1,'pc','2020-07-21 18:19:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3634}'),(3636,1,'im.chat',2,'pc','2020-07-21 18:21:14','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3637,1,'im.chat',2,'pc','2020-07-21 18:21:27','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3638,1,'im.chat',2,'pc','2020-07-21 18:21:39','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3639,1,'im.chat',1,'pc','2020-07-21 18:46:25','管理员、塔迈信息、张三',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3640,1,'im.read',2,'pc','2020-07-21 18:53:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3639}'),(3641,1,'im.read',2,'pc','2020-07-21 18:53:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3639}'),(3642,1,'im.chat',2,'pc','2020-07-21 22:47:38','塔迈信息','撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3643,1,'im.chat',2,'pc','2020-07-21 22:48:00','塔迈信息',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3644,1,'im.chat',2,'pc','2020-07-21 22:48:06','管理员、塔迈信息、张三','4567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3645,1,'im.chat',2,'pc','2020-07-21 22:56:26','塔迈信息','234567',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3646,1,'im.chat',2,'pc','2020-07-22 08:52:26','塔迈信息','345678',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3647,1,'im.read',1,'pc','2020-07-22 08:52:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3646}'),(3648,1,'im.chat',1,'pc','2020-07-22 09:28:15','管理员','5678',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3649,1,'im.read',2,'pc','2020-07-22 09:28:16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3648}'),(3650,1,'im.chat',1,'pc','2020-07-22 11:35:52','管理员','76543',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3651,1,'im.chat',1,'pc','2020-07-22 11:35:58','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3652,1,'im.chat',1,'pc','2020-07-22 11:36:02','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3653,1,'im.chat',1,'pc','2020-07-22 11:36:06','管理员',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3654,1,'im.read',2,'pc','2020-07-22 11:36:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3652}'),(3655,1,'im.read',2,'pc','2020-07-22 11:36:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3651}'),(3656,1,'im.read',2,'pc','2020-07-22 11:36:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3652}'),(3657,1,'im.read',2,'pc','2020-07-22 11:36:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3653}'),(3658,1,'im.read',2,'pc','2020-07-22 11:36:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3653}'),(3659,1,'im.read',2,'pc','2020-07-22 11:36:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3653}'),(3660,1,'im.chat',2,'pc','2020-07-22 11:36:45','塔迈信息','撒打发',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3661,1,'im.read',1,'pc','2020-07-22 11:36:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3660}'),(3662,1,'im.chat',2,'pc','2020-07-22 14:51:57','塔迈信息','撒旦发顺丰',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3663,1,'im.read',1,'pc','2020-07-22 14:52:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3662}'),(3664,1,'im.chat',1,'pc','2020-07-22 14:52:17','管理员','撒旦发',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3665,1,'im.read',2,'pc','2020-07-22 14:52:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'{\"retainDays\":3,\"msgId\":3664}'),(3666,1,'im.chat',1,'pc','2020-07-22 17:17:27','管理员','[管理员]撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3667,1,'im.chat',1,'pc','2020-07-22 17:48:35','管理员','[管理员]的沙发松岛枫',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(3668,1,'im.read',2,'pc','2020-07-22 17:49:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,3,'{\"msgId\":3667}'),(3669,1,'im.read',1,'pc','2020-07-28 17:15:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,3,'{\"msgId\":3651}'),(3670,1,'im.read',1,'pc','2020-07-28 17:15:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,3,'{\"msgId\":3652}'),(3671,1,'im.chat',1,'pc','2020-07-28 17:15:28','管理员','[管理员]撒地方',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_msg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_msg_receive`
--

DROP TABLE IF EXISTS `sys_msg_receive`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_msg_receive` (
  `id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `receive_status_phone` smallint(6) DEFAULT NULL,
  `receive_status_pc` smallint(6) DEFAULT NULL,
  `receive_time_phone` datetime DEFAULT NULL,
  `receive_time_pc` datetime DEFAULT NULL,
  `read_time` datetime DEFAULT NULL,
  `read_client_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`,`receiver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_msg_receive`
--

LOCK TABLES `sys_msg_receive` WRITE;
/*!40000 ALTER TABLE `sys_msg_receive` DISABLE KEYS */;
INSERT INTO `sys_msg_receive` VALUES (3346,1,0,0,NULL,NULL,NULL,NULL),(3346,2,0,0,NULL,NULL,NULL,NULL),(3347,1,0,0,NULL,NULL,NULL,NULL),(3347,2,0,0,NULL,NULL,NULL,NULL),(3348,1,0,0,NULL,NULL,NULL,NULL),(3348,2,0,0,NULL,NULL,NULL,NULL),(3349,1,0,0,NULL,NULL,NULL,NULL),(3349,2,0,0,NULL,NULL,NULL,NULL),(3350,1,0,0,NULL,NULL,NULL,NULL),(3350,2,0,0,NULL,NULL,NULL,NULL),(3351,1,0,0,NULL,NULL,NULL,NULL),(3351,2,0,0,NULL,NULL,NULL,NULL),(3352,1,0,0,NULL,NULL,NULL,NULL),(3352,2,0,0,NULL,NULL,NULL,NULL),(3353,1,0,0,NULL,NULL,NULL,NULL),(3353,2,0,0,NULL,NULL,NULL,NULL),(3354,1,0,0,NULL,NULL,NULL,NULL),(3354,2,0,0,NULL,NULL,NULL,NULL),(3355,1,0,0,NULL,NULL,NULL,NULL),(3355,2,0,0,NULL,NULL,NULL,NULL),(3356,1,0,0,NULL,NULL,NULL,NULL),(3356,2,0,0,NULL,NULL,NULL,NULL),(3357,1,0,0,NULL,NULL,NULL,NULL),(3357,2,0,0,NULL,NULL,NULL,NULL),(3358,1,0,0,NULL,NULL,NULL,NULL),(3358,2,0,0,NULL,NULL,NULL,NULL),(3359,1,0,0,NULL,NULL,NULL,NULL),(3359,2,0,0,NULL,NULL,NULL,NULL),(3360,1,0,0,NULL,NULL,NULL,NULL),(3360,2,0,0,NULL,NULL,NULL,NULL),(3361,1,0,0,NULL,NULL,NULL,NULL),(3361,2,0,0,NULL,NULL,NULL,NULL),(3362,1,0,0,NULL,NULL,NULL,NULL),(3362,2,0,0,NULL,NULL,NULL,NULL),(3363,1,0,0,NULL,NULL,NULL,NULL),(3363,2,0,0,NULL,NULL,NULL,NULL),(3364,1,0,0,NULL,NULL,NULL,NULL),(3364,2,0,0,NULL,NULL,NULL,NULL),(3365,1,0,0,NULL,NULL,NULL,NULL),(3365,2,0,0,NULL,NULL,NULL,NULL),(3366,1,0,0,NULL,NULL,NULL,NULL),(3366,2,0,0,NULL,NULL,NULL,NULL),(3367,1,0,0,NULL,NULL,NULL,NULL),(3367,2,0,0,NULL,NULL,NULL,NULL),(3368,1,0,0,NULL,NULL,NULL,NULL),(3368,2,0,0,NULL,NULL,NULL,NULL),(3369,1,0,0,NULL,NULL,NULL,NULL),(3369,2,0,0,NULL,NULL,NULL,NULL),(3370,1,0,0,NULL,NULL,NULL,NULL),(3370,2,0,0,NULL,NULL,NULL,NULL),(3371,1,0,0,NULL,NULL,NULL,NULL),(3371,2,0,0,NULL,NULL,NULL,NULL),(3372,1,0,0,NULL,NULL,NULL,NULL),(3372,2,0,0,NULL,NULL,NULL,NULL),(3373,1,0,0,NULL,NULL,NULL,NULL),(3373,2,0,0,NULL,NULL,NULL,NULL),(3374,1,0,0,NULL,NULL,NULL,NULL),(3374,2,0,0,NULL,NULL,NULL,NULL),(3375,1,0,0,NULL,NULL,NULL,NULL),(3375,2,0,0,NULL,NULL,NULL,NULL),(3376,1,0,0,NULL,NULL,NULL,NULL),(3376,2,0,0,NULL,NULL,NULL,NULL),(3377,1,0,0,NULL,NULL,NULL,NULL),(3377,2,0,0,NULL,NULL,NULL,NULL),(3378,1,0,0,NULL,NULL,NULL,NULL),(3378,2,0,0,NULL,NULL,NULL,NULL),(3379,1,0,0,NULL,NULL,NULL,NULL),(3379,2,0,0,NULL,NULL,NULL,NULL),(3380,1,0,0,NULL,NULL,NULL,NULL),(3380,2,0,0,NULL,NULL,NULL,NULL),(3381,1,0,0,NULL,NULL,NULL,NULL),(3381,2,0,0,NULL,NULL,NULL,NULL),(3382,1,0,0,NULL,NULL,NULL,NULL),(3382,2,0,0,NULL,NULL,NULL,NULL),(3383,1,0,0,NULL,NULL,NULL,NULL),(3383,2,0,0,NULL,NULL,NULL,NULL),(3384,1,0,0,NULL,NULL,NULL,NULL),(3384,2,0,0,NULL,NULL,NULL,NULL),(3385,1,0,0,NULL,NULL,NULL,NULL),(3385,5,0,0,NULL,NULL,NULL,NULL),(3386,1,0,0,NULL,NULL,NULL,NULL),(3386,2,0,0,NULL,NULL,NULL,NULL),(3387,2,0,0,NULL,NULL,NULL,NULL),(3388,1,0,0,NULL,NULL,NULL,NULL),(3388,2,0,0,NULL,NULL,NULL,NULL),(3389,2,0,0,NULL,NULL,NULL,NULL),(3390,1,0,0,NULL,NULL,NULL,NULL),(3390,2,0,0,NULL,NULL,NULL,NULL),(3391,1,0,0,NULL,NULL,NULL,NULL),(3392,1,0,0,NULL,NULL,NULL,NULL),(3392,2,0,0,NULL,NULL,NULL,NULL),(3393,2,0,0,NULL,NULL,NULL,NULL),(3401,1,0,0,NULL,NULL,NULL,NULL),(3401,2,0,0,NULL,NULL,NULL,NULL),(3402,2,0,0,NULL,NULL,NULL,NULL),(3403,1,0,0,NULL,NULL,NULL,NULL),(3403,2,0,0,NULL,NULL,'2020-07-13 15:08:12','pc'),(3404,2,0,0,NULL,NULL,NULL,NULL),(3405,1,0,0,NULL,NULL,'2020-07-13 15:33:54','pc'),(3405,2,0,0,NULL,NULL,NULL,NULL),(3406,1,0,0,NULL,NULL,NULL,NULL),(3407,1,0,0,NULL,NULL,'2020-07-13 15:53:59','pc'),(3407,2,0,0,NULL,NULL,NULL,NULL),(3408,1,0,0,NULL,NULL,NULL,NULL),(3409,1,0,0,NULL,NULL,NULL,NULL),(3409,2,0,0,NULL,NULL,'2020-07-13 15:54:38','pc'),(3410,2,0,0,NULL,NULL,NULL,NULL),(3411,1,0,0,NULL,NULL,NULL,NULL),(3411,2,0,0,NULL,NULL,NULL,NULL),(3412,1,0,0,NULL,NULL,NULL,NULL),(3412,2,0,0,NULL,NULL,NULL,NULL),(3413,1,0,0,NULL,NULL,NULL,NULL),(3413,2,0,0,NULL,NULL,NULL,NULL),(3414,1,0,0,NULL,NULL,NULL,NULL),(3414,2,0,0,NULL,NULL,NULL,NULL),(3415,1,0,0,NULL,NULL,NULL,NULL),(3415,2,0,0,NULL,NULL,NULL,NULL),(3416,1,0,0,NULL,NULL,NULL,NULL),(3416,2,0,0,NULL,NULL,NULL,NULL),(3417,1,0,0,NULL,NULL,NULL,NULL),(3417,2,0,0,NULL,NULL,NULL,NULL),(3418,2,0,0,NULL,NULL,NULL,NULL),(3419,1,0,0,NULL,NULL,NULL,NULL),(3419,2,0,0,NULL,NULL,NULL,NULL),(3420,2,0,0,NULL,NULL,NULL,NULL),(3421,1,0,0,NULL,NULL,'2020-07-13 17:35:57','pc'),(3421,2,0,0,NULL,NULL,NULL,NULL),(3422,1,0,0,NULL,NULL,NULL,NULL),(3423,1,0,0,NULL,NULL,NULL,NULL),(3424,1,0,0,NULL,NULL,NULL,NULL),(3424,2,0,0,NULL,NULL,'2020-07-13 18:01:52','pc'),(3425,2,0,0,NULL,NULL,NULL,NULL),(3426,1,0,0,NULL,NULL,NULL,NULL),(3426,2,0,0,NULL,NULL,'2020-07-13 18:04:56','pc'),(3427,2,0,0,NULL,NULL,NULL,NULL),(3428,2,0,0,NULL,NULL,NULL,NULL),(3429,2,0,0,NULL,NULL,NULL,NULL),(3429,5,0,0,NULL,NULL,NULL,NULL),(3430,1,0,0,NULL,NULL,NULL,NULL),(3430,2,0,0,NULL,NULL,NULL,NULL),(3431,1,0,0,NULL,NULL,NULL,NULL),(3431,2,0,0,NULL,NULL,NULL,NULL),(3432,2,0,0,NULL,NULL,NULL,NULL),(3433,1,0,0,NULL,NULL,NULL,NULL),(3433,2,0,0,NULL,NULL,NULL,NULL),(3434,2,0,0,NULL,NULL,NULL,NULL),(3435,1,0,0,NULL,NULL,NULL,NULL),(3435,2,0,0,NULL,NULL,'2020-07-16 08:40:10','pc'),(3436,2,0,0,NULL,NULL,NULL,NULL),(3437,1,0,0,NULL,NULL,NULL,NULL),(3437,2,0,0,NULL,NULL,'2020-07-16 08:40:40','pc'),(3438,2,0,0,NULL,NULL,NULL,NULL),(3439,1,0,0,NULL,NULL,'2020-07-16 08:40:52','pc'),(3439,2,0,0,NULL,NULL,NULL,NULL),(3440,1,0,0,NULL,NULL,NULL,NULL),(3441,1,0,0,NULL,NULL,'2020-07-16 14:41:54','pc'),(3441,2,0,0,NULL,NULL,NULL,NULL),(3442,1,0,0,NULL,NULL,NULL,NULL),(3443,1,0,0,NULL,NULL,NULL,NULL),(3443,2,0,0,NULL,NULL,NULL,NULL),(3444,1,0,0,NULL,NULL,'2020-07-16 21:15:40','pc'),(3444,2,0,0,NULL,NULL,NULL,NULL),(3445,1,0,0,NULL,NULL,NULL,NULL),(3446,1,0,0,NULL,NULL,NULL,NULL),(3447,1,0,0,NULL,NULL,NULL,NULL),(3447,2,0,0,NULL,NULL,NULL,NULL),(3448,1,0,0,NULL,NULL,NULL,NULL),(3448,2,0,0,NULL,NULL,NULL,NULL),(3449,1,0,0,NULL,NULL,NULL,NULL),(3449,2,0,0,NULL,NULL,'2020-07-16 21:38:39','pc'),(3450,2,0,0,NULL,NULL,NULL,NULL),(3451,1,0,0,NULL,NULL,NULL,NULL),(3451,2,0,0,NULL,NULL,NULL,NULL),(3451,5,0,0,NULL,NULL,NULL,NULL),(3452,1,0,0,NULL,NULL,'2020-07-18 15:09:08','pc'),(3452,2,0,0,NULL,NULL,NULL,NULL),(3452,5,0,0,NULL,NULL,NULL,NULL),(3453,1,0,0,NULL,NULL,'2020-07-18 15:09:08','pc'),(3453,2,0,0,NULL,NULL,NULL,NULL),(3453,5,0,0,NULL,NULL,NULL,NULL),(3454,1,0,0,NULL,NULL,'2020-07-18 15:09:08','pc'),(3454,2,0,0,NULL,NULL,NULL,NULL),(3454,5,0,0,NULL,NULL,NULL,NULL),(3455,1,0,0,NULL,NULL,'2020-07-18 15:09:08','pc'),(3455,2,0,0,NULL,NULL,NULL,NULL),(3455,5,0,0,NULL,NULL,NULL,NULL),(3456,1,0,0,NULL,NULL,NULL,NULL),(3457,1,0,0,NULL,NULL,NULL,NULL),(3457,2,0,0,NULL,NULL,'2020-07-18 15:09:13','pc'),(3457,5,0,0,NULL,NULL,NULL,NULL),(3458,2,0,0,NULL,NULL,NULL,NULL),(3459,1,0,0,NULL,NULL,'2020-07-18 15:09:40','pc'),(3459,2,0,0,NULL,NULL,NULL,NULL),(3459,5,0,0,NULL,NULL,NULL,NULL),(3460,1,0,0,NULL,NULL,NULL,NULL),(3461,1,0,0,NULL,NULL,NULL,NULL),(3461,2,0,0,NULL,NULL,NULL,NULL),(3461,5,0,0,NULL,NULL,NULL,NULL),(3462,2,0,0,NULL,NULL,NULL,NULL),(3463,1,0,0,NULL,NULL,'2020-07-18 15:10:20','pc'),(3463,2,0,0,NULL,NULL,NULL,NULL),(3463,5,0,0,NULL,NULL,NULL,NULL),(3464,1,0,0,NULL,NULL,NULL,NULL),(3465,1,0,0,NULL,NULL,NULL,NULL),(3465,2,0,0,NULL,NULL,'2020-07-18 15:10:28','pc'),(3465,5,0,0,NULL,NULL,NULL,NULL),(3466,2,0,0,NULL,NULL,NULL,NULL),(3467,1,0,0,NULL,NULL,'2020-07-18 15:10:44','pc'),(3467,2,0,0,NULL,NULL,NULL,NULL),(3467,5,0,0,NULL,NULL,NULL,NULL),(3468,1,0,0,NULL,NULL,NULL,NULL),(3469,1,0,0,NULL,NULL,'2020-07-18 15:10:55','pc'),(3469,2,0,0,NULL,NULL,NULL,NULL),(3469,5,0,0,NULL,NULL,NULL,NULL),(3470,1,0,0,NULL,NULL,NULL,NULL),(3471,1,0,0,NULL,NULL,NULL,NULL),(3472,1,0,0,NULL,NULL,NULL,NULL),(3472,2,0,0,NULL,NULL,'2020-07-18 15:11:11','pc'),(3472,5,0,0,NULL,NULL,NULL,NULL),(3473,2,0,0,NULL,NULL,NULL,NULL),(3474,1,0,0,NULL,NULL,NULL,NULL),(3474,2,0,0,NULL,NULL,'2020-07-18 15:13:55','pc'),(3474,5,0,0,NULL,NULL,NULL,NULL),(3475,2,0,0,NULL,NULL,NULL,NULL),(3476,1,0,0,NULL,NULL,'2020-07-18 15:15:01','pc'),(3476,2,0,0,NULL,NULL,NULL,NULL),(3476,5,0,0,NULL,NULL,NULL,NULL),(3477,1,0,0,NULL,NULL,NULL,NULL),(3478,1,0,0,NULL,NULL,NULL,NULL),(3478,2,0,0,NULL,NULL,'2020-07-18 15:15:20','pc'),(3478,5,0,0,NULL,NULL,NULL,NULL),(3479,2,0,0,NULL,NULL,NULL,NULL),(3480,1,0,0,NULL,NULL,NULL,NULL),(3480,2,0,0,NULL,NULL,'2020-07-18 15:15:25','pc'),(3480,5,0,0,NULL,NULL,NULL,NULL),(3481,2,0,0,NULL,NULL,NULL,NULL),(3482,1,0,0,NULL,NULL,'2020-07-18 15:15:35','pc'),(3482,2,0,0,NULL,NULL,NULL,NULL),(3482,5,0,0,NULL,NULL,NULL,NULL),(3483,1,0,0,NULL,NULL,NULL,NULL),(3484,1,0,0,NULL,NULL,NULL,NULL),(3484,2,0,0,NULL,NULL,NULL,NULL),(3484,5,0,0,NULL,NULL,NULL,NULL),(3484,6,0,0,NULL,NULL,NULL,NULL),(3485,1,0,0,NULL,NULL,NULL,NULL),(3485,2,0,0,NULL,NULL,NULL,NULL),(3485,5,0,0,NULL,NULL,NULL,NULL),(3486,1,0,0,NULL,NULL,NULL,NULL),(3486,2,0,0,NULL,NULL,NULL,NULL),(3486,5,0,0,NULL,NULL,NULL,NULL),(3486,6,0,0,NULL,NULL,NULL,NULL),(3487,1,0,0,NULL,NULL,NULL,NULL),(3487,2,0,0,NULL,NULL,'2020-07-18 22:55:28','pc'),(3487,5,0,0,NULL,NULL,NULL,NULL),(3487,6,0,0,NULL,NULL,NULL,NULL),(3488,2,0,0,NULL,NULL,NULL,NULL),(3489,1,0,0,NULL,NULL,NULL,NULL),(3489,2,0,0,NULL,NULL,NULL,NULL),(3489,5,0,0,NULL,NULL,NULL,NULL),(3490,1,0,0,NULL,NULL,NULL,NULL),(3490,2,0,0,NULL,NULL,'2020-07-18 23:32:54','pc'),(3490,5,0,0,NULL,NULL,NULL,NULL),(3491,2,0,0,NULL,NULL,NULL,NULL),(3492,1,0,0,NULL,NULL,NULL,NULL),(3492,2,0,0,NULL,NULL,NULL,NULL),(3492,5,0,0,NULL,NULL,NULL,NULL),(3492,6,0,0,NULL,NULL,NULL,NULL),(3493,1,0,0,NULL,NULL,NULL,NULL),(3493,2,0,0,NULL,NULL,NULL,NULL),(3493,5,0,0,NULL,NULL,NULL,NULL),(3494,1,0,0,NULL,NULL,NULL,NULL),(3494,2,0,0,NULL,NULL,'2020-07-19 13:07:35','pc'),(3495,2,0,0,NULL,NULL,NULL,NULL),(3496,1,0,0,NULL,NULL,NULL,NULL),(3496,2,0,0,NULL,NULL,'2020-07-19 13:27:48','pc'),(3496,5,0,0,NULL,NULL,NULL,NULL),(3497,2,0,0,NULL,NULL,NULL,NULL),(3498,1,0,0,NULL,NULL,NULL,NULL),(3498,2,0,0,NULL,NULL,NULL,NULL),(3498,5,0,0,NULL,NULL,NULL,NULL),(3498,6,0,0,NULL,NULL,NULL,NULL),(3499,1,0,0,NULL,NULL,'2020-07-19 14:34:13','pc'),(3499,2,0,0,NULL,NULL,NULL,NULL),(3499,5,0,0,NULL,NULL,NULL,NULL),(3500,1,0,0,NULL,NULL,NULL,NULL),(3501,1,0,0,NULL,NULL,NULL,NULL),(3501,2,0,0,NULL,NULL,NULL,NULL),(3501,5,0,0,NULL,NULL,NULL,NULL),(3501,6,0,0,NULL,NULL,NULL,NULL),(3502,1,0,0,NULL,NULL,NULL,NULL),(3502,2,0,0,NULL,NULL,'2020-07-19 16:33:01','pc'),(3502,5,0,0,NULL,NULL,NULL,NULL),(3502,6,0,0,NULL,NULL,NULL,NULL),(3503,2,0,0,NULL,NULL,NULL,NULL),(3504,1,0,0,NULL,NULL,'2020-07-19 16:33:52','pc'),(3504,2,0,0,NULL,NULL,NULL,NULL),(3504,5,0,0,NULL,NULL,NULL,NULL),(3505,1,0,0,NULL,NULL,NULL,NULL),(3506,1,0,0,NULL,NULL,NULL,NULL),(3506,2,0,0,NULL,NULL,'2020-07-20 09:43:11','pc'),(3506,5,0,0,NULL,NULL,NULL,NULL),(3507,2,0,0,NULL,NULL,NULL,NULL),(3508,1,0,0,NULL,NULL,NULL,NULL),(3508,2,0,0,NULL,NULL,NULL,NULL),(3508,5,0,0,NULL,NULL,NULL,NULL),(3508,6,0,0,NULL,NULL,NULL,NULL),(3509,1,0,0,NULL,NULL,NULL,NULL),(3509,2,0,0,NULL,NULL,'2020-07-20 10:10:59','pc'),(3509,5,0,0,NULL,NULL,NULL,NULL),(3510,2,0,0,NULL,NULL,NULL,NULL),(3511,1,0,0,NULL,NULL,NULL,NULL),(3511,2,0,0,NULL,NULL,NULL,NULL),(3511,5,0,0,NULL,NULL,NULL,NULL),(3511,6,0,0,NULL,NULL,NULL,NULL),(3512,1,0,0,NULL,NULL,NULL,NULL),(3512,2,0,0,NULL,NULL,'2020-07-20 10:18:02','pc'),(3512,5,0,0,NULL,NULL,NULL,NULL),(3513,2,0,0,NULL,NULL,NULL,NULL),(3514,1,0,0,NULL,NULL,NULL,NULL),(3514,2,0,0,NULL,NULL,NULL,NULL),(3514,5,0,0,NULL,NULL,NULL,NULL),(3514,6,0,0,NULL,NULL,NULL,NULL),(3515,1,0,0,NULL,NULL,'2020-07-20 10:22:45','pc'),(3515,2,0,0,NULL,NULL,NULL,NULL),(3515,5,0,0,NULL,NULL,NULL,NULL),(3516,1,0,0,NULL,NULL,NULL,NULL),(3517,1,0,0,NULL,NULL,NULL,NULL),(3517,2,0,0,NULL,NULL,NULL,NULL),(3517,5,0,0,NULL,NULL,NULL,NULL),(3517,6,0,0,NULL,NULL,NULL,NULL),(3518,1,0,0,NULL,NULL,'2020-07-20 10:22:58','pc'),(3518,2,0,0,NULL,NULL,NULL,NULL),(3518,5,0,0,NULL,NULL,NULL,NULL),(3518,6,0,0,NULL,NULL,NULL,NULL),(3519,1,0,0,NULL,NULL,NULL,NULL),(3520,1,0,0,NULL,NULL,'2020-07-20 10:23:47','pc'),(3520,2,0,0,NULL,NULL,NULL,NULL),(3520,5,0,0,NULL,NULL,NULL,NULL),(3521,1,0,0,NULL,NULL,NULL,NULL),(3522,1,0,0,NULL,NULL,NULL,NULL),(3522,2,0,0,NULL,NULL,NULL,NULL),(3522,5,0,0,NULL,NULL,NULL,NULL),(3522,6,0,0,NULL,NULL,NULL,NULL),(3523,1,0,0,NULL,NULL,'2020-07-20 10:23:58','pc'),(3523,2,0,0,NULL,NULL,NULL,NULL),(3523,5,0,0,NULL,NULL,NULL,NULL),(3523,6,0,0,NULL,NULL,NULL,NULL),(3524,1,0,0,NULL,NULL,NULL,NULL),(3525,1,0,0,NULL,NULL,NULL,NULL),(3525,2,0,0,NULL,NULL,NULL,NULL),(3525,6,0,0,NULL,NULL,NULL,NULL),(3526,1,0,0,NULL,NULL,'2020-07-20 10:25:21','pc'),(3526,2,0,0,NULL,NULL,NULL,NULL),(3526,5,0,0,NULL,NULL,NULL,NULL),(3527,1,0,0,NULL,NULL,NULL,NULL),(3528,1,0,0,NULL,NULL,NULL,NULL),(3528,2,0,0,NULL,NULL,NULL,NULL),(3528,5,0,0,NULL,NULL,NULL,NULL),(3528,6,0,0,NULL,NULL,NULL,NULL),(3529,1,0,0,NULL,NULL,NULL,NULL),(3529,2,0,0,NULL,NULL,NULL,NULL),(3529,5,0,0,NULL,NULL,NULL,NULL),(3529,6,0,0,NULL,NULL,NULL,NULL),(3530,1,0,0,NULL,NULL,NULL,NULL),(3531,1,0,0,NULL,NULL,NULL,NULL),(3531,2,0,0,NULL,NULL,NULL,NULL),(3531,6,0,0,NULL,NULL,NULL,NULL),(3532,1,0,0,NULL,NULL,NULL,NULL),(3532,2,0,0,NULL,NULL,NULL,NULL),(3532,5,0,0,NULL,NULL,NULL,NULL),(3532,6,0,0,NULL,NULL,NULL,NULL),(3533,1,0,0,NULL,NULL,NULL,NULL),(3533,2,0,0,NULL,NULL,NULL,NULL),(3533,5,0,0,NULL,NULL,NULL,NULL),(3534,1,0,0,NULL,NULL,NULL,NULL),(3534,2,0,0,NULL,NULL,NULL,NULL),(3534,5,0,0,NULL,NULL,NULL,NULL),(3534,6,0,0,NULL,NULL,NULL,NULL),(3535,1,0,0,NULL,NULL,NULL,NULL),(3535,5,0,0,NULL,NULL,NULL,NULL),(3535,6,0,0,NULL,NULL,NULL,NULL),(3536,1,0,0,NULL,NULL,NULL,NULL),(3536,2,0,0,NULL,NULL,NULL,NULL),(3536,6,0,0,NULL,NULL,NULL,NULL),(3537,1,0,0,NULL,NULL,'2020-07-20 10:54:20','pc'),(3537,2,0,0,NULL,NULL,NULL,NULL),(3537,5,0,0,NULL,NULL,NULL,NULL),(3537,6,0,0,NULL,NULL,NULL,NULL),(3538,1,0,0,NULL,NULL,NULL,NULL),(3539,1,0,0,NULL,NULL,NULL,NULL),(3539,2,0,0,NULL,NULL,NULL,NULL),(3539,5,0,0,NULL,NULL,NULL,NULL),(3539,6,0,0,NULL,NULL,NULL,NULL),(3540,1,0,0,NULL,NULL,'2020-07-20 11:24:09','pc'),(3540,2,0,0,NULL,NULL,NULL,NULL),(3540,5,0,0,NULL,NULL,NULL,NULL),(3541,1,0,0,NULL,NULL,NULL,NULL),(3542,1,0,0,NULL,NULL,NULL,NULL),(3542,2,0,0,NULL,NULL,NULL,NULL),(3542,5,0,0,NULL,NULL,NULL,NULL),(3543,1,0,0,NULL,NULL,NULL,NULL),(3543,5,0,0,NULL,NULL,NULL,NULL),(3543,6,0,0,NULL,NULL,NULL,NULL),(3544,2,0,0,NULL,NULL,NULL,NULL),(3545,2,0,0,NULL,NULL,NULL,NULL),(3546,2,0,0,NULL,NULL,NULL,NULL),(3547,2,0,0,NULL,NULL,NULL,NULL),(3548,2,0,0,NULL,NULL,NULL,NULL),(3548,5,0,0,NULL,NULL,NULL,NULL),(3548,6,0,0,NULL,NULL,NULL,NULL),(3549,2,0,0,NULL,NULL,NULL,NULL),(3550,2,0,0,NULL,NULL,NULL,NULL),(3551,1,0,0,NULL,NULL,NULL,NULL),(3551,2,0,0,NULL,NULL,NULL,NULL),(3551,5,0,0,NULL,NULL,NULL,NULL),(3551,6,0,0,NULL,NULL,NULL,NULL),(3552,1,0,0,NULL,NULL,NULL,NULL),(3552,2,0,0,NULL,NULL,'2020-07-20 14:40:20','pc'),(3552,5,0,0,NULL,NULL,NULL,NULL),(3552,6,0,0,NULL,NULL,NULL,NULL),(3553,2,0,0,NULL,NULL,NULL,NULL),(3554,1,0,0,NULL,NULL,NULL,NULL),(3555,1,0,0,NULL,NULL,NULL,NULL),(3556,2,0,0,NULL,NULL,NULL,NULL),(3556,5,0,0,NULL,NULL,NULL,NULL),(3556,6,0,0,NULL,NULL,NULL,NULL),(3557,1,0,0,NULL,NULL,NULL,NULL),(3557,2,0,0,NULL,NULL,'2020-07-20 14:43:00','pc'),(3557,5,0,0,NULL,NULL,NULL,NULL),(3557,6,0,0,NULL,NULL,NULL,NULL),(3558,2,0,0,NULL,NULL,NULL,NULL),(3559,2,0,0,NULL,NULL,NULL,NULL),(3559,5,0,0,NULL,NULL,NULL,NULL),(3559,6,0,0,NULL,NULL,NULL,NULL),(3560,2,0,0,NULL,NULL,NULL,NULL),(3560,5,0,0,NULL,NULL,NULL,NULL),(3560,6,0,0,NULL,NULL,NULL,NULL),(3561,1,0,0,NULL,NULL,NULL,NULL),(3561,2,0,0,NULL,NULL,NULL,NULL),(3561,5,0,0,NULL,NULL,NULL,NULL),(3561,6,0,0,NULL,NULL,NULL,NULL),(3562,1,0,0,NULL,NULL,NULL,NULL),(3562,2,0,0,NULL,NULL,'2020-07-20 14:43:36','pc'),(3562,5,0,0,NULL,NULL,NULL,NULL),(3562,6,0,0,NULL,NULL,NULL,NULL),(3563,2,0,0,NULL,NULL,NULL,NULL),(3564,1,0,0,NULL,NULL,NULL,NULL),(3564,2,0,0,NULL,NULL,NULL,NULL),(3564,5,0,0,NULL,NULL,NULL,NULL),(3565,1,0,0,NULL,NULL,NULL,NULL),(3565,2,0,0,NULL,NULL,NULL,NULL),(3565,5,0,0,NULL,NULL,NULL,NULL),(3566,1,0,0,NULL,NULL,'2020-07-20 15:17:51','pc'),(3566,2,0,0,NULL,NULL,NULL,NULL),(3566,6,0,0,NULL,NULL,NULL,NULL),(3567,1,0,0,NULL,NULL,NULL,NULL),(3568,1,0,0,NULL,NULL,NULL,NULL),(3568,2,0,0,NULL,NULL,NULL,NULL),(3568,6,0,0,NULL,NULL,NULL,NULL),(3569,1,0,0,NULL,NULL,NULL,NULL),(3569,2,0,0,NULL,NULL,NULL,NULL),(3569,5,0,0,NULL,NULL,NULL,NULL),(3569,6,0,0,NULL,NULL,NULL,NULL),(3570,1,0,0,NULL,NULL,NULL,NULL),(3570,2,0,0,NULL,NULL,NULL,NULL),(3570,5,0,0,NULL,NULL,NULL,NULL),(3570,6,0,0,NULL,NULL,NULL,NULL),(3571,1,0,0,NULL,NULL,NULL,NULL),(3571,2,0,0,NULL,NULL,NULL,NULL),(3571,5,0,0,NULL,NULL,NULL,NULL),(3572,1,0,0,NULL,NULL,NULL,NULL),(3572,2,0,0,NULL,NULL,NULL,NULL),(3572,5,0,0,NULL,NULL,NULL,NULL),(3573,1,0,0,NULL,NULL,NULL,NULL),(3574,1,0,0,NULL,NULL,NULL,NULL),(3575,1,0,0,NULL,NULL,NULL,NULL),(3576,1,0,0,NULL,NULL,NULL,NULL),(3577,1,0,0,NULL,NULL,NULL,NULL),(3577,2,0,0,NULL,NULL,NULL,NULL),(3578,1,0,0,NULL,NULL,NULL,NULL),(3578,2,0,0,NULL,NULL,NULL,NULL),(3578,5,0,0,NULL,NULL,NULL,NULL),(3578,6,0,0,NULL,NULL,NULL,NULL),(3580,1,0,0,NULL,NULL,NULL,NULL),(3580,2,0,0,NULL,NULL,NULL,NULL),(3580,5,0,0,NULL,NULL,NULL,NULL),(3580,6,0,0,NULL,NULL,NULL,NULL),(3581,1,0,0,NULL,NULL,NULL,NULL),(3581,2,0,0,NULL,NULL,NULL,NULL),(3581,6,0,0,NULL,NULL,NULL,NULL),(3582,1,0,0,NULL,NULL,NULL,NULL),(3582,2,0,0,NULL,NULL,NULL,NULL),(3582,5,0,0,NULL,NULL,NULL,NULL),(3582,6,0,0,NULL,NULL,NULL,NULL),(3583,1,0,0,NULL,NULL,NULL,NULL),(3583,2,0,0,NULL,NULL,NULL,NULL),(3583,5,0,0,NULL,NULL,NULL,NULL),(3583,6,0,0,NULL,NULL,NULL,NULL),(3584,1,0,0,NULL,NULL,NULL,NULL),(3584,2,0,0,NULL,NULL,NULL,NULL),(3585,1,0,0,NULL,NULL,NULL,NULL),(3585,2,0,0,NULL,NULL,NULL,NULL),(3586,1,0,0,NULL,NULL,NULL,NULL),(3586,2,0,0,NULL,NULL,NULL,NULL),(3587,1,0,0,NULL,NULL,NULL,NULL),(3587,2,0,0,NULL,NULL,NULL,NULL),(3588,1,0,0,NULL,NULL,NULL,NULL),(3588,2,0,0,NULL,NULL,NULL,NULL),(3588,5,0,0,NULL,NULL,NULL,NULL),(3588,6,0,0,NULL,NULL,NULL,NULL),(3589,1,0,0,NULL,NULL,NULL,NULL),(3589,2,0,0,NULL,NULL,NULL,NULL),(3589,5,0,0,NULL,NULL,NULL,NULL),(3589,6,0,0,NULL,NULL,NULL,NULL),(3590,1,0,0,NULL,NULL,NULL,NULL),(3590,2,0,0,NULL,NULL,NULL,NULL),(3590,5,0,0,NULL,NULL,NULL,NULL),(3590,6,0,0,NULL,NULL,NULL,NULL),(3591,1,0,0,NULL,NULL,NULL,NULL),(3591,2,0,0,NULL,NULL,NULL,NULL),(3591,5,0,0,NULL,NULL,NULL,NULL),(3591,6,0,0,NULL,NULL,NULL,NULL),(3592,1,0,0,NULL,NULL,NULL,NULL),(3592,2,0,0,NULL,NULL,NULL,NULL),(3592,5,0,0,NULL,NULL,NULL,NULL),(3592,6,0,0,NULL,NULL,NULL,NULL),(3593,1,0,0,NULL,NULL,NULL,NULL),(3593,2,0,0,NULL,NULL,NULL,NULL),(3593,5,0,0,NULL,NULL,NULL,NULL),(3593,6,0,0,NULL,NULL,NULL,NULL),(3594,1,0,0,NULL,NULL,NULL,NULL),(3594,2,0,0,NULL,NULL,NULL,NULL),(3594,5,0,0,NULL,NULL,NULL,NULL),(3594,6,0,0,NULL,NULL,NULL,NULL),(3595,1,0,0,NULL,NULL,NULL,NULL),(3595,2,0,0,NULL,NULL,NULL,NULL),(3595,5,0,0,NULL,NULL,NULL,NULL),(3595,6,0,0,NULL,NULL,NULL,NULL),(3596,1,0,0,NULL,NULL,NULL,NULL),(3596,2,0,0,NULL,NULL,NULL,NULL),(3596,5,0,0,NULL,NULL,NULL,NULL),(3596,6,0,0,NULL,NULL,NULL,NULL),(3597,1,0,0,NULL,NULL,NULL,NULL),(3597,2,0,0,NULL,NULL,NULL,NULL),(3597,5,0,0,NULL,NULL,NULL,NULL),(3597,6,0,0,NULL,NULL,NULL,NULL),(3598,1,0,0,NULL,NULL,NULL,NULL),(3598,5,0,0,NULL,NULL,NULL,NULL),(3599,1,0,0,NULL,NULL,NULL,NULL),(3599,2,0,0,NULL,NULL,NULL,NULL),(3600,1,0,0,NULL,NULL,NULL,NULL),(3600,5,0,0,NULL,NULL,NULL,NULL),(3601,1,0,0,NULL,NULL,NULL,NULL),(3601,6,0,0,NULL,NULL,NULL,NULL),(3602,1,0,0,NULL,NULL,NULL,NULL),(3602,2,0,0,NULL,NULL,NULL,NULL),(3603,1,0,0,NULL,NULL,NULL,NULL),(3603,2,0,0,NULL,NULL,NULL,NULL),(3603,5,0,0,NULL,NULL,NULL,NULL),(3604,1,0,0,NULL,NULL,NULL,NULL),(3604,6,0,0,NULL,NULL,NULL,NULL),(3605,1,0,0,NULL,NULL,'2020-07-21 15:18:20','pc'),(3605,2,0,0,NULL,NULL,NULL,NULL),(3606,1,0,0,NULL,NULL,NULL,NULL),(3607,1,0,0,NULL,NULL,NULL,NULL),(3608,1,0,0,NULL,NULL,NULL,NULL),(3608,2,0,0,NULL,NULL,NULL,NULL),(3609,1,0,0,NULL,NULL,NULL,NULL),(3609,2,0,0,NULL,NULL,NULL,NULL),(3610,1,0,0,NULL,NULL,NULL,NULL),(3610,2,0,0,NULL,NULL,NULL,NULL),(3611,1,0,0,NULL,NULL,NULL,NULL),(3611,2,0,0,NULL,NULL,'2020-07-21 16:37:22','pc'),(3612,1,0,0,NULL,NULL,NULL,NULL),(3612,2,0,0,NULL,NULL,NULL,NULL),(3613,1,0,0,NULL,NULL,NULL,NULL),(3613,2,0,0,NULL,NULL,'2020-07-21 16:48:14','pc'),(3614,1,0,0,NULL,NULL,NULL,NULL),(3614,2,0,0,NULL,NULL,NULL,NULL),(3615,2,0,0,NULL,NULL,NULL,NULL),(3616,1,0,0,NULL,NULL,NULL,NULL),(3616,2,0,0,NULL,NULL,'2020-07-21 17:04:05','pc'),(3617,2,0,0,NULL,NULL,NULL,NULL),(3618,2,0,0,NULL,NULL,NULL,NULL),(3619,2,0,0,NULL,NULL,NULL,NULL),(3620,1,0,0,NULL,NULL,'2020-07-21 17:24:08','pc'),(3620,2,0,0,NULL,NULL,NULL,NULL),(3621,1,0,0,NULL,NULL,NULL,NULL),(3622,1,0,0,NULL,NULL,NULL,NULL),(3623,1,0,0,NULL,NULL,NULL,NULL),(3623,2,0,0,NULL,NULL,'2020-07-21 17:31:11','pc'),(3623,5,0,0,NULL,NULL,NULL,NULL),(3624,2,0,0,NULL,NULL,NULL,NULL),(3625,2,0,0,NULL,NULL,NULL,NULL),(3626,1,0,0,NULL,NULL,NULL,NULL),(3626,2,0,0,NULL,NULL,'2020-07-21 18:17:30','pc'),(3626,5,0,0,NULL,NULL,NULL,NULL),(3627,2,0,0,NULL,NULL,NULL,NULL),(3628,2,0,0,NULL,NULL,NULL,NULL),(3629,1,0,0,NULL,NULL,NULL,NULL),(3629,2,0,0,NULL,NULL,'2020-07-21 18:18:44','pc'),(3629,5,0,0,NULL,NULL,NULL,NULL),(3630,2,0,0,NULL,NULL,NULL,NULL),(3631,2,0,0,NULL,NULL,NULL,NULL),(3632,1,0,0,NULL,NULL,NULL,NULL),(3632,2,0,0,NULL,NULL,'2020-07-21 18:19:42','pc'),(3632,5,0,0,NULL,NULL,NULL,NULL),(3633,2,0,0,NULL,NULL,NULL,NULL),(3634,1,0,0,NULL,NULL,NULL,NULL),(3634,2,0,0,NULL,NULL,'2020-07-21 18:19:48','pc'),(3634,5,0,0,NULL,NULL,NULL,NULL),(3635,2,0,0,NULL,NULL,NULL,NULL),(3636,1,0,0,NULL,NULL,NULL,NULL),(3636,2,0,0,NULL,NULL,NULL,NULL),(3636,5,0,0,NULL,NULL,NULL,NULL),(3637,2,0,0,NULL,NULL,NULL,NULL),(3637,5,0,0,NULL,NULL,NULL,NULL),(3638,2,0,0,NULL,NULL,NULL,NULL),(3638,6,0,0,NULL,NULL,NULL,NULL),(3639,1,0,0,NULL,NULL,'2020-07-21 18:53:10','pc'),(3639,2,0,0,NULL,NULL,NULL,NULL),(3639,5,0,0,NULL,NULL,NULL,NULL),(3640,1,0,0,NULL,NULL,NULL,NULL),(3641,1,0,0,NULL,NULL,NULL,NULL),(3642,1,0,0,NULL,NULL,NULL,NULL),(3642,2,0,0,NULL,NULL,NULL,NULL),(3643,1,0,0,NULL,NULL,NULL,NULL),(3643,2,0,0,NULL,NULL,NULL,NULL),(3644,1,0,0,NULL,NULL,NULL,NULL),(3644,2,0,0,NULL,NULL,NULL,NULL),(3644,5,0,0,NULL,NULL,NULL,NULL),(3645,1,0,0,NULL,NULL,NULL,NULL),(3645,2,0,0,NULL,NULL,NULL,NULL),(3646,1,0,0,NULL,NULL,NULL,NULL),(3646,2,0,0,NULL,NULL,'2020-07-22 08:52:30','pc'),(3647,2,0,0,NULL,NULL,NULL,NULL),(3648,1,0,0,NULL,NULL,'2020-07-22 09:28:15','pc'),(3648,2,0,0,NULL,NULL,NULL,NULL),(3649,1,0,0,NULL,NULL,NULL,NULL),(3650,1,0,0,NULL,NULL,'2020-07-22 11:36:33','pc'),(3650,2,0,0,NULL,NULL,NULL,NULL),(3651,1,0,0,NULL,NULL,'2020-07-28 17:15:25','pc'),(3651,2,0,0,NULL,NULL,NULL,NULL),(3652,1,0,0,NULL,NULL,'2020-07-28 17:15:25','pc'),(3652,2,0,0,NULL,NULL,NULL,NULL),(3653,1,0,0,NULL,NULL,'2020-07-22 11:36:37','pc'),(3653,2,0,0,NULL,NULL,NULL,NULL),(3654,1,0,0,NULL,NULL,NULL,NULL),(3655,1,0,0,NULL,NULL,NULL,NULL),(3656,1,0,0,NULL,NULL,NULL,NULL),(3657,1,0,0,NULL,NULL,NULL,NULL),(3658,1,0,0,NULL,NULL,NULL,NULL),(3659,1,0,0,NULL,NULL,NULL,NULL),(3660,1,0,0,NULL,NULL,NULL,NULL),(3660,2,0,0,NULL,NULL,'2020-07-22 11:36:44','pc'),(3661,2,0,0,NULL,NULL,NULL,NULL),(3662,1,0,0,NULL,NULL,NULL,NULL),(3662,2,0,0,NULL,NULL,'2020-07-22 14:52:15','pc'),(3663,2,0,0,NULL,NULL,NULL,NULL),(3664,1,0,0,NULL,NULL,'2020-07-22 14:52:17','pc'),(3664,2,0,0,NULL,NULL,NULL,NULL),(3665,1,0,0,NULL,NULL,NULL,NULL),(3666,1,0,0,NULL,NULL,'2020-07-22 17:49:24','pc'),(3666,2,0,0,NULL,NULL,NULL,NULL),(3667,1,0,0,NULL,NULL,'2020-07-22 17:49:24','pc'),(3667,2,0,0,NULL,NULL,NULL,NULL),(3668,1,0,0,NULL,NULL,NULL,NULL),(3669,1,0,0,NULL,NULL,NULL,NULL),(3670,1,0,0,NULL,NULL,NULL,NULL),(3671,1,0,0,NULL,NULL,NULL,NULL),(3671,2,0,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_msg_receive` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_org`
--

DROP TABLE IF EXISTS `sys_org`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `code` varchar(16) NOT NULL DEFAULT '' COMMENT '代码',
  `name` varchar(200) NOT NULL COMMENT '名称',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  `status` tinyint(4) NOT NULL COMMENT '已禁用',
  `user_count` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `default_pwd` varchar(100) DEFAULT NULL,
  `look_all` smallint(1) DEFAULT NULL,
  `look_self_bureau` smallint(1) DEFAULT NULL,
  `look_self_dep` smallint(1) DEFAULT NULL,
  `look_leader` smallint(1) DEFAULT NULL,
  `look_under` smallint(1) DEFAULT NULL,
  `create_group` smallint(1) DEFAULT NULL,
  `disable_chat` smallint(1) DEFAULT NULL,
  `only_app_center` smallint(1) DEFAULT NULL,
  `logo_image` varchar(200) DEFAULT NULL,
  `launch_image` varchar(200) DEFAULT NULL,
  `custom_install_package` smallint(1) DEFAULT NULL,
  `allow_add_friend` smallint(1) DEFAULT NULL,
  `show_nickname_in_user_list` smallint(1) DEFAULT NULL,
  `show_post_in_user_list` smallint(1) DEFAULT NULL,
  `show_motto_in_user_list` smallint(1) DEFAULT NULL,
  `show_type_in_role_list` smallint(1) DEFAULT NULL,
  `show_description_in_role_list` smallint(1) DEFAULT NULL,
  `client_view_title_bgcolor` varchar(45) DEFAULT NULL,
  `client_button_bgcolor` varchar(45) DEFAULT NULL,
  `disable_work_circle` smallint(1) DEFAULT NULL,
  `app_center_url` varchar(200) DEFAULT NULL,
  `app_center_title` varchar(45) DEFAULT NULL,
  `work_circle_title` varchar(45) DEFAULT NULL,
  `disable_address_book` smallint(1) DEFAULT NULL,
  `allow_regist` smallint(1) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `msg_center_title` varchar(20) DEFAULT NULL,
  `show_netstatus_in_user_list` smallint(1) DEFAULT NULL,
  `user_cell_left_info` varchar(45) DEFAULT NULL,
  `user_cell_right_info` varchar(45) DEFAULT NULL,
  `user_cell_bottom_info` varchar(45) DEFAULT NULL,
  `regist_url` varchar(200) DEFAULT NULL,
  `disable_appmarket` smallint(6) DEFAULT NULL,
  `show_app_center_banner` smallint(1) DEFAULT NULL,
  `app_center_banner_height` int(11) DEFAULT NULL,
  `bind_client_device` smallint(1) DEFAULT NULL,
  `disable_chpwd` int(11) DEFAULT NULL,
  `disable_taskmsg` int(11) DEFAULT NULL,
  `disable_msg_center` int(11) DEFAULT NULL,
  `appcenter_netdisk` int(11) DEFAULT NULL,
  `bottom_mail` int(11) DEFAULT NULL,
  `disable_app_center` int(11) DEFAULT NULL,
  `disable_set_ad` int(11) DEFAULT NULL,
  `disable_set_logo` int(11) DEFAULT NULL,
  `disable_set_slogan` int(11) DEFAULT NULL,
  `disable_set_launch_image` int(11) DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  `apns_channel` int(11) DEFAULT NULL,
  `server_device_code` varchar(64) DEFAULT NULL,
  `mps_addr` varchar(100) DEFAULT NULL,
  `mps_port` int(11) DEFAULT NULL,
  `web_addr` varchar(100) DEFAULT NULL,
  `web_port` int(11) DEFAULT NULL,
  `tcpfile_addr` varchar(100) DEFAULT NULL,
  `tcpfile_port` int(11) DEFAULT NULL,
  `httpfile_addr` varchar(100) DEFAULT NULL,
  `httpfile_port` int(11) DEFAULT NULL,
  `ddns_type` varchar(10) DEFAULT NULL,
  `disk_limit` int(11) DEFAULT NULL,
  `disk_limit_unit` varchar(2) DEFAULT NULL,
  `file_size_limit` int(11) DEFAULT NULL,
  `auth_end_date` datetime DEFAULT NULL,
  `online_play_addr` varchar(200) DEFAULT NULL,
  `watermark_path` varchar(200) DEFAULT NULL,
  `ignore_pc_online` smallint(6) DEFAULT NULL,
  `hide_about` smallint(6) DEFAULT NULL,
  `auth_key` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_org`
--

LOCK TABLES `sys_org` WRITE;
/*!40000 ALTER TABLE `sys_org` DISABLE KEYS */;
INSERT INTO `sys_org` VALUES (1,'taskmsg','任讯信息','',0,20,'2015-05-01 18:18:31',1,'2020-11-01 23:05:58','f9429ab0b5f04baf1e9dd1cef50cbd8f',1,1,0,1,0,1,0,0,NULL,NULL,0,0,0,0,0,1,0,NULL,NULL,0,'','','',0,0,NULL,NULL,0,'loginname','tel_work','email',NULL,NULL,1,400,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'f84707a40cf74ec18b3eefb76f16d58a');
/*!40000 ALTER TABLE `sys_org` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_org_app`
--

DROP TABLE IF EXISTS `sys_org_app`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_org_app` (
  `org_id` int(11) NOT NULL,
  `app_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `installer_id` int(11) NOT NULL,
  `install_time` datetime NOT NULL,
  `order_no` int(11) DEFAULT NULL,
  `titlebar_color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`org_id`,`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_org_app`
--

LOCK TABLES `sys_org_app` WRITE;
/*!40000 ALTER TABLE `sys_org_app` DISABLE KEYS */;
INSERT INTO `sys_org_app` VALUES (1,1,0,1,1,'2015-10-13 15:16:31',1,NULL),(1,2,0,1,1,'2015-10-13 15:16:31',2,NULL),(1,3,0,1,1,'2015-10-13 15:16:31',3,NULL),(1,4,0,1,1,'2015-10-13 15:16:31',4,NULL),(1,5,0,1,1,'2015-10-13 15:16:31',5,NULL),(1,6,0,1,1,'2015-10-13 15:16:31',6,NULL),(1,7,0,1,1,'2020-04-07 17:04:04',7,NULL),(1,8,0,1,1,'2020-04-07 17:04:41',8,NULL),(1,9,0,1,1,'2020-04-07 17:07:04',9,NULL),(1,10,0,1,1,'2020-04-07 17:38:36',10,NULL);
/*!40000 ALTER TABLE `sys_org_app` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_org_app_category`
--

DROP TABLE IF EXISTS `sys_org_app_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_org_app_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) DEFAULT NULL,
  `name` varchar(45) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `org_id` int(11) NOT NULL,
  `group_apps` smallint(4) DEFAULT NULL,
  `icon_code` varchar(45) DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_org_app_category`
--

LOCK TABLES `sys_org_app_category` WRITE;
/*!40000 ALTER TABLE `sys_org_app_category` DISABLE KEYS */;
INSERT INTO `sys_org_app_category` VALUES (1,'sys','系统维护',0,1,NULL,NULL,9999);
/*!40000 ALTER TABLE `sys_org_app_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `org_id` int(11) NOT NULL,
  `code` varchar(4) NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `creater_id` int(11) NOT NULL,
  `createtime` datetime NOT NULL,
  `status` tinyint(4) NOT NULL,
  `type` varchar(45) DEFAULT NULL,
  `allow_apply_join` smallint(1) DEFAULT NULL,
  `head_id` int(11) DEFAULT NULL,
  `only_app_center` smallint(1) DEFAULT NULL,
  `disable_address_book` smallint(1) DEFAULT NULL,
  `disable_work_circle` smallint(1) DEFAULT NULL,
  `disable_app_center` smallint(6) DEFAULT NULL,
  `disable_taskmsg` smallint(6) DEFAULT NULL,
  `disk_limit` smallint(6) DEFAULT NULL,
  `disk_limit_unit` varchar(45) DEFAULT NULL,
  `file_size_limit` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'系统管理员',1,'1',NULL,1,'2015-03-10 16:41:49',0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'所有人',1,'9999',NULL,1,'2015-03-10 16:41:49',0,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_type`
--

DROP TABLE IF EXISTS `sys_role_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_type`
--

LOCK TABLES `sys_role_type` WRITE;
/*!40000 ALTER TABLE `sys_role_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_role_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_user`
--

DROP TABLE IF EXISTS `sys_role_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_user` (
  `org_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `is_admin` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`org_id`,`role_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_user`
--

LOCK TABLES `sys_role_user` WRITE;
/*!40000 ALTER TABLE `sys_role_user` DISABLE KEYS */;
INSERT INTO `sys_role_user` VALUES (1,1,1,1,'2015-12-21 16:09:26',1);
/*!40000 ALTER TABLE `sys_role_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_scheduled_task`
--

DROP TABLE IF EXISTS `sys_scheduled_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_scheduled_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `type` smallint(6) DEFAULT NULL,
  `exe_time` varchar(45) DEFAULT NULL,
  `period_type` varchar(45) DEFAULT NULL,
  `period_range` varchar(100) DEFAULT NULL,
  `service` varchar(200) DEFAULT NULL,
  `status` smallint(6) DEFAULT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `last_exe_time` datetime DEFAULT NULL,
  `next_exe_time` datetime DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `server_id` varchar(45) DEFAULT NULL,
  `tag` varchar(200) DEFAULT NULL,
  `sys_task` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_scheduled_task`
--

LOCK TABLES `sys_scheduled_task` WRITE;
/*!40000 ALTER TABLE `sys_scheduled_task` DISABLE KEYS */;
INSERT INTO `sys_scheduled_task` VALUES (1,1,'清理附件缓存',1,'00:10:00','day',NULL,'/sys/service/app/clearAttachCache',0,1,'2020-04-21 09:00:00',NULL,NULL,'2020-04-21 09:00:00',NULL,'TaskMsgServer',NULL,1);
/*!40000 ALTER TABLE `sys_scheduled_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_session`
--

DROP TABLE IF EXISTS `sys_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(45) DEFAULT NULL,
  `org_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  `last_address` varchar(45) DEFAULT NULL,
  `last_port` int(11) DEFAULT NULL,
  `server_type` varchar(25) DEFAULT NULL,
  `client_type` varchar(15) DEFAULT NULL,
  `client_version` varchar(10) DEFAULT NULL,
  `client_net_type` varchar(45) DEFAULT NULL,
  `client_os` varchar(45) DEFAULT NULL,
  `client_os_version` varchar(45) DEFAULT NULL,
  `device_manufactor` varchar(45) DEFAULT NULL,
  `device_model` varchar(45) DEFAULT NULL,
  `device_id` varchar(45) DEFAULT NULL,
  `device_token` varchar(200) DEFAULT NULL,
  `operator_name` varchar(45) DEFAULT NULL,
  `status` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2172 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_session`
--

LOCK TABLES `sys_session` WRITE;
/*!40000 ALTER TABLE `sys_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `code` varchar(16) NOT NULL COMMENT '代码',
  `name` varchar(20) NOT NULL COMMENT '姓名',
  `loginname` varchar(20) NOT NULL COMMENT '登录名',
  `password` varchar(50) NOT NULL COMMENT '密码',
  `org_id` int(11) NOT NULL COMMENT '组织编号',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `motto` varchar(100) DEFAULT NULL,
  `creater_id` int(11) NOT NULL,
  `createtime` datetime NOT NULL,
  `lastLoginTime` datetime DEFAULT NULL,
  `lastLoginIp` varchar(30) DEFAULT NULL,
  `sex` smallint(1) DEFAULT NULL,
  `post` varchar(50) DEFAULT NULL,
  `create_group` smallint(1) DEFAULT NULL,
  `look_all` smallint(1) DEFAULT NULL,
  `look_self_bureau` smallint(1) DEFAULT NULL,
  `look_self_dep` smallint(1) DEFAULT NULL,
  `look_leader` smallint(1) DEFAULT NULL,
  `look_under` smallint(1) DEFAULT NULL,
  `province` varchar(45) DEFAULT NULL,
  `city` varchar(45) DEFAULT NULL,
  `district` varchar(45) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `nickname` varchar(45) DEFAULT NULL,
  `tel_short` varchar(10) DEFAULT NULL,
  `tel_work` varchar(20) DEFAULT NULL,
  `tel_home` varchar(20) DEFAULT NULL,
  `tel_other` varchar(20) DEFAULT NULL,
  `only_app_center` smallint(1) DEFAULT NULL,
  `disable_address_book` smallint(1) DEFAULT NULL,
  `disable_work_circle` smallint(1) DEFAULT NULL,
  `device_manufactor` varchar(20) DEFAULT NULL,
  `device_model` varchar(50) DEFAULT NULL,
  `device_id` varchar(50) DEFAULT NULL,
  `not_bind_device` smallint(1) DEFAULT NULL,
  `client_type` varchar(20) DEFAULT NULL,
  `client_version` varchar(10) DEFAULT NULL,
  `client_os_version` varchar(10) DEFAULT NULL,
  `operator_name` varchar(10) DEFAULT NULL,
  `net_type` varchar(10) DEFAULT NULL,
  `head_id` int(11) DEFAULT NULL,
  `last_update_pwd` datetime DEFAULT NULL,
  `disable_app_center` smallint(6) DEFAULT NULL,
  `disable_taskmsg` smallint(6) DEFAULT NULL,
  `disable_chpwd` int(11) DEFAULT NULL,
  `disk_limit` int(11) DEFAULT NULL,
  `disk_limit_unit` varchar(2) DEFAULT NULL,
  `file_size_limit` int(11) DEFAULT NULL,
  `bind_ca` int(11) DEFAULT NULL,
  `bind_ca_id` varchar(45) DEFAULT NULL,
  `theme_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='用户信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'999999','管理员','admin','f9429ab0b5f04baf1e9dd1cef50cbd8f',1,0,'13504997777','123@sina.com','123',1,'2015-03-09 19:01:54','2017-04-22 14:09:24',NULL,0,NULL,1,1,1,1,1,1,NULL,NULL,NULL,NULL,'123123','2','3','4','5',NULL,NULL,NULL,NULL,NULL,NULL,0,'androidphone','0.2.018',NULL,NULL,'3g',27,'2020-06-27 12:03:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_post`
--

DROP TABLE IF EXISTS `sys_user_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `org_id` int(11) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `creater_id` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_post`
--

LOCK TABLES `sys_user_post` WRITE;
/*!40000 ALTER TABLE `sys_user_post` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_subdep`
--

DROP TABLE IF EXISTS `sys_user_subdep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_subdep` (
  `user_id` int(11) NOT NULL,
  `dep_id` int(11) NOT NULL,
  `org_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`dep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_subdep`
--

LOCK TABLES `sys_user_subdep` WRITE;
/*!40000 ALTER TABLE `sys_user_subdep` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_subdep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary view structure for view `vsys_app_auth`
--

DROP TABLE IF EXISTS `vsys_app_auth`;
/*!50001 DROP VIEW IF EXISTS `vsys_app_auth`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_app_auth` AS SELECT 
 1 AS `id`,
 1 AS `owner_type`,
 1 AS `owner_id`,
 1 AS `opration_id`,
 1 AS `opration_name`,
 1 AS `service_path`,
 1 AS `auth_terminal`,
 1 AS `owner_name`,
 1 AS `app_id`,
 1 AS `app_name`,
 1 AS `app_code`,
 1 AS `description`,
 1 AS `developer_id`,
 1 AS `developer_code`,
 1 AS `developer_name`,
 1 AS `version`,
 1 AS `deploy`,
 1 AS `terminal`,
 1 AS `url_phone`,
 1 AS `url_pad`,
 1 AS `url_pc`,
 1 AS `url_web`,
 1 AS `icon_path`,
 1 AS `icon_code`,
 1 AS `url_phone_detail`,
 1 AS `url_pad_detail`,
 1 AS `url_pc_detail`,
 1 AS `url_web_detail`,
 1 AS `titlebar_color`,
 1 AS `msg_group`,
 1 AS `createtime`,
 1 AS `lastupdate`,
 1 AS `org_id`,
 1 AS `status`,
 1 AS `category_id`,
 1 AS `installer_id`,
 1 AS `install_time`,
 1 AS `order_no`,
 1 AS `get_badge_service`,
 1 AS `pc_open_type`,
 1 AS `pc_show_on_sysbar`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_log_download`
--

DROP TABLE IF EXISTS `vsys_log_download`;
/*!50001 DROP VIEW IF EXISTS `vsys_log_download`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_log_download` AS SELECT 
 1 AS `id`,
 1 AS `file_id`,
 1 AS `file_code`,
 1 AS `file_name`,
 1 AS `file_size`,
 1 AS `file_path`,
 1 AS `app_code`,
 1 AS `app_data_id`,
 1 AS `thumbnail`,
 1 AS `session_id`,
 1 AS `req_time`,
 1 AS `req_ms`,
 1 AS `ip`,
 1 AS `res_time`,
 1 AS `res_ms`,
 1 AS `use_time`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_log_service`
--

DROP TABLE IF EXISTS `vsys_log_service`;
/*!50001 DROP VIEW IF EXISTS `vsys_log_service`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_log_service` AS SELECT 
 1 AS `id`,
 1 AS `session_id`,
 1 AS `path`,
 1 AS `req_data`,
 1 AS `res_data`,
 1 AS `res_code`,
 1 AS `err_msg`,
 1 AS `req_time`,
 1 AS `req_ms`,
 1 AS `ip`,
 1 AS `res_time`,
 1 AS `res_ms`,
 1 AS `use_time`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_log_static`
--

DROP TABLE IF EXISTS `vsys_log_static`;
/*!50001 DROP VIEW IF EXISTS `vsys_log_static`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_log_static` AS SELECT 
 1 AS `id`,
 1 AS `content_type`,
 1 AS `content_size`,
 1 AS `range_start`,
 1 AS `range_end`,
 1 AS `compress_type`,
 1 AS `last_modified`,
 1 AS `req_time`,
 1 AS `req_ms`,
 1 AS `ip`,
 1 AS `path`,
 1 AS `response_code`,
 1 AS `res_time`,
 1 AS `res_ms`,
 1 AS `use_time`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_log_upload`
--

DROP TABLE IF EXISTS `vsys_log_upload`;
/*!50001 DROP VIEW IF EXISTS `vsys_log_upload`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_log_upload` AS SELECT 
 1 AS `id`,
 1 AS `file_code`,
 1 AS `file_name`,
 1 AS `file_size`,
 1 AS `app_code`,
 1 AS `app_data_id`,
 1 AS `session_id`,
 1 AS `req_time`,
 1 AS `req_ms`,
 1 AS `ip`,
 1 AS `res_time`,
 1 AS `res_ms`,
 1 AS `use_time`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_org_app`
--

DROP TABLE IF EXISTS `vsys_org_app`;
/*!50001 DROP VIEW IF EXISTS `vsys_org_app`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_org_app` AS SELECT 
 1 AS `app_id`,
 1 AS `app_name`,
 1 AS `app_code`,
 1 AS `description`,
 1 AS `developer_id`,
 1 AS `developer_code`,
 1 AS `developer_name`,
 1 AS `version`,
 1 AS `deploy`,
 1 AS `terminal`,
 1 AS `url_phone`,
 1 AS `url_pad`,
 1 AS `url_pc`,
 1 AS `url_web`,
 1 AS `url_phone_detail`,
 1 AS `url_pad_detail`,
 1 AS `url_pc_detail`,
 1 AS `url_web_detail`,
 1 AS `icon_path`,
 1 AS `icon_code`,
 1 AS `titlebar_color`,
 1 AS `get_badge_service`,
 1 AS `msg_group`,
 1 AS `createtime`,
 1 AS `lastupdate`,
 1 AS `pc_open_type`,
 1 AS `pc_show_on_sysbar`,
 1 AS `org_id`,
 1 AS `status`,
 1 AS `category_id`,
 1 AS `installer_id`,
 1 AS `install_time`,
 1 AS `order_no`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_role_user`
--

DROP TABLE IF EXISTS `vsys_role_user`;
/*!50001 DROP VIEW IF EXISTS `vsys_role_user`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_role_user` AS SELECT 
 1 AS `org_id`,
 1 AS `role_id`,
 1 AS `user_id`,
 1 AS `creater_id`,
 1 AS `createtime`,
 1 AS `is_admin`,
 1 AS `role_name`,
 1 AS `user_name`,
 1 AS `user_code`,
 1 AS `user_sex`,
 1 AS `user_status`*/;
SET character_set_client = @saved_cs_client;

--
-- Temporary view structure for view `vsys_user`
--

DROP TABLE IF EXISTS `vsys_user`;
/*!50001 DROP VIEW IF EXISTS `vsys_user`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `vsys_user` AS SELECT 
 1 AS `id`,
 1 AS `code`,
 1 AS `name`,
 1 AS `loginname`,
 1 AS `password`,
 1 AS `org_id`,
 1 AS `status`,
 1 AS `mobile`,
 1 AS `email`,
 1 AS `motto`,
 1 AS `creater_id`,
 1 AS `createtime`,
 1 AS `lastLoginTime`,
 1 AS `lastLoginIp`,
 1 AS `sex`,
 1 AS `post`,
 1 AS `create_group`,
 1 AS `look_all`,
 1 AS `look_self_bureau`,
 1 AS `look_self_dep`,
 1 AS `look_leader`,
 1 AS `look_under`,
 1 AS `province`,
 1 AS `city`,
 1 AS `district`,
 1 AS `address`,
 1 AS `nickname`,
 1 AS `tel_short`,
 1 AS `tel_work`,
 1 AS `tel_home`,
 1 AS `tel_other`,
 1 AS `only_app_center`,
 1 AS `disable_address_book`,
 1 AS `disable_work_circle`,
 1 AS `device_id`,
 1 AS `not_bind_device`,
 1 AS `head_id`,
 1 AS `disable_taskmsg`,
 1 AS `disable_app_center`,
 1 AS `client_version`,
 1 AS `disable_chpwd`,
 1 AS `disk_limit`,
 1 AS `disk_limit_unit`,
 1 AS `file_size_limit`,
 1 AS `bind_ca`,
 1 AS `bind_ca_id`,
 1 AS `theme_id`,
 1 AS `dep_id`,
 1 AS `dep_name`*/;
SET character_set_client = @saved_cs_client;

--
-- Final view structure for view `vsys_app_auth`
--

/*!50001 DROP VIEW IF EXISTS `vsys_app_auth`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_app_auth` AS select `a`.`id` AS `id`,`a`.`owner_type` AS `owner_type`,`a`.`owner_id` AS `owner_id`,`a`.`opration_id` AS `opration_id`,`c`.`name` AS `opration_name`,`c`.`service_path` AS `service_path`,(case when isnull(`a`.`opration_id`) then `a`.`terminal` else `c`.`terminal` end) AS `auth_terminal`,(case `a`.`owner_type` when 'role' then (select `sys_role`.`name` from `sys_role` where ((`sys_role`.`id` = `a`.`owner_id`) and (`sys_role`.`org_id` = `a`.`org_id`))) when 'dep' then (select `sys_dep`.`name` from `sys_dep` where ((`sys_dep`.`id` = `a`.`owner_id`) and (`sys_dep`.`org_id` = `a`.`org_id`))) else (select `sys_user`.`name` from `sys_user` where ((`sys_user`.`id` = `a`.`owner_id`) and (`sys_user`.`org_id` = `a`.`org_id`))) end) AS `owner_name`,`b`.`app_id` AS `app_id`,`b`.`app_name` AS `app_name`,`b`.`app_code` AS `app_code`,`b`.`description` AS `description`,`b`.`developer_id` AS `developer_id`,`b`.`developer_code` AS `developer_code`,`b`.`developer_name` AS `developer_name`,`b`.`version` AS `version`,`b`.`deploy` AS `deploy`,`b`.`terminal` AS `terminal`,`b`.`url_phone` AS `url_phone`,`b`.`url_pad` AS `url_pad`,`b`.`url_pc` AS `url_pc`,`b`.`url_web` AS `url_web`,`b`.`icon_path` AS `icon_path`,`b`.`icon_code` AS `icon_code`,`b`.`url_phone_detail` AS `url_phone_detail`,`b`.`url_pad_detail` AS `url_pad_detail`,`b`.`url_pc_detail` AS `url_pc_detail`,`b`.`url_web_detail` AS `url_web_detail`,`b`.`titlebar_color` AS `titlebar_color`,`b`.`msg_group` AS `msg_group`,`b`.`createtime` AS `createtime`,`b`.`lastupdate` AS `lastupdate`,`b`.`org_id` AS `org_id`,`b`.`status` AS `status`,`b`.`category_id` AS `category_id`,`b`.`installer_id` AS `installer_id`,`b`.`install_time` AS `install_time`,`b`.`order_no` AS `order_no`,`b`.`get_badge_service` AS `get_badge_service`,`b`.`pc_open_type` AS `pc_open_type`,`b`.`pc_show_on_sysbar` AS `pc_show_on_sysbar` from ((`sys_app_auth` `a` join `vsys_org_app` `b`) left join `sys_app_opration` `c` on((`c`.`id` = `a`.`opration_id`))) where ((`a`.`app_id` = `b`.`app_id`) and (`a`.`org_id` = `b`.`org_id`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_log_download`
--

/*!50001 DROP VIEW IF EXISTS `vsys_log_download`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_log_download` AS select `a`.`id` AS `id`,`a`.`file_id` AS `file_id`,`a`.`file_code` AS `file_code`,`a`.`file_name` AS `file_name`,`a`.`file_size` AS `file_size`,`a`.`file_path` AS `file_path`,`a`.`app_code` AS `app_code`,`a`.`app_data_id` AS `app_data_id`,`a`.`thumbnail` AS `thumbnail`,`a`.`session_id` AS `session_id`,`b`.`req_time` AS `req_time`,`b`.`req_ms` AS `req_ms`,`b`.`ip` AS `ip`,`b`.`res_time` AS `res_time`,`b`.`res_ms` AS `res_ms`,`b`.`use_time` AS `use_time` from (`sys_log_download` `a` join `sys_log_request` `b`) where (`a`.`id` = `b`.`id`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_log_service`
--

/*!50001 DROP VIEW IF EXISTS `vsys_log_service`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_log_service` AS select `a`.`id` AS `id`,`a`.`session_id` AS `session_id`,`a`.`path` AS `path`,`a`.`req_data` AS `req_data`,`a`.`res_data` AS `res_data`,`a`.`res_code` AS `res_code`,`a`.`err_msg` AS `err_msg`,`b`.`req_time` AS `req_time`,`b`.`req_ms` AS `req_ms`,`b`.`ip` AS `ip`,`b`.`res_time` AS `res_time`,`b`.`res_ms` AS `res_ms`,`b`.`use_time` AS `use_time` from (`sys_log_service` `a` join `sys_log_request` `b`) where (`a`.`id` = `b`.`id`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_log_static`
--

/*!50001 DROP VIEW IF EXISTS `vsys_log_static`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_log_static` AS select `a`.`id` AS `id`,`a`.`content_type` AS `content_type`,`a`.`content_size` AS `content_size`,`a`.`range_start` AS `range_start`,`a`.`range_end` AS `range_end`,`a`.`compress_type` AS `compress_type`,`a`.`last_modified` AS `last_modified`,`b`.`req_time` AS `req_time`,`b`.`req_ms` AS `req_ms`,`b`.`ip` AS `ip`,`b`.`path` AS `path`,`b`.`response_code` AS `response_code`,`b`.`res_time` AS `res_time`,`b`.`res_ms` AS `res_ms`,`b`.`use_time` AS `use_time` from (`sys_log_static` `a` join `sys_log_request` `b`) where (`a`.`id` = `b`.`id`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_log_upload`
--

/*!50001 DROP VIEW IF EXISTS `vsys_log_upload`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_log_upload` AS select `a`.`id` AS `id`,`a`.`file_code` AS `file_code`,`a`.`file_name` AS `file_name`,`a`.`file_size` AS `file_size`,`a`.`app_code` AS `app_code`,`a`.`app_data_id` AS `app_data_id`,`a`.`session_id` AS `session_id`,`b`.`req_time` AS `req_time`,`b`.`req_ms` AS `req_ms`,`b`.`ip` AS `ip`,`b`.`res_time` AS `res_time`,`b`.`res_ms` AS `res_ms`,`b`.`use_time` AS `use_time` from (`sys_log_upload` `a` join `sys_log_request` `b`) where (`a`.`id` = `b`.`id`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_org_app`
--

/*!50001 DROP VIEW IF EXISTS `vsys_org_app`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_org_app` AS select `a`.`id` AS `app_id`,`a`.`name` AS `app_name`,`a`.`code` AS `app_code`,`a`.`description` AS `description`,`a`.`developer_id` AS `developer_id`,`c`.`code` AS `developer_code`,`c`.`name` AS `developer_name`,`a`.`version` AS `version`,`a`.`deploy` AS `deploy`,`a`.`terminal` AS `terminal`,`a`.`url_phone` AS `url_phone`,`a`.`url_pad` AS `url_pad`,`a`.`url_pc` AS `url_pc`,`a`.`url_web` AS `url_web`,`a`.`url_phone_detail` AS `url_phone_detail`,`a`.`url_pad_detail` AS `url_pad_detail`,`a`.`url_pc_detail` AS `url_pc_detail`,`a`.`url_web_detail` AS `url_web_detail`,`a`.`icon_path` AS `icon_path`,`a`.`icon_code` AS `icon_code`,`a`.`titlebar_color` AS `titlebar_color`,`a`.`get_badge_service` AS `get_badge_service`,`a`.`msg_group` AS `msg_group`,`a`.`createtime` AS `createtime`,`a`.`lastupdate` AS `lastupdate`,`a`.`pc_open_type` AS `pc_open_type`,`a`.`pc_show_on_sysbar` AS `pc_show_on_sysbar`,`b`.`org_id` AS `org_id`,`b`.`status` AS `status`,`b`.`category_id` AS `category_id`,`b`.`installer_id` AS `installer_id`,`b`.`install_time` AS `install_time`,`b`.`order_no` AS `order_no` from ((`sys_app` `a` join `sys_org_app` `b`) join `sys_org` `c`) where ((`a`.`id` = `b`.`app_id`) and (`a`.`developer_id` = `c`.`id`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_role_user`
--

/*!50001 DROP VIEW IF EXISTS `vsys_role_user`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_role_user` AS select `a`.`org_id` AS `org_id`,`a`.`role_id` AS `role_id`,`a`.`user_id` AS `user_id`,`a`.`creater_id` AS `creater_id`,`a`.`createtime` AS `createtime`,`a`.`is_admin` AS `is_admin`,`b`.`name` AS `role_name`,`c`.`name` AS `user_name`,`c`.`code` AS `user_code`,`c`.`sex` AS `user_sex`,`c`.`status` AS `user_status` from ((`sys_role_user` `a` join `sys_role` `b`) join `sys_user` `c`) where ((`a`.`org_id` = `b`.`org_id`) and (`a`.`role_id` = `b`.`id`) and (`a`.`org_id` = `c`.`org_id`) and (`a`.`user_id` = `c`.`id`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `vsys_user`
--

/*!50001 DROP VIEW IF EXISTS `vsys_user`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vsys_user` AS select `a`.`id` AS `id`,`a`.`code` AS `code`,`a`.`name` AS `name`,`a`.`loginname` AS `loginname`,`a`.`password` AS `password`,`a`.`org_id` AS `org_id`,`a`.`status` AS `status`,`a`.`mobile` AS `mobile`,`a`.`email` AS `email`,`a`.`motto` AS `motto`,`a`.`creater_id` AS `creater_id`,`a`.`createtime` AS `createtime`,`a`.`lastLoginTime` AS `lastLoginTime`,`a`.`lastLoginIp` AS `lastLoginIp`,`a`.`sex` AS `sex`,`a`.`post` AS `post`,`a`.`create_group` AS `create_group`,`a`.`look_all` AS `look_all`,`a`.`look_self_bureau` AS `look_self_bureau`,`a`.`look_self_dep` AS `look_self_dep`,`a`.`look_leader` AS `look_leader`,`a`.`look_under` AS `look_under`,`a`.`province` AS `province`,`a`.`city` AS `city`,`a`.`district` AS `district`,`a`.`address` AS `address`,`a`.`nickname` AS `nickname`,`a`.`tel_short` AS `tel_short`,`a`.`tel_work` AS `tel_work`,`a`.`tel_home` AS `tel_home`,`a`.`tel_other` AS `tel_other`,`a`.`only_app_center` AS `only_app_center`,`a`.`disable_address_book` AS `disable_address_book`,`a`.`disable_work_circle` AS `disable_work_circle`,`a`.`device_id` AS `device_id`,`a`.`not_bind_device` AS `not_bind_device`,`a`.`head_id` AS `head_id`,`a`.`disable_taskmsg` AS `disable_taskmsg`,`a`.`disable_app_center` AS `disable_app_center`,`a`.`client_version` AS `client_version`,`a`.`disable_chpwd` AS `disable_chpwd`,`a`.`disk_limit` AS `disk_limit`,`a`.`disk_limit_unit` AS `disk_limit_unit`,`a`.`file_size_limit` AS `file_size_limit`,`a`.`bind_ca` AS `bind_ca`,`a`.`bind_ca_id` AS `bind_ca_id`,`a`.`theme_id` AS `theme_id`,(select `c`.`dep_id` from `sys_dep_user` `c` where ((`a`.`org_id` = `c`.`org_id`) and (`c`.`user_id` = `a`.`id`)) limit 1) AS `dep_id`,(select `e`.`name` from (`sys_dep_user` `d` join `sys_dep` `e`) where ((`d`.`org_id` = `e`.`org_id`) and (`d`.`org_id` = `a`.`org_id`) and (`d`.`dep_id` = `e`.`id`) and (`d`.`user_id` = `a`.`id`)) limit 1) AS `dep_name` from `sys_user` `a` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!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 */;

-- Dump completed on 2020-12-02 11:05:35
