Query

MaiBot.db — image_descriptions

SQL

CREATE TABLE "image_descriptions"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "type" TEXT NOT NULL,
  "image_description_hash" TEXT NOT NULL,
  "description" TEXT NOT NULL,
  "timestamp" REAL NOT NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
imagedescriptions_image_description_hash image_description_hash SQL 
CREATE INDEX "imagedescriptions_image_description_hash"
ON "image_descriptions" ("image_description_hash")
Drop