AgentServer/apps/server/drizzle/0005_custom_skills.sql

CREATE TABLE `custom_skill_versions` (
	`skill_id` text NOT NULL,
	`version` integer NOT NULL,
	`reason` text NOT NULL,
	`files` text NOT NULL,
	`changed` text NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	PRIMARY KEY(`skill_id`, `version`)
);
--> statement-breakpoint
CREATE TABLE `custom_skills` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`origin` text NOT NULL,
	`source_id` text,
	`enabled` integer DEFAULT true NOT NULL,
	`include_in_all` integer DEFAULT false NOT NULL,
	`published_version` integer,
	`latest_version` integer DEFAULT 0 NOT NULL,
	`working_files` 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 `custom_skills_name_unique` ON `custom_skills` (`name`);--> statement-breakpoint
CREATE TABLE `skill_sources` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`kind` text NOT NULL,
	`path` text NOT NULL,
	`sync_mode` text DEFAULT 'manual' NOT NULL,
	`interval_min` integer DEFAULT 10 NOT NULL,
	`last_sync_at` text,
	`last_sync_digest` text,
	`status` text DEFAULT 'never' NOT NULL,
	`last_error` 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
);