Query

webui.db — folder

SQL

CREATE TABLE "folder"  (
  id TEXT NOT NULL,
  parent_id TEXT,
  user_id TEXT NOT NULL,
  name TEXT NOT NULL,
  items JSON,
  meta JSON,
  is_expanded BOOLEAN NOT NULL,
  created_at BIGINT NOT NULL,
  updated_at BIGINT NOT NULL,
  data JSON,
  PRIMARY KEY (id, user_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
parent_id TEXT ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
name TEXT Rename | Drop
items JSON ✓ Rename | Drop
meta JSON ✓ Rename | Drop
is_expanded BOOLEAN Rename | Drop
created_at BIGINT Rename | Drop
updated_at BIGINT Rename | Drop
data JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_folder_1
  • id
  • user_id
 ✓ SQL
-- no sql found --
 Drop