Query

MaiBot.db — memory

SQL

CREATE TABLE "memory"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "memory_id" TEXT NOT NULL,
  "chat_id" TEXT,
  "memory_text" TEXT,
  "keywords" TEXT,
  "create_time" REAL,
  "last_view_time" REAL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
memory_id TEXT Rename | Drop
chat_id TEXT ✓ Rename | Drop
memory_text TEXT ✓ Rename | Drop
keywords TEXT ✓ Rename | Drop
create_time REAL ✓ Rename | Drop
last_view_time REAL ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
memory_memory_id memory_id SQL 
CREATE INDEX "memory_memory_id"
ON "memory" ("memory_id")
Drop