用户-角色--权限【通用思路】

我不是女神ヾ 2023-06-19 11:12 25阅读 0赞

1 登录--admin/admin-查询【用户基本信息--角色--权限】  
2 根据角色权限--动态渲染菜单  
3异常请求--验证权限--有，显示，无，显示403，没有权限  
4 【用户角色权限】  
1用户增删改查 【User表】userId  
2角色增删改查 【Role表】roleId---【User\_role表】userId+roleId  
3权限增删改查 【Permission表】permissionId--【id--pId--name---url--type\[按钮，菜单menu \]--icon--orderNum【排序】--perms【权限】--use\_flag【是否可用】】

/\*  
Navicat MySQL Data Transfer

Source Server         : 本地  
Source Server Version : 80015  
Source Host           : localhost:3306  
Source Database       : shiro4

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

Date: 2019-12-06 10:45:27  
\*/

SET FOREIGN\_KEY\_CHECKS=0;

\-- ----------------------------  
\-- Table structure for sys\_menu  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_menu\`;  
CREATE TABLE \`sys\_menu\` (  
  \`menu\_id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
  \`parent\_id\` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',  
  \`name\` varchar(50) DEFAULT NULL COMMENT '菜单名称',  
  \`url\` varchar(200) DEFAULT NULL COMMENT '菜单URL',  
  \`perms\` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',  
  \`type\` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',  
  \`icon\` varchar(50) DEFAULT NULL COMMENT '菜单图标',  
  \`order\_num\` int(11) DEFAULT NULL COMMENT '排序',  
  PRIMARY KEY (\`menu\_id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

\-- ----------------------------  
\-- Records of sys\_menu  
\-- ----------------------------  
INSERT INTO \`sys\_menu\` VALUES ('1', '0', '系统管理', '', '', '0', 'fa fa-cog', '0');  
INSERT INTO \`sys\_menu\` VALUES ('2', '1', '管理员列表', 'admin/sys/admin.html', '', '1', 'fa fa-user', '1');  
INSERT INTO \`sys\_menu\` VALUES ('3', '1', '角色管理', 'admin/sys/role.html', null, '1', 'fa fa-user-secret', '2');  
INSERT INTO \`sys\_menu\` VALUES ('4', '1', '菜单管理', 'admin/sys/menu.html', null, '1', 'fa fa-th-list', '3');  
INSERT INTO \`sys\_menu\` VALUES ('5', '2', '查看', null, 'sys:user:list,sys:user:info', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('6', '2', '新增', '', 'sys:user:save,sys:role:select', '2', '', '0');  
INSERT INTO \`sys\_menu\` VALUES ('7', '2', '修改', '', 'sys:user:update,sys:role:select', '2', '', '0');  
INSERT INTO \`sys\_menu\` VALUES ('8', '2', '删除', null, 'sys:user:delete', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('9', '3', '查看', null, 'sys:role:list,sys:role:info', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('10', '3', '新增', null, 'sys:role:save,sys:menu:perms', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('11', '3', '修改', null, 'sys:role:update,sys:menu:perms', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('12', '3', '删除', null, 'sys:role:delete', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('13', '4', '查看', null, 'sys:menu:list,sys:menu:info', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('14', '4', '新增', null, 'sys:menu:save,sys:menu:select', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('15', '4', '修改', null, 'sys:menu:update,sys:menu:select', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('16', '4', '删除', null, 'sys:menu:delete', '2', null, '0');  
INSERT INTO \`sys\_menu\` VALUES ('17', '1', '监控管理', 'druid/index.html', 'druid:druid:manager', '1', 'fa fa-cogs', '3');  
INSERT INTO \`sys\_menu\` VALUES ('18', '1', 'Swagger管理', 'swagger-ui.html', 'swaggerui:swaggerui:manager', '1', 'fa fa-diamond', '4');

\-- ----------------------------  
\-- Table structure for sys\_role  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_role\`;  
CREATE TABLE \`sys\_role\` (  
  \`role\_id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
  \`role\_name\` varchar(100) DEFAULT NULL COMMENT '角色名称',  
  \`remark\` varchar(100) DEFAULT NULL COMMENT '备注',  
  \`create\_time\` int(11) DEFAULT NULL COMMENT '创建时间',  
  PRIMARY KEY (\`role\_id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='角色';

\-- ----------------------------  
\-- Records of sys\_role  
\-- ----------------------------  
INSERT INTO \`sys\_role\` VALUES ('13', 'admin', 'admina', '1498801511');

\-- ----------------------------  
\-- Table structure for sys\_role\_menu  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_role\_menu\`;  
CREATE TABLE \`sys\_role\_menu\` (  
  \`id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
  \`role\_id\` bigint(20) DEFAULT NULL COMMENT '角色ID',  
  \`menu\_id\` bigint(20) DEFAULT NULL COMMENT '菜单ID',  
  PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=251 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

\-- ----------------------------  
\-- Records of sys\_role\_menu  
\-- ----------------------------  
INSERT INTO \`sys\_role\_menu\` VALUES ('241', '13', '1');  
INSERT INTO \`sys\_role\_menu\` VALUES ('242', '13', '2');  
INSERT INTO \`sys\_role\_menu\` VALUES ('243', '13', '5');  
INSERT INTO \`sys\_role\_menu\` VALUES ('244', '13', '6');  
INSERT INTO \`sys\_role\_menu\` VALUES ('245', '13', '3');  
INSERT INTO \`sys\_role\_menu\` VALUES ('246', '13', '9');  
INSERT INTO \`sys\_role\_menu\` VALUES ('247', '13', '4');  
INSERT INTO \`sys\_role\_menu\` VALUES ('248', '13', '13');  
INSERT INTO \`sys\_role\_menu\` VALUES ('249', '13', '17');  
INSERT INTO \`sys\_role\_menu\` VALUES ('250', '13', '18');

\-- ----------------------------  
\-- Table structure for sys\_user  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_user\`;  
CREATE TABLE \`sys\_user\` (  
  \`user\_id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
  \`username\` varchar(50) NOT NULL COMMENT '用户名',  
  \`password\` varchar(100) DEFAULT NULL COMMENT '密码',  
  \`sex\` tinyint(1) DEFAULT '0' COMMENT '性别 0=保密/1=男/2=女',  
  \`email\` varchar(100) DEFAULT NULL COMMENT '邮箱',  
  \`mobile\` varchar(100) DEFAULT NULL COMMENT '手机号',  
  \`last\_login\_time\` int(11) DEFAULT NULL COMMENT '最后登录时间',  
  \`last\_login\_ip\` varchar(20) DEFAULT NULL COMMENT '最后登录IP',  
  \`avatar\_url\` varchar(255) DEFAULT NULL COMMENT '头像缩略图地址',  
  \`status\` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',  
  \`create\_time\` int(11) DEFAULT NULL COMMENT '创建时间',  
  PRIMARY KEY (\`user\_id\`),  
  UNIQUE KEY \`username\` (\`username\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='系统用户';

\-- ----------------------------  
\-- Records of sys\_user  
\-- ----------------------------  
INSERT INTO \`sys\_user\` VALUES ('1', 'admin', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '0', '2434387555@qq.com', '13647910242', '1500018856', '192.168.1.88', 'upload/adminAvatar/201707/1499675749475head.jpg', '1', '1498801511');  
INSERT INTO \`sys\_user\` VALUES ('7', 'lastone', 'd50b4c0cab140a3310e256d86fd3cd33c02f145635df4694e71df062c1679a8f', '2', 'asd@qq.com', '13456465465', '1499069279', '192.168.1.88', 'upload/adminAvatar/201707/1499675749475head.jpg', '1', '1499069190');  
INSERT INTO \`sys\_user\` VALUES ('8', 'joey', 'bfef4adc39f01b033fe749bb5f28f10b581fef319d34445d21a7bc63fe732fa3', '2', '2434387555@qq.com', '13647910412', '1499670576', '192.168.1.88', 'upload/adminAvatar/201707/1499675749475head.jpg', '0', '1499410874');

\-- ----------------------------  
\-- Table structure for sys\_user\_login\_log  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_user\_login\_log\`;  
CREATE TABLE \`sys\_user\_login\_log\` (  
  \`log\_id\` bigint(20) unsigned NOT NULL AUTO\_INCREMENT COMMENT '登录日志ID',  
  \`login\_time\` int(11) DEFAULT NULL COMMENT '登录时间',  
  \`login\_ip\` varchar(20) DEFAULT NULL COMMENT '登录IP',  
  \`user\_id\` bigint(20) DEFAULT NULL COMMENT '用户ID',  
  \`operating\_system\` varchar(50) DEFAULT NULL COMMENT '操作系统',  
  \`browser\` varchar(50) DEFAULT NULL COMMENT '浏览器',  
  PRIMARY KEY (\`log\_id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=402 DEFAULT CHARSET=utf8 COMMENT='用户登录表';

\-- ----------------------------  
\-- Records of sys\_user\_login\_log  
\-- ----------------------------  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('144', '1498643487', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('145', '1498643522', '192.168.1.13', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('146', '1498644136', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('147', '1498696770', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('148', '1498696935', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('149', '1498697948', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('150', '1498698072', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('151', '1498698196', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('152', '1498699082', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('153', '1498699432', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('154', '1498699706', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('155', '1498699646', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('156', '1498699799', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('157', '1498700536', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('158', '1498703621', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('159', '1498703553', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('160', '1498703797', '192.168.1.26', '1', 'WINDOWS\_7', 'CHROME39');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('161', '1498703941', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('162', '1498704012', '192.168.1.26', '1', 'WINDOWS\_7', 'CHROME39');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('163', '1498704110', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('164', '1498704322', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('165', '1498704455', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('166', '1498704533', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('167', '1498704682', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('168', '1498706068', '192.168.1.26', '1', 'WINDOWS\_7', 'CHROME39');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('169', '1498707433', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('170', '1498707589', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('171', '1498708225', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('172', '1498714561', '192.168.1.13', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('173', '1498714892', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('174', '1498714912', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('175', '1498717536', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('176', '1498719628', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('177', '1498719718', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('178', '1498720250', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('179', '1498721509', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('180', '1498721472', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('181', '1498721707', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('182', '1498722682', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('183', '1498722697', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('184', '1498722774', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('185', '1498722797', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('186', '1498723998', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('187', '1498724109', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('188', '1498724427', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('189', '1498724612', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('190', '1498726269', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('191', '1498726979', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('192', '1498727250', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('193', '1498729214', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('194', '1498730522', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('195', '1498730704', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('196', '1498784021', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('197', '1498784093', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('198', '1498784793', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('199', '1498785172', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('200', '1498786010', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('201', '1498786323', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('202', '1498786548', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('203', '1498786548', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('204', '1498786716', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('205', '1498786626', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('206', '1498786988', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('207', '1498787137', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('208', '1498787414', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('209', '1498787655', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('210', '1498787901', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('211', '1498788939', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('212', '1498789243', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('213', '1498792867', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('214', '1498793558', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('215', '1498793866', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('216', '1498794052', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('217', '1498794300', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('218', '1498801042', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('219', '1498800942', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('220', '1498802396', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('221', '1498802454', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('222', '1498803515', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('223', '1498804811', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('224', '1498805228', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('225', '1498805241', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('226', '1498805469', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('227', '1498805899', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('228', '1498806813', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('229', '1498806800', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('230', '1498806995', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('231', '1498807290', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('232', '1498807203', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('233', '1498807725', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('234', '1498808125', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('235', '1498809962', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('236', '1498811173', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('237', '1498811214', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('238', '1498811582', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('239', '1498811989', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('240', '1498812194', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('241', '1498812256', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('242', '1498812373', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('243', '1498812703', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('244', '1498812751', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('245', '1498814101', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('246', '1498814281', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('247', '1498814294', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('248', '1498815015', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('249', '1499042315', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('250', '1499043527', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('251', '1499049141', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('252', '1499051653', '192.168.1.88', '1', 'WINDOWS\_7', 'IE9');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('253', '1499051758', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME51');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('254', '1499052573', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('255', '1499052849', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('256', '1499053115', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('257', '1499060576', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('258', '1499062246', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('259', '1499066402', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('260', '1499066583', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('261', '1499066779', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('262', '1499067338', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('263', '1499069038', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('264', '1499069279', '192.168.1.88', '7', 'WINDOWS\_7', 'IE9');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('265', '1499069518', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('266', '1499069582', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('267', '1499070803', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('268', '1499070825', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('269', '1499071525', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('270', '1499131270', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('271', '1499134326', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('272', '1499134791', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('273', '1499153429', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('274', '1499155324', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('275', '1499155573', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('276', '1499157566', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('277', '1499157784', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('278', '1499224438', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('279', '1499224558', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('280', '1499237804', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('281', '1499238665', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('282', '1499240768', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('283', '1499240844', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('284', '1499240927', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('285', '1499241009', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('286', '1499241689', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('287', '1499241852', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('288', '1499241940', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('289', '1499242070', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('290', '1499242204', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('291', '1499242576', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('292', '1499242686', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('293', '1499242786', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('294', '1499243019', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('295', '1499243826', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('296', '1499244330', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('297', '1499244413', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('298', '1499244893', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('299', '1499245106', '0:0:0:0:0:0:0:1', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('300', '1499304924', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('301', '1499305120', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('302', '1499305230', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('303', '1499305433', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('304', '1499305555', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('305', '1499305754', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('306', '1499305988', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('307', '1499306086', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('308', '1499306206', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('309', '1499306272', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('310', '1499306446', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('311', '1499323795', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('312', '1499324004', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('313', '1499325387', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('314', '1499325470', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('315', '1499325657', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('316', '1499325738', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('317', '1499325800', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('318', '1499326940', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('319', '1499326972', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('320', '1499327095', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('321', '1499327157', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('322', '1499327897', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('323', '1499328094', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('324', '1499328214', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('325', '1499333844', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('326', '1499389330', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('327', '1499392633', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('328', '1499394310', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('329', '1499394750', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('330', '1499397025', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('331', '1499397556', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('332', '1499399214', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('333', '1499407108', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME51');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('334', '1499407181', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('335', '1499410304', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('336', '1499410387', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('337', '1499410642', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('338', '1499410906', '192.168.1.88', '8', 'WINDOWS\_7', 'CHROME51');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('339', '1499410928', '192.168.1.88', '8', 'WINDOWS\_7', 'CHROME51');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('340', '1499419066', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('341', '1499649774', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('342', '1499649874', '192.168.1.11', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('343', '1499650352', '192.168.1.11', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('344', '1499651147', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('345', '1499651546', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('346', '1499651696', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('347', '1499652951', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('348', '1499653330', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('349', '1499656282', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('350', '1499657144', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('351', '1499665646', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('352', '1499665846', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('353', '1499666672', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('354', '1499667521', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('355', '1499668376', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('356', '1499668738', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('357', '1499668939', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('358', '1499669915', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('359', '1499670576', '192.168.1.88', '8', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('360', '1499675439', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('361', '1499675579', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('362', '1499675677', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('363', '1499675734', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('364', '1499676954', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('365', '1499678029', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('366', '1499733831', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('367', '1499736644', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('368', '1499740053', '192.168.1.12', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('369', '1499739950', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('370', '1499751595', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('371', '1499754490', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('372', '1499754532', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME51');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('373', '1499754626', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('374', '1499754671', '192.168.1.88', '1', 'WINDOWS\_7', 'IE9');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('375', '1499754889', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('376', '1499755582', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('377', '1499823697', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('378', '1499824314', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('379', '1499830448', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('380', '1499830781', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('381', '1499851241', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('382', '1499911630', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('383', '1499911942', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('384', '1499912210', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('385', '1499912417', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('386', '1499912551', '192.168.1.88', '1', 'WINDOWS\_7', 'IE9');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('387', '1499913005', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('388', '1499914224', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('389', '1499914472', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('390', '1499915663', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('391', '1499918084', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('392', '1499925822', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('393', '1499936087', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('394', '1499938281', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('395', '1499938450', '192.168.1.88', '1', 'WINDOWS\_7', 'IE9');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('396', '1500012618', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('397', '1500018058', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('398', '1500018358', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('399', '1500018527', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('400', '1500018635', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');  
INSERT INTO \`sys\_user\_login\_log\` VALUES ('401', '1500018856', '192.168.1.88', '1', 'WINDOWS\_7', 'CHROME49');

\-- ----------------------------  
\-- Table structure for sys\_user\_role  
\-- ----------------------------  
DROP TABLE IF EXISTS \`sys\_user\_role\`;  
CREATE TABLE \`sys\_user\_role\` (  
  \`id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
  \`user\_id\` bigint(20) DEFAULT NULL COMMENT '用户ID',  
  \`role\_id\` bigint(20) DEFAULT NULL COMMENT '角色ID',  
  PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';

\-- ----------------------------  
\-- Records of sys\_user\_role  
\-- ----------------------------  
INSERT INTO \`sys\_user\_role\` VALUES ('62', '1', '13');  
INSERT INTO \`sys\_user\_role\` VALUES ('72', '8', '13');  
INSERT INTO \`sys\_user\_role\` VALUES ('73', '7', '13');