Query

MaiBot.db — emoji

SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
full_path TEXT Rename | Drop
format TEXT Rename | Drop
emoji_hash TEXT Rename | Drop
description TEXT Rename | Drop
query_count INTEGER Rename | Drop
is_registered INTEGER Rename | Drop
is_banned INTEGER Rename | Drop
emotion TEXT ✓ Rename | Drop
record_time REAL Rename | Drop
register_time REAL ✓ Rename | Drop
usage_count INTEGER Rename | Drop
last_used_time REAL ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
emoji_emoji_hash emoji_hash SQL 
CREATE INDEX "emoji_emoji_hash"
ON "emoji" ("emoji_hash")
Drop
emoji_full_path full_path ✓ SQL 
CREATE UNIQUE INDEX "emoji_full_path"
ON "emoji" ("full_path")
Drop