Query

avatarai.db — Avatars

SQL

CREATE TABLE Avatars  (
  Id TEXT NOT NULL CONSTRAINT PK_Avatars PRIMARY KEY,
  Name TEXT NOT NULL,
  Description TEXT NOT NULL,
  SystemPrompt TEXT NOT NULL,
  CreatedAt TEXT NOT NULL,
  UserId TEXT NOT NULL,
  WhatsAppEnabled INTEGER NOT NULL DEFAULT 0,
  WhatsAppNumber TEXT NULL,
  CapabilityCode TEXT NOT NULL DEFAULT 'GeneralChat',
  ModelName TEXT NULL DEFAULT phi,
  Agent24x7Enabled INTEGER NOT NULL DEFAULT (1),
  LiveChatEnabled INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
Name TEXT Rename | Drop
Description TEXT Rename | Drop
SystemPrompt TEXT Rename | Drop
CreatedAt TEXT Rename | Drop
UserId TEXT Rename | Drop
WhatsAppEnabled INTEGER Rename | Drop
WhatsAppNumber TEXT ✓ Rename | Drop
CapabilityCode TEXT Rename | Drop
ModelName TEXT ✓ Rename | Drop
Agent24x7Enabled INTEGER Rename | Drop
LiveChatEnabled INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_Avatars_1 Id ✓ SQL
-- no sql found --
 Drop