Query

MaiBot.db — messages

SQL

CREATE TABLE "messages"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "message_id" TEXT NOT NULL,
  "time" REAL NOT NULL,
  "chat_id" TEXT NOT NULL,
  "reply_to" TEXT,
  "interest_value" REAL,
  "key_words" TEXT,
  "key_words_lite" TEXT,
  "is_mentioned" INTEGER,
  "is_at" INTEGER,
  "reply_probability_boost" REAL,
  "chat_info_stream_id" TEXT NOT NULL,
  "chat_info_platform" TEXT NOT NULL,
  "chat_info_user_platform" TEXT NOT NULL,
  "chat_info_user_id" TEXT NOT NULL,
  "chat_info_user_nickname" TEXT NOT NULL,
  "chat_info_user_cardname" TEXT,
  "chat_info_group_platform" TEXT,
  "chat_info_group_id" TEXT,
  "chat_info_group_name" TEXT,
  "chat_info_create_time" REAL NOT NULL,
  "chat_info_last_active_time" REAL NOT NULL,
  "user_platform" TEXT,
  "user_id" TEXT,
  "user_nickname" TEXT,
  "user_cardname" TEXT,
  "processed_plain_text" TEXT,
  "display_message" TEXT,
  "priority_mode" TEXT,
  "priority_info" TEXT,
  "additional_config" TEXT,
  "is_emoji" INTEGER NOT NULL,
  "is_picid" INTEGER NOT NULL,
  "is_command" INTEGER NOT NULL,
  "is_notify" INTEGER NOT NULL,
  "selected_expressions" TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
message_id TEXT Rename | Drop
time REAL Rename | Drop
chat_id TEXT Rename | Drop
reply_to TEXT ✓ Rename | Drop
interest_value REAL ✓ Rename | Drop
key_words TEXT ✓ Rename | Drop
key_words_lite TEXT ✓ Rename | Drop
is_mentioned INTEGER ✓ Rename | Drop
is_at INTEGER ✓ Rename | Drop
reply_probability_boost REAL ✓ Rename | Drop
chat_info_stream_id TEXT Rename | Drop
chat_info_platform TEXT Rename | Drop
chat_info_user_platform TEXT Rename | Drop
chat_info_user_id TEXT Rename | Drop
chat_info_user_nickname TEXT Rename | Drop
chat_info_user_cardname TEXT ✓ Rename | Drop
chat_info_group_platform TEXT ✓ Rename | Drop
chat_info_group_id TEXT ✓ Rename | Drop
chat_info_group_name TEXT ✓ Rename | Drop
chat_info_create_time REAL Rename | Drop
chat_info_last_active_time REAL Rename | Drop
user_platform TEXT ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
user_nickname TEXT ✓ Rename | Drop
user_cardname TEXT ✓ Rename | Drop
processed_plain_text TEXT ✓ Rename | Drop
display_message TEXT ✓ Rename | Drop
priority_mode TEXT ✓ Rename | Drop
priority_info TEXT ✓ Rename | Drop
additional_config TEXT ✓ Rename | Drop
is_emoji INTEGER Rename | Drop
is_picid INTEGER Rename | Drop
is_command INTEGER Rename | Drop
is_notify INTEGER Rename | Drop
selected_expressions TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
messages_chat_id chat_id SQL 
CREATE INDEX "messages_chat_id"
ON "messages" ("chat_id")
Drop
messages_message_id message_id SQL 
CREATE INDEX "messages_message_id"
ON "messages" ("message_id")
Drop