Query

database.sqlite — agents_messages

SQL

CREATE TABLE "agents_messages"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "threadId" varchar(255) NOT NULL,
  "resourceId" varchar(255) NOT NULL,
  "role" varchar(36) NOT NULL,
  "type" varchar(36),
  "content" text NOT NULL,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_0a8057a61afabd2999608ffd0d9" FOREIGN KEY ("threadId") REFERENCES "agents_threads" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
threadId varchar(255) Rename | Drop
resourceId varchar(255) Rename | Drop
role varchar(36) Rename | Drop
type varchar(36) ✓ Rename | Drop
content TEXT Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
threadId agents_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_agents_messages_threadId_createdAt
  • threadId
  • createdAt
 SQL 
CREATE INDEX "IDX_agents_messages_threadId_createdAt"
ON "agents_messages" ("threadId", "createdAt")
Drop
IDX_fc7bf858660bfafd19181e8e35
  • threadId
  • createdAt
 SQL 
CREATE INDEX "IDX_fc7bf858660bfafd19181e8e35"
ON "agents_messages" ("threadId", "createdAt")
Drop
sqlite_autoindex_agents_messages_1 id ✓ SQL
-- no sql found --
 Drop