-- Runtime panic button/cutoff settings and durable Flowise session IDs.
CREATE TABLE "RuntimeSetting" (
    "key" TEXT NOT NULL PRIMARY KEY,
    "value" TEXT NOT NULL,
    "updatedBy" TEXT,
    "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" DATETIME NOT NULL
);

CREATE TABLE "ConversationState" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "conversationId" INTEGER NOT NULL,
    "flowiseSessionId" TEXT NOT NULL,
    "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" DATETIME NOT NULL
);

CREATE UNIQUE INDEX "ConversationState_conversationId_key" ON "ConversationState"("conversationId");
CREATE INDEX "ConversationState_flowiseSessionId_idx" ON "ConversationState"("flowiseSessionId");

INSERT INTO "RuntimeSetting" ("key", "value", "updatedBy", "updatedAt") VALUES
  ('bot_enabled', 'true', 'migration', CURRENT_TIMESTAMP),
  ('max_message_age_minutes', '240', 'migration', CURRENT_TIMESTAMP);