Query

webui.db — memory

SQL

CREATE TABLE "memory"  (
  "id" VARCHAR(255) NOT NULL,
  "user_id" VARCHAR(255) NOT NULL,
  "content" TEXT NOT NULL,
  "updated_at" INTEGER NOT NULL,
  "created_at" INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(255) Rename | Drop
user_id VARCHAR(255) Rename | Drop
content TEXT Rename | Drop
updated_at INTEGER Rename | Drop
created_at INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
memory_id id ✓ SQL 
CREATE UNIQUE INDEX "memory_id"
ON "memory" ("id")
Drop