Query

webui.db — prompt

SQL

CREATE TABLE "prompt"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "command" VARCHAR(255) NOT NULL,
  "user_id" VARCHAR(255) NOT NULL,
  "title" TEXT NOT NULL NOT NULL,
  "content" TEXT NOT NULL,
  "timestamp" INTEGER NOT NULL NOT NULL,
  access_control JSON
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
command VARCHAR(255) Rename | Drop
user_id VARCHAR(255) Rename | Drop
title TEXT Rename | Drop
content TEXT Rename | Drop
timestamp INTEGER Rename | Drop
access_control JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
prompt_command command ✓ SQL 
CREATE UNIQUE INDEX "prompt_command"
ON "prompt" ("command")
Drop