Query

MaiBot.db — chat_history

SQL

CREATE TABLE "chat_history"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "chat_id" TEXT NOT NULL,
  "start_time" REAL NOT NULL,
  "end_time" REAL NOT NULL,
  "original_text" TEXT NOT NULL,
  "participants" TEXT NOT NULL,
  "theme" TEXT NOT NULL,
  "keywords" TEXT NOT NULL,
  "summary" TEXT NOT NULL,
  "key_point" TEXT,
  "count" INTEGER NOT NULL,
  "forget_times" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
chat_id TEXT Rename | Drop
start_time REAL Rename | Drop
end_time REAL Rename | Drop
original_text TEXT Rename | Drop
participants TEXT Rename | Drop
theme TEXT Rename | Drop
keywords TEXT Rename | Drop
summary TEXT Rename | Drop
key_point TEXT ✓ Rename | Drop
count INTEGER Rename | Drop
forget_times INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
chathistory_chat_id chat_id SQL 
CREATE INDEX "chathistory_chat_id"
ON "chat_history" ("chat_id")
Drop