CREATE TABLE `knowledge_collections` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`root_ids` text DEFAULT '[]' NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`updated_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `knowledge_collections_name_unique` ON `knowledge_collections` (`name`);--> statement-breakpoint
PRAGMA foreign_keys=OFF;--> statement-breakpoint
CREATE TABLE `__new_knowledge_roots` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`kind` text DEFAULT 'managed' NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`access` text DEFAULT 'read' NOT NULL,
	`enabled` integer DEFAULT true NOT NULL,
	`source` text,
	`secrets` text DEFAULT '{}' NOT NULL,
	`url` text,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`updated_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
INSERT INTO `__new_knowledge_roots`("id", "name", "kind", "description", "access", "enabled", "source", "secrets", "url", "created_at", "updated_at") SELECT "id", "name", 'local', "description", 'read', "enabled", json_object('path', "path", 'uuid', NULL, 'relPath', NULL), '{}', NULL, "created_at", "updated_at" FROM `knowledge_roots`;--> statement-breakpoint
DROP TABLE `knowledge_roots`;--> statement-breakpoint
ALTER TABLE `__new_knowledge_roots` RENAME TO `knowledge_roots`;--> statement-breakpoint
PRAGMA foreign_keys=ON;--> statement-breakpoint
ALTER TABLE `profiles` ADD `knowledge_collection_ids` text DEFAULT '[]' NOT NULL;