Add Column

Cancel

Current Schema

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
)