create table sys_project
(
    id           int auto_increment comment '主键索引'
        primary key,
    tenant_id    varchar(255) default '000000'          not null,
    dept_id      bigint       default 0                 not null comment '部门id',
    organization varchar(500)                           not null comment '组织名称',
    project      varchar(500)                           not null comment '项目名称',
    private_key  longtext                               not null comment '私钥',
    public_key   varchar(255)                           not null comment '公钥',
    model_ids    longtext                               not null comment '模型仓库',
    rag_ids      longtext                               null comment '知识库仓库',
    agent_ids    longtext                               null comment '智能体权限',
    create_dept  bigint       default 0                 not null comment '创建部门',
    create_by    bigint       default 0                 not null comment '创建者',
    create_time  datetime     default CURRENT_TIMESTAMP not null comment '创建时间',
    update_by    bigint       default 0                 not null comment '更新者',
    update_time  datetime     default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    del_flag     varchar(255) default '0'               null comment '删除标识（0-存在；1-删除）'
)
    comment '项目表' row_format = DYNAMIC;

INSERT INTO ruoyi.sys_project (id, tenant_id, dept_id, organization, project, private_key, public_key, model_ids, rag_ids, agent_ids, create_dept, create_by, create_time, update_by, update_time, del_flag) VALUES (1, '000000', 0, 'org1', 'project1', 'dlaskjdlasjdlajslkj', 'aslkdjlasjdlkasjdljal', '["1", "2"]', '["1", "2"]', '["1", "2"]', 0, 0, '2025-08-29 10:42:32', 0, '2025-08-29 10:42:32', '0');
INSERT INTO ruoyi.sys_project (id, tenant_id, dept_id, organization, project, private_key, public_key, model_ids, rag_ids, agent_ids, create_dept, create_by, create_time, update_by, update_time, del_flag) VALUES (2, '000000', 0, 'org1', 'project2', 'dlaskjdlasjdlajslkj', 'aslkdjlasjdlkasjdljal', '["1", "2"]', '["1", "2"]', '["1", "2"]', 0, 0, '2025-08-29 10:42:32', 0, '2025-08-29 10:42:32', '0');
INSERT INTO ruoyi.sys_project (id, tenant_id, dept_id, organization, project, private_key, public_key, model_ids, rag_ids, agent_ids, create_dept, create_by, create_time, update_by, update_time, del_flag) VALUES (3, '00001', 0, 'org1', 'project2', 'dlaskjdlasjdlajslkj', 'aslkdjlasjdlkasjdljal', '["1", "2"]', '["1", "2"]', '["1", "2"]', 0, 0, '2025-08-29 10:42:32', 0, '2025-08-29 10:42:32', '0');
