Query

webui.db — chat

SQL

CREATE TABLE "chat"  (
  "id" VARCHAR(255) NOT NULL,
  "user_id" VARCHAR(255) NOT NULL,
  "title" TEXT NOT NULL NOT NULL,
  "share_id" VARCHAR(255),
  "archived" INTEGER NOT NULL,
  "created_at" DATETIME NOT NULL NOT NULL,
  "updated_at" DATETIME NOT NULL NOT NULL,
  chat JSON,
  pinned BOOLEAN,
  meta JSON DEFAULT '{}' NOT NULL,
  folder_id TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) Rename | Drop
user_id VARCHAR(255) Rename | Drop
title TEXT Rename | Drop
share_id VARCHAR(255) ✓ Rename | Drop
archived INTEGER Rename | Drop
created_at DATETIME Rename | Drop
updated_at DATETIME Rename | Drop
chat JSON ✓ Rename | Drop
pinned BOOLEAN ✓ Rename | Drop
meta JSON Rename | Drop
folder_id TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
chat_id id ✓ SQL 
CREATE UNIQUE INDEX "chat_id"
ON "chat" ("id")
Drop
chat_share_id share_id ✓ SQL 
CREATE UNIQUE INDEX "chat_share_id"
ON "chat" ("share_id")
Drop
folder_id_idx folder_id SQL 
CREATE INDEX folder_id_idx
ON chat (folder_id)
Drop
folder_id_user_id_idx
  • folder_id
  • user_id
 SQL 
CREATE INDEX folder_id_user_id_idx
ON chat (folder_id, user_id)
Drop
updated_at_user_id_idx
  • updated_at
  • user_id
 SQL 
CREATE INDEX updated_at_user_id_idx
ON chat (updated_at, user_id)
Drop
user_id_archived_idx
  • user_id
  • archived
 SQL 
CREATE INDEX user_id_archived_idx
ON chat (user_id, archived)
Drop
user_id_pinned_idx
  • user_id
  • pinned
 SQL 
CREATE INDEX user_id_pinned_idx
ON chat (user_id, pinned)
Drop