create table sys_role_perm
(
    id          varchar(20)          not null comment '主键id'
        primary key,
    role_id     varchar(20)          not null comment '角色ID',
    perm_id     varchar(20)          not null comment '权限ID',
    create_date datetime             null comment '创建时间',
    update_date datetime             null comment '更新时间',
    delete_date datetime             null comment '删除时间',
    deleted     tinyint(1) default 0 not null,
    constraint role_id
        unique (role_id, perm_id)
)
    comment '角色和菜单关联表';

INSERT INTO sys_role_perm (id, role_id, perm_id, create_date, update_date, delete_date, deleted)
VALUES ('', '1', '5', '2021-11-23 17:49:28', null, null, 0);