Query

database.sqlite — instance_ai_pending_c...

SQL

CREATE TABLE "instance_ai_pending_confirmations"  (
  "requestId" varchar(36) PRIMARY KEY NOT NULL,
  "threadId" varchar NOT NULL,
  "userId" varchar NOT NULL,
  "kind" varchar(16) NOT NULL,
  "runId" varchar(36) NOT NULL,
  "toolCallId" varchar(64),
  "messageGroupId" varchar(36),
  "checkpointKey" varchar(255),
  "checkpointTaskId" varchar(36),
  "expiresAt" datetime(3),
  "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 "CHK_instance_ai_pending_confirmations_kind" CHECK ("kind" IN ('suspended', 'inline')),
  CONSTRAINT "FK_ba67ee8dc311830a2eea89b6e96" FOREIGN KEY ("threadId") REFERENCES "instance_ai_threads" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_df5fd25c8bbfd2b042602600d8e" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_0babdf6e3b897a86fe4678355eb" FOREIGN KEY ("checkpointKey") REFERENCES "instance_ai_checkpoints" ("key") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
requestId varchar(36) ✓ Rename | Drop
threadId varchar Rename | Drop
userId varchar Rename | Drop
kind varchar(16) Rename | Drop
runId varchar(36) Rename | Drop
toolCallId varchar(64) ✓ Rename | Drop
messageGroupId varchar(36) ✓ Rename | Drop
checkpointKey varchar(255) ✓ Rename | Drop
checkpointTaskId varchar(36) ✓ Rename | Drop
expiresAt datetime(3) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
checkpointKey instance_ai_checkpoints.key
userId user.id
threadId instance_ai_threads.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_0babdf6e3b897a86fe4678355e checkpointKey SQL 
CREATE INDEX "IDX_0babdf6e3b897a86fe4678355e"
ON "instance_ai_pending_confirmations" ("checkpointKey")
Drop
IDX_ba67ee8dc311830a2eea89b6e9 threadId SQL 
CREATE INDEX "IDX_ba67ee8dc311830a2eea89b6e9"
ON "instance_ai_pending_confirmations" ("threadId")
Drop
IDX_d7a4aba7440449865e2b924377 expiresAt SQL 
CREATE INDEX "IDX_d7a4aba7440449865e2b924377"
ON "instance_ai_pending_confirmations" ("expiresAt")
Drop
IDX_df5fd25c8bbfd2b042602600d8 userId SQL 
CREATE INDEX "IDX_df5fd25c8bbfd2b042602600d8"
ON "instance_ai_pending_confirmations" ("userId")
Drop
sqlite_autoindex_instance_ai_pending_confirmations_1 requestId ✓ SQL
-- no sql found --
 Drop