SQL
CREATE TABLE "installed_packages" (
"packageName" char(214) NOT NULL,
"installedVersion" char(50) NOT NULL,
"authorName" char(70) NULL,
"authorEmail" char(70) NULL,
"createdAt" datetime(3) NOT NULL DEFAULT 'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')',
"updatedAt" datetime(3) NOT NULL DEFAULT 'STRFTIME(''%Y-%m-%d %H:%M:%f'', ''NOW'')',
PRIMARY KEY("packageName")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
packageName |
char(214) |
✓ | Rename | Drop | |
installedVersion |
char(50) |
Rename | Drop | ||
authorName |
char(70) |
✓ | Rename | Drop | |
authorEmail |
char(70) |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_installed_packages_1 |
packageName
|
✓ | SQL | Drop |