Query

avatarai.db — ChatMessages

+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop