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;