0022_mcp_credentials.sql 570 B

12345678910111213
  1. CREATE TABLE `mcp_credentials` (
  2. `id` text PRIMARY KEY NOT NULL,
  3. `name` text NOT NULL,
  4. `description` text DEFAULT '' NOT NULL,
  5. `kind` text NOT NULL,
  6. `values` text DEFAULT '{}' NOT NULL,
  7. `url_prefixes` text DEFAULT '[]' NOT NULL,
  8. `created_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL,
  9. `updated_at` text DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')) NOT NULL
  10. );
  11. --> statement-breakpoint
  12. CREATE UNIQUE INDEX `mcp_credentials_name_unique` ON `mcp_credentials` (`name`);--> statement-breakpoint
  13. ALTER TABLE `mcp_servers` ADD `credential_id` text;