master

分支 (1)

管理

管理

master

node-front-rear
/
packages
/
asc-bg
/
asc_project.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80011 (8.0.11)
 Source Host           : localhost:3306
 Source Schema         : asc_project

 Target Server Type    : MySQL
 Target Server Version : 80011 (8.0.11)
 File Encoding         : 65001

 Date: 21/04/2023 01:08:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for system_application
-- ----------------------------
DROP TABLE IF EXISTS `system_application`;
CREATE TABLE `system_application`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT 'id',
  `applicationName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '系统名',
  `applicationCode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '系统code',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '1' COMMENT '状态，（权限 0 锁定 1 正常 2 删除）',
  `sort` int(11) NOT NULL COMMENT '排序',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL COMMENT '备注',
  `createUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `updateUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ref_applicationCode`(`applicationCode` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_application
-- ----------------------------
INSERT INTO `system_application` VALUES ('840884b0-d9a7-11ed-8b85-c5e454decebc', 'menuTest1', 'menuTest1_1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:01:41', '2023-04-13 11:01:41', NULL);
INSERT INTO `system_application` VALUES ('ad29ff90-d9a7-11ed-9b8e-0911a9c4f732', '系统', 'system', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:02:50', '2023-04-13 11:02:50', NULL);
INSERT INTO `system_application` VALUES ('b78891e0-d9a7-11ed-9b8e-0911a9c4f732', '报表系统', 'report', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:03:08', '2023-04-13 11:03:08', NULL);
INSERT INTO `system_application` VALUES ('bd23cfc0-d9a7-11ed-9b8e-0911a9c4f732', '查询系统', 'query', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:03:17', '2023-04-13 11:03:17', NULL);

-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT 'id',
  `pid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '父id',
  `menuName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '菜单名',
  `menuCode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '菜单code',
  `application` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '系统code',
  `openType` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '打开方式（菜单：内链、外链、组件）1 主系统内部的 2 wujie的 3 外链',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT 'icon',
  `state` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '是否展示',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '1' COMMENT '状态，（权限 0 锁定 1 正常 2 删除）',
  `sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL COMMENT '备注',
  `createUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `updateUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ref_id_pid`(`id` ASC, `pid` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_menu
-- ----------------------------
INSERT INTO `system_menu` VALUES ('03a95f20-d9ab-11ed-b90f-37a2dded28c6', '941168b0-d9aa-11ed-b67d-7fb0da448c9f', 'menu12', '/menu_children', 'b78891e0-d9a7-11ed-9b8e-0911a9c4f732', '2', NULL, '1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:26:44', '2023-04-13 11:26:44', NULL);
INSERT INTO `system_menu` VALUES ('1eff3b00-d9d8-11ed-a181-03e851b65002', '0', 'menu_21', '/menu_children_21', 'bd23cfc0-d9a7-11ed-9b8e-0911a9c4f732', '2', NULL, '1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 16:49:37', '2023-04-13 16:49:37', NULL);
INSERT INTO `system_menu` VALUES ('941168b0-d9aa-11ed-b67d-7fb0da448c9f', '0', 'menu1', '/menu1', 'b78891e0-d9a7-11ed-9b8e-0911a9c4f732', '2', NULL, '1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:23:37', '2023-04-13 11:23:37', NULL);
INSERT INTO `system_menu` VALUES ('bf155f30-d9aa-11ed-b67d-7fb0da448c9f', '0', 'menu2', '/menu_ada', 'b78891e0-d9a7-11ed-9b8e-0911a9c4f732', '2', NULL, '1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 11:24:49', '2023-04-13 11:24:49', NULL);
INSERT INTO `system_menu` VALUES ('d9b75460-d9d7-11ed-a181-03e851b65002', '0', 'menu_2', '/menu_children_2', 'bd23cfc0-d9a7-11ed-9b8e-0911a9c4f732', '2', NULL, '1', '1', 100, NULL, 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 16:47:41', '2023-04-13 16:47:41', NULL);

-- ----------------------------
-- Table structure for system_role
-- ----------------------------
DROP TABLE IF EXISTS `system_role`;
CREATE TABLE `system_role`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT 'id',
  `pid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '父id',
  `roleName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '角色名字',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '唯一标识',
  `serialNum` int(11) NOT NULL COMMENT '排序',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '1' COMMENT '状态，（权限 0 锁定 1 正常 2 删除）',
  `createUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '创建人Id',
  `updateUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '创建人Id',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `pid`) USING BTREE,
  UNIQUE INDEX `ref_pid_roleName`(`roleName` ASC, `pid` ASC) USING BTREE,
  UNIQUE INDEX `ref_pid`(`pid` ASC, `id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_role
-- ----------------------------
INSERT INTO `system_role` VALUES ('0129f270-df99-11ed-bbba-83833040a054', '610ac050-d9a1-11ed-8235-cd04e329665a', 'child33', 'child33', 50, '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-21 00:32:56', '2023-04-21 00:32:56', NULL);
INSERT INTO `system_role` VALUES ('1742f730-df91-11ed-bbba-83833040a054', '0', '买呢3', 'main333', 50, '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-20 23:36:17', '2023-04-20 23:36:17', NULL);
INSERT INTO `system_role` VALUES ('51f66e20-d9a1-11ed-8235-cd04e329665a', '0', 'demo1', NULL, 50, '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 10:17:20', '2023-04-13 10:17:20', NULL);
INSERT INTO `system_role` VALUES ('53a1d430-d9a1-11ed-8235-cd04e329665a', '0', 'demo2', NULL, 50, '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 10:17:23', '2023-04-13 10:17:23', NULL);
INSERT INTO `system_role` VALUES ('54d2da20-d9a1-11ed-8235-cd04e329665a', '0', 'demo3', NULL, 50, '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 10:17:25', '2023-04-13 10:17:25', NULL);
INSERT INTO `system_role` VALUES ('610ac050-d9a1-11ed-8235-cd04e329665a', '53a1d430-d9a1-11ed-8235-cd04e329665a', 'children1', NULL, 50, '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 10:17:45', '2023-04-13 10:17:45', NULL);
INSERT INTO `system_role` VALUES ('7e7d4650-df8f-11ed-bbba-83833040a054', '0', 'main111', 'main111', 50, '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-20 23:24:51', '2023-04-20 23:24:51', NULL);
INSERT INTO `system_role` VALUES ('aa847170-df8e-11ed-bbba-83833040a054', '610ac050-d9a1-11ed-8235-cd04e329665a', 'mainZZZ', 'mainZZZ', 50, '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-20 23:18:55', '2023-04-20 23:18:55', NULL);
INSERT INTO `system_role` VALUES ('dc5579a0-df8f-11ed-bbba-83833040a054', '0', 'main2222', 'main2222', 50, '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-20 23:27:28', '2023-04-20 23:27:28', NULL);

-- ----------------------------
-- Table structure for system_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_role_menu`;
CREATE TABLE `system_role_menu`  (
  `MenuId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '菜单id',
  `RoleId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '角色id',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '1' COMMENT '状态，（权限 0 锁定 1 正常 2 删除）',
  `createUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `updateUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`MenuId`, `RoleId`) USING BTREE,
  UNIQUE INDEX `system_role_menu_RoleId_MenuId_unique`(`MenuId` ASC, `RoleId` ASC) USING BTREE,
  INDEX `RoleId`(`RoleId` ASC) USING BTREE,
  CONSTRAINT `system_role_menu_ibfk_1` FOREIGN KEY (`MenuId`) REFERENCES `system_menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `system_role_menu_ibfk_2` FOREIGN KEY (`RoleId`) REFERENCES `system_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_role_menu
-- ----------------------------
INSERT INTO `system_role_menu` VALUES ('03a95f20-d9ab-11ed-b90f-37a2dded28c6', '51f66e20-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 14:28:35', '2023-04-13 14:28:35', NULL);
INSERT INTO `system_role_menu` VALUES ('03a95f20-d9ab-11ed-b90f-37a2dded28c6', '53a1d430-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 14:28:35', '2023-04-13 14:28:35', NULL);
INSERT INTO `system_role_menu` VALUES ('03a95f20-d9ab-11ed-b90f-37a2dded28c6', '54d2da20-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 16:15:42', '2023-04-13 16:15:42', NULL);
INSERT INTO `system_role_menu` VALUES ('1eff3b00-d9d8-11ed-a181-03e851b65002', '51f66e20-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-14 10:39:56', '2023-04-14 10:39:56', NULL);
INSERT INTO `system_role_menu` VALUES ('941168b0-d9aa-11ed-b67d-7fb0da448c9f', '51f66e20-d9a1-11ed-8235-cd04e329665a', '0', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 14:28:35', '2023-04-13 14:28:35', NULL);
INSERT INTO `system_role_menu` VALUES ('941168b0-d9aa-11ed-b67d-7fb0da448c9f', '53a1d430-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 14:28:35', '2023-04-13 14:28:35', NULL);
INSERT INTO `system_role_menu` VALUES ('bf155f30-d9aa-11ed-b67d-7fb0da448c9f', '53a1d430-d9a1-11ed-8235-cd04e329665a', '1', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', 'bc3c9cf0-d90b-11ed-ad21-8fa62a2db8a4', '2023-04-13 14:28:35', '2023-04-13 14:28:35', NULL);

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '用户ID',
  `account` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '账号',
  `userName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '密码',
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `sex` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '2' COMMENT '性别(0 男 1 女 2 未知)',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '手机号',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '2' COMMENT '状态，（权限 0 注销 1 正常 2 暂停）',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL COMMENT '自我介绍',
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '所属单位',
  `birthday` int(11) NULL DEFAULT NULL COMMENT '生日',
  `jobNum` int(11) NULL DEFAULT NULL COMMENT '工号',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `account`(`account` ASC) USING BTREE,
  INDEX `ref_userName`(`userName` ASC) USING BTREE,
  INDEX `ref_account`(`account` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_user
-- ----------------------------
INSERT INTO `system_user` VALUES ('6f45c980-d9a1-11ed-8235-cd04e329665a', 'adminAcc1', 'admin1', '96e79218965eb72c92a549dd5a330112', NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, '2023-04-13 10:18:09', '2023-04-19 23:16:34', NULL);
INSERT INTO `system_user` VALUES ('724f11e0-d9a1-11ed-8235-cd04e329665a', 'adminAcc', 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', NULL, '1', NULL, NULL, NULL, NULL, '2023-04-13 10:18:14', '2023-04-19 23:24:16', NULL);
INSERT INTO `system_user` VALUES ('f9fd2e50-de07-11ed-9e6b-479d037046e5', 'zzzz', 'ZZZZ', '111111', NULL, '2', NULL, '2', NULL, NULL, NULL, NULL, '2023-04-19 00:42:15', '2023-04-19 00:42:15', NULL);

-- ----------------------------
-- Table structure for system_user_role
-- ----------------------------
DROP TABLE IF EXISTS `system_user_role`;
CREATE TABLE `system_user_role`  (
  `UserId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '用户id',
  `RoleId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL COMMENT '角色id',
  `status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT '1' COMMENT '状态，（权限 0 锁定 1 正常 2 删除）',
  `createUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `updateUser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `deletedAt` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`UserId`, `RoleId`) USING BTREE,
  UNIQUE INDEX `system_user_role_RoleId_UserId_unique`(`UserId` ASC, `RoleId` ASC) USING BTREE,
  INDEX `RoleId`(`RoleId` ASC) USING BTREE,
  CONSTRAINT `system_user_role_ibfk_1` FOREIGN KEY (`UserId`) REFERENCES `system_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `system_user_role_ibfk_2` FOREIGN KEY (`RoleId`) REFERENCES `system_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of system_user_role
-- ----------------------------
INSERT INTO `system_user_role` VALUES ('6f45c980-d9a1-11ed-8235-cd04e329665a', '51f66e20-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 10:19:24', '2023-04-13 10:19:24', NULL);
INSERT INTO `system_user_role` VALUES ('6f45c980-d9a1-11ed-8235-cd04e329665a', '53a1d430-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 10:19:24', '2023-04-13 10:19:24', NULL);
INSERT INTO `system_user_role` VALUES ('6f45c980-d9a1-11ed-8235-cd04e329665a', '54d2da20-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 10:19:24', '2023-04-13 10:19:24', NULL);
INSERT INTO `system_user_role` VALUES ('724f11e0-d9a1-11ed-8235-cd04e329665a', '51f66e20-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 16:23:56', '2023-04-13 16:23:56', NULL);
INSERT INTO `system_user_role` VALUES ('724f11e0-d9a1-11ed-8235-cd04e329665a', '54d2da20-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 10:20:01', '2023-04-13 10:20:01', NULL);
INSERT INTO `system_user_role` VALUES ('724f11e0-d9a1-11ed-8235-cd04e329665a', '610ac050-d9a1-11ed-8235-cd04e329665a', '1', '818beb60-d938-11ed-b322-314de904cc7a1', '818beb60-d938-11ed-b322-314de904cc7a1', '2023-04-13 10:20:01', '2023-04-13 10:20:01', NULL);
INSERT INTO `system_user_role` VALUES ('f9fd2e50-de07-11ed-9e6b-479d037046e5', '0129f270-df99-11ed-bbba-83833040a054', '1', '724f11e0-d9a1-11ed-8235-cd04e329665a', '724f11e0-d9a1-11ed-8235-cd04e329665a', '2023-04-21 01:04:03', '2023-04-21 01:04:03', NULL);
INSERT INTO `system_user_role` VALUES ('f9fd2e50-de07-11ed-9e6b-479d037046e5', '53a1d430-d9a1-11ed-8235-cd04e329665a', '1', '724f11e0-d9a1-11ed-8235-cd04e329665a', '724f11e0-d9a1-11ed-8235-cd04e329665a', '2023-04-21 01:04:01', '2023-04-21 01:04:01', NULL);
INSERT INTO `system_user_role` VALUES ('f9fd2e50-de07-11ed-9e6b-479d037046e5', '610ac050-d9a1-11ed-8235-cd04e329665a', '1', '724f11e0-d9a1-11ed-8235-cd04e329665a', '724f11e0-d9a1-11ed-8235-cd04e329665a', '2023-04-21 01:04:03', '2023-04-21 01:04:03', NULL);
INSERT INTO `system_user_role` VALUES ('f9fd2e50-de07-11ed-9e6b-479d037046e5', 'aa847170-df8e-11ed-bbba-83833040a054', '1', '724f11e0-d9a1-11ed-8235-cd04e329665a', '724f11e0-d9a1-11ed-8235-cd04e329665a', '2023-04-21 01:04:04', '2023-04-21 01:04:04', NULL);

SET FOREIGN_KEY_CHECKS = 1;