1.权限配置检查
  对应属性需配置为 security_admin
      casic:
        video:
          admin:
            role: security_admin
1.租户设定更新
  创建租户设定角色 角色别名必须是tenantAdministrator

  分配给管理员 需手动入库授权, sys_user表 role_id字段添加租户设定字段,
  sys_ru_relation 添加用户绑定关系

  INSERT INTO  sys_tenant(ID, TENANT_NAME, TENANT_CODE, LINK_PERSON, TEL, CLEARDAY, FLAG, TS) VALUES (1, '航天二院', '001', NULL, NULL, NULL, '0', '2025-02-21 14:41:20');

  ALTER TABLE sys_user_group ADD COLUMN tenant_id VARCHAR(64);
  ALTER TABLE sys_group_device ADD COLUMN tenant_id VARCHAR(64);
  ALTER TABLE sys_group_rel_user ADD COLUMN tenant_id VARCHAR(64);
    ALTER TABLE device_group_info ADD COLUMN tenant_id VARCHAR(64);
  update device_group_info set tenant_id = 1;
  update sys_user set tenant_id = 1;
  update sys_role set tenant_id = 1;
  update sys_rm_relation  set tenant_id = 1;
  update sys_ru_relation  set tenant_id = 1;
  update sys_dept set   tenant_id = 1;
  update  sys_user_group set   tenant_id = 1;
  update  sys_group_device set   tenant_id = 1;
  update   sys_group_rel_user set   tenant_id = 1;
  添加租户ID 0

2.表risk_point_info 字段 secret_level值密级默认 0 设定

3.新增表 sys_user_risk_group  sys_risk_group_rel_user sys_risk_group_point

CREATE TABLE sys_user_risk_group
(
 id numeric(20,0) NOT NULL,
 group_name VARCHAR(256),
 create_time date,
 dept_id numeric(20,0),
 create_id numeric(20,0),
 description VARCHAR(256),
 safe SMALLINT,
 group_type SMALLINT,
 tenant_id VARCHAR(64),
 PRIMARY KEY (id)
);

CREATE TABLE sys_risk_group_rel_user
(
   id                   numeric(20,0) NOT NULL,
   group_id             numeric(20,0),
   user_id              numeric(20,0),
   create_time          date,
   tenant_id            VARCHAR(64)
);

CREATE TABLE sys_risk_group_point
(
   id                   numeric(20,0) NOT NULL,
   group_id             numeric(20,0),
   create_time          date,
   target_id            numeric(20,0),
   tenant_id            VARCHAR(64)
);