/*

 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;