Query

webui.db — auth

SQL

CREATE TABLE "auth"  (
  "id" VARCHAR(255) NOT NULL,
  "email" VARCHAR(255) NOT NULL,
  "password" TEXT NOT NULL NOT NULL,
  "active" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) Rename | Drop
email VARCHAR(255) Rename | Drop
password TEXT Rename | Drop
active INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
auth_id id ✓ SQL 
CREATE UNIQUE INDEX "auth_id"
ON "auth" ("id")
Drop