create table sys_role
(
    role_id             bigint                       not null comment '角色ID'
        primary key,
    tenant_id           varchar(20) default '000000' null comment '租户编号',
    role_name           varchar(30)                  not null comment '角色名称',
    role_key            varchar(100)                 not null comment '角色权限字符串',
    role_sort           int                          not null comment '显示顺序',
    data_scope          char        default '1'      null comment '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限 5：仅本人数据权限 6：部门及以下或本人数据权限）',
    menu_check_strictly tinyint(1)  default 1        null comment '菜单树选择项是否关联显示',
    dept_check_strictly tinyint(1)  default 1        null comment '部门树选择项是否关联显示',
    status              char                         not null comment '角色状态（0正常 1停用）',
    del_flag            char        default '0'      null comment '删除标志（0代表存在 1代表删除）',
    create_dept         bigint                       null comment '创建部门',
    create_by           bigint                       null comment '创建者',
    create_time         datetime                     null comment '创建时间',
    update_by           bigint                       null comment '更新者',
    update_time         datetime                     null comment '更新时间',
    remark              varchar(500)                 null comment '备注'
)
    comment '角色信息表';

INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', '超级管理员', 'superadmin', 1, '1', 1, 1, '0', '0', 103, 1, '2025-08-23 21:51:22', null, null, '超级管理员');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', '本部门及以下', 'test1', 3, '4', 1, 1, '0', '1', 103, 1, '2025-08-23 21:51:22', 1, '2025-08-25 21:30:58', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (4, '000000', '仅本人', 'test2', 4, '3', 1, 1, '0', '1', 103, 1, '2025-08-23 21:51:22', 1, '2025-08-25 21:30:43', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959256835782897665, '889144', '管理员', 'admin', 1, '1', 1, 1, '0', '1', 103, 1, '2025-08-23 22:10:06', 1, '2025-08-25 21:33:47', null);
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959924482642579458, '889144', '技术总监', 'jszj', 2, '4', 1, 1, '0', '1', 103, 1, '2025-08-25 18:23:05', 1, '2025-08-25 21:33:45', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959973642972467201, '889144', '总经理', 'zjl', 1, '1', 1, 1, '0', '0', 103, 1, '2025-08-25 21:38:26', 1, '2025-08-25 21:38:26', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959973751676243970, '889144', '副总经理', 'fzjl', 1, '1', 1, 1, '0', '0', 103, 1, '2025-08-25 21:38:52', 1, '2025-08-25 21:38:52', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959973862762385409, '889144', '研发经理', 'yfjl', 1, '1', 1, 1, '0', '0', 103, 1, '2025-08-25 21:39:18', 1, '2025-08-25 21:39:18', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1959976407475982337, '841063', '管理员', 'admin', 1, '4', 1, 1, '0', '0', 103, 1, '2025-08-25 21:49:25', 1, '2025-08-25 21:54:51', null);
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960316477504557058, '938163', '管理员', 'admin', 1, '1', 1, 1, '0', '0', 103, 1, '2025-08-26 20:20:44', 1, '2025-08-26 20:20:44', null);
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1960317682385489921, '938163', '暗部', 'anbu', 1, '1', 1, 1, '0', '0', 1960316477680717825, 1960316478058205186, '2025-08-26 20:25:31', 1960316478058205186, '2025-08-26 20:25:31', '');
INSERT INTO ruoyi.sys_role (role_id, tenant_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1970143865193107458, '000000', 'test', 'test', 1, '1', 1, 1, '0', '0', 103, 1, '2025-09-22 23:11:16', 1, '2025-09-22 23:11:16', '');
