| 12345678910111213141516171819202122232425262728293031323334 |
- 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', '');
|
