Query

MaiBot.db — chat_streams

SQL

CREATE TABLE "chat_streams"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "stream_id" TEXT NOT NULL,
  "create_time" REAL NOT NULL,
  "group_platform" TEXT,
  "group_id" TEXT,
  "group_name" TEXT,
  "last_active_time" REAL NOT NULL,
  "platform" TEXT NOT NULL,
  "user_platform" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "user_nickname" TEXT NOT NULL,
  "user_cardname" TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
stream_id TEXT Rename | Drop
create_time REAL Rename | Drop
group_platform TEXT ✓ Rename | Drop
group_id TEXT ✓ Rename | Drop
group_name TEXT ✓ Rename | Drop
last_active_time REAL Rename | Drop
platform TEXT Rename | Drop
user_platform TEXT Rename | Drop
user_id TEXT Rename | Drop
user_nickname TEXT Rename | Drop
user_cardname TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
chatstreams_stream_id stream_id ✓ SQL 
CREATE UNIQUE INDEX "chatstreams_stream_id"
ON "chat_streams" ("stream_id")
Drop