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(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `user_id` BIGINT(10) NOT NULL COMMENT '用户ID',
    `role_id` BIGINT(10) NOT NULL COMMENT '角色ID'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户角色关系表';

INSERT INTO sys_user_role_relation(user_id, role_id) VALUES
    (1, 1), (2, 1), (3, 2), (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)
;