Query

avatarai.db — Capabilities

SQL

CREATE TABLE "Capabilities"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_Capabilities" PRIMARY KEY,
  "Name" TEXT NOT NULL,
  "DisplayName" TEXT NOT NULL,
  "Description" TEXT NOT NULL,
  "DefaultAgentPrompt" TEXT NOT NULL,
  "DefaultFallbackMessage" TEXT NOT NULL,
  "DefaultRouterExamples" TEXT NOT NULL,
  "IsSystem" INTEGER NOT NULL,
  "CreatedAt" TEXT NOT NULL,
  "DefaultModel" TEXT NOT NULL DEFAULT '',
  "DefaultProvider" TEXT NOT NULL DEFAULT '',
  "FallbackModel" TEXT NOT NULL DEFAULT '',
  "FallbackProvider" TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Name TEXT Rename | Drop
DisplayName TEXT Rename | Drop
Description TEXT Rename | Drop
DefaultAgentPrompt TEXT Rename | Drop
DefaultFallbackMessage TEXT Rename | Drop
DefaultRouterExamples TEXT Rename | Drop
IsSystem INTEGER Rename | Drop
CreatedAt TEXT Rename | Drop
DefaultModel TEXT Rename | Drop
DefaultProvider TEXT Rename | Drop
FallbackModel TEXT Rename | Drop
FallbackProvider TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_Capabilities_Name Name ✓ SQL 
CREATE UNIQUE INDEX "IX_Capabilities_Name"
ON "Capabilities" ("Name")
Drop
sqlite_autoindex_Capabilities_1 Id ✓ SQL
-- no sql found --
 Drop