Query

MaiBot.db — emoji_description_cache

SQL

CREATE TABLE "emoji_description_cache"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "emoji_hash" TEXT NOT NULL,
  "description" TEXT NOT NULL,
  "emotion_tags" TEXT,
  "timestamp" REAL NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
emoji_hash TEXT Rename | Drop
description TEXT Rename | Drop
emotion_tags TEXT ✓ Rename | Drop
timestamp REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
emojidescriptioncache_emoji_hash emoji_hash ✓ SQL 
CREATE UNIQUE INDEX "emojidescriptioncache_emoji_hash"
ON "emoji_description_cache" ("emoji_hash")
Drop