AgentServer/apps/server/drizzle/0003_profile_versions.sql

CREATE TABLE `profile_versions` (
	`profile_id` text NOT NULL,
	`version` integer NOT NULL,
	`snapshot` text NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	PRIMARY KEY(`profile_id`, `version`)
);
--> statement-breakpoint
-- 数据迁移：为现有 Profile 保存当前版本的快照
INSERT INTO `profile_versions` (`profile_id`, `version`, `snapshot`, `created_at`)
SELECT `id`, `version`, json_object(
  'name', `name`, 'description', `description`, 'provider', `provider`, 'model', `model`, 'systemPrompt', `system_prompt`,
  'permissionMode', `permission_mode`, 'allowedTools', json(`allowed_tools`), 'disallowedTools', json(`disallowed_tools`),
  'skills', json(`skills`), 'fileAccess', json(`file_access`), 'knowledgeRootIds', json(`knowledge_root_ids`)
), `updated_at`
FROM `profiles`;