Query

MaiBot.db — graph_edges

SQL

CREATE TABLE "graph_edges"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "source" TEXT NOT NULL,
  "target" TEXT NOT NULL,
  "strength" INTEGER 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
source TEXT Rename | Drop
target TEXT Rename | Drop
strength INTEGER Rename | Drop
hash TEXT Rename | Drop
created_time REAL Rename | Drop
last_modified REAL Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
graphedges_source source SQL 
CREATE INDEX "graphedges_source"
ON "graph_edges" ("source")
Drop
graphedges_target target SQL 
CREATE INDEX "graphedges_target"
ON "graph_edges" ("target")
Drop