Query

webui.db — document

SQL

CREATE TABLE "document"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "collection_name" VARCHAR(255) NOT NULL,
  "name" VARCHAR(255) NOT NULL,
  "title" TEXT NOT NULL NOT NULL,
  "filename" TEXT NOT NULL NOT NULL,
  "content" TEXT,
  "user_id" VARCHAR(255) NOT NULL,
  "timestamp" INTEGER NOT NULL NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
collection_name VARCHAR(255) Rename | Drop
name VARCHAR(255) Rename | Drop
title TEXT Rename | Drop
filename TEXT Rename | Drop
content TEXT ✓ Rename | Drop
user_id VARCHAR(255) Rename | Drop
timestamp INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
document_collection_name collection_name ✓ SQL 
CREATE UNIQUE INDEX "document_collection_name"
ON "document" ("collection_name")
Drop
document_name name ✓ SQL 
CREATE UNIQUE INDEX "document_name"
ON "document" ("name")
Drop