rbac表 ( 5张 )

/*
 Navicat Premium Data Transfer Source Server         : 本地连接
 Source Server Type    : MySQL
 Source Server Version : 50549
 Source Host           : localhost:3306
 Source Schema         : rbac Target Server Type    : MySQL
 Target Server Version : 50549
 File Encoding         : 65001 Date: 25/08/2020 16:08:34
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for rbac_admin
-- ----------------------------
DROP TABLE IF EXISTS `rbac_admin`;
CREATE TABLE `rbac_admin`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `is_delete` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除 (0：未删除 1：已删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Compact;-- ----------------------------
-- Records of rbac_admin
-- ----------------------------
INSERT INTO `rbac_admin` VALUES ('2edfaab0c621c5aaed18de036168f116', 'Saygin-BAIYE', '0192023A7BBD73250516F069DF18B500', '2020-08-22 15:58:29', NULL, NULL, NULL, 0);
INSERT INTO `rbac_admin` VALUES ('43333ddd5eb1c95ac88e03ece5156d26', 'admin', '0192023A7BBD73250516F069DF18B500', '2020-08-22 15:37:11', '43333ddd5eb1c95ac88e03ece5156d26', '2020-08-22 18:15:50', '43333ddd5eb1c95ac88e03ece5156d26', 0);-- ----------------------------
-- Table structure for rbac_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `rbac_admin_role`;
CREATE TABLE `rbac_admin_role`  (
  `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `is_delete` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除 (0：未删除 1：已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联' ROW_FORMAT = Compact;-- ----------------------------
-- Table structure for rbac_permission
-- ----------------------------
DROP TABLE IF EXISTS `rbac_permission`;
CREATE TABLE `rbac_permission`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限id',
  `permission_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限名称',
  `permission_value` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '权限值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `is_delete` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除 (0：未删除 1：已删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = Compact;-- ----------------------------
-- Records of rbac_permission
-- ----------------------------
INSERT INTO `rbac_permission` VALUES ('10ff76c932489fa97ef3d82783b166cf', '菜品模块', NULL, '2020-08-24 14:51:43', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);
INSERT INTO `rbac_permission` VALUES ('7505eae5228d9055544af67bc82b9bd4', '用户模块', NULL, '2020-08-24 14:51:58', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);
INSERT INTO `rbac_permission` VALUES ('abb7c2245993f571f48ce508b5048c8e', '会员模块', NULL, '2020-08-24 14:52:02', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);
INSERT INTO `rbac_permission` VALUES ('f8b1c9551843913e7c546ddbc8102afe', '常规模块', NULL, '2020-08-24 14:55:00', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);-- ----------------------------
-- Table structure for rbac_role
-- ----------------------------
DROP TABLE IF EXISTS `rbac_role`;
CREATE TABLE `rbac_role`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
  `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `is_delete` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除 (0：未删除 1：已删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Compact;-- ----------------------------
-- Records of rbac_role
-- ----------------------------
INSERT INTO `rbac_role` VALUES ('7fbdb94500952633a02d8668322ce635', '管理员', '2020-08-24 11:54:05', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);
INSERT INTO `rbac_role` VALUES ('ea5b466f128087240ee8ab1ba9c2854d', '超级管理员', '2020-08-24 11:54:18', '43333ddd5eb1c95ac88e03ece5156d26', NULL, NULL, 0);-- ----------------------------
-- Table structure for rbac_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `rbac_role_permission`;
CREATE TABLE `rbac_role_permission`  (
  `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
  `permission_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人',
  `is_delete` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否删除 (0：未删除 1：已删除)'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限关联' ROW_FORMAT = Compact;SET FOREIGN_KEY_CHECKS = 1;