telegram_bot.sql

/*
 Navicat Premium Data Transfer

 Source Server         : docker-mysql5.7
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : 127.0.0.1:3306
 Source Schema         : telegram_bot

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 13/03/2019 16:23:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', '0/1 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', '0/5 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', '0/1 * * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', NULL, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C6EB70707874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740004746573747400066D7262697264740018E69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', NULL, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161D01BAC507874000D302F35202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000B74000574657374327074000CE6B58BE8AF95E5BC82E5B8B8740001317800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', NULL, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C71032987874000E302F3130202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740005746573743170740018E697A0E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', NULL, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161CFB9A6907874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000037400047465737474000B68656C6C6F20776F726C6474002BE69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF952CE6AF8FE99A94E4B880E7A792E8A7A6E58F91740001317800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('MyScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('MyScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('MyScheduler', 'easy.local1552462398895', 1552465389963, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', NULL, 1552441281000, -1, 5, 'PAUSED', 'CRON', 1552441281000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C6EB70707874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740004746573747400066D7262697264740018E69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800);
INSERT INTO `QRTZ_TRIGGERS` VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', 'TASK_11', 'DEFAULT', NULL, 1552441285000, -1, 5, 'PAUSED', 'CRON', 1552441281000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161D01BAC507874000D302F35202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000B74000574657374327074000CE6B58BE8AF95E5BC82E5B8B8740001317800);
INSERT INTO `QRTZ_TRIGGERS` VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', NULL, 1552441290000, -1, 5, 'PAUSED', 'CRON', 1552441281000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C71032987874000E302F3130202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740005746573743170740018E697A0E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800);
INSERT INTO `QRTZ_TRIGGERS` VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', 'TASK_3', 'DEFAULT', NULL, 1552441281000, -1, 5, 'PAUSED', 'CRON', 1552441281000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161CFB9A6907874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000037400047465737474000B68656C6C6F20776F726C6474002BE69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF952CE6AF8FE99A94E4B880E7A792E8A7A6E58F91740001317800);
COMMIT;

-- ----------------------------
-- Table structure for t_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept` (
  `DEPT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `PARENT_ID` bigint(20) NOT NULL COMMENT '上级部门ID',
  `DEPT_NAME` varchar(100) NOT NULL COMMENT '部门名称',
  `ORDER_NUM` bigint(20) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`DEPT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dept
-- ----------------------------
BEGIN;
INSERT INTO `t_dept` VALUES (1, 0, '开发部', NULL, '2018-01-04 15:42:26');
INSERT INTO `t_dept` VALUES (2, 1, '开发一部', NULL, '2018-01-04 15:42:34');
INSERT INTO `t_dept` VALUES (3, 1, '开发二部', NULL, '2018-01-04 15:42:29');
INSERT INTO `t_dept` VALUES (4, 0, '市场部', NULL, '2018-01-04 15:42:36');
INSERT INTO `t_dept` VALUES (5, 0, '人事部', NULL, '2018-01-04 15:42:32');
INSERT INTO `t_dept` VALUES (6, 0, '测试部', NULL, '2018-01-04 15:42:38');
COMMIT;

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `DICT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典ID',
  `KEYY` bigint(20) NOT NULL COMMENT '键',
  `VALUEE` varchar(100) NOT NULL COMMENT '值',
  `FIELD_NAME` varchar(100) NOT NULL COMMENT '字段名称',
  `TABLE_NAME` varchar(100) NOT NULL COMMENT '表名',
  PRIMARY KEY (`DICT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dict
-- ----------------------------
BEGIN;
INSERT INTO `t_dict` VALUES (1, 0, '男', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (2, 1, '女', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (3, 2, '保密', 'ssex', 't_user');
INSERT INTO `t_dict` VALUES (4, 1, '有效', 'status', 't_user');
INSERT INTO `t_dict` VALUES (5, 0, '锁定', 'status', 't_user');
INSERT INTO `t_dict` VALUES (6, 0, '菜单', 'type', 't_menu');
INSERT INTO `t_dict` VALUES (7, 1, '按钮', 'type', 't_menu');
INSERT INTO `t_dict` VALUES (30, 0, '正常', 'status', 't_job');
INSERT INTO `t_dict` VALUES (31, 1, '暂停', 'status', 't_job');
INSERT INTO `t_dict` VALUES (32, 0, '成功', 'status', 't_job_log');
INSERT INTO `t_dict` VALUES (33, 1, '失败', 'status', 't_job_log');
COMMIT;

-- ----------------------------
-- Table structure for t_job
-- ----------------------------
DROP TABLE IF EXISTS `t_job`;
CREATE TABLE `t_job` (
  `JOB_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `BEAN_NAME` varchar(100) NOT NULL COMMENT 'spring bean名称',
  `METHOD_NAME` varchar(100) NOT NULL COMMENT '方法名',
  `PARAMS` varchar(200) DEFAULT NULL COMMENT '参数',
  `CRON_EXPRESSION` varchar(100) NOT NULL COMMENT 'cron表达式',
  `STATUS` char(2) NOT NULL COMMENT '任务状态  0：正常  1：暂停',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`JOB_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_job
-- ----------------------------
BEGIN;
INSERT INTO `t_job` VALUES (1, 'testTask', 'test', 'mrbird', '0/1 * * * * ?', '1', '有参任务调度测试', '2018-02-24 16:26:14');
INSERT INTO `t_job` VALUES (2, 'testTask', 'test1', NULL, '0/10 * * * * ?', '1', '无参任务调度测试', '2018-02-24 17:06:23');
INSERT INTO `t_job` VALUES (3, 'testTask', 'test', 'hello world', '0/1 * * * * ?', '1', '有参任务调度测试,每隔一秒触发', '2018-02-26 09:28:26');
INSERT INTO `t_job` VALUES (11, 'testTask', 'test2', NULL, '0/5 * * * * ?', '1', '测试异常', '2018-02-26 11:15:30');
COMMIT;

-- ----------------------------
-- Table structure for t_job_log
-- ----------------------------
DROP TABLE IF EXISTS `t_job_log`;
CREATE TABLE `t_job_log` (
  `LOG_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `JOB_ID` bigint(20) NOT NULL COMMENT '任务id',
  `BEAN_NAME` varchar(100) NOT NULL COMMENT 'spring bean名称',
  `METHOD_NAME` varchar(100) NOT NULL COMMENT '方法名',
  `PARAMS` varchar(200) DEFAULT NULL COMMENT '参数',
  `STATUS` char(2) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `ERROR` text COMMENT '失败信息',
  `TIMES` decimal(11,0) DEFAULT NULL COMMENT '耗时(单位：毫秒)',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`LOG_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2476 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_job_log
-- ----------------------------
BEGIN;
INSERT INTO `t_job_log` VALUES (2448, 3, 'testTask', 'test', 'hello world', '0', NULL, 0, '2018-03-20 15:31:50');
INSERT INTO `t_job_log` VALUES (2449, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:31:51');
INSERT INTO `t_job_log` VALUES (2450, 3, 'testTask', 'test', 'hello world', '0', NULL, 2, '2018-03-20 15:31:52');
INSERT INTO `t_job_log` VALUES (2451, 3, 'testTask', 'test', 'hello world', '0', NULL, 0, '2018-03-20 15:31:53');
INSERT INTO `t_job_log` VALUES (2452, 3, 'testTask', 'test', 'hello world', '0', NULL, 2, '2018-03-20 15:31:54');
INSERT INTO `t_job_log` VALUES (2453, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:31:55');
INSERT INTO `t_job_log` VALUES (2454, 3, 'testTask', 'test', 'hello world', '0', NULL, 0, '2018-03-20 15:31:56');
INSERT INTO `t_job_log` VALUES (2455, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:31:57');
INSERT INTO `t_job_log` VALUES (2456, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:31:59');
INSERT INTO `t_job_log` VALUES (2457, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:31:59');
INSERT INTO `t_job_log` VALUES (2458, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:32:00');
INSERT INTO `t_job_log` VALUES (2459, 3, 'testTask', 'test', 'hello world', '0', NULL, 0, '2018-03-20 15:32:01');
INSERT INTO `t_job_log` VALUES (2460, 3, 'testTask', 'test', 'hello world', '0', NULL, 5, '2018-03-20 15:32:02');
INSERT INTO `t_job_log` VALUES (2461, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:32:03');
INSERT INTO `t_job_log` VALUES (2462, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:32:04');
INSERT INTO `t_job_log` VALUES (2463, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:32:05');
INSERT INTO `t_job_log` VALUES (2464, 3, 'testTask', 'test', 'hello world', '0', NULL, 1, '2018-03-20 15:32:06');
INSERT INTO `t_job_log` VALUES (2465, 11, 'testTask', 'test2', NULL, '1', 'java.lang.NoSuchMethodException: cc.mrbird.job.task.TestTask.test2()', 0, '2018-03-20 15:32:26');
INSERT INTO `t_job_log` VALUES (2466, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 15:26:40');
INSERT INTO `t_job_log` VALUES (2467, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 15:26:50');
INSERT INTO `t_job_log` VALUES (2468, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 15:27:20');
INSERT INTO `t_job_log` VALUES (2469, 2, 'testTask', 'test1', NULL, '0', NULL, 3, '2018-04-02 17:29:20');
INSERT INTO `t_job_log` VALUES (2470, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 17:29:30');
INSERT INTO `t_job_log` VALUES (2471, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 17:29:40');
INSERT INTO `t_job_log` VALUES (2472, 2, 'testTask', 'test1', NULL, '0', NULL, 14, '2018-04-02 17:29:50');
INSERT INTO `t_job_log` VALUES (2473, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 17:30:00');
INSERT INTO `t_job_log` VALUES (2474, 2, 'testTask', 'test1', NULL, '0', NULL, 0, '2018-04-02 17:30:10');
INSERT INTO `t_job_log` VALUES (2475, 2, 'testTask', 'test1', NULL, '0', NULL, 1, '2018-04-02 17:30:20');
COMMIT;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `USERNAME` varchar(50) DEFAULT NULL COMMENT '操作用户',
  `OPERATION` text COMMENT '操作内容',
  `TIME` decimal(11,0) DEFAULT NULL COMMENT '耗时',
  `METHOD` text COMMENT '操作方法',
  `PARAMS` text COMMENT '方法参数',
  `IP` varchar(64) DEFAULT NULL COMMENT '操作者IP',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `location` varchar(50) DEFAULT NULL COMMENT '操作地点',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=986 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_log
-- ----------------------------
BEGIN;
INSERT INTO `t_log` VALUES (730, 'MrBird', '恢复任务', 55, 'cc.mrbird.job.controller.JobController.resumeJob()', 'jobIds: 3', '127.0.0.1', '2018-03-19 10:07:32', NULL);
INSERT INTO `t_log` VALUES (731, 'MrBird', '执行任务', 40, 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 3', '127.0.0.1', '2018-03-19 10:07:36', NULL);
INSERT INTO `t_log` VALUES (733, 'MrBird', '暂停任务', 10, 'cc.mrbird.job.controller.JobController.pauseJob()', 'jobIds: 3', '127.0.0.1', '2018-03-19 10:07:53', NULL);
INSERT INTO `t_log` VALUES (734, 'MrBird', '恢复任务', 17, 'cc.mrbird.job.controller.JobController.resumeJob()', 'jobIds: 1', '127.0.0.1', '2018-03-19 10:08:02', NULL);
INSERT INTO `t_log` VALUES (735, 'MrBird', '执行任务', 13, 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 1', '127.0.0.1', '2018-03-19 10:08:05', NULL);
INSERT INTO `t_log` VALUES (737, 'MrBird', '暂停任务', 11, 'cc.mrbird.job.controller.JobController.pauseJob()', 'jobIds: 1', '127.0.0.1', '2018-03-19 10:08:27', NULL);
INSERT INTO `t_log` VALUES (738, 'MrBird', '执行任务', 14, 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 11', '127.0.0.1', '2018-03-19 10:08:34', NULL);
INSERT INTO `t_log` VALUES (840, 'MrBird', '删除用户', 255, 'cc.mrbird.system.controller.UserController.deleteUsers()', 'ids: 165,166', '127.0.0.1', '2018-03-20 18:34:26', NULL);
INSERT INTO `t_log` VALUES (841, 'MrBird', '修改用户', 348, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@5adf3b3b  roles: [Ljava.lang.Long;@75a9cd18', '127.0.0.1', '2018-03-21 09:05:12', NULL);
INSERT INTO `t_log` VALUES (842, 'MrBird', '删除调度日志', 79, 'cc.mrbird.job.controller.JobLogController.deleteJobLog()', 'ids: 2447', '127.0.0.1', '2018-03-22 18:52:10', 'XX内网IP');
INSERT INTO `t_log` VALUES (843, 'MrBird', '修改用户', 18805, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@1a6c90df  rolesSelect: [Ljava.lang.Long;@4d9b2e06', '127.0.0.1', '2018-03-27 09:20:05', 'XX内网IP');
INSERT INTO `t_log` VALUES (844, 'MrBird', '修改用户', 5222, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@655c7201  rolesSelect: [Ljava.lang.Long;@1840d3a4', '127.0.0.1', '2018-03-27 09:20:23', 'XX内网IP');
INSERT INTO `t_log` VALUES (845, 'MrBird', '修改用户', 6989, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@3691c744  rolesSelect: [Ljava.lang.Long;@1cb15d59', '127.0.0.1', '2018-03-27 09:21:09', 'XX内网IP');
INSERT INTO `t_log` VALUES (846, 'MrBird', '新增任务', 361, 'cc.mrbird.job.controller.JobController.addJob()', 'job: cc.mrbird.job.domain.Job@41ea2910', '127.0.0.1', '2018-03-27 15:24:30', 'XX内网IP');
INSERT INTO `t_log` VALUES (847, 'MrBird', '修改任务', 429, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@7cb0d614', '127.0.0.1', '2018-03-27 15:25:31', 'XX内网IP');
INSERT INTO `t_log` VALUES (848, 'MrBird', '修改任务', 273, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@4937e65d', '127.0.0.1', '2018-03-27 17:43:09', 'XX内网IP');
INSERT INTO `t_log` VALUES (849, 'MrBird', '修改任务', 712, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@aa7781d', '127.0.0.1', '2018-03-27 17:43:31', 'XX内网IP');
INSERT INTO `t_log` VALUES (850, 'MrBird', '新增任务', 294, 'cc.mrbird.job.controller.JobController.addJob()', 'job: cc.mrbird.job.domain.Job@5543ec34', '127.0.0.1', '2018-03-28 14:36:44', 'XX内网IP');
INSERT INTO `t_log` VALUES (851, 'MrBird', '修改任务', 353, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@3fccec56', '127.0.0.1', '2018-03-28 14:37:06', 'XX内网IP');
INSERT INTO `t_log` VALUES (852, 'MrBird', '修改任务', 262, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@2ed43da1', '127.0.0.1', '2018-03-28 14:41:50', 'XX内网IP');
INSERT INTO `t_log` VALUES (853, 'MrBird', '删除任务', 589, 'cc.mrbird.job.controller.JobController.deleteJob()', 'ids: 18,19', '127.0.0.1', '2018-03-29 10:26:30', 'XX内网IP');
INSERT INTO `t_log` VALUES (854, 'MrBird', '新增任务', 548, 'cc.mrbird.job.controller.JobController.addJob()', 'job: cc.mrbird.job.domain.Job@b404b16', '127.0.0.1', '2018-03-29 10:27:11', 'XX内网IP');
INSERT INTO `t_log` VALUES (855, 'MrBird', '修改任务', 442, 'cc.mrbird.job.controller.JobController.updateJob()', 'job: cc.mrbird.job.domain.Job@49f25426', '127.0.0.1', '2018-03-29 10:29:18', 'XX内网IP');
INSERT INTO `t_log` VALUES (856, 'MrBird', '删除任务', 520, 'cc.mrbird.job.controller.JobController.deleteJob()', 'ids: 20', '127.0.0.1', '2018-03-29 10:41:20', 'XX内网IP');
INSERT INTO `t_log` VALUES (857, 'MrBird', '修改用户', 449, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@68355f70  rolesSelect: [Ljava.lang.Long;@80ce783', '127.0.0.1', '2018-03-29 16:18:26', 'XX内网IP');
INSERT INTO `t_log` VALUES (858, 'MrBird', '修改用户', 686, 'cc.mrbird.system.controller.UserController.updateUser()', 'user: cc.mrbird.system.domain.User@784012be  rolesSelect: [Ljava.lang.Long;@368eb59f', '127.0.0.1', '2018-03-29 16:18:37', 'XX内网IP');
INSERT INTO `t_log` VALUES (859, 'MrBird', '删除用户', 200, 'cc.mrbird.system.controller.UserController.deleteUsers()', 'ids: 41,68,92,125,161,162', '127.0.0.1', '2018-04-02 17:29:50', 'XX内网IP');
INSERT INTO `t_log` VALUES (860, 'MrBird', '访问系统', 1, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 09:58:44', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (861, 'MrBird', '获取用户信息', 104, 'cc.mrbird.system.controller.UserController.userList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  user: \"User{userId=null, username=\'\', password=\'null\', deptId=null, deptName=\'null\', email=\'null\', mobile=\'null\', status=\'\', crateTime=null, modifyTime=null, lastLoginTime=null, ssex=\'\', theme=\'null\', avatar=\'null\', description=\'null\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 09:58:48', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (862, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 09:58:48', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (863, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 09:58:49', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (864, 'MrBird', '获取系统所有URL', 3, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 09:58:49', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (865, 'MrBird', '获取部门信息', 0, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 09:58:50', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (866, 'MrBird', '获取字典信息', 5, 'cc.mrbird.system.controller.DictController.index()', '', '127.0.0.1', '2019-03-13 09:58:50', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (867, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 09:58:59', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (868, 'MrBird', '获取系统所有URL', 3, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 09:58:59', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (869, 'MrBird', '新增菜单/按钮', 15, 'cc.mrbird.system.controller.MenuController.addMenu()', 'menu: \"cc.mrbird.system.domain.Menu@4842ef5e\"', '127.0.0.1', '2019-03-13 09:59:59', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (870, 'MrBird', '获取角色信息', 1, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 10:00:03', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (871, 'MrBird', '获取部门信息', 0, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 10:00:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (872, 'MrBird', '获取菜单信息', 1, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 10:00:06', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (873, 'MrBird', '获取系统所有URL', 2, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 10:00:06', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (874, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 10:00:07', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (875, 'MrBird', '修改角色', 168, 'cc.mrbird.system.controller.RoleController.updateRole()', 'role: \"cc.mrbird.system.domain.Role@378257f\"  menuId: \"[Ljava.lang.Long;@5622816f\"', '127.0.0.1', '2019-03-13 10:00:16', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (876, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 10:00:18', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (877, 'MrBird', '获取定时任务信息', 7, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 10:01:37', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (878, 'MrBird', '获取调度日志信息', 7, 'cc.mrbird.job.controller.JobLogController.index()', '', '127.0.0.1', '2019-03-13 10:01:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (879, 'MrBird', '获取在线用户信息', 4, 'cc.mrbird.system.controller.SessionController.online()', '', '127.0.0.1', '2019-03-13 10:01:40', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (880, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 10:01:44', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (881, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 10:02:20', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (882, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 10:02:21', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (883, 'MrBird', '获取系统所有URL', 2, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 10:02:21', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (884, 'MrBird', '新增菜单/按钮', 13, 'cc.mrbird.system.controller.MenuController.addMenu()', 'menu: \"cc.mrbird.system.domain.Menu@535a7b14\"', '127.0.0.1', '2019-03-13 10:03:31', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (885, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 10:03:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (886, 'MrBird', '获取系统所有URL', 2, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 10:03:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (887, 'MrBird', '新增菜单/按钮', 7, 'cc.mrbird.system.controller.MenuController.addMenu()', 'menu: \"cc.mrbird.system.domain.Menu@107a6fb0\"', '127.0.0.1', '2019-03-13 10:05:25', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (888, 'MrBird', '新增菜单/按钮', 6, 'cc.mrbird.system.controller.MenuController.addMenu()', 'menu: \"cc.mrbird.system.domain.Menu@33c63c34\"', '127.0.0.1', '2019-03-13 10:06:30', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (889, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 10:06:31', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (890, 'MrBird', '修改角色', 173, 'cc.mrbird.system.controller.RoleController.updateRole()', 'role: \"cc.mrbird.system.domain.Role@2ac61efd\"  menuId: \"[Ljava.lang.Long;@38b3d12f\"', '127.0.0.1', '2019-03-13 10:06:46', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (891, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 10:06:48', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (892, 'MrBird', '获取定时任务信息', 0, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 10:07:02', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (893, 'MrBird', '获取调度日志信息', 0, 'cc.mrbird.job.controller.JobLogController.index()', '', '127.0.0.1', '2019-03-13 10:07:03', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (894, 'MrBird', '获取定时任务信息', 0, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 10:07:03', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (895, 'MrBird', '获取调度日志信息', 0, 'cc.mrbird.job.controller.JobLogController.index()', '', '127.0.0.1', '2019-03-13 10:07:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (896, 'MrBird', '获取定时任务信息', 0, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 10:07:05', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (897, 'MrBird', '获取天气信息', 4, 'cc.mrbird.web.controller.WeatherController.weather()', '', '127.0.0.1', '2019-03-13 10:07:11', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (898, 'MrBird', '获取每日一文信息', 5, 'cc.mrbird.web.controller.ArticleController.index()', '', '127.0.0.1', '2019-03-13 10:07:11', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (899, 'MrBird', '获取热门电影信息', 10, 'cc.mrbird.web.controller.MovieController.movieHot()', '', '127.0.0.1', '2019-03-13 10:07:13', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (900, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 10:07:14', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (901, 'MrBird', '获取即将上映电影信息', 0, 'cc.mrbird.web.controller.MovieController.movieComing()', '', '127.0.0.1', '2019-03-13 10:07:14', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (902, 'MrBird', '获取One--绘画信息', 10, 'cc.mrbird.web.controller.OneIsAllController.paintIndex()', '', '127.0.0.1', '2019-03-13 10:07:17', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (903, 'MrBird', '获取在线用户信息', 0, 'cc.mrbird.system.controller.SessionController.online()', '', '127.0.0.1', '2019-03-13 10:07:19', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (904, 'MrBird', '获取在线用户信息', 0, 'cc.mrbird.system.controller.SessionController.online()', '', '127.0.0.1', '2019-03-13 10:07:51', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (905, 'MrBird', '获取在线用户信息', 0, 'cc.mrbird.system.controller.SessionController.online()', '', '127.0.0.1', '2019-03-13 10:07:57', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (906, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 10:12:36', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (907, 'MrBird', '访问系统', 8, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 10:26:51', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (908, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 10:30:37', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (909, 'MrBird', '获取系统所有URL', 46, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 10:30:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (910, 'MrBird', '修改菜单/按钮', 16, 'cc.mrbird.system.controller.MenuController.updateMenu()', 'menu: \"cc.mrbird.system.domain.Menu@49e2656a\"', '127.0.0.1', '2019-03-13 10:31:03', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (911, 'MrBird', '访问系统', 1, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Mon Apr 02 17:29:32 CST 2018, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 10:31:10', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (912, 'MrBird', '获取定时任务信息', 8, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 10:31:42', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (913, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 09:58:44 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 13:51:48', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (914, 'MrBird', '获取角色信息', 12, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 13:51:57', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (915, 'MrBird', '获取用户信息', 45, 'cc.mrbird.system.controller.UserController.userList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  user: \"User{userId=null, username=\'\', password=\'null\', deptId=null, deptName=\'null\', email=\'null\', mobile=\'null\', status=\'\', crateTime=null, modifyTime=null, lastLoginTime=null, ssex=\'\', theme=\'null\', avatar=\'null\', description=\'null\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 13:52:01', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (916, 'MrBird', '访问系统', 2, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 13:51:48 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 14:24:21', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (917, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 13:51:48 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 14:24:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (918, 'MrBird', '获取字典信息', 8, 'cc.mrbird.system.controller.DictController.index()', '', '127.0.0.1', '2019-03-13 14:24:42', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (919, 'MrBird', '获取部门信息', 8, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 14:24:45', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (920, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 14:24:46', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (921, 'MrBird', '获取系统所有URL', 5, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 14:24:46', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (922, 'MrBird', '修改菜单/按钮', 14, 'cc.mrbird.system.controller.MenuController.updateMenu()', 'menu: \"cc.mrbird.system.domain.Menu@29e6a162\"', '127.0.0.1', '2019-03-13 14:25:34', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (923, 'MrBird', '修改菜单/按钮', 14, 'cc.mrbird.system.controller.MenuController.updateMenu()', 'menu: \"cc.mrbird.system.domain.Menu@36002f73\"', '127.0.0.1', '2019-03-13 14:26:05', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (924, 'MrBird', '获取用户信息', 104, 'cc.mrbird.system.controller.UserController.userList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  user: \"User{userId=null, username=\'null\', password=\'null\', deptId=null, deptName=\'null\', email=\'null\', mobile=\'null\', status=\'1\', crateTime=null, modifyTime=null, lastLoginTime=null, ssex=\'null\', theme=\'null\', avatar=\'null\', description=\'null\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 14:26:30', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (925, 'MrBird', '访问系统', 1, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 13:51:48 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 14:34:13', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (926, 'MrBird', '获取在线用户信息', 4, 'cc.mrbird.system.controller.SessionController.online()', '', '127.0.0.1', '2019-03-13 14:34:16', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (927, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 13:51:48 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 14:36:01', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (928, 'MrBird', '获取用户信息', 88, 'cc.mrbird.system.controller.UserController.userList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  user: \"User{userId=null, username=\'\', password=\'null\', deptId=null, deptName=\'null\', email=\'null\', mobile=\'null\', status=\'\', crateTime=null, modifyTime=null, lastLoginTime=null, ssex=\'\', theme=\'null\', avatar=\'null\', description=\'null\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 14:45:12', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (929, 'MrBird', '获取角色信息', 0, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 14:45:42', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (930, 'MrBird', '修改角色', 273, 'cc.mrbird.system.controller.RoleController.updateRole()', 'role: \"cc.mrbird.system.domain.Role@5fcd4022\"  menuId: \"[Ljava.lang.Long;@5bf2cf03\"', '127.0.0.1', '2019-03-13 14:45:55', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (931, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 14:45:59', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (932, 'MrBird', '获取系统所有URL', 4, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 14:46:00', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (933, 'MrBird', '获取部门信息', 1, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 14:46:43', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (934, 'MrBird', '获取字典信息', 7, 'cc.mrbird.system.controller.DictController.index()', '', '127.0.0.1', '2019-03-13 14:46:48', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (935, 'MrBird', '访问系统', 12, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 13:51:48 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 14:48:19', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (936, 'MrBird', '获取菜单信息', 1, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 14:48:24', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (937, 'MrBird', '获取系统所有URL', 68, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 14:48:24', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (938, 'MrBird', '获取角色信息', 6, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 14:48:25', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (939, 'MrBird', '获取用户信息', 21, 'cc.mrbird.system.controller.UserController.userList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  user: \"User{userId=null, username=\'\', password=\'null\', deptId=null, deptName=\'null\', email=\'null\', mobile=\'null\', status=\'\', crateTime=null, modifyTime=null, lastLoginTime=null, ssex=\'\', theme=\'null\', avatar=\'null\', description=\'null\', roleName=\'null\'}\"', '127.0.0.1', '2019-03-13 14:48:29', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (940, 'MrBird', '获取部门信息', 0, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 14:48:34', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (941, 'MrBird', '获取部门信息', 0, 'cc.mrbird.system.controller.DeptController.index()', '', '127.0.0.1', '2019-03-13 14:48:34', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (942, 'MrBird', '获取字典信息', 7, 'cc.mrbird.system.controller.DictController.index()', '', '127.0.0.1', '2019-03-13 14:48:36', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (943, 'MrBird', '获取角色信息', 1, 'cc.mrbird.system.controller.RoleController.index()', '', '127.0.0.1', '2019-03-13 14:48:37', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (944, 'MrBird', '获取菜单信息', 0, 'cc.mrbird.system.controller.MenuController.index()', '', '127.0.0.1', '2019-03-13 14:48:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (945, 'MrBird', '获取系统所有URL', 2, 'cc.mrbird.system.controller.MenuController.getAllUrl()', '', '127.0.0.1', '2019-03-13 14:48:38', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (946, 'MrBird', '获取用户信息', 121, 'cc.mrbird.system.controller.TelegramController.telegramMessage()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:55:14', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (947, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessage()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:55:15', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (948, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessage()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:55:16', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (949, 'MrBird', '获取用户信息', 126, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:55:59', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (950, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:56:01', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (951, 'MrBird', '获取用户信息', 4, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:56:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (952, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 14:56:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (953, 'MrBird', '获取用户信息', 6, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:00:51', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (954, 'MrBird', '访问系统', 0, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 14:24:21 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 15:31:02', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (955, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  telegramMessage: \"TelegramMessage{id=null, title=\'\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (956, 'MrBird', '获取用户信息', 5, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:05', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (957, 'MrBird', '获取用户信息', 3, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:08', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (958, 'MrBird', '获取用户信息', 4, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:10', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (959, 'MrBird', '获取定时任务信息', 6, 'cc.mrbird.job.controller.JobController.index()', '', '127.0.0.1', '2019-03-13 15:31:12', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (960, 'MrBird', '获取用户信息', 3, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=10, pageNum=1}\"  telegramMessage: \"TelegramMessage{id=null, title=\'\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:12', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (961, 'MrBird', '获取用户信息', 10, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:13', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (962, 'MrBird', '获取用户信息', 9, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:14', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (963, 'MrBird', '获取用户信息', 3, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:14', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (964, 'MrBird', '获取用户信息', 4, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 15:31:20', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (965, 'MrBird', '访问系统', 3, 'cc.mrbird.system.controller.LoginController.index()', 'user: \"User{userId=4, username=\'MrBird\', password=\'42ee25d1e43e9f57119a00d0a39e5250\', deptId=5, deptName=\'null\', email=\'mrbird@hotmail.com\', mobile=\'13455533222\', status=\'1\', crateTime=Wed Dec 27 15:47:19 CST 2017, modifyTime=Wed Mar 21 09:05:12 CST 2018, lastLoginTime=Wed Mar 13 15:31:02 CST 2019, ssex=\'0\', theme=\'green\', avatar=\'default.jpg\', description=\'我是作者。\', roleName=\'null\'}\"  org.springframework.validation.BindingResult.user: \"org.springframework.validation.BeanPropertyBindingResult: 0 errors\"', '127.0.0.1', '2019-03-13 16:18:54', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (966, 'MrBird', '获取用户信息', 113, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:19:56', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (967, 'MrBird', '获取用户信息', 96, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:29', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (968, 'MrBird', '获取用户信息', 69, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:30', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (969, 'MrBird', '获取用户信息', 57, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:31', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (970, 'MrBird', '获取用户信息', 44, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:31', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (971, 'MrBird', '获取用户信息', 40, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:31', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (972, 'MrBird', '获取用户信息', 48, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:32', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (973, 'MrBird', '获取用户信息', 37, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:32', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (974, 'MrBird', '获取用户信息', 12, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:32', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (975, 'MrBird', '获取用户信息', 41, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:32', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (976, 'MrBird', '获取用户信息', 26, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (977, 'MrBird', '获取用户信息', 32, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (978, 'MrBird', '获取用户信息', 62, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (979, 'MrBird', '获取用户信息', 32, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (980, 'MrBird', '获取用户信息', 26, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (981, 'MrBird', '获取用户信息', 35, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (982, 'MrBird', '获取用户信息', 15, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (983, 'MrBird', '获取用户信息', 43, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:21:33', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (984, 'MrBird', '获取用户信息', 20, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:22:04', '内网IP|0|0|内网IP|内网IP');
INSERT INTO `t_log` VALUES (985, 'MrBird', '获取用户信息', 41, 'cc.mrbird.system.controller.TelegramController.telegramMessageList()', 'request: \"QueryRequest{pageSize=0, pageNum=0}\"  telegramMessage: \"TelegramMessage{id=null, title=\'null\', content=\'null\', status=null, created=\'null\', updated=\'null\'}\"', '127.0.0.1', '2019-03-13 16:22:04', '内网IP|0|0|内网IP|内网IP');
COMMIT;

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `MENU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单/按钮ID',
  `PARENT_ID` bigint(20) NOT NULL COMMENT '上级菜单ID',
  `MENU_NAME` varchar(50) NOT NULL COMMENT '菜单/按钮名称',
  `URL` varchar(100) DEFAULT NULL COMMENT '菜单URL',
  `PERMS` text COMMENT '权限标识',
  `ICON` varchar(50) DEFAULT NULL COMMENT '图标',
  `TYPE` char(2) NOT NULL COMMENT '类型 0菜单 1按钮',
  `ORDER_NUM` bigint(20) DEFAULT NULL COMMENT '排序',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_menu` VALUES (1, 0, '系统管理', NULL, NULL, 'zmdi zmdi-settings', '0', 1, '2017-12-27 16:39:07', NULL);
INSERT INTO `t_menu` VALUES (2, 0, '系统监控', NULL, NULL, 'zmdi zmdi-shield-security', '0', 2, '2017-12-27 16:45:51', '2018-01-17 17:08:28');
INSERT INTO `t_menu` VALUES (3, 1, '用户管理', 'user', 'user:list', '', '0', 1, '2017-12-27 16:47:13', '2018-04-25 09:00:01');
INSERT INTO `t_menu` VALUES (4, 1, '角色管理', 'role', 'role:list', '', '0', 2, '2017-12-27 16:48:09', '2018-04-25 09:01:12');
INSERT INTO `t_menu` VALUES (5, 1, '菜单管理', 'menu', 'menu:list', '', '0', 3, '2017-12-27 16:48:57', '2018-04-25 09:01:30');
INSERT INTO `t_menu` VALUES (6, 1, '部门管理', 'dept', 'dept:list', '', '0', 4, '2017-12-27 16:57:33', '2018-04-25 09:01:40');
INSERT INTO `t_menu` VALUES (8, 2, '在线用户', 'session', 'session:list', '', '0', 1, '2017-12-27 16:59:33', '2018-04-25 09:02:04');
INSERT INTO `t_menu` VALUES (10, 2, '系统日志', 'log', 'log:list', '', '0', 3, '2017-12-27 17:00:50', '2018-04-25 09:02:18');
INSERT INTO `t_menu` VALUES (11, 3, '新增用户', NULL, 'user:add', NULL, '1', NULL, '2017-12-27 17:02:58', NULL);
INSERT INTO `t_menu` VALUES (12, 3, '修改用户', NULL, 'user:update', NULL, '1', NULL, '2017-12-27 17:04:07', NULL);
INSERT INTO `t_menu` VALUES (13, 3, '删除用户', NULL, 'user:delete', NULL, '1', NULL, '2017-12-27 17:04:58', NULL);
INSERT INTO `t_menu` VALUES (14, 4, '新增角色', NULL, 'role:add', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (15, 4, '修改角色', NULL, 'role:update', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (16, 4, '删除角色', NULL, 'role:delete', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
INSERT INTO `t_menu` VALUES (17, 5, '新增菜单', NULL, 'menu:add', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (18, 5, '修改菜单', NULL, 'menu:update', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (19, 5, '删除菜单', NULL, 'menu:delete', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
INSERT INTO `t_menu` VALUES (20, 6, '新增部门', NULL, 'dept:add', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (21, 6, '修改部门', NULL, 'dept:update', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (22, 6, '删除部门', NULL, 'dept:delete', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
INSERT INTO `t_menu` VALUES (23, 8, '踢出用户', NULL, 'user:kickout', NULL, '1', NULL, '2017-12-27 17:11:13', NULL);
INSERT INTO `t_menu` VALUES (24, 10, '删除日志', NULL, 'log:delete', NULL, '1', NULL, '2017-12-27 17:11:45', NULL);
INSERT INTO `t_menu` VALUES (58, 0, '网络资源', NULL, NULL, 'zmdi zmdi-globe-alt', '0', NULL, '2018-01-12 15:28:48', '2018-01-22 19:49:26');
INSERT INTO `t_menu` VALUES (59, 58, '天气查询', 'weather', 'weather:list', '', '0', NULL, '2018-01-12 15:40:02', '2018-04-25 09:02:57');
INSERT INTO `t_menu` VALUES (61, 58, '每日一文', 'article', 'article:list', '', '0', NULL, '2018-01-15 17:17:14', '2018-04-25 09:03:08');
INSERT INTO `t_menu` VALUES (64, 1, '字典管理', 'dict', 'dict:list', '', '0', NULL, '2018-01-18 10:38:25', '2018-04-25 09:01:50');
INSERT INTO `t_menu` VALUES (65, 64, '新增字典', NULL, 'dict:add', NULL, '1', NULL, '2018-01-18 19:10:08', NULL);
INSERT INTO `t_menu` VALUES (66, 64, '修改字典', NULL, 'dict:update', NULL, '1', NULL, '2018-01-18 19:10:27', NULL);
INSERT INTO `t_menu` VALUES (67, 64, '删除字典', NULL, 'dict:delete', NULL, '1', NULL, '2018-01-18 19:10:47', NULL);
INSERT INTO `t_menu` VALUES (81, 58, '影视资讯', NULL, NULL, NULL, '0', NULL, '2018-01-22 14:12:59', NULL);
INSERT INTO `t_menu` VALUES (82, 81, '正在热映', 'movie/hot', 'movie:hot', '', '0', NULL, '2018-01-22 14:13:47', '2018-04-25 09:03:48');
INSERT INTO `t_menu` VALUES (83, 81, '即将上映', 'movie/coming', 'movie:coming', '', '0', NULL, '2018-01-22 14:14:36', '2018-04-25 09:04:05');
INSERT INTO `t_menu` VALUES (86, 58, 'One 一个', NULL, NULL, NULL, '0', NULL, '2018-01-26 09:42:41', '2018-01-26 09:43:46');
INSERT INTO `t_menu` VALUES (87, 86, '绘画', 'one/painting', 'one:painting', '', '0', NULL, '2018-01-26 09:47:14', '2018-04-25 09:04:17');
INSERT INTO `t_menu` VALUES (88, 86, '语文', 'one/yuwen', 'one:yuwen', '', '0', NULL, '2018-01-26 09:47:40', '2018-04-25 09:04:30');
INSERT INTO `t_menu` VALUES (89, 86, '散文', 'one/essay', 'one:essay', '', '0', NULL, '2018-01-26 09:48:05', '2018-04-25 09:04:42');
INSERT INTO `t_menu` VALUES (101, 0, '任务调度', NULL, NULL, 'zmdi zmdi-alarm', '0', NULL, '2018-02-24 15:52:57', NULL);
INSERT INTO `t_menu` VALUES (102, 101, '定时任务', 'job', 'job:list', '', '0', NULL, '2018-02-24 15:53:53', '2018-04-25 09:05:12');
INSERT INTO `t_menu` VALUES (103, 102, '新增任务', NULL, 'job:add', NULL, '1', NULL, '2018-02-24 15:55:10', NULL);
INSERT INTO `t_menu` VALUES (104, 102, '修改任务', NULL, 'job:update', NULL, '1', NULL, '2018-02-24 15:55:53', NULL);
INSERT INTO `t_menu` VALUES (105, 102, '删除任务', NULL, 'job:delete', NULL, '1', NULL, '2018-02-24 15:56:18', NULL);
INSERT INTO `t_menu` VALUES (106, 102, '暂停任务', NULL, 'job:pause', NULL, '1', NULL, '2018-02-24 15:57:08', NULL);
INSERT INTO `t_menu` VALUES (107, 102, '恢复任务', NULL, 'job:resume', NULL, '1', NULL, '2018-02-24 15:58:21', NULL);
INSERT INTO `t_menu` VALUES (108, 102, '立即执行任务', NULL, 'job:run', NULL, '1', NULL, '2018-02-24 15:59:45', NULL);
INSERT INTO `t_menu` VALUES (109, 101, '调度日志', 'jobLog', 'jobLog:list', '', '0', NULL, '2018-02-24 16:00:45', '2018-04-25 09:05:25');
INSERT INTO `t_menu` VALUES (110, 109, '删除日志', NULL, 'jobLog:delete', NULL, '1', NULL, '2018-02-24 16:01:21', NULL);
INSERT INTO `t_menu` VALUES (113, 2, 'Redis监控', 'redis/info', 'redis:list', '', '0', NULL, '2018-06-28 14:29:42', NULL);
INSERT INTO `t_menu` VALUES (114, 2, 'Redis终端', 'redis/terminal', 'redis:terminal', '', '0', NULL, '2018-06-28 15:35:21', NULL);
INSERT INTO `t_menu` VALUES (115, 0, 'telegram', 'telegram', '', 'zmdi zmdi-mail-send', '0', NULL, '2019-03-13 09:59:59', '2019-03-13 14:26:05');
INSERT INTO `t_menu` VALUES (116, 115, '定时消息', 'telegram/message', 'telegram:message-list', 'zmdi zmdi-assignment-o', '0', NULL, '2019-03-13 10:03:31', '2019-03-13 14:25:34');
INSERT INTO `t_menu` VALUES (117, 115, '命令管理', 'telegram/command', 'telegram:command-list', 'zmdi zmdi-mail-reply-all', '0', NULL, '2019-03-13 10:05:25', NULL);
INSERT INTO `t_menu` VALUES (118, 115, '群管理', 'telegram/group', 'telegram:group-list', 'zmdi zmdi-assignment-account', '0', NULL, '2019-03-13 10:06:30', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `ROLE_NAME` varchar(100) NOT NULL COMMENT '角色名称',
  `REMARK` varchar(100) DEFAULT NULL COMMENT '角色描述',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES (1, '管理员', '管理员', '2017-12-27 16:23:11', '2019-03-13 14:45:55');
INSERT INTO `t_role` VALUES (2, '测试账号', '测试账号', '2017-12-27 16:25:09', '2018-01-23 09:11:11');
INSERT INTO `t_role` VALUES (3, '注册账户', '注册账户，只可查看，不可操作', '2017-12-29 16:00:15', '2018-02-24 17:33:45');
INSERT INTO `t_role` VALUES (23, '用户管理员', '负责用户的增删改操作', '2018-01-09 15:32:41', NULL);
INSERT INTO `t_role` VALUES (24, '系统监控员', '可查看系统监控信息，但不可操作', '2018-01-09 15:52:01', '2018-03-07 19:05:33');
INSERT INTO `t_role` VALUES (25, '用户查看', '查看用户，无相应操作权限', '2018-01-09 15:56:30', NULL);
INSERT INTO `t_role` VALUES (63, '影院工作者', '可查看影视信息', '2018-02-06 08:48:28', '2018-03-07 19:05:26');
INSERT INTO `t_role` VALUES (64, '天气预报员', '可查看天气预报信息', '2018-02-27 08:47:04', NULL);
INSERT INTO `t_role` VALUES (65, '文章审核', '文章类', '2018-02-27 08:48:01', '2018-03-13 11:20:34');
COMMIT;

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID',
  `MENU_ID` bigint(20) NOT NULL COMMENT '菜单/按钮ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_role_menu` VALUES (3, 58);
INSERT INTO `t_role_menu` VALUES (3, 59);
INSERT INTO `t_role_menu` VALUES (3, 61);
INSERT INTO `t_role_menu` VALUES (3, 81);
INSERT INTO `t_role_menu` VALUES (3, 82);
INSERT INTO `t_role_menu` VALUES (3, 83);
INSERT INTO `t_role_menu` VALUES (3, 86);
INSERT INTO `t_role_menu` VALUES (3, 87);
INSERT INTO `t_role_menu` VALUES (3, 88);
INSERT INTO `t_role_menu` VALUES (3, 89);
INSERT INTO `t_role_menu` VALUES (3, 1);
INSERT INTO `t_role_menu` VALUES (3, 3);
INSERT INTO `t_role_menu` VALUES (3, 4);
INSERT INTO `t_role_menu` VALUES (3, 5);
INSERT INTO `t_role_menu` VALUES (3, 6);
INSERT INTO `t_role_menu` VALUES (3, 64);
INSERT INTO `t_role_menu` VALUES (3, 2);
INSERT INTO `t_role_menu` VALUES (3, 8);
INSERT INTO `t_role_menu` VALUES (3, 10);
INSERT INTO `t_role_menu` VALUES (3, 101);
INSERT INTO `t_role_menu` VALUES (3, 102);
INSERT INTO `t_role_menu` VALUES (3, 109);
INSERT INTO `t_role_menu` VALUES (63, 58);
INSERT INTO `t_role_menu` VALUES (63, 81);
INSERT INTO `t_role_menu` VALUES (63, 82);
INSERT INTO `t_role_menu` VALUES (63, 83);
INSERT INTO `t_role_menu` VALUES (24, 8);
INSERT INTO `t_role_menu` VALUES (24, 2);
INSERT INTO `t_role_menu` VALUES (24, 10);
INSERT INTO `t_role_menu` VALUES (65, 86);
INSERT INTO `t_role_menu` VALUES (65, 88);
INSERT INTO `t_role_menu` VALUES (65, 89);
INSERT INTO `t_role_menu` VALUES (65, 58);
INSERT INTO `t_role_menu` VALUES (65, 61);
INSERT INTO `t_role_menu` VALUES (2, 81);
INSERT INTO `t_role_menu` VALUES (2, 61);
INSERT INTO `t_role_menu` VALUES (2, 24);
INSERT INTO `t_role_menu` VALUES (2, 82);
INSERT INTO `t_role_menu` VALUES (2, 83);
INSERT INTO `t_role_menu` VALUES (2, 58);
INSERT INTO `t_role_menu` VALUES (2, 59);
INSERT INTO `t_role_menu` VALUES (2, 2);
INSERT INTO `t_role_menu` VALUES (2, 8);
INSERT INTO `t_role_menu` VALUES (2, 10);
INSERT INTO `t_role_menu` VALUES (23, 11);
INSERT INTO `t_role_menu` VALUES (23, 12);
INSERT INTO `t_role_menu` VALUES (23, 13);
INSERT INTO `t_role_menu` VALUES (23, 3);
INSERT INTO `t_role_menu` VALUES (23, 1);
INSERT INTO `t_role_menu` VALUES (25, 1);
INSERT INTO `t_role_menu` VALUES (25, 3);
INSERT INTO `t_role_menu` VALUES (64, 59);
INSERT INTO `t_role_menu` VALUES (64, 58);
INSERT INTO `t_role_menu` VALUES (1, 59);
INSERT INTO `t_role_menu` VALUES (1, 2);
INSERT INTO `t_role_menu` VALUES (1, 3);
INSERT INTO `t_role_menu` VALUES (1, 67);
INSERT INTO `t_role_menu` VALUES (1, 1);
INSERT INTO `t_role_menu` VALUES (1, 4);
INSERT INTO `t_role_menu` VALUES (1, 5);
INSERT INTO `t_role_menu` VALUES (1, 6);
INSERT INTO `t_role_menu` VALUES (1, 20);
INSERT INTO `t_role_menu` VALUES (1, 21);
INSERT INTO `t_role_menu` VALUES (1, 22);
INSERT INTO `t_role_menu` VALUES (1, 10);
INSERT INTO `t_role_menu` VALUES (1, 8);
INSERT INTO `t_role_menu` VALUES (1, 58);
INSERT INTO `t_role_menu` VALUES (1, 66);
INSERT INTO `t_role_menu` VALUES (1, 11);
INSERT INTO `t_role_menu` VALUES (1, 12);
INSERT INTO `t_role_menu` VALUES (1, 64);
INSERT INTO `t_role_menu` VALUES (1, 13);
INSERT INTO `t_role_menu` VALUES (1, 14);
INSERT INTO `t_role_menu` VALUES (1, 65);
INSERT INTO `t_role_menu` VALUES (1, 15);
INSERT INTO `t_role_menu` VALUES (1, 16);
INSERT INTO `t_role_menu` VALUES (1, 17);
INSERT INTO `t_role_menu` VALUES (1, 18);
INSERT INTO `t_role_menu` VALUES (1, 23);
INSERT INTO `t_role_menu` VALUES (1, 81);
INSERT INTO `t_role_menu` VALUES (1, 82);
INSERT INTO `t_role_menu` VALUES (1, 83);
INSERT INTO `t_role_menu` VALUES (1, 19);
INSERT INTO `t_role_menu` VALUES (1, 24);
INSERT INTO `t_role_menu` VALUES (1, 61);
INSERT INTO `t_role_menu` VALUES (1, 86);
INSERT INTO `t_role_menu` VALUES (1, 87);
INSERT INTO `t_role_menu` VALUES (1, 88);
INSERT INTO `t_role_menu` VALUES (1, 89);
INSERT INTO `t_role_menu` VALUES (1, 101);
INSERT INTO `t_role_menu` VALUES (1, 102);
INSERT INTO `t_role_menu` VALUES (1, 103);
INSERT INTO `t_role_menu` VALUES (1, 104);
INSERT INTO `t_role_menu` VALUES (1, 105);
INSERT INTO `t_role_menu` VALUES (1, 106);
INSERT INTO `t_role_menu` VALUES (1, 107);
INSERT INTO `t_role_menu` VALUES (1, 108);
INSERT INTO `t_role_menu` VALUES (1, 109);
INSERT INTO `t_role_menu` VALUES (1, 110);
INSERT INTO `t_role_menu` VALUES (1, 113);
INSERT INTO `t_role_menu` VALUES (1, 114);
INSERT INTO `t_role_menu` VALUES (1, 115);
INSERT INTO `t_role_menu` VALUES (1, 117);
INSERT INTO `t_role_menu` VALUES (1, 118);
INSERT INTO `t_role_menu` VALUES (1, 116);
COMMIT;

-- ----------------------------
-- Table structure for t_telegram_message
-- ----------------------------
DROP TABLE IF EXISTS `t_telegram_message`;
CREATE TABLE `t_telegram_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `title` varchar(255) DEFAULT NULL,
  `content` longtext,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_telegram_message
-- ----------------------------
BEGIN;
INSERT INTO `t_telegram_message` VALUES (1, '最新新闻', '奥术大师大所大所大所大所大大所大所大所 奥术大师大所大是大事大奥所大所所 a', 1, '2019-03-13 16:21:23', '2019-03-13 16:20:44');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `USER_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `USERNAME` varchar(50) NOT NULL COMMENT '用户名',
  `PASSWORD` varchar(128) NOT NULL COMMENT '密码',
  `DEPT_ID` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `EMAIL` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `MOBILE` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `STATUS` char(1) NOT NULL COMMENT '状态 0锁定 1有效',
  `CRATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间',
  `LAST_LOGIN_TIME` datetime DEFAULT NULL COMMENT '最近访问时间',
  `SSEX` char(1) DEFAULT NULL COMMENT '性别 0男 1女',
  `THEME` varchar(10) DEFAULT NULL COMMENT '主题',
  `AVATAR` varchar(100) DEFAULT NULL COMMENT '头像',
  `DESCRIPTION` varchar(100) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (4, 'MrBird', '42ee25d1e43e9f57119a00d0a39e5250', 5, 'mrbird@hotmail.com', '13455533222', '1', '2017-12-27 15:47:19', '2018-03-21 09:05:12', '2019-03-13 16:18:54', '0', 'green', 'default.jpg', '我是作者。');
INSERT INTO `t_user` VALUES (6, 'tester', '243e29429b340192700677d48c09d992', 6, 'tester@qq.com', '13888888888', '1', '2017-12-27 17:35:14', '2018-03-27 09:21:08', '2018-01-23 09:17:27', '1', 'teal', 'default.jpg', NULL);
INSERT INTO `t_user` VALUES (23, 'scott', 'ac3af72d9f95161a502fd326865c2f15', 6, 'scott@qq.com', '15134627380', '1', '2017-12-29 16:16:39', '2018-03-29 16:18:36', '2018-03-20 17:59:04', '0', 'blue-grey', 'default.jpg', '我是scott，嗯嗯');
INSERT INTO `t_user` VALUES (24, 'smith', '228208eafc74e48c44619cc543fc0efe', 3, 'smith@qq.com', '13364754932', '1', '2017-12-29 16:21:31', '2018-02-27 08:48:16', '2018-02-27 08:48:27', '1', 'teal', 'default.jpg', NULL);
INSERT INTO `t_user` VALUES (25, 'allen', '83baac97928a113986054efacaeec1d2', 3, 'allen@qq.com', '13427374857', '0', '2017-12-29 16:21:54', '2018-01-17 11:28:16', NULL, '1', 'indigo', 'default.jpg', NULL);
INSERT INTO `t_user` VALUES (26, 'martin', 'b26c9edca9a61016bca1f6fb042e679e', 4, 'martin@qq.com', '15562736678', '1', '2017-12-29 16:22:24', '2018-01-25 09:23:15', '2018-01-25 17:24:50', '1', 'teal', 'default.jpg', NULL);
INSERT INTO `t_user` VALUES (27, 'ford', '0448f0dcfd856b0e831842072b532141', 6, 'ford@qq.com', '15599998373', '0', '2017-12-29 16:22:52', '2018-03-13 11:19:56', '2018-03-08 16:31:59', '0', 'cyan', 'default.jpg', NULL);
INSERT INTO `t_user` VALUES (91, '系统监控员', '7c28d1cd33414ac15832f7be92668b7a', 6, 'xtjk@qq.com', '18088736652', '1', '2018-01-09 15:52:56', NULL, '2018-01-09 15:53:12', '0', 'cyan', 'default.jpg', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `USER_ID` bigint(20) NOT NULL COMMENT '用户ID',
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES (27, 3);
INSERT INTO `t_user_role` VALUES (24, 65);
INSERT INTO `t_user_role` VALUES (26, 3);
INSERT INTO `t_user_role` VALUES (26, 23);
INSERT INTO `t_user_role` VALUES (26, 24);
INSERT INTO `t_user_role` VALUES (25, 3);
INSERT INTO `t_user_role` VALUES (91, 24);
INSERT INTO `t_user_role` VALUES (4, 1);
INSERT INTO `t_user_role` VALUES (6, 1);
INSERT INTO `t_user_role` VALUES (6, 2);
INSERT INTO `t_user_role` VALUES (6, 3);
INSERT INTO `t_user_role` VALUES (6, 25);
INSERT INTO `t_user_role` VALUES (6, 63);
INSERT INTO `t_user_role` VALUES (23, 2);
INSERT INTO `t_user_role` VALUES (23, 3);
INSERT INTO `t_user_role` VALUES (23, 23);
INSERT INTO `t_user_role` VALUES (23, 24);
INSERT INTO `t_user_role` VALUES (23, 25);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;