yvjia/db/sys_user_role_permission_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_permission_relation`;
CREATE TABLE `sys_user_role_permission_relation` (
    PRIMARY KEY (`id`),
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `role_id` BIGINT NOT NULL COMMENT '角色ID',
    `permission_id` VARCHAR(10) NOT NULL COMMENT '权限ID',
    INDEX `idx_role_id` (`role_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统角色权限关系表';

INSERT INTO sys_user_role_permission_relation(role_id, permission_id) VALUES
    (1, '1'),
        (1, '1.1'),
#         (1, '1.2'),
#         (1, '1.3'),
#             (1, '1.3.1'), (1, '1.3.2'), (1, '1.3.3'),

    (1, '2'),

    (1, '3'),
        (1, '3.1'),
        (1, '3.2'),
            (1, '3.2.1'), (1, '3.2.1.2'), (1, '3.2.2'),
            (1, '3.2.3'),
                (1, '3.2.3.2'), (1, '3.2.3.3'), (1, '3.2.3.4'),
            (1, '3.2.4'), (1, '3.2.5'), (1, '3.2.6'), (1, '3.2.7'),
        (1, '3.3'),
            (1, '3.3.1'), (1, '3.3.2'), (1, '3.3.3'),
            (1, '3.3.4'),
        (1, '3.4'),
            (1, '3.4.1'), (1, '3.4.1.2'),
        (1, '3.5'),
            (1, '3.5.1'), (1, '3.5.1.2'),
    (1, '4'),
        (1, '4.1'),
            (1, '4.1.1'), (1, '4.1.2'), (1, '4.1.3'), (1, '4.1.4'), (1, '4.1.5'),
        (1, '4.3'),
            (1, '4.3.1'), (1, '4.3.2'), (1, '4.3.3'), (1, '4.3.4'),
    (1, '5'),
        (1, '5.1'),
    (1, '6'),
        (1, '6.1'),
            (1, '6.1.1'), (1, '6.1.3'),
    (1, '10'),
        (1, '10.1'),
            (1, '10.1.1'), (1, '10.1.2'), (1, '10.1.3'), (1, '10.1.4'),
        (1, '10.2'),
            (1, '10.2.1'), (1, '10.2.2'), (1, '10.2.3'), (1, '10.2.4'),
        (1, '10.3'),
            (1, '10.3.1'), (1, '10.3.2'), (1, '10.3.3'), (1, '10.3.4'),
#     (1, '11'),
#         (1, '11.1'),
#             (1, '11.1.1'), (1, '11.1.2'), (1, '11.1.3'), (1, '11.1.4'),
#         (1, '11.2'),
#             (1, '11.2.1'), (1, '11.2.2'), (1, '11.2.3'), (1, '11.2.4'),
#         (1, '11.3'),
#             (1, '11.3.1'), (1, '11.3.2'), (1, '11.3.3'), (1, '11.3.4'),
#         (1, '11.4'),
#             (1, '11.4.1'), (1, '11.4.2'), (1, '11.4.3'), (1, '11.4.4'),
#         (1, '11.5'),
#             (1, '11.5.1'), (1, '11.5.2'), (1, '11.5.3'), (1, '11.5.4'),
#         (1, '11.6'),
#             (1, '11.6.1'), (1, '11.6.2'), (1, '11.6.3'), (1, '11.6.4'),
#     (1, '12'),
#         (1, '12.1'),
#         (1, '12.2'),
#         (1, '12.3'),
    (1, '13'),
        (1, '13.1'),
    (1, '14'),
        (1, '14.3'),
            (1, '14.3.1'), (1, '14.3.2'), (1, '14.3.3'), (1, '14.3.4'),

    (1, '20'),
        (1, '20.1'),
            (1, '20.1.1'), (1, '20.1.2'), (1, '20.1.3'), (1, '20.1.4'), (1, '20.1.5'), (1, '20.1.6'),
        (1, '20.2'),
            (1, '20.2.1'), (1, '20.2.2'), (1, '20.2.3'), (1, '20.2.4'),

    (1, '21'),
        (1, '21.1'),
            (1, '21.1.1'), (1, '21.1.2'), (1, '21.1.3'), (1, '21.1.4'), (1, '21.1.5'), (1, '21.1.6'),
        (1, '21.2'),
            (1, '21.2.1'), (1, '21.2.2'), (1, '21.2.3'), (1, '21.2.4'),
        (1, '21.3'),
            (1, '21.3.1'), (1, '21.3.2'), (1, '21.3.3'), (1, '21.3.4'),

    (1, '31'),
        (1, '31.1'),
    (1, '32'),
        (1, '32.1'),
    (1, '33'),
        (1, '33.1'),
    (1, '34'),
        (1, '34.1'),
    (1, '35'),
        (1, '35.1'),


    (2, '1'),
        (2, '1.1'),
    (2, '2'),

    (2, '3.2.1'),
    (2, '4.1'),

    (2, '31'),
    (2, '32'),
    (2, '33'),
    (2, '34'),
    (2, '35'),

    (3, '3'),
        (3, '3.1'),
        (3, '3.2'),
            (3, '3.2.1'), (1, '3.2.1.2'), (1, '3.2.2'),
    (3, '4'),
        (3, '4.1'),
            (3, '4.1.1'), (3, '4.1.2'), (3, '4.1.3'), (3, '4.1.4'), (3, '4.1.5')
;