/*
Navicat MySQL Data Transfer

Source Server         : myconn
Source Server Version : 50625
Source Host           : localhost:3306
Source Database       : security

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

Date: 2021-12-21 09:19:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(30) NOT NULL COMMENT '用户账号',
  `password` varchar(100) NOT NULL COMMENT '用户密码',
  `role_id` bigint(20) NOT NULL DEFAULT '1' COMMENT '角色ID',
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'xxx', '$2a$10$62wvQSpB4FCnNKeijAzSB.5GcSYlwVhVTPV.fsENpMUDA4INCHxh2', '1');
INSERT INTO `admin` VALUES ('3', '123', '$2a$10$m30GWAWzN7JmmlRa7nP/ue5unV8yzhMK02OsUX2lfb/COC6O3bGFm', '2');

-- ----------------------------
-- Table structure for `auty`
-- ----------------------------
DROP TABLE IF EXISTS `auty`;
CREATE TABLE `auty` (
  `auty_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `auty_name` varchar(30) NOT NULL COMMENT '权限名称',
  PRIMARY KEY (`auty_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of auty
-- ----------------------------
INSERT INTO `auty` VALUES ('1', 'update');
INSERT INTO `auty` VALUES ('2', 'deleted');
INSERT INTO `auty` VALUES ('3', 'insert');
INSERT INTO `auty` VALUES ('4', 'select');

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

-- ----------------------------
-- Records of roau
-- ----------------------------
INSERT INTO `roau` VALUES ('1', '1', '1');
INSERT INTO `roau` VALUES ('2', '2', '1');
INSERT INTO `roau` VALUES ('3', '2', '3');
INSERT INTO `roau` VALUES ('4', '2', '4');

-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', 'ROLE_user');
INSERT INTO `role` VALUES ('2', 'ROLE_root');