CREATE TABLE `skill_publish_keys` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`key_hash` text NOT NULL,
	`key_prefix` text NOT NULL,
	`enabled` integer DEFAULT true NOT NULL,
	`expires_at` text,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
	`last_used_at` text,
	`last_used_ip` text
);
--> statement-breakpoint
CREATE UNIQUE INDEX `skill_publish_keys_key_hash_unique` ON `skill_publish_keys` (`key_hash`);--> statement-breakpoint
CREATE TABLE `skill_submission_items` (
	`id` text PRIMARY KEY NOT NULL,
	`submission_id` text NOT NULL,
	`name` text NOT NULL,
	`description` text DEFAULT '' NOT NULL,
	`declared_version` text,
	`files` text NOT NULL,
	`checks` text DEFAULT '[]' NOT NULL,
	`status` text NOT NULL,
	`reason` text,
	`review_note` text,
	`reviewed_at` text,
	`result` text,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
CREATE TABLE `skill_submissions` (
	`id` text PRIMARY KEY NOT NULL,
	`key_id` text NOT NULL,
	`key_name` text NOT NULL,
	`message` text DEFAULT '' NOT NULL,
	`meta` text DEFAULT '{}' NOT NULL,
	`package_sha` text NOT NULL,
	`package_size` integer NOT NULL,
	`created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
);
--> statement-breakpoint
ALTER TABLE `custom_skill_versions` ADD `note` text;