Query

database.sqlite — instance_ai_messages

SQL

CREATE TABLE "instance_ai_messages"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "threadId" varchar NOT NULL,
  "content" text NOT NULL,
  "role" varchar(16) NOT NULL,
  "type" varchar(32),
  "resourceId" varchar(255),
  "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_1eeb64cb9d66a927988de759e6e" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE
)

+ Add column

Columns

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

Foreign Keys

Column Destination
threadId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_1eeb64cb9d66a927988de759e6 threadId SQL 
CREATE INDEX "IDX_1eeb64cb9d66a927988de759e6"
ON "instance_ai_messages" ("threadId")
Drop
IDX_76e212c6867fbaa06bf0decd6f resourceId SQL 
CREATE INDEX "IDX_76e212c6867fbaa06bf0decd6f"
ON "instance_ai_messages" ("resourceId")
Drop
sqlite_autoindex_instance_ai_messages_1 id ✓ SQL
-- no sql found --
 Drop