SQL
CREATE TABLE "installed_nodes" (
"name" char(200) NOT NULL,
"type" char(200) NOT NULL,
"latestVersion" INTEGER DEFAULT 1,
"package" char(214) NOT NULL,
PRIMARY KEY("name"),
FOREIGN KEY("package") REFERENCES "installed_packages"("packageName") ON DELETE CASCADE ON UPDATE CASCADE
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
name |
char(200) |
✓ | Rename | Drop | |
type |
char(200) |
Rename | Drop | ||
latestVersion |
INTEGER |
✓ | Rename | Drop | |
package |
char(214) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
package |
installed_packages.packageName |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_installed_nodes_1 |
name
|
✓ | SQL | Drop |