Query

avatarai.db — AvatarCapabilities

SQL

CREATE TABLE "AvatarCapabilities"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_AvatarCapabilities" PRIMARY KEY,
  "AvatarId" TEXT NOT NULL,
  "CapabilityId" TEXT NOT NULL,
  "IsEnabled" INTEGER NOT NULL,
  "Priority" INTEGER NOT NULL,
  "CustomAgentPrompt" TEXT NULL,
  "CustomFallbackMessage" TEXT NULL,
  "CustomRouterExamples" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NULL,
  "CustomModel" TEXT NULL,
  "CustomProvider" TEXT NULL,
  CONSTRAINT "FK_AvatarCapabilities_Avatars_AvatarId" FOREIGN KEY ("AvatarId") REFERENCES "Avatars" ("Id") ON DELETE CASCADE,
  CONSTRAINT "FK_AvatarCapabilities_Capabilities_CapabilityId" FOREIGN KEY ("CapabilityId") REFERENCES "Capabilities" ("Id") ON DELETE RESTRICT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
CapabilityId TEXT Rename | Drop
IsEnabled INTEGER Rename | Drop
Priority INTEGER Rename | Drop
CustomAgentPrompt TEXT ✓ Rename | Drop
CustomFallbackMessage TEXT ✓ Rename | Drop
CustomRouterExamples TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT ✓ Rename | Drop
CustomModel TEXT ✓ Rename | Drop
CustomProvider TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
CapabilityId Capabilities.Id
AvatarId Avatars.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_AvatarCapabilities_AvatarId_CapabilityId
  • AvatarId
  • CapabilityId
 ✓ SQL 
CREATE UNIQUE INDEX "IX_AvatarCapabilities_AvatarId_CapabilityId"
ON "AvatarCapabilities" ("AvatarId", "CapabilityId")
Drop
IX_AvatarCapabilities_CapabilityId CapabilityId SQL 
CREATE INDEX "IX_AvatarCapabilities_CapabilityId"
ON "AvatarCapabilities" ("CapabilityId")
Drop
sqlite_autoindex_AvatarCapabilities_1 Id ✓ SQL
-- no sql found --
 Drop