Query

database.sqlite — installed_nodes

SQL

CREATE TABLE "installed_nodes"  (
  "name" char(200) NOT NULL,
  "type" char(200) NOT NULL,
  "latestVersion" REAL DEFAULT 1,
  "package" char(214) NOT NULL,
  PRIMARY KEY ("name"),
  FOREIGN KEY ("package") REFERENCES "installed_packages" ("packageName") ON DELETE CASCADE ON UPDATE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
name char(200) ✓ Rename | Drop
type char(200) Rename | Drop
latestVersion REAL ✓ Rename | Drop
package char(214) Rename | Drop

Foreign Keys

Column Destination
package installed_packages.packageName

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_installed_nodes_1 name ✓ SQL
-- no sql found --
 Drop