Query

MaiBot.db — emoji

+/- table definition

Query 

CREATE TABLE "emoji"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "full_path" TEXT NOT NULL,
  "format" TEXT NOT NULL,
  "emoji_hash" TEXT NOT NULL,
  "description" TEXT NOT NULL,
  "query_count" INTEGER NOT NULL,
  "is_registered" INTEGER NOT NULL,
  "is_banned" INTEGER NOT NULL,
  "emotion" TEXT,
  "record_time" REAL NOT NULL,
  "register_time" REAL,
  "usage_count" INTEGER NOT NULL,
  "last_used_time" REAL
)
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