Query

MaiBot.db — action_records

SQL

CREATE TABLE "action_records"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "action_id" TEXT NOT NULL,
  "time" REAL NOT NULL,
  "action_name" TEXT NOT NULL,
  "action_data" TEXT NOT NULL,
  "action_done" INTEGER NOT NULL,
  "action_build_into_prompt" INTEGER NOT NULL,
  "action_prompt_display" TEXT NOT NULL,
  "chat_id" TEXT NOT NULL,
  "chat_info_stream_id" TEXT NOT NULL,
  "chat_info_platform" TEXT NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
action_id TEXT Rename | Drop
time REAL Rename | Drop
action_name TEXT Rename | Drop
action_data TEXT Rename | Drop
action_done INTEGER Rename | Drop
action_build_into_prompt INTEGER Rename | Drop
action_prompt_display TEXT Rename | Drop
chat_id TEXT Rename | Drop
chat_info_stream_id TEXT Rename | Drop
chat_info_platform TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
actionrecords_action_id action_id SQL 
CREATE INDEX "actionrecords_action_id"
ON "action_records" ("action_id")
Drop
actionrecords_chat_id chat_id SQL 
CREATE INDEX "actionrecords_chat_id"
ON "action_records" ("chat_id")
Drop