Query

MaiBot.db — graph_nodes

SQL

CREATE TABLE "graph_nodes"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "concept" TEXT NOT NULL,
  "memory_items" TEXT NOT NULL,
  "weight" REAL NOT NULL,
  "hash" TEXT NOT NULL,
  "created_time" REAL NOT NULL,
  "last_modified" REAL NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
concept TEXT Rename | Drop
memory_items TEXT Rename | Drop
weight REAL Rename | Drop
hash TEXT Rename | Drop
created_time REAL Rename | Drop
last_modified REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
graphnodes_concept concept ✓ SQL 
CREATE UNIQUE INDEX "graphnodes_concept"
ON "graph_nodes" ("concept")
Drop