Query

webui.db — model

SQL

CREATE TABLE "model"  (
  "id" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "base_model_id" TEXT,
  "name" TEXT NOT NULL,
  "meta" TEXT NOT NULL,
  "params" TEXT NOT NULL,
  "created_at" INTEGER NOT NULL,
  "updated_at" INTEGER NOT NULL,
  access_control JSON,
  is_active BOOLEAN DEFAULT (1) NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
user_id TEXT Rename | Drop
base_model_id TEXT ✓ Rename | Drop
name TEXT Rename | Drop
meta TEXT Rename | Drop
params TEXT Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop
access_control JSON ✓ Rename | Drop
is_active BOOLEAN Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
model_id id ✓ SQL 
CREATE UNIQUE INDEX "model_id"
ON "model" ("id")
Drop