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 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.1.1'), (1, '1.1.2'), (1, '1.1.3'), (1, '1.1.4'), (1, '1.1.5'), (1, '1.1.6'),

    (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.3.5'),
            (1, '3.2.4'),
            (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, '10.4'),
            (1, '10.4.1'), (1, '10.4.2'), (1, '10.4.3'), (1, '10.4.4'),
        (1, '10.5'),
            (1, '10.5.1'),
        (1, '10.6'),
            (1, '10.6.1'), (1, '10.6.2'), (1, '10.6.3'), (1, '10.6.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, '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.2'),
        (1, '20.3'),
        (1, '20.4'),
            (1, '20.4.1'),

#     (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, '32'),
        (1, '32.1'),
    (1, '33'),
        (1, '33.1'),
    (1, '34'),
        (1, '34.1'),
    (1, '35'),
        (1, '35.1'),

    (1, '36'),
        (1, '36.1'),
            (1, '36.1.1'),
            (1, '36.1.2'),
            (1, '36.1.3'),
            (1, '36.1.4'), (1, '36.1.4.1'),
            (1, '36.1.5'), (1, '36.1.5.1'),
            (1, '36.1.6'), (1, '36.1.6.1'),
        (1, '36.2'),
            (1, '36.2.1'),
            (1, '36.2.2'),
            (1, '36.2.3'), (1, '36.2.3.1'),
            (1, '36.2.4'), (1, '36.2.4.1'),
            (1, '36.2.5'), (1, '36.2.5.1'),
            (1, '36.2.6'), (1, '36.2.6.1'),
        (1, '36.3'),
        (1, '36.4'),
    (1, '37'),
        (1, '37.1'),
            (1, '37.1.1'),
            (1, '37.1.2'),
            (1, '37.1.3'),
            (1, '37.1.4'),
            (1, '37.1.5'),

    (1, '100'),
        (1, '101'),


    (2, '1'),
        (2, '1.1'),
            (2, '1.1.1'), (2, '1.1.2'), (2, '1.1.3'), (2, '1.1.4'), (2, '1.1.5'), (2, '1.1.6'),

    (2, '2'),
    (2, '3'),
        (2, '3.1'),
        (2, '3.2'),
            (2, '3.2.1'),
                (2, '3.2.1.2'),
            (2, '3.2.3'),
                (2, '3.2.3.2'),
            (2, '3.2.4'),
            (2, '3.2.6'),
            (2, '3.2.7'),
        (2, '3.3'),
            (2, '3.3.1'), (2, '3.3.2'), (2, '3.3.3'), (2, '3.3.4'),
        (2, '3.4'),
            (2, '3.4.1'), (2, '3.4.1.2'),
        (2, '3.5'),
            (2, '3.5.1'), (2, '3.5.1.2'),

    (2, '4'),
        (2, '4.1'),
            (2, '4.1.1'), (2, '4.1.2'), (2, '4.1.3'), (2, '4.1.4'), (2, '4.1.5'),
        (2, '4.3'),
            (2, '4.3.1'), (2, '4.3.2'), (2, '4.3.3'), (2, '4.3.4'),
    (2, '5'),
        (2, '5.1'),
    (2, '6'),
        (2, '6.1'),
            (2, '6.1.1'), (2, '6.1.3'),

    (2, '31'),

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

    (3, '2'),

    # 运营-素材管理者
    (4, '1.1.2'), (4, '1.1.3'), (4, '1.1.6'),
#     (4, '3.2.1'),
    (4, '3.2.3.3'), (4, '3.5.1'),
    (4, '20'),
        (4, '20.1'),
            (4, '20.1.1'), (4, '20.1.2'), (4, '20.1.3'), (4, '20.1.4'), (4, '20.1.5'),
        (4, '20.2'),
        (4, '20.3'),
        (4, '20.4'),
            (4, '20.4.1'),

    # 运营-素材使用者
    (5, '1.1.2'), (5, '1.1.3'), (5, '1.1.6'),
#     (5, '3.2.1'),
    (5, '3.2.3.3'), (5, '3.5.1'),
    (5, '20'),
        (5, '20.1'),
            (5, '20.1.1'), (5, '20.1.5'),
        (5, '20.2'),
        (5, '20.3'),

    # 运营-素材游客
#     (6, '3.2.1'),
    (6, '1.1.3'),
    (6, '3.2.3.3'), (6, '3.5.1'),
    (6, '20'),
        (6, '20.1'),
            (6, '20.1.1'),
    (6, '20.2'),
    (6, '20.3')
;