Query

webui.db — file

SQL

CREATE TABLE "file"  (
  id TEXT NOT NULL,
  user_id TEXT NOT NULL,
  filename TEXT NOT NULL,
  meta JSON,
  created_at INTEGER NOT NULL,
  hash TEXT,
  data JSON,
  updated_at BIGINT,
  path TEXT,
  access_control JSON
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT Rename | Drop
user_id TEXT Rename | Drop
filename TEXT Rename | Drop
meta JSON ✓ Rename | Drop
created_at INTEGER Rename | Drop
hash TEXT ✓ Rename | Drop
data JSON ✓ Rename | Drop
updated_at BIGINT ✓ Rename | Drop
path TEXT ✓ Rename | Drop
access_control JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
file_id id ✓ SQL 
CREATE UNIQUE INDEX file_id
ON file (id)
Drop