Query

webui.db — user_backup

SQL

CREATE TABLE user_backup (
  id TEXT,
  name TEXT,
  email TEXT,
  role TEXT,
  profile_image_url TEXT,
  api_key TEXT,
  created_at INT,
  updated_at INT,
  last_active_at INT,
  settings TEXT,
  info TEXT,
  oauth_sub TEXT,
  username TEXT,
  bio TEXT,
  gender TEXT,
  date_of_birth NUM
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
email TEXT ✓ Rename | Drop
role TEXT ✓ Rename | Drop
profile_image_url TEXT ✓ Rename | Drop
api_key TEXT ✓ Rename | Drop
created_at INT ✓ Rename | Drop
updated_at INT ✓ Rename | Drop
last_active_at INT ✓ Rename | Drop
settings TEXT ✓ Rename | Drop
info TEXT ✓ Rename | Drop
oauth_sub TEXT ✓ Rename | Drop
username TEXT ✓ Rename | Drop
bio TEXT ✓ Rename | Drop
gender TEXT ✓ Rename | Drop
date_of_birth NUM ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?