Query

webui.db — function

SQL

CREATE TABLE "function"  (
  "id" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "name" TEXT NOT NULL,
  "type" TEXT NOT NULL,
  "content" TEXT NOT NULL,
  "meta" TEXT NOT NULL,
  "created_at" INTEGER NOT NULL,
  "updated_at" INTEGER NOT NULL,
  "valves" TEXT,
  "is_active" INTEGER NOT NULL,
  "is_global" INTEGER NOT NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
function_id id ✓ SQL 
CREATE UNIQUE INDEX "function_id"
ON "function" ("id")
Drop
is_global_idx is_global SQL 
CREATE INDEX is_global_idx
ON function (is_global)
Drop