gps/gps-service/lvye-admin-api/target/classes/sql/smart-admin.sql

-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.7.20-log - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  10.2.0.5670
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- 导出 ly-fms 的数据库结构
DROP DATABASE IF EXISTS `ly-fms`;
CREATE DATABASE IF NOT EXISTS `ly-fms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `ly-fms`;


DROP TABLE IF EXISTS `t_peony`;
CREATE TABLE IF NOT EXISTS `t_peony` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `kind` varchar(500) DEFAULT NULL COMMENT '品种',
  `name` varchar(500) DEFAULT NULL COMMENT '名字',
  `color` varchar(500) DEFAULT NULL COMMENT '颜色',
  `image_url` text COMMENT '图片链接',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='牡丹花';




INSERT INTO `t_peony` (`id`, `kind`, `name`, `color`, `image_url`, `create_time`, `update_time`) VALUES
	(5, '复色类', '什样锦', '红色', 'https://bkimg.cdn.bcebos.com/pic/3c6d55fbb2fb43160ee185da2aa4462308f7d390?x-bce-process=image/watermark,g_7,image_d2F0ZXIvYmFpa2UxNTA=,xp_5,yp_5', '2020-04-06 22:02:32', '2020-04-06 22:03:30'),
	(6, '绿色', '绿香球', '绿色', '11', '2020-04-06 22:14:35', '2020-04-06 22:17:51'),
	(7, '墨紫色类', '冠世墨玉', '紫色', '34534534534', '2020-04-06 22:15:19', '2020-04-06 22:18:21');

-- 导出  表 ly-fms.t_department 结构
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE IF NOT EXISTS `t_department` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '部门主键id',
  `name` varchar(50) NOT NULL COMMENT '部门名称',
  `short_name` varchar(50) DEFAULT NULL COMMENT '部门简称',
  `manager_id` int(10) unsigned DEFAULT NULL COMMENT '部门负责人id',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT '部门的父级id',
  `sort` int(10) NOT NULL COMMENT '部门排序',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';

-- 正在导出表  ly-fms.t_department 的数据：~20 rows (大约)
/*!40000 ALTER TABLE `t_department` DISABLE KEYS */;
INSERT INTO `t_department` (`id`, `name`, `short_name`, `manager_id`, `parent_id`, `sort`, `update_time`, `create_time`) VALUES
	(1, '1024创新实验室', 'ZWGWL', 16, 0, 1, '2019-04-03 10:41:25', '2019-04-03 10:41:25'),
	(2, '二级部门-2', NULL, 15, 1, 17, '2019-04-15 16:45:10', '2019-04-15 16:45:10'),
	(4, '二级部门-1', '管理', 14, 1, 20, '2019-04-17 16:14:55', '2019-04-17 16:14:55'),
	(8, '三级部门-1', NULL, NULL, 4, 8, '2019-04-25 12:25:52', '2019-04-25 12:25:52'),
	(9, '四级部门-1', NULL, NULL, 8, 9, '2019-04-25 12:26:36', '2019-04-25 12:26:36'),
	(10, '五级部门-1', NULL, NULL, 9, 10, '2019-04-25 12:26:49', '2019-04-25 12:26:49'),
	(11, '六级部门-1', NULL, NULL, 10, 11, '2019-04-25 12:26:59', '2019-04-25 12:26:59'),
	(12, '七级部门-1', NULL, NULL, 11, 12, '2019-04-25 12:27:18', '2019-04-25 12:27:18'),
	(13, '八级部门-1', NULL, NULL, 12, 13, '2019-04-25 12:27:34', '2019-04-25 12:27:34'),
	(14, '九级部门-1', NULL, NULL, 13, 14, '2019-04-25 12:27:47', '2019-04-25 12:27:47'),
	(15, '十级部门-1', NULL, NULL, 14, 15, '2019-04-25 12:28:16', '2019-04-25 12:28:16'),
	(16, '十一级部门部门部部门门嘻嘻哈哈-1', NULL, 13, 15, 16, '2019-04-25 14:56:40', '2019-04-25 14:56:40'),
	(17, '信息中心', NULL, 16, 1, 4, '2019-04-26 11:53:50', '2019-04-26 11:53:50'),
	(18, '测试部门', NULL, 16, 17, 18, '2019-04-26 11:54:06', '2019-04-26 11:54:06'),
	(19, '张娇测试', NULL, NULL, 2, 22, '2019-04-26 14:36:18', '2019-04-26 14:36:18'),
	(20, '子部门', NULL, NULL, 2, 23, '2019-04-26 14:36:28', '2019-04-26 14:36:28'),
	(22, '张静如', NULL, 16, 1, 2, '2019-04-28 14:21:44', '2019-04-28 14:21:44'),
	(23, '张静如2', NULL, 22, 4, 19, '2019-04-28 14:22:48', '2019-04-28 14:22:48'),
	(24, '测试', NULL, 18, 23, 24, '2019-04-29 10:12:42', '2019-04-29 10:12:42'),
	(25, '测试', NULL, 18, 23, 25, '2019-04-29 10:12:42', '2019-04-29 10:12:42');
/*!40000 ALTER TABLE `t_department` ENABLE KEYS */;

-- 导出  表 ly-fms.t_email 结构
DROP TABLE IF EXISTS `t_email`;
CREATE TABLE IF NOT EXISTS `t_email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
  `to_emails` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收件人',
  `send_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '发送状态 0未发送 1已发送',
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件内容',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_email 的数据：~56 rows (大约)
/*!40000 ALTER TABLE `t_email` DISABLE KEYS */;
INSERT INTO `t_email` (`id`, `title`, `to_emails`, `send_status`, `content`, `create_time`, `update_time`) VALUES
	(20, '新增测试12345', '新增测试@11.com', 1, '<p>这是内容</p>', '2019-08-30 15:35:12', '2019-08-30 15:35:12'),
	(21, 'b', 'asdf@33.com', 1, '<p>c</p>', '2019-09-06 14:25:33', '2019-09-06 14:25:33'),
	(23, 'string', 'string', 0, 'string', '2019-09-06 06:55:01', '2019-09-06 06:55:01'),
	(24, 'string', 'string', 0, 'string', '2019-09-06 06:55:01', '2019-09-06 06:55:01'),
	(26, 'string', 'string', 0, 'string', '2019-09-06 07:01:32', '2019-09-06 07:01:32'),
	(27, 'string', 'string', 0, 'string', '2019-09-06 07:01:32', '2019-09-06 07:01:32'),
	(37, 'ewqwe', '适者生存@22.cc', 1, '<p>qweqwe</p>', '2019-11-09 10:00:46', '2019-11-09 10:00:46'),
	(38, 'ewqwe', '适者生存@22.cc', 1, '<p>qweqwe</p>', '2019-11-09 10:00:49', '2019-11-09 10:00:49'),
	(39, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:54', '2019-11-09 10:04:54'),
	(40, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:57', '2019-11-09 10:04:57'),
	(41, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:57', '2019-11-09 10:04:57'),
	(42, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:58', '2019-11-09 10:04:58'),
	(43, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:59', '2019-11-09 10:04:59'),
	(44, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:59', '2019-11-09 10:04:59'),
	(45, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:05:16', '2019-11-09 10:05:16'),
	(46, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:06:29', '2019-11-09 10:06:29'),
	(47, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:07:02', '2019-11-09 10:07:02'),
	(48, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:07:16', '2019-11-09 10:07:16'),
	(49, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:13', '2019-11-09 10:08:13'),
	(50, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:30', '2019-11-09 10:08:30'),
	(51, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:50', '2019-11-09 10:08:50'),
	(52, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:09:09', '2019-11-09 10:09:09'),
	(53, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:09:31', '2019-11-09 10:09:31'),
	(54, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:12:24', '2019-11-09 10:12:24'),
	(55, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:13:13', '2019-11-09 10:13:13'),
	(56, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:20:42', '2019-11-09 10:20:42'),
	(57, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:20:52', '2019-11-09 10:20:52'),
	(58, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:16', '2019-11-09 10:21:16'),
	(59, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:24', '2019-11-09 10:21:24'),
	(60, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:30', '2019-11-09 10:21:30'),
	(61, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:53', '2019-11-09 10:21:53'),
	(62, 'a21312', '23423@qq.cc', 0, '<p>asdasdas</p>', '2019-11-09 10:23:40', '2019-11-09 10:23:40'),
	(63, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:12', '2019-11-15 15:35:12'),
	(64, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:15', '2019-11-15 15:35:15'),
	(65, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:16', '2019-11-15 15:35:16'),
	(66, 'eeee', '1234@qq.com', 0, '<p>&nbsp; &nbsp; eee2233<br></p>', '2019-11-15 17:00:00', '2019-11-15 17:00:00'),
	(67, 'eeee', '1234@qq.com', 0, '<p>&nbsp; &nbsp; eee2233<br></p>', '2019-11-15 17:00:03', '2019-11-15 17:00:03'),
	(68, 'eeee', '1234@qq.com', 0, '<p>&nbsp; &nbsp; eee2233<br></p>', '2019-11-15 17:00:04', '2019-11-15 17:00:04'),
	(69, '22223', '1017146812@qq.com', 0, '<p>&nbsp; &nbsp; e34233<br></p>', '2019-11-15 17:00:33', '2019-11-15 17:00:33'),
	(70, '22223', '1017146812@qq.com', 0, '<p>&nbsp; &nbsp; e34233<br></p>', '2019-11-15 17:00:34', '2019-11-15 17:00:34'),
	(71, '22223', '1017146812@qq.com', 0, '<p>&nbsp; &nbsp; e34233<br></p>', '2019-11-15 17:00:34', '2019-11-15 17:00:34'),
	(72, '22223', '12232', 0, '<p>&nbsp; &nbsp; e34233<br></p>', '2019-11-15 17:00:49', '2019-11-15 17:00:49'),
	(73, '22223', '12232@qq.com', 0, '<p>&nbsp; &nbsp; e34233<br></p>', '2019-11-15 17:00:56', '2019-11-15 17:00:56'),
	(74, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 08:51:44', '2019-11-16 08:51:44'),
	(75, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:05:10', '2019-11-16 09:05:10'),
	(76, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:05:14', '2019-11-16 09:05:14'),
	(77, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:06:34', '2019-11-16 09:06:34'),
	(78, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:09', '2019-11-16 09:07:09'),
	(79, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:30', '2019-11-16 09:07:30'),
	(80, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:32', '2019-11-16 09:07:32'),
	(81, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:08:29', '2019-11-16 09:08:29'),
	(82, 'sdfs', 'ss@ss.cc', 0, '<p>dsdsf</p>', '2019-11-16 09:08:46', '2019-11-16 09:08:46'),
	(83, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:18', '2019-11-16 09:09:18'),
	(84, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:42', '2019-11-16 09:09:42'),
	(85, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:46', '2019-11-16 09:09:46'),
	(86, 'dasdad', 'dasda@ss.cc', 1, '<p>dasasdas</p>', '2019-11-16 09:10:05', '2019-11-16 09:10:05');
/*!40000 ALTER TABLE `t_email` ENABLE KEYS */;

-- 导出  表 ly-fms.t_employee 结构
DROP TABLE IF EXISTS `t_employee`;
CREATE TABLE IF NOT EXISTS `t_employee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `login_name` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '登录帐号',
  `login_pwd` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '登录密码',
  `actual_name` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '员工名称',
  `nick_name` varchar(30) DEFAULT '' COMMENT '别名',
  `phone` varchar(15) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机号码',
  `id_card` varchar(18) CHARACTER SET utf8 DEFAULT NULL COMMENT '身份证',
  `birthday` date DEFAULT NULL COMMENT '出生日期',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `department_id` int(10) unsigned NOT NULL COMMENT '部门id',
  `is_leave` int(10) NOT NULL DEFAULT '0' COMMENT '是否离职1是',
  `is_disabled` int(10) NOT NULL DEFAULT '0' COMMENT '是否被禁用 0否1是',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_user` int(10) unsigned NOT NULL COMMENT '创建者id',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_delete` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除0否 1是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COMMENT='员工表';

-- 正在导出表  ly-fms.t_employee 的数据：~28 rows (大约)
/*!40000 ALTER TABLE `t_employee` DISABLE KEYS */;
INSERT INTO `t_employee` (`id`, `login_name`, `login_pwd`, `actual_name`, `nick_name`, `phone`, `id_card`, `birthday`, `email`, `department_id`, `is_leave`, `is_disabled`, `remark`, `create_user`, `update_time`, `create_time`, `is_delete`) VALUES
	(1, 'sa', 'c655798e4648c540812a1b8f48759af7', '管理员', '15515515515', '13112312131', '410306199202020020', '1992-02-02', NULL, 1, 0, 0, NULL, 0, '2019-04-27 09:56:17', '2018-05-11 09:38:54', 0),
	(11, 'role1', 'c655798e4648c540812a1b8f48759af7', '角色测试1', '', '18123245230', '', '1970-01-01', '', 4, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 12:30:22', 0),
	(12, 'role2', 'c655798e4648c540812a1b8f48759af7', '角色测试2', '', '18121451241', '', NULL, '', 4, 0, 0, NULL, 1, '2019-08-01 10:04:38', '2019-04-25 12:31:11', 0),
	(13, 'lihaifan', 'c655798e4648c540812a1b8f48759af7', 'lihaifan', '', '18399485774', '', NULL, '', 1, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 13:50:44', 0),
	(14, 'lipeng', 'c655798e4648c540812a1b8f48759af7', '李鹏1', '', '13937988294', '', NULL, '', 2, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 14:34:47', 0),
	(15, 'huangwenli', 'c655798e4648c540812a1b8f48759af7', '黄文丽', '', '15515515515', '', NULL, '', 16, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-26 10:05:05', 0),
	(16, 'huangwenli1', 'c655798e4648c540812a1b8f48759af7', '黄文丽', '', '15515515515', '', NULL, '', 15, 0, 0, NULL, 1, '2019-04-27 14:04:19', '2019-04-26 10:25:04', 0),
	(17, 'zhangjiao', 'c655798e4648c540812a1b8f48759af7', '张娇', '阿娇', '15670390391', '410305199102020020', '1991-02-02', '86484@qq.com', 19, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:37:23', 0),
	(18, 'zhangjiao1', 'c655798e4648c540812a1b8f48759af7', '张娇1', '', '15670390391', '', '2019-04-18', '6666@qq.com', 20, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:45:55', 0),
	(19, 'zhenxiaocang', 'c655798e4648c540812a1b8f48759af7', '珍小藏', '', '15670390391', '', NULL, '', 19, 0, 1, NULL, 1, '2019-09-09 08:34:35', '2019-04-26 14:46:57', 0),
	(20, 'matengfei', 'c655798e4648c540812a1b8f48759af7', '马腾飞', '', '15670390393', '', NULL, '', 19, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:47:24', 0),
	(21, 'ceshi123', 'c655798e4648c540812a1b8f48759af7', '测试人员', '', '18829938477', '', NULL, '', 1, 0, 1, NULL, 13, '2019-04-27 09:56:17', '2019-04-27 09:38:07', 1),
	(22, 'zhangjingru', 'c655798e4648c540812a1b8f48759af7', '张静如', '', '15600000000', '', NULL, '', 1, 0, 0, NULL, 1, '2019-09-04 09:06:47', '2019-04-28 14:05:03', 0),
	(23, 'sdfsdfdsfsdfdsfdsf', 'c655798e4648c540812a1b8f48759af7', 'werewr', '', '15698585858', '', NULL, '', 19, 0, 0, NULL, 1, '2019-09-05 16:13:03', '2019-04-28 16:26:27', 0),
	(25, 'shq2019', 'c655798e4648c540812a1b8f48759af7', 'shq', 'shq', '18798801298', '410281199309024040', '1993-09-02', '', 17, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-05-05 09:13:41', 0),
	(26, 'zhangjiao666', 'c655798e4648c540812a1b8f48759af7', 'tom我是五个字12', '', '15612345678', '', NULL, '', 18, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-05-05 15:34:10', 0),
	(28, 'dfsfgds', 'c655798e4648c540812a1b8f48759af7', 'fds', '', '15854127845', '', NULL, '', 22, 0, 1, NULL, 1, '2019-09-06 08:58:40', '2019-05-06 10:36:57', 0),
	(29, 'abcabc', 'c655798e4648c540812a1b8f48759af7', 'abccba', 'aaabac', '13311112222', '', NULL, '', 17, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-07-10 17:00:58', 0),
	(30, 'gengweigang', 'c655798e4648c540812a1b8f48759af7', '耿为刚', 'geng', '15038588418', '', NULL, '', 17, 0, 0, NULL, 1, '2019-08-08 14:35:51', '2019-08-08 14:35:51', 0),
	(31, 'gengweigang1', 'c655798e4648c540812a1b8f48759af7', '耿为刚1', '这是别名', '15038588418', '410322193312123232', '1933-12-12', '32@qq.com', 18, 0, 0, NULL, 30, '2019-08-23 09:27:22', '2019-08-23 09:25:50', 0),
	(32, 'ceshi123', 'c655798e4648c540812a1b8f48759af7', '测试', '测试', '15670702651', '', NULL, '', 17, 0, 0, NULL, 1, '2019-09-04 09:05:48', '2019-09-03 11:48:04', 0),
	(33, 'ceshi321', 'c655798e4648c540812a1b8f48759af7', '测试', '测试', '15670702651', '', NULL, '', 17, 0, 1, NULL, 1, '2019-09-03 15:51:16', '2019-09-03 11:49:17', 0),
	(34, 'ceshi123321', 'c655798e4648c540812a1b8f48759af7', '123', '', '15600000000', '', NULL, '', 22, 0, 1, NULL, 1, '2019-09-06 08:58:37', '2019-09-04 09:13:54', 0),
	(35, 'guoqingfeng', 'c655798e4648c540812a1b8f48759af7', '郭青枫', '', '15670702651', '', NULL, '', 18, 0, 0, NULL, 1, '2019-09-04 15:09:00', '2019-09-04 15:09:00', 0),
	(36, 'li327263458', 'c655798e4648c540812a1b8f48759af7', 'lipeng', '', '13937988294', '', NULL, '', 17, 0, 0, NULL, 1, '2019-09-09 17:01:39', '2019-09-09 17:01:39', 0),
	(37, 'test123', 'c655798e4648c540812a1b8f48759af7', 'test', '', '13211110201', '', NULL, '', 18, 0, 1, NULL, 1, '2019-11-14 16:08:08', '2019-11-08 09:32:39', 0),
	(38, 'tiantian', 'c655798e4648c540812a1b8f48759af7', '天天管理员', '', '13574502368', '', NULL, '', 17, 0, 0, NULL, 1, '2019-11-14 02:08:08', '2019-11-08 11:09:46', 0),
	(39, 'wang13211111', 'c655798e4648c540812a1b8f48759af7', 'ceshi111', 'dddd', '13244553212', '', NULL, '', 25, 0, 0, NULL, 38, '2019-11-15 17:14:34', '2019-11-15 17:03:04', 0);
/*!40000 ALTER TABLE `t_employee` ENABLE KEYS */;

-- 导出  表 ly-fms.t_file 结构
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE IF NOT EXISTS `t_file` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `module_id` varchar(50) NOT NULL COMMENT '相关业务id',
  `module_type` varchar(50) NOT NULL COMMENT '相关业务类型',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名称',
  `file_size` varchar(255) DEFAULT NULL COMMENT '文件大小',
  `file_type` varchar(50) DEFAULT NULL COMMENT '文件类型，程序中枚举控制，文件类型：如身份证正面，三证合一等等',
  `file_path` varchar(255) NOT NULL COMMENT '文件key，用于文件下载',
  `file_location_type` int(10) NOT NULL COMMENT '文件位置类型',
  `creater_user` int(10) NOT NULL COMMENT '创建人，即上传人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '上次更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `module_id_module_type` (`module_id`,`module_type`) USING BTREE,
  KEY `module_type` (`module_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- 正在导出表  ly-fms.t_file 的数据：~23 rows (大约)
/*!40000 ALTER TABLE `t_file` DISABLE KEYS */;
INSERT INTO `t_file` (`id`, `module_id`, `module_type`, `file_name`, `file_size`, `file_type`, `file_path`, `file_location_type`, `creater_user`, `update_time`, `create_time`) VALUES
	(1, '1', '1', '阿里云1.jpg', NULL, NULL, 'backUser/config/d1788b717be24f14ba526f25397b936f', 2, 1, NULL, '2019-07-05 10:38:15'),
	(2, '2', '1', '1.jpg', NULL, NULL, 'backUser/config/8895ec770c4e4e558c6d9b54eb00dffc', 2, 1, '2019-07-18 09:20:59', '2019-07-18 09:20:25'),
	(3, '3', '1', '随笔.txt', NULL, NULL, 'backUser/config/f5cbc4c9a56f4fa7ad0ba58b0aa5d169', 2, 1, NULL, '2019-07-18 09:22:47'),
	(4, '3', '1', '1.jpg', NULL, NULL, 'backUser/config/2019071809245603e0a4e449a4bf3aa28ee731c309040.jpg', 1, 1, NULL, '2019-07-18 09:24:51'),
	(6, '4', '1', '1.jpg', NULL, NULL, 'backUser/config/ddcb8214ba274dec9bb2c33e0e246391', 3, 1, NULL, '2019-07-19 16:19:43'),
	(7, '5', '1', 'sql.txt', NULL, NULL, 'backUser/config/cfbdf9562c894405b5b6f64f71fa812a', 3, 1, NULL, '2019-07-19 17:41:55'),
	(9, '1', '1', '20190912023241a6132f5713b54e1fb490f4ea88115747.md', NULL, NULL, 'backUser/config/20190912023241a6132f5713b54e1fb490f4ea88115747.md', 1, 1, '2019-09-12 15:25:35', '2019-09-12 14:32:42'),
	(10, '1', '1', '201909120232499804998573f643ff8e58189d23485629.mjs', NULL, NULL, 'backUser/config/201909120232499804998573f643ff8e58189d23485629.mjs', 1, 1, '2019-09-12 15:25:19', '2019-09-12 14:32:50'),
	(11, '1', '1', '201909120326564cdc8df7b8cc49cfb273926877f047f5.json', NULL, NULL, 'backUser/config/201909120326564cdc8df7b8cc49cfb273926877f047f5.json', 1, 1, NULL, '2019-09-12 15:26:56'),
	(12, '1', '1', '201909120343357104b7f1cc684f5797ada35c06aba770.json', NULL, NULL, 'backUser/config/201909120343357104b7f1cc684f5797ada35c06aba770.json', 1, 1, NULL, '2019-09-12 15:43:36'),
	(13, '1', '1', '201909120343427e408141a0ea467ea2e012f7086a6265.json', NULL, NULL, 'backUser/config/201909120343427e408141a0ea467ea2e012f7086a6265.json', 1, 1, NULL, '2019-09-12 15:43:42'),
	(14, '1', '1', '20190912034543b4d3a061fb2e416c899fe2ff6b9327e0.ts', NULL, NULL, 'backUser/config/20190912034543b4d3a061fb2e416c899fe2ff6b9327e0.ts', 1, 1, NULL, '2019-09-12 15:45:43'),
	(15, '1', '1', '20190912034550a5dc04ce79b14a1cb2bb76545c909aa8.md', NULL, NULL, 'backUser/config/20190912034550a5dc04ce79b14a1cb2bb76545c909aa8.md', 1, 1, NULL, '2019-09-12 15:45:51'),
	(16, '1', '1', 'LICENCE', NULL, NULL, 'backUser/config/cc02b99c0ec548f1a2231b70b7d569b8', 2, 1, NULL, '2019-09-12 15:47:22'),
	(17, '1', '1', 'bignumber.min.js', NULL, NULL, 'backUser/config/bda49e8ad6d242fe8735b2023dfbf125', 2, 1, NULL, '2019-09-12 15:47:29'),
	(18, '1', '1', '20190912034880a881fa8fbc841bfb7194ff312bd1058.json', NULL, NULL, 'backUser/config/20190912034880a881fa8fbc841bfb7194ff312bd1058.json', 1, 1, NULL, '2019-09-12 15:48:08'),
	(19, '1', '1', '20190912034816ece14084acf345a79396a0f4347c4e44.md', NULL, NULL, 'backUser/config/20190912034816ece14084acf345a79396a0f4347c4e44.md', 1, 1, NULL, '2019-09-12 15:48:16'),
	(20, '1', '1', '20191024054412fac4b4e04c574c6eab71f91e13a8a0b6.jpg', NULL, NULL, 'backUser/config/20191024054412fac4b4e04c574c6eab71f91e13a8a0b6.jpg', 1, 1, NULL, '2019-10-24 17:44:13'),
	(21, '1', '1', '20191106042073f7ef01bde3046bd8e01928f397230bd.jpg', NULL, NULL, 'backUser/config/20191106042073f7ef01bde3046bd8e01928f397230bd.jpg', 1, 1, NULL, '2019-11-06 02:20:13'),
	(22, '1', '1', '201911130802024b8a2ebf80543a98241bb464682650d.jpg', NULL, NULL, 'backUser/config/201911130802024b8a2ebf80543a98241bb464682650d.jpg', 1, 1, NULL, '2019-11-13 06:02:01'),
	(23, '1', '1', '20191113080210d1d98eea46364d268b2a03fa03f7a446.jpg', NULL, NULL, 'backUser/config/20191113080210d1d98eea46364d268b2a03fa03f7a446.jpg', 1, 1, NULL, '2019-11-13 06:02:14'),
	(24, '1', '1', '20191115043844e92b25e70fb140a1885614b978469ca9.jpg', NULL, NULL, 'backUser/config/20191115043844e92b25e70fb140a1885614b978469ca9.jpg', 1, 38, NULL, '2019-11-15 02:38:45'),
	(25, '1', '1', '20191116060546d3a2c703cb5546b3851612907cc3786f.png', NULL, NULL, 'backUser/config/20191116060546d3a2c703cb5546b3851612907cc3786f.png', 1, 1, NULL, '2019-11-16 10:05:47');
/*!40000 ALTER TABLE `t_file` ENABLE KEYS */;

-- 导出  表 ly-fms.t_heart_beat_record 结构
DROP TABLE IF EXISTS `t_heart_beat_record`;
CREATE TABLE IF NOT EXISTS `t_heart_beat_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `project_path` varchar(100) DEFAULT NULL COMMENT '项目名称',
  `server_ip` varchar(200) DEFAULT NULL COMMENT '服务器ip',
  `process_no` int(10) DEFAULT NULL COMMENT '进程号',
  `process_start_time` datetime DEFAULT NULL COMMENT '进程开启时间',
  `heart_beat_time` datetime DEFAULT NULL COMMENT '心跳时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- 正在导出表  ly-fms.t_heart_beat_record 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `t_heart_beat_record` DISABLE KEYS */;
INSERT INTO `t_heart_beat_record` (`id`, `project_path`, `server_ip`, `process_no`, `process_start_time`, `heart_beat_time`) VALUES
	(1, '/home/server/smart-admin/dev', '192.168.122.1;172.16.0.145', 14843, '2019-11-16 03:11:50', '2019-11-16 03:58:01'),
	(2, 'F:\\codespace\\idea\\gangquan360\\foundation', '172.16.1.188;192.168.56.1', 227992, '2019-11-16 10:02:39', '2019-11-16 10:06:50');
/*!40000 ALTER TABLE `t_heart_beat_record` ENABLE KEYS */;

-- 导出  表 ly-fms.t_id_generator 结构
DROP TABLE IF EXISTS `t_id_generator`;
CREATE TABLE IF NOT EXISTS `t_id_generator` (
  `id` int(11) DEFAULT NULL,
  `key_name` varchar(50) NOT NULL COMMENT '英文key',
  `rule_format` varchar(500) NOT NULL COMMENT '规则格式。no_cycle没有周期, year_cycle 年周期, month_cycle月周期, day_cycle 日周期',
  `rule_type` varchar(50) NOT NULL COMMENT '格式[yyyy]表示年,[mm]标识月,[dd]表示日,[nnn]表示三位数字',
  `init_number` int(11) NOT NULL DEFAULT '1' COMMENT '初始值',
  `last_number` int(11) DEFAULT NULL COMMENT '上次产生的id, 默认为空',
  `remark` varchar(1000) NOT NULL COMMENT '备注',
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime NOT NULL,
  UNIQUE KEY `key_name` (`key_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='id生成器定义表';

-- 正在导出表  ly-fms.t_id_generator 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `t_id_generator` DISABLE KEYS */;
INSERT INTO `t_id_generator` (`id`, `key_name`, `rule_format`, `rule_type`, `init_number`, `last_number`, `remark`, `update_time`, `create_time`) VALUES
	(2, 'goods_num', '[nnnnnnn]', 'NO_CYCLE', 1, NULL, '商品编号', '2019-04-09 09:48:04', '2019-03-29 14:14:12'),
	(1, 'order', '[yyyy][mm][dd][nnnnn]', 'DAY_CYCLE', 1, 1, '订单编号', '2019-03-30 11:25:42', '2019-03-29 14:14:12');
/*!40000 ALTER TABLE `t_id_generator` ENABLE KEYS */;

-- 导出  表 ly-fms.t_id_generator_record 结构
DROP TABLE IF EXISTS `t_id_generator_record`;
CREATE TABLE IF NOT EXISTS `t_id_generator_record` (
  `generator_id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `last_number` int(11) NOT NULL,
  PRIMARY KEY (`generator_id`,`year`,`month`,`day`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='id_generator记录表';

-- 正在导出表  ly-fms.t_id_generator_record 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `t_id_generator_record` DISABLE KEYS */;
INSERT INTO `t_id_generator_record` (`generator_id`, `year`, `month`, `day`, `last_number`) VALUES
	(1, 2019, 3, 30, 1),
	(2, 2019, 3, 30, 1),
	(2, 2019, 4, 3, 2),
	(2, 2019, 4, 8, 2),
	(2, 2019, 4, 9, 1);
/*!40000 ALTER TABLE `t_id_generator_record` ENABLE KEYS */;

-- 导出  表 ly-fms.t_notice 结构
DROP TABLE IF EXISTS `t_notice`;
CREATE TABLE IF NOT EXISTS `t_notice` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息标题',
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息内容',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态：0未删除 0删除 ',
  `send_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送状态 0未发送 1发送',
  `create_user` bigint(20) NOT NULL COMMENT '消息创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_notice 的数据：~14 rows (大约)
/*!40000 ALTER TABLE `t_notice` DISABLE KEYS */;
INSERT INTO `t_notice` (`id`, `title`, `content`, `deleted`, `send_status`, `create_user`, `create_time`, `update_time`) VALUES
	(93, '大扫把', '晓冬吃大便', 1, 1, 1, '2019-07-13 17:54:13', '2019-07-13 17:54:21'),
	(95, '4444444', '444444444444', 1, 1, 1, '2019-07-13 17:54:53', '2019-09-04 09:42:02'),
	(96, '3434', '444444', 1, 1, 1, '2019-07-13 17:58:42', '2019-11-08 09:05:24'),
	(97, '44444', '555555555555', 1, 1, 1, '2019-07-13 17:58:54', '2019-09-03 16:19:50'),
	(98, '《青花瓷》', '素胚勾勒出青花笔锋浓转淡\n瓶身描绘的牡丹一如你初妆\n冉冉檀香透过窗心事我了然\n周杰伦 青花瓷\n周杰伦 青花瓷\n宣纸上走笔至此搁一半\n釉色渲染仕女图韵味被私藏\n而你嫣然的一笑如含苞待放\n你的美一缕飘散\n去到我去不了的地方\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意\n色白花青的锦鲤跃然于碗底\n临摹宋体落款时却惦记着你\n你隐藏在窑烧里千年的秘密\n极细腻犹如绣花针落地\n篱外芭蕉惹骤雨门环惹铜绿\n而我路过那江南小镇惹了你\n在泼墨山水画里\n你从墨色深处被隐去\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意 ', 1, 1, 1, '2019-08-05 16:36:44', '2019-09-02 17:53:12'),
	(99, '1', '2', 1, 1, 30, '2019-08-08 14:53:58', '2019-08-08 14:54:07'),
	(100, '呵呵', '呵呵', 1, 1, 1, '2019-08-20 16:52:53', '2019-09-02 17:46:59'),
	(101, 'aa', 'bbcc', 1, 1, 30, '2019-08-23 09:51:01', '2019-08-23 09:51:28'),
	(102, '1', '2', 0, 1, 1, '2019-09-05 14:28:10', '2019-09-05 14:28:10'),
	(103, '12', '22', 0, 1, 1, '2019-09-05 14:29:30', '2019-09-05 14:29:30'),
	(104, 'a', 'b', 1, 1, 30, '2019-09-06 14:21:18', '2019-09-06 14:24:07'),
	(105, '22222222222', '1111', 0, 0, 1, '2019-11-07 19:05:56', '2019-11-07 19:05:56'),
	(106, '423', '234', 0, 0, 37, '2019-11-08 21:48:19', '2019-11-08 21:48:19'),
	(107, 'AAS', 's\'da\'ssdas', 1, 1, 1, '2019-11-13 19:06:55', '2019-11-14 09:07:06');
/*!40000 ALTER TABLE `t_notice` ENABLE KEYS */;

-- 导出  表 ly-fms.t_notice_receive_record 结构
DROP TABLE IF EXISTS `t_notice_receive_record`;
CREATE TABLE IF NOT EXISTS `t_notice_receive_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `notice_id` bigint(20) NOT NULL COMMENT '消息id',
  `employee_id` bigint(20) NOT NULL COMMENT '用户id',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_notice_receive_record 的数据：~27 rows (大约)
/*!40000 ALTER TABLE `t_notice_receive_record` DISABLE KEYS */;
INSERT INTO `t_notice_receive_record` (`id`, `notice_id`, `employee_id`, `create_time`, `update_time`) VALUES
	(114, 93, 1, '2019-07-13 17:54:16', '2019-07-13 17:54:16'),
	(115, 95, 1, '2019-07-13 17:54:55', '2019-07-13 17:54:55'),
	(116, 95, 22, '2019-07-13 17:58:03', '2019-07-13 17:58:03'),
	(117, 93, 22, '2019-07-13 17:58:05', '2019-07-13 17:58:05'),
	(118, 96, 1, '2019-07-13 17:58:44', '2019-07-13 17:58:44'),
	(119, 97, 1, '2019-07-13 17:58:58', '2019-07-13 17:58:58'),
	(120, 98, 1, '2019-08-05 16:37:01', '2019-08-05 16:37:01'),
	(121, 99, 30, '2019-08-08 14:54:05', '2019-08-08 14:54:05'),
	(122, 99, 1, '2019-08-08 15:15:44', '2019-08-08 15:15:44'),
	(123, 100, 1, '2019-08-20 16:53:29', '2019-08-20 16:53:29'),
	(124, 101, 30, '2019-08-23 09:51:11', '2019-08-23 09:51:11'),
	(125, 101, 1, '2019-08-23 12:46:27', '2019-08-23 12:46:27'),
	(126, 102, 1, '2019-09-05 14:28:32', '2019-09-05 14:28:32'),
	(127, 104, 30, '2019-09-06 14:23:58', '2019-09-06 14:23:58'),
	(128, 104, 1, '2019-09-06 15:25:13', '2019-09-06 15:25:13'),
	(129, 101, 14, '2019-11-02 21:46:13', '2019-11-02 21:46:13'),
	(130, 102, 14, '2019-11-02 21:46:14', '2019-11-02 21:46:14'),
	(131, 104, 14, '2019-11-02 21:46:15', '2019-11-02 21:46:15'),
	(132, 98, 14, '2019-11-02 21:46:18', '2019-11-02 21:46:18'),
	(133, 103, 37, '2019-11-07 19:58:06', '2019-11-07 19:58:06'),
	(134, 103, 1, '2019-11-07 20:03:54', '2019-11-07 20:03:54'),
	(135, 107, 1, '2019-11-13 19:07:02', '2019-11-13 19:07:02'),
	(136, 107, 38, '2019-11-15 02:11:04', '2019-11-15 02:11:04'),
	(137, 104, 38, '2019-11-15 02:11:17', '2019-11-15 02:11:17'),
	(138, 101, 38, '2019-11-15 02:26:33', '2019-11-15 02:26:33'),
	(139, 98, 38, '2019-11-15 02:29:32', '2019-11-15 02:29:32'),
	(140, 100, 38, '2019-11-15 03:19:18', '2019-11-15 03:19:18');
/*!40000 ALTER TABLE `t_notice_receive_record` ENABLE KEYS */;

-- 导出  表 ly-fms.t_order_operate_log 结构
DROP TABLE IF EXISTS `t_order_operate_log`;
CREATE TABLE IF NOT EXISTS `t_order_operate_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '各种单据的id',
  `order_type` int(11) NOT NULL COMMENT '单据类型',
  `operate_type` int(11) NOT NULL COMMENT '操作类型',
  `operate_content` text NOT NULL COMMENT '操作类型 对应的中文',
  `operate_remark` text COMMENT '操作备注',
  `employee_id` int(11) NOT NULL COMMENT '员工id',
  `employee_name` varchar(1000) NOT NULL COMMENT '员工名称',
  `ext_data` text COMMENT '额外信息',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `order_id_order_type` (`order_id`,`order_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='各种单据操作记录\r\n';

-- 正在导出表  ly-fms.t_order_operate_log 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `t_order_operate_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_order_operate_log` ENABLE KEYS */;

-- 导出  表 ly-fms.t_position 结构
DROP TABLE IF EXISTS `t_position`;
CREATE TABLE IF NOT EXISTS `t_position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `position_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '岗位名称',
  `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '岗位描述',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位表';

-- 正在导出表  ly-fms.t_position 的数据：~13 rows (大约)
/*!40000 ALTER TABLE `t_position` DISABLE KEYS */;
INSERT INTO `t_position` (`id`, `position_name`, `remark`, `update_time`, `create_time`) VALUES
	(1, 'java develop', 'java develop is good job', '2019-07-03 15:18:45', '2019-07-03 15:18:45'),
	(2, 'android develop', 'android develop is good job', '2019-07-04 16:11:11', '2019-07-04 16:11:00'),
	(3, '测试岗位1', '这是内容11', '2019-09-02 16:39:33', '2019-07-10 14:03:50'),
	(8, '测试岗位2', '测试岗位2.。', '2019-09-04 10:19:40', '2019-09-04 10:19:32'),
	(9, '测试岗位3', '测试岗位3', '2019-09-05 14:39:43', '2019-09-05 14:39:43'),
	(10, '测试岗位4', '测试岗位4', '2019-09-05 14:39:48', '2019-09-05 14:39:48'),
	(11, '测试岗位5', '测试岗位5', '2019-09-05 14:39:53', '2019-09-05 14:39:53'),
	(12, '测试岗位6', '测试岗位6', '2019-09-05 14:39:58', '2019-09-05 14:39:58'),
	(13, '测试岗位7', '测试岗位7', '2019-09-05 14:40:03', '2019-09-05 14:40:03'),
	(14, '测试岗位8', '测试岗位8', '2019-09-05 14:40:09', '2019-09-05 14:40:09'),
	(15, '测试岗位9', '测试岗位9', '2019-09-05 14:40:19', '2019-09-05 14:40:19'),
	(16, 'aaa22222', 'ddddddddddd', '2019-11-15 17:04:29', '2019-11-06 15:58:37'),
	(17, 'ddd', 'fsdef', '2019-11-15 17:04:40', '2019-11-15 17:04:40');
/*!40000 ALTER TABLE `t_position` ENABLE KEYS */;

-- 导出  表 ly-fms.t_position_relation 结构
DROP TABLE IF EXISTS `t_position_relation`;
CREATE TABLE IF NOT EXISTS `t_position_relation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `position_id` int(10) DEFAULT NULL COMMENT '岗位ID',
  `employee_id` int(10) DEFAULT NULL COMMENT '员工ID',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `job_id` (`position_id`) USING BTREE,
  KEY `employee_id` (`employee_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位关联表';

-- 正在导出表  ly-fms.t_position_relation 的数据：~27 rows (大约)
/*!40000 ALTER TABLE `t_position_relation` DISABLE KEYS */;
INSERT INTO `t_position_relation` (`id`, `position_id`, `employee_id`, `update_time`, `create_time`) VALUES
	(14, 1, 28, '2019-07-10 16:40:14', '2019-07-10 16:40:14'),
	(18, 1, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
	(19, 3, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
	(20, 2, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
	(21, 1, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
	(22, 2, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
	(23, 3, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
	(26, 2, 31, '2019-08-23 09:26:44', '2019-08-23 09:26:44'),
	(27, 3, 31, '2019-08-23 09:26:44', '2019-08-23 09:26:44'),
	(28, 3, 32, '2019-09-04 09:05:47', '2019-09-04 09:05:47'),
	(29, 2, 32, '2019-09-04 09:05:47', '2019-09-04 09:05:47'),
	(30, 3, 22, '2019-09-04 09:06:46', '2019-09-04 09:06:46'),
	(31, 2, 22, '2019-09-04 09:06:46', '2019-09-04 09:06:46'),
	(35, 8, 35, '2019-09-04 15:09:00', '2019-09-04 15:09:00'),
	(36, 3, 35, '2019-09-04 15:09:00', '2019-09-04 15:09:00'),
	(37, 15, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
	(38, 14, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
	(39, 13, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
	(40, 3, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
	(41, 2, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
	(42, 1, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
	(43, 14, 36, '2019-09-09 17:01:39', '2019-09-09 17:01:39'),
	(44, 3, 37, '2019-11-08 09:32:39', '2019-11-08 09:32:39'),
	(46, 8, 38, '2019-11-14 16:08:05', '2019-11-14 16:08:05'),
	(50, 16, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04'),
	(51, 13, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04'),
	(52, 14, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04');
/*!40000 ALTER TABLE `t_position_relation` ENABLE KEYS */;

-- 导出  表 ly-fms.t_privilege 结构
DROP TABLE IF EXISTS `t_privilege`;
CREATE TABLE IF NOT EXISTS `t_privilege` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '功能权限表主键id',
  `type` tinyint(11) NOT NULL COMMENT '1.菜单 2.功能点',
  `name` varchar(50) NOT NULL COMMENT '菜单名称',
  `key` varchar(1000) NOT NULL COMMENT '路由name 英文关键字',
  `url` text COMMENT '路由path/type=3为API接口',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `parent_key` varchar(1000) DEFAULT NULL COMMENT '父级key',
  `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`) USING BTREE,
  KEY `type` (`type`) USING BTREE,
  KEY `parent_key` (`parent_key`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COMMENT='权限功能表';

-- 正在导出表  ly-fms.t_privilege 的数据：~103 rows (大约)
/*!40000 ALTER TABLE `t_privilege` DISABLE KEYS */;
INSERT INTO `t_privilege` (`id`, `type`, `name`, `key`, `url`, `sort`, `parent_key`, `update_time`, `create_time`) VALUES
	(1, 1, '人员管理', 'Employee', '/employee', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(2, 1, '角色管理', 'RoleManage', '/employee/role', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(3, 1, '岗位管理', 'PositionList', '/employee/position', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(4, 1, '员工管理', 'RoleEmployeeManage', '/employee/role-employee-manage', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(5, 1, '系统设置', 'SystemSetting', '/system-setting', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(6, 1, '系统参数', 'SystemConfig', '/system-setting/system-config', 0, 'SystemSetting', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(8, 1, '菜单管理', 'SystemPrivilege', '/system-setting/system-privilege', 0, 'SystemSetting', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(9, 1, '消息管理', 'Notice', '/notice', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(10, 1, '通知管理', 'NoticeList', '/notice/notice-list', 0, 'Notice', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(11, 1, '个人消息', 'PersonNotice', '/notice/person-notice', 0, 'Notice', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(12, 1, '邮件管理', 'Email', '/email', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(13, 1, '邮件管理', 'EmailList', '/email/email-list', 0, 'Email', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(14, 1, '发送邮件', 'SendMail', '/email/send-mail', 0, 'Email', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(15, 1, '用户日志', 'UserLog', '/user-log', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(16, 1, '用户操作日志', 'UserOperateLog', '/user-log/user-operate-log', 0, 'UserLog', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(17, 1, '用户登录日志', 'UserLoginLog', '/user-log/user-login-log', 0, 'UserLog', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(18, 1, '系统监控', 'Monitor', '/monitor', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(19, 1, '在线人数', 'OnlineUser', '/monitor/online-user', 0, 'Monitor', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(20, 1, 'SQL监控', 'Sql', '/monitor/sql', 0, 'Monitor', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(21, 1, '定时任务', 'Task', '/task', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(22, 1, '任务管理', 'TaskList', '/system-setting/task-list', 0, 'Task', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(23, 1, '动态加载', 'Reload', '/reload', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(24, 1, 'SmartReload', 'SmartReloadList', '/reload/smart-reload-list', 0, 'Reload', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(25, 1, '接口文档', 'ApiDoc', '/api-doc', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(26, 1, 'Swagger接口文档', 'Swagger', '/api-doc/swagger', 0, 'ApiDoc', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(27, 1, '三级路由', 'ThreeRouter', '/three-router', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(28, 1, '三级菜单', 'LevelTwo', '/three-router/level-two', 0, 'ThreeRouter', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(29, 1, '三级A', 'RoleOneTwo', '/three-router/level-two/level-three1', 0, 'LevelTwo', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(30, 1, '三级B', 'RoleTwoTwo', '/three-router/level-two/level-three2', 0, 'LevelTwo', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(31, 1, '二级菜单', 'RoleOneOne', '/three-router/level-two2', 0, 'ThreeRouter', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(32, 1, 'KeepAlive', 'KeepAlive', '/keep-alive', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(33, 1, 'KeepAlive列表', 'KeepAliveContentList', '/keep-alive/content-list', 0, 'KeepAlive', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(34, 1, 'KeepAlive表单', 'KeepAliveAddContent', '/keep-alive/add-content', 0, 'KeepAlive', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(35, 1, '心跳服务', 'HeartBeat', '/heart-beat', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(36, 1, '心跳服务', 'HeartBeatList', '/heart-beat/heart-beat-list', 0, 'HeartBeat', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(37, 1, '文件服务', 'File', '/file', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(38, 1, '文件列表', 'FileList', '/file/file-list', 0, 'File', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
	(39, 2, '添加角色', 'add-role', 'roleController.addRole', 0, 'RoleManage', '2019-11-01 11:47:29', '2019-11-01 11:47:29'),
	(40, 2, '删除角色', 'delete-role', 'roleController.deleteRole', 1, 'RoleManage', '2019-11-01 11:47:43', '2019-11-01 11:47:43'),
	(41, 2, '编辑角色', 'update-role', 'roleController.updateRole', 2, 'RoleManage', '2019-11-01 11:47:55', '2019-11-01 11:47:55'),
	(42, 2, '修改角色权限', 'update-role-privilege', 'rolePrivilegeController.updateRolePrivilege', 3, 'RoleManage', '2019-11-01 11:48:09', '2019-11-01 11:48:09'),
	(43, 2, '添加成员', 'add-employee-role', 'roleEmployeeController.addEmployeeList', 4, 'RoleManage', '2019-11-05 10:38:11', '2019-11-05 10:38:11'),
	(44, 2, '查询成员', 'search-employee-list', 'roleEmployeeController.listAllEmployeeRoleId,roleEmployeeController.listEmployeeByName,roleController.getAllRole,rolePrivilegeController.listPrivilegeByRoleId', 7, 'RoleManage', '2019-11-05 10:39:04', '2019-11-05 10:39:04'),
	(45, 2, '移除成员', 'delete-employee-role', 'roleEmployeeController.removeEmployee', 5, 'RoleManage', '2019-11-05 10:40:09', '2019-11-05 10:40:09'),
	(46, 2, '批量移除', 'delete-employee-role-batch', 'roleEmployeeController.removeEmployeeList', 6, 'RoleManage', '2019-11-05 10:40:27', '2019-11-05 10:40:27'),
	(47, 2, '查询数据范围', 'query-data-scope', 'dataScopeController.dataScopeList,dataScopeController.dataScopeListByRole,rolePrivilegeController.listPrivilegeByRoleId,privilegeController.queryAll,privilegeController.getAllUrl', 8, 'RoleManage', '2019-11-05 10:40:57', '2019-11-05 10:40:57'),
	(48, 2, '更新数据范围', 'update-data-scope', 'dataScopeController.dataScopeBatchSet', 9, 'RoleManage', '2019-11-05 10:41:03', '2019-11-05 10:41:03'),
	(49, 2, '查询', 'search-position', 'positionController.queryJobById,positionController.getJobPage', 0, 'PositionList', '2019-11-05 10:41:30', '2019-11-05 10:41:30'),
	(50, 2, '添加', 'add-position', 'positionController.addJob', 1, 'PositionList', '2019-11-05 10:41:40', '2019-11-05 10:41:40'),
	(51, 2, '修改', 'update-position', 'positionController.updateJob', 2, 'PositionList', '2019-11-05 10:41:49', '2019-11-05 10:41:49'),
	(52, 2, '删除', 'delete-position', 'positionController.removeJob', 3, 'PositionList', '2019-11-05 10:41:57', '2019-11-05 10:41:57'),
	(53, 2, '添加部门', 'add-department', 'departmentController.addDepartment', 0, 'RoleEmployeeManage', '2019-11-05 11:11:18', '2019-11-05 11:11:18'),
	(54, 2, '编辑部门', 'update-department', 'departmentController.updateDepartment', 1, 'RoleEmployeeManage', '2019-11-05 11:11:29', '2019-11-05 11:11:29'),
	(55, 2, '删除部门', 'delete-department', 'departmentController.delDepartment', 2, 'RoleEmployeeManage', '2019-11-05 11:11:48', '2019-11-05 11:11:48'),
	(56, 2, '查询', 'search-department', 'departmentController.listAll,departmentController.getDepartment,departmentController.listDepartmentEmployee,departmentController.listDepartment,employeeController.query', 3, 'RoleEmployeeManage', '2019-11-05 11:12:09', '2019-11-05 11:12:09'),
	(57, 2, '添加成员', 'add-employee', 'employeeController.addEmployee', 4, 'RoleEmployeeManage', '2019-11-05 17:06:23', '2019-11-05 17:06:23'),
	(58, 2, '编辑成员', 'update-employee', 'employeeController.updateEmployee', 5, 'RoleEmployeeManage', '2019-11-05 17:06:57', '2019-11-05 17:06:57'),
	(59, 2, '禁用', 'disabled-employee', 'employeeController.updateStatus', 6, 'RoleEmployeeManage', '2019-11-05 17:14:35', '2019-11-05 17:14:35'),
	(60, 2, '批量操作', 'disabled-employee-batch', 'employeeController.batchUpdateStatus', 7, 'RoleEmployeeManage', '2019-11-05 17:19:23', '2019-11-05 17:19:23'),
	(61, 2, '员工角色编辑', 'update-employee-role', 'employeeController.updateRoles', 8, 'RoleEmployeeManage', '2019-11-05 17:21:15', '2019-11-05 17:21:15'),
	(62, 2, '重置密码', 'reset-employee-password', 'employeeController.resetPasswd', 10, 'RoleEmployeeManage', '2019-11-05 17:22:13', '2019-11-05 17:22:13'),
	(63, 2, '删除员工', 'delete-employee', 'employeeController.deleteEmployeeById', 9, 'RoleEmployeeManage', '2019-11-05 17:22:27', '2019-11-05 17:22:27'),
	(64, 2, '查询系统参数', 'system-params-search', 'systemConfigController.selectByKey,systemConfigController.getListByGroup,systemConfigController.getSystemConfigPage', 0, 'SystemConfig', '2019-11-05 17:23:41', '2019-11-05 17:23:41'),
	(65, 2, '添加系统参数', 'system-params-add', 'systemConfigController.addSystemConfig', 1, 'SystemConfig', '2019-11-05 17:26:00', '2019-11-05 17:26:00'),
	(66, 2, '修改系统参数', 'system-config-update', 'systemConfigController.updateSystemConfig', 2, 'SystemConfig', '2019-11-05 17:26:07', '2019-11-05 17:26:07'),
	(67, 2, '搜索系统参数', 'system-config-search', 'systemConfigController.selectByKey,systemConfigController.getListByGroup,systemConfigController.getSystemConfigPage', 3, 'SystemConfig', '2019-11-05 17:26:44', '2019-11-05 17:26:44'),
	(69, 2, '编辑', 'privilege-main-update', 'privilegeController.menuBatchSave,privilegeController.functionSaveOrUpdate', 0, 'SystemPrivilege', '2019-11-05 17:27:28', '2019-11-05 17:27:28'),
	(70, 2, '查询', 'privilege-main-search', 'privilegeController.queryAll,privilegeController.getAllUrl,privilegeController.functionQuery', 1, 'SystemPrivilege', '2019-11-05 17:28:45', '2019-11-05 17:28:45'),
	(71, 2, '查询', 'notice-query', 'noticeController.queryReceiveByPage,noticeController.queryUnreadByPage,noticeController.queryByPage,noticeController.detail', 0, 'NoticeList', '2019-11-05 17:30:16', '2019-11-05 17:30:16'),
	(72, 2, '添加', 'notice-add', 'noticeController.add', 1, 'NoticeList', '2019-11-05 17:30:28', '2019-11-05 17:30:28'),
	(73, 2, '修改', 'notice-edit', 'noticeController.update', 2, 'NoticeList', '2019-11-05 17:31:24', '2019-11-05 17:31:24'),
	(74, 2, '删除', 'notice-delete', 'noticeController.delete', 3, 'NoticeList', '2019-11-06 11:12:32', '2019-11-06 11:12:32'),
	(75, 2, '详情', 'notice-detail', 'noticeController.detail', 4, 'NoticeList', '2019-11-06 11:12:44', '2019-11-06 11:12:44'),
	(76, 2, '发送', 'notice-send', 'noticeController.send', 5, 'NoticeList', '2019-11-06 11:12:51', '2019-11-06 11:12:51'),
	(77, 2, '查询', 'person-notice-query', 'noticeController.queryReceiveByPage,noticeController.queryUnreadByPage,noticeController.queryByPage', 0, 'PersonNotice', '2019-11-06 11:13:27', '2019-11-06 11:13:27'),
	(78, 2, '详情', 'person-notice-detail', 'noticeController.detail', 1, 'PersonNotice', '2019-11-06 11:13:35', '2019-11-06 11:13:35'),
	(79, 2, '查询', 'email-query', 'emailController.queryByPage,emailController.detail', 0, 'EmailList', '2019-11-06 11:13:49', '2019-11-06 11:13:49'),
	(80, 2, '新增', 'email-add', 'emailController.add', 1, 'EmailList', '2019-11-06 11:14:02', '2019-11-06 11:14:02'),
	(81, 2, '编辑', 'email-update', 'emailController.update', 2, 'EmailList', '2019-11-06 11:14:08', '2019-11-06 11:14:08'),
	(82, 2, '删除', 'email-delete', 'emailController.delete', 3, 'EmailList', '2019-11-06 11:14:16', '2019-11-06 11:14:16'),
	(83, 2, '发送', 'email-send', 'emailController.send', 0, 'SendMail', '2019-11-06 11:14:40', '2019-11-06 11:14:40'),
	(84, 2, '查询', 'user-operate-log-search', 'userOperateLogController.queryByPage', 0, 'UserOperateLog', '2019-11-06 11:15:04', '2019-11-06 11:15:04'),
	(85, 2, '详情', 'user-operate-log-detail', 'userOperateLogController.detail', 1, 'UserOperateLog', '2019-11-06 11:15:16', '2019-11-06 11:15:16'),
	(86, 2, '删除', 'user-operate-log-delete', 'userOperateLogController.delete', 2, 'UserOperateLog', '2019-11-06 11:15:25', '2019-11-06 11:15:25'),
	(87, 2, '查询', 'user-login-log-search', 'userLoginLogController.queryByPage', 0, 'UserLoginLog', '2019-11-06 11:15:43', '2019-11-06 11:15:43'),
	(88, 2, '删除', 'user-login-log-delete', 'userLoginLogController.delete', 1, 'UserLoginLog', '2019-11-06 11:15:49', '2019-11-06 11:15:49'),
	(89, 2, '查询', 'online-user-search', 'userLoginLogController.queryUserOnLine', 0, 'OnlineUser', '2019-11-06 11:16:05', '2019-11-06 11:16:05'),
	(90, 2, '查询任务', 'task-search', 'quartzController.query', 0, 'TaskList', '2019-11-06 11:16:24', '2019-11-06 11:16:24'),
	(91, 2, '刷新任务', 'task-refresh', 'quartzController.query', 1, 'TaskList', '2019-11-06 11:16:50', '2019-11-06 11:16:50'),
	(92, 2, '添加任务', 'task-add', 'quartzController.saveOrUpdateTask', 2, 'TaskList', '2019-11-06 11:17:04', '2019-11-06 11:17:04'),
	(93, 2, '编辑任务', 'task-update', 'quartzController.saveOrUpdateTask', 3, 'TaskList', '2019-11-06 11:17:17', '2019-11-06 11:17:17'),
	(94, 2, '暂停任务', 'task-pause', 'quartzController.pauseTask', 4, 'TaskList', '2019-11-06 11:17:25', '2019-11-06 11:17:25'),
	(95, 2, '恢复任务', 'task-resume', 'quartzController.resumeTask', 5, 'TaskList', '2019-11-06 11:17:31', '2019-11-06 11:17:31'),
	(96, 2, '立即运行任务', 'task-run', 'quartzController.runTask', 6, 'TaskList', '2019-11-06 11:17:38', '2019-11-06 11:17:38'),
	(97, 2, '查看任务日志', 'task-query-log', 'quartzController.queryLog', 7, 'TaskList', '2019-11-06 11:17:47', '2019-11-06 11:17:47'),
	(98, 2, '删除任务', 'task-delete', 'quartzController.deleteTask', 8, 'TaskList', '2019-11-06 11:17:53', '2019-11-06 11:17:53'),
	(99, 2, '查询', 'smart-reload-search', 'smartReloadController.listAllReloadItem', 0, 'SmartReloadList', '2019-11-06 11:18:06', '2019-11-06 11:18:06'),
	(100, 2, '执行reload', 'smart-reload-update', 'smartReloadController.updateByTag', 1, 'SmartReloadList', '2019-11-06 11:18:14', '2019-11-06 11:18:14'),
	(101, 2, '查看执行结果', 'smart-reload-result', 'smartReloadController.queryReloadResult', 2, 'SmartReloadList', '2019-11-06 11:18:19', '2019-11-06 11:18:19'),
	(102, 2, '查询任务', 'heart-beat-query', 'heartBeatController.query', 0, 'HeartBeatList', '2019-11-06 11:18:38', '2019-11-06 11:18:38'),
	(103, 2, '查询', 'file-filePage-query', 'fileController.queryListByPage,fileController.localGetFile,fileController.downLoadById', 0, 'FileList', '2019-11-06 11:19:06', '2019-11-06 11:19:06'),
	(104, 2, '上传', 'file-filePage-upload', 'fileController.qiNiuUpload,fileController.localUpload,fileController.aliYunUpload,fileController.saveFile', 1, 'FileList', '2019-11-06 11:19:36', '2019-11-06 11:19:36'),
	(105, 2, '下载', 'file-filePage-download', 'fileController.downLoadById', 2, 'FileList', '2019-11-16 10:05:02', '2019-11-16 10:05:02');
/*!40000 ALTER TABLE `t_privilege` ENABLE KEYS */;

-- 导出  表 ly-fms.t_quartz_task 结构
DROP TABLE IF EXISTS `t_quartz_task`;
CREATE TABLE IF NOT EXISTS `t_quartz_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
  `task_bean` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'spring bean名称',
  `task_params` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务参数',
  `task_cron` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '运行cron表达式',
  `task_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '任务状态0:正常，1:暂停',
  `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_quartz_task 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `t_quartz_task` DISABLE KEYS */;
INSERT INTO `t_quartz_task` (`id`, `task_name`, `task_bean`, `task_params`, `task_cron`, `task_status`, `remark`, `update_time`, `create_time`) VALUES
	(9, '2312332', 'exampleTask', '21314', '*/5 * * * * ?', 1, NULL, '2019-09-06 14:41:55', '2019-04-19 15:24:26'),
	(13, '567', 'exampleTask', 'ads', '*/5 * * * * ?', 1, NULL, '2019-09-04 16:37:25', '2019-04-23 15:32:17'),
	(21, '11', 'exampleTask', '11', '*/5 * * * * ?', 1, NULL, '2019-09-04 16:37:30', '2019-04-26 17:29:21'),
	(22, '33', 'exampleTask', '333', '*/5 * * * * ?', 1, NULL, '2019-04-26 17:29:36', '2019-04-26 17:29:36'),
	(23, '1', 'exampleTask', '3', '*/5 * * * * ?', 0, NULL, '2019-09-05 17:21:12', '2019-04-26 17:29:50');
/*!40000 ALTER TABLE `t_quartz_task` ENABLE KEYS */;

-- 导出  表 ly-fms.t_quartz_task_log 结构
DROP TABLE IF EXISTS `t_quartz_task_log`;
CREATE TABLE IF NOT EXISTS `t_quartz_task_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL COMMENT '任务id',
  `task_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
  `task_params` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务参数',
  `process_status` tinyint(4) NOT NULL COMMENT '任务处理状态0:成功，1:失败',
  `process_duration` bigint(11) NOT NULL DEFAULT '0' COMMENT '运行时长',
  `process_log` text COLLATE utf8mb4_unicode_ci COMMENT '日志',
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '运行主机ip',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=732881 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_quartz_task_log 的数据：~11 rows (大约)
/*!40000 ALTER TABLE `t_quartz_task_log` DISABLE KEYS */;
INSERT INTO `t_quartz_task_log` (`id`, `task_id`, `task_name`, `task_params`, `process_status`, `process_duration`, `process_log`, `ip_address`, `update_time`, `create_time`) VALUES
	(732870, 9, '231233', '2131', 0, 5, NULL, '127.0.0.1', '2019-05-05 15:28:01', '2019-05-05 15:28:01'),
	(732871, 9, '231233', '2131', 0, 32, NULL, '172.16.0.145', '2019-05-05 15:54:40', '2019-05-05 15:54:40'),
	(732872, 22, '33', '333', 0, 31, NULL, '172.16.0.145', '2019-05-07 16:20:31', '2019-05-07 16:20:31'),
	(732873, 9, '231233', '2131', 0, 304, NULL, '172.16.0.145', '2019-08-02 09:29:36', '2019-08-02 09:29:36'),
	(732874, 9, '231233', '2131', 0, 24, NULL, '172.16.0.145', '2019-08-08 16:48:49', '2019-08-08 16:48:49'),
	(732875, 9, '231233', '2131', 0, 147, NULL, '172.16.0.145', '2019-08-23 09:41:08', '2019-08-23 09:41:08'),
	(732876, 9, '231233', '2131', 0, 610, NULL, '172.16.0.145', '2019-08-26 16:16:34', '2019-08-26 16:16:34'),
	(732877, 9, '2312332', '2131', 0, 27, NULL, '172.16.0.145', '2019-09-05 14:34:51', '2019-09-05 14:34:51'),
	(732878, 9, '2312332', '2131', 0, 5, NULL, '172.16.0.145', '2019-09-05 17:18:17', '2019-09-05 17:18:17'),
	(732879, 9, '2312332', '2131', 0, 1, NULL, '172.16.0.145', '2019-09-05 17:20:15', '2019-09-05 17:20:15'),
	(732880, 9, '2312332', '2131', 0, 5, NULL, '172.16.0.145', '2019-09-06 14:42:04', '2019-09-06 14:42:04');
/*!40000 ALTER TABLE `t_quartz_task_log` ENABLE KEYS */;

-- 导出  表 ly-fms.t_reload_item 结构
DROP TABLE IF EXISTS `t_reload_item`;
CREATE TABLE IF NOT EXISTS `t_reload_item` (
  `tag` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '项名称',
  `args` varchar(255) DEFAULT NULL COMMENT '参数 可选',
  `identification` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '运行标识',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 正在导出表  ly-fms.t_reload_item 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `t_reload_item` DISABLE KEYS */;
INSERT INTO `t_reload_item` (`tag`, `args`, `identification`, `update_time`, `create_time`) VALUES
	('system_config', '234', 'xxxx', '2019-11-14 16:46:21', '2019-04-18 11:48:27');
/*!40000 ALTER TABLE `t_reload_item` ENABLE KEYS */;

-- 导出  表 ly-fms.t_reload_result 结构
DROP TABLE IF EXISTS `t_reload_result`;
CREATE TABLE IF NOT EXISTS `t_reload_result` (
  `tag` varchar(255) NOT NULL,
  `identification` varchar(255) NOT NULL COMMENT '运行标识',
  `args` varchar(255) DEFAULT NULL,
  `result` tinyint(3) unsigned NOT NULL COMMENT '是否成功 ',
  `exception` text,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 正在导出表  ly-fms.t_reload_result 的数据：~126 rows (大约)
/*!40000 ALTER TABLE `t_reload_result` DISABLE KEYS */;
INSERT INTO `t_reload_result` (`tag`, `identification`, `args`, `result`, `exception`, `create_time`) VALUES
	('system_config', '23', '', 1, NULL, '2019-09-07 17:26:04'),
	('system_config', '23', '', 1, NULL, '2019-09-07 17:28:16'),
	('system_config', '23', '', 1, NULL, '2019-09-07 17:35:39'),
	('system_config', '23', '', 1, NULL, '2019-09-07 17:42:58'),
	('system_config', '23', '', 1, NULL, '2019-09-09 08:30:13'),
	('system_config', '23', '', 1, NULL, '2019-09-11 10:38:19'),
	('system_config', '23', '', 1, NULL, '2019-09-11 10:42:46'),
	('system_config', '23', '', 1, NULL, '2019-09-11 10:49:27'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:09:10'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:10:06'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:18:17'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:41:18'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:45:41'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:46:37'),
	('system_config', '23', '', 1, NULL, '2019-09-11 11:50:35'),
	('system_config', '23', '', 1, NULL, '2019-09-11 14:55:00'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:26:19'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:35:51'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:36:19'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:36:53'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:37:58'),
	('system_config', '23', '', 1, NULL, '2019-09-11 15:41:37'),
	('system_config', '23', '', 1, NULL, '2019-09-16 10:12:29'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:14:08'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:18:24'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:23:07'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:24:17'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:30:17'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:31:40'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:32:34'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:52:31'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:55:10'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:55:47'),
	('system_config', '23', '', 1, NULL, '2019-09-20 17:58:49'),
	('system_config', '23', '', 1, NULL, '2019-09-21 10:53:47'),
	('system_config', '23', '', 1, NULL, '2019-09-22 18:24:21'),
	('system_config', '23', '', 1, NULL, '2019-09-24 09:04:42'),
	('system_config', '23', '', 1, NULL, '2019-10-15 11:06:12'),
	('system_config', '23', '', 1, NULL, '2019-10-15 11:22:10'),
	('system_config', '23', '', 1, NULL, '2019-10-15 16:42:16'),
	('system_config', '23', '', 1, NULL, '2019-10-19 15:18:54'),
	('system_config', '23', '', 1, NULL, '2019-10-19 16:50:10'),
	('system_config', '23', '', 1, NULL, '2019-10-21 15:52:25'),
	('system_config', '23', '', 1, NULL, '2019-10-23 10:24:38'),
	('system_config', '23', '', 1, NULL, '2019-10-23 10:28:45'),
	('system_config', '23', '', 1, NULL, '2019-10-23 16:35:45'),
	('system_config', '23', '', 1, NULL, '2019-10-23 16:38:48'),
	('system_config', '23', '', 1, NULL, '2019-10-25 08:52:22'),
	('system_config', '23', '', 1, NULL, '2019-10-28 16:04:30'),
	('system_config', '23', '', 1, NULL, '2019-10-30 19:59:24'),
	('system_config', '23', '', 1, NULL, '2019-10-31 14:29:26'),
	('system_config', '23', '', 1, NULL, '2019-10-31 14:35:38'),
	('system_config', '23', '', 1, NULL, '2019-10-31 15:58:39'),
	('system_config', '23', '', 1, NULL, '2019-10-31 17:34:48'),
	('system_config', '23', '', 1, NULL, '2019-11-01 11:23:26'),
	('system_config', '23', '', 1, NULL, '2019-11-01 14:55:34'),
	('system_config', '23', '', 1, NULL, '2019-11-02 08:49:44'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:40:52'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:42:48'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:47:38'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:50:57'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:51:32'),
	('system_config', '23', '', 1, NULL, '2019-11-02 09:51:48'),
	('system_config', '23', '', 1, NULL, '2019-11-02 15:48:21'),
	('system_config', '23', '', 1, NULL, '2019-11-02 20:48:44'),
	('system_config', '23', '', 1, NULL, '2019-11-02 21:27:50'),
	('system_config', '23', '', 1, NULL, '2019-11-03 22:10:32'),
	('system_config', '23', '', 1, NULL, '2019-11-03 22:10:32'),
	('system_config', '23', '', 1, NULL, '2019-11-04 09:10:24'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-05 10:24:51'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:22:42'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:25:54'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:27:04'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:28:00'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:34:06'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:34:43'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:53:11'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:56:05'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 13:52:39'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 15:29:29'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:05:36'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:06:13'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:13:22'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:19:38'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:21:37'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:22:23'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-08 08:50:08'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-08 13:37:34'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 08:35:08'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 08:54:38'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:00:32'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:01:24'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:24:16'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:26:46'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:43:13'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:44:48'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 10:28:30'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-09 11:24:19'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-11 09:40:42'),
	('system_config', '23', '4234234', 1, NULL, '2019-11-13 17:25:42'),
	('system_config', '23343', '2423', 1, NULL, '2019-11-13 20:29:19'),
	('system_config', '23343', '2423', 1, NULL, '2019-11-13 20:29:23'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 11:43:57'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 11:50:18'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 11:51:13'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 11:52:03'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 11:53:02'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 13:49:11'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 13:51:05'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 13:53:53'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 13:55:57'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 16:15:44'),
	('system_config', '23343', '234', 1, NULL, '2019-11-14 16:39:36'),
	('system_config', '23343234234', '234', 1, NULL, '2019-11-14 16:41:05'),
	('system_config', '23343234234', '234', 1, NULL, '2019-11-14 16:41:05'),
	('system_config', 'aaaa', '234', 1, NULL, '2019-11-14 16:41:20'),
	('system_config', 'aaaa', '234', 1, NULL, '2019-11-14 16:41:25'),
	('system_config', '111', '234', 1, NULL, '2019-11-14 16:43:20'),
	('system_config', '111', '234', 1, NULL, '2019-11-14 16:44:13'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:46:26'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:46:39'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:48:47'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-15 14:39:55'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 08:47:43'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 17:12:10'),
	('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 18:02:57');
/*!40000 ALTER TABLE `t_reload_result` ENABLE KEYS */;

-- 导出  表 ly-fms.t_role 结构
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE IF NOT EXISTS `t_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` varchar(20) NOT NULL COMMENT '角色名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- 正在导出表  ly-fms.t_role 的数据：~14 rows (大约)
/*!40000 ALTER TABLE `t_role` DISABLE KEYS */;
INSERT INTO `t_role` (`id`, `role_name`, `remark`, `update_time`, `create_time`) VALUES
	(1, '管理员', '', '2019-06-21 12:09:34', '2019-06-21 12:09:34'),
	(34, '销售', '', '2019-08-30 09:30:50', '2019-08-30 09:30:50'),
	(35, '总经理', '', '2019-08-30 09:31:05', '2019-08-30 09:31:05'),
	(36, '董事长', '', '2019-08-30 09:31:11', '2019-08-30 09:31:11'),
	(37, '财务', '', '2019-08-30 09:31:16', '2019-08-30 09:31:16'),
	(38, '运营', '', '2019-08-30 09:31:22', '2019-08-30 09:31:22'),
	(40, '测试角色1', '测试角色1', '2019-09-05 15:05:38', '2019-09-05 15:05:38'),
	(41, '测试角色2', '测试角色2', '2019-09-05 15:05:43', '2019-09-05 15:05:43'),
	(42, '测试角色3', '测试角色3', '2019-09-05 15:05:49', '2019-09-05 15:05:49'),
	(43, '测试角色4', '测试角色4', '2019-09-05 15:05:56', '2019-09-05 15:05:56'),
	(45, '测试角色6', '测试角色6', '2019-09-05 15:06:06', '2019-09-05 15:06:06'),
	(46, '测试角色7', '测试角色7', '2019-09-05 15:06:18', '2019-09-05 15:06:18'),
	(47, '测试角色8', '测试角色8', '2019-09-05 15:06:25', '2019-09-05 15:06:25'),
	(48, '测试角色9', '测试角色9', '2019-11-15 17:06:11', '2019-09-05 15:06:30');
/*!40000 ALTER TABLE `t_role` ENABLE KEYS */;

-- 导出  表 ly-fms.t_role_data_scope 结构
DROP TABLE IF EXISTS `t_role_data_scope`;
CREATE TABLE IF NOT EXISTS `t_role_data_scope` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_scope_type` int(11) NOT NULL COMMENT '数据范围id',
  `view_type` int(11) NOT NULL COMMENT '数据范围类型',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_role_data_scope 的数据：~4 rows (大约)
/*!40000 ALTER TABLE `t_role_data_scope` DISABLE KEYS */;
INSERT INTO `t_role_data_scope` (`id`, `data_scope_type`, `view_type`, `role_id`, `update_time`, `create_time`) VALUES
	(5, 0, 2, 9, '2019-04-29 15:01:04', '2019-04-29 15:01:04'),
	(14, 0, 2, 40, '2019-09-05 15:25:37', '2019-09-05 15:25:37'),
	(15, 0, 0, 1, '2019-09-06 08:35:45', '2019-09-06 08:35:45'),
	(16, 0, 3, 34, '2019-11-06 16:08:02', '2019-11-06 16:08:02');
/*!40000 ALTER TABLE `t_role_data_scope` ENABLE KEYS */;

-- 导出  表 ly-fms.t_role_employee 结构
DROP TABLE IF EXISTS `t_role_employee`;
CREATE TABLE IF NOT EXISTS `t_role_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `employee_id` int(11) NOT NULL COMMENT '员工id',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4 COMMENT='角色员工功能表';

-- 正在导出表  ly-fms.t_role_employee 的数据：~25 rows (大约)
/*!40000 ALTER TABLE `t_role_employee` DISABLE KEYS */;
INSERT INTO `t_role_employee` (`id`, `role_id`, `employee_id`, `update_time`, `create_time`) VALUES
	(121, 38, 22, '2019-09-04 09:23:09', '2019-09-04 09:23:09'),
	(130, 1, 30, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(131, 1, 17, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(132, 1, 26, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(135, 1, 12, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(136, 1, 11, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(137, 1, 16, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(138, 1, 18, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(139, 1, 19, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(140, 1, 20, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(141, 1, 23, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
	(147, 1, 35, '2019-09-06 09:00:27', '2019-09-06 09:00:27'),
	(148, 40, 35, '2019-09-06 09:00:27', '2019-09-06 09:00:27'),
	(165, 40, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
	(166, 34, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
	(167, 38, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
	(168, 38, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
	(169, 40, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
	(170, 37, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
	(174, 38, 37, '2019-11-08 11:05:39', '2019-11-08 11:05:39'),
	(175, 42, 37, '2019-11-08 11:05:39', '2019-11-08 11:05:39'),
	(188, 1, 1, '2019-11-15 16:05:33', '2019-11-15 16:05:33'),
	(211, 40, 38, '2019-11-15 16:54:54', '2019-11-15 16:54:54'),
	(212, 34, 29, '2019-11-16 18:04:04', '2019-11-16 18:04:04'),
	(213, 45, 29, '2019-11-16 18:04:04', '2019-11-16 18:04:04');
/*!40000 ALTER TABLE `t_role_employee` ENABLE KEYS */;

-- 导出  表 ly-fms.t_role_privilege 结构
DROP TABLE IF EXISTS `t_role_privilege`;
CREATE TABLE IF NOT EXISTS `t_role_privilege` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `privilege_key` varchar(1000) NOT NULL COMMENT '权限key',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10835 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限功能表';

-- 正在导出表  ly-fms.t_role_privilege 的数据：~322 rows (大约)
/*!40000 ALTER TABLE `t_role_privilege` DISABLE KEYS */;
INSERT INTO `t_role_privilege` (`id`, `role_id`, `privilege_key`, `update_time`, `create_time`) VALUES
	(3506, 48, 'search-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3507, 48, 'add-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3508, 48, 'update-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3509, 48, 'delete-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3510, 48, 'add-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3511, 48, 'delete-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3512, 48, 'update-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3513, 48, 'update-role-privilege', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3514, 48, 'add-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3515, 48, 'delete-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3516, 48, 'delete-employee-role-batch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3517, 48, 'search-employee-list', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3518, 48, 'query-data-scope', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3519, 48, 'update-data-scope', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3520, 48, 'add-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3521, 48, 'update-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3522, 48, 'delete-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3523, 48, 'search-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3524, 48, 'add-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3525, 48, 'update-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3526, 48, 'delete-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3527, 48, 'disabled-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3528, 48, 'reset-employee-password', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3529, 48, 'set-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3530, 48, 'disabled-employee-batch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3531, 48, 'update-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3533, 48, 'system-params-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3534, 48, 'system-params-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3535, 48, 'system-config-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3536, 48, 'system-config-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3537, 48, 'privilegeMainSearch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3538, 48, 'privilegeMainUpdate', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3539, 48, 'task-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3540, 48, 'task-refresh', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3541, 48, 'task-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3542, 48, 'task-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3543, 48, 'task-pause', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3544, 48, 'task-resume', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3545, 48, 'task-run', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3546, 48, 'task-query-log', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3547, 48, 'task-delete', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3548, 48, 'systemCodeVersionsQuery', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3552, 48, 'roleOneTwo-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3555, 48, 'apiDocument', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3557, 48, 'reload', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3559, 48, 'smart-reload-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3560, 48, 'smart-reload-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3561, 48, 'smart-reload-result', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
	(3575, 45, 'task-search', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3576, 45, 'task-refresh', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3577, 45, 'task-add', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3578, 45, 'task-update', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3579, 45, 'task-pause', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3580, 45, 'task-resume', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3581, 45, 'task-run', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3582, 45, 'task-query-log', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3583, 45, 'task-delete', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3586, 45, 'add-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3587, 45, 'delete-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3588, 45, 'update-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3589, 45, 'update-role-privilege', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3590, 45, 'add-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3591, 45, 'delete-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3592, 45, 'delete-employee-role-batch', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3593, 45, 'search-employee-list', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3594, 45, 'query-data-scope', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3595, 45, 'update-data-scope', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3597, 45, 'search-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3598, 45, 'add-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3599, 45, 'update-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3600, 45, 'delete-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3602, 45, 'add-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3603, 45, 'set-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3604, 45, 'update-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3605, 45, 'delete-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3606, 45, 'search-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3607, 45, 'add-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3608, 45, 'update-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3609, 45, 'disabled-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3610, 45, 'disabled-employee-batch', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3611, 45, 'update-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3612, 45, 'delete-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(3613, 45, 'reset-employee-password', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
	(8112, 41, 'SystemSetting', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
	(8113, 41, 'SystemPrivilege', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
	(8114, 41, 'privilege-main-update', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
	(8115, 41, 'privilege-main-search', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
	(8549, 35, 'SystemSetting', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8550, 35, 'SystemConfig', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8551, 35, 'SystemPrivilege', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8552, 35, 'Notice', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8553, 35, 'NoticeList', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8554, 35, 'PersonNotice', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8555, 35, 'Email', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8556, 35, 'EmailList', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8557, 35, 'UserLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8558, 35, 'UserOperateLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8559, 35, 'UserLoginLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8560, 35, 'system-config-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8561, 35, 'privilege-main-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8562, 35, 'privilege-main-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8563, 35, 'notice-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8564, 35, 'notice-add', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8565, 35, 'notice-edit', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8566, 35, 'notice-delete', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8567, 35, 'person-notice-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8568, 35, 'person-notice-detail', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8569, 35, 'email-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8570, 35, 'email-add', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8571, 35, 'email-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8572, 35, 'user-operate-log-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8573, 35, 'user-login-log-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(8574, 35, 'system-config-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
	(9005, 37, 'SystemSetting', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
	(9006, 37, 'SystemConfig', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
	(9007, 37, 'system-params-search', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
	(9008, 37, 'system-params-add', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
	(9009, 37, 'system-config-update', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
	(9368, 34, 'SystemSetting', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9369, 34, 'SystemConfig', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9370, 34, 'SystemPrivilege', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9371, 34, 'system-params-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9372, 34, 'system-params-add', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9373, 34, 'privilege-main-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9374, 34, 'Task', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9375, 34, 'TaskList', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9376, 34, 'task-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9377, 34, 'task-refresh', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9378, 34, 'task-add', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9379, 34, 'task-update', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9380, 34, 'task-pause', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9381, 34, 'task-resume', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9382, 34, 'task-run', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9383, 34, 'task-query-log', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9384, 34, 'task-delete', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
	(9536, 42, 'Task', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9537, 42, 'TaskList', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9538, 42, 'task-search', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9539, 42, 'task-add', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9540, 42, 'task-update', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9541, 42, 'task-query-log', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
	(9674, 38, 'Employee', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9675, 38, 'PositionList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9676, 38, 'SystemSetting', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9677, 38, 'SystemConfig', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9678, 38, 'Notice', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9679, 38, 'PersonNotice', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9680, 38, 'Email', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9681, 38, 'EmailList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9682, 38, 'SendMail', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9683, 38, 'Monitor', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9684, 38, 'OnlineUser', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9685, 38, 'Task', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9686, 38, 'TaskList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9687, 38, 'KeepAlive', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9688, 38, 'KeepAliveContentList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9689, 38, 'HeartBeat', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9690, 38, 'HeartBeatList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9691, 38, 'File', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9692, 38, 'FileList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9693, 38, 'search-position', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9694, 38, 'system-params-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9695, 38, 'system-config-update', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9696, 38, 'system-config-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9697, 38, 'person-notice-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9698, 38, 'person-notice-detail', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9699, 38, 'email-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9700, 38, 'email-send', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9701, 38, 'online-user-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9702, 38, 'task-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9703, 38, 'heart-beat-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9704, 38, 'file-filePage-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9705, 38, 'file-filePage-upload', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(9706, 38, 'task-refresh', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
	(10585, 40, 'Employee', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10586, 40, 'RoleManage', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10587, 40, 'PositionList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10588, 40, 'RoleEmployeeManage', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10589, 40, 'SystemSetting', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10590, 40, 'SystemConfig', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10591, 40, 'SystemPrivilege', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10592, 40, 'Notice', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10593, 40, 'NoticeList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10594, 40, 'PersonNotice', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10595, 40, 'Email', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10596, 40, 'SendMail', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10597, 40, 'Task', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10598, 40, 'TaskList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10599, 40, 'add-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10600, 40, 'delete-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10601, 40, 'update-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10602, 40, 'update-role-privilege', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10603, 40, 'add-employee-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10604, 40, 'search-employee-list', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10605, 40, 'delete-employee-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10606, 40, 'delete-employee-role-batch', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10607, 40, 'query-data-scope', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10608, 40, 'update-data-scope', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10609, 40, 'search-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10610, 40, 'add-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10611, 40, 'update-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10612, 40, 'search-department', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10613, 40, 'system-params-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10614, 40, 'system-config-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10615, 40, 'privilege-main-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10616, 40, 'notice-query', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10617, 40, 'notice-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10618, 40, 'notice-edit', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10619, 40, 'notice-delete', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10620, 40, 'notice-detail', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10621, 40, 'notice-send', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10622, 40, 'person-notice-query', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10623, 40, 'email-send', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10624, 40, 'task-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10625, 40, 'task-refresh', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10626, 40, 'task-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10627, 40, 'task-update', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10628, 40, 'task-query-log', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10629, 40, 'task-delete', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10630, 40, 'delete-department', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
	(10733, 1, 'Employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10734, 1, 'RoleManage', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10735, 1, 'PositionList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10736, 1, 'RoleEmployeeManage', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10737, 1, 'SystemSetting', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10738, 1, 'SystemConfig', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10739, 1, 'SystemPrivilege', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10740, 1, 'Notice', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10741, 1, 'NoticeList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10742, 1, 'PersonNotice', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10743, 1, 'Email', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10744, 1, 'EmailList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10745, 1, 'SendMail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10746, 1, 'UserLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10747, 1, 'UserOperateLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10748, 1, 'UserLoginLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10749, 1, 'Monitor', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10750, 1, 'OnlineUser', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10751, 1, 'Sql', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10752, 1, 'Task', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10753, 1, 'TaskList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10754, 1, 'Reload', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10755, 1, 'SmartReloadList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10756, 1, 'ApiDoc', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10757, 1, 'Swagger', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10758, 1, 'ThreeRouter', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10759, 1, 'LevelTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10760, 1, 'RoleOneTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10761, 1, 'RoleTwoTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10762, 1, 'RoleOneOne', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10763, 1, 'KeepAlive', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10764, 1, 'KeepAliveContentList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10765, 1, 'KeepAliveAddContent', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10766, 1, 'HeartBeat', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10767, 1, 'HeartBeatList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10768, 1, 'File', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10769, 1, 'FileList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10770, 1, 'add-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10771, 1, 'delete-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10772, 1, 'update-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10773, 1, 'update-role-privilege', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10774, 1, 'add-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10775, 1, 'search-employee-list', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10776, 1, 'delete-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10777, 1, 'delete-employee-role-batch', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10778, 1, 'query-data-scope', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10779, 1, 'update-data-scope', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10780, 1, 'search-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10781, 1, 'add-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10782, 1, 'update-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10783, 1, 'delete-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10784, 1, 'add-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10785, 1, 'update-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10786, 1, 'delete-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10787, 1, 'search-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10788, 1, 'add-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10789, 1, 'update-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10790, 1, 'disabled-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10791, 1, 'disabled-employee-batch', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10792, 1, 'update-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10793, 1, 'reset-employee-password', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10794, 1, 'delete-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10795, 1, 'system-params-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10796, 1, 'system-params-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10797, 1, 'system-config-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10798, 1, 'system-config-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10799, 1, 'privilege-main-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10800, 1, 'privilege-main-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10801, 1, 'notice-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10802, 1, 'notice-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10803, 1, 'notice-edit', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10804, 1, 'notice-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10805, 1, 'notice-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10806, 1, 'notice-send', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10807, 1, 'person-notice-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10808, 1, 'person-notice-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10809, 1, 'email-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10810, 1, 'email-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10811, 1, 'email-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10812, 1, 'email-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10813, 1, 'email-send', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10814, 1, 'user-operate-log-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10815, 1, 'user-operate-log-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10816, 1, 'user-operate-log-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10817, 1, 'user-login-log-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10818, 1, 'user-login-log-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10819, 1, 'online-user-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10820, 1, 'task-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10821, 1, 'task-refresh', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10822, 1, 'task-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10823, 1, 'task-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10824, 1, 'task-pause', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10825, 1, 'task-resume', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10826, 1, 'task-run', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10827, 1, 'task-query-log', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10828, 1, 'task-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10829, 1, 'smart-reload-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10830, 1, 'smart-reload-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10831, 1, 'smart-reload-result', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10832, 1, 'heart-beat-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10833, 1, 'file-filePage-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
	(10834, 1, 'file-filePage-upload', '2019-11-16 18:04:10', '2019-11-16 18:04:10');
/*!40000 ALTER TABLE `t_role_privilege` ENABLE KEYS */;

-- 导出  表 ly-fms.t_system_config 结构
DROP TABLE IF EXISTS `t_system_config`;
CREATE TABLE IF NOT EXISTS `t_system_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `config_name` varchar(255) NOT NULL COMMENT '参数名字',
  `config_key` varchar(255) NOT NULL COMMENT '参数key',
  `config_value` text NOT NULL,
  `config_group` varchar(255) NOT NULL COMMENT '参数类别',
  `is_using` int(10) NOT NULL COMMENT '是否使用0 否 1 是',
  `remark` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次修改时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- 正在导出表  ly-fms.t_system_config 的数据：~8 rows (大约)
/*!40000 ALTER TABLE `t_system_config` DISABLE KEYS */;
INSERT INTO `t_system_config` (`id`, `config_name`, `config_key`, `config_value`, `config_group`, `is_using`, `remark`, `update_time`, `create_time`) VALUES
	(1, '超级管理员', 'employee_superman', '12,13,1', 'employee', 1, '123r8566456', '2019-11-14 16:40:48', '2018-08-18 16:28:03'),
	(13, '本地上传URL前缀', 'local_upload_url_prefix', 'http://172.16.0.145/smartAdmin/file/', 'upload', 1, '', '2019-09-04 16:23:49', '2019-04-26 17:06:53'),
	(14, '阿里云上传配置', 'ali_oss', '{"accessKeyId":"","accessKeySecret":"","bucketName":"sit","endpoint":"http://oss-cn-beijing.aliyuncs.com"}', 'upload', 1, 'eefwfwfds', '2019-11-16 18:04:30', '2019-05-11 18:00:06'),
	(15, '邮件发配置', 'email_config', '{"password":"smartadmin","smtpHost":"smtp.163.com","username":"smartadmin1024@163.com"}', 'email', 1, NULL, '2019-09-04 16:42:17', '2019-05-13 16:57:48'),
	(16, '七牛云上传配置', 'qi_niu_oss', '{"accessKeyId":"rX7HgY1ZLpUD25JrA-uwMM_jj-","accessKeySecret":"","bucketName":"sun-smart-admin","endpoint":"http://puvpyay08.bkt.clouddn.com"}', 'upload', 1, NULL, '2019-11-16 18:04:42', '2019-07-19 16:05:56'),
	(17, 'test', 'ww_1', 'ewr', '3', 1, 'testoo', '2019-11-08 09:43:36', '2019-11-08 09:27:19'),
	(18, '4234', '42342', '423423', '23423', 1, '423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111', '2019-11-14 14:58:39', '2019-11-14 11:22:49'),
	(19, 'test323@', 'test', '123456', '11_', 1, 'gggggg', '2019-11-15 16:24:52', '2019-11-15 16:24:52');
/*!40000 ALTER TABLE `t_system_config` ENABLE KEYS */;

-- 导出  表 ly-fms.t_user_login_log 结构
DROP TABLE IF EXISTS `t_user_login_log`;
CREATE TABLE IF NOT EXISTS `t_user_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '员工id',
  `user_name` varchar(50) NOT NULL COMMENT '用户名',
  `remote_ip` varchar(50) DEFAULT NULL COMMENT '用户ip',
  `remote_port` int(11) DEFAULT NULL COMMENT '用户端口',
  `remote_browser` varchar(100) DEFAULT NULL COMMENT '浏览器',
  `remote_os` varchar(50) DEFAULT NULL COMMENT '操作系统',
  `login_status` tinyint(4) NOT NULL COMMENT '登录状态 0 失败  1成功',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `customer_id` (`user_id`) USING BTREE,
  KEY `auditor_id` (`remote_browser`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1742 DEFAULT CHARSET=utf8mb4 COMMENT='用户登录日志';

-- 正在导出表  ly-fms.t_user_login_log 的数据：~122 rows (大约)
/*!40000 ALTER TABLE `t_user_login_log` DISABLE KEYS */;
INSERT INTO `t_user_login_log` (`id`, `user_id`, `user_name`, `remote_ip`, `remote_port`, `remote_browser`, `remote_os`, `login_status`, `update_time`, `create_time`) VALUES
	(1501, 30, '耿为刚', '172.16.1.234', 61406, 'Chrome', 'Windows 10', 1, '2019-09-06 14:19:47', '2019-09-06 14:19:47'),
	(1502, 30, '耿为刚', '172.16.1.234', 61405, 'Chrome', 'Windows 10', 1, '2019-09-06 14:20:46', '2019-09-06 14:20:46'),
	(1503, 30, '耿为刚', '172.16.1.234', 62213, 'Chrome', 'Windows 10', 1, '2019-09-06 14:28:50', '2019-09-06 14:28:50'),
	(1505, 30, '耿为刚', '172.16.1.234', 62478, 'Chrome', 'Windows 10', 1, '2019-09-06 14:32:57', '2019-09-06 14:32:57'),
	(1506, 1, '管理员', '127.0.0.1', 55613, 'Chrome', 'Windows 10', 1, '2019-09-06 14:35:48', '2019-09-06 14:35:48'),
	(1507, 1, '管理员', '172.16.1.234', 63132, 'Chrome', 'Windows 10', 1, '2019-09-06 14:38:43', '2019-09-06 14:38:43'),
	(1508, 30, '耿为刚', '172.16.1.234', 63132, 'Chrome', 'Windows 10', 1, '2019-09-06 14:41:36', '2019-09-06 14:41:36'),
	(1509, 1, '管理员', '172.16.1.234', 63332, 'Chrome', 'Windows 10', 1, '2019-09-06 14:42:37', '2019-09-06 14:42:37'),
	(1511, 1, '管理员', '172.16.1.166', 29923, 'Chrome', 'Windows 10', 1, '2019-09-06 15:09:22', '2019-09-06 15:09:22'),
	(1512, 1, '管理员', '172.16.1.113', 58150, 'Chrome', 'Windows 7', 1, '2019-09-06 15:23:31', '2019-09-06 15:23:31'),
	(1513, 1, '管理员', '172.16.1.166', 31226, 'Chrome', 'Windows 10', 1, '2019-09-06 15:24:51', '2019-09-06 15:24:51'),
	(1514, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:25:04', '2019-09-06 15:25:04'),
	(1515, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:25:26', '2019-09-06 15:25:26'),
	(1516, 1, '管理员', '172.16.1.166', 31243, 'Chrome', 'Windows 10', 1, '2019-09-06 15:25:29', '2019-09-06 15:25:29'),
	(1517, 1, '管理员', '172.16.1.221', 61458, 'Chrome', 'Windows 10', 1, '2019-09-06 15:27:07', '2019-09-06 15:27:07'),
	(1518, 1, '管理员', '172.16.1.166', 31243, 'Chrome', 'Windows 10', 1, '2019-09-06 15:27:09', '2019-09-06 15:27:09'),
	(1519, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:27:10', '2019-09-06 15:27:10'),
	(1520, 1, '管理员', '172.16.1.166', 31551, 'Chrome', 'Windows 10', 1, '2019-09-06 15:30:01', '2019-09-06 15:30:01'),
	(1521, 1, '管理员', '172.16.4.160', 50527, 'Chrome', 'Windows 10', 1, '2019-09-06 15:50:20', '2019-09-06 15:50:20'),
	(1522, 1, '管理员', '172.16.1.166', 36381, 'Chrome', 'Windows 10', 1, '2019-09-06 16:20:46', '2019-09-06 16:20:46'),
	(1523, 1, '管理员', '172.16.1.166', 40039, 'Chrome', 'Windows 10', 1, '2019-09-06 17:02:33', '2019-09-06 17:02:33'),
	(1524, 1, '管理员', '172.16.1.166', 41014, 'Chrome', 'Windows 10', 1, '2019-09-06 17:16:09', '2019-09-06 17:16:09'),
	(1525, 1, '管理员', '172.16.1.188', 56577, 'Chrome', 'Windows 7', 1, '2019-09-07 08:36:31', '2019-09-07 08:36:31'),
	(1526, 1, '管理员', '172.16.1.48', 60852, 'Chrome', 'Windows 10', 1, '2019-09-07 08:45:02', '2019-09-07 08:45:02'),
	(1527, 1, '管理员', '172.16.4.85', 4818, 'Chrome', 'Windows 10', 1, '2019-09-07 09:04:44', '2019-09-07 09:04:44'),
	(1528, 1, '管理员', '172.16.4.85', 5230, 'Chrome', 'Windows 10', 1, '2019-09-07 09:25:41', '2019-09-07 09:25:41'),
	(1529, 1, '管理员', '172.16.1.166', 10251, 'Chrome', 'Windows 10', 1, '2019-09-07 10:15:20', '2019-09-07 10:15:20'),
	(1530, 1, '管理员', '172.16.1.48', 63877, 'Chrome', 'Windows 10', 1, '2019-09-07 11:26:19', '2019-09-07 11:26:19'),
	(1531, 1, '管理员', '172.16.1.166', 26667, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:15', '2019-09-07 14:08:15'),
	(1532, 1, '管理员', '172.16.4.85', 10604, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:33', '2019-09-07 14:08:33'),
	(1533, 1, '管理员', '172.16.4.85', 10604, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:50', '2019-09-07 14:08:50'),
	(1534, 1, '管理员', '172.16.1.166', 26812, 'Chrome', 'Windows 10', 1, '2019-09-07 14:14:09', '2019-09-07 14:14:09'),
	(1535, 1, '管理员', '172.16.1.188', 52924, 'Chrome', 'Windows 7', 1, '2019-09-07 14:37:16', '2019-09-07 14:37:16'),
	(1536, 1, '管理员', '172.16.1.188', 56721, 'Chrome', 'Windows 7', 1, '2019-09-07 14:49:37', '2019-09-07 14:49:37'),
	(1537, 1, '管理员', '172.16.1.188', 52839, 'Chrome', 'Windows 7', 1, '2019-09-07 15:33:04', '2019-09-07 15:33:04'),
	(1538, 1, '管理员', '172.16.1.166', 32489, 'Chrome', 'Windows 10', 1, '2019-09-07 15:48:02', '2019-09-07 15:48:02'),
	(1539, 1, '管理员', '172.16.1.166', 32847, 'Chrome', 'Windows 10', 1, '2019-09-07 15:52:25', '2019-09-07 15:52:25'),
	(1540, 1, '管理员', '172.16.1.166', 33456, 'Chrome', 'Windows 10', 1, '2019-09-07 16:00:01', '2019-09-07 16:00:01'),
	(1541, 1, '管理员', '172.16.1.188', 61015, 'Chrome', 'Windows 7', 1, '2019-09-07 17:05:49', '2019-09-07 17:05:49'),
	(1542, 1, '管理员', '127.0.0.1', 51566, 'Chrome', 'Windows 7', 1, '2019-09-07 17:31:20', '2019-09-07 17:31:20'),
	(1543, 1, '管理员', '127.0.0.1', 54228, 'Chrome', 'Windows 7', 1, '2019-09-07 17:41:12', '2019-09-07 17:41:12'),
	(1544, 1, '管理员', '127.0.0.1', 54957, 'Chrome', 'Windows 7', 1, '2019-09-07 17:43:21', '2019-09-07 17:43:21'),
	(1545, 1, '管理员', '172.16.4.85', 2336, 'Chrome', 'Windows 10', 1, '2019-09-07 18:25:51', '2019-09-07 18:25:51'),
	(1546, 1, '管理员', '127.0.0.1', 52161, 'Chrome', 'Windows 7', 1, '2019-09-09 08:30:47', '2019-09-09 08:30:47'),
	(1547, 1, '管理员', '172.16.4.85', 5903, 'Chrome', 'Windows 10', 1, '2019-09-09 08:47:47', '2019-09-09 08:47:47'),
	(1548, 1, '管理员', '172.16.1.243', 55673, 'Chrome', 'Windows 10', 1, '2019-09-09 11:25:02', '2019-09-09 11:25:02'),
	(1549, 1, '管理员', '172.16.4.85', 4672, 'Chrome', 'Windows 10', 1, '2019-09-09 11:25:34', '2019-09-09 11:25:34'),
	(1550, 1, '管理员', '172.16.1.188', 61186, 'Chrome', 'Windows 7', 1, '2019-09-09 11:39:24', '2019-09-09 11:39:24'),
	(1551, 1, '管理员', '172.16.4.85', 3032, 'Chrome', 'Windows 10', 1, '2019-09-09 14:17:53', '2019-09-09 14:17:53'),
	(1552, 1, '管理员', '172.16.4.85', 5829, 'Chrome', 'Windows 10', 1, '2019-09-09 14:54:27', '2019-09-09 14:54:27'),
	(1553, 1, '管理员', '172.16.1.166', 23398, 'Chrome', 'Windows 10', 1, '2019-09-09 15:06:50', '2019-09-09 15:06:50'),
	(1554, 1, '管理员', '172.16.5.60', 61094, 'Chrome', 'Windows 10', 1, '2019-09-09 15:20:50', '2019-09-09 15:20:50'),
	(1555, 1, '管理员', '172.16.4.85', 10566, 'Chrome', 'Windows 10', 1, '2019-09-09 15:51:22', '2019-09-09 15:51:22'),
	(1556, 1, '管理员', '172.16.1.166', 32190, 'Chrome', 'Windows 10', 1, '2019-09-09 17:00:59', '2019-09-09 17:00:59'),
	(1557, 1, '管理员', '172.16.5.60', 54502, 'Chrome', 'Windows 10', 1, '2019-09-10 09:10:48', '2019-09-10 09:10:48'),
	(1558, 1, '管理员', '172.16.4.85', 10659, 'Chrome', 'Windows 10', 1, '2019-09-10 09:21:48', '2019-09-10 09:21:48'),
	(1559, 1, '管理员', '172.16.4.85', 3363, 'Chrome', 'Windows 10', 1, '2019-09-10 10:56:23', '2019-09-10 10:56:23'),
	(1560, 1, '管理员', '172.16.4.85', 4460, 'Chrome', 'Windows 10', 1, '2019-09-10 14:23:44', '2019-09-10 14:23:44'),
	(1561, 1, '管理员', '172.16.4.85', 7344, 'Chrome', 'Windows 10', 1, '2019-09-10 14:59:52', '2019-09-10 14:59:52'),
	(1562, 1, '管理员', '172.16.5.89', 49996, 'Chrome', 'Windows 10', 1, '2019-09-10 18:08:04', '2019-09-10 18:08:04'),
	(1563, 1, '管理员', '172.16.1.38', 50152, 'Chrome', 'Windows 10', 1, '2019-09-11 10:19:27', '2019-09-11 10:19:27'),
	(1564, 1, '管理员', '172.16.1.38', 50173, 'Chrome', 'Windows 10', 1, '2019-09-11 10:20:38', '2019-09-11 10:20:38'),
	(1565, 1, '管理员', '172.16.4.141', 60881, 'Chrome', 'Windows 10', 1, '2019-09-11 14:52:02', '2019-09-11 14:52:02'),
	(1566, 1, '管理员', '172.16.4.93', 52688, 'Chrome', 'Windows 10', 1, '2019-09-11 15:15:14', '2019-09-11 15:15:14'),
	(1567, 1, '管理员', '172.16.5.127', 54993, 'Chrome', 'Windows 10', 1, '2019-09-12 14:29:58', '2019-09-12 14:29:58'),
	(1568, 1, '管理员', '172.16.5.127', 57424, 'Chrome', 'Windows 10', 1, '2019-09-12 15:26:46', '2019-09-12 15:26:46'),
	(1569, 1, '管理员', '172.16.5.127', 58073, 'Chrome', 'Windows 10', 1, '2019-09-12 15:41:54', '2019-09-12 15:41:54'),
	(1570, 1, '管理员', '172.16.5.146', 63230, 'Chrome', 'Windows 10', 1, '2019-09-16 10:17:15', '2019-09-16 10:17:15'),
	(1571, 1, '管理员', '172.16.5.146', 52857, 'Chrome', 'Windows 10', 1, '2019-09-16 11:17:18', '2019-09-16 11:17:18'),
	(1572, 1, '管理员', '172.16.1.190', 64527, 'Chrome', 'Windows 10', 1, '2019-09-19 14:06:45', '2019-09-19 14:06:45'),
	(1573, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:33', '2019-09-20 17:24:33'),
	(1574, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:43', '2019-09-20 17:24:43'),
	(1575, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:59', '2019-09-20 17:24:59'),
	(1576, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:26:05', '2019-09-20 17:26:05'),
	(1577, 1, '管理员', '127.0.0.1', 60612, 'Chrome', 'Windows 7', 1, '2019-09-20 17:56:06', '2019-09-20 17:56:06'),
	(1578, 1, '管理员', '172.16.1.202', 58066, 'Chrome', 'Windows 7', 1, '2019-09-22 18:25:03', '2019-09-22 18:25:03'),
	(1579, 1, '管理员', '172.16.1.48', 52290, 'Chrome', 'Windows 10', 1, '2019-09-23 16:01:16', '2019-09-23 16:01:16'),
	(1580, 1, '管理员', '172.16.4.141', 60997, 'Chrome', 'Windows 10', 1, '2019-09-23 17:16:55', '2019-09-23 17:16:55'),
	(1581, 1, '管理员', '172.16.5.146', 53246, 'Chrome', 'Windows 10', 1, '2019-09-23 17:54:14', '2019-09-23 17:54:14'),
	(1582, 1, '管理员', '127.0.0.1', 51987, 'Chrome', 'Windows 7', 1, '2019-09-24 09:16:37', '2019-09-24 09:16:37'),
	(1583, 1, '管理员', '172.16.1.202', 55724, 'Chrome', 'Windows 7', 1, '2019-09-24 12:57:39', '2019-09-24 12:57:39'),
	(1584, 1, '管理员', '172.16.1.166', 51876, 'Chrome', 'Windows 10', 1, '2019-09-24 16:24:37', '2019-09-24 16:24:37'),
	(1585, 1, '管理员', '172.16.1.202', 51648, 'Chrome', 'Windows 7', 1, '2019-09-24 19:26:39', '2019-09-24 19:26:39'),
	(1586, 1, '管理员', '172.16.1.234', 60984, 'Chrome', 'Windows 10', 1, '2019-09-26 10:52:07', '2019-09-26 10:52:07'),
	(1587, 1, '管理员', '172.16.1.234', 63440, 'Chrome', 'Windows 10', 1, '2019-09-26 11:30:54', '2019-09-26 11:30:54'),
	(1588, 1, '管理员', '172.16.1.202', 51956, 'Chrome', 'Windows 7', 1, '2019-09-27 20:55:08', '2019-09-27 20:55:08'),
	(1589, 1, '管理员', '172.16.1.48', 56166, 'Chrome', 'Windows 10', 1, '2019-09-30 08:59:13', '2019-09-30 08:59:13'),
	(1590, 1, '管理员', '172.16.1.202', 51448, 'Chrome', 'Windows 7', 1, '2019-09-30 09:00:13', '2019-09-30 09:00:13'),
	(1591, 1, '管理员', '172.16.1.188', 62679, 'Chrome', 'Windows 7', 1, '2019-10-15 11:25:26', '2019-10-15 11:25:26'),
	(1592, 1, '管理员', '172.16.1.234', 54034, 'Chrome', 'Windows 10', 1, '2019-10-18 10:47:14', '2019-10-18 10:47:14'),
	(1593, 1, '管理员', '172.16.1.234', 64515, 'Chrome', 'Windows 10', 1, '2019-10-18 13:32:10', '2019-10-18 13:32:10'),
	(1594, 1, '管理员', '172.16.1.234', 50211, 'Chrome', 'Windows 10', 1, '2019-10-18 13:56:19', '2019-10-18 13:56:19'),
	(1595, 1, '管理员', '172.16.1.234', 55469, 'Chrome', 'Windows 10', 1, '2019-10-18 14:56:24', '2019-10-18 14:56:24'),
	(1596, 1, '管理员', '172.16.1.234', 56392, 'Chrome', 'Windows 10', 1, '2019-10-18 15:08:25', '2019-10-18 15:08:25'),
	(1597, 1, '管理员', '172.16.1.234', 60896, 'Chrome', 'Windows 10', 1, '2019-10-18 16:14:15', '2019-10-18 16:14:15'),
	(1598, 1, '管理员', '172.16.1.234', 50590, 'Chrome', 'Windows 10', 1, '2019-10-19 08:38:54', '2019-10-19 08:38:54'),
	(1599, 1, '管理员', '172.16.1.166', 4879, 'Chrome', 'Windows 10', 1, '2019-10-19 09:19:08', '2019-10-19 09:19:08'),
	(1600, 1, '管理员', '172.16.1.188', 62895, 'Chrome', 'Windows 7', 1, '2019-10-19 13:49:29', '2019-10-19 13:49:29'),
	(1601, 1, '管理员', '172.16.1.234', 58144, 'Chrome', 'Windows 10', 1, '2019-10-19 14:55:50', '2019-10-19 14:55:50'),
	(1602, 1, '管理员', '127.0.0.1', 61033, 'Chrome', 'Windows 7', 1, '2019-10-19 15:19:38', '2019-10-19 15:19:38'),
	(1603, 1, '管理员', '172.16.1.188', 58944, 'Chrome', 'Windows 7', 1, '2019-10-19 16:48:49', '2019-10-19 16:48:49'),
	(1604, 1, '管理员', '172.16.1.188', 63950, 'Chrome', 'Windows 7', 1, '2019-10-21 08:10:38', '2019-10-21 08:10:38'),
	(1605, 1, '管理员', '172.16.1.188', 64899, 'Chrome', 'Windows 7', 1, '2019-10-21 08:17:40', '2019-10-21 08:17:40'),
	(1606, 1, '管理员', '172.16.1.221', 53180, 'Chrome', 'Windows 10', 1, '2019-10-21 15:52:36', '2019-10-21 15:52:36'),
	(1607, 1, '管理员', '172.16.1.221', 56067, 'Chrome', 'Windows 10', 1, '2019-10-23 10:19:39', '2019-10-23 10:19:39'),
	(1608, 1, '管理员', '172.16.1.221', 57692, 'Chrome', 'Windows 10', 1, '2019-10-23 16:36:39', '2019-10-23 16:36:39'),
	(1609, 1, '管理员', '172.16.1.188', 57180, 'Chrome', 'Windows 7', 1, '2019-10-24 08:26:21', '2019-10-24 08:26:21'),
	(1610, 1, '管理员', '172.16.0.196', 61409, 'Chrome', 'Windows 10', 1, '2019-10-24 08:26:55', '2019-10-24 08:26:55'),
	(1611, 1, '管理员', '172.16.1.234', 51906, 'Chrome', 'Windows 10', 1, '2019-10-24 15:56:50', '2019-10-24 15:56:50'),
	(1612, 1, '管理员', '172.16.1.234', 56793, 'Chrome', 'Windows 10', 1, '2019-10-24 17:04:54', '2019-10-24 17:04:54'),
	(1613, 30, '耿为刚', '172.16.1.234', 60368, 'Chrome', 'Windows 10', 1, '2019-10-24 17:51:13', '2019-10-24 17:51:13'),
	(1614, 1, '管理员', '172.16.1.234', 60368, 'Chrome', 'Windows 10', 1, '2019-10-24 17:51:56', '2019-10-24 17:51:56'),
	(1615, 30, '耿为刚', '172.16.1.234', 60589, 'Chrome 65', 'Windows 10', 1, '2019-10-24 17:52:52', '2019-10-24 17:52:52'),
	(1616, 1, '管理员', '172.16.1.234', 52998, 'Chrome', 'Windows 10', 1, '2019-10-25 09:28:13', '2019-10-25 09:28:13'),
	(1617, 1, '管理员', '172.16.1.234', 54948, 'Chrome', 'Windows 10', 1, '2019-10-25 10:01:34', '2019-10-25 10:01:34'),
	(1618, 1, '管理员', '172.16.1.234', 56800, 'Chrome', 'Windows 10', 1, '2019-10-25 10:32:53', '2019-10-25 10:32:53'),
	(1619, 1, '管理员', '127.0.0.1', 59071, 'Chrome', 'Windows 7', 1, '2019-10-28 16:05:21', '2019-10-28 16:05:21'),
	(1620, 1, '管理员', '127.0.0.1', 60106, 'Chrome', 'Windows 7', 1, '2019-10-28 16:11:29', '2019-10-28 16:11:29'),
	(1621, 1, '管理员', '127.0.0.1', 63479, 'Chrome', 'Windows 7', 1, '2019-10-28 16:28:59', '2019-10-28 16:28:59'),
	(1622, 1, '管理员', '127.0.0.1', 63479, 'Chrome', 'Windows 7', 1, '2019-10-28 16:29:55', '2019-10-28 16:29:55'),
	(1623, 1, '管理员', '127.0.0.1', 57588, 'Chrome', 'Windows 7', 1, '2019-10-29 15:37:03', '2019-10-29 15:37:03'),
	(1741, 1, '管理员', '127.0.0.1', 54621, 'Chrome', 'Windows 7', 1, '2019-11-16 18:03:45', '2019-11-16 18:03:45');
/*!40000 ALTER TABLE `t_user_login_log` ENABLE KEYS */;

-- 导出  表 ly-fms.t_user_operate_log 结构
DROP TABLE IF EXISTS `t_user_operate_log`;
CREATE TABLE IF NOT EXISTS `t_user_operate_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名称',
  `module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作模块',
  `content` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作内容',
  `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求路径',
  `method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求方法',
  `param` text COLLATE utf8mb4_unicode_ci COMMENT '请求参数',
  `result` tinyint(4) DEFAULT NULL COMMENT '请求结果 0失败 1成功',
  `fail_reason` longtext COLLATE utf8mb4_unicode_ci COMMENT '失败原因',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 正在导出表  ly-fms.t_user_operate_log 的数据：~32 rows (大约)
/*!40000 ALTER TABLE `t_user_operate_log` DISABLE KEYS */;
INSERT INTO `t_user_operate_log` (`id`, `user_id`, `user_name`, `module`, `content`, `url`, `method`, `param`, `result`, `fail_reason`, `update_time`, `create_time`) VALUES
	(1, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/0', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[0]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(2, 1, '管理员', '管理端-角色', '获取所有角色', '/smart-admin-api/role/getAll', 'com.gangquan360.smartadmin.module.role.basic.RoleController.getAllRole', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(3, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/1', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[1]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(4, 1, '管理员', '管理端-岗位', '分页查询所有岗位', '/smart-admin-api/position/getListPage', 'com.gangquan360.smartadmin.module.position.PositionController.getJobPage', 'PositionQueryDTO[{"pageNum":1,"pageSize":10,"positionName":"","searchCount":true,"sort":false}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(5, 1, '管理员', '管理端-角色', '获取所有角色', '/smart-admin-api/role/getAll', 'com.gangquan360.smartadmin.module.role.basic.RoleController.getAllRole', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(6, 1, '管理员', '管理端-部门', '根据部门名称查询部门及员工列表', '/smart-admin-api/department/listEmployeeByDepartmentName', 'com.gangquan360.smartadmin.module.department.DepartmentController.listDepartmentEmployee', 'String[""]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(7, 1, '管理员', '管理端-部门', '查询部门及员工列表', '/smart-admin-api/department/listEmployee', 'com.gangquan360.smartadmin.module.department.DepartmentController.listDepartmentEmployee', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(8, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(9, 1, '管理员', '管理端-用户', '员工重置密码', '/smart-admin-api/employee/resetPasswd/29', 'com.gangquan360.smartadmin.module.employee.EmployeeController.resetPasswd', 'Integer[29]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(10, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(11, 1, '管理员', '管理端-角色用户', '通过员工id获取所有角色以及员工具有的角色', '/smart-admin-api/role/getRoles/29', 'com.gangquan360.smartadmin.module.role.roleemployee.RoleEmployeeController.getRoleByEmployeeId', 'Long[29]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(12, 1, '管理员', '管理端-用户', '单个员工角色授权', '/smart-admin-api/employee/updateRoles', 'com.gangquan360.smartadmin.module.employee.EmployeeController.updateRoles', 'EmployeeUpdateRolesDTO[{"employeeId":29,"roleIds":[34,45]}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(13, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(14, 1, '管理员', '管理端-角色权限', '更新角色权限', '/smart-admin-api/privilege/updateRolePrivilege', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.updateRolePrivilege', 'RolePrivilegeDTO[{"privilegeKeyList":["Employee","RoleManage","PositionList","RoleEmployeeManage","SystemSetting","SystemConfig","SystemPrivilege","Notice","NoticeList","PersonNotice","Email","EmailList","SendMail","UserLog","UserOperateLog","UserLoginLog","Monitor","OnlineUser","Sql","Task","TaskList","Reload","SmartReloadList","ApiDoc","Swagger","ThreeRouter","LevelTwo","RoleOneTwo","RoleTwoTwo","RoleOneOne","KeepAlive","KeepAliveContentList","KeepAliveAddContent","HeartBeat","HeartBeatList","File","FileList","add-role","delete-role","update-role","update-role-privilege","add-employee-role","search-employee-list","delete-employee-role","delete-employee-role-batch","query-data-scope","update-data-scope","search-position","add-position","update-position","delete-position","add-department","update-department","delete-department","search-department","add-employee","update-employee","disabled-employee","disabled-employee-batch","update-employee-role","reset-employee-password","delete-employee","system-params-search","system-params-add","system-config-update","system-config-search","privilege-main-update","privilege-main-search","notice-query","notice-add","notice-edit","notice-delete","notice-detail","notice-send","person-notice-query","person-notice-detail","email-query","email-add","email-update","email-delete","email-send","user-operate-log-search","user-operate-log-detail","user-operate-log-delete","user-login-log-search","user-login-log-delete","online-user-search","task-search","task-refresh","task-add","task-update","task-pause","task-resume","task-run","task-query-log","task-delete","smart-reload-search","smart-reload-update","smart-reload-result","heart-beat-query","file-filePage-query","file-filePage-upload"],"roleId":1}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(15, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/1', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[1]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(16, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(17, 1, '管理员', '管理端-系统配置', '修改配置参数', '/smart-admin-api/systemConfig/update', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.updateSystemConfig', 'SystemConfigUpdateDTO[{"configGroup":"upload","configKey":"ali_oss","configName":"阿里云上传配置","configValue":"{\\"accessKeyId\\":\\"\\",\\"accessKeySecret\\":\\"\\",\\"bucketName\\":\\"sit\\",\\"endpoint\\":\\"http://oss-cn-beijing.aliyuncs.com\\"}","id":14,"remark":"eefwfwfds"}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(18, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(19, 1, '管理员', '管理端-系统配置', '修改配置参数', '/smart-admin-api/systemConfig/update', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.updateSystemConfig', 'SystemConfigUpdateDTO[{"configGroup":"upload","configKey":"qi_niu_oss","configName":"七牛云上传配置","configValue":"{\\"accessKeyId\\":\\"rX7HgY1ZLpUD25JrA-uwMM_jj-\\",\\"accessKeySecret\\":\\"\\",\\"bucketName\\":\\"sun-smart-admin\\",\\"endpoint\\":\\"http://puvpyay08.bkt.clouddn.com\\"}","id":16}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(20, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(21, 1, '管理员', '通用-权限', '获取所有请求路径', '/smart-admin-api/privilege/getAllUrl', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.getAllUrl', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(22, 1, '管理员', '通用-权限', '查询所有菜单项', '/smart-admin-api/privilege/menu/queryAll', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.queryAll', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(23, 1, '管理员', '通用-权限', '查询菜单功能点', '/smart-admin-api/privilege/function/query/FileList', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionQuery', 'String["FileList"]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(24, 1, '管理员', '通用-权限', '保存更新功能点', '/smart-admin-api/privilege/function/saveOrUpdate', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionSaveOrUpdate', 'PrivilegeFunctionDTO[{"functionKey":"file-filePage-download","functionName":"下载","menuKey":"FileList","sort":2,"url":"fileController.downLoadById"}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(25, 1, '管理员', '通用-权限', '查询菜单功能点', '/smart-admin-api/privilege/function/query/FileList', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionQuery', 'String["FileList"]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(26, 1, '管理员', '通用-邮件发送', '分页查询', '/smart-admin-api/email/page/query', 'com.gangquan360.smartadmin.module.email.EmailController.queryByPage', 'EmailQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"startDate":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(27, 1, '管理员', '管理端-用户操作日志', '分页查询', '/smart-admin-api/userOperateLog/page/query', 'com.gangquan360.smartadmin.module.log.useroperatelog.UserOperateLogController.queryByPage', 'UserOperateLogQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"sort":false,"startDate":"","userName":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(28, 1, '管理员', '管理端-用户登录日志', '分页查询用户登录日志', '/smart-admin-api/userLoginLog/page/query', 'com.gangquan360.smartadmin.module.log.userloginlog.UserLoginLogController.queryByPage', 'UserLoginLogQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"sort":false,"startDate":"","userName":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(29, 1, '管理员', '管理端-用户登录日志', '查询员工在线状态', '/smart-admin-api/userOnLine/query', 'com.gangquan360.smartadmin.module.log.userloginlog.UserLoginLogController.queryUserOnLine', 'EmployeeQueryDTO[{"actualName":"","employeeIds":[1],"isDelete":0,"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(30, 1, '管理员', '管理端-任务调度', '查询任务', '/smart-admin-api/quartz/task/query', 'com.gangquan360.smartadmin.module.quartz.controller.QuartzController.query', 'QuartzQueryDTO[{"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(31, 1, '管理员', '管理端-smart reload', '获取全部Smart-reload项', '/smart-admin-api/smartReload/all', 'com.gangquan360.smartadmin.module.smartreload.SmartReloadController.listAllReloadItem', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
	(32, 1, '管理员', '通用-心跳服务', '查询心跳记录 @author zhuoda', '/smart-admin-api/heartBeat/query', 'com.gangquan360.smartadmin.module.heartbeat.HeartBeatController.query', 'PageParamDTO[{"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00');
/*!40000 ALTER TABLE `t_user_operate_log` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;