Query

webui.db — chatidtag

SQL

CREATE TABLE "chatidtag"  (
  "id" VARCHAR(255) NOT NULL,
  "tag_name" VARCHAR(255) NOT NULL,
  "chat_id" VARCHAR(255) NOT NULL,
  "user_id" VARCHAR(255) NOT NULL,
  "timestamp" INTEGER NOT NULL NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) Rename | Drop
tag_name VARCHAR(255) Rename | Drop
chat_id VARCHAR(255) Rename | Drop
user_id VARCHAR(255) Rename | Drop
timestamp INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
chatidtag_id id ✓ SQL 
CREATE UNIQUE INDEX "chatidtag_id"
ON "chatidtag" ("id")
Drop