Query

webui.db — tool

SQL

CREATE TABLE "tool"  (
  "id" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "name" TEXT NOT NULL,
  "content" TEXT NOT NULL,
  "specs" TEXT NOT NULL,
  "meta" TEXT NOT NULL,
  "created_at" INTEGER NOT NULL,
  "updated_at" INTEGER NOT NULL,
  "valves" TEXT,
  access_control JSON
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
user_id TEXT Rename | Drop
name TEXT Rename | Drop
content TEXT Rename | Drop
specs TEXT Rename | Drop
meta TEXT Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop
valves TEXT ✓ Rename | Drop
access_control JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
tool_id id ✓ SQL 
CREATE UNIQUE INDEX "tool_id"
ON "tool" ("id")
Drop