Query

MaiBot.db — chat_streams

+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop