Query

webui.db — user

SQL

CREATE TABLE "user"  (
  "id" VARCHAR(255) PRIMARY KEY,
  "name" VARCHAR(255) NOT NULL,
  "email" VARCHAR(255) NOT NULL,
  "role" VARCHAR(255) NOT NULL,
  "profile_image_url" TEXT NOT NULL,
  "api_key" VARCHAR(255),
  "created_at" INTEGER NOT NULL,
  "updated_at" INTEGER NOT NULL,
  "last_active_at" INTEGER NOT NULL,
  "settings" TEXT,
  "info" TEXT,
  "oauth_sub" TEXT,
  "username" VARCHAR(50),
  "bio" TEXT,
  "gender" TEXT,
  "date_of_birth" DATE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) ✓ ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
email VARCHAR(255) Rename | Drop
role VARCHAR(255) Rename | Drop
profile_image_url TEXT Rename | Drop
api_key VARCHAR(255) ✓ Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop
last_active_at INTEGER Rename | Drop
settings TEXT ✓ Rename | Drop
info TEXT ✓ Rename | Drop
oauth_sub TEXT ✓ Rename | Drop
username VARCHAR(50) ✓ Rename | Drop
bio TEXT ✓ Rename | Drop
gender TEXT ✓ Rename | Drop
date_of_birth DATE ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 id ✓ SQL
-- no sql found --
 Drop