text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 本机
   Source Server Type    : MySQL
   Source Server Version : 50718
   Source Host           : localhost:3306
   Source Schema         : spring-boot-demo
  
   Target Server Type    : MySQL
   Target Server Version : 50718
   File Encoding         : 65001
  
   Date: 12/12/2018 18:52:51
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for sec_user
  -- ----------------------------
  DROP TABLE IF EXISTS `shiro_user`;
  CREATE TABLE `shiro_user`
  (
    `id`          bigint(64)  NOT NULL COMMENT '主键',
    `username`    varchar(50) NOT NULL COMMENT '用户名',
    `password`    varchar(60) NOT NULL COMMENT '密码',
    `salt`        varchar(60) NOT NULL COMMENT '盐值',
    `nickname`    varchar(255)         DEFAULT NULL COMMENT '昵称',
    `phone`       varchar(11)          DEFAULT NULL COMMENT '手机',
    `email`       varchar(50)          DEFAULT NULL COMMENT '邮箱',
    `birthday`    bigint(13)           DEFAULT NULL COMMENT '生日',
    `sex`         int(2)               DEFAULT NULL COMMENT '性别，男-1，女-2',
    `status`      int(2)      NOT NULL DEFAULT '1' COMMENT '状态，启用-1，禁用-0',
    `create_time` bigint(13)  NOT NULL COMMENT '创建时间',
    `update_time` bigint(13)  NOT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`),
    UNIQUE KEY `phone` (`phone`),
    UNIQUE KEY `email` (`email`)
  ) ENGINE = InnoDB
    DEFAULT CHARSET = utf8 COMMENT ='用户表';
  
  -- ----------------------------
  -- Table structure for sec_role
  -- ----------------------------
  DROP TABLE IF EXISTS `shiro_role`;
  CREATE TABLE `shiro_role`
  (
    `id`          bigint(64)  NOT NULL COMMENT '主键',
    `name`        varchar(50) NOT NULL COMMENT '角色名',
    `description` varchar(100) DEFAULT NULL COMMENT '描述',
    `create_time` bigint(13)  NOT NULL COMMENT '创建时间',
    `update_time` bigint(13)  NOT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE = InnoDB
    DEFAULT CHARSET = utf8 COMMENT ='角色表';
  
  -- ----------------------------
  -- Table structure for sec_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `shiro_user_role`;
  CREATE TABLE `shiro_user_role`
  (
    `user_id` bigint(64) NOT NULL COMMENT '用户主键',
    `role_id` bigint(64) NOT NULL COMMENT '角色主键',
    PRIMARY KEY (`user_id`, `role_id`)
  ) ENGINE = InnoDB
    DEFAULT CHARSET = utf8 COMMENT ='用户角色关系表';
  
  -- ----------------------------
  -- Table structure for sec_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `shiro_permission`;
  CREATE TABLE `shiro_permission`
  (
    `id`         bigint(64)  NOT NULL COMMENT '主键',
    `name`       varchar(50) NOT NULL COMMENT '权限名',
    `url`        varchar(1000) DEFAULT NULL COMMENT '类型为页面时，代表前端路由地址，类型为按钮时，代表后端接口地址',
    `type`       int(2)      NOT NULL COMMENT '权限类型，页面-1，按钮-2',
    `permission` varchar(50)   DEFAULT NULL COMMENT '权限表达式',
    `method`     varchar(50)   DEFAULT NULL COMMENT '后端接口访问方式',
    `sort`       int(11)     NOT NULL COMMENT '排序',
    `parent_id`  bigint(64)  NOT NULL COMMENT '父级id',
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB
    DEFAULT CHARSET = utf8 COMMENT ='权限表';
  
  -- ----------------------------
  -- Table structure for sec_role_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `shiro_role_permission`;
  CREATE TABLE `shiro_role_permission`
  (
    `role_id`       bigint(64) NOT NULL COMMENT '角色主键',
    `permission_id` bigint(64) NOT NULL COMMENT '权限主键',
    PRIMARY KEY (`role_id`, `permission_id`)
  ) ENGINE = InnoDB
    DEFAULT CHARSET = utf8 COMMENT ='角色权限关系表';