Query

webui.db — tag

SQL

CREATE TABLE "tag"  (
  id VARCHAR(255) NOT NULL,
  name VARCHAR(255) NOT NULL,
  user_id VARCHAR(255) NOT NULL,
  meta JSON,
  CONSTRAINT pk_id_user_id PRIMARY KEY (id, user_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
user_id VARCHAR(255) ✓ Rename | Drop
meta JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_tag_1
  • id
  • user_id
 ✓ SQL
-- no sql found --
 Drop
user_id_idx user_id SQL 
CREATE INDEX user_id_idx
ON tag (user_id)
Drop