create table sys_perm
(
    id          varchar(20)             not null comment '权限id'
        primary key,
    sp_name     varchar(50)             not null comment '权限名称',
    sp_key      varchar(20)             null comment '权限标识',
    sp_remark   varchar(500) default '' null comment '备注',
    create_date datetime                null comment '创建时间',
    update_date datetime                null comment '更新时间',
    delete_date datetime                null comment '删除时间',
    deleted     tinyint(1)   default 0  not null,
    constraint ux_perms_key
        unique (sp_key) comment '权限key唯一索引'
)
    comment '菜单权限表';

INSERT INTO sys_perm (id, sp_name, sp_key, sp_remark, create_date, update_date, delete_date, deleted)
VALUES ('1', '查看用户权限', 'system:user:list', '', '2020-11-02 09:16:31', null, null, 0);
INSERT INTO sys_perm (id, sp_name, sp_key, sp_remark, create_date, update_date, delete_date, deleted)
VALUES ('2', '更新用户权限', 'system:user:update', '', '2020-11-02 09:16:31', null, null, 0);
INSERT INTO sys_perm (id, sp_name, sp_key, sp_remark, create_date, update_date, delete_date, deleted)
VALUES ('3', '删除用户权限', 'system:user:remove', '', '2020-11-02 09:16:31', null, null, 0);
INSERT INTO sys_perm (id, sp_name, sp_key, sp_remark, create_date, update_date, delete_date, deleted)
VALUES ('4', '添加用户权限', 'system:user:insert', '', '2020-11-02 09:16:31', null, null, 0);
INSERT INTO sys_perm (id, sp_name, sp_key, sp_remark, create_date, update_date, delete_date, deleted)
VALUES ('5', '用户所有权限', 'system:user:*', '', '2020-11-02 09:16:31', null, null, 0);