text: /*
  SQLyog Ultimate v12.09 (64 bit)
  MySQL - 5.7.26-log : Database - wind
  *********************************************************************
  */
  
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!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 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`wind` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  
  USE `wind`;
  
  /*Table structure for table `email_send_log` */
  
  DROP TABLE IF EXISTS `email_send_log`;
  
  CREATE TABLE `email_send_log` (
    `id` varchar(32) NOT NULL,
    `email` longtext NOT NULL COMMENT '联系电话',
    `subject` varchar(255) DEFAULT NULL COMMENT '主题',
    `content` text COMMENT '模板类型',
    `send_data` varchar(255) DEFAULT NULL,
    `send_code` varchar(255) NOT NULL COMMENT '发送编码',
    `response_date` datetime DEFAULT NULL COMMENT '响应时间',
    `try_num` int(2) DEFAULT NULL COMMENT '重发次数',
    `msg` varchar(250) DEFAULT NULL COMMENT '返回消息',
    `status` varchar(4) DEFAULT NULL COMMENT '发送状态',
    `del_flag` varchar(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0：正常；1：删除）',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `tenant_id` varchar(64) DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  
  /*Data for the table `email_send_log` */
  
  insert  into `email_send_log`(`id`,`email`,`subject`,`content`,`send_data`,`send_code`,`response_date`,`try_num`,`msg`,`status`,`del_flag`,`remarks`,`tenant_id`) values ('05df11ef6fd8467d865d8bc350ca0967','502079461@qq.com','测试模板','<p>测试模板123456</p>','{\"code\":\"123456\"}','2p6dl894ur','2018-11-09 11:44:00',3,'发送失败','-1','0',NULL,'00000000'),('1bd18fc2fb4309841e230c0a99bbda8c','dothegod@gmail.com','测试模板','<p>测试模板1111111</p>','{\"code\":\"1111111\"}','2p6dl894ur','2020-02-05 02:13:34',0,'发送失败','-1','0',NULL,'00000000'),('4287a548d8d988957c03f9ede01c7651','dothegod@163.com','测试模板','<p>测试模板123,123,123</p>','{\"code\":123123123}','2p6dl894ur','2020-02-05 02:31:12',0,'发送成功','1','0',NULL,'00000000'),('ae75ade7429e80edddcb46ba1d9e330f','dothegod@163.com','测试模板','<p>测试模板1111111</p>','{\"code\":\"1111111\"}','2p6dl894ur','2020-02-05 02:18:15',0,'发送成功','1','0',NULL,'00000000');
  
  /*Table structure for table `email_template` */
  
  DROP TABLE IF EXISTS `email_template`;
  
  CREATE TABLE `email_template` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `name` varchar(255) NOT NULL COMMENT '模版名称',
    `code` varchar(255) NOT NULL COMMENT '模版编码',
    `template_subject` varchar(20) NOT NULL COMMENT '模版主题',
    `template_content` text NOT NULL COMMENT '模版内容',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `update_by` varchar(32) DEFAULT NULL COMMENT '更新者',
    `create_date` varchar(19) DEFAULT NULL COMMENT '创建时间',
    `del_flag` varchar(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0：正常；1：删除）',
    `create_by` varchar(32) DEFAULT NULL COMMENT '创建者',
    `update_date` varchar(19) DEFAULT NULL COMMENT '更新时间',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件发送模板';
  
  /*Data for the table `email_template` */
  
  insert  into `email_template`(`id`,`name`,`code`,`template_subject`,`template_content`,`remarks`,`update_by`,`create_date`,`del_flag`,`create_by`,`update_date`,`tenant_id`) values ('4c7bc6a0b20c41a6be9a6495f65b10f3','JeeWeb社区找回密码','7e6cww7l5t','JeeWeb社区找回密码','&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px; border: 1px solid #ddd; border-radius: 3px; color: #555; font-family: \'Helvetica Neue Regular\',Helvetica,Arial,Tahoma,\'Microsoft YaHei\',\'San Francisco\',\'微软雅黑\',\'Hiragino Sans GB\',STHeitiSC-Light; font-size: 12px; height: auto; margin: auto; overflow: hidden; text-align: left; word-break: break-all; word-wrap: break-word;&quot;&gt; \r\n    &lt;tbody style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n     &lt;tr style=&quot;background-color: #393D49; height: 60px; margin: 0; padding: 0;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n       &lt;div style=&quot;color: #5EB576; margin: 0; margin-left: 30px; padding: 0;&quot;&gt;\r\n&lt;a style=&quot;font-size: 14px; margin: 0; padding: 0; color: #5EB576; text-decoration: none;&quot; href=&quot;http://www.jeeweb.cn/&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot;&gt;JeeWeb社区 - JeeWeb快速开发平台框架官方社区&lt;/a&gt;&lt;br&gt;&lt;/div&gt; &lt;/td&gt; \r\n     &lt;/tr&gt; \r\n     &lt;tr style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 30px;&quot;&gt; &lt;p style=&quot;line-height: 20px; margin: 0; margin-bottom: 10px; padding: 0;&quot;&gt; Hi，&lt;em style=&quot;font-weight: 700;&quot;&gt;${realname}&lt;/em&gt;，童鞋，请在30分钟内重置您的密码： &lt;/p&gt; \r\n       &lt;div style=&quot;&quot;&gt; \r\n        &lt;a href=&quot;http://192.168.10.56:8080/user/reset?token=${token}&amp;amp;key=email&amp;amp;value=${email}&quot; style=&quot;background-color: #009E94; color: #fff; display: inline-block; height: 32px; line-height: 32px; margin: 0 15px 0 0; padding: 0 15px; text-decoration: none;&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot;&gt;立即重置密码&lt;/a&gt; \r\n       &lt;/div&gt; &lt;p style=&quot;line-height: 20px; margin-top: 20px; padding: 10px; background-color: #f2f2f2; font-size: 12px;&quot;&gt; 如果该邮件不是由你本人操作，请勿进行激活！否则你的邮箱将会被他人绑定。 &lt;/p&gt; &lt;/td&gt; \r\n     &lt;/tr&gt; \r\n     &lt;tr style=&quot;background-color: #fafafa; color: #999; height: 35px; margin: 0; padding: 0; text-align: center;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 0;&quot;&gt;系统邮件，请勿直接回复。&lt;/td&gt; \r\n     &lt;/tr&gt; \r\n    &lt;/tbody&gt; \r\n   &lt;/table&gt; \r\n   &lt;style type=&quot;text/css&quot;&gt;\r\n      .qmbox style, .qmbox script, .qmbox head, .qmbox link, .qmbox meta {display: none !important;}\r\n   &lt;/style&gt;',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-12 11:44:12','0','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-12 14:46:35','00000000'),('e67c81395da3448782da1771f37ab840','测试模板','2p6dl894ur','测试模板','&lt;p&gt;测试模板${code}&lt;/p&gt;',NULL,NULL,'2018-11-09 11:39:07','0','4028ea815a3d2a8c015a3d2f8d2a0002',NULL,'00000000'),('fc38a13d91c0408ebc3ff4710ddffb20','JeeWeb社区激活邮件','l2g4ywbs0l','JeeWeb社区激活邮件','&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px; border: 1px solid #ddd; border-radius: 3px; color: #555; font-family: \'Helvetica Neue Regular\',Helvetica,Arial,Tahoma,\'Microsoft YaHei\',\'San Francisco\',\'微软雅黑\',\'Hiragino Sans GB\',STHeitiSC-Light; font-size: 12px; height: auto; margin: auto; overflow: hidden; text-align: left; word-break: break-all; word-wrap: break-word;&quot;&gt; \r\n    &lt;tbody style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n     &lt;tr style=&quot;background-color: #393D49; height: 60px; margin: 0; padding: 0;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n       &lt;div style=&quot;color: #5EB576; margin: 0; margin-left: 30px; padding: 0;&quot;&gt;\r\n&lt;a style=&quot;font-size: 14px; margin: 0; padding: 0; color: #5EB576; text-decoration: none;&quot; href=&quot;http://www.jeeweb.cn/&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot;&gt;JeeWeb社区 - JeeWeb快速开发平台框架官方社区&lt;/a&gt;\r\n&lt;br&gt;&lt;/div&gt; &lt;/td&gt; \r\n     &lt;/tr&gt; \r\n     &lt;tr style=&quot;margin: 0; padding: 0;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 30px;&quot;&gt; &lt;p style=&quot;line-height: 20px; margin: 0; margin-bottom: 10px; padding: 0;&quot;&gt; Hi，&lt;em style=&quot;font-weight: 700;&quot;&gt;${realname}&lt;/em&gt;，请完成以下操作： &lt;/p&gt; \r\n       &lt;div style=&quot;&quot;&gt; \r\n        &lt;a href=&quot;http://192.168.10.56:8080/user/activate?token=${token}&quot; style=&quot;background-color: #009E94; color: #fff; display: inline-block; height: 32px; line-height: 32px; margin: 0 15px 0 0; padding: 0 15px; text-decoration: none;&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot;&gt;立即激活邮箱&lt;/a&gt; \r\n       &lt;/div&gt; &lt;p style=&quot;line-height: 20px; margin-top: 20px; padding: 10px; background-color: #f2f2f2; font-size: 12px;&quot;&gt; 如果该邮件不是由你本人操作，请勿进行激活！否则你的邮箱将会被他人绑定。 &lt;/p&gt; &lt;/td&gt; \r\n     &lt;/tr&gt; \r\n     &lt;tr style=&quot;background-color: #fafafa; color: #999; height: 35px; margin: 0; padding: 0; text-align: center;&quot;&gt; \r\n      &lt;td style=&quot;margin: 0; padding: 0;&quot;&gt;系统邮件，请勿直接回复。&lt;/td&gt; \r\n     &lt;/tr&gt; \r\n    &lt;/tbody&gt; \r\n   &lt;/table&gt; \r\n   &lt;style type=&quot;text/css&quot;&gt;\r\n      .qmbox style, .qmbox script, .qmbox head, .qmbox link, .qmbox meta {display: none !important;}\r\n   &lt;/style&gt;',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-12 11:41:05','0','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-14 17:16:06','00000000');
  
  /*Table structure for table `oa_notification` */
  
  DROP TABLE IF EXISTS `oa_notification`;
  
  CREATE TABLE `oa_notification` (
    `id` varchar(32) NOT NULL,
    `title` varchar(255) NOT NULL COMMENT '标题',
    `content` longtext NOT NULL COMMENT '内容',
    `status` varchar(4) NOT NULL COMMENT '发布状态',
    `create_by` varchar(32) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` varchar(32) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `del_flag` varchar(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0：正常；1：删除）',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `oa_notification` */
  
  insert  into `oa_notification`(`id`,`title`,`content`,`status`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`remarks`,`tenant_id`) values ('40281e815c912406015c914e3e27006b','测试通知1','测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知测试通知','1','4028ea815a3d2a8c015a3d2f8d2a0002','2017-06-10 17:20:43','4028ea815a3d2a8c015a3d2f8d2a0002','2017-07-22 23:27:22','0',NULL,'00000000'),('40281e815c914f07015c91548e690000','测试通知2','测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2测试通知2','1','4028ea815a3d2a8c015a3d2f8d2a0002','2017-06-10 17:27:36','4028ea815a3d2a8c015a3d2f8d2a0002','2017-07-22 23:27:25','0',NULL,'00000000'),('40281e815c914f07015c9154aa010001','测试通知3','测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3测试通知3','1','4028ea815a3d2a8c015a3d2f8d2a0002','2017-06-10 17:27:43','4028ea815a3d2a8c015a3d2f8d2a0002','2017-07-22 23:27:28','0',NULL,'00000000'),('40281e815c914f07015c9154c1b30002','测试通知4','测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4测试通知4','1','4028ea815a3d2a8c015a3d2f8d2a0002','2017-06-10 17:27:49','4028ea815a3d2a8c015a3d2f8d2a0002','2018-03-06 10:29:46','0',NULL,'00000000'),('40288ab85cf356ef015cf35c67ae0004','1111','11111','1','4028ea815a3d2a8c015a3d2f8d2a0002','2017-06-29 18:18:58','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-24 14:20:16','0',NULL,'00000000');
  
  /*Table structure for table `oss_attachment` */
  
  DROP TABLE IF EXISTS `oss_attachment`;
  
  CREATE TABLE `oss_attachment` (
    `id` varchar(32) NOT NULL,
    `file_name` varchar(50) NOT NULL COMMENT '文件名称',
    `user_id` varchar(32) DEFAULT NULL COMMENT '用户ID',
    `upload_time` datetime NOT NULL COMMENT '上传时间',
    `upload_ip` varchar(30) NOT NULL COMMENT '上传的ID',
    `file_extension` varchar(10) NOT NULL COMMENT '文件扩展名',
    `file_path` varchar(200) NOT NULL COMMENT '文件路径',
    `file_size` int(10) NOT NULL DEFAULT '0' COMMENT '文件大小',
    `content_type` varchar(100) DEFAULT NULL,
    `status` varchar(1) NOT NULL DEFAULT '0' COMMENT '状态',
    `base_path` varchar(250) DEFAULT NULL COMMENT 'oss的根路径',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  
  /*Data for the table `oss_attachment` */
  
  insert  into `oss_attachment`(`id`,`file_name`,`user_id`,`upload_time`,`upload_ip`,`file_extension`,`file_path`,`file_size`,`content_type`,`status`,`base_path`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`tenant_id`) values ('048ae89ba6e0cda8eb7b294b4839e040','logo1',NULL,'2020-02-04 08:38:25','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/20200204223824716.png',42300,'image/png','1',NULL,NULL,'2020-02-04 08:38:26',NULL,NULL,NULL,'0','00000000'),('08a541990c550031a4b5c84bc19b0a05','疫情公告',NULL,'2020-02-04 19:47:30','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/20200205094729693.png',11098,'image/png','1',NULL,NULL,'2020-02-04 19:47:30',NULL,NULL,NULL,'0','00000000'),('0ae88bc610694384aecc425b1346be52','未标题-14',NULL,'2019-05-18 16:26:20','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558167979749.png',4250,'image/png','1','',NULL,'2019-05-18 16:26:20',NULL,NULL,NULL,'0','00000000'),('0ff8a4024cac56ef84eb5e941284f4fd','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 12:48:22','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213124822050.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 12:48:22',NULL,NULL,NULL,'0','00000000'),('1df5dbc8778c6cbec167ad8cc8aa3e0e','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 12:47:33','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213124733035.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 12:47:33',NULL,NULL,NULL,'0','00000000'),('2a6a09ecc28043dd837c03ff1e3a2cd7','未命名',NULL,'2019-05-18 16:13:21','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558167200777.png',10591,'image/png','1','',NULL,'2019-05-18 16:13:21',NULL,NULL,NULL,'0','00000000'),('34ab97088bd472f9e97f9bb4214eb11c','476eabb4bd4d01bb45492e9a11b10bc',NULL,'2020-12-13 13:31:23','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213133123112.jpg',122757,'image/jpeg','1','',NULL,'2020-12-13 13:31:23',NULL,NULL,NULL,'0','00000000'),('38bd759e0cfd40400503044028577916','一键报警',NULL,'2020-02-04 19:56:58','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/test/20200205095657434.png',10385,'image/png','1','test',NULL,'2020-02-04 19:56:59',NULL,NULL,NULL,'0','00000000'),('3912df91c0c52a272616f5525d65d845','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:27:34','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213132734196.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:27:34',NULL,NULL,NULL,'0','00000000'),('3a04882c8bf1452a9a880d5b3f3d32e9','未标题-14',NULL,'2019-05-18 16:28:22','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558168101498.png',4250,'image/png','1','',NULL,'2019-05-18 16:28:22',NULL,NULL,NULL,'0','00000000'),('45853f6cff714e17bd3742f8baf9097a','未标题-14',NULL,'2019-05-18 16:34:10','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558168448251.png',4250,'image/png','1','',NULL,'2019-05-18 16:34:10',NULL,NULL,NULL,'0','00000000'),('4db0cc6087099c8f9db113ee713ab203','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:35:06','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213133506250.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:35:06',NULL,NULL,NULL,'0','00000000'),('4df750134102368340d550a322f4cc66','本地疫情',NULL,'2020-02-04 07:30:55','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/2020/02/04/1580822952887.png',18351,'image/png','1',NULL,NULL,'2020-02-04 07:30:55',NULL,NULL,NULL,'0','00000000'),('4eb63491f4bd6111ebbdd7b812006880','防护指南',NULL,'2020-02-04 09:02:23','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/20200204230222687.png',13621,'image/png','1',NULL,NULL,'2020-02-04 09:02:23',NULL,NULL,NULL,'0','00000000'),('50a3c0af3f97425094be83dce6239f0d','屏幕截图(1)',NULL,'2018-11-06 15:50:18','127.0.0.1','png','jeewebbbs.oss-cn-beijing.aliyuncs.com/user/portrait/2018/11/06/1541490618213.png',270806,'image/png','1','/user/portrait',NULL,'2018-11-06 15:50:18',NULL,NULL,NULL,'0','00000000'),('5f533ee06cc30510d40d384b09b4426f','疑似上报',NULL,'2020-02-04 19:53:26','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/20200205095325043.png',10349,'image/png','1','',NULL,'2020-02-04 19:53:27',NULL,NULL,NULL,'0','00000000'),('68216b84c0a2405d829dd046ba7bd267','屏幕截图(1)',NULL,'2018-11-06 15:57:09','127.0.0.1','png','http://jeewebbbs.oss-cn-beijing.aliyuncs.com/user/portrait/2018/11/06/1541491028415.png',270806,'image/png','1','/user/portrait',NULL,'2018-11-06 15:57:09',NULL,NULL,NULL,'0','00000000'),('6901f6a94805484a9117edd98e8ece89','未标题-14',NULL,'2019-05-18 16:36:29','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558168588826.png',4250,'image/png','1','',NULL,'2019-05-18 16:36:29',NULL,NULL,NULL,'0','00000000'),('69d6ff3f22055bffb43630d05c972595','疫情公告',NULL,'2020-02-04 07:27:47','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/2020/02/04/1580822866443.png',11098,'image/png','1',NULL,NULL,'2020-02-04 07:27:47',NULL,NULL,NULL,'0','00000000'),('6d235457c508116443ce979b573ad6b4','logo1',NULL,'2020-02-04 07:57:44','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/20200204215743819.png',42300,'image/png','1',NULL,NULL,'2020-02-04 07:57:44',NULL,NULL,NULL,'0','00000000'),('6f920a55ff094d37895e71d6a5f8a0e3','未标题-14',NULL,'2019-05-18 16:38:10','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558168689991.png',4250,'image/png','1','',NULL,'2019-05-18 16:38:10',NULL,NULL,NULL,'0','00000000'),('766d4b75bb1ed6dc25646404c0aac0bf','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:02:39','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213130239397.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:02:39',NULL,NULL,NULL,'0','00000000'),('7762bdbd3c7ac5d1e166c0604d206c51','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 12:57:43','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213125742700.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 12:57:43',NULL,NULL,NULL,'0','00000000'),('8bcf1ec98ee624786ee6ab437f62c6dc','防护指南',NULL,'2020-02-04 09:22:42','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/gangwanvuetest/2020/02/04/20200204232242045.png',13621,'image/png','1',NULL,NULL,'2020-02-04 09:22:42',NULL,NULL,NULL,'0','00000000'),('956cddd3e661c0bbadba0f4ae3582b81','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:26:10','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213132609680.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:26:10',NULL,NULL,NULL,'0','00000000'),('98894c610025ef853d01934e56cdf012','c18ff76bb1aa806457df97510664173',NULL,'2020-12-13 13:14:16','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213131416033.jpg',110689,'image/jpeg','1','',NULL,'2020-12-13 13:14:16',NULL,NULL,NULL,'0','00000000'),('a0d067faba256b3cb910314a3654da12','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 12:43:22','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213124322352.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 12:43:24',NULL,NULL,NULL,'0','00000000'),('b3e53ff491c5b378e7a7659f5860054a','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:34:51','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213133451339.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:34:51',NULL,NULL,NULL,'0','00000000'),('bc0efa88543c45c0b62f460f32539dee','未标题-14',NULL,'2019-05-18 16:37:22','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558168642074.png',4250,'image/png','1','',NULL,'2019-05-18 16:37:22',NULL,NULL,NULL,'0','00000000'),('bfc31c1c0ba835d56c2126790fb00f1f','本地疫情',NULL,'2020-02-04 07:32:37','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/2020/02/04/1580823156746.png',18351,'image/png','1',NULL,NULL,'2020-02-04 07:32:37',NULL,NULL,NULL,'0','00000000'),('c5e4697deb134072aafb032c5941870d','未标题-14',NULL,'2019-05-18 16:25:47','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558167947101.png',4250,'image/png','1','',NULL,'2019-05-18 16:25:47',NULL,NULL,NULL,'0','00000000'),('cbae2f4be5b0adbc23d9c6d3d01f4ef0','疫情公告',NULL,'2020-02-04 07:23:07','127.0.0.1','png','http://gangwantest.oss-cn-beijing.aliyuncs.com/2020/02/04/1580822586600.png',11098,'image/png','1',NULL,NULL,'2020-02-04 07:23:09',NULL,NULL,NULL,'0','00000000'),('cc63573fc5d5352cb1be380cb18ac443','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:18:36','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213131835965.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:18:36',NULL,NULL,NULL,'0','00000000'),('ddb2ce3e868f6411cc768bf9019f4c39','c18ff76bb1aa806457df97510664173',NULL,'2020-12-13 12:58:52','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213125851839.jpg',110689,'image/jpeg','1','',NULL,'2020-12-13 12:58:52',NULL,NULL,NULL,'0','00000000'),('e12a8276bda455035f51ab12d48ccb35','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:12:56','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213131255999.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:12:56',NULL,NULL,NULL,'0','00000000'),('e4856caeab7ba763fb6458ae6532e44a','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:29:46','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213132945719.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:29:46',NULL,NULL,NULL,'0','00000000'),('e7246b97aed0d6fc0662057b1b9f4c36','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:20:05','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213132004904.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:20:05',NULL,NULL,NULL,'0','00000000'),('e83293ae595b381bf80d5b165a9e0026','0d493dcc2ac0e51f13ac5e99949e3d5',NULL,'2020-12-13 13:30:57','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213133057039.jpg',129448,'image/jpeg','1','',NULL,'2020-12-13 13:30:57',NULL,NULL,NULL,'0','00000000'),('e8e6985e798f4c6a9997a1e948d24264','未标题-14',NULL,'2019-05-18 16:11:52','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558167111350.png',4250,'image/png','1','',NULL,'2019-05-18 16:11:52',NULL,NULL,NULL,'0','00000000'),('f08d0e702c5daf8c71b0bd8f1d744869','dc391d223f6abc1048236f3cbd43b51',NULL,'2020-12-13 13:19:31','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213131930639.jpg',121975,'image/jpeg','1','',NULL,'2020-12-13 13:19:31',NULL,NULL,NULL,'0','00000000'),('f1bc7c24343dba8ca569501319b7200b','0d493dcc2ac0e51f13ac5e99949e3d5',NULL,'2020-12-13 13:31:20','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213133120198.jpg',129448,'image/jpeg','1','',NULL,'2020-12-13 13:31:20',NULL,NULL,NULL,'0','00000000'),('f2119774227c41b3be8d3ac8a99e898e','未标题-14',NULL,'2019-05-18 16:43:26','127.0.0.1','png','http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558169005633.png',4250,'image/png','1','',NULL,'2019-05-18 16:43:26',NULL,NULL,NULL,'0','00000000'),('f59b53b6fd3933830a5a7bad6c225284','c18ff76bb1aa806457df97510664173',NULL,'2020-12-13 12:48:33','127.0.0.1','jpg','http://localhost:8080/userfiles/20201213124833361.jpg',110689,'image/jpeg','1','',NULL,'2020-12-13 12:48:33',NULL,NULL,NULL,'0','00000000');
  
  /*Table structure for table `sms_send_log` */
  
  DROP TABLE IF EXISTS `sms_send_log`;
  
  CREATE TABLE `sms_send_log` (
    `id` varchar(32) NOT NULL,
    `phone` longtext NOT NULL COMMENT '联系电话',
    `template_name` varchar(50) DEFAULT NULL COMMENT '模板名称',
    `send_data` varchar(255) DEFAULT NULL COMMENT '发送数据',
    `send_code` varchar(20) DEFAULT NULL,
    `try_num` int(2) DEFAULT NULL,
    `status` varchar(4) NOT NULL COMMENT '发送状态',
    `smsid` varchar(50) DEFAULT NULL COMMENT '发送响应消息ID',
    `code` varchar(40) DEFAULT NULL COMMENT '返回码',
    `msg` varchar(600) DEFAULT NULL COMMENT '返回消息',
    `del_flag` varchar(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0：正常；1：删除）',
    `response_date` datetime DEFAULT NULL COMMENT '响应时间',
    `tenant_id` varchar(64) DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  
  /*Data for the table `sms_send_log` */
  
  insert  into `sms_send_log`(`id`,`phone`,`template_name`,`send_data`,`send_code`,`try_num`,`status`,`smsid`,`code`,`msg`,`del_flag`,`response_date`,`tenant_id`) values ('809291e1091c4784ac5cc006d6f7061a','15085980308','用户注册验证码','{\"code\":\"123456\"}','7hch8lsi8w',0,'1','8852983',NULL,'OK','0','2018-11-09 11:47:35','00000000'),('a576246cab47469997e76b3de666238f','15085980308','用户注册验证码','{\"code\":\"49156\"}','7hch8lsi8w',1,'1','7653143',NULL,'OK','0','2018-11-09 11:26:38','00000000'),('a65867c85f97474fbdc2414d1b77cf97','15085980308','找回密码验证码','{\"code\":\"88814\"}','oal0up6qo2',3,'-1','5365487',NULL,'触发分钟级流控Permits:1','0','2018-11-09 11:27:00','00000000');
  
  /*Table structure for table `sms_template` */
  
  DROP TABLE IF EXISTS `sms_template`;
  
  CREATE TABLE `sms_template` (
    `id` varchar(32) NOT NULL,
    `name` varchar(255) NOT NULL COMMENT '模版名称',
    `code` varchar(255) NOT NULL COMMENT '模版编码',
    `business_type` varchar(4) NOT NULL COMMENT '业务类型',
    `template_content` varchar(255) NOT NULL COMMENT '模版内容',
    `create_by` varchar(32) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` varchar(32) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `del_flag` varchar(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0：正常；1：删除）',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  
  /*Data for the table `sms_template` */
  
  insert  into `sms_template`(`id`,`name`,`code`,`business_type`,`template_content`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`remarks`,`tenant_id`) values ('6c625030d72e45b181ce689a2ca9afde','用户注册验证码','7hch8lsi8w','1','SMS_119805068','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-14 10:34:21','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-16 13:01:35','0',NULL,'00000000'),('a170787aa90c495d858401a36428999f','找回密码验证码','oal0up6qo2','1','SMS_119805067','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-14 10:34:38','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 16:32:43','0',NULL,'00000000');
  
  /*Table structure for table `sys_config` */
  
  DROP TABLE IF EXISTS `sys_config`;
  
  CREATE TABLE `sys_config` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `create_by` varchar(64) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(64) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `name` varchar(64) NOT NULL COMMENT '名称',
    `code` varchar(64) NOT NULL COMMENT '编码',
    `value` text NOT NULL COMMENT '值',
    `del_flag` int(2) NOT NULL DEFAULT '0',
    `is_sys` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是系统配置，如果是，该配置不可以删除',
    `tenant_id` varchar(11) NOT NULL DEFAULT '00000000',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `sys_config` */
  
  insert  into `sys_config`(`id`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`name`,`code`,`value`,`del_flag`,`is_sys`,`tenant_id`) values ('1',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-27 11:10:20','请勿随便设置','使用许可','license','123654',0,1,'00000000'),('107410e99915b184ba30aa34f2294a77','4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 04:36:39','4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 07:34:02','11','测试','test','11',0,0,'00000000'),('2',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-27 10:47:13',NULL,'产品ID','productId','wind',0,0,'00000000');
  
  /*Table structure for table `sys_data_rule` */
  
  DROP TABLE IF EXISTS `sys_data_rule`;
  
  CREATE TABLE `sys_data_rule` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `menu_id` varchar(64) DEFAULT NULL COMMENT '菜单主键',
    `resource_code` varchar(255) NOT NULL COMMENT '资源编号',
    `scope_name` varchar(255) NOT NULL COMMENT '数据权限名称',
    `scope_field` varchar(255) NOT NULL COMMENT '数据权限字段',
    `scope_class` varchar(500) NOT NULL COMMENT '数据权限类名',
    `scope_column` varchar(255) NOT NULL COMMENT '数据权限字段',
    `scope_type` int(2) NOT NULL COMMENT '数据权限类型',
    `scope_value` varchar(2000) DEFAULT NULL COMMENT '数据权限值域',
    `remarks` varchar(255) DEFAULT NULL COMMENT '数据权限备注',
    `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
    `create_dept` varchar(64) DEFAULT NULL COMMENT '创建部门',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
    `update_date` datetime DEFAULT NULL COMMENT '修改时间',
    `status` int(2) DEFAULT NULL COMMENT '状态',
    `del_flag` int(2) DEFAULT NULL COMMENT '是否已删除',
    `table_name` varchar(64) DEFAULT NULL COMMENT '数据库表',
    `user_column` varchar(64) DEFAULT NULL COMMENT '用户表对应字段',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    `user_entity_field` varchar(64) DEFAULT NULL COMMENT 'user实体类对应字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据权限表';
  
  /*Data for the table `sys_data_rule` */
  
  insert  into `sys_data_rule`(`id`,`menu_id`,`resource_code`,`scope_name`,`scope_field`,`scope_class`,`scope_column`,`scope_type`,`scope_value`,`remarks`,`create_by`,`create_dept`,`create_date`,`update_by`,`update_date`,`status`,`del_flag`,`table_name`,`user_column`,`tenant_id`,`user_entity_field`) values ('2d1d11805de287aa9b9108350cf45eac',NULL,'expandTable','test1','*','com.sunseagear.wind.modules.test.expandtable.mapper.ExpandTableMapper.selectPage','organization_id',4,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002',NULL,'2019-12-03 07:30:19','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-29 22:54:32',NULL,0,'sys_organization','organizationId','00000000',NULL),('dfc71dbeb4f8f15f9e00a945c177d2a6',NULL,'table','test','id,title,author,type,level,content,`user.realname`,`user.username`,status','com.sunseagear.wind.modules.test.table.mapper.TableMapper.selectPage','author',2,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002',NULL,'2019-11-29 15:18:25','4028ea815a3d2a8c015a3d2f8d2a0002','2020-10-31 12:01:59',NULL,0,'sys_organization','organization_id','00000000','organizationId');
  
  /*Table structure for table `sys_dict` */
  
  DROP TABLE IF EXISTS `sys_dict`;
  
  CREATE TABLE `sys_dict` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `gid` varchar(32) DEFAULT NULL COMMENT '分组ID',
    `label` varchar(100) DEFAULT NULL COMMENT '键值键',
    `value` varchar(100) DEFAULT NULL COMMENT '值',
    `sort` int(5) DEFAULT NULL COMMENT '排序',
    `remarks` varchar(100) DEFAULT NULL COMMENT '描述',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `sys_dict_groupid_key` (`gid`),
    CONSTRAINT `sys_dict_groupid_key` FOREIGN KEY (`gid`) REFERENCES `sys_dict_group` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典';
  
  /*Data for the table `sys_dict` */
  
  insert  into `sys_dict`(`id`,`gid`,`label`,`value`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) values ('04e4a4b8af5b6590f609ab29f1d920f1','e4ed989ab589d1be4b708bd285c24f1e','所在机构及下级可见','4',4,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:35:36','4028ea815a3d2a8c015a3d2f8d2a0002','2020-01-25 21:44:43','0'),('0578673152dd43afb7e2c65a4e3463b5',NULL,'wey7','002',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 00:02:02',NULL,NULL,'0'),('0b05a99bb7c24053bb06ddb9b41068c8','9dc0d8aceb9046559f0fcd3acfd4fb8d','按钮','3',3,'','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:47:23','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:38:29','0'),('2a6cb5048f204a6d99f5ea6e8cf450bf','0bf0a5f4378748c1b6b759aea7da9c72','修改','update',2,'修改','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:55:04',NULL,NULL,'0'),('2abd99f7a44e4ef0937b97109b31db87','9f28ef405c63412f9ef6524edb4adc68','继续执行','1',1,'继续执行','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-17 15:37:58',NULL,NULL,'0'),('30bf1683c3a54772bbc75193d8cc48ab','0bf0a5f4378748c1b6b759aea7da9c72','删除','delete',5,'删除','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:55:29',NULL,NULL,'0'),('32143ca22bd14795910255281934c340',NULL,'H6','001',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 00:01:36',NULL,NULL,'0'),('33a22077c3b8e79d93a1c78e23a0a050','e4ed989ab589d1be4b708bd285c24f1e','本人可见','2',2,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:35:00',NULL,NULL,'0'),('35f74a4053fa4880af41819297c9823f','69c0d7e407184b339b055215b3b719a5','25','25',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 11:32:20',NULL,NULL,'0'),('3e285e6650cb47f88f452e156b5bf903','0bf0a5f4378748c1b6b759aea7da9c72','导出','export',7,'导出','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:56:28',NULL,NULL,'0'),('3eb18e509ffb4dd5a069e6ea10a14001','1044ab256fd2468289c6f876905ff8aa','是','true',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:41:25',NULL,NULL,'0'),('40281e815ced1f27015ced2f83bc000b','40281e815ced1f27015ced2be5330003','男','1',1,'1',NULL,NULL,NULL,NULL,'0'),('40281e815cef4f99015cef6f7d070005','40281e815ced1f27015ced2be5330003','女','2',1,'女',NULL,NULL,NULL,NULL,'0'),('40288ab85a20b609015a20c422e90003','40288ab85a20b609015a20c3f7bf0002','是','1',1,'1',NULL,NULL,NULL,NULL,'0'),('40288ab85a5eecc6015a5eede8720000','40288ab85a20b609015a20c3f7bf0002','否','0',2,'否',NULL,NULL,NULL,NULL,'0'),('40288ab85bf1549e015bf175152a0001','40288ab85bf1549e015bf17370ff0000','在线','on_line',1,'在线',NULL,NULL,NULL,NULL,'0'),('40288ab85bf1549e015bf17559ac0002','40288ab85bf1549e015bf17370ff0000','隐身','hidden',2,'隐身',NULL,NULL,NULL,NULL,'0'),('40288ab85bf1549e015bf17590820003','40288ab85bf1549e015bf17370ff0000','强制退出','force_logout',3,'强制退出',NULL,NULL,NULL,NULL,'0'),('40288ab85c8593cd015c859b70010011','40288ab85c8593cd015c859b1fcf0010','验证码','1',1,'验证码',NULL,NULL,NULL,NULL,'0'),('40288ab85c8593cd015c859b8ff50012','40288ab85c8593cd015c859b1fcf0010','通知','2',2,'通知',NULL,NULL,NULL,NULL,'0'),('40288ab85c86382b015c863993a30002','40288ab85c8593cd015c859b1fcf0010','其他','99',99,'其他',NULL,NULL,NULL,NULL,'0'),('4e23f0cd2a154d62bdd9417610ca2679','0bf0a5f4378748c1b6b759aea7da9c72','新增','insert',1,'新增','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:54:48',NULL,NULL,'0'),('5b905a49c182491988865986e4cc48e3','9f28ef405c63412f9ef6524edb4adc68','放弃执行','3',3,'放弃执行','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-17 15:38:20',NULL,NULL,'0'),('6aeb216b950740c9ba61ba2994b4ce98','9f28ef405c63412f9ef6524edb4adc68','一次执行','2',2,'一次执行','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-17 15:38:10',NULL,NULL,'0'),('72a55df5480c48b79e095eb5c6a4728f','d8fd027d0743468c828d7d068239d483','成功','1',1,'成功','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-28 13:15:31',NULL,NULL,'0'),('7da9613b9af54ea19fd6b2ba349fc8ea','9dc0d8aceb9046559f0fcd3acfd4fb8d','菜单','2',2,'','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:47:13','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:38:26','0'),('821adedf100644382102418b6bb9fd9f','e4ed989ab589d1be4b708bd285c24f1e','全部可见','1',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:34:43',NULL,NULL,'0'),('839273eee78947759bd8a980fcf77e99','0bf0a5f4378748c1b6b759aea7da9c72','查询','select',3,'查询','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:55:13',NULL,NULL,'0'),('90f97d607fb745019c88e126b989fa8d','7a4ed165f128484787a119179b7c18fd','普通类','2',2,'普通类','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-20 15:00:56','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-17 17:57:04','0'),('929342ef5d29f0db17df321cb48d54b5','e4ed989ab589d1be4b708bd285c24f1e','所在机构可见','3',3,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:35:10',NULL,NULL,'0'),('94be09dc54b345e7b170711b14003b48','69c0d7e407184b339b055215b3b719a5','50','50',2,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 11:32:30',NULL,NULL,'0'),('97a7d2a2669a47b5a55565d906eef341','9dc0d8aceb9046559f0fcd3acfd4fb8d','目录','1',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:47:01','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:38:23','0'),('a94650c480914ad69f4820b01086a8be','7a4ed165f128484787a119179b7c18fd','SpringBean','1',1,'SpringBean','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-20 15:00:31','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-24 12:36:33','0'),('aa6aeaf0fcaa42098f039b5e15494ebb','0bf0a5f4378748c1b6b759aea7da9c72','其他','other',6,'其他','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:55:59',NULL,NULL,'0'),('b568561ffaa5459e8c79fd71d58eede2','0bf0a5f4378748c1b6b759aea7da9c72','导入','import',8,'导入','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:56:44',NULL,NULL,'0'),('b9e6addb28b8487299413f5346bb621f','69c0d7e407184b339b055215b3b719a5','150','150',4,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 15:18:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 15:29:22','0'),('bbaa5726c9dd4e33bd9aa8b6003ec6e0','69c0d7e407184b339b055215b3b719a5','100','100',3,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 11:33:15',NULL,NULL,'0'),('de1ad2226ae04bb98f6db78ff9e7fee0','d8fd027d0743468c828d7d068239d483','失败','-1',1,'失败','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-28 13:15:39',NULL,NULL,'0'),('e64158128fd1400fb9f834c7a96a1046','d8fd027d0743468c828d7d068239d483','退出','0',0,'退出','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-28 13:15:54',NULL,NULL,'0'),('e76f306325a0675d51f1dc25359a568e','e4ed989ab589d1be4b708bd285c24f1e','自定义','5',5,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:36:04','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:36:18','0'),('e7a5f8f4fbb94cc2a3db0487340cccb4','1044ab256fd2468289c6f876905ff8aa','否','false',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:41:31',NULL,NULL,'0');
  
  /*Table structure for table `sys_dict_group` */
  
  DROP TABLE IF EXISTS `sys_dict_group`;
  
  CREATE TABLE `sys_dict_group` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `name` varchar(100) DEFAULT NULL COMMENT '分组名称',
    `code` varchar(100) DEFAULT NULL COMMENT '分组编码',
    `remarks` varchar(100) DEFAULT NULL COMMENT '备注',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典分组';
  
  /*Data for the table `sys_dict_group` */
  
  insert  into `sys_dict_group`(`id`,`name`,`code`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) values ('0bf0a5f4378748c1b6b759aea7da9c72','日志类型','logType','日志类型','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-30 23:54:01',NULL,NULL,'0'),('1044ab256fd2468289c6f876905ff8aa','是否','sf_bool','是否','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:41:17',NULL,NULL,'0'),('40281e815ced1f27015ced2be5330003','性别','sex','性别',NULL,NULL,NULL,NULL,'0'),('40288ab85a20b609015a20c3f7bf0002','是否','sf','是否',NULL,NULL,NULL,NULL,'0'),('40288ab85bf1549e015bf17370ff0000','用户登陆状态','onlinestatus','',NULL,NULL,NULL,NULL,'0'),('40288ab85c8593cd015c859b1fcf0010','短信业务类型','businesstype','短信业务类型',NULL,NULL,NULL,NULL,'0'),('69c0d7e407184b339b055215b3b719a5','分页数组','page','','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 11:31:44','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 14:13:28','0'),('7a4ed165f128484787a119179b7c18fd','任务加载方式','loadway','任务加载方式','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-20 15:00:01','4028ea815a3d2a8c015a3d2f8d2a0002','2018-08-27 16:46:02','0'),('9dc0d8aceb9046559f0fcd3acfd4fb8d','菜单类型','menutype','','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 14:46:50','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:42:07','0'),('9f28ef405c63412f9ef6524edb4adc68','执行策略','misfirePolicy','执行策略','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-17 15:37:42',NULL,NULL,'0'),('d8fd027d0743468c828d7d068239d483','登陆状态','loginstatus','登陆状态','4028ea815a3d2a8c015a3d2f8d2a0002','2018-09-28 13:15:00',NULL,NULL,'0'),('e4ed989ab589d1be4b708bd285c24f1e','数据权限类型','dataRuleType','','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:32:40',NULL,NULL,'0');
  
  /*Table structure for table `sys_login_log` */
  
  DROP TABLE IF EXISTS `sys_login_log`;
  
  CREATE TABLE `sys_login_log` (
    `id` varchar(32) NOT NULL COMMENT '访问ID',
    `login_name` varchar(50) DEFAULT '' COMMENT '登录账号',
    `login_ip` varchar(50) DEFAULT '' COMMENT '登录IP地址',
    `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
    `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
    `os` varchar(50) DEFAULT '' COMMENT '操作系统',
    `status` char(2) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
    `login_time` datetime DEFAULT NULL COMMENT '访问时间',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统访问记录';
  
  /*Data for the table `sys_login_log` */
  
  insert  into `sys_login_log`(`id`,`login_name`,`login_ip`,`login_location`,`browser`,`os`,`status`,`msg`,`login_time`,`tenant_id`) values ('04a0cae02767507b08f8752f2cf9a27f','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-17 13:46:24','00000000'),('097e9cb57f6fc7405e159878a8510eb5','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 23:22:35','00000000'),('09a5bfbe2031c2783a2c27ab695760ea','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-16 21:55:29','00000000'),('2b8d0fc61b1294eae7acf82bcd316760','admin','127.0.0.1','','Chrome 8','Windows 10','0','退出成功','2021-01-01 22:19:25','00000000'),('2bcf2535e7caf5c653117d86a30b27e5','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 23:10:15','00000000'),('3188ed992f582017d558fb62c22c367f','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:20:46','00000000'),('3c2ff44aad767adfb1d29d18745495c1','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:19:15','00000000'),('4fc8bdfdeac675a339b5908d2d9c2b61','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 23:21:25','00000000'),('8bf97f007153d2c2bf003fc056108cd4','admin','127.0.0.1','','Chrome 8','Windows 10','0','退出成功','2021-01-01 22:17:42','00000000'),('aa745e50c99663596a74035cbf5aa960','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:24:36','00000000'),('ac0baebb0f2055ad9189f63a94a41336','admin','127.0.0.1','','Chrome 8','Windows 10','0','退出成功','2021-01-01 22:23:29','00000000'),('b9887532cbfbacb3d29178cb00c11ad4','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-16 22:48:21','00000000'),('c947a35d88cfe13db8fbc144adfdc070','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-17 15:09:49','00000000'),('dc9a265de161dab2ab69e6992572a326','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:09:57','00000000'),('e306c8404a0e16c5fb7deba95094674f','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-16 15:37:13','00000000'),('ee5f1ad968e8dcf5f30d8500bf431d64','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:17:41','00000000'),('f00663bdbe9f1adf880624ad92b33ea9','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-03 14:50:02','00000000'),('f17fa90ba270f930c7c93c221139c928','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:16:31','00000000'),('f4d75adbc331a0a1dc124a226144c25a','admin','127.0.0.1','','Chrome 8','Windows 10','0','退出成功','2021-01-01 23:22:29','00000000'),('fb8297b6dc30110892a6628f4740c10b','admin','127.0.0.1','','Chrome 8','Windows 10','1','登陆成功','2021-01-01 22:23:29','00000000'),('ff849e524015d1ba8f7c5ca55d747eb2','admin','127.0.0.1','','Chrome 8','Windows 10','0','退出成功','2021-01-01 22:25:48','00000000');
  
  /*Table structure for table `sys_menu` */
  
  DROP TABLE IF EXISTS `sys_menu`;
  
  CREATE TABLE `sys_menu` (
    `id` varchar(32) NOT NULL,
    `permission` varchar(100) DEFAULT NULL COMMENT '权限ID',
    `name` varchar(100) DEFAULT NULL COMMENT '资源路径',
    `type` varchar(50) DEFAULT NULL COMMENT '菜单类型',
    `path` varchar(200) DEFAULT NULL COMMENT '路径编码',
    `url` varchar(200) DEFAULT NULL COMMENT '访问路由',
    `parent_id` varchar(32) DEFAULT NULL COMMENT '父编号',
    `parent_ids` varchar(1000) DEFAULT NULL COMMENT '父编号列表',
    `enabled` tinyint(1) DEFAULT '0' COMMENT '是否显示',
    `sort` int(5) DEFAULT NULL COMMENT '排序',
    `icon` varchar(255) DEFAULT NULL COMMENT '图标',
    `redirect` varchar(255) DEFAULT NULL COMMENT '跳转URL',
    `cacheable` tinyint(1) DEFAULT NULL COMMENT '是否缓存',
    `require_auth` tinyint(1) DEFAULT NULL,
    `component` varchar(255) DEFAULT NULL COMMENT '前端资源路径',
    `remarks` varchar(255) DEFAULT NULL COMMENT '摘要',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_sys_resource_parent_id` (`parent_id`),
    KEY `idx_sys_resource_parent_ids` (`parent_ids`(255))
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `sys_menu` */
  
  insert  into `sys_menu`(`id`,`permission`,`name`,`type`,`path`,`url`,`parent_id`,`parent_ids`,`enabled`,`sort`,`icon`,`redirect`,`cacheable`,`require_auth`,`component`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) values ('008c004de43a4ebab36deb9b9a11a790','oss:attachment:update','更新','3',NULL,NULL,'203aacd2a474445d8d4fb22199a7fe40',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:45:43',NULL,NULL,'0'),('0b73fc6442d3484ebfcc0e945916a38c','sms:sendlog:delete','删除','3',NULL,NULL,'5a7fb16c87f745dfb3185be1e65673a5',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:52:00',NULL,NULL,'0'),('0ce52312cd294c5a95ffec7e7abe0ef1','sys:role:update','更新','3',NULL,NULL,'f3938743bdab4c64bfa99c5c9e5341e1',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:52:50',NULL,NULL,'0'),('10dbd0f844d04bbcbc394dcdd6b9f258','test:treetable:treetable:delete','删除','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:26',NULL,NULL,'0'),('1307a3dd0f934efba63b2ba4b04ffd08','test:expandtable:expandtable:detail','详情','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,6,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:20:05',NULL,NULL,'0'),('1386f898cb3862fb48e3a314852031e7','sys:organization:detail','详情','3','','','8402e9bc967144d0988386a54c912548','a2da339ab8014bb1a0600bd20149bbbd/8402e9bc967144d0988386a54c912548/',1,2,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:32:49','4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:33:16','0'),('13dbeacf57934abe970497ed34ea6e59','monitor:login:log:list','查询','3',NULL,NULL,'48663b3b2eb5457e8a79a6a105b8fb69',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:46:46',NULL,NULL,'0'),('153c8847203a4df5bd8ff08e20fb6e3b','sys:datarule:detail','详情','3',NULL,NULL,'9f8897e23c5b4c4e924ec983404834a6','a2da339ab8014bb1a0600bd20149bbbd/9f8897e23c5b4c4e924ec983404834a6/',1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16',NULL,NULL,'0'),('1c41720eeea94e59aeb2ea84b2cd3b00','sys:datarule:delete','删除','3',NULL,NULL,'9f8897e23c5b4c4e924ec983404834a6','a2da339ab8014bb1a0600bd20149bbbd/9f8897e23c5b4c4e924ec983404834a6/',1,5,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16',NULL,NULL,'0'),('1c6cfbfc836f4c588375458bb0968c12','test:twotable:carmodel:export','汽车型号导出','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:50:24','0'),('1e46d1cc27f248fb880cc887639e2e4e','sys:user:export','导出','3',NULL,NULL,'bedb1eeccf294d98ba2f636365d01928',NULL,1,4,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:45:14',NULL,NULL,'0'),('1fa22fa16d6140ffbddb5747e33e7205','sms:template:delete','删除','3',NULL,NULL,'5534c207669f4ba3af912622a8b5fee6',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:51:09',NULL,NULL,'0'),('203aacd2a474445d8d4fb22199a7fe40',NULL,'附件日志','2','/monitor/attachment','','4cfdb4c51e144a34957e2a2ceca7fae9','4cfdb4c51e144a34957e2a2ceca7fae9/',1,0,'',NULL,1,1,'views/monitor/attachment/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:23:20','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:48:40','0'),('21c83bb40edd4a9e95a2392f4ed8394a','test:expandtable:expandtable:update','更新','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('247c9f811073431da881a8f90972e1c8','','树形表格','2','/demo/treeTable','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,3,'',NULL,1,1,'views/demo/treeTable/treeTableList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 13:17:20','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:52:21','0'),('26ab0c0a2cff4bf49079bc6ee3462f27',NULL,'表格级联','2','/demo/twoTable','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,2,'',NULL,1,1,'views/demo/twoTable/twoTable',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 13:21:24','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:52:13','0'),('27b5cf637a964a4a97b716739056c8e4','sys:tenant:list','列表','3',NULL,NULL,'9de6b62cb95e483c8e57392213a87f77','a2da339ab8014bb1a0600bd20149bbbd/9de6b62cb95e483c8e57392213a87f77/',1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20',NULL,NULL,'0'),('2821d2f3dc5042459a4b975e1cba929a',NULL,'源码更新','2','https://gitee.com/sunseagear/wind','','3f4c3063841641319d95412352db5a35','3f4c3063841641319d95412352db5a35/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:08:00','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 18:25:25','0'),('2954fb967419410fb281857ec86db428','task:schedule:job:add','添加','3',NULL,NULL,'38edc1e2843d411b99a05b721a2f778a',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:05',NULL,NULL,'0'),('2eef0abf5d414d9589576c30b8202dcd','task:schedule:job:list','查询','3',NULL,NULL,'38edc1e2843d411b99a05b721a2f778a',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:05',NULL,NULL,'0'),('3135bcb72d324ac8aad4a42823545570','test:expandtable:expandtable:delete','删除','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('35850e938efe413f9ddcc7821225266b','oss:attachment:list','查询','3',NULL,NULL,'203aacd2a474445d8d4fb22199a7fe40',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:45:43',NULL,NULL,'0'),('35af237befdb46b097070599470c8eed','sys:dict:add','添加','3',NULL,NULL,'6dd8f9cceaf04ce5959e961a59ab91fc',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:28',NULL,NULL,'0'),('3864b314549e4a9cb9e540fba21852a3','test:table:table:import','导入','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,5,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('38edc1e2843d411b99a05b721a2f778a',NULL,'计划任务','2','/tool/task','','88b25c355bdc4a7b8b8bfdb307918eb5','88b25c355bdc4a7b8b8bfdb307918eb5/',1,1,'',NULL,1,1,'views/tool/task/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:03:13','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:49:40','0'),('39883d8ee458426d8890dbc0a61dc3ac','test:table:table:update','更新','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('3b980e49ec4d4d208eec8f4dd433ca6c','sys:menu:update','更新','3',NULL,NULL,'64a6cd14e86f434db5bc6bd3f947398f',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:04',NULL,NULL,'0'),('3eaf2534601a4eac9cda4b17c333eee3','test:treeandtable:treeandtable','左树右表','2','/demo/treeAndTable','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,4,'',NULL,1,1,'views/demo/treeAndTable/treeAndTableList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 13:20:39','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-13 16:36:25','0'),('3f4c3063841641319d95412352db5a35',NULL,'系统帮助','1','','',NULL,NULL,1,70,'fas fa-question-circle',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:05:04','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:53:05','0'),('40a71f551a18416a850063d42250e09f','sys:organization:list','查询','3',NULL,NULL,'8402e9bc967144d0988386a54c912548','a2da339ab8014bb1a0600bd20149bbbd/8402e9bc967144d0988386a54c912548/',1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:03:07','4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:33:15','0'),('41141cd290874c76968cee0ac9932f67','sys:tenant:detail','详情','3',NULL,NULL,'9de6b62cb95e483c8e57392213a87f77','a2da339ab8014bb1a0600bd20149bbbd/9de6b62cb95e483c8e57392213a87f77/',1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20',NULL,NULL,'0'),('41529f653db84afaaf9ef4b16845842e','sys:user:list','查询','3',NULL,NULL,'bedb1eeccf294d98ba2f636365d01928',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:45:14',NULL,NULL,'0'),('41b543b75bcc4feca88f8b2e34c8c8c4','test:twotable:car:detail','详情','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,14,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:01','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:35','0'),('42cba67a7200910918ed3d6b2cf897e3',NULL,'网络通信','2','/demo/websocket','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,6,'',NULL,1,1,'views/demo/websocket/websocket',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-23 23:15:29','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-23 23:17:36','0'),('4548f01cbbf0427e8bb47243d4a546e9','sys:dict:delete','删除','3',NULL,NULL,'6dd8f9cceaf04ce5959e961a59ab91fc',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:28',NULL,NULL,'0'),('467202a879c0455d948185ad52ee871b','sys:config:update','更新','3',NULL,NULL,'ea3bf0ab4bd042e0be6416680f66e19c',NULL,1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-23 16:43:32',NULL,NULL,'0'),('46ddbbabf30445e3a75ff2294e06ec50','test:treetable:treetable:detail','详情','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,10,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:54',NULL,NULL,'0'),('48663b3b2eb5457e8a79a6a105b8fb69',NULL,'登陆日志','2','/monitor/loginLog','','4cfdb4c51e144a34957e2a2ceca7fae9','4cfdb4c51e144a34957e2a2ceca7fae9/',1,1,'',NULL,1,1,'views/monitor/log/login',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:24:25','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:48:48','0'),('4870363dbd084cdc99840732a26d9c4a','test:twotable:car:import','导入','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,12,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:32','0'),('498016d4913446deb6415785befd3480','sys:dict:group:delete','删除分组','3','','','6dd8f9cceaf04ce5959e961a59ab91fc','a2da339ab8014bb1a0600bd20149bbbd/6dd8f9cceaf04ce5959e961a59ab91fc/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:41:12',NULL,NULL,'0'),('49e01ae88046460484d262d47fa30719','sys:dict:list','查询','3',NULL,NULL,'6dd8f9cceaf04ce5959e961a59ab91fc',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:28',NULL,NULL,'0'),('4b96d6bd8bf542ca888cdb64b1006c69','task:schedule:job:refresh:job','刷新任务','3','','','38edc1e2843d411b99a05b721a2f778a','88b25c355bdc4a7b8b8bfdb307918eb5/38edc1e2843d411b99a05b721a2f778a/',1,0,'',NULL,1,1,'','刷新任务','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:55:19',NULL,NULL,'0'),('4cfdb4c51e144a34957e2a2ceca7fae9',NULL,'系统监控','1','','',NULL,NULL,1,40,'fas fa-chart-line',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:13:37','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:49:28','0'),('4d559f775fb94b20b87c22c6643b3180','sys:dict:group:list','查询分组','3','','','6dd8f9cceaf04ce5959e961a59ab91fc','a2da339ab8014bb1a0600bd20149bbbd/6dd8f9cceaf04ce5959e961a59ab91fc/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:39:48','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:41:20','0'),('4de1c247dc8d4adfa48beb27e4e5696d','sys:menu:generate:button','生成按钮','3','','','64a6cd14e86f434db5bc6bd3f947398f','a2da339ab8014bb1a0600bd20149bbbd/64a6cd14e86f434db5bc6bd3f947398f/',1,0,'',NULL,1,1,'','备注','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:01:31','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:01:52','0'),('4ee35f7f1db2420e82f8ce6833ba885e','sys:datarule:list','列表','3',NULL,NULL,'9f8897e23c5b4c4e924ec983404834a6','a2da339ab8014bb1a0600bd20149bbbd/9f8897e23c5b4c4e924ec983404834a6/',1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16',NULL,NULL,'0'),('50e2814c16ac4bef821cb0af6bea1e2b','test:expandtable:expandtable:list','查询','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('5534c207669f4ba3af912622a8b5fee6',NULL,'短信模板','2','/sms/template','','699fbeee7c914b619485f259f83a2e6d','699fbeee7c914b619485f259f83a2e6d/',1,0,'',NULL,1,1,'views/sms/template/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:50:14','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:46:54','0'),('55c0e037734a4f4d803e881cd7204692','sys:config:detail','详情','3',NULL,NULL,'ea3bf0ab4bd042e0be6416680f66e19c','a2da339ab8014bb1a0600bd20149bbbd/ea3bf0ab4bd042e0be6416680f66e19c/',1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-23 16:43:32','4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 04:12:19','0'),('56e87bb7ee424e6999b27cb2a4cbc96d','test:expandtable:expandtable:import','导入','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,5,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('57b666b69b554c8d80da32b0141776af','test:treetable:treetable:add','添加','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:26',NULL,NULL,'0'),('5a7fb16c87f745dfb3185be1e65673a5',NULL,'发送日志','2','/sms/sendlog','','699fbeee7c914b619485f259f83a2e6d','699fbeee7c914b619485f259f83a2e6d/',1,1,'',NULL,1,1,'views/sms/send/log',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:50:47','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:47:06','0'),('5a92b11ad8434ff68b588767417c6b58','sys:datarule:add','添加','3',NULL,NULL,'9f8897e23c5b4c4e924ec983404834a6','a2da339ab8014bb1a0600bd20149bbbd/9f8897e23c5b4c4e924ec983404834a6/',1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16',NULL,NULL,'0'),('5b85cfebd56141d1a100102727395556','test:treeandtable:treeandtable:import','导入','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,5,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('608629d6bfa7461f9ca258a4393523a1','sys:user:add','添加','3',NULL,NULL,'bedb1eeccf294d98ba2f636365d01928',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:45:14',NULL,NULL,'0'),('64a6cd14e86f434db5bc6bd3f947398f',NULL,'菜单管理','2','/sys/menu','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,30,'',NULL,1,1,'views/sys/menu/menuList','菜单管理','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:12:53','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:16:55','0'),('650fa5a8ccd04deeb656321311410606','monitor:operation:log:list','查询','3',NULL,NULL,'fdb08c18a73648ddb77d2558167a764a',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:47:04',NULL,NULL,'0'),('653c7b79ebdf4054b3a7233ad6168d49',NULL,'在线用户','2','/monitor/onlineUser','','4cfdb4c51e144a34957e2a2ceca7fae9','4cfdb4c51e144a34957e2a2ceca7fae9/',1,3,'',NULL,1,1,'views/monitor/user/online',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:24:02','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:49:11','0'),('6869b6f955594ab2a8d10b0b130120b4','test:twotable:carmodel:add','汽车型号添加','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:48:07','0'),('69039de89fb94c54be70543475b995ad','test:twotable:car:delete','删除','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,10,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:28','0'),('699fbeee7c914b619485f259f83a2e6d',NULL,'短信管理','1','','',NULL,NULL,1,20,'fas fa-sms',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:49:28','4028ea815a3d2a8c015a3d2f8d2a0002','2019-09-09 21:07:24','0'),('6c46f6d5f6cd4cc094cc295737c3ace6','test:table:table:export','导出','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('6dd8f9cceaf04ce5959e961a59ab91fc','','字典管理','2','/sys/dict','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,60,'',NULL,1,1,'views/sys/dict/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:12:18','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:17:14','0'),('6e36c83436e34bfbb316058453e3205f','task:schedule:job:update','更新','3',NULL,NULL,'38edc1e2843d411b99a05b721a2f778a',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:05',NULL,NULL,'0'),('70466fa5271d45dc99cccea0027c3dc2','sys:tenant:update','更新','3',NULL,NULL,'9de6b62cb95e483c8e57392213a87f77','a2da339ab8014bb1a0600bd20149bbbd/9de6b62cb95e483c8e57392213a87f77/',1,4,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20',NULL,NULL,'0'),('70d7d2aa8c291a5013360d86ce91d954',NULL,'综合表单','2','/demo/tableView/:id/:title','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',0,0,'',NULL,1,1,'views/demo/table/tableView',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-12-14 23:37:26','4028ea815a3d2a8c015a3d2f8d2a0002','2020-12-14 23:37:54','0'),('7230458979a149d48ff88544ce985809','monitor:operation:log:delete','删除','3',NULL,NULL,'fdb08c18a73648ddb77d2558167a764a',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:47:04',NULL,NULL,'0'),('760dd42695984c15a0db3f1e4ed0a4af','test:table:table:delete','删除','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('76fd71b67d784ed9bd02e320a387e834','','邮件管理','1','','',NULL,NULL,1,30,'fas fa-mail-bulk',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:22:57','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:48:16','0'),('779d64b7717c4f3a99fc96ed7ccd075d','sms:template:list','查询','3',NULL,NULL,'5534c207669f4ba3af912622a8b5fee6',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:51:09',NULL,NULL,'0'),('7811944f996a441e9b3a761b18cb88bf','test:treetable:treetable:update','更新','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,6,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('79059d522a11459394c23c6f29092c41','sys:organization:add','添加','3',NULL,NULL,'8402e9bc967144d0988386a54c912548','a2da339ab8014bb1a0600bd20149bbbd/8402e9bc967144d0988386a54c912548/',1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:03:07','4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:33:19','0'),('8386bfdcf52547c1a091e71873eedfdf',NULL,'任务日志','2','/tool/tasklog','','88b25c355bdc4a7b8b8bfdb307918eb5','88b25c355bdc4a7b8b8bfdb307918eb5/',1,2,'',NULL,1,1,'views/tool/task/log',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:03:34','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:49:51','0'),('83aea54a484b4bc8a19259352badaceb','sys:user:update','更新','3',NULL,NULL,'bedb1eeccf294d98ba2f636365d01928',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:45:14',NULL,NULL,'0'),('83da63a6359e494cbbaffa678274ec19','sys:user:change:password','修改密码','3','','','bedb1eeccf294d98ba2f636365d01928','a2da339ab8014bb1a0600bd20149bbbd/bedb1eeccf294d98ba2f636365d01928/',1,0,'',NULL,1,1,'','修改密码','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:02:30','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:03:03','0'),('8402e9bc967144d0988386a54c912548',NULL,'组织机构','2','/sys/organization','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,50,'',NULL,1,1,'views/sys/organization/organizationList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:09:52','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:17:06','0'),('86d49f3cd426463080e0ac13bdfbc28d','sys:organization:delete','删除','3',NULL,NULL,'8402e9bc967144d0988386a54c912548','a2da339ab8014bb1a0600bd20149bbbd/8402e9bc967144d0988386a54c912548/',1,5,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:03:07','4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:33:24','0'),('86f65f1677184cc5b92201bbb63618d7',NULL,'发送日志','2','/email/sendlog','','76fd71b67d784ed9bd02e320a387e834','76fd71b67d784ed9bd02e320a387e834/',1,1,'',NULL,1,1,'views/email/send/log',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:24:04','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:48:06','0'),('86fcadeb0950427b8a4819a4229bbd74','test:treetable:treetable:delete','删除','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,9,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('87c10320fb46431e8e2900d45d9f6dad','task:schedule:job:change:job:status','变更状态','3','','','38edc1e2843d411b99a05b721a2f778a','88b25c355bdc4a7b8b8bfdb307918eb5/38edc1e2843d411b99a05b721a2f778a/',1,0,'',NULL,1,1,'','变更状态','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 13:00:19',NULL,NULL,'0'),('88b25c355bdc4a7b8b8bfdb307918eb5',NULL,'定时任务','1','','',NULL,NULL,1,60,'fas fa-clock',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:02:41','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:50:12','0'),('8a13a95a71b948208d31acb590112440','sys:menu:add','添加','3',NULL,NULL,'64a6cd14e86f434db5bc6bd3f947398f',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:04',NULL,NULL,'0'),('8b226abad44047b6aa2a164b441a3815','test:expandtable:expandtable:add','添加','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('91b33be150b3416d82ba38128590c507','monitor:login:log:export','导出','3','','','48663b3b2eb5457e8a79a6a105b8fb69','4cfdb4c51e144a34957e2a2ceca7fae9/48663b3b2eb5457e8a79a6a105b8fb69/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 14:07:10','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 14:07:26','0'),('91fccb99710f4f2e97567653a8ef14d6','task:schedule:joblog:list','查询','3',NULL,NULL,'8386bfdcf52547c1a091e71873eedfdf',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:25',NULL,NULL,'0'),('93669750fdad4979b658408e13675b30','sys:dict:group:add','添加分组','3','','','6dd8f9cceaf04ce5959e961a59ab91fc','a2da339ab8014bb1a0600bd20149bbbd/6dd8f9cceaf04ce5959e961a59ab91fc/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:39:23','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:41:27','0'),('936b2acedf194ed3bfc403acc4c5aa71','test:twotable:car:list','查询','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,7,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:18','0'),('9406154d48144fe0971880bb9d79f3a8','sys:tenant:delete','删除','3',NULL,NULL,'9de6b62cb95e483c8e57392213a87f77','a2da339ab8014bb1a0600bd20149bbbd/9de6b62cb95e483c8e57392213a87f77/',1,5,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20',NULL,NULL,'0'),('97194b12b19248c79336a634a0ed9ac3','task:schedule:joblog:delete','删除','3',NULL,NULL,'8386bfdcf52547c1a091e71873eedfdf',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:25',NULL,NULL,'0'),('9a42181d7301459b935871b921e1a89a','test:treeandtable:treeandtable:add','添加','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('9afdab469e1f4f3fab4b242a2d5679e9','test:treetable:treetable:list','查询','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('9c44133cf8d14addbb4b024f3515f4df','task:schedule:job:delete','删除','3',NULL,NULL,'38edc1e2843d411b99a05b721a2f778a',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:48:05',NULL,NULL,'0'),('9c59bd5de46b48a4911047bf3307ebbc','test:treeandtable:treeandtable:update','更新','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('9de6b62cb95e483c8e57392213a87f77','sys:tenant:list','租户管理','2','/sys/tenant','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,0,NULL,NULL,1,1,'views/sys/tenant/tenantList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-04 08:32:25','0'),('9f4f6568e9a54623b52657bcc6a6f478','test:twotable:car:update','更新','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,9,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:26','0'),('9f8897e23c5b4c4e924ec983404834a6','sys:datarule:list','数据权限','2','/sys/dataRule','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,40,NULL,NULL,1,1,'views/sys/dataRule/dataRuleList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-04 09:06:43','0'),('9fbb210970df4024bfb1e9eaaa9de6ac','sys:menu:delete','删除','3',NULL,NULL,'64a6cd14e86f434db5bc6bd3f947398f',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:04',NULL,NULL,'0'),('a2da339ab8014bb1a0600bd20149bbbd',NULL,'系统设置','1','','',NULL,NULL,1,10,'fas fa-cog',NULL,1,1,'','系统设置','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:08:45','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:17:37','0'),('a3bb826296174bb7b7bfdd0fcb2d33fc','sys:role:delete','删除','3',NULL,NULL,'f3938743bdab4c64bfa99c5c9e5341e1',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:52:50',NULL,NULL,'0'),('a9d4028655c945eba33546ff3df634e4','test:treeandtable:treeandtable:detail','详情','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,6,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:19:40',NULL,NULL,'0'),('abc8dc302b1540f69f2a8c24a5612c2a','sms:template:update','更新','3',NULL,NULL,'5534c207669f4ba3af912622a8b5fee6',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:51:09',NULL,NULL,'0'),('abe099fdb4144a88b6635eea23d0bd01',NULL,'代码样例','1','','',NULL,NULL,1,80,'fas fa-code',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 10:56:31','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:51:46','0'),('ac793681eab74d2d99e3e6d335a79826',NULL,'表格展开','2','/demo/expendTable','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,5,'',NULL,1,1,'views/demo/expandTable/expandTableList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 13:24:13','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-13 14:56:40','0'),('ae18e571ddd44dbaa0384f685b3e357a',NULL,'开发文档','2','https://panjiachen.github.io/vue-element-admin-site/zh/','','3f4c3063841641319d95412352db5a35','3f4c3063841641319d95412352db5a35/',1,1,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:05:48','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 18:24:53','0'),('afa4277041cb454ab789b55d4b4b824a','test:twotable:car:add','添加','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,8,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:24','0'),('b0da410e900944aa84d3ad2a170ec006','sys:datarule:update','更新','3',NULL,NULL,'9f8897e23c5b4c4e924ec983404834a6','a2da339ab8014bb1a0600bd20149bbbd/9f8897e23c5b4c4e924ec983404834a6/',1,4,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 03:25:16',NULL,NULL,'0'),('b338552c1eee4313b1a21a880df97e81','sys:user:dddd','设置角色','3','','','bedb1eeccf294d98ba2f636365d01928','a2da339ab8014bb1a0600bd20149bbbd/bedb1eeccf294d98ba2f636365d01928/',1,0,'',NULL,1,1,'','设置角色','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:02:55',NULL,NULL,'0'),('b899735bed7744c2a27c5bf3c35a3e1e','test:treetable:treetable:export','导出','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,7,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('b8faa3f2cdc9499e814be30e218a88f5','test:table:table:add','添加','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,1,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('ba46b8b6d27c4f0cabea1598d15cad27','test:twotable:carmodel:import','汽车型号导入','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,5,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:50:39','0'),('bb2e6d8d88cb4685a33a27823dd09a30','test:treeandtable:treeandtable:list','查询','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('bb981a178102e12675e1c393e85f4fa3',NULL,'代码生成','2','http://sunseagear.com:8081/admin/','',NULL,NULL,1,90,'fas fa-laptop-code',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-10-30 23:26:58','4028ea815a3d2a8c015a3d2f8d2a0002','2020-10-30 23:27:41','0'),('bc3c57bb7d954de7a64956e6df718fe2','sys:dict:group:update','添加分组','3','','','6dd8f9cceaf04ce5959e961a59ab91fc','a2da339ab8014bb1a0600bd20149bbbd/6dd8f9cceaf04ce5959e961a59ab91fc/',1,0,'',NULL,1,1,'',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:39:04','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:41:37','0'),('be2ececee58e4f5ba7cf13ac35a51fbe','email:template:add','添加','3',NULL,NULL,'d4272a1fac244950acc93dac7ac1c7cf',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:24:49',NULL,NULL,'0'),('be85d873590d4a10b490bf9174c707df','oss:attachment:delete','删除','3',NULL,NULL,'203aacd2a474445d8d4fb22199a7fe40',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:45:43',NULL,NULL,'0'),('bedb1eeccf294d98ba2f636365d01928',NULL,'用户管理','2','/sys/user','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,10,'',NULL,1,1,'views/sys/user/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:10:29','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:16:30','0'),('c2fa9d559e744df9971f0321e218e125','sys:user:role:list','用户角色','3','','','f3938743bdab4c64bfa99c5c9e5341e1','a2da339ab8014bb1a0600bd20149bbbd/f3938743bdab4c64bfa99c5c9e5341e1/',1,0,'',NULL,1,1,'','用户角色','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:03:49',NULL,NULL,'0'),('c5280ea2f36b44e192643c1cfd63918c','test:treeandtable:treeandtable:delete','删除','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('c782a018e34947aeae172a1fc05506a6','sys:user:role:delete','删除用户角色','3','','','bedb1eeccf294d98ba2f636365d01928','a2da339ab8014bb1a0600bd20149bbbd/bedb1eeccf294d98ba2f636365d01928/',1,0,'',NULL,1,1,'','删除用户角色','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:05:43',NULL,NULL,'0'),('c7f55a648f974247bec0dd0745be6492','test:treetable:treetable:import','导入','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,8,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('c8dacf03f6f34c1dad41bc05f85cc9e9','sms:template:add','添加','3',NULL,NULL,'5534c207669f4ba3af912622a8b5fee6',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:51:09',NULL,NULL,'0'),('c8fdf84fa0aa4372b930ba57d0277ab9','email:template:update','更新','3',NULL,NULL,'d4272a1fac244950acc93dac7ac1c7cf',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:24:49',NULL,NULL,'0'),('c97c4ff1abc5436da415047d450fdb88','test:table:table:list','查询','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:12',NULL,NULL,'0'),('cb6f769427554df58229b65ae6038544','monitor:login:log:delete','删除','3',NULL,NULL,'48663b3b2eb5457e8a79a6a105b8fb69',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:46:46',NULL,NULL,'0'),('cdf0fe2958434b40be1fff8145cba08b','sys:role:add','添加','3',NULL,NULL,'f3938743bdab4c64bfa99c5c9e5341e1',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:52:50',NULL,NULL,'0'),('d1069347e4374ddaab932656e27a2772','sys:organization:update','更新','3',NULL,NULL,'8402e9bc967144d0988386a54c912548','a2da339ab8014bb1a0600bd20149bbbd/8402e9bc967144d0988386a54c912548/',1,4,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:03:07','4028ea815a3d2a8c015a3d2f8d2a0002','2021-01-16 22:33:20','0'),('d4272a1fac244950acc93dac7ac1c7cf',NULL,'邮件模板','2','/email/template','','76fd71b67d784ed9bd02e320a387e834','76fd71b67d784ed9bd02e320a387e834/',1,0,'',NULL,1,1,'views/email/template/index',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:23:33','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:47:53','0'),('d4bc391e2d6b4d619435da7c37021212','test:twotable:carmodel:list','汽车型号查询','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:47:58','0'),('d4e076ece76e4c109c794ee354133ef3','sys:user:delete','删除','3',NULL,NULL,'bedb1eeccf294d98ba2f636365d01928',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:45:14',NULL,NULL,'0'),('d50770e755564f15a32c2b798cdbb2de','test:expandtable:expandtable:export','导出','3',NULL,NULL,'ac793681eab74d2d99e3e6d335a79826',NULL,1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-04 13:21:02',NULL,NULL,'0'),('d67f9a69cce040d0b28000e988a489c7','sys:menu:list','查询','3',NULL,NULL,'64a6cd14e86f434db5bc6bd3f947398f',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:04',NULL,NULL,'0'),('da7f94c7087b42359e34c703cd2ed30f','test:table:table:list','综合表格','2','/demo/table','','abe099fdb4144a88b6635eea23d0bd01','abe099fdb4144a88b6635eea23d0bd01/',1,1,'',NULL,1,1,'views/demo/table/tableList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-23 10:59:35','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-10 13:10:30','0'),('dce5ce1a87e3417692a8b1225d90d121','email:template:delete','删除','3',NULL,NULL,'d4272a1fac244950acc93dac7ac1c7cf',NULL,1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:24:49',NULL,NULL,'0'),('dd2b6238d3304fcf926b9e389175ad42','sys:tenant:add','添加','3',NULL,NULL,'9de6b62cb95e483c8e57392213a87f77','a2da339ab8014bb1a0600bd20149bbbd/9de6b62cb95e483c8e57392213a87f77/',1,3,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-28 06:30:20',NULL,NULL,'0'),('deca5f90b4a74a3ca243ee81a798801f','test:table:table:detail','详情','3',NULL,NULL,'da7f94c7087b42359e34c703cd2ed30f',NULL,1,6,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-25 13:23:00',NULL,NULL,'0'),('df07014114924135a875782fcaf40333','test:treetable:treetable:update','更新','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:26',NULL,NULL,'0'),('df3307b6f9884a2ea9c4aa32ec0388fa','oss:attachment:add','添加','3',NULL,NULL,'203aacd2a474445d8d4fb22199a7fe40',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 12:45:43',NULL,NULL,'0'),('e052e5772bb74b4b8791d79732677eb1','test:treeandtable:treeandtable:export','导出','3',NULL,NULL,'3eaf2534601a4eac9cda4b17c333eee3',NULL,1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-03 01:33:11',NULL,NULL,'0'),('e198425d45ba6b6e31a6db4b7763f716','sys:config:delete','删除','3',NULL,NULL,'ea3bf0ab4bd042e0be6416680f66e19c',NULL,1,4,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 04:12:46',NULL,NULL,'0'),('e49f6dfe7973326a6ed21512ee42bae0','sys:config:add','添加','3',NULL,NULL,'ea3bf0ab4bd042e0be6416680f66e19c',NULL,1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 04:12:46',NULL,NULL,'0'),('e57d4c7de46d4a12911f1c0880608fdb','sys:role:list','查询','3',NULL,NULL,'f3938743bdab4c64bfa99c5c9e5341e1',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:52:50',NULL,NULL,'0'),('e6d19f6b484e4fdb8b05ed34457fd594','monitor:user:online:list','查询','3',NULL,NULL,'653c7b79ebdf4054b3a7233ad6168d49',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 12:59:22',NULL,NULL,'0'),('e746144939314619827be86fbd3efe50','email:template:list','查询','3',NULL,NULL,'d4272a1fac244950acc93dac7ac1c7cf',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:24:49',NULL,NULL,'0'),('ea3bf0ab4bd042e0be6416680f66e19c',NULL,'系统参数','2','/sys/config','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,70,'',NULL,1,1,'views/sys/config/configList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-23 16:42:13','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:17:22','0'),('edf9c54876d8424b9ea7edb9b992a3a3','test:twotable:carmodel:delete','汽车型号删除','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,3,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:48:25','0'),('ee8e03adf46f4377b03e4f81176b9640','test:twotable:carmodel:detail','汽车型号详情','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,6,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:17:05','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:17:27','0'),('ef66722b109e4b44badded26ddc129ba','sys:user:role:add','添加用户角色','3','','','bedb1eeccf294d98ba2f636365d01928','a2da339ab8014bb1a0600bd20149bbbd/bedb1eeccf294d98ba2f636365d01928/',1,0,'',NULL,1,1,'','添加用户角色','4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 15:04:38',NULL,NULL,'0'),('ef68f37ced434f319797e3f26ef202d2','test:twotable:carmodel:update','汽车型号更新','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:36:46','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 22:48:16','0'),('efe69c7d51f140abbfc1c1e05975ecae','sms:sendlog:list','查询','3',NULL,NULL,'5a7fb16c87f745dfb3185be1e65673a5',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:52:00',NULL,NULL,'0'),('eff0c65a539846f59b2046b279833dae','test:treetable:treetable:list','查询','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,0,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:26',NULL,NULL,'0'),('f219d0b6f8144f0eab326b53f3323dd7','email:sendlog:delete','删除','3',NULL,NULL,'86f65f1677184cc5b92201bbb63618d7',NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:25:07',NULL,NULL,'0'),('f38443b4da684b7d8e81614d8180021e','test:treetable:treetable:add','添加','3',NULL,NULL,'247c9f811073431da881a8f90972e1c8',NULL,1,5,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 21:45:49',NULL,NULL,'0'),('f3938743bdab4c64bfa99c5c9e5341e1',NULL,'角色管理','2','/sys/role','','a2da339ab8014bb1a0600bd20149bbbd','a2da339ab8014bb1a0600bd20149bbbd/',1,20,'',NULL,1,1,'views/sys/role/roleList',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-30 15:11:36','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-26 21:16:45','0'),('f5ea5f1f8c1d4cf1abafd1f6c4efab69','test:twotable:car:export','导出','3',NULL,NULL,'26ab0c0a2cff4bf49079bc6ee3462f27','abe099fdb4144a88b6635eea23d0bd01/26ab0c0a2cff4bf49079bc6ee3462f27/',1,11,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-24 23:03:51','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:18:30','0'),('f6226a63129a4141adbe6805324dabdd','email:sendlog:list','查询','3',NULL,NULL,'86f65f1677184cc5b92201bbb63618d7',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-09 10:25:07',NULL,NULL,'0'),('f9b2cdabb11d429884a5465e754c4e06','sys:dict:update','更新','3',NULL,NULL,'6dd8f9cceaf04ce5959e961a59ab91fc',NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-11-06 11:53:28',NULL,NULL,'0'),('fdb08c18a73648ddb77d2558167a764a',NULL,'操作日志','2','/monitor/operationLog','','4cfdb4c51e144a34957e2a2ceca7fae9','4cfdb4c51e144a34957e2a2ceca7fae9/',1,2,'',NULL,1,1,'views/monitor/log/operation',NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:25:04','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-28 17:49:00','0'),('fedca180ec4e9822d718026cd83817f4','sys:config:list','列表','3',NULL,NULL,'ea3bf0ab4bd042e0be6416680f66e19c',NULL,1,2,NULL,NULL,1,1,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-16 04:12:46',NULL,NULL,'0');
  
  /*Table structure for table `sys_message` */
  
  DROP TABLE IF EXISTS `sys_message`;
  
  CREATE TABLE `sys_message` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `title` varchar(255) NOT NULL COMMENT '标题',
    `content` text NOT NULL COMMENT '模版内容',
    `is_read` tinyint(1) DEFAULT NULL COMMENT '是否阅读',
    `read_uid` varchar(64) DEFAULT NULL COMMENT '阅读的用户ID',
    `read_uname` varchar(250) DEFAULT NULL COMMENT '阅读的人',
    `read_date` datetime DEFAULT NULL COMMENT '阅读时间',
    `send_date` datetime DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`),
    KEY `sys_message_read_uid` (`read_uid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发送消息';
  
  /*Data for the table `sys_message` */
  
  insert  into `sys_message`(`id`,`title`,`content`,`is_read`,`read_uid`,`read_uname`,`read_date`,`send_date`,`tenant_id`) values ('34d90ff1d82c40c1b24d9598310d4174','回答了求解','<p><a href=\"/user/4028ea815a3d2a8c015a3d2f8d2a0002\" target=\"_self\" title=\"系统管理员\"><cite>系统管理员</cite></a>回答了您的求解<a href=\"/posts/3c69b5d3676e42a5ba8adbf9a3133813/detail\" target=\"_self\" title=\"dasdadasd\"><cite>dasdadasd</cite></a></p>',1,'4028ea815a3d2a8c015a3d2f8d2a0002','系统管理员',NULL,'2018-09-21 17:12:24','00000000'),('3daf4c6501354c64bc54d5dae1cc8532','回答了求解','<p><a href=\"/user/703ab3b65dd940708d191a19fb64632c\" target=\"_self\" title=\"王存见\"><cite>王存见</cite></a>回答了您的求解<a href=\"/posts/b27a9f2296b5490c92b86eceac13f692/detail\" target=\"_self\" title=\"标题标题标题标题标题标题标题标题标题标题\"><cite>标题标题标题标题标题标题标题标题标题标题</cite></a></p>',0,'703ab3b65dd940708d191a19fb64632c','王存见',NULL,'2018-09-20 11:37:39','00000000'),('67185c781b0541ad975ed740df5fdfd7','回答了求解','<p><a href=\"/user/d7bdacb99d8746548c0882417ae3abbd\" target=\"_self\" title=\"白猫\"><cite>白猫</cite></a>回答了您的求解<a href=\"/posts/b2dcc675fb5d48a88120c5900ff1a4fd/detail\" target=\"_self\" title=\"测试一个标题哈哈哈哈\"><cite>测试一个标题哈哈哈哈</cite></a></p>',1,'d7bdacb99d8746548c0882417ae3abbd','白猫',NULL,'2018-09-13 13:42:47','00000000'),('7730bb741c9341c2869dfaaf70665c06','回答了求解','<p><a href=\"/user/d7bdacb99d8746548c0882417ae3abbd\" target=\"_self\" title=\"白猫\"><cite>白猫</cite></a>回答了您的求解<a href=\"/posts/b2dcc675fb5d48a88120c5900ff1a4fd/detail\" target=\"_self\" title=\"测试一个标题哈哈哈哈\"><cite>测试一个标题哈哈哈哈</cite></a></p>',0,'d7bdacb99d8746548c0882417ae3abbd','白猫',NULL,'2018-09-13 13:52:10','00000000'),('9a311d6e471544d9b07c4d966c9b86e3','回答了求解','<p><a href=\"/user/4028ea815a3d2a8c015a3d2f8d2a0002\" target=\"_self\" title=\"系统管理员\"><cite>系统管理员</cite></a>回答了您的求解<a href=\"/posts/3c69b5d3676e42a5ba8adbf9a3133813/detail\" target=\"_self\" title=\"dasdadasd\"><cite>dasdadasd</cite></a></p>',1,'4028ea815a3d2a8c015a3d2f8d2a0002','系统管理员',NULL,'2018-09-21 17:12:36','00000000'),('9fb5dd93108340f9a8e108fa150e4dc0','回答了求解','<p><a href=\"/user/703ab3b65dd940708d191a19fb64632c\" target=\"_self\" title=\"王存见\"><cite>王存见</cite></a>回答了您的求解<a href=\"/posts/b27a9f2296b5490c92b86eceac13f692/detail\" target=\"_self\" title=\"标题标题标题标题标题标题标题标题标题标题\"><cite>标题标题标题标题标题标题标题标题标题标题</cite></a></p>',0,'703ab3b65dd940708d191a19fb64632c','王存见',NULL,'2018-09-21 17:12:05','00000000');
  
  /*Table structure for table `sys_message_template` */
  
  DROP TABLE IF EXISTS `sys_message_template`;
  
  CREATE TABLE `sys_message_template` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `name` varchar(255) NOT NULL COMMENT '模版名称',
    `code` varchar(255) NOT NULL COMMENT '模版编码',
    `template_title` varchar(255) NOT NULL COMMENT '模版标题',
    `template_content` text NOT NULL COMMENT '模版内容',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发送消息模板';
  
  /*Data for the table `sys_message_template` */
  
  insert  into `sys_message_template`(`id`,`name`,`code`,`template_title`,`template_content`,`tenant_id`) values ('980000eda2bf4644b099404cc4b8cd68','产品付款成功模板','ur780e3fjt','产品付款成功模板','&lt;p&gt;&lt;a href=&quot;/user/${uid}&quot; target=&quot;_self&quot; title=&quot;${realname}&quot;&gt;&lt;cite&gt;${realname}&lt;/cite&gt;&lt;/a&gt;在求解&lt;a href=&quot;/posts/${postsId}/detail&quot; target=&quot;_self&quot; title=&quot;${postsTitle}&quot;&gt;&lt;cite&gt;${postsTitle}&lt;/cite&gt;&lt;/a&gt;。中回复了你&lt;/p&gt;','00000000'),('c1fc105870bc4e3b8252973cc557ad75','回答了求解','iheyj2har8','回答了求解','&lt;p&gt;&lt;a href=&quot;/user/${uid}&quot; target=&quot;_self&quot; title=&quot;${realname}&quot;&gt;&lt;cite&gt;${realname}&lt;/cite&gt;&lt;/a&gt;回答了您的求解&lt;a href=&quot;/posts/${postsId}/detail&quot; target=&quot;_self&quot; title=&quot;${postsTitle}&quot;&gt;&lt;cite&gt;${postsTitle}&lt;/cite&gt;&lt;/a&gt;&lt;/p&gt;','00000000'),('f5f928d3d7354a73a73bd67e21bc54dd','回复中AT了你','yfsidsne12','回复中AT了你','&lt;p&gt;&lt;a href=&quot;/user/${uid}&quot; target=&quot;_self&quot; title=&quot;${realname}&quot;&gt;&lt;cite&gt;${realname}&lt;/cite&gt;&lt;/a&gt;在求解&lt;a href=&quot;/posts/${postsId}/detail&quot; target=&quot;_self&quot; title=&quot;${postsTitle}&quot;&gt;&lt;cite&gt;${postsTitle}&lt;/cite&gt;&lt;/a&gt;。中回复了你&lt;/p&gt;','00000000');
  
  /*Table structure for table `sys_operation_log` */
  
  DROP TABLE IF EXISTS `sys_operation_log`;
  
  CREATE TABLE `sys_operation_log` (
    `id` varchar(64) NOT NULL COMMENT '编号',
    `title` varchar(255) DEFAULT '' COMMENT '日志标题',
    `content` varchar(1000) DEFAULT '' COMMENT '日志内容',
    `log_type` varchar(10) DEFAULT '' COMMENT '操作方式',
    `create_by` varchar(32) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `request_uri` varchar(255) DEFAULT NULL COMMENT '请求URL',
    `browser` varchar(255) DEFAULT NULL COMMENT '浏览器',
    `os` varchar(100) DEFAULT NULL COMMENT '操作系统',
    `operation_ip` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
    `operation_name` varchar(255) DEFAULT NULL COMMENT '操作人',
    `method` varchar(255) DEFAULT NULL COMMENT '操作方法',
    `params` text COMMENT '数据',
    `msg` text COMMENT '异常信息',
    `status` varchar(1) DEFAULT NULL COMMENT '请求状态',
    `tenant_id` varchar(64) DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`),
    KEY `sys_log_create_by` (`create_by`),
    KEY `sys_log_request_uri` (`operation_ip`),
    KEY `sys_log_create_date` (`create_date`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日志表';
  
  /*Data for the table `sys_operation_log` */
  
  /*Table structure for table `sys_organization` */
  
  DROP TABLE IF EXISTS `sys_organization`;
  
  CREATE TABLE `sys_organization` (
    `id` varchar(64) NOT NULL,
    `name` varchar(100) DEFAULT NULL COMMENT '机构名称',
    `parent_id` varchar(32) DEFAULT NULL COMMENT '父节点',
    `parent_ids` varchar(1000) DEFAULT NULL COMMENT '父节点路径',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL COMMENT '删除标记',
    `remarks` varchar(255) DEFAULT NULL,
    `tenant_id` varchar(64) DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`),
    KEY `idx_sys_organization_parent_id` (`parent_id`),
    KEY `idx_sys_organization_parent_ids` (`parent_ids`(255))
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `sys_organization` */
  
  insert  into `sys_organization`(`id`,`name`,`parent_id`,`parent_ids`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`remarks`,`tenant_id`) values ('05fa0ccf85e2dac369445c927fed4ed9','西游网络',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-17 11:07:53',NULL,NULL,'0',NULL,'89013384'),('103c59b6e4dcdb4a00c4d128c431a3d5','飞廉','40288ab85b6080e1015b60996d690005','40288ab85b6080e1015b60996d690005/','4028ea815a3d2a8c015a3d2f8d2a0002','2020-01-25 21:26:56','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-26 23:25:41','0',NULL,'00000000'),('1469131e587ee3da82308dd0a2956dbf','大汉无忧',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-07-18 11:22:22',NULL,NULL,'0',NULL,'28648086'),('3409babe66b970ed4c841bf0ec72b887','李四的租户',NULL,NULL,'67d2d0b2a68b0178ca1aa3c3a1e0bd1c','2020-07-18 10:56:47',NULL,NULL,'0',NULL,'96192153'),('397f2b2f1f92bd4fd4ef893cee61c354','测试',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-07-21 14:30:26',NULL,NULL,'0',NULL,'01208100'),('40288ab85b6080e1015b60996d690005','山海',NULL,NULL,NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-30 22:08:30','0',NULL,'00000000'),('4ca062d0ed5803df2e4b86754c1b3e7e','张三的租户',NULL,NULL,'ff803cb98718d47127fd5291ab959a49','2020-07-18 10:52:27',NULL,NULL,'0',NULL,'82517141'),('68a207cc33fa7d89924bdb3d030e5b59','lisixu的租户',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-07-18 11:00:14',NULL,NULL,'0',NULL,'27317614'),('74c1e35673fa31b2716f296d6f45ff85','租户名称',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2020-07-18 11:15:42',NULL,NULL,'0',NULL,'31126092'),('82e352cab34c0c5d45fb048f99a1d93f','后台开发','103c59b6e4dcdb4a00c4d128c431a3d5','40288ab85b6080e1015b60996d690005/103c59b6e4dcdb4a00c4d128c431a3d5/','4028ea815a3d2a8c015a3d2f8d2a0002','2020-01-25 21:27:12',NULL,NULL,'0',NULL,'00000000'),('d269cc34a28843303a8863dde83a3d3a','山海科技',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-13 10:01:07',NULL,NULL,'0',NULL,'35798760'),('d2cae9f8eefd5c0941bf44dcb57cec5b','仓颉','40288ab85b6080e1015b60996d690005','40288ab85b6080e1015b60996d690005/','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-26 23:25:53',NULL,NULL,'0',NULL,'00000000'),('ea33ae995d2daa7f41843eeca8976c65','九州科技',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-16 09:28:50',NULL,NULL,'0',NULL,'86865558');
  
  /*Table structure for table `sys_role` */
  
  DROP TABLE IF EXISTS `sys_role`;
  
  CREATE TABLE `sys_role` (
    `id` varchar(64) NOT NULL COMMENT '编号',
    `name` varchar(100) NOT NULL COMMENT '角色名称',
    `code` varchar(255) DEFAULT NULL COMMENT '英文名称',
    `is_sys` varchar(64) DEFAULT NULL COMMENT '是否系统数据',
    `usable` varchar(64) DEFAULT NULL COMMENT '是否可用',
    `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`),
    KEY `sys_role_del_flag` (`del_flag`),
    KEY `sys_role_enname` (`code`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';
  
  /*Data for the table `sys_role` */
  
  insert  into `sys_role`(`id`,`name`,`code`,`is_sys`,`usable`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`tenant_id`) values ('0','总系统管理员','admin','1','1',NULL,'2017-02-13 15:52:53','4028ea815a3d2a8c015a3d2f8d2a0002','2018-10-31 21:32:43','总系统管理员','0','00000000'),('1','系统管理员','tenantAdmin','0','1',NULL,'2017-02-13 15:52:53','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-13 11:10:20','租户系统管理员','0','00000000'),('43b7e6d70640e2b577e1b2dbbdca1032','用户','user','1','1','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-17 07:37:14','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-27 10:34:39',NULL,'0','00000000'),('9e69dd6647d2b156afcd962473f05a58','山海角色','shanhairole','0','1','49cc47c9a5646525345621673dbc10fc','2019-12-17 10:56:41',NULL,NULL,NULL,'0','35798760');
  
  /*Table structure for table `sys_role_data_rule` */
  
  DROP TABLE IF EXISTS `sys_role_data_rule`;
  
  CREATE TABLE `sys_role_data_rule` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `data_rule_category` int(2) DEFAULT NULL COMMENT '权限类型(1:数据权限、2:接口权限)',
    `data_rule_id` varchar(64) DEFAULT NULL COMMENT '权限id',
    `role_id` varchar(64) DEFAULT NULL COMMENT '角色id',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色数据权限关联表';
  
  /*Data for the table `sys_role_data_rule` */
  
  insert  into `sys_role_data_rule`(`id`,`data_rule_category`,`data_rule_id`,`role_id`) values ('99872684208fe7fb0e7f524b6541211e',NULL,'dfc71dbeb4f8f15f9e00a945c177d2a6','0');
  
  /*Table structure for table `sys_role_menu` */
  
  DROP TABLE IF EXISTS `sys_role_menu`;
  
  CREATE TABLE `sys_role_menu` (
    `id` varchar(32) NOT NULL COMMENT '编号',
    `menu_id` varchar(32) NOT NULL COMMENT '菜单编号',
    `role_id` varchar(32) NOT NULL COMMENT '角色编号',
    PRIMARY KEY (`id`),
    KEY `sys_role_menu_menuid` (`menu_id`),
    KEY `sys_role_menu_roleid` (`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色-菜单';
  
  /*Data for the table `sys_role_menu` */
  
  insert  into `sys_role_menu`(`id`,`menu_id`,`role_id`) values ('01345e2a72b39da85cf6d1fdcbe4fe9c','936b2acedf194ed3bfc403acc4c5aa71','0'),('041173a03a01766f1d8b8dc136cc665a','e052e5772bb74b4b8791d79732677eb1','1'),('0486bd969cbf2f0e82229ec8345ce5fe','ba46b8b6d27c4f0cabea1598d15cad27','1'),('0598854951dd8b636c4727d6fc40be62','a9d4028655c945eba33546ff3df634e4','1'),('067cfaa8438eba58a3bf92ac958e64f6','d4bc391e2d6b4d619435da7c37021212','0'),('08a9839ffe995c757a939e8358701266','93669750fdad4979b658408e13675b30','0'),('08b3017eec7e79b6cb2022138a11d940','ee8e03adf46f4377b03e4f81176b9640','0'),('08ebdbb1bb15b50aa143aafcf8d2142d','a3bb826296174bb7b7bfdd0fcb2d33fc','0'),('08ee05f3b5b3eafd7f3726463dae84cb','f38443b4da684b7d8e81614d8180021e','0'),('09c61472799673e58f7cc05436d66227','ef68f37ced434f319797e3f26ef202d2','0'),('0a6f2e711c341d45aeaf4b9354a1ed1b','1c6cfbfc836f4c588375458bb0968c12','43b7e6d70640e2b577e1b2dbbdca1032'),('0c303de9a9e2d8bf21bbf38319c5376a','f5ea5f1f8c1d4cf1abafd1f6c4efab69','1'),('0c9222364402e73d1aa8af49086c8cc5','50e2814c16ac4bef821cb0af6bea1e2b','43b7e6d70640e2b577e1b2dbbdca1032'),('0d9fa81cf80107a1665b3823ad4e36c2','42cba67a7200910918ed3d6b2cf897e3','43b7e6d70640e2b577e1b2dbbdca1032'),('0e0777edf34765f2fa25746043380651','10dbd0f844d04bbcbc394dcdd6b9f258','1'),('0e29b21faf9f7ae5cfeee115ba9eee80','3864b314549e4a9cb9e540fba21852a3','43b7e6d70640e2b577e1b2dbbdca1032'),('0ee3052ad7571ca0e693d0dfe94b94a9','1307a3dd0f934efba63b2ba4b04ffd08','1'),('0fce19b4290c23e439fc44b485986148','9406154d48144fe0971880bb9d79f3a8','0'),('10007b006963346aa01e0de5d67580d4','40a71f551a18416a850063d42250e09f','1'),('103695e6c75eb54c747e5a07ea882108','2954fb967419410fb281857ec86db428','0'),('1065353e210df862f05852a3ac2759b8','c2fa9d559e744df9971f0321e218e125','1'),('1157457316122e6dc23f0aedffa8e086','b899735bed7744c2a27c5bf3c35a3e1e','1'),('1195c45048cdc60b22830d84fd84991b','608629d6bfa7461f9ca258a4393523a1','1'),('11f1bda9cdb37018ab5ec3c5ef235041','26ab0c0a2cff4bf49079bc6ee3462f27','43b7e6d70640e2b577e1b2dbbdca1032'),('12665f6a51853349b940ebfae4e0df7e','ee8e03adf46f4377b03e4f81176b9640','43b7e6d70640e2b577e1b2dbbdca1032'),('14ce8c532f38516ff2daad8e4d3f687a','1e46d1cc27f248fb880cc887639e2e4e','0'),('1553136ee7fc2a9529d14fa23f451ffc','5a7fb16c87f745dfb3185be1e65673a5','0'),('1659284717955ca1710b6302f8160fd4','40a71f551a18416a850063d42250e09f','0'),('17144a5b65e76431bda92358ade6379a','bedb1eeccf294d98ba2f636365d01928','0'),('17233aaa57dd03f07fb1cc37970789bf','91b33be150b3416d82ba38128590c507','0'),('17938bde09003ce8580b25914b2ea5da','9c59bd5de46b48a4911047bf3307ebbc','0'),('18116b1ec43e51cf3441036c0016be7e','760dd42695984c15a0db3f1e4ed0a4af','0'),('18de5ca2ab89e4136b4d4ca1af1f2ce5','f5ea5f1f8c1d4cf1abafd1f6c4efab69','43b7e6d70640e2b577e1b2dbbdca1032'),('18e702757eee639c94c37b5336e1f8f4','46ddbbabf30445e3a75ff2294e06ec50','0'),('191981fe08fe44703bb550b0b0b161ab','83aea54a484b4bc8a19259352badaceb','1'),('1a69baac5fcff95349fe5fc3512a4ae7','bb981a178102e12675e1c393e85f4fa3','0'),('1c21519f17e7c836c80553f63ab99d6f','0ce52312cd294c5a95ffec7e7abe0ef1','0'),('1cb28134912382ffb9a2dedd78585edb','76fd71b67d784ed9bd02e320a387e834','0'),('1ea4594faa52b1250e0b19913e3d001a','c2fa9d559e744df9971f0321e218e125','0'),('1eb0c408e442d48d7f51c79bf0dab5e9','1c41720eeea94e59aeb2ea84b2cd3b00','0'),('1ef135eee6ac2bfb82777f418050c917','760dd42695984c15a0db3f1e4ed0a4af','43b7e6d70640e2b577e1b2dbbdca1032'),('1f695dec006996ef59c2902e777a30b1','abc8dc302b1540f69f2a8c24a5612c2a','0'),('2031faa2cf5d07c3a8e90f930b0418d8','86fcadeb0950427b8a4819a4229bbd74','43b7e6d70640e2b577e1b2dbbdca1032'),('20600880c913ad97e99ccad0292d7788','88b25c355bdc4a7b8b8bfdb307918eb5','0'),('20e48eba737fe2584ef0db476442f391','6869b6f955594ab2a8d10b0b130120b4','0'),('22230839a600b55573cf802869a37a67','c97c4ff1abc5436da415047d450fdb88','1'),('225ea8b9bb41047ec9d30aae244f2194','9f4f6568e9a54623b52657bcc6a6f478','43b7e6d70640e2b577e1b2dbbdca1032'),('22e767b326354dbd58345546a15eaeb6','9c59bd5de46b48a4911047bf3307ebbc','1'),('247d7abbe9139e7c816c30583bdb8efe','deca5f90b4a74a3ca243ee81a798801f','43b7e6d70640e2b577e1b2dbbdca1032'),('25d598f56bde804a60945bf2a6e708bc','9f4f6568e9a54623b52657bcc6a6f478','1'),('2612b50b944e87b9e0c1c3a09f3fe335','e052e5772bb74b4b8791d79732677eb1','0'),('261b3a053722f9803d5b418b45993417','3135bcb72d324ac8aad4a42823545570','1'),('286777b17c517812864da2baa7178b60','a2da339ab8014bb1a0600bd20149bbbd','0'),('2cbeba4ebb8f5ae833cb1253dee2ea1a','fdb08c18a73648ddb77d2558167a764a','0'),('2cc460ad2ea72341eb784605ebbf6a1d','c5280ea2f36b44e192643c1cfd63918c','0'),('2f6b8911d50f6039196c0f88dbc4756f','4548f01cbbf0427e8bb47243d4a546e9','0'),('312c9db411638ff43776ddfdf786de4e','c7f55a648f974247bec0dd0745be6492','0'),('31687de4562d677dbc09ed5f65348f9b','6dd8f9cceaf04ce5959e961a59ab91fc','0'),('3230ed8e61c21ab9afeb8e0f394627da','1c6cfbfc836f4c588375458bb0968c12','1'),('32e905c455e7cf9f580c4034bd3b2881','57b666b69b554c8d80da32b0141776af','43b7e6d70640e2b577e1b2dbbdca1032'),('33f1945bd0b817a0b5cef4d52fa9d909','79059d522a11459394c23c6f29092c41','0'),('341addabe80b826c803880ec71a66ce2','10dbd0f844d04bbcbc394dcdd6b9f258','43b7e6d70640e2b577e1b2dbbdca1032'),('347aa9c48ea1abab9217b51d8ad57a25','69039de89fb94c54be70543475b995ad','0'),('34b26fa37fd5a4120624f0d962575e9a','ea3bf0ab4bd042e0be6416680f66e19c','0'),('34eb96e0c9148d78357effb82e0d3ce9','f3938743bdab4c64bfa99c5c9e5341e1','0'),('35d630d03bf10575ae80b50ba75c6ab6','c8dacf03f6f34c1dad41bc05f85cc9e9','0'),('38b0cf2e0856fc694b5cd5c1ddb2d254','d4e076ece76e4c109c794ee354133ef3','0'),('3949b6df9aceb27ed3aa9a110ca6f48e','6869b6f955594ab2a8d10b0b130120b4','43b7e6d70640e2b577e1b2dbbdca1032'),('399afad088df49c3a0de72f901452f30','8402e9bc967144d0988386a54c912548','0'),('3a1ed7686cb6897adaccb788bf60cc36','69039de89fb94c54be70543475b995ad','1'),('3ad98229b7846fab3adc61703bb10fd8','0b73fc6442d3484ebfcc0e945916a38c','0'),('3adc6b78d774a3c7f74b6e87c8edae03','c8fdf84fa0aa4372b930ba57d0277ab9','0'),('3b01469a537439d4d2254ec1efce68a3','cdf0fe2958434b40be1fff8145cba08b','0'),('3cc1ff8ee2ab14a045896802a741cdf7','be2ececee58e4f5ba7cf13ac35a51fbe','0'),('3d2d4f1bf38eb4457cf52b3dc0c9884d','f5ea5f1f8c1d4cf1abafd1f6c4efab69','0'),('3defd721fe237ab254dd0347808cd682','f9b2cdabb11d429884a5465e754c4e06','0'),('3ed0b1c5c8846b92bf65dffd9efe30a5','3eaf2534601a4eac9cda4b17c333eee3','1'),('43996aa3e00124031d093f4abf0f5534','5a92b11ad8434ff68b588767417c6b58','0'),('43a4b2e6f661b1448b0f2cdd65821749','21c83bb40edd4a9e95a2392f4ed8394a','1'),('4535eab3ec749d31927b82ee53018c0c','ae18e571ddd44dbaa0384f685b3e357a','43b7e6d70640e2b577e1b2dbbdca1032'),('45b01178de23e2e36518e8811cedf25e','d50770e755564f15a32c2b798cdbb2de','0'),('4748a1c6651b24adf87b048550b3fe86','df3307b6f9884a2ea9c4aa32ec0388fa','0'),('4836790c2463f09ab60e4d66342254f1','b8faa3f2cdc9499e814be30e218a88f5','1'),('484142aa7ed232fc361880caf419166c','3135bcb72d324ac8aad4a42823545570','43b7e6d70640e2b577e1b2dbbdca1032'),('4ac3c785e2c34f11903bf70f52b4ce9e','26ab0c0a2cff4bf49079bc6ee3462f27','1'),('4c1a1e7229d087430931bf981c0401a5','eff0c65a539846f59b2046b279833dae','43b7e6d70640e2b577e1b2dbbdca1032'),('4c3ebefeeb5d8188ce5aa8ed01f6c1ce','6869b6f955594ab2a8d10b0b130120b4','1'),('4d744bc5c8dbd2a3afb2a8883c134e8b','42cba67a7200910918ed3d6b2cf897e3','1'),('4fbc9125427506ae129b93a35b80700f','41529f653db84afaaf9ef4b16845842e','1'),('5044bdd0b8db8af457b13357b4eac292','41b543b75bcc4feca88f8b2e34c8c8c4','1'),('50822c79b87d85645b5e43e86d0678d1','be85d873590d4a10b490bf9174c707df','0'),('516c10e9558d7c8f491c1ca1d99774c0','0ce52312cd294c5a95ffec7e7abe0ef1','1'),('51b41af3a4c255374293ff1b24e0c10e','4cfdb4c51e144a34957e2a2ceca7fae9','0'),('5272ce71b62a0e8fe98c79e7cec6b299','8386bfdcf52547c1a091e71873eedfdf','0'),('52be144cd4b554773b9e02f99cd683a6','d4272a1fac244950acc93dac7ac1c7cf','0'),('53464c579b90ad09a5a267eca9ad756e','9afdab469e1f4f3fab4b242a2d5679e9','43b7e6d70640e2b577e1b2dbbdca1032'),('541a0fa086d85a73012be5455f481772','2eef0abf5d414d9589576c30b8202dcd','0'),('54e910d4cf2fad9f5a7022082fe511c1','ee8e03adf46f4377b03e4f81176b9640','1'),('56ef282e754e282a0fc5518092fe89fb','1fa22fa16d6140ffbddb5747e33e7205','0'),('57f20228b83cafb268d7ae811fdd2bbe','9f4f6568e9a54623b52657bcc6a6f478','0'),('5872d2879e9beddbc169a550f21e4407','bb2e6d8d88cb4685a33a27823dd09a30','0'),('597b4c46f9632a8ee08a67f3ff0555f0','42cba67a7200910918ed3d6b2cf897e3','0'),('59b77a4f0ce5d595dcf7e44a483a5cd0','d4bc391e2d6b4d619435da7c37021212','1'),('5adcfabe83eb305ed9af43ec14993912','41141cd290874c76968cee0ac9932f67','0'),('5b2dbc76d777d442037bcdc50aaea0db','9a42181d7301459b935871b921e1a89a','43b7e6d70640e2b577e1b2dbbdca1032'),('5d4d92771a712383f3ea1076b9ae7aa0','ef66722b109e4b44badded26ddc129ba','1'),('5e17b2d28a353502499310f418194f06','d67f9a69cce040d0b28000e988a489c7','0'),('5e36aaeccea2a14c832b61c9acd429e8','6c46f6d5f6cd4cc094cc295737c3ace6','43b7e6d70640e2b577e1b2dbbdca1032'),('5e5788a062cdcbc03c84c275862c1d43','f38443b4da684b7d8e81614d8180021e','43b7e6d70640e2b577e1b2dbbdca1032'),('603b66abd03a90c50c16b8a2e8298b1b','4870363dbd084cdc99840732a26d9c4a','43b7e6d70640e2b577e1b2dbbdca1032'),('62c9fc76f2531f49990fe2f9ecac8264','c97c4ff1abc5436da415047d450fdb88','43b7e6d70640e2b577e1b2dbbdca1032'),('6318a079006bf5d35ddec6d40dc9b2e3','c5280ea2f36b44e192643c1cfd63918c','1'),('6464f88ba1eacfff29dc5a7f72c1f081','35af237befdb46b097070599470c8eed','0'),('64813349d598cf9cb4ed1dafde7a4b3f','8b226abad44047b6aa2a164b441a3815','43b7e6d70640e2b577e1b2dbbdca1032'),('65310d8ae1f8b34e5390aeab4638edb5','c782a018e34947aeae172a1fc05506a6','0'),('65567a2ba4adbd90963eb51c4745e572','c7f55a648f974247bec0dd0745be6492','43b7e6d70640e2b577e1b2dbbdca1032'),('65d2a96cf59f0fcaa00d9b7a127d41d6','9de6b62cb95e483c8e57392213a87f77','0'),('66e2c3b0cd90aa404c1e5937b596b710','10dbd0f844d04bbcbc394dcdd6b9f258','0'),('675997b5e6ff7390abb491c498330032','86fcadeb0950427b8a4819a4229bbd74','0'),('688e58c8e565af3e44f467448cd7964e','9afdab469e1f4f3fab4b242a2d5679e9','1'),('6975853bbe5b0e2c0b3801e8f9f234a1','35850e938efe413f9ddcc7821225266b','0'),('6bd4d614895f49272047e2313ab4daec','c5280ea2f36b44e192643c1cfd63918c','43b7e6d70640e2b577e1b2dbbdca1032'),('6d103a30f6aa1290655fb58b0526df83','2821d2f3dc5042459a4b975e1cba929a','0'),('6d1b596c7593707f02326403be78acfc','4de1c247dc8d4adfa48beb27e4e5696d','0'),('6d3403793800a83df56d6a8107acc8ea','1e46d1cc27f248fb880cc887639e2e4e','1'),('6f2326c939579de54dfd5869722e3714','afa4277041cb454ab789b55d4b4b824a','1'),('71f32405594c57c13110af156a40c94e','79059d522a11459394c23c6f29092c41','1'),('7252c5241c1e9cc40a78c83faffd2936','da7f94c7087b42359e34c703cd2ed30f','1'),('739a9ad8abbea55dc891c996a3bd48bc','edf9c54876d8424b9ea7edb9b992a3a3','43b7e6d70640e2b577e1b2dbbdca1032'),('74040f6c2d68cecd515be52490b95871','e052e5772bb74b4b8791d79732677eb1','43b7e6d70640e2b577e1b2dbbdca1032'),('74aeb2df5fae457221530c14fb1fea33','70d7d2aa8c291a5013360d86ce91d954','1'),('770c8043c9ab4a10854bf01e0b7ff69c','8b226abad44047b6aa2a164b441a3815','0'),('7900c99ca77eea1cd65248c4758e3e5a','d4bc391e2d6b4d619435da7c37021212','43b7e6d70640e2b577e1b2dbbdca1032'),('7938087fda35db02acd0e28778faed04','1307a3dd0f934efba63b2ba4b04ffd08','43b7e6d70640e2b577e1b2dbbdca1032'),('795476d79f16034452ddb205578b90fe','97194b12b19248c79336a634a0ed9ac3','0'),('7a79239e2f7be08e57b9aded2d551ad6','d4e076ece76e4c109c794ee354133ef3','1'),('7ad90ee3a872471ecd2adbeac0c33aba','3135bcb72d324ac8aad4a42823545570','0'),('7bd77c019b17bd4ffcaf38309e8e91d7','f6226a63129a4141adbe6805324dabdd','0'),('7c33409e15619ee37ffb4153ae0079c0','70466fa5271d45dc99cccea0027c3dc2','0'),('80d863ef0a6d4648ce61f324ef3066c8','91fccb99710f4f2e97567653a8ef14d6','0'),('81b46f90de4aaa8a492dcb5748daef71','39883d8ee458426d8890dbc0a61dc3ac','0'),('820c46ce06ed994a3e0a7f6276331c02','4870363dbd084cdc99840732a26d9c4a','1'),('82c22c3fd96ad332de3057b14f6776e9','afa4277041cb454ab789b55d4b4b824a','0'),('83eb9b28bafa008c8cefa3521af86c8e','9fbb210970df4024bfb1e9eaaa9de6ac','0'),('8462e82b6f11fee1a9e77f43197dcca7','da7f94c7087b42359e34c703cd2ed30f','43b7e6d70640e2b577e1b2dbbdca1032'),('84870f5f29ad829e4f19b5f236966cdf','247c9f811073431da881a8f90972e1c8','43b7e6d70640e2b577e1b2dbbdca1032'),('854e0c7d601202586046879ca137a885','deca5f90b4a74a3ca243ee81a798801f','1'),('868dfa2b6638c30f14493e3e1c1265bf','da7f94c7087b42359e34c703cd2ed30f','0'),('878db1819fa2713b913eca26e285e07c','41529f653db84afaaf9ef4b16845842e','0'),('8793138ea9635c545a2d6ac956be4b8b','69039de89fb94c54be70543475b995ad','43b7e6d70640e2b577e1b2dbbdca1032'),('884144b6ad8f09e204406e2e69411633','936b2acedf194ed3bfc403acc4c5aa71','43b7e6d70640e2b577e1b2dbbdca1032'),('8a296e3911310b77581e116d5961d866','39883d8ee458426d8890dbc0a61dc3ac','1'),('8b0c9cb21b21d85ebbc627c68d33b480','c7f55a648f974247bec0dd0745be6492','1'),('8d715cecc34da0758154e25b0bfab8a1','87c10320fb46431e8e2900d45d9f6dad','0'),('9083a73f3b950b89d9b1cc551985a8c5','9c44133cf8d14addbb4b024f3515f4df','0'),('91c8f0e04f46b9c857eb435fb57af7e2','c782a018e34947aeae172a1fc05506a6','1'),('91ff5723cd1b72b23569480b4d26f604','83da63a6359e494cbbaffa678274ec19','0'),('931b206c0d13195b58e77b1283888e16','21c83bb40edd4a9e95a2392f4ed8394a','0'),('93b9950a5ecbf2caeb8aa179e734a057','247c9f811073431da881a8f90972e1c8','0'),('93ee429156c8c277bed79f2fd1498327','1386f898cb3862fb48e3a314852031e7','1'),('940acf3d3a44a71c5b0767f218f8a9b8','83aea54a484b4bc8a19259352badaceb','0'),('954cefa957d476495fd7dbd73c9ff7bd','3b980e49ec4d4d208eec8f4dd433ca6c','0'),('95e17e8b2ef1c30e4f51df7fd06ed4da','b899735bed7744c2a27c5bf3c35a3e1e','0'),('971e3128740fc48fa6d16445f33ba4b3','153c8847203a4df5bd8ff08e20fb6e3b','0'),('977ac05e164f618653fa3b0c1fe0afab','3864b314549e4a9cb9e540fba21852a3','0'),('9a9de062f76657efa5e80f3b9a49109d','46ddbbabf30445e3a75ff2294e06ec50','1'),('9afde0a5516d82fd91857560e7000310','39883d8ee458426d8890dbc0a61dc3ac','43b7e6d70640e2b577e1b2dbbdca1032'),('9c36cfe469d21975b0ecbe20738951a2','6e36c83436e34bfbb316058453e3205f','0'),('9cb287143ebd041f3b46cc4cb6e02296','3eaf2534601a4eac9cda4b17c333eee3','0'),('9d58a88fefa82e240b6902a1e7a642f9','d1069347e4374ddaab932656e27a2772','0'),('9d5c7fa2fc6e545694a53db22a3f1eda','deca5f90b4a74a3ca243ee81a798801f','0'),('9e69d764462d057640f7bba4dd34837b','57b666b69b554c8d80da32b0141776af','0'),('9f35b5e09819fd4f14e4bcd954dcce96','650fa5a8ccd04deeb656321311410606','0'),('a0012ea4ad0456a72723e584889e5a36','653c7b79ebdf4054b3a7233ad6168d49','0'),('a28bebe62ab86e131b591d5c7d31e85d','df07014114924135a875782fcaf40333','1'),('a29d02886a697ef3d25d36f15041d3b7','b338552c1eee4313b1a21a880df97e81','1'),('a2b078354b44e04a1d57b2656a35d26b','a9d4028655c945eba33546ff3df634e4','43b7e6d70640e2b577e1b2dbbdca1032'),('a319a01becfab8e9ce77c899d0767855','56e87bb7ee424e6999b27cb2a4cbc96d','1'),('a3420b460c9736b616313173491f3d92','3864b314549e4a9cb9e540fba21852a3','1'),('a39340b407cbfc59d4c66abdb5a2cdc0','64a6cd14e86f434db5bc6bd3f947398f','0'),('a3b766e31b213e19d910266a8f1315ac','a9d4028655c945eba33546ff3df634e4','0'),('a443b96a155870fcba59958ed049327d','f219d0b6f8144f0eab326b53f3323dd7','0'),('a47ee083b0a8c6f07d999ba20e2b9e6c','ac793681eab74d2d99e3e6d335a79826','43b7e6d70640e2b577e1b2dbbdca1032'),('a51652360d6272ad093d88f607a4c76b','ba46b8b6d27c4f0cabea1598d15cad27','43b7e6d70640e2b577e1b2dbbdca1032'),('a6db650208c09b6abb799f1416a8ae69','760dd42695984c15a0db3f1e4ed0a4af','1'),('a6efd05407244c92987659babf79b811','27b5cf637a964a4a97b716739056c8e4','0'),('a9e8fb5e16b1cd3b8b71ee1d5433f6db','8a13a95a71b948208d31acb590112440','0'),('ab92ae28f31179df896002c5e85456b6','498016d4913446deb6415785befd3480','0'),('abc32cd8f61bc18a1a461dee7f9630a5','86f65f1677184cc5b92201bbb63618d7','0'),('ac14c4911b1450e5188068e1753e90f8','edf9c54876d8424b9ea7edb9b992a3a3','0'),('acb1b5a49eb5431b0e8f907656aaeb74','abe099fdb4144a88b6635eea23d0bd01','43b7e6d70640e2b577e1b2dbbdca1032'),('ad4bf6d5b754dd7e973926f52bb1e945','48663b3b2eb5457e8a79a6a105b8fb69','0'),('ad5461acce6e7c0fbfafe568fdde45ff','afa4277041cb454ab789b55d4b4b824a','43b7e6d70640e2b577e1b2dbbdca1032'),('ae58b9b38cc4f507208002f3e7389443','fedca180ec4e9822d718026cd83817f4','0'),('ae77d607129f5dbdb0a7fcb91fbc0ec5','e198425d45ba6b6e31a6db4b7763f716','0'),('af69519ff8309e6954d2a3ecb3e1ab0d','b0da410e900944aa84d3ad2a170ec006','0'),('b2b43623623a694e69a8fdad24825e15','ae18e571ddd44dbaa0384f685b3e357a','0'),('b55d223a507de8d404fabd0060a2a7a1','38edc1e2843d411b99a05b721a2f778a','0'),('b752fa9c885214dd2ec9cc9011c96704','b8faa3f2cdc9499e814be30e218a88f5','0'),('b824db6602f58a91284534a7dc45065c','57b666b69b554c8d80da32b0141776af','1'),('b894996acf8678b72e8b382db120658f','bc3c57bb7d954de7a64956e6df718fe2','0'),('b8dea1a3e6b2f0be89779190ad824f4b','7230458979a149d48ff88544ce985809','0'),('ba0e52306f937bf83eec49263dc659df','e6d19f6b484e4fdb8b05ed34457fd594','0'),('ba71a9d04bb7cde5e48190c3f08b879f','ef66722b109e4b44badded26ddc129ba','0'),('bab922102b74e73b3994f8f5538f618f','abe099fdb4144a88b6635eea23d0bd01','0'),('bb5c697319752c0772e2899c95fe5dc8','56e87bb7ee424e6999b27cb2a4cbc96d','0'),('bb7b50094eb03fc0b18a00530e5fb8e1','e57d4c7de46d4a12911f1c0880608fdb','0'),('bca317aff309ca4f2703e302d470db10','8b226abad44047b6aa2a164b441a3815','1'),('bd58565f2eea7b5e1c3e55e302dddf47','1386f898cb3862fb48e3a314852031e7','0'),('bdd4ea0bdb0acb8359a3171a32a63b1f','49e01ae88046460484d262d47fa30719','0'),('be0f48b4ee8841db3a72922677526413','e49f6dfe7973326a6ed21512ee42bae0','0'),('bef2ca68d7bbd935781b7878cb50ccac','a3bb826296174bb7b7bfdd0fcb2d33fc','1'),('bfa428099a71faca8fa3592e8be6adcb','bb2e6d8d88cb4685a33a27823dd09a30','43b7e6d70640e2b577e1b2dbbdca1032'),('bfb2a66c014d733efcb89aeb25932a34','467202a879c0455d948185ad52ee871b','0'),('c0d2e8352e8891eb83d08a5863abde81','f38443b4da684b7d8e81614d8180021e','1'),('c10e252cd91a7ed95a724929a1fd5909','86fcadeb0950427b8a4819a4229bbd74','1'),('c1f732e74c241aa94f0e8f96f99f1aa9','df07014114924135a875782fcaf40333','43b7e6d70640e2b577e1b2dbbdca1032'),('c2cb81172f16a24cdbb02cf5ae4f8126','df07014114924135a875782fcaf40333','0'),('c2f5d6706f72f57582731a87baea3629','e746144939314619827be86fbd3efe50','0'),('c325bf01fca8b415962d78a15b99b305','9afdab469e1f4f3fab4b242a2d5679e9','0'),('c4929b0a007d5f746f767a74adf60612','6c46f6d5f6cd4cc094cc295737c3ace6','1'),('c5528d09fc7e493a6e8f199107e8d92c','7811944f996a441e9b3a761b18cb88bf','1'),('c68ba828d4d094da470d6d57a271f5b9','4b96d6bd8bf542ca888cdb64b1006c69','0'),('c699cc39f711e9a173b037c411ed72eb','4870363dbd084cdc99840732a26d9c4a','0'),('c70098e6f1706def27ef7fb02da77194','9a42181d7301459b935871b921e1a89a','1'),('c70562fb0d4641a590b27e177da57ddf','699fbeee7c914b619485f259f83a2e6d','0'),('c720c2f377a31bbd550bdb4e24ae9323','1c6cfbfc836f4c588375458bb0968c12','0'),('c7c720c70daa1c60730f2e47bfe60cea','6c46f6d5f6cd4cc094cc295737c3ace6','0'),('c8903e94fe403cacd5fe65b01ddc7c98','8402e9bc967144d0988386a54c912548','1'),('cb0452fb555ccb9fe03d4f510f1eb329','5534c207669f4ba3af912622a8b5fee6','0'),('ccfe02bb44e64d559db7f6f1ea04ac99','3f4c3063841641319d95412352db5a35','0'),('cd27dfc82d20c1d309d95e1b6c252ff0','b899735bed7744c2a27c5bf3c35a3e1e','43b7e6d70640e2b577e1b2dbbdca1032'),('ce0770fa6b6a08121e9f114ecb75fb56','ef68f37ced434f319797e3f26ef202d2','43b7e6d70640e2b577e1b2dbbdca1032'),('ce48db9c9c4c380f1a860bf48b1222cd','3eaf2534601a4eac9cda4b17c333eee3','43b7e6d70640e2b577e1b2dbbdca1032'),('cf5d29806bfed6ad0d0924be3b445ba3','779d64b7717c4f3a99fc96ed7ccd075d','0'),('d1e265bb36905d0d23868622f5fa7c9d','b8faa3f2cdc9499e814be30e218a88f5','43b7e6d70640e2b577e1b2dbbdca1032'),('d1e4a8e25e3affe8afd404e707eea686','9a42181d7301459b935871b921e1a89a','0'),('d2256f70368d17339ef9fc672e2afef7','edf9c54876d8424b9ea7edb9b992a3a3','1'),('d278d413e494283582ed93f36d49fc26','c97c4ff1abc5436da415047d450fdb88','0'),('d3b4d3ea7e9969e81a89a21aa6865c82','008c004de43a4ebab36deb9b9a11a790','0'),('d3d8b43bac130b7ce20b1940e217c272','5b85cfebd56141d1a100102727395556','43b7e6d70640e2b577e1b2dbbdca1032'),('d506279c0644441f4594fe81165f5fd9','9f8897e23c5b4c4e924ec983404834a6','0'),('d559542dbd4a091ab221dc7730eff783','e57d4c7de46d4a12911f1c0880608fdb','1'),('d6f0dd30e24beac4fbf76284e29b9f1b','d1069347e4374ddaab932656e27a2772','1'),('d70116507a9111d985fa2055235409e1','dd2b6238d3304fcf926b9e389175ad42','0'),('d81f4fb5cdefc9a9bf9d55039a96aee5','56e87bb7ee424e6999b27cb2a4cbc96d','43b7e6d70640e2b577e1b2dbbdca1032'),('d917784ed9c4396198243ca27b82d611','21c83bb40edd4a9e95a2392f4ed8394a','43b7e6d70640e2b577e1b2dbbdca1032'),('d94451ba204ba71c0af8c4853b30fadc','efe69c7d51f140abbfc1c1e05975ecae','0'),('d9ae539e5560c782a09f9b23b78cf776','b338552c1eee4313b1a21a880df97e81','0'),('daf370810e8742d18d8ca3646b088b6d','4ee35f7f1db2420e82f8ce6833ba885e','0'),('dbe92a5047d43c923bc33fd50f0eddb2','41b543b75bcc4feca88f8b2e34c8c8c4','43b7e6d70640e2b577e1b2dbbdca1032'),('dc63ae8f1b2aea2ae5d730c3f9d40709','86d49f3cd426463080e0ac13bdfbc28d','1'),('dc676dffe1a25cd7a613ecc33ec6fd23','7811944f996a441e9b3a761b18cb88bf','0'),('dc8312c65ffbda1a087db9765d370e38','26ab0c0a2cff4bf49079bc6ee3462f27','0'),('dcaa8502304a1a75b8ecab8efe32410a','bb2e6d8d88cb4685a33a27823dd09a30','1'),('dd6f9622b5405b6df393c0fd64bbb118','cb6f769427554df58229b65ae6038544','0'),('ddd3ea01ebd56089d533394ae379be5d','7811944f996a441e9b3a761b18cb88bf','43b7e6d70640e2b577e1b2dbbdca1032'),('e050cd95ce9ccb9402f982e4bd479ac3','eff0c65a539846f59b2046b279833dae','0'),('e06228f97d419c59e2dc9c8cbe772ff9','1307a3dd0f934efba63b2ba4b04ffd08','0'),('e3067d0f9a6293b36672a00e7a465562','70d7d2aa8c291a5013360d86ce91d954','0'),('e3e0af82537f1a3ebe21aa88ad950b05','ac793681eab74d2d99e3e6d335a79826','0'),('e4f5e55001f4f0bf809e347a2953141a','203aacd2a474445d8d4fb22199a7fe40','0'),('e529c31d30d1a2239a5e70612a7fe2d0','83da63a6359e494cbbaffa678274ec19','1'),('e5bfcfc8863b2a699cbf835670edf2b5','608629d6bfa7461f9ca258a4393523a1','0'),('e6366504d74ec8acc26d12f70abfb140','ba46b8b6d27c4f0cabea1598d15cad27','0'),('e667424da632818e740821a2e0264cd4','ef68f37ced434f319797e3f26ef202d2','1'),('e9720b5d7a5de2abaa1b44278f42d5d0','ac793681eab74d2d99e3e6d335a79826','1'),('ec1fe6f7f5f3080e0619a3eab9507cba','55c0e037734a4f4d803e881cd7204692','0'),('ed955662a854e45bb0300281f9469353','86d49f3cd426463080e0ac13bdfbc28d','0'),('ee0f1eeb5d860be5c3e105832a3b6cbd','41b543b75bcc4feca88f8b2e34c8c8c4','0'),('f00156e36f7ac7e047dc7b05b6006a34','46ddbbabf30445e3a75ff2294e06ec50','43b7e6d70640e2b577e1b2dbbdca1032'),('f55d9c49abab10392806851e323bb016','d50770e755564f15a32c2b798cdbb2de','1'),('f587258ecd41a9e99397f48c75e8c021','abe099fdb4144a88b6635eea23d0bd01','1'),('f7b4161c2e6911b72f3d79fda8d3523e','5b85cfebd56141d1a100102727395556','0'),('f7b97f608f71d4e83bdee2687bb47d1c','dce5ce1a87e3417692a8b1225d90d121','0'),('f8062890a204e4a7467787176feb5630','50e2814c16ac4bef821cb0af6bea1e2b','0'),('f8280edb7787c50bf72df5ba627ef807','936b2acedf194ed3bfc403acc4c5aa71','1'),('f99d9c738d931cd92a03c44cb0e12ab2','d50770e755564f15a32c2b798cdbb2de','43b7e6d70640e2b577e1b2dbbdca1032'),('fb7b48beb517a6fa6acb2133a84f6246','13dbeacf57934abe970497ed34ea6e59','0'),('fc67d74f11c05e1a41a55a365408bfb9','9c59bd5de46b48a4911047bf3307ebbc','43b7e6d70640e2b577e1b2dbbdca1032'),('fc881f186848d3d62e9ae92d1ab6aff3','bedb1eeccf294d98ba2f636365d01928','1'),('fcc45207c2215e4209bb8a8bf3296d78','eff0c65a539846f59b2046b279833dae','1'),('fd8e54ec9e9e0725effe433039a8ad9e','50e2814c16ac4bef821cb0af6bea1e2b','1'),('fdb8dc68f42b53bf07e9d1b6928f0ba9','5b85cfebd56141d1a100102727395556','1'),('fdd24f364a364839c51d4f3e4bcdf093','4d559f775fb94b20b87c22c6643b3180','0'),('ff0c6d15e0f9b3d929280566bf8ba9b2','247c9f811073431da881a8f90972e1c8','1');
  
  /*Table structure for table `sys_sessions` */
  
  DROP TABLE IF EXISTS `sys_sessions`;
  
  CREATE TABLE `sys_sessions` (
    `id` varchar(200) NOT NULL DEFAULT '',
    `session` varchar(2000) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `sys_sessions` */
  
  /*Table structure for table `sys_tenant` */
  
  DROP TABLE IF EXISTS `sys_tenant`;
  
  CREATE TABLE `sys_tenant` (
    `id` varchar(64) DEFAULT NULL COMMENT 'id主键',
    `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建日期',
    `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新日期',
    `del_flag` char(1) DEFAULT NULL COMMENT '删除标识',
    `remarks` text COMMENT '备注',
    `tenant_id` varchar(64) DEFAULT NULL COMMENT '租户标识',
    `contact` varchar(64) NOT NULL COMMENT '联系人',
    `phone` varchar(64) NOT NULL COMMENT '电话',
    `name` varchar(64) NOT NULL COMMENT '租户名称',
    `user_id` varchar(64) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='租户管理';
  
  /*Data for the table `sys_tenant` */
  
  insert  into `sys_tenant`(`id`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`remarks`,`tenant_id`,`contact`,`phone`,`name`,`user_id`) values ('487396777bf30416ee1ff5c22543512f','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-29 14:43:01','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-26 22:46:44','0',NULL,'00000000','boss','13111111111','山海科技','4028ea815a3d2a8c015a3d2f8d2a0002'),('01a16c43838c176f59a8d152a071bff0','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-16 09:28:50',NULL,NULL,'0',NULL,'86865558','boss2','13311111111','九州科技','44452a3f185f8fc03b63c75c5ba59fd9'),('833590525a5386670b8396bc94b06b6c','4028ea815a3d2a8c015a3d2f8d2a0002','2019-12-17 11:08:08','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-26 18:41:37','0',NULL,'89013384','boss3','13311111111','西游网络','126657d9b6648cbd188cee3cbf713981');
  
  /*Table structure for table `sys_user` */
  
  DROP TABLE IF EXISTS `sys_user`;
  
  CREATE TABLE `sys_user` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `realname` varchar(255) NOT NULL COMMENT '真实名称',
    `username` varchar(100) NOT NULL COMMENT '用户名',
    `portrait` varchar(250) DEFAULT NULL COMMENT '头像',
    `password` varchar(100) DEFAULT NULL COMMENT '密码',
    `salt` varchar(100) DEFAULT NULL,
    `email` varchar(64) DEFAULT NULL COMMENT '邮件',
    `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
    `status` tinyint(4) DEFAULT NULL COMMENT '系统用户的状态',
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `create_by` varchar(32) DEFAULT NULL,
    `organization_id` varchar(64) DEFAULT NULL COMMENT '所属组织ID',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `sys_user` */
  
  insert  into `sys_user`(`id`,`realname`,`username`,`portrait`,`password`,`salt`,`email`,`phone`,`status`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`create_by`,`organization_id`,`tenant_id`) values ('126657d9b6648cbd188cee3cbf713981','西游网络','xiyounet',NULL,'a0c4df50efa380ea505cbeb2d542a8b8','acf600b7bc8d04513b8dbe175a2172af',NULL,'13311111111',1,NULL,NULL,NULL,NULL,'0',NULL,'05fa0ccf85e2dac369445c927fed4ed9','89013384'),('13e929eff9596c22361e10e33e0b8234','白泽','baize',NULL,'e25d7cddfc97d702c395048440c4a679','acf600b7bc8d04513b8dbe175a2172af',NULL,'13211111111',1,NULL,NULL,NULL,NULL,NULL,NULL,'103c59b6e4dcdb4a00c4d128c431a3d5','00000000'),('4028ea815a3d2a8c015a3d2f8d2a0002','系统管理员','admin',NULL,'e25d7cddfc97d702c395048440c4a679','acf600b7bc8d04513b8dbe175a2172af','wind@sunseagear.com','13111111111',1,'2019-04-16 01:08:19','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-22 17:16:28',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002','40288ab85b6080e1015b60996d690005','00000000'),('44452a3f185f8fc03b63c75c5ba59fd9','九州科技','jiuzhoutech',NULL,'3107f38e4597fe316ed621994bd3c807','acf600b7bc8d04513b8dbe175a2172af',NULL,'13311111111',1,NULL,NULL,NULL,NULL,'0',NULL,'ea33ae995d2daa7f41843eeca8976c65','86865558'),('c91a986a797a8b69d6e13e94e2c78740','帝江(hong)','dihong',NULL,'45ab3cf06ef22078d03da623c6abdd98','8757269b239fc7bb838c2a4452817f90',NULL,'13311111111',1,NULL,NULL,NULL,NULL,NULL,NULL,'d2cae9f8eefd5c0941bf44dcb57cec5b','00000000');
  
  /*Table structure for table `sys_user_role` */
  
  DROP TABLE IF EXISTS `sys_user_role`;
  
  CREATE TABLE `sys_user_role` (
    `id` varchar(32) NOT NULL COMMENT '编号',
    `user_id` varchar(32) NOT NULL COMMENT '用户编号',
    `role_id` varchar(32) NOT NULL COMMENT '角色编号',
    PRIMARY KEY (`id`),
    KEY `sys_user_role_userid` (`user_id`),
    KEY `sys_user_role_roleid` (`role_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户-角色';
  
  /*Data for the table `sys_user_role` */
  
  insert  into `sys_user_role`(`id`,`user_id`,`role_id`) values ('43cdc2781bc2154e763d64ef6078a60b','126657d9b6648cbd188cee3cbf713981','1'),('4cfd06e6076906f56242635e7cad08b7','06ae39cd8ce42744a576a4204bc425a7','1'),('59c47b010a09e4bd13b0d21992b994ea','c91a986a797a8b69d6e13e94e2c78740','1'),('5f7e5539f6b121438ce7dd9fbbfb556f','13e929eff9596c22361e10e33e0b8234','43b7e6d70640e2b577e1b2dbbdca1032'),('631ab068d69087911f4a6580ddbfab9d','3004b806c27b51184c91511972084186','1'),('677685d49d6494a79506ca844ff1baf5','4b2adf2831b85914e1310fd7d401a5af','1'),('74b68ec1366bfcb15c6cab1930b31d6f','bb84e7d458644f9f81e9df4eecc39bd0','0'),('773d63b1c99449bd85fac6c270b8bd16','4028ea815a3d2a8c015a3d2f8d2a0002','0'),('773d63b1c99449bd85fac6c270b8bd17','49cc47c9a5646525345621673dbc10fc','1'),('830ccedbb6ad763786d5591959a856f0','67d2d0b2a68b0178ca1aa3c3a1e0bd1c','0'),('8b1ebdd4266c98c9de87eb32250227be','ff803cb98718d47127fd5291ab959a49','0'),('a02c11310bd0fc2279822c167037ab4c','0769017c87b1179733fac705461146ae','1'),('b27d65f47b24ab6607f555026fbb6b2b','1503ad286f471b361ba6b716fcc67307','1'),('ca8279b1958e8284cf482ef1c105d5e5','7fe6dc45fd62bc40ad188267c9408da0','1'),('d5b38ea853808238e57d8d0ba2062caa','bf5a446c42964ad6a42b2bbb04604190','0'),('e19d2e05ba915f9ce597712709d79b52','44452a3f185f8fc03b63c75c5ba59fd9','1'),('eb9201d6b80638c1c575a4ebb50f7707','092b7c63dfdd903132858bd100bb02c5','0'),('ec2845d96816743e5ad7fa1177250c87','5a4addc3d1a960d1246b24b84c7527ee','1'),('fcf58093ee0ee15be9fb1e0052c7bb51','7d4aaac7b5500ed65514228cfd090db5','1');
  
  /*Table structure for table `task_schedule_job` */
  
  DROP TABLE IF EXISTS `task_schedule_job`;
  
  CREATE TABLE `task_schedule_job` (
    `id` varchar(32) NOT NULL,
    `cron_expression` varchar(255) NOT NULL COMMENT 'cron表达式',
    `method_name` varchar(255) NOT NULL COMMENT '任务调用的方法名',
    `method_params` varchar(255) DEFAULT NULL COMMENT '请求参数',
    `misfire_policy` varchar(4) DEFAULT NULL COMMENT '执行策略',
    `is_concurrent` varchar(255) DEFAULT NULL COMMENT '任务是否有状态',
    `description` varchar(255) DEFAULT NULL COMMENT '任务描述',
    `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
    `create_date` datetime DEFAULT NULL COMMENT '创建时间',
    `job_status` varchar(255) DEFAULT NULL COMMENT '任务状态',
    `job_group` varchar(255) DEFAULT NULL COMMENT '任务分组',
    `update_date` datetime DEFAULT NULL COMMENT '更新时间',
    `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
    `execute_class` varchar(255) DEFAULT NULL COMMENT 'Spring bean',
    `job_name` varchar(255) DEFAULT NULL COMMENT '任务名',
    `load_way` varchar(1) DEFAULT NULL COMMENT '加载任务方式',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `task_schedule_job` */
  
  insert  into `task_schedule_job`(`id`,`cron_expression`,`method_name`,`method_params`,`misfire_policy`,`is_concurrent`,`description`,`update_by`,`create_date`,`job_status`,`job_group`,`update_date`,`create_by`,`execute_class`,`job_name`,`load_way`) values ('4ff760aa5e1042158f760fc41a225691','0/10 * * * * ?','run','','3','0','测试任务',NULL,NULL,'0','sys',NULL,NULL,'smsTask','短信修复发送定时任务','1'),('9d3449fe77f395da4e832a366d8c5e20','0 0 0 * * ?','run','','','1','',NULL,NULL,'1','system',NULL,NULL,'logTask','日志清除','1'),('b57316ae58234829b5602687180dfa28','0/10 * * * * ?','run','',NULL,'0','',NULL,NULL,'0','sys',NULL,NULL,'emailTask','邮件修复发送定时任务','1');
  
  /*Table structure for table `task_schedule_job_log` */
  
  DROP TABLE IF EXISTS `task_schedule_job_log`;
  
  CREATE TABLE `task_schedule_job_log` (
    `id` varchar(32) NOT NULL COMMENT '任务日志ID',
    `job_name` varchar(64) NOT NULL COMMENT '任务名称',
    `job_group` varchar(64) NOT NULL COMMENT '任务组名',
    `execute_class` varchar(500) DEFAULT NULL,
    `method_name` varchar(500) DEFAULT NULL COMMENT '任务方法',
    `method_params` varchar(200) DEFAULT '' COMMENT '方法参数',
    `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
    `status` char(2) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
    `exception_info` text COMMENT '异常信息',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务调度日志表';
  
  /*Data for the table `task_schedule_job_log` */
  
  insert  into `task_schedule_job_log`(`id`,`job_name`,`job_group`,`execute_class`,`method_name`,`method_params`,`job_message`,`status`,`exception_info`,`create_time`) values ('0029efe73c349f151bd98c4e8285ed09','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-25 08:00:00'),('0156f963a01ec5925dd6292e23b267c2','日志清除','system','logTask','run','','日志清除 总共耗时：811毫秒','1',NULL,'2020-08-02 08:00:01'),('0313556d7c149702709e95fd72120a20','日志清除','system','logTask','run','','日志清除 总共耗时：457毫秒','1',NULL,'2020-07-18 08:00:01'),('049fb5ce35c81d0e2768da54009b68f9','日志清除','system','logTask','run','','日志清除 总共耗时：479毫秒','1',NULL,'2020-08-06 08:00:01'),('0d303febea2d4ea9ed026e46d5ff4b86','日志清除','system','logTask','run','','日志清除 总共耗时：534毫秒','1',NULL,'2020-09-12 08:00:01'),('0dec6eff7d9159d44eebdde8b9eed0a9','日志清除','system','logTask','run','','日志清除 总共耗时：611毫秒','1',NULL,'2020-07-21 08:00:01'),('0ea14b7f8ec020eaf846dc4ec235e61c','日志清除','system','logTask','run','','日志清除 总共耗时：381毫秒','1',NULL,'2020-07-23 08:00:01'),('0eb21c570a65d81658b913d05051a8b2','日志清除','system','logTask','run','','日志清除 总共耗时：684毫秒','1',NULL,'2020-08-17 08:00:01'),('118d5f4cee35e36a954efbe44a2d1764','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-20 08:00:00'),('14a267674d82ba17de78899c9bd15867','日志清除','system','logTask','run','','日志清除 总共耗时：621毫秒','1',NULL,'2020-09-14 08:00:01'),('168001a17cc95189d27092d5e3f9685e','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-18 08:00:00'),('173e53e17eb74ca9ba0706738ede3646','日志清除','system','logTask','run','','日志清除 总共耗时：1548毫秒','-1',NULL,'2020-05-24 00:39:50'),('17407788a901c8e194d5584c0e260b05','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-02 08:00:00'),('18d1e423967047610b227a6d53c0b033','日志清除','system','logTask','run','','日志清除 总共耗时：1636毫秒','1',NULL,'2020-08-30 08:00:02'),('1a1a9da6dccf7626e8a18349beeb20c3','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-16 08:00:00'),('1a98befc18cf5c7aeadc748fc3729cee','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-23 08:00:00'),('1cc8435848d73aea76c29f012f0098bf','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-11 08:00:00'),('2214e528771917ca1b35ba6bef96b717','日志清除','system','logTask','run','','日志清除 总共耗时：930毫秒','1',NULL,'2020-07-24 08:00:01'),('230735755d6cdf98fca603c6e8392b05','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-05-26 00:00:00'),('27856524e95159d420a04584f26caf3a','日志清除','system','logTask','run','','日志清除 总共耗时：577毫秒','1',NULL,'2020-07-23 00:00:01'),('288ee7a632d3bffb3269b9866f01a715','日志清除','system','logTask','run','','日志清除 总共耗时：716毫秒','1',NULL,'2020-08-13 08:00:01'),('289ff84b53428482d5c7becc8ba13d8f','日志清除','system','logTask','run','','日志清除 总共耗时：333毫秒','1',NULL,'2020-08-03 08:00:00'),('2972a080cc0e577c8e5a84bfc0e29d15','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-04 08:00:01'),('2badef95adb28a44073c47687cfd005e','日志清除','system','logTask','run','','日志清除 总共耗时：871毫秒','-1',NULL,'2020-07-22 08:00:01'),('2c4fc026d2ed984a0bc15d2a6a17a658','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-05 08:00:00'),('2cde76f576e75aef2f813b0c9bd0e541','日志清除','system','logTask','run','','日志清除 总共耗时：344毫秒','1',NULL,'2020-08-10 08:00:00'),('2dc17338186f9ac97761b09ccd0e99e1','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-10 08:00:01'),('2e2db2c7c9900760306115e9a5ef15a8','日志清除','system','logTask','run','','日志清除 总共耗时：460毫秒','1',NULL,'2020-08-25 08:00:01'),('31c00038754c0512886ba722f40ec0ad','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-06 08:00:00'),('335629d6fc4b3455dd5146e96cc7e179','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-16 08:00:00'),('337b8759f7d6b1657245db0566e8bad4','日志清除','system','logTask','run','','日志清除 总共耗时：566毫秒','1',NULL,'2020-12-15 00:00:01'),('33f0ddbe745ce36cabf55cde4ecf189f','日志清除','system','logTask','run','','日志清除 总共耗时：302毫秒','1',NULL,'2020-08-22 08:00:00'),('34f7c71c973ec594c33ddc3bcb8b8735','日志清除','system','logTask','run','','日志清除 总共耗时：1242毫秒','1',NULL,'2020-09-01 08:00:01'),('3b5857c0c3635c73efce82603256e005','日志清除','system','logTask','run','','日志清除 总共耗时：2276毫秒','1',NULL,'2020-08-31 08:00:02'),('3c42bee3f8a1c090c06f28442ea78ebe','日志清除','system','logTask','run','','日志清除 总共耗时：560毫秒','1',NULL,'2020-08-27 08:00:01'),('3caa7d5c372818e9f924c9520fbc8553','日志清除','system','logTask','run','','日志清除 总共耗时：823毫秒','1',NULL,'2020-09-04 08:00:01'),('3e601a2a7dfc54797d23b1883bdaef90','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-09 08:00:00'),('3ffd64d38b57991b5e15326b2e271e2c','日志清除','system','logTask','run','','日志清除 总共耗时：345毫秒','1',NULL,'2020-08-12 08:00:00'),('41474b356ebc65a93e23c583d2beaf9f','日志清除','system','logTask','run','','日志清除 总共耗时：729毫秒','1',NULL,'2020-08-11 08:00:01'),('41b0a078ca4d1eb9746f14c9b8b5549f','日志清除','system','logTask','run','','日志清除 总共耗时：1154毫秒','1',NULL,'2020-05-26 00:00:01'),('4239bdb95e554043f5173abf0854c817','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-07 08:00:00'),('45905b4033515297347c6498024443e9','日志清除','system','logTask','run','','日志清除 总共耗时：572毫秒','1',NULL,'2020-08-28 08:00:01'),('49db66887cb4dbb066a729dbb5fd3857','日志清除','system','logTask','run','','日志清除 总共耗时：652毫秒','1',NULL,'2020-08-29 08:00:01'),('4a3e4d5bf8772cdc3e3ebc76220a867e','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-31 08:00:01'),('4c18863748f20f8f42d8a02c21e694b6','日志清除','system','logTask','run','','日志清除 总共耗时：406毫秒','1',NULL,'2020-09-03 08:00:00'),('4c7380e0658b2033c81853ead70d35f8','日志清除','system','logTask','run','','日志清除 总共耗时：359毫秒','1',NULL,'2020-09-11 08:00:00'),('4e089ec841dc0fb26a6cfc66d420b924','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-09 08:00:00'),('4e83ab209e4efe62200ff4fda99c51a3','日志清除','system','logTask','run','','日志清除 总共耗时：584毫秒','1',NULL,'2020-08-14 08:00:01'),('4eea1a4016b07ae205a00d70954d6973','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-07 08:00:00'),('51988b247e4b5048910c7a2b41d87474','日志清除','system','logTask','run','','日志清除 总共耗时：329毫秒','1',NULL,'2020-08-24 08:00:00'),('53a1c3f7913bfcc7ffa91666cba5252b','日志清除','system','logTask','run','','日志清除 总共耗时：1014毫秒','1',NULL,'2020-07-18 00:00:01'),('54c5ded961dac4f74539cd6fbd644e08','日志清除','system','logTask','run','','日志清除 总共耗时：680毫秒','1',NULL,'2020-08-21 08:00:01'),('58116920b7566f44239fc441cf6839f0','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-19 08:00:00'),('5c3b44456b1143c41e44a601f8532249','日志清除','system','logTask','run','','日志清除 总共耗时：923毫秒','1',NULL,'2020-05-30 00:00:57'),('5cb3b1d5ae892c95fb3ba7614d2b762a','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-01 08:00:00'),('5e2c7f7326e8362309dcb904da9fc15f','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-29 08:00:00'),('5e799e986e5c72ea70bb61a3b0129990','日志清除','system','logTask','run','','日志清除 总共耗时：1219毫秒','1',NULL,'2020-09-10 08:00:01'),('605eb321c6c049ed7baa28b7e84154a2','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-13 08:00:00'),('62770d4008f499229b1d250667adfb12','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-15 08:00:00'),('62d7c14b0a2b55642a5615c8c0966d97','日志清除','system','logTask','run','','日志清除 总共耗时：1087毫秒','1',NULL,'2020-08-15 08:00:01'),('679ca62083843913133d0733c828382c','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-23 00:00:00'),('697a2bfd672084297bdc0a060b65c989','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-18 00:00:00'),('6c8f1a9dccd72de8876edce986180a4f','日志清除','system','logTask','run','','日志清除 总共耗时：796毫秒','1',NULL,'2020-08-23 08:00:01'),('6e0423b51aa7b0557499e44f883b0317','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-30 08:00:00'),('6e429501d80c162a6958b0fb0325fe35','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2021-01-17 00:00:00'),('6f05f265f5674b4287aaa73a07f8eb21','日志清除','system','logTask','run','','日志清除 总共耗时：342毫秒','1',NULL,'2020-08-01 08:00:00'),('7023a519d14409db3e380a5d1ac94c8a','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-08 08:00:00'),('71239defd159b2c8896f736f5be953b7','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-22 08:00:00'),('76a8c43d6f262cae263770d989b17788','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-03 08:00:00'),('79a8fdb1f6ea8ced26cb7ebb4b4cd4c4','日志清除','system','logTask','run','','日志清除 总共耗时：385毫秒','1',NULL,'2020-07-30 08:00:00'),('79a9b1efa6ba61de0234b7ec512f016f','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-14 08:00:00'),('7a8d9472f4209f0687cd88ec79511581','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-21 08:00:00'),('7dcae5541612858dafd2e4040a0905ea','日志清除','system','logTask','run','','日志清除 总共耗时：593毫秒','1',NULL,'2020-09-09 08:00:01'),('7e3f8c5c51d97cc8bbc10852b064ec7e','日志清除','system','logTask','run','','日志清除 总共耗时：416毫秒','-1',NULL,'2020-09-08 08:00:01'),('7f79b7dc1eb07bdb5f2a8a32431424bf','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-05-30 00:00:56'),('8205923a86639b4c6f8f7b2731ae6225','日志清除','system','logTask','run','','日志清除 总共耗时：817毫秒','1',NULL,'2020-09-06 08:00:01'),('831cf29e17c32b1dc84bca65714e1039','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-03 08:00:00'),('833f3b3080791d9ca6444a4fa8d7770d','日志清除','system','logTask','run','','日志清除 总共耗时：296毫秒','1',NULL,'2020-09-13 08:00:00'),('885141f04ad1f05e894fe94884c15a2b','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-27 08:00:00'),('8b77d7e19e062012665d48a6e22102aa','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-30 08:00:00'),('8d75231b2b8adbfb22bf2fab55b15907','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-31 08:00:01'),('8f325ca87224699719d6354c4d90b346','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-14 08:00:00'),('91e3b508a9fcec2b558089cbe6118750','日志清除','system','logTask','run','','日志清除 总共耗时：501毫秒','1',NULL,'2020-08-08 08:00:01'),('941736b870b20bce0fc54e9f7e0310a1','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-05-24 00:39:48'),('96ce16347a7a60d47996ff8f9bf85587','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-18 08:00:00'),('97adbe391e87f590ad4a0b06b489f66a','日志清除','system','logTask','run','','日志清除 总共耗时：596毫秒','1',NULL,'2020-08-09 08:00:01'),('97b922286aeb3121e3f0777361430005','日志清除','system','logTask','run','','日志清除 总共耗时：589毫秒','1',NULL,'2020-05-27 11:12:36'),('99814fad2c9846c8a6159a499666d522','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-05 08:00:00'),('9a19aeded0e034ed027fa7969fed6278','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-17 08:00:00'),('9bf06bf7cb023a6508c2bdb83cc9c349','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-12 08:00:00'),('9d9e9703993ac05c70b79c09c7573df4','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-23 08:00:00'),('9ea9c00d11d30e58685956f28507314d','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-11 08:00:00'),('9f4d0508692260726f441ce7e61a3ef6','短信修复发送定时任务','sys','smsTask','run','','短信修复发送定时任务 总共耗时：315毫秒','1',NULL,'2020-10-11 21:15:20'),('a10c99f8d007b2d0cab92fdf72863d82','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-20 08:00:00'),('a38037fde6d7e2556033cdd7d3d01540','日志清除','system','logTask','run','','日志清除 总共耗时：793毫秒','1',NULL,'2021-01-17 00:00:01'),('a3cbd60bb3fbeff4a662354e53c0f4ab','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-06 08:00:00'),('a97b435a6aa0f10b4ab64f441b291db9','日志清除','system','logTask','run','','日志清除 总共耗时：294毫秒','1',NULL,'2020-08-18 08:00:00'),('a998fbf5cf1ad599d49b2dda08d93797','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-21 08:00:00'),('aa0ecb8c3618d4a3351d256200aff007','日志清除','system','logTask','run','','日志清除 总共耗时：862毫秒','1',NULL,'2020-07-19 08:00:01'),('ac96c0ebb333b0100638edb793f5e3b6','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-12 08:00:00'),('ad9edb496f085ce7772ed5f1dae87eb9','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-10 08:00:00'),('adbc69dbd8c9b16a22aef669783cca72','日志清除','system','logTask','run','','日志清除 总共耗时：882毫秒','1',NULL,'2020-07-26 08:00:01'),('b0924e19a5daf318083fbce33341d5bf','日志清除','system','logTask','run','','日志清除 总共耗时：1164毫秒','1',NULL,'2020-09-02 08:00:01'),('b4aa74e2e37923f7bcbc6b7f393182c7','日志清除','system','logTask','run','','日志清除 总共耗时：314毫秒','1',NULL,'2020-09-16 08:00:00'),('b6709b3f666c120b3a4cf027fd2ee6bb','日志清除','system','logTask','run','','日志清除 总共耗时：244毫秒','1',NULL,'2020-08-16 08:00:00'),('ba30e21d17d0f6cfd1d4a70c719a6816','日志清除','system','logTask','run','','日志清除 总共耗时：308毫秒','1',NULL,'2020-07-20 08:00:00'),('bbb1809b96555631a24d7f886ef82494','日志清除','system','logTask','run','','日志清除 总共耗时：768毫秒','-1','Could not roll back JDBC transaction; nested exception is java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.','2020-07-29 08:00:01'),('bc8e872613835cdffc401021943e0c30','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-12-15 00:00:00'),('be40e6cb2be1bfac42e19292e490b6d3','日志清除','system','logTask','run','','日志清除 总共耗时：391毫秒','-1',NULL,'2020-08-07 08:00:01'),('bed7e9c78771f24c7c17573685e7b9e5','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-15 08:00:01'),('c031133c0bf566e3fd8bca29c748d0de','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-22 08:00:00'),('c35fe4cc2af2a9bee19a1cf6e96bc7e7','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-01 08:00:00'),('c394f768a420d5f499e70520ebc049da','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-13 08:00:00'),('c3c9ab7d69dc46dabba0a1d9890b6ed6','日志清除','system','logTask','run','','日志清除 总共耗时：682毫秒','1',NULL,'2020-08-19 08:00:01'),('c43b3c05a055a2aeb7b1a13e45a75197','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-28 08:00:00'),('c5018cd6ce6f6bc6152bed4b69ca4b3d','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-25 08:00:00'),('c50b45c99af74bfa7ae1511c7f9897da','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-28 08:00:00'),('d25243e0bab08a169f0fe79af1acfaf0','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-05-27 11:12:35'),('d44631a4e169d651220618b6027e4562','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-24 08:00:00'),('df8aca23f7b9a8ff851c0b12c78bd699','日志清除','system','logTask','run','','日志清除 总共耗时：918毫秒','1',NULL,'2020-08-04 08:00:01'),('e0b0df5afb241423d0dfef981e1e5041','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-24 08:00:01'),('e0c3e7efa642f2acb31c51447aea5196','日志清除','system','logTask','run','','日志清除 总共耗时：365毫秒','1',NULL,'2020-07-27 08:00:00'),('e16d1d8281b7427b0131b3bcf5ae922c','日志清除','system','logTask','run','','日志清除 总共耗时：851毫秒','1',NULL,'2020-09-07 08:00:01'),('e1e657178cae5358173d80109f52e631','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-08 08:00:00'),('e301e5a85047cfbb5e5b58c954ee32b6','日志清除','system','logTask','run','','日志清除 总共耗时：521毫秒','1',NULL,'2020-08-26 08:00:01'),('e30af902f9665fdce768b381ce1b27d1','日志清除','system','logTask','run','','日志清除 总共耗时：370毫秒','1',NULL,'2020-08-20 08:00:00'),('e3814471ad48ae44c60cae5d6d7b253b','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-27 08:00:00'),('e4811bf1fb78f76a4d751837cb253473','日志清除','system','logTask','run','','日志清除 总共耗时：661毫秒','1',NULL,'2020-07-28 08:00:01'),('ec3302ec6715edcaf13d20afbfe76c33','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-26 08:00:00'),('ed97dfb795a94c0de9db42d40badf774','日志清除','system','logTask','run','','日志清除 总共耗时：565毫秒','1',NULL,'2020-09-15 08:00:01'),('edf54132d4cf76268080f0a13004bbea','日志清除','system','logTask','run','','日志清除 总共耗时：772毫秒','-1',NULL,'2020-09-05 08:00:01'),('eea639fbd5a8356b7d3efaf5868bcae7','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-07-19 08:00:01'),('eff7374511dd3f947193e42dcc455345','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-29 08:00:00'),('f2092f6a4b4590319d40ce0b72851e5a','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-02 08:00:01'),('f37695be1a05017c09a16f905f2217f1','短信修复发送定时任务','sys','smsTask','run','','短信修复发送定时任务运行开始!','0',NULL,'2020-10-11 21:15:20'),('f6b196dcc5f6ddb9e5e84d7926637492','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-08-26 08:00:00'),('f82daf136a54e5844e055c5fc58faf30','日志清除','system','logTask','run','','日志清除 总共耗时：514毫秒','1',NULL,'2020-07-25 08:00:01'),('fce696f5a7b9d0d11f070a27cfc2a003','日志清除','system','logTask','run','','日志清除 总共耗时：1168毫秒','1',NULL,'2020-07-31 08:00:01'),('fcf103747dd2e204d8ee0b5fd1db63e1','日志清除','system','logTask','run','','日志清除 总共耗时：410毫秒','1',NULL,'2020-08-05 08:00:00'),('fd5e9d1683c8d59655617a04c0e234d3','日志清除','system','logTask','run','','日志清除运行开始!','0',NULL,'2020-09-04 08:00:00');
  
  /*Table structure for table `test012` */
  
  DROP TABLE IF EXISTS `test012`;
  
  CREATE TABLE `test012` (
    `id` varchar(64) NOT NULL COMMENT 'id主键',
    `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
    `create_date` datetime DEFAULT NULL COMMENT '创建日期',
    `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
    `update_date` datetime DEFAULT NULL COMMENT '更新日期',
    `del_flag` char(1) DEFAULT NULL COMMENT '删除标识',
    `remarks` text COMMENT '备注',
    `tenant_id` varchar(11) DEFAULT '00000000' COMMENT '租户ID',
    `user_name` varchar(64) NOT NULL COMMENT '用户名',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='test';
  
  /*Data for the table `test012` */
  
  /*Table structure for table `test_car` */
  
  DROP TABLE IF EXISTS `test_car`;
  
  CREATE TABLE `test_car` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `name` varchar(100) DEFAULT NULL COMMENT '名称',
    `code` varchar(100) DEFAULT NULL COMMENT '品牌代码',
    `remarks` varchar(100) DEFAULT NULL COMMENT '备注',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典分组';
  
  /*Data for the table `test_car` */
  
  insert  into `test_car`(`id`,`name`,`code`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`tenant_id`) values ('1e53e2812aa34d9abd6bc7ded070e6ee','哈弗','002','阿三大声道','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-26 23:45:59','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:24:19','0','00000000'),('79e50f7cc7164e159b6128110ecf28bd','比亚迪','001','','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-26 23:37:16',NULL,NULL,'0','00000000');
  
  /*Table structure for table `test_car_model` */
  
  DROP TABLE IF EXISTS `test_car_model`;
  
  CREATE TABLE `test_car_model` (
    `id` varchar(32) NOT NULL COMMENT '主键',
    `car_id` varchar(32) DEFAULT NULL COMMENT '汽车',
    `name` varchar(100) DEFAULT NULL COMMENT '型号名',
    `value` varchar(100) DEFAULT NULL COMMENT '型号代码',
    `sort` int(5) DEFAULT NULL COMMENT '排序',
    `remarks` varchar(100) DEFAULT NULL COMMENT '描述',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000',
    PRIMARY KEY (`id`),
    KEY `test_car_model_car_id` (`car_id`),
    CONSTRAINT `test_car_model_car_id` FOREIGN KEY (`car_id`) REFERENCES `test_car` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典';
  
  /*Data for the table `test_car_model` */
  
  insert  into `test_car_model`(`id`,`car_id`,`name`,`value`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`tenant_id`) values ('2d8de06fc6774d159fa4ea3758a3758e','1e53e2812aa34d9abd6bc7ded070e6ee','h6','001',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 00:10:45','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 00:11:45','0','00000000'),('327f8ce636d3413c94ac9f44f0839b83','79e50f7cc7164e159b6128110ecf28bd','汉','003',3,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:49:23','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:51:33','0','00000000'),('77077b6f6cd54557acecf62b81979984','79e50f7cc7164e159b6128110ecf28bd','唐','001',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:49:02',NULL,NULL,'0','00000000'),('c6505ba95a304c47895307fea735e42d','1e53e2812aa34d9abd6bc7ded070e6ee','wey7','002',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 00:14:08',NULL,NULL,'0','00000000'),('c8374120bda044118580df60710174bd','1e53e2812aa34d9abd6bc7ded070e6ee','h9','003',1,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:44:05','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:48:44','0','00000000'),('f4dfd96542574a8ba3dc3be9880ca4d6','79e50f7cc7164e159b6128110ecf28bd','王朝','002',2,'','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:49:10','4028ea815a3d2a8c015a3d2f8d2a0002','2019-04-27 11:51:38','0','00000000');
  
  /*Table structure for table `test_expand_table` */
  
  DROP TABLE IF EXISTS `test_expand_table`;
  
  CREATE TABLE `test_expand_table` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `name` varchar(255) NOT NULL COMMENT '商品名称',
    `shop` varchar(100) NOT NULL COMMENT '所属店铺',
    `category` varchar(100) DEFAULT NULL COMMENT '商品分类',
    `address` text COMMENT '店铺地址',
    `description` longtext COMMENT '商品描述',
    `tag` varchar(200) DEFAULT NULL COMMENT '标签',
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `create_by` varchar(32) DEFAULT NULL,
    `organization_id` varchar(64) DEFAULT NULL COMMENT '组织ID',
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    `image` text COMMENT '图片',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `test_expand_table` */
  
  insert  into `test_expand_table`(`id`,`name`,`shop`,`category`,`address`,`description`,`tag`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`create_by`,`organization_id`,`tenant_id`,`image`) values ('08c7fa3112fab09a3d9007c3883e9caa','平板电脑','3C卖场','电子产品','智能手机卖场','大屏幕大尺寸，大有可为','大屏，语音助手','2020-05-30 22:19:35','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-30 22:19:52',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002',NULL,'00000000',NULL),('50a5699064ac49aeae0dbf50e8172f1d','智能手机','手机卖场','电子产品','阿斯达s\'d','最新的智能手机，最新的配置，最低的价格','手机','2019-05-04 14:02:11','4028ea815a3d2a8c015a3d2f8d2a0002','2020-05-30 22:18:12',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002','4028ea815a452f69015a45346f7b0001','00000000',NULL);
  
  /*Table structure for table `test_table` */
  
  DROP TABLE IF EXISTS `test_table`;
  
  CREATE TABLE `test_table` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `title` varchar(255) DEFAULT NULL COMMENT '标题',
    `author` varchar(100) NOT NULL COMMENT '作者',
    `type` varchar(250) DEFAULT NULL COMMENT '类型',
    `level` varchar(100) DEFAULT NULL COMMENT '密码',
    `content` longtext COMMENT '内容',
    `status` varchar(32) DEFAULT NULL COMMENT '状态',
    `tag` varchar(200) DEFAULT NULL COMMENT '标签',
    `readings` int(11) DEFAULT NULL COMMENT '阅读数',
    `publish_date` datetime DEFAULT NULL COMMENT '发布时间',
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `create_by` varchar(32) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_test_table_title` (`title`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `test_table` */
  
  insert  into `test_table`(`id`,`title`,`author`,`type`,`level`,`content`,`status`,`tag`,`readings`,`publish_date`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`create_by`,`tenant_id`) values ('11af6bf658691874d4762267241a71e1','testuser','4028ea815a3d2a8c015a3d2f8d2a0002','china','3','&lt;p&gt;testuser&lt;/p&gt;','published',NULL,NULL,'2020-01-26 03:05:00','2020-01-26 03:06:03','4028ea815a3d2a8c015a3d2f8d2a0002','2020-07-05 16:57:59',NULL,'0','bf5a446c42964ad6a42b2bbb04604190','00000000'),('2e12735f8b05b9d65338a393145c7f98','bbbb','4028ea815a3d2a8c015a3d2f8d2a0002','china','1','&lt;p&gt;asdas&amp;nbsp;&lt;/p&gt;','published',NULL,NULL,'2020-01-26 03:05:00','2020-01-26 03:05:31',NULL,NULL,NULL,'0','092b7c63dfdd903132858bd100bb02c5','00000000'),('7c059874514549459efe9da842b0ad5f','admin3','13e929eff9596c22361e10e33e0b8234','CN','1','&lt;p&gt;&lt;img class=&quot;wscnph&quot; src=&quot;http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558169005633.png&quot; /&gt;&lt;img class=&quot;wscnph&quot; src=&quot;http://harbouross.oss-cn-beijing.aliyuncs.com/2019/05/18/1558169051041.png&quot; /&gt;dfasdfdsf&lt;/p&gt;','published',NULL,NULL,'2019-04-03 00:37:00','2019-04-24 12:32:38','4028ea815a3d2a8c015a3d2f8d2a0002','2019-06-14 18:07:10',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002','00000000'),('9accf9bdc02f48a48facc321370541de','admin2','13e929eff9596c22361e10e33e0b8234','US','1','aaaa','published',NULL,NULL,'2019-04-24 00:02:00','2019-04-23 23:20:23','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-25 19:07:07',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002','00000000'),('d0188d2e7d65e839f135ff5d476b7f10','西游网络文章','126657d9b6648cbd188cee3cbf713981','china','1','&lt;p&gt;阿斯顿发斯蒂芬&lt;/p&gt;','published',NULL,NULL,'2019-12-17 11:20:00','2019-12-17 11:23:42',NULL,NULL,NULL,'0','126657d9b6648cbd188cee3cbf713981','89013384'),('db4eaa99fb4642f3b3b1fbfc49713f58','admin1','c91a986a797a8b69d6e13e94e2c78740','china','1','&lt;p&gt;adasdasds&lt;/p&gt;\n&lt;p&gt;&lt;img class=&quot;wscnph&quot; src=&quot;data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAgAElEQVR4nO2deXhUVZ73P7f2quwrhARCwpoEAmEngOxgg7jQyow0Q9PiOGK3tvu8/draC9PdzzRurTNq2+207fBqD+04KgMtCiKgILJJgASy7zuprJWlqu59/6hUUdmKLBVSCefzPHlS67nn3Drf8zvnd875HckvehM+hjLUGRAMGdJQZ6AzmqHOAEIQgmt0VxeGVDRDJRAhCkFvca8rN1wsN1ogQhiCgeCsPzdMKDdKIEIYAm9yw4Qy2AIRwhAMJoMulMESiBCG4EYyaELxtkCEMARDideFovJWQghxCHwHr9VFb1gQIQyBL+IVazJQCyLEIfB1BlRHByIQIQ7BcKHfdbW/AhHiEAw3+lVn+yMQIQ7BcKXPdbevAhHiEAx3+lSH+yIQIQ7BSKHXdbm3AhHiEIw0elWnvTlRKBCMOHojEGE9BCOV69bt6wlEiEMw0vFYx0UXSyDwgCeBCOshuFnosa4LCyIQeKAngQjrIbjZ6LbOdycQIQ7BzUqXui+6WAKBBzoLRFgPwc1OBw0ICyIQeMBdIMJ6CAQOXFoQFkQg8IAQiEDgASEQgcADzrA/Yvwh6DdqtQqNWo1Go0atVmG12bG1/ynKsK1aCiD5wvkggmHM+NhI4uPHMCk+iuBAEyajnsbGZvKLq8nOLSUru4TGxpahzma/EQIR9BmdTsPcWZNYtXQGixYkEBkZTFhwAHq9BrVKjdVmo76hmbIqMydOZbLvwClOfnOZtjbbUGe9z0jtR7ANWzsouHH4mQzMmzOZ9Wtms3xJMuOiwzEadB6/Y7XZyS+q4oN9X/Mf73xKSenVG5RbryBJftGbhDgEHgnwN7IkNYl1a+awNDWJmKhQtNq+dT5aWm389eOv+NXzeyguqR6knHof0cUS9MjoyGBWLpvJutWzSZkeR8yYcFSq/oW6Neg1bP7uElpa2vjlb/+C2dzo5dwODkIggi7Ejo3gO6tns2b5TGZOjycyPMgr6apVKu797hLSM4v4w58OeCXNwUYIROAiaeo4Vi2bweoVKSQnxhIa7O/1a/ibDPzg3hUcPnqB7JxSr6fvbYRAbnIkSSIlOZ51a+awfPE0pk6KISjQNKjXTJg8ljvWzeOFVz8c1Ot4AyGQmxSdTsOiBQmsuCWZFYuTmTxxzHU9Ut5Cq1Fz+7r5vP/RcQoKK2/INfuLEMhNRmhIAAvnTWHNilksTU1kXEwEuj56pLzB1InRrF6ewh//7NtjESGQm4Sw0ACWL0lm/do5zE+ZyNixEUg37rjxLvgZ9WzcsIB9B05RVl4zZPm4HkIgI5yY6HBW3jKdtStnM2vGBKJHhyINnS46MHPaeG5ZnMR/vX9sqLPSI0IgI5Spk2JYszKFVUuTmZ4QS0SfXbUKvTneT5FB6uea8AA/I5vuXMShL85TXV3fv0QGGSGQEUZKcjzrVs/mlkXTmDZ1HEGBRvp3jmXH7zS0yWRVt5JvbqWuVabBKtNmk2mxKUhIqCUJvRpGB2qJC9aSGGkkUO9ZOZIkMW/WZBanJvLhx1/3I4+DjxDICMBg0DF31iTWrEhh+aIkpkyKGbBHqtpi40p1K7nmNjKqWjhTZKG4tg0Am0qiVZZRISErCmpJwi5LKJKCQS3hr1MxM8rI300LYs3EQKBnexQcYOKe2xfx+Rdp1NdbBpTnwUCsxRrGBAQYWTQ/gbUrZrJoQSKT4qPRavq/B6643sqF8mbSKls5V27hSlULZXVWKhusjA/Wc8+0YOzAx5l1IIFR7biWooCMhF1RXFalvkVmbICGn64YxebkEI/XrTY38NCTb7D/wOl+532wEBZkGBIWGsCyxdNZuyKFBXMmExc7CqmfI++GVjtfF1s4XmThZJGFPHMr9a0KMjJtNgWbXWZDYiDPLotiUpie/3ehlrYMhVCTFpNGwq6Aoiio2q8voQZJob5ZJrumhee/qmTGaCNJkYaeyxMSwB3r53Pky4s0NfnW3hEhkGFE1KgQlqQmsm7NHBbMnkJ0VGi/hZFrbuNofhOf5zZwpsxCeaMNFDBq1QQZVPhpNdS3yRg0sDUljDnRJsoarBzJb6TVpuCnUaGgYFcUhwVp3zkoASoJQk0qxqEjr9bKyWKLR4FIwNLUJGYmx/PVifR+lWewEAIZBowfF+lYI7V8JjOnxTMmKrTfMxjnK5rZn9nA8YImLla20thmw1+nYoy/FoNGhVotoQJkBdrsMqFGDVH+WgByalq5UN5MY5tMZaMNlRqC9SpQSdhlh0CU9u/aFFAjYdSoaLVfvxcfPSqUjRtSOXMum5aWtn6WzvsIgfgw0xNjWbN8JsuWTCc5aTxhIQH9TuvrYgv7Mxv4JKuevJpWZAWMehXjg3UYNSpkwCa3WwJFok12dLHCTVqi/HU022Q+z20k+2or44L1GHUSlU1WGlologO1qN1EIklglxUsVofApob3bD2cSJLEmmUz+PN70Vy4mO8ze9mFQHwMlUpi1owJrF42k+WLpzMzOR6Tsf8eqUtVLey5WMu+K/Xk1lixWO1oVBDppyHcX4tWJdEmg92tiySpwG4HGRgbqCUmSIO5xUabDD+cF8FdSUEossLJ0ib+/G0tBbVW4kN1qCSHV0uSoNkK5maZBTEGZo+5vkAAokaHkDJzAhmXC7Fa7f0uszcRAvERtFoNi+ZPZfXyFG5JTSRh8lgMem2/0yuss/JhRh3vp9eSUd2CTiURbFSh10BipJ71k4LIrmnjUG4D/gY1GsnhjZIASVGw2hX0Gom4UC1atUSAXs322aFEB2jRqR0dvHkxJsYEaPnpwXJqmu2EGTQoOMYkVy02/HQqNkwJIFCv7lWeNWo1UyfFYDDosVp9w+UrBDLE6PVaZs2cyLrVs7h1RQpTJsW4PEL9odUu82F6PX86W8O5ModHKCpAhwQ022S+mxjMfbNDCTdp+MXhCiqbbAQZVDhnKRQcD62yY05jXJBDpEaNikg/DZ/mNFDZZOXWiYGMCdCycWow3xQ3818X6wjUqdCqwNxip6FN5p6kINZN7n23UK2SCA8LxN/fSEODEMhNT1JiLPfcuYhli5OZkTgOraZ3LW1PpFW08P/SzOy5WEdFg5WxQToiTGqQIK+2jfhgLf84J5QZo42cKLJwttxCgF6NUavCZgcriit8h11RMGpUBBscVcTcYueVr6v505lqGttkMlJa+dnyUfjr1ayID2DvlXpabTKyWqKi0c7caCM/mh9OiLEvVUwi0M+Av0k/oPvgTYRAhoCxMeHcuno2371tIYvmJwx4Ta1dgY8y6njleBVfFTSh0amID9MRYdRgU2QaWmWsdoW4ED3jgx3jmYzqZgrMrejVamqa7WhVEgatCrvdYUvUkkSbHVrbI/VUNdn46HIdhXU2AvVq9qSZuWdaCPNijIwyqQk3qTFb7NS22BkfrOfx1EhmjDb2vTAK2Gy+Mf4AIZAbSnCwH99ZPYfb1s5lWWqSV3bulTRaeeObq7z9ZRXFta0Eh+oJMKqpaLBhaZOJDtCiKI65iUh/Lf46NZVNdg5lN2KuszImTI252U6zzc4Yfx3BBg2yoqBTq2hstVNY53C5hpnUzIs2ca7IQovFxtSxJgxah7StikJti0x+jZUJ4XqeWTqK1RP6vl3XarWRkV1KbX3TgO+LtxACuUHMnzuFv7/7Fu5YO4/I8ECvpHmqtJnfHirjvy/WMincwNPzopgRbUIFHCuw8El2PdUWO1oJdGoV8cE61CoobWhDQuKRxaNYOTGAulYbn2Y38FlOI3ZFIcJPi79Woq5F4cuiJu5NDibMqOGheWE0tthoa5PZPj+cxAg9FrvCB5fqyC5sYlKMHz9bMYo7EwLpT/CT+qZmzl7M9alIjEIgg0z0mDDuuXMx99yZSnJCbL9nvjtzIKeBn31Syje5DWyaHcajS0cxK8qIrr1mrpoQSKSfmn8/WQ2SxLggHePau1cxgVp+sjSSKeEGnEu3lsT6o9dU8GFGHXqNimarwtUmOx+nmZkxysBPlkSSPMrIi+tikBWF0f5aLDaF54+W84ej5cyKMfHL9WO4dVJAv8QBkJ1fTmZmMVar70RgFAIZRBYsSOC+Lau469Z5Xt3v/WFGHc/8rZT0kibumRPO8+tjiAnUUFJvJbfOSlK4nnCTms3JIXxZ0MihnEbmRpuIDnT83OEmDYF6NYfzGjFqJRaNNTE+WMeDc8L4ttTClapmkqP9WBobwoVSCy99VYVKgg2TA4kN1tFik9mX2cC7Z67y4fkaUuMD+NX6GOZF97/LqCgKR45dJD+v3Fu3ySsIgQwC4WGB3L5+Pj/43kpmJI4fkNvWHUWB9y/V8fMvykmvaGbqWH+2zA4lJlBDbm0bvz5YzqncBramRvDIokhig3XMi/Hj4OUGtGoINTq8ZAXmNn53spqP0sxE+mv4xZoo1kwMZGKYnhmRBsrqrDw8P5yVcf6kV7fy6L4SfnG4nIPZjYwN1mK22Pkmp5EKi43ts8N4bMVopoYNzPN08NhF/nPPYZ9aZgJCIF5nZnI89/3DKu5aN5+QIO/FlbIrCnsvN/DTz8soqbcSHWEgNkzLuADHT1hcb+VATj3FV+r5MFjHfXPCsdllcqvboMGKpUWmfXU6aRXN/OlsDa1tdsoarPzpm6ukjvPHpJUYHagjzF/HrCgjEX4aZmpUzIgyUNzQRnp1CwdzG8BiJ2mMkf+zejRbZoYQYhiYe/r0xVx+/fJfyc+vGOht8jpCIF5Cp9OwctlMHn1wA4vmTfV6+qdLWvjV0QryattIjjDQ1CajKA4Xb1mDjU+z6mlWYEpiMLcnBGNUS1S0ykwM0zExxkRWTSv5ZisxgTpGBWiJDdKSXmrDqpKw2OT2cYOERqOizGJl93kzt04K4GJFC/m1bQToVNRbZSL8NNw6I4QdC8JYGO034HKdPJvFL1/cw9kzWQNOazAQAvECkRHBfO/vl/H9v1vOxPGjAUef2lsD8tJ6K698XcWFimamhOkx6VRYFahtkXntVA1tNplPs+vRayR+uCSSHXPD0aggNkjHjxZGkBxt4tdfVLD/ch2LY/2YNsrIjrnhvPV1FWMjDeyYF45JqyLrahtp5S3Y7Qr/fbGWrwoaMbfYybraisUqszjWny0zQlg/2TGLPhBq6hrZ9+kZfv/2AdIu5CLLvrE4sTNCIANkWlIsO+5bxz13pmLSXxuIe0scrXaFPZdq+SSznugALcEGNS12BaNWotmm8LfMehQFNCo1gXrHUo/sqy2cKm1mTKCWlXH+3JMYRFFNG/959iq3JQaROtaPrSmhzIsxMSpAw5gALRWNNn5/+irflluIC9bRalM4VuCYjxgfouO2yYFsnRnKzKh+TP65UVx2lUNH0/jiq4t8dSKd0jLfDfkDYsttv9HpNKQuTOTxB29nxZLpg3adCxUWHt5fyoXyVqZG6JFlsCkKKsAO2NsXFZrUaiotNlQqhUh/DRfKmpkYrOOF22JYEGMivaqF+/6Sj04l8bN1McyPNuKvU1HTbONsaTP/m9nA3st12GUFlUqiySoTZFCxYnwAGxODWBzrh0nb/+286VnFHD91hc8OnePU2Swqq2q9do8GE2FB+kFwsD+bN93C/d9bzeQJYwbtOgpwqriZfHMbYX5qxz4LRUFqf08FaLUSKglq22w0We2UNbRxoUyBJhv1tW2cL29mQYyJUJOG8eF6/ut0DU99Usr8GCN+eglzk0zm1VYya1qpabKhU6sYE6TltikBfGdSIMvH+xNm6l81kRWFCxmF7P/sNF98eZErmcVUX/XN8D49IQTSR+LjRnPfllXct3klgQGDG+S5vlXmQmUrVrtCuJ8KW6edeZIkOZaWN9uwygrL4vxJiTLyRX4jX+U0sGicifkxjjyW1lspb7EzerSB+hYbH16uw2pXaG5TsMoKei1MjdCzJDaA70wOYMFYExH9FIbVZufrs5l8eSKdg0fSSLuQS3Ozb7lve4sQSC+RJJgzezI/vH89t6+di047MNdmb5BlhepmG41tMia1CjsSNpuMJLXv20DBJkNjm52FY/14ZukoJobqWDMxgIvJISSPMjA5TI+5xc6ei3Xk1LQx2k/j+I5VQUJhdICaCaF65o/1Y0WcH3Oi/QjQ9a8rVd9o4eS5bD4/ksaxE5e4cqWYZh+b1+grQiC9wGDQsXxZMk88dAcLZk2+YdcN1KtIijDw32m1VDXZGB2kRVEcg3/HDkAJNQqBOjUgUdpgZWKojqnheqaGOybuTpVaeOesmd1na6httWM2Opa3TwjRkxJlYOFYEzOjjEwNN7g2QvWVhsYWPjt6ngOHz3HuXDbpl4u8dAeGHjFIvw7BQX58797l3P+9VUyKi7rh188zt/HE/hI+ulLP6EAtIQY1Bo2qfQ2VhFoCOwo1FjsRJg3rJgcQF6Knqc3OpVILn16uJ8PcSpiflvgIA4mRBuZEG5kxysjUcD0Rfv1vI8sqzHx1KoPPDqfx1dfp5Bf43kTfQBEC8cD48aO47x9W8+D312K6QWdndEdaeTP//s1VjhdZqGu2Y1cU1JIjcoiCggI0W2Xqm+1IKolwkwa9JKFXZOKCdMyfEMDMGCOxQTomhugJMQ6se5iZW8anX3zLka8ucOFiPsUlw+rk2j4hBNIDc+dM5p/uu5VNty1Epeq/e9Nb1DbbOFvWQlp5C9nmFupa7DS2KdhkGUUCk1ZNuFGDn04izKhmlJ+W2GAtk8KNjA3svZVwTnAq7cEX3AOGnk8v4PBXFzhy7CJfn7riM9tiBxMhkE6YjHpWLJvBUz+6k9kzJgx1drqlqsmKxabQalOQ26MaatUqgvQqggwq1NeZpGwfvjhE4HwN2kPtKEgqFar2d9qsNs6m5XLsZAZ/+/QMGZcLaWhsHszi+RRikO5GRHgQmzct5cFtaxk7Jrz91d4dA3AjifDryzIPBYX2kCXtzxRZAlX7OwoosqObplJLqCQ1EtDQ1MyxrzP47Mh5Tp3OJONKEa2t1sEojk8jBNLOxIlj2Pa9VfzTP6zutHfDt8TRWxRZBpUKRQYFGRQFRXIIRQGwO8KGooBKktBpHMEdyqvrOHk6k6MnLvH5kTSyskuGuihDyk0vEJVKxbJbktlx362sWToTdT9dnb6C0i4AGZBk2SGQ9oBXiiIjy47/iiyjUqtd8zm5RRUcO5nBp5+fI+1CPnn5vrVxaai4qQUSHOzPhu/M44f3r2falJihzs4AcHSjnF0lZ49KURRkWUFGcTy2y8jtARzUKhV2WSYtvYTPjpzjq68zSLuYT2Xl8FgjdaO4aQUyccIYNm9ayvbNqwgL8d7GphuPY6CutEdZdww1HMKwywp2WW6fVFTaZ9+hsbmVtEuFnDqXxeGjaZxPy6O5uXVIS+Gr3HQC0em0LF0yjW3fW8Ftq+ai7m+EgSFGVmQcpgLk9qDTMgrIjiUqNrsdq2xHATSS4zzb+qYWTpzN5PCRNM6dzyEzs5i2Nt8JkOCL3FQCiYgI4p67FvOPW9cwqX1j07DBEXT92mOlfSyhOAQhK44/qyxjt9qxywqS5JjTKK6o4djJy5w+m8Wp05nk5pYNaVGGEzeNQKYnjWfb91axZdNS/IZwVryvOAbYEpJ0bQCO7DhdVkbBLjusid1ux2ZXsMt2R7fKrlBQXMWpb7M48uVFzp3LoUqML/rMiBdIYKCJxalJPPbgBhbOmTLU2ekXzojpzoG30j6+sCkyNrsd2W5HURznc9htdi5lF3P0RDonT14mPb0Qs7lhqIswbBnRApk6JYa77kjlB3+3gjGjPB8k6as4ln3IjsNpFAlZlrHbZWyyjNVuBxWoJBWWlla+vZTPufO5fH70PBfS8nwuhM5wZEQKJCTYn8Wpifzj1jWsWDx422EHDedBHYrkGlvIsozdOYeB43DN1jYbDZYWLmUUcvxkBidOXiYnp5TGm2gpyGAzogSiVquYPDmGH9y7gnvuWEREmHdi4N5oZGj3TjlctJJzPsOuoFKpaLW2culKMZezSjhx6gpnv80mJ7vEuZpE4EVGjECix4SRuiCR729ewbIFiUOdnX7gGIA7Bt8O7xSKwz1rkxXsNhlzXSNXcss5eORbzpzJ4kpmMebaxiHO98hmRAgkef5UHrx3JRtWzSYkeODBzG4UztW0itS+mlZ2zG1Ijnk97IpCTW0jufnlfHsxl3NpuaRfKSI9vdCnztAYyQxrgUSOjSB+1kRSNyxixbKZhBgGFsxsSJBAao9TIrcfHlNaYaawuIoLGYVculxIZlYxGVeKaGgQY4sbzbAUSFB4IJNmTGDaipmMmzkRf7WdhsY6FEP4sFp7K0kSdkWhvLKGwuJqKitrSc8s5kJGAZlZxeQXVApP1BAzrAQSEhFE3PTxTJmfQOycKUQGmphghMlGhRB1I5IcCCrfnARU2rfHNre0Ultnoaj0KrmFFWTllpGbW0ZBYSXFJdWUV5iHOqsCN4aFQIz+BhJmTWTKoiRiUiZhCDAyXg+zghTijSrUKi1Vza00NzYQFhDqteMGBoKiKLS22ai6Wk9Do4WScjNZuaWUlFRTWl5DflEVefkVXL1a376TT+CL+LRA/IP8iBwXSfLiJKYuTUYV6E+YBhL9JeYEqTBqoLxZoawVMuoVbNRxW1wAoTd4KYmiKDQ1t2KubaS8uo5acyPllbXk5JeTW1BBdXUtRcXVlFfUilWzwwyfFIhOr2VyygQSFiYSnTyBwFHBBGokJhglkgJUjDFImNvgjNlGdgvU2KChTYXN1kp2XRNzDDoGK8yCrChYrTaqr9ZTbW6gtMJMSelVikuqySuopKikmvKKGmpqGmhs8p2z9gT9w+cEYvQ3kLpuLvM3LEQTGoS/RmKCn0S8QUWMQcKohoImma9qFQqaHeFvDGqJKIMGc6uNdHMdk4P9CdZ7x6PVZrVRY26kuqaeiqpa8gorKSiuorioiuKyq5SW1VB9tZ4mIYYRiU8JRK1RM3/tbJZvWYWs1RKrV5gVrCFSD1a7Qpus0GSDU3Uyec3gr5bwVyso7aE4A7U6Si3N5NdbmBEe2PsjCNziMjRaWrha00hldR05+eXkF1aQk1tGflEl5RW1VFbW0mQRYrhZ8BmBqDUqRo+PZP7tqdgMBqYaFBYHqzCpoc4GLXbw10C9XaHSqmBUSfipHPvk5PZddAa1ChUKF811xAf5EajzXDxZVmi1WqmuqqesupasnFIyMovJK6ggN7+cwqIq6up858xuwY3HZwRi9DMyOWUifqND8ZcUZgWp8FNDVZuCTQFnLAUVEjqVRJusILfvlANcgQqC9VpKmiwUNFiYFhpIZyOiKArmukaqqus5czGPK5nF5OWVk5lbSkFhpZiME3TAZwSiN+kJigjCZrURZNLgr5Joag8yoG7vQskKGNVgUkODTeoQsUrCcbCMTq0CbFyqqSMu0B9/rQqb3U5FZS1FpVc5f6mAK1lFXMksIT2ziKqquiErs8D38RmBKIDN6jjAxSY7YjapuLbNVMEhFNn5XFGQnIMPZxoK2GUwaTWUNDTxzZUiTJYWjnyTTvrlIi6mF1BQKGanBb3HZwTSWNtIVVE1epXEVatMeavCZJOjK2VVQKcCo1qislmmwaqgbt+G6hx/OE2MubqOgpxyirNL+FtBFVdLr5KVUzrEpRMMV3xGIG3NbeReyMdcWoU2Moy0Bjuj9RqCtBI2GTQqiRqbTHqjjMUO+vYA5ZIk0WxpxVxppuBSIZdOZFCUXUpDjdhmKhg4PhW8WpIklty5kO/c9x1sWjVxBpjkr8YA1LYpXGmWqbaCVgUqFK4WX6Usv4KiK8VkfptDaW45NqsIYyPwHj5jQcAxrjh98ByjYsJJXjGTy3YteS1gkKDZLoNag95u42pxNZnnckj78hIl2aU0i0k6wSDhUxbEiSnAyNzVs0hanIQpPBidToOkgK2xifPHLnH5dCZFmSXYxaYhwSDjkwIBx6GZEdHhxEwcg9HfiKWxmdLccioKK4c6a4KbCJ/qYrmjKFBZXE1jXRManZaWphbaWoV7VnBj8VmBOLE0NANidlswNAz94XsCgQ8jBCIQeEAIRCDwgBCIQOABIRCBwANCIAKBB4RABAIPCIEIBB4QAhEIPCAEIhB4QAhEIPCAEIhA4AEhEIHAAz6/mrczBz/4KX4mIwCbt/+WvBLfCNuzYWUCISH+mM2N7D2UMWjXWZgSw8YNqURFhbFlx+uDdp3+sjAlhp3PbiM7p5jjJy/xzvunhjpLA2JYCeSNXduYOzsJgOpqM//86F19+v6f3z3IiXPFbL17LqnzkwaUl84//v99aguJCfGkZ+Sy99AzAGy9ey6vvvB4r9J7+IkXr1uZFqbE8MmHu1zPt959+rrf8UZZnTjLvPXuuTz543v5p0de5MS54g6f+f7mVcydncTc2UmkXy7wynWHkmEjkA0rE7h301rX8/DwkA7Pe8Pxk5c4ca6Y1PlJff5udwxG67gwJYZJE6J6fL+gsIzYcY73t272XIZjJzK9VlYnwUH+7HzuAQB+/8rjJC/p2ACsXjEPAIulhVfeOuy16w4Vw0IgG1Ym8Oa/Pe16XlBYRlNT3zdRmc1DdyLsm2/9DxfS8zq8Nj0xjge2d7SC39+8qtcV2tlS98TDT7zY94xeh1feOsz92zYQOy6K2HFR7H59h6ur98j25YSHhwBgMhmoK3jPY1q9sZpDjc8LxCkOk8kAOMTx/O883/jOdB4X/Pndgxw/eanbz268/RaWL50DdF+pnWTllAFw4pNfkZgQ73o9MSGeuoL3ulTOtasXsDh1RofX/PyMfSpHf3jwqbd58Km3u7zurLzv7Tngev+NXdtc4gyKvbfHNJ/5+R/Y/R/PAbBh3S08sv0yr7x1mHvvWeXdzPsAPi+QmcnxLnEAxI6L6nW/3on7uADgxLniLn1nJ+799QvpeV5r4ZzdouvRnXhjx0aybm0qr//xw26/s+P+O9l/4DgFRR0DWhw7keJJpKkAAA9wSURBVNm/zF6HvYcyeG/PAZeYxkZHsPXuua6GorrazGeff9Ptd1MXJLvuxVBa9N7i8wLZvedLHnrgbiyWZpf5tlhayC9whBP18zMSOy6K6mozlVUdD8B0b9l7y+hRYX36/P4Dxzl/IYvVK+YRHh7iqhxZOWUdxhLddSe6G8R3Fu+GlQn8686HMJkMbLz9Fu7c+kKHz3/4zhMkJsQzPnYMv3n+nW77/btf38GEuJhu8796xTxOfDIJgMiIkGv5+ORXXcq586V9ruf/+vL/MGP6JH69azd7D2WQc+Y113tv797Hzpf2sfXuuYDD2jrLVJbxJ8DZaA2et89b+LxA8krqeO3N99m950u+Pf4GAJcycli18V+Aaz+kyWRk/4F9HX7E7vrA1xsEx8dFux5PT4xj69095y0rp8x1vROfTCI8PITKKrOry+J+nVdfeJxXX+gulZ55ZPtyfvLkVpcFnZ40gYUpMa7KFhcdxKjIUMDR59/53APMmzOVZ//l3Q7u7wlxMT02FuHhIa6Gx53Onz9/IavD87ySOhbe6rDKu57b5EqjutrsuidO8b+35wAnzr3Ns4+td5Vl/4HjfbgTQ4fPCwRg50v72LAywfU8O+daC/veXw+6KtGTj26hoKiyS0udk3ft830ZBHceQHfG+cMPBu7jAXCMve74+190qPjOSrr79R1sWHcL4BgTJE+b1K0LFhwtt9PqOtN1OjwiIxxicbfQnqxwXHSQowF76wABASbuuG0pb+92iGNhSleLFRjgR3pGLpERIR0aMl/G5wXy7GPriR4T0aHrM2P6JN7Ytc31/FJGDnNnJ1FQWEbq/KQufv8JcTG8sWsbJaVVg57f8bFjyDnzGr/4zZ84diKz154k53ghLjqIj/7ysw5jlsNHTvP5kbNsuHVWly7UG7u20djYzPMv7+ahB+7GZDIQOy6KD97dSeqqR7tMpC689ZkOXbvnf/eeq0E58cmvCA8PIb+g1GUdPHmi/vDqw/iZjOw/cJwHn3qbf335f1zXmztrUpfPP/XLPcCeXt0PX8HnBbJubWqXViwxIb7bls3peuyM8/PpGbk9DnTBIbzO6e7df5TGxu5dysdPXmL36ztYuWyeq+tgMhkwmQykzk/qlzNh4a3PdHBhv/nW/xAQYGLncw9gsbSw95Ozrkq4MCWGO25bislkID0jlwd+9FuXx++1N9/vcZWBewPy5I/vdXn5xseOAaDJcn0Xelx0kMvFnJgQz+49X3a43rw5U12PHXMjb/f6PvgSPi8QZ/fIaf7BUZGcOF93fw3o0I1wDuBz8op55/1TPXqmOg9MARobm7t1kzrZcf+dHbxszus1NFiuX7ge2Lz9t3z0l5+5WvcP33kCcIjv3beedrXuv3/lcde1z1/IYu+hDDZufpbvb17lsQuTuiDZ9Th2XBRv/tvTfPS/R1xpzZ2dxK7nNrW3+N2zZdNi1+PDR053tVTzprseh4eH8Oxj64dNt8odnxeIcxLKaf4BVwV5ZPty16wuwOM/ed3V73bvRnz2+TceK7kzLaf1SM/IZXzsGEwmA3fcttS1RKU7zl/IIjEhHoulxdWSL7z1GeKig7iQnsfG228hK7vINZ/izNPhI6f54OOjHdJyuj3zSuo6zFA/9pM/cvDjCYSHh5CYEO8SjPs4wlk+hxes57JuvXtuh+/Fjovi5KmLXbx3D2y/i0kTx/aYzj0bV7oedy7Hs4+t7+BxNJkMbNuyvouVGQ4Mm9W8zkk1d0vxyluHeW/PAcBh5n/4wIZuv3u9sceGlQn85Mmtruev//FDPvrfI4Cj1f79K48TFx3U7Xf//O5BZqY+6BrUOskrqSMrp4zlS+e4BvvulmtUZKhrvOT868ntmVdSx6NPv4ql/fjp5UvnuCYzLZYW/umR3s+Y77j/TtfjZ37+Bx5+4kU+P3LWlV5BYVmH63THhpUJHayze7niooN46IFrrr/X3nwfcFiRnT/d3Ot8+go+b0GcOH+Q8bFjunSFnK3UhLgY13vus9T3bFzJurWpLp+9O51n6k+dueTqhjkntWLHRfHRX37WxYsE9GhZAFYtuzZz3nnSrrtxlCcrt/dQBoe++MblrXJy6ItvPOahM+5Wcu+hDOKigzj48W9c7z//u/dc663c1325s/3761yPnV4ruOZgcN7LvfuPsvOlfSxdksLc2UlsWHcLzz5WOKy6WsNCIO4uQ5PJ0KPrsafXnT9ySIh/h9d3Pbepgyu3oLCMf3z4VdfzZ37+B5d4YsdFcfzgy/zzs6/1enZ96ZIU1+M/vPqwa+4G6HZiszviooN4aPtaNt6xrNv5ig3rbiHnzHTe3r2vV10YZ2Py6127AXjpN/e70nU2DgBBgSa+Tct1LSlxz4+7Zdm950vX6+7et+pqM8/+y7sAPLvzbT54d6fLFR89JuK6XV5fYVgIpLyyoc8L7372kx+4fnjnmipnK+5cru3eOnY3z7D3UAavvfk+Tz66BXCI89UXHmfH/bm899eDHVyunddVLUyJ6bCQcO7spA6Wr6dx0YaVCcxMjmfK5HEkT5vUbQvu7GY6G4Tw8BCefHSLYx6osIy0i1lcySzk27Sus9W/ef4dEqfGul6/c+sL7H59BwvnTe/QOOx8aR+PbF/e5druWwycg/Otd8/tcL8tlhYeffpV1708ca64w328d9NaZkyfxOt//FAsVvQGeSV15Hm4kZ27XO4eL4ulpYM3prPVgO7F4cTZHXDOMYCjYu587gFq6xo7LG5058Xf7HA9dq5bcrdw925a22XC0jlwd1akzlRXm/nda391CfOR7cv58UP3dLAszi7hhnXdr+btbinKlh2vuyb9wLEpradVwn9+9yD+/kZWLpvHBx8f7bJcxmJp4bU33+8iTOd9dJatP8uAhoJhIZDe0N0Nd/5Y7jz1yz1MmjjWVan37j963Z15O1/ax7dpua5NUQDPv7ybd94/RezYyA4COX8hi4UpMS6Lsnf/UR586m2On7zUxWp15sy5y44NSZsvuSqoxdLCyVMX+eDjo11a21feOswrbx3mke3LuX39IpISJnQZS/UW98YhO6e4g0Aslhb+/O5BoN1LtuN14qKvLWfZePtpli+dg8XSwgM/+m2Pzgb3xuZSRo7PWw/w4SPY+kJ3u+bSLxd0mFTrzBu7trHvk5N9XjD37GPrmTJ5nEtUC1Ni+P5mxzLvzrsM39i1rcPsMjj66ksWTu427WMnMh3LR1JiWLVsRrddpOux9e65TE+M44O9x12Dd+dqBPDsCHDiXqaS0ioOfnH+uo6A3a/v6LIGzFP64NnB4SuMCIEIBIPFsJkHEQiGAiEQgcADQiACgQeEQAQCDwiBCAQeEAIRCDwgBCIQeEAIRCDwgBCIQOABIRCBwAPDfrHiruc2ERBgum6ofeexAQEBJhoaLB3WKvWF/qTzyPblJE6NBRxrxAYa1Pl6Zfa03stJXxYK+kKZh4phuxar8x4E9xiznXGPG+VOb1byDiSdDSsTePm3D3fZ6FRdbebRp1/t10LE3pS5N8cueIq9685Ql3moGVZdrLjoIHY9t4mcM6/x6guPd7vDrjNv7NrW7Q8Mjt147vG1vJlOXHQQb/7b093mMTw8hDf/7eke97l3TqevZfYWQ1VmX2JYCWTJwsk8sP2uXleShSkxHTYlPf/yboJi72Xv/mtROO64bel1f7T+pPPSb+7vEJF+ZuqD3HrnU66ACCaToVcHAPW1zOA4w8PJ4SOnefiJF7v8XY+hLLMvMawE4s7e/UcpKCzz+JmNG1JdjwsKr8XR3bLj9Q4/2oZbZ3k9nflzp7ke//HtveSV1HHiXDG73/ub63X3+FS9oTdlBlx9f4Cs7CJXEAr3v+vhK2UeaoaVQLJyynj+5d3MTH2QLTtev+4hOu7ncRz/Oq3De+5hetwr1O7Xd1BX8B5px150bezpazpb757bIZic+wDV/byR3hyJ0Ncyd6an803c8bUy+xLDSiAnzhWz86V9vQ4+5h7Ov/N5ee7RymdMd8SR3Xr3XFefO3ZclGtXXV/TiR0b6Xqtc4vf3REInuhrmTuz8XbHWOGNXdu6vZYvltmXGPZuXk+499tr665/WMuxE5lUV5tdEc6dB9n0NR3n9lagX0fFDRT3KInu++Xv3bSWJ39c1iHy+0gp82AxogXSV/JK6lh1+09YsnByh0NfhhvOM0O6I3ZcVIfDN0dKmQcLIZBOXC/E0HDg17t2c/FyqatbtmFlAj/+4XddkUpix0XxyPblrnHCSCjzYKECpKHOxGDh9LZAR9cngL//tUBvFZU1Xk3HPbJ754BynV3KzsNAvcneQxldAuCt2vgvVFdfi+To7pjojuFW5kFCGlaD9L7Sk6cK6HBmX1Z2kVfT8eS1cV8CYrG03NAuTW9CnToZKWUeKCNaIO5Hr7n73+OigzoEmvtgr+fz8vqaTudA1e4hPNesvDZoPnnq4nXL0B+6m/iMiw5yHZADXT1TnRluZR4sRvQY5N/f3NvBhfnhO084Qnv++No6pPSM3A4tmnPtkXs40r6mk1dSx+Ejp10eJOfRCmOjIzos3eh8roa3OPjxbzjxzQU+PXTakeexkWzbcu0Azepqc4d5ipFQ5sHCKRAJGJaLFj1x4lwxe/cfdf1A7udqgMPcO6OcQ9c5gX9+9C4efOrtPqcD8K8v/Rfz505zHcnmftAPOJaADFbozfDwEDasu6XbdVTOwNJORkqZBwEJRngXCxxLI97bc6DDoBNwnennvrr02IlM1ySX+5xAX9MBhzgf+NFvuxwNZ7G08N6eA13OO/cmp85c6vH1kVrmwULyi97kfDziLEhnujvYvjPOvRSePtObdNxxP5v9Rrag7jPWzri/3TGSyuxFJLjJBCIQ9IEuXawROx8iEPQRlxZG/BhEIBgInQUirIjgZqeDBoQFEQg80J1AhBUR3Kx0qfs9WRAhEsHNRrd1XnSxBAIPeBKIsCKCm4Ue67qwIAKBB64nEGFFBCMdj3W8NxZEiEQwUrlu3RZdLIHAA70ViLAigpFGr+p0XyyIEIlgpNDrutzXLpYQiWC406c63J8xiBCJYLjS57rb30G6EIlguNGvOjsQL5YQiWC40O+6OlA3rxCJwNcZUB31xjyINNBMCASDxIDrpTcnCoVIBL6C1xptb0dWdGZKREgRDAVeb6QHK/SoEIrgRjJovZfBjs0rhCIYTAa9W3+jglcLoQi8yQ0b797o6O5CKIKBcMMdQUN1/IF7QYVYBJ4YUu+oL5wP0t0NEKK5OfG5qYL/D78B7d70p5zxAAAAAElFTkSuQmCC&quot; /&gt;&lt;/p&gt;','published',NULL,NULL,'2019-06-13 00:00:00','2019-06-14 18:12:40','4028ea815a3d2a8c015a3d2f8d2a0002','2020-02-04 02:08:04',NULL,'0','4028ea815a3d2a8c015a3d2f8d2a0002','00000000'),('f67a8d7433ec8b4f7355191118845dc9','山海文章','c91a986a797a8b69d6e13e94e2c78740','china','3','&lt;p&gt;阿斯顿发送到，好像忘了标签&lt;/p&gt;','draft',NULL,NULL,'2019-12-17 11:25:00','2019-12-17 11:26:11',NULL,NULL,NULL,'0','49cc47c9a5646525345621673dbc10fc','35798760');
  
  /*Table structure for table `test_tree_and_table` */
  
  DROP TABLE IF EXISTS `test_tree_and_table`;
  
  CREATE TABLE `test_tree_and_table` (
    `id` varchar(64) NOT NULL COMMENT '主键',
    `name` varchar(255) DEFAULT NULL COMMENT '部门名称',
    `type` varchar(250) DEFAULT NULL COMMENT '类型',
    `tag` varchar(200) DEFAULT NULL COMMENT '标签',
    `area_id` varchar(64) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL,
    `create_by` varchar(32) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `test_tree_and_table` */
  
  insert  into `test_tree_and_table`(`id`,`name`,`type`,`tag`,`area_id`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`create_by`,`tenant_id`) values ('030181840a5f449daad2a78c5c6b0d76','市委','市委','','a25c56ceb3134e25abcd3f11241067b9',NULL,NULL,NULL,NULL,NULL,NULL,'00000000'),('c6201bd0a6534309a512575c3094ba7f','城管','城管','阿达是否','0246a2a1667c453fac27fa4fd118c18b',NULL,NULL,NULL,NULL,NULL,NULL,'00000000');
  
  /*Table structure for table `test_tree_table` */
  
  DROP TABLE IF EXISTS `test_tree_table`;
  
  CREATE TABLE `test_tree_table` (
    `id` varchar(64) NOT NULL,
    `name` varchar(100) DEFAULT NULL COMMENT '机构名称',
    `geocoding` varchar(32) DEFAULT NULL COMMENT '是否叶子节点',
    `postal_code` varchar(32) DEFAULT NULL,
    `parent_id` varchar(32) DEFAULT NULL COMMENT '父节点',
    `parent_ids` varchar(1000) DEFAULT NULL COMMENT '父节点路径',
    `create_by` varchar(32) DEFAULT NULL,
    `create_date` datetime DEFAULT NULL,
    `update_by` varchar(32) DEFAULT NULL,
    `update_date` datetime DEFAULT NULL,
    `del_flag` char(1) DEFAULT NULL COMMENT '删除标记',
    `remarks` varchar(255) DEFAULT NULL,
    `tenant_id` varchar(64) NOT NULL DEFAULT '00000000' COMMENT '租户ID',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*Data for the table `test_tree_table` */
  
  insert  into `test_tree_table`(`id`,`name`,`geocoding`,`postal_code`,`parent_id`,`parent_ids`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`,`remarks`,`tenant_id`) values ('0246a2a1667c453fac27fa4fd118c18b','陕西','001001','710000',NULL,NULL,'4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 23:33:26','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-26 18:26:54','0','陕西','00000000'),('06cdf012b088513f11aeede4549ed121','河西','1123','123123','e26e805cfeeb2b772db3924fddcbc807','0246a2a1667c453fac27fa4fd118c18b/e26e805cfeeb2b772db3924fddcbc807/','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-13 12:02:21',NULL,NULL,'0',NULL,'00000000'),('9db9219474f6519913b3acd2f21554d4','雁塔区','1111','11111','a25c56ceb3134e25abcd3f11241067b9','0246a2a1667c453fac27fa4fd118c18b/a25c56ceb3134e25abcd3f11241067b9/','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-13 11:14:23',NULL,NULL,'0',NULL,'00000000'),('a25c56ceb3134e25abcd3f11241067b9','西安','2123165','123123','0246a2a1667c453fac27fa4fd118c18b','0246a2a1667c453fac27fa4fd118c18b/','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 23:38:28','4028ea815a3d2a8c015a3d2f8d2a0002','2019-05-02 23:49:15','0','西安','00000000'),('e26e805cfeeb2b772db3924fddcbc807','咸阳','11111','22222','0246a2a1667c453fac27fa4fd118c18b','0246a2a1667c453fac27fa4fd118c18b/','4028ea815a3d2a8c015a3d2f8d2a0002','2019-11-13 11:38:14',NULL,NULL,'0','咸阳','00000000');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  