Query

avatarai.db — CacheConversations

SQL

CREATE TABLE "CacheConversations"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_CacheConversations" PRIMARY KEY,
  "AvatarId" TEXT NOT NULL,
  "CapabilityName" TEXT NOT NULL,
  "UserMessage" TEXT NOT NULL,
  "UserMessageEmbedding" BLOB NOT NULL,
  "PreviousContext" TEXT NULL,
  "CachedResponse" TEXT NOT NULL,
  "HitCount" INTEGER NOT NULL,
  "LastUsedAt" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "ExpiresAt" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
CapabilityName TEXT Rename | Drop
UserMessage TEXT Rename | Drop
UserMessageEmbedding BLOB Rename | Drop
PreviousContext TEXT ✓ Rename | Drop
CachedResponse TEXT Rename | Drop
HitCount INTEGER Rename | Drop
LastUsedAt TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
ExpiresAt TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_cache_avatar_capability
  • AvatarId
  • CapabilityName
 SQL 
CREATE INDEX "idx_cache_avatar_capability"
ON "CacheConversations" ("AvatarId", "CapabilityName")
Drop
idx_cache_created CreatedAt SQL 
CREATE INDEX "idx_cache_created"
ON "CacheConversations" ("CreatedAt")
Drop
idx_cache_expires ExpiresAt SQL 
CREATE INDEX "idx_cache_expires"
ON "CacheConversations" ("ExpiresAt")
Drop
idx_cache_hits HitCount SQL 
CREATE INDEX "idx_cache_hits"
ON "CacheConversations" ("HitCount")
Drop
sqlite_autoindex_CacheConversations_1 Id ✓ SQL
-- no sql found --
 Drop