-- 幂等键按账号隔离;创建和继续操作都保存指纹,键相同但请求不同须报冲突。 CREATE TABLE agent_task ( id VARCHAR(36) PRIMARY KEY, user_id VARCHAR(36) NOT NULL, FOREIGN KEY (user_id) REFERENCES app_user(id), parent_id VARCHAR(36), FOREIGN KEY (parent_id) REFERENCES agent_task(id), operation VARCHAR(32) NOT NULL, workflow VARCHAR(32) NOT NULL, skill_version VARCHAR(16) NOT NULL, request_json TEXT NOT NULL, request_hash VARCHAR(64) NOT NULL, idempotency_key VARCHAR(128) NOT NULL, status VARCHAR(32) NOT NULL, question VARCHAR(512), result_json MEDIUMTEXT, max_calls INT NOT NULL, max_cost_units DECIMAL(18,4) NOT NULL, created_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), updated_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), UNIQUE(user_id, idempotency_key) ); CREATE TABLE task_command ( task_id VARCHAR(36) NOT NULL, FOREIGN KEY (task_id) REFERENCES agent_task(id), idempotency_key VARCHAR(128) NOT NULL, request_hash VARCHAR(64) NOT NULL, PRIMARY KEY(task_id, idempotency_key) ); -- 事件 ID 全局递增,同一任务严格有序;先入库后推送,重连只能重放。 CREATE TABLE task_event ( id BIGINT AUTO_INCREMENT PRIMARY KEY, task_id VARCHAR(36) NOT NULL, FOREIGN KEY (task_id) REFERENCES agent_task(id), type VARCHAR(32) NOT NULL, payload MEDIUMTEXT NOT NULL, created_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ); CREATE INDEX idx_event_task ON task_event(task_id, id); CREATE TABLE tool_call ( id VARCHAR(36) PRIMARY KEY, task_id VARCHAR(36) NOT NULL, FOREIGN KEY (task_id) REFERENCES agent_task(id), provider VARCHAR(32) NOT NULL, tool_name VARCHAR(64) NOT NULL, client_version VARCHAR(64) NOT NULL, status VARCHAR(32) NOT NULL, http_status INT, error_code VARCHAR(64), cost_units DECIMAL(18,4), input_tokens BIGINT, output_tokens BIGINT, actual_model VARCHAR(128), duration_ms BIGINT, created_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ); CREATE TABLE evidence ( id VARCHAR(36) PRIMARY KEY, task_id VARCHAR(36) NOT NULL, FOREIGN KEY (task_id) REFERENCES agent_task(id), tool_call_id VARCHAR(36) NOT NULL, FOREIGN KEY (tool_call_id) REFERENCES tool_call(id), source_url TEXT, locator VARCHAR(256), excerpt TEXT NOT NULL, created_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ); -- D1 只建文件元数据表,不开放尚未实现权限、解析与清理的上传接口。 CREATE TABLE temporary_file ( id VARCHAR(36) PRIMARY KEY, user_id VARCHAR(36) NOT NULL, FOREIGN KEY (user_id) REFERENCES app_user(id), task_id VARCHAR(36), FOREIGN KEY (task_id) REFERENCES agent_task(id), purpose VARCHAR(32) NOT NULL, media_type VARCHAR(128) NOT NULL, sha256 VARCHAR(64) NOT NULL, storage_path VARCHAR(512), status VARCHAR(32) NOT NULL, expires_at TIMESTAMP(6) NOT NULL, deleted_at TIMESTAMP(6), created_at TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) );