Query

avatarai.db — ChatMessages

SQL

CREATE TABLE "ChatMessages"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_ChatMessages" PRIMARY KEY,
  "AvatarId" TEXT NOT NULL,
  "Role" TEXT NOT NULL,
  "Content" TEXT NOT NULL,
  "Timestamp" TEXT NOT NULL,
  "IsUser" INTEGER NOT NULL DEFAULT 0,
  "UserId" TEXT NOT NULL DEFAULT '',
  "ClientId" TEXT NOT NULL DEFAULT '',
  CONSTRAINT "FK_ChatMessages_Avatars_AvatarId" FOREIGN KEY ("AvatarId") REFERENCES "Avatars" ("Id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
AvatarId TEXT Rename | Drop
Role TEXT Rename | Drop
Content TEXT Rename | Drop
Timestamp TEXT Rename | Drop
IsUser INTEGER Rename | Drop
UserId TEXT Rename | Drop
ClientId TEXT Rename | Drop

Foreign Keys

Column Destination
AvatarId Avatars.Id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_ChatMessages_AvatarId AvatarId SQL 
CREATE INDEX "IX_ChatMessages_AvatarId"
ON "ChatMessages" ("AvatarId")
Drop
sqlite_autoindex_ChatMessages_1 Id ✓ SQL
-- no sql found --
 Drop