create table sys_role
(
    id          varchar(20)          not null comment '角色id'
        primary key,
    sr_name     varchar(30)          not null comment '角色名称',
    sr_key      varchar(20)          not null comment '角色权限字符串',
    sr_remark   varchar(500)         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_role_key
        unique (sr_key) comment '角色权限key唯一索引'
)
    comment '角色信息';

INSERT INTO sys_role (id, sr_name, sr_key, sr_remark, create_date, update_date, delete_date, deleted)
VALUES ('1', '管理员', 'ROLE_admin', '管理员', '2020-06-22 08:58:26', '2020-06-22 08:58:26', null, 0);
INSERT INTO sys_role (id, sr_name, sr_key, sr_remark, create_date, update_date, delete_date, deleted)
VALUES ('2', '普通角色', 'ROLE_common', '普通角色', '2020-06-22 08:58:26', '2020-06-22 08:58:26', null, 0);