/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 80012
Source Host           : localhost:3306
Source Database       : moose

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

Date: 2019-02-28 14:52:54
*/

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_operate_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operate_log`;
CREATE TABLE `sys_operate_log`
(
  `id`             bigint(20)   NOT NULL,
  `operator`       varchar(10)  NOT NULL COMMENT '操作人',
  `operate_role`   varchar(100)          DEFAULT NULL COMMENT '人员角色',
  `operate_time`   bigint(20)   NOT NULL COMMENT '操作时间',
  `operate_ip`     varchar(100) NOT NULL COMMENT 'IP地址',
  `operate_active` varchar(100)          DEFAULT NULL COMMENT '操作行为',
  `execute_time`   bigint(20)   NOT NULL COMMENT '方法执行时间',
  `is_deleted`     bit(1)       NOT NULL DEFAULT b'0',
  `create_time`    datetime     NOT NULL,
  `update_time`    datetime     NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='操作日志表';

-- ----------------------------
-- Records of sys_operate_log
-- ----------------------------
INSERT INTO `sys_operate_log`
VALUES ('1101009747617878017', 'cat', '日志管理员', '1551336154044', '192.168.17.74', '登陆', '122', '\0',
        '2019-02-28 06:42:34', '2019-02-28 06:42:34');
INSERT INTO `sys_operate_log`
VALUES ('1101009849556242433', 'cat', '日志管理员', '1551336178565', '192.168.17.74', '查询操作日志列表', '139', '\0',
        '2019-02-28 06:42:59', '2019-02-28 06:42:59');

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission`
(
  `id`          bigint(20)   NOT NULL,
  `name`        varchar(128) NOT NULL COMMENT '资源名称',
  `url`         varchar(128) NOT NULL DEFAULT '' COMMENT '访问url',
  `parent_id`   bigint(20)            DEFAULT NULL COMMENT '自关联主键',
  `seq`         int(10)               DEFAULT NULL COMMENT '排序字段',
  `is_deleted`  bit(1)       NOT NULL DEFAULT b'0',
  `create_time` datetime     NOT NULL,
  `update_time` datetime     NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='权限表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission`
VALUES ('1100996127508946946', '全权限', '', '-1', null, '\0', '2019-02-28 05:48:27', '2019-02-28 05:48:27');
INSERT INTO `sys_permission`
VALUES ('1100996128557522945', '文件管理', '', '1100996127508946946', null, '\0', '2019-02-28 05:48:27',
        '2019-02-28 05:48:27');
INSERT INTO `sys_permission`
VALUES ('1100996128888872961', '文件上传', '/file/upload', '1100996128557522945', '1', '\0', '2019-02-28 05:48:27',
        '2019-02-28 05:48:27');
INSERT INTO `sys_permission`
VALUES ('1100996129174085633', '文件预览', '/file/onlinePreview', '1100996128557522945', '2', '\0', '2019-02-28 05:48:27',
        '2019-02-28 05:48:27');
INSERT INTO `sys_permission`
VALUES ('1100996129450909698', '日志管理', '', '1100996127508946946', null, '\0', '2019-02-28 05:48:27',
        '2019-02-28 05:48:27');
INSERT INTO `sys_permission`
VALUES ('1100996129757093890', '日志列表', '/operateLog/page', '1100996129450909698', '1', '\0', '2019-02-28 05:48:28',
        '2019-02-28 05:48:28');
INSERT INTO `sys_permission`
VALUES ('1100996130033917953', '日志导出', '/operateLog/excel', '1100996129450909698', '2', '\0', '2019-02-28 05:48:28',
        '2019-02-28 05:48:28');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`
(
  `id`          bigint(20)  NOT NULL,
  `role_name`   varchar(10) NOT NULL COMMENT '角色名称',
  `type`        varchar(10) NOT NULL DEFAULT 'role' COMMENT '角色类型：一般用户role 系统管理员 admin',
  `is_deleted`  bit(1)      NOT NULL DEFAULT b'0',
  `create_time` datetime    NOT NULL,
  `update_time` datetime    NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role`
VALUES ('1100992918660964353', '系统管理员', 'role', '\0', '2019-02-28 05:35:42', '2019-02-28 05:35:42');
INSERT INTO `sys_role`
VALUES ('1101000427488419841', '文件管理员', 'role', '\0', '2019-02-28 06:05:32', '2019-02-28 06:05:32');
INSERT INTO `sys_role`
VALUES ('1101000428163702785', '日志管理员', 'role', '\0', '2019-02-28 06:05:32', '2019-02-28 06:05:32');

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission`
(
  `role_id`       bigint(20) NOT NULL,
  `permission_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`, `permission_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='角色-权限关联表';

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996127508946946');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996128557522945');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996128888872961');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996129174085633');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996129450909698');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996129757093890');
INSERT INTO `sys_role_permission`
VALUES ('1100992918660964353', '1100996130033917953');
INSERT INTO `sys_role_permission`
VALUES ('1101000427488419841', '1100996127508946946');
INSERT INTO `sys_role_permission`
VALUES ('1101000427488419841', '1100996128557522945');
INSERT INTO `sys_role_permission`
VALUES ('1101000427488419841', '1100996128888872961');
INSERT INTO `sys_role_permission`
VALUES ('1101000427488419841', '1100996129174085633');
INSERT INTO `sys_role_permission`
VALUES ('1101000428163702785', '1100996127508946946');
INSERT INTO `sys_role_permission`
VALUES ('1101000428163702785', '1100996129450909698');
INSERT INTO `sys_role_permission`
VALUES ('1101000428163702785', '1100996129757093890');
INSERT INTO `sys_role_permission`
VALUES ('1101000428163702785', '1100996130033917953');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`
(
  `id`          bigint(20)   NOT NULL,
  `name`        varchar(10)  NOT NULL COMMENT '用户名',
  `password`    varchar(200) NOT NULL COMMENT '密码',
  `mobile`      varchar(11)  NOT NULL COMMENT '电话号码',
  `email`       varchar(200) NOT NULL DEFAULT '' COMMENT '邮箱地址',
  `gender`      int(1)       NOT NULL DEFAULT '1' COMMENT '性别1：男性2：女性（默认男）',
  `icon`        varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
  `is_deleted`  bit(1)       NOT NULL DEFAULT b'0',
  `create_time` datetime     NOT NULL,
  `update_time` datetime     NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sys_user_mobile_index` (`mobile`),
  KEY `sys_user_name_index` (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='用户表';

-- ----------------------------
-- Records of sys_user 
-- admin->admin
-- cat->tomcat
-- moose->moose
-- ----------------------------
INSERT INTO `sys_user`
VALUES ('1100953520615456770', 'admin', '$2a$10$zQqUopv1yzlErurlEzSgZOmBdMX.mxG54C2MSsDc1RTYb5jwa2BAu', '18888888888',
        '', '1', '', '\0', '2019-02-28 02:59:09', '2019-02-28 02:59:09');
INSERT INTO `sys_user`
VALUES ('1101000425491931137', 'cat', '$2a$10$4t6VXVeO144QTz4/yxFcAOQgg9Rwp0gZy6Po18esyAi.hiY.ICH1u', '19999999999', '',
        '1', '', '\0', '2019-02-28 06:05:32', '2019-02-28 06:05:32');
INSERT INTO `sys_user`
VALUES ('1101000427098349569', 'moose', '$2a$10$Zr7ffpOw5E.ZOtpieD0.G.Kx4a7RyT.wd5zP80TtotZVKtAINby02', '16666666666',
        '', '1', '', '\0', '2019-02-28 06:05:32', '2019-02-28 06:05:32');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`
(
  `sys_user_id` bigint(20) NOT NULL,
  `sys_role_id` bigint(20) NOT NULL,
  PRIMARY KEY (`sys_user_id`, `sys_role_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role`
VALUES ('1100953520615456770', '1100992918660964353');
INSERT INTO `sys_user_role`
VALUES ('1101000425491931137', '1101000428163702785');
INSERT INTO `sys_user_role`
VALUES ('1101000427098349569', '1101000427488419841');