Query

database.sqlite — instance_ai_events

SQL

CREATE TABLE "instance_ai_events"  (
  "threadId" varchar NOT NULL,
  "seq" integer NOT NULL,
  "runId" varchar(64) NOT NULL,
  "type" varchar(64) NOT NULL,
  "payload" 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_35909c5576a4a6c1d6a6fb71caa" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE,
  PRIMARY KEY ("threadId", "seq")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
threadId varchar ✓ Rename | Drop
seq INTEGER ✓ Rename | Drop
runId varchar(64) Rename | Drop
type varchar(64) Rename | Drop
payload TEXT 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_32cdd799675715fb1d2a8683e9
  • threadId
  • runId
 SQL 
CREATE INDEX "IDX_32cdd799675715fb1d2a8683e9"
ON "instance_ai_events" ("threadId", "runId")
Drop
sqlite_autoindex_instance_ai_events_1
  • threadId
  • seq
 ✓ SQL
-- no sql found --
 Drop