-- -------------------------------------------------------- -- 主机: 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, '

这是内容

', '2019-08-30 15:35:12', '2019-08-30 15:35:12'), (21, 'b', 'asdf@33.com', 1, '

c

', '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, '

qweqwe

', '2019-11-09 10:00:46', '2019-11-09 10:00:46'), (38, 'ewqwe', '适者生存@22.cc', 1, '

qweqwe

', '2019-11-09 10:00:49', '2019-11-09 10:00:49'), (39, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:54', '2019-11-09 10:04:54'), (40, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:57', '2019-11-09 10:04:57'), (41, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:57', '2019-11-09 10:04:57'), (42, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:58', '2019-11-09 10:04:58'), (43, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:59', '2019-11-09 10:04:59'), (44, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:04:59', '2019-11-09 10:04:59'), (45, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:05:16', '2019-11-09 10:05:16'), (46, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:06:29', '2019-11-09 10:06:29'), (47, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:07:02', '2019-11-09 10:07:02'), (48, 'dsfds', 'dsfsd@qq.ccc', 1, '

fsdfs

', '2019-11-09 10:07:16', '2019-11-09 10:07:16'), (49, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:08:13', '2019-11-09 10:08:13'), (50, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:08:30', '2019-11-09 10:08:30'), (51, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:08:50', '2019-11-09 10:08:50'), (52, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:09:09', '2019-11-09 10:09:09'), (53, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:09:31', '2019-11-09 10:09:31'), (54, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:12:24', '2019-11-09 10:12:24'), (55, '2342', '11@ss.cc', 1, '

234234

', '2019-11-09 10:13:13', '2019-11-09 10:13:13'), (56, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:20:42', '2019-11-09 10:20:42'), (57, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:20:52', '2019-11-09 10:20:52'), (58, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:21:16', '2019-11-09 10:21:16'), (59, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:21:24', '2019-11-09 10:21:24'), (60, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:21:30', '2019-11-09 10:21:30'), (61, 'asdasd', '3423@aqq.cc', 0, '

asdasd

', '2019-11-09 10:21:53', '2019-11-09 10:21:53'), (62, 'a21312', '23423@qq.cc', 0, '

asdasdas

', '2019-11-09 10:23:40', '2019-11-09 10:23:40'), (63, '11', '1234@qq.com', 0, '

23

', '2019-11-15 15:35:12', '2019-11-15 15:35:12'), (64, '11', '1234@qq.com', 0, '

23

', '2019-11-15 15:35:15', '2019-11-15 15:35:15'), (65, '11', '1234@qq.com', 0, '

23

', '2019-11-15 15:35:16', '2019-11-15 15:35:16'), (66, 'eeee', '1234@qq.com', 0, '

    eee2233

', '2019-11-15 17:00:00', '2019-11-15 17:00:00'), (67, 'eeee', '1234@qq.com', 0, '

    eee2233

', '2019-11-15 17:00:03', '2019-11-15 17:00:03'), (68, 'eeee', '1234@qq.com', 0, '

    eee2233

', '2019-11-15 17:00:04', '2019-11-15 17:00:04'), (69, '22223', '1017146812@qq.com', 0, '

    e34233

', '2019-11-15 17:00:33', '2019-11-15 17:00:33'), (70, '22223', '1017146812@qq.com', 0, '

    e34233

', '2019-11-15 17:00:34', '2019-11-15 17:00:34'), (71, '22223', '1017146812@qq.com', 0, '

    e34233

', '2019-11-15 17:00:34', '2019-11-15 17:00:34'), (72, '22223', '12232', 0, '

    e34233

', '2019-11-15 17:00:49', '2019-11-15 17:00:49'), (73, '22223', '12232@qq.com', 0, '

    e34233

', '2019-11-15 17:00:56', '2019-11-15 17:00:56'), (74, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 08:51:44', '2019-11-16 08:51:44'), (75, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:05:10', '2019-11-16 09:05:10'), (76, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:05:14', '2019-11-16 09:05:14'), (77, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:06:34', '2019-11-16 09:06:34'), (78, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:07:09', '2019-11-16 09:07:09'), (79, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:07:30', '2019-11-16 09:07:30'), (80, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:07:32', '2019-11-16 09:07:32'), (81, 'dsasdasd', 'asdas@qq.com', 0, '

asdasd

', '2019-11-16 09:08:29', '2019-11-16 09:08:29'), (82, 'sdfs', 'ss@ss.cc', 0, '

dsdsf

', '2019-11-16 09:08:46', '2019-11-16 09:08:46'), (83, 'asdasd', 'asd@qq.vv', 0, '

asdas

', '2019-11-16 09:09:18', '2019-11-16 09:09:18'), (84, 'asdasd', 'asd@qq.vv', 0, '

asdas

', '2019-11-16 09:09:42', '2019-11-16 09:09:42'), (85, 'asdasd', 'asd@qq.vv', 0, '

asdas

', '2019-11-16 09:09:46', '2019-11-16 09:09:46'), (86, 'dasdad', 'dasda@ss.cc', 1, '

dasasdas

', '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 */;