Query

webui.db — group

SQL

CREATE TABLE "group"  (
  id TEXT NOT NULL,
  user_id TEXT,
  name TEXT,
  description TEXT,
  data JSON,
  meta JSON,
  permissions JSON,
  user_ids JSON,
  created_at BIGINT,
  updated_at BIGINT,
  PRIMARY KEY (id),
  UNIQUE (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
data JSON ✓ Rename | Drop
meta JSON ✓ Rename | Drop
permissions JSON ✓ Rename | Drop
user_ids JSON ✓ Rename | Drop
created_at BIGINT ✓ Rename | Drop
updated_at BIGINT ✓ Rename | Drop

+ Add index

Indexes

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