| 12345678910111213141516171819202122232425 |
- 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');
|
