Query

webui.db — config

SQL

CREATE TABLE config  (
  id INTEGER NOT NULL,
  data JSON NOT NULL,
  version INTEGER NOT NULL,
  created_at DATETIME DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
  updated_at DATETIME DEFAULT (CURRENT_TIMESTAMP),
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
data JSON Rename | Drop
version INTEGER Rename | Drop
created_at DATETIME Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?