/*
Navicat MySQL Data Transfer

Source Server         : 1.8
Source Server Version : 50513
Source Host           : 192.168.1.8:3306
Source Database       : platform

Target Server Type    : MYSQL
Target Server Version : 50513
File Encoding         : 65001

Date: 2016-12-30 15:48:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for T_AGENT
-- ----------------------------
DROP TABLE IF EXISTS `T_AGENT`;
CREATE TABLE `T_AGENT` (
  `AGENT_ID` bigint(20) NOT NULL COMMENT '终端信息编号',
  `AGENT_GROUP_ID` bigint(20) DEFAULT NULL COMMENT '终端分组编号',
  `AGENT_NAME` varchar(255) NOT NULL COMMENT '终端名称',
  `AGENT_CODE` varchar(100) NOT NULL COMMENT '终端编号',
  `AGENT_IP` varchar(255) DEFAULT NULL COMMENT '终端IP',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `FIRST_HEARTBEAT_TIME` datetime DEFAULT NULL COMMENT '首次心跳时间',
  `START_TIME` datetime DEFAULT NULL COMMENT '开机时间',
  `END_TIME` datetime DEFAULT NULL COMMENT '关机时间',
  `CS_NO` varchar(50) DEFAULT NULL COMMENT '终端软件版本',
  `VOLUME` int(11) NOT NULL DEFAULT '20' COMMENT '音量',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`AGENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_AGENT
-- ----------------------------
INSERT INTO `T_AGENT` VALUES ('813252091525988352', null, 'wer', '12', null, null, null, '2016-12-26 17:13:25', '2016-12-26 13:44:28', null, '12', '1', null);
INSERT INTO `T_AGENT` VALUES ('813260769335443456', null, 'ert', '121', null, '2016-12-26 13:50:51', null, '2016-12-26 13:50:48', '2016-12-26 13:50:49', null, '12', '1', null);
INSERT INTO `T_AGENT` VALUES ('813378472599617536', '813270804908212224', 'er', '12', null, '2016-12-26 21:38:34', null, '2016-12-26 21:38:30', '2016-12-26 21:38:32', null, '12', '1', null);

-- ----------------------------
-- Table structure for T_AGENT_GROUP
-- ----------------------------
DROP TABLE IF EXISTS `T_AGENT_GROUP`;
CREATE TABLE `T_AGENT_GROUP` (
  `AGENT_GROUP_ID` bigint(20) NOT NULL COMMENT '�ն˷�����',
  `AGENT_GROUP_NAME` varchar(255) DEFAULT NULL COMMENT '�ն˷�����',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '״̬',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '��ע',
  PRIMARY KEY (`AGENT_GROUP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_AGENT_GROUP
-- ----------------------------
INSERT INTO `T_AGENT_GROUP` VALUES ('813270804908212224', 'test1', '1', null);

-- ----------------------------
-- Table structure for T_CONTENT_TYPE
-- ----------------------------
DROP TABLE IF EXISTS `T_CONTENT_TYPE`;
CREATE TABLE `T_CONTENT_TYPE` (
  `CONTENT_TYPE_ID` bigint(20) NOT NULL COMMENT '�������ͱ��',
  `CONTENT_TYPE_NAME` varchar(255) NOT NULL COMMENT '��������',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '״̬',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '��ע',
  PRIMARY KEY (`CONTENT_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_CONTENT_TYPE
-- ----------------------------
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177025686470656', '主题', '1', null);
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177199129329664', '栏目', '1', null);
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177290506436608', '视频', '1', null);
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177401869402112', '播放列表', '1', null);
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177514532601856', '字幕', '1', null);
INSERT INTO `T_CONTENT_TYPE` VALUES ('811177633478868992', '垫片', '1', null);

-- ----------------------------
-- Table structure for T_DIRECTORY
-- ----------------------------
DROP TABLE IF EXISTS `T_DIRECTORY`;
CREATE TABLE `T_DIRECTORY` (
  `DIRECTORY_ID` bigint(20) NOT NULL COMMENT '目录信息编号',
  `DIRECTORY_TYPE_ID` bigint(20) NOT NULL COMMENT '内容类型编号',
  `DIRECTORY_NAME` varchar(255) NOT NULL COMMENT '目录名称',
  `IS_ROOT` int(11) NOT NULL DEFAULT '1' COMMENT '是否根目录',
  `PATH_CODE` varchar(255) DEFAULT NULL COMMENT '目录编码',
  `PARENT_DIRECTORY_ID` bigint(20) DEFAULT NULL COMMENT '父级目录编号',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`DIRECTORY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_DIRECTORY
-- ----------------------------
INSERT INTO `T_DIRECTORY` VALUES ('813690895089008640', '1', 'test', '1', 'test', null, '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('813691412083113984', '1', 'well', '1', 'well', null, '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('813933487332524032', '1', 'ag', '0', 'ag', '813690895089008640', '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('813938128023715840', '1', 'ert', '0', 'ert', '813690895089008640', '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('813944641597472768', '1', 'yo', '1', 'yo', '813933487332524032', '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('813944679778222080', '1', 'asdf', '0', 'asdf', '813933487332524032', '1', null);
INSERT INTO `T_DIRECTORY` VALUES ('814000498418909184', '1', 'fg', '0', 'fg', '813691412083113984', '1', null);

-- ----------------------------
-- Table structure for T_DIRECTORY_TYPE
-- ----------------------------
DROP TABLE IF EXISTS `T_DIRECTORY_TYPE`;
CREATE TABLE `T_DIRECTORY_TYPE` (
  `DIRECTORY_TYPE_ID` bigint(20) NOT NULL COMMENT '目录类型编号',
  `DIRECTORY_TYPE_NAME` varchar(255) NOT NULL COMMENT '类型名称',
  `DISK` varchar(255) NOT NULL COMMENT '存放目录的盘符',
  `CODE` varchar(255) NOT NULL COMMENT '目录编码（用disk+code拼接）',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`DIRECTORY_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_DIRECTORY_TYPE
-- ----------------------------
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('1', '实例化主题', '/yunfiles', 'theme', '1', null);
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('2', '本地栏目', '/yunfiles', 'column', '1', null);
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('3', '本地广告', '/yunfiles', 'ad', '1', null);
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('4', '播单列表', '/yunfiles', 'playlist', '1', null);
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('5', '字幕', '/yunfiles', 'led', '1', null);
INSERT INTO `T_DIRECTORY_TYPE` VALUES ('6', '垫片', '/yunfiles', 'gaskets', '1', null);

-- ----------------------------
-- Table structure for T_FILE
-- ----------------------------
DROP TABLE IF EXISTS `T_FILE`;
CREATE TABLE `T_FILE` (
  `FILE_ID` bigint(20) NOT NULL COMMENT '文件信息编号',
  `DIRECTORY_ID` bigint(20) DEFAULT NULL COMMENT '目录编号',
  `FILE_TYPE_ID` bigint(20) NOT NULL COMMENT '文件类型编号',
  `FILE_NAME` varchar(255) NOT NULL COMMENT '文件名称',
  `DIRECTORY_PATH` varchar(255) DEFAULT NULL COMMENT '目录路径',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `POST_FINISH` int(11) DEFAULT NULL COMMENT '是否下发成功',
  `POST_FINISH_TIME` datetime DEFAULT NULL COMMENT '下发成功时间',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`FILE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_FILE
-- ----------------------------
INSERT INTO `T_FILE` VALUES ('814349124613701632', '813690895089008640', '1', 'Redis-x64-3.2.100.msi', 'E://home/', '2016-12-29 13:55:35', null, null, '1', null);
INSERT INTO `T_FILE` VALUES ('814351423390089216', '814000498418909184', '1', 'apache-tomcat-7.0.70-windows-x64 免安装版.zip', 'E://home/', '2016-12-29 14:04:43', null, null, '1', null);
INSERT INTO `T_FILE` VALUES ('814351617586364416', '813690895089008640', '1', 'apache-tomcat-7.0.70-windows-x64 免安装版.zip', 'E://home/', '2016-12-29 14:05:30', null, null, '1', null);
INSERT INTO `T_FILE` VALUES ('814377111094558720', '813933487332524032', '1', 'Redis-x64-3.2.100.msi', 'E://home/', '2016-12-29 15:46:48', null, null, '1', null);
INSERT INTO `T_FILE` VALUES ('814414810304217088', '813691412083113984', '1', 'Redis-x64-3.2.100.msi', 'E://home/', '2016-12-29 18:16:36', '2', null, '1', null);
INSERT INTO `T_FILE` VALUES ('814466402126659584', '814000498418909184', '1', 'Redis-x64-3.2.100.msi', 'E://home/', '2016-12-29 21:41:36', '2', null, '1', null);
INSERT INTO `T_FILE` VALUES ('814660576247545856', '813938128023715840', '1', 'Redis-x64-3.2.100.msi', 'E://home/', '2016-12-30 10:33:11', '2', null, '1', null);

-- ----------------------------
-- Table structure for T_FILE_TYPE
-- ----------------------------
DROP TABLE IF EXISTS `T_FILE_TYPE`;
CREATE TABLE `T_FILE_TYPE` (
  `FILE_TYPE_ID` bigint(20) NOT NULL COMMENT '文件类型编号',
  `FILE_TYPE_NAME` varchar(255) NOT NULL COMMENT '类型名称',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`FILE_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_FILE_TYPE
-- ----------------------------
INSERT INTO `T_FILE_TYPE` VALUES ('1', '主题', '1', null);
INSERT INTO `T_FILE_TYPE` VALUES ('2', '栏目', '1', null);
INSERT INTO `T_FILE_TYPE` VALUES ('3', '视频', '1', null);
INSERT INTO `T_FILE_TYPE` VALUES ('4', '播单', '1', null);
INSERT INTO `T_FILE_TYPE` VALUES ('5', '字幕', '1', null);
INSERT INTO `T_FILE_TYPE` VALUES ('6', '垫片', '1', null);

-- ----------------------------
-- Table structure for T_LOG
-- ----------------------------
DROP TABLE IF EXISTS `T_LOG`;
CREATE TABLE `T_LOG` (
  `LOG_ID` bigint(20) NOT NULL COMMENT '日志编号',
  `LOG_TYPE_ID` bigint(20) NOT NULL COMMENT '日志类型编号',
  `USER_ID` bigint(20) NOT NULL COMMENT '用户编号',
  `OPERATE_TIME` datetime NOT NULL COMMENT '操作时间',
  `REQUEST_URL` varchar(255) DEFAULT NULL COMMENT '请求路径',
  `RESPONSE_CODE` varchar(50) DEFAULT NULL COMMENT '响应的状态码',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`LOG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_LOG
-- ----------------------------
INSERT INTO `T_LOG` VALUES ('814099562481319936', '808953751040688128', '808949520158162944', '2016-12-28 21:23:55', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814278622805229568', '808953751040688128', '808949520158162944', '2016-12-29 09:15:26', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814282979722395648', '808953751040688128', '808949520158162944', '2016-12-29 09:32:45', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814283914687283200', '808953751040688128', '808949520158162944', '2016-12-29 09:36:28', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814285166833827840', '808953751040688128', '808949520158162944', '2016-12-29 09:41:27', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814290245284528128', '808953751040688128', '808949520158162944', '2016-12-29 10:01:37', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814297400335138816', '808953751040688128', '808949520158162944', '2016-12-29 10:30:03', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814303477801943040', '808953751040688128', '808949520158162944', '2016-12-29 10:54:12', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814316446392778752', '808953751040688128', '808949520158162944', '2016-12-29 11:45:44', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814335733325103104', '808953751040688128', '808949520158162944', '2016-12-29 13:02:23', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814337248114769920', '808953751040688128', '808949520158162944', '2016-12-29 13:08:24', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814346275049701376', '808953751040688128', '808949520158162944', '2016-12-29 13:44:16', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814347038148788224', '808953751040688128', '808949520158162944', '2016-12-29 13:47:18', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814347571857195008', '808953751040688128', '808949520158162944', '2016-12-29 13:49:25', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814347970953609216', '808953751040688128', '808949520158162944', '2016-12-29 13:51:00', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814348520348712960', '808953751040688128', '808949520158162944', '2016-12-29 13:53:11', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814349087406030848', '808953751040688128', '808949520158162944', '2016-12-29 13:55:26', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814350011864186880', '808953751040688128', '808949520158162944', '2016-12-29 13:59:07', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814350707384647680', '808953751040688128', '808949520158162944', '2016-12-29 14:01:53', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814369298993643520', '808953751040688128', '808949520158162944', '2016-12-29 15:15:45', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814369577357017088', '808953751040688128', '808949520158162944', '2016-12-29 15:16:52', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814370708787298304', '808953751040688128', '808949520158162944', '2016-12-29 15:21:21', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814371609648300032', '808953751040688128', '808949520158162944', '2016-12-29 15:24:56', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372571775500288', '808953751040688128', '808949520158162944', '2016-12-29 15:28:46', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814372591882993664', '808953871287189504', '808949520158162944', '2016-12-29 15:28:50', '/user/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372618290331648', '808953871287189504', '808949520158162944', '2016-12-29 15:28:57', '/agent/agentList/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372622312669184', '808953871287189504', '808949520158162944', '2016-12-29 15:28:58', '/agent/agentGroup/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372628360855552', '808953871287189504', '808949520158162944', '2016-12-29 15:28:59', '/log/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372683914412032', '808953871287189504', '808949520158162944', '2016-12-29 15:29:12', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372690390417408', '808953871287189504', '808949520158162944', '2016-12-29 15:29:14', '/cloudDisk/contentType/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814372973203947520', '808953871287189504', '808949520158162944', '2016-12-29 15:30:21', '/log/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373162505469952', '808953871287189504', '808949520158162944', '2016-12-29 15:31:06', '/user/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373174488596480', '808953871287189504', '808949520158162944', '2016-12-29 15:31:09', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373183917391872', '808953871287189504', '808949520158162944', '2016-12-29 15:31:12', '/cloudDisk/contentType/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373194252156928', '808953751040688128', '808949520158162944', '2016-12-29 15:31:14', '/loginIn.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373208043028480', '808953871287189504', '808949520158162944', '2016-12-29 15:31:17', '/agent/agentList/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373217488601088', '808953871287189504', '808949520158162944', '2016-12-29 15:31:20', '/agent/agentGroup/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373223394181120', '808953871287189504', '808949520158162944', '2016-12-29 15:31:21', '/log/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373229677248512', '808953871287189504', '808949520158162944', '2016-12-29 15:31:22', '/permission/user/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373241572294656', '808953871287189504', '808949520158162944', '2016-12-29 15:31:25', '/permission/role/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814373251139502080', '808953871287189504', '808949520158162944', '2016-12-29 15:31:28', '/permission/menu/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814376472687935488', '808953751040688128', '808949520158162944', '2016-12-29 15:44:16', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814376488441741312', '808953871287189504', '808949520158162944', '2016-12-29 15:44:19', '/user/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814376505818742784', '808953871287189504', '808949520158162944', '2016-12-29 15:44:24', '/cloudDisk/contentType/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814376855950852096', '808953751040688128', '808949520158162944', '2016-12-29 15:45:47', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814376866352726016', '808953871287189504', '808949520158162944', '2016-12-29 15:45:49', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814384233534455808', '808953871287189504', '808949520158162944', '2016-12-29 16:15:06', '/cloudDisk/contentType/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814395912158707712', '808953751040688128', '808949520158162944', '2016-12-29 17:01:30', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814395924485767168', '808953871287189504', '808949520158162944', '2016-12-29 17:01:33', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814411199142690816', '808953751040688128', '808949520158162944', '2016-12-29 18:02:15', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814411258143965184', '808953871287189504', '808949520158162944', '2016-12-29 18:02:29', '/permission/grant/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814411425211482112', '808953751040688128', '808949520158162944', '2016-12-29 18:03:09', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814411443595116544', '808953871287189504', '808949520158162944', '2016-12-29 18:03:13', '/release/history/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814411452734504960', '808953871287189504', '808949520158162944', '2016-12-29 18:03:16', '/release/push/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814411459151790080', '808953871287189504', '808949520158162944', '2016-12-29 18:03:17', '/release/history/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814411476751089664', '808953871287189504', '808949520158162944', '2016-12-29 18:03:21', '/release/push/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814414731958812672', '808953751040688128', '808949520158162944', '2016-12-29 18:16:17', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814414741312110592', '808953871287189504', '808949520158162944', '2016-12-29 18:16:20', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814414745942622208', '808953871287189504', '808949520158162944', '2016-12-29 18:16:21', '/cloudDisk/contentType/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814414750589911040', '808953871287189504', '808949520158162944', '2016-12-29 18:16:22', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814414822413172736', '808953871287189504', '808949520158162944', '2016-12-29 18:16:39', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814414841883131904', '808953871287189504', '808949520158162944', '2016-12-29 18:16:44', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814453248655097856', '808953751040688128', '808949520158162944', '2016-12-29 20:49:20', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814453654454009856', '808953871287189504', '808949520158162944', '2016-12-29 20:50:57', '/cloudDisk/content/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814453671617101824', '808953871287189504', '808949520158162944', '2016-12-29 20:51:01', '/log/page.html', '0', '0', null);
INSERT INTO `T_LOG` VALUES ('814456926870962176', '808953751040688128', '808949520158162944', '2016-12-29 21:03:57', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814456942889009152', '808953871287189504', '808949520158162944', '2016-12-29 21:04:01', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814456946668077056', '808953871287189504', '808949520158162944', '2016-12-29 21:04:02', '/cloudDisk/contentType/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814456959913689088', '808953871287189504', '808949520158162944', '2016-12-29 21:04:05', '/release/push/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814456978381209600', '808953871287189504', '808949520158162944', '2016-12-29 21:04:10', '/log/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814465843411812352', '808953751040688128', '808949520158162944', '2016-12-29 21:39:23', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814465862378455040', '808953871287189504', '808949520158162944', '2016-12-29 21:39:28', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814466340524916736', '808953751040688128', '808949520158162944', '2016-12-29 21:41:22', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814466355272089600', '808953871287189504', '808949520158162944', '2016-12-29 21:41:25', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814466422280290304', '808953871287189504', '808949520158162944', '2016-12-29 21:41:41', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658421830713344', '808953751040688128', '808949520158162944', '2016-12-30 10:24:38', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658430831689728', '808953871287189504', '808949520158162944', '2016-12-30 10:24:40', '/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658885854953472', '808953871287189504', '808949520158162944', '2016-12-30 10:26:28', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658890418356224', '808953871287189504', '808949520158162944', '2016-12-30 10:26:29', '/permission/menu/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658893979320320', '808953871287189504', '808949520158162944', '2016-12-30 10:26:30', '/permission/role/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658896865001472', '808953871287189504', '808949520158162944', '2016-12-30 10:26:31', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814658899729711104', '808953871287189504', '808949520158162944', '2016-12-30 10:26:31', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814659386227032064', '808953871287189504', '808949520158162944', '2016-12-30 10:28:27', '/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814659768399429632', '808953871287189504', '808949520158162944', '2016-12-30 10:29:59', '/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814660475324203008', '808953751040688128', '808949520158162944', '2016-12-30 10:32:47', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814660483863805952', '808953871287189504', '808949520158162944', '2016-12-30 10:32:49', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814660490058792960', '808953871287189504', '808949520158162944', '2016-12-30 10:32:51', '/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814660524435308544', '808953871287189504', '808949520158162944', '2016-12-30 10:32:59', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814661738812145664', '808953751040688128', '808949520158162944', '2016-12-30 10:37:48', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814661752963727360', '808953871287189504', '808949520158162944', '2016-12-30 10:37:52', '/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814662142799118336', '808953751040688128', '808949520158162944', '2016-12-30 10:39:25', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814662156992643072', '808953871287189504', '808949520158162944', '2016-12-30 10:39:28', '/permission/menu/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814662164332675072', '808953871287189504', '808949520158162944', '2016-12-30 10:39:30', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814715689188196352', '808953751040688128', '808949520158162944', '2016-12-30 14:12:11', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814715712231702528', '808953871287189504', '808949520158162944', '2016-12-30 14:12:17', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720118691987456', '808953751040688128', '808949520158162944', '2016-12-30 14:29:47', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720126774411264', '808953871287189504', '808949520158162944', '2016-12-30 14:29:49', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720141316063232', '808953871287189504', '808949520158162944', '2016-12-30 14:29:53', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720151504027648', '808953871287189504', '808949520158162944', '2016-12-30 14:29:55', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720822898851840', '808953751040688128', '808949520158162944', '2016-12-30 14:32:35', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720830238883840', '808953871287189504', '808949520158162944', '2016-12-30 14:32:37', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720834030534656', '808953871287189504', '808949520158162944', '2016-12-30 14:32:38', '/cloudDisk/contentType/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720845933969408', '808953871287189504', '808949520158162944', '2016-12-30 14:32:41', '/release/push/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720856088379392', '808953871287189504', '808949520158162944', '2016-12-30 14:32:43', '/release/push/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720856113545216', '808953871287189504', '808949520158162944', '2016-12-30 14:32:43', '/release/history/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720864174997504', '808953871287189504', '808949520158162944', '2016-12-30 14:32:45', '/agent/agentList/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720868008591360', '808953871287189504', '808949520158162944', '2016-12-30 14:32:46', '/agent/agentGroup/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720879547121664', '808953871287189504', '808949520158162944', '2016-12-30 14:32:49', '/log/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720889630228480', '808953871287189504', '808949520158162944', '2016-12-30 14:32:51', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720896613744640', '808953871287189504', '808949520158162944', '2016-12-30 14:32:53', '/permission/role/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720901076484096', '808953871287189504', '808949520158162944', '2016-12-30 14:32:54', '/permission/menu/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720913034444800', '808953871287189504', '808949520158162944', '2016-12-30 14:32:57', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814720923121745920', '808953871287189504', '808949520158162944', '2016-12-30 14:32:59', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814726443845025792', '808953751040688128', '808949520158162944', '2016-12-30 14:54:55', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814726456285331456', '808953871287189504', '808949520158162944', '2016-12-30 14:54:58', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814726621800955904', '808953871287189504', '808949520158162944', '2016-12-30 14:55:38', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731321287901184', '808953751040688128', '808949520158162944', '2016-12-30 15:14:18', '/loginIn.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731331899490304', '808953871287189504', '808949520158162944', '2016-12-30 15:14:21', '/cloudDisk/content/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731355844771840', '808953871287189504', '808949520158162944', '2016-12-30 15:14:26', '/release/push/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731365210652672', '808953871287189504', '808949520158162944', '2016-12-30 15:14:29', '/log/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731375318925312', '808953871287189504', '808949520158162944', '2016-12-30 15:14:31', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731378724700160', '808953871287189504', '808949520158162944', '2016-12-30 15:14:32', '/permission/role/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731383187439616', '808953871287189504', '808949520158162944', '2016-12-30 15:14:33', '/permission/menu/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731386807123968', '808953871287189504', '808949520158162944', '2016-12-30 15:14:34', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731398781861888', '808953871287189504', '808949520158162944', '2016-12-30 15:14:37', '/permission/user/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731423767330816', '808953871287189504', '808949520158162944', '2016-12-30 15:14:43', '/permission/grant/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731432516648960', '808953871287189504', '808949520158162944', '2016-12-30 15:14:45', '/agent/agentList/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731442482315264', '808953871287189504', '808949520158162944', '2016-12-30 15:14:47', '/release/push/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731445829369856', '808953871287189504', '808949520158162944', '2016-12-30 15:14:48', '/cloudDisk/contentType/page.html', '0', '1', null);
INSERT INTO `T_LOG` VALUES ('814731455073615872', '808953871287189504', '808949520158162944', '2016-12-30 15:14:50', '/user/page.html', '0', '1', null);

-- ----------------------------
-- Table structure for T_LOG_TYPE
-- ----------------------------
DROP TABLE IF EXISTS `T_LOG_TYPE`;
CREATE TABLE `T_LOG_TYPE` (
  `LOG_TYPE_ID` bigint(20) NOT NULL COMMENT '日志类型编号',
  `TYPE_NAME` varchar(255) NOT NULL COMMENT '日志类型名称',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`LOG_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_LOG_TYPE
-- ----------------------------
INSERT INTO `T_LOG_TYPE` VALUES ('808953751040688128', '登录日志', '1', '用户登录日志');
INSERT INTO `T_LOG_TYPE` VALUES ('808953871287189504', '操作记录日志', '1', '记录用户操作步骤');

-- ----------------------------
-- Table structure for T_MENU
-- ----------------------------
DROP TABLE IF EXISTS `T_MENU`;
CREATE TABLE `T_MENU` (
  `MENU_ID` bigint(20) NOT NULL COMMENT '菜单编号',
  `MENU_NAME` varchar(255) NOT NULL COMMENT '菜单名字',
  `PARENT_ID` bigint(20) DEFAULT NULL COMMENT '菜单父级编号',
  `MENU_URL` varchar(255) DEFAULT NULL COMMENT '菜单链接地址',
  `MENU_ICON` varchar(255) DEFAULT NULL COMMENT '菜单图标',
  `MENU_INDEX` int(11) NOT NULL DEFAULT '1' COMMENT '菜单显示顺序',
  `PERMISSION` varchar(255) DEFAULT NULL COMMENT '菜单权限',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_MENU
-- ----------------------------
INSERT INTO `T_MENU` VALUES ('809280468385005568', '用户管理', null, '', '**', '1', '', '1', '用户管理');
INSERT INTO `T_MENU` VALUES ('809290438698598400', '内容云盘', null, '', '适', '2', null, '1', '内容云盘管理');
INSERT INTO `T_MENU` VALUES ('809290653677649920', '内容发布', null, null, '之', '3', null, '1', '内容发布管理');
INSERT INTO `T_MENU` VALUES ('809290798087536640', '终端管理', null, null, '科', '4', null, '1', '终端管理');
INSERT INTO `T_MENU` VALUES ('809290899161874432', '日志管理', null, null, '技', '5', null, '1', '日志管理');
INSERT INTO `T_MENU` VALUES ('809291013486018560', '权限管理', null, null, '**', '6', null, '1', '权限管理');
INSERT INTO `T_MENU` VALUES ('809310811968241664', '用户信息', '809291013486018560', 'permission/user/page.html', null, '1', 'permission:user:page', '1', '权限管理之用户');
INSERT INTO `T_MENU` VALUES ('809339761310302208', '角色信息', '809291013486018560', 'permission/role/page.html', null, '2', 'permission:role:page', '1', '权限管理之角色');
INSERT INTO `T_MENU` VALUES ('809340358776324096', '菜单信息', '809291013486018560', 'permission/menu/page.html', null, '3', 'permission:menu:page', '1', '权限管理之菜单');
INSERT INTO `T_MENU` VALUES ('809748590816657408', '日志信息', '809290899161874432', 'log/page.html', null, '1', 'log:page', '1', null);
INSERT INTO `T_MENU` VALUES ('810016051986169856', '授权信息', '809291013486018560', 'permission/grant/page.html', null, '1', 'permission:grant:page', '1', null);
INSERT INTO `T_MENU` VALUES ('811552189750181888', '个人信息', '809280468385005568', '/user/page.html', null, '1', 'user:page', '1', null);
INSERT INTO `T_MENU` VALUES ('811869909595193344', '内容管理', '809290438698598400', '/cloudDisk/content/page.html', null, '1', 'cloudDisk:content:page', '1', null);
INSERT INTO `T_MENU` VALUES ('812261057765572608', '终端列表', '809290798087536640', '/agent/agentList/page.html', null, '1', 'agent:agentList:page', '1', null);
INSERT INTO `T_MENU` VALUES ('812261363291258880', '终端分组', '809290798087536640', '/agent/agentGroup/page.html', null, '2', 'agent:agentGroup:page', '1', null);
INSERT INTO `T_MENU` VALUES ('813278247167983616', '内容类型', '809290438698598400', '/cloudDisk/contentType/page.html', null, '2', 'cloudDisk:contentType:page', '1', null);
INSERT INTO `T_MENU` VALUES ('814353965553549312', '发布历史', '809290653677649920', '/release/history/page.html', null, '1', 'release:history:page', '1', null);
INSERT INTO `T_MENU` VALUES ('814354495977816064', '发布信息', '809290653677649920', '/release/push/page.html', null, '2', 'release:push:page', '1', null);

-- ----------------------------
-- Table structure for T_PUBLISH_HISTORY
-- ----------------------------
DROP TABLE IF EXISTS `T_PUBLISH_HISTORY`;
CREATE TABLE `T_PUBLISH_HISTORY` (
  `PUBLISH_HISTORY_ID` bigint(20) NOT NULL COMMENT '历史记录编号',
  `FILE_ID` bigint(20) NOT NULL COMMENT '文件编号',
  `AGENT_ID` bigint(20) NOT NULL DEFAULT '1' COMMENT '终端编号',
  `PUBLISH_TIME` datetime DEFAULT NULL COMMENT '发布时间',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`PUBLISH_HISTORY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_PUBLISH_HISTORY
-- ----------------------------

-- ----------------------------
-- Table structure for T_ROLE
-- ----------------------------
DROP TABLE IF EXISTS `T_ROLE`;
CREATE TABLE `T_ROLE` (
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色编号',
  `ROLE_NAME` varchar(255) NOT NULL COMMENT '角色名称',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_ROLE
-- ----------------------------
INSERT INTO `T_ROLE` VALUES ('809281289969467392', '系统管理员', '1', '');
INSERT INTO `T_ROLE` VALUES ('809694250722656256', '权限管理员', '1', null);
INSERT INTO `T_ROLE` VALUES ('809697588000325632', '日志管理员', '1', null);
INSERT INTO `T_ROLE` VALUES ('811102268043558912', '终端管理员', '1', null);
INSERT INTO `T_ROLE` VALUES ('812176318056628224', '内容管理员', '1', null);
INSERT INTO `T_ROLE` VALUES ('812253732514299904', '发布管理员', '1', null);
INSERT INTO `T_ROLE` VALUES ('813195349446361088', '测试', '1', null);

-- ----------------------------
-- Table structure for T_ROLE_MENU
-- ----------------------------
DROP TABLE IF EXISTS `T_ROLE_MENU`;
CREATE TABLE `T_ROLE_MENU` (
  `ROLE_MENU_ID` bigint(20) NOT NULL COMMENT '角色菜单编号',
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色编号',
  `MENU_ID` bigint(20) NOT NULL COMMENT '菜单编号',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ROLE_MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_ROLE_MENU
-- ----------------------------
INSERT INTO `T_ROLE_MENU` VALUES ('809281508635312128', '809281289969467392', '809280468385005568', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809291906839216128', '809281289969467392', '809290653677649920', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809291963013529600', '809281289969467392', '809290438698598400', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809292013118685184', '809281289969467392', '809290798087536640', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809292113442242560', '809281289969467392', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809292224901677056', '809281289969467392', '809291013486018560', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809315775092359168', '809281289969467392', '809310811968241664', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809340141129695232', '809281289969467392', '809339761310302208', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('809340291877175296', '809281289969467392', '809340358776324096', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('810016254478778368', '809281289969467392', '810016051986169856', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811116341917384704', '809281289969467392', '811099623417446400', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811116388876812288', '809281289969467392', '809748590816657408', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811116533492219904', '809281289969467392', '809749524149960704', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811116542442864640', '809281289969467392', '809749610070278144', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811567672683659264', '809281289969467392', '811552189750181888', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811777415985496064', '809748590816657408', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811801292321062912', '809748590816657408', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811802037699215360', '809748590816657408', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811802314892378112', '809748590816657408', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811802951696777216', '809748590816657408', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807377429889024', '809694250722656256', '809291013486018560', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807392994951168', '809694250722656256', '809310811968241664', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807399328350208', '809694250722656256', '809339761310302208', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807403283578880', '809694250722656256', '809340358776324096', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807407616294912', '809694250722656256', '810016051986169856', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807690580819968', '809697588000325632', '809290899161874432', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811807690618568704', '809697588000325632', '809748590816657408', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('811869980457959424', '809281289969467392', '811869909595193344', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('812258982411370496', '812253732514299904', '809290653677649920', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('812289325218660352', '809281289969467392', '812261057765572608', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('812289330667061248', '809281289969467392', '812261363291258880', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('813280233602940928', '809281289969467392', '813278247167983616', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('814411288569446400', '809281289969467392', '814353965553549312', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('814411293283844096', '809281289969467392', '814354495977816064', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('814720285625286656', '812176318056628224', '809290653677649920', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('814726566918488064', '812253732514299904', '814353965553549312', '1', null);
INSERT INTO `T_ROLE_MENU` VALUES ('814726577056120832', '812253732514299904', '814354495977816064', '1', null);

-- ----------------------------
-- Table structure for T_USER
-- ----------------------------
DROP TABLE IF EXISTS `T_USER`;
CREATE TABLE `T_USER` (
  `USER_ID` bigint(20) NOT NULL COMMENT '用户编号',
  `USER_NAME` varchar(50) NOT NULL COMMENT '用户名称',
  `USER_PASSWORD` varchar(255) NOT NULL COMMENT '用户密码',
  `EMAIL` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `USER_DIRECTORY` varchar(255) DEFAULT NULL COMMENT '用户目录',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_USER
-- ----------------------------
INSERT INTO `T_USER` VALUES ('808949520158162944', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin@163.com', 'admin', '1', '');
INSERT INTO `T_USER` VALUES ('809374762269671424', 'idiot', 'e10adc3949ba59abbe56e057f20f883e', 'idiotalex@163.com', 'idiot', '1', null);
INSERT INTO `T_USER` VALUES ('809375449502187520', 'alex', 'e10adc3949ba59abbe56e057f20f883e', 'alex@163.com', 'alex', '1', null);
INSERT INTO `T_USER` VALUES ('809376476934701056', 'wang', 'e10adc3949ba59abbe56e057f20f883e', '18716910170@163.com', 'wang', '1', null);
INSERT INTO `T_USER` VALUES ('812296235263197184', 'hah', 'e10adc3949ba59abbe56e057f20f883e', '123', '5', '1', null);

-- ----------------------------
-- Table structure for T_USER_AGENT_GROUP
-- ----------------------------
DROP TABLE IF EXISTS `T_USER_AGENT_GROUP`;
CREATE TABLE `T_USER_AGENT_GROUP` (
  `USER_AGENT_GROUP_ID` bigint(20) NOT NULL COMMENT '用户终端关系编号',
  `AGENT_GROUP_ID` bigint(20) NOT NULL COMMENT '终端分组编号',
  `USER_ID` bigint(20) NOT NULL COMMENT '用户编号',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`USER_AGENT_GROUP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_USER_AGENT_GROUP
-- ----------------------------

-- ----------------------------
-- Table structure for T_USER_ROLE
-- ----------------------------
DROP TABLE IF EXISTS `T_USER_ROLE`;
CREATE TABLE `T_USER_ROLE` (
  `USER_ROLE_ID` bigint(20) NOT NULL COMMENT '用户角色关系编号',
  `USER_ID` bigint(20) NOT NULL COMMENT '用户编号',
  `ROLE_ID` bigint(20) NOT NULL COMMENT '角色信息编号',
  `STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '状态',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`USER_ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of T_USER_ROLE
-- ----------------------------
INSERT INTO `T_USER_ROLE` VALUES ('811108448371474432', '808949520158162944', '809281289969467392', '1', null);
INSERT INTO `T_USER_ROLE` VALUES ('811199142192742400', '809374762269671424', '809697588000325632', '1', null);
INSERT INTO `T_USER_ROLE` VALUES ('811399947155931136', '809374762269671424', '809694250722656256', '1', null);
INSERT INTO `T_USER_ROLE` VALUES ('812179373548371968', '809374762269671424', '812176318056628224', '1', null);
INSERT INTO `T_USER_ROLE` VALUES ('812258884407263232', '809376476934701056', '812253732514299904', '1', null);
INSERT INTO `T_USER_ROLE` VALUES ('814715762852757504', '809375449502187520', '812176318056628224', '1', null);