Query

database.sqlite — instance_ai_checkpoints

SQL

CREATE TABLE "instance_ai_checkpoints"  (
  "key" varchar(255) PRIMARY KEY NOT NULL,
  "runId" varchar(255),
  "threadId" varchar NOT NULL,
  "resourceId" varchar(255),
  "state" text,
  "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')),
  "expiredAt" datetime(3),
  "hostRunId" VARCHAR(64),
  CONSTRAINT "instance_ai_checkpoints_state_tombstone_check" CHECK (("expiredAt" IS NOT NULL AND "state" IS NULL) OR "expiredAt" IS NULL),
  CONSTRAINT "FK_2b23f3f24a70bebb990203b011e" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE ON UPDATE NO ACTION
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
key varchar(255) ✓ Rename | Drop
runId varchar(255) ✓ Rename | Drop
threadId varchar Rename | Drop
resourceId varchar(255) ✓ Rename | Drop
state TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
expiredAt datetime(3) ✓ Rename | Drop
hostRunId VARCHAR(64) ✓ Rename | Drop

Foreign Keys

Column Destination
threadId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_2b23f3f24a70bebb990203b011 threadId SQL 
CREATE INDEX "IDX_2b23f3f24a70bebb990203b011"
ON "instance_ai_checkpoints" ("threadId")
Drop
IDX_768189b506cc26c4fe878b87cb runId SQL 
CREATE INDEX "IDX_768189b506cc26c4fe878b87cb"
ON "instance_ai_checkpoints" ("runId")
Drop
IDX_be9d0eca0b19fb93d4eb74b327 resourceId SQL 
CREATE INDEX "IDX_be9d0eca0b19fb93d4eb74b327"
ON "instance_ai_checkpoints" ("resourceId")
Drop
sqlite_autoindex_instance_ai_checkpoints_1 key ✓ SQL
-- no sql found --
 Drop