Query

MaiBot.db — thinking_back

SQL

CREATE TABLE "thinking_back"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "chat_id" TEXT NOT NULL,
  "question" TEXT NOT NULL,
  "context" TEXT,
  "found_answer" INTEGER NOT NULL,
  "answer" TEXT,
  "thinking_steps" TEXT,
  "create_time" REAL NOT NULL,
  "update_time" REAL NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
chat_id TEXT Rename | Drop
question TEXT Rename | Drop
context TEXT ✓ Rename | Drop
found_answer INTEGER Rename | Drop
answer TEXT ✓ Rename | Drop
thinking_steps TEXT ✓ Rename | Drop
create_time REAL Rename | Drop
update_time REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
thinkingback_chat_id chat_id SQL 
CREATE INDEX "thinkingback_chat_id"
ON "thinking_back" ("chat_id")
Drop