yvjia/db/sys_user_role_relation.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_user_role_relation`;
CREATE TABLE `sys_user_role_relation` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `role_id` BIGINT NOT NULL COMMENT '角色ID',
    INDEX `idx_user_id` (`user_id`),
    INDEX `idx_role_id` (`role_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户角色关系表';

INSERT INTO sys_user_role_relation(user_id, role_id) VALUES
    (1, 1), (2, 2), (3, 3), (4, 2), (5, 2), (6, 2),
    (7, 2), (8, 2), (9, 2), (10, 2), (11, 2), (12, 2),
    (13, 1), (14, 1), (15, 1), (16, 1)
;