Query

MaiBot.db — images

SQL

CREATE TABLE "images"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "image_id" TEXT NOT NULL,
  "emoji_hash" TEXT NOT NULL,
  "description" TEXT,
  "path" TEXT NOT NULL,
  "count" INTEGER NOT NULL,
  "timestamp" REAL NOT NULL,
  "type" TEXT NOT NULL,
  "vlm_processed" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
image_id TEXT Rename | Drop
emoji_hash TEXT Rename | Drop
description TEXT ✓ Rename | Drop
path TEXT Rename | Drop
count INTEGER Rename | Drop
timestamp REAL Rename | Drop
type TEXT Rename | Drop
vlm_processed INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
images_emoji_hash emoji_hash SQL 
CREATE INDEX "images_emoji_hash"
ON "images" ("emoji_hash")
Drop
images_path path ✓ SQL 
CREATE UNIQUE INDEX "images_path"
ON "images" ("path")
Drop