SQL
CREATE TABLE "trusted_key_source" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"type" varchar(32) NOT NULL,
"config" text NOT NULL,
"status" varchar(32) NOT NULL DEFAULT ('pending'),
"lastError" text,
"lastRefreshedAt" datetime(3),
"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'))
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar(36) |
✓ | Rename | Drop | |
type |
varchar(32) |
Rename | Drop | ||
config |
TEXT |
Rename | Drop | ||
status |
varchar(32) |
Rename | Drop | ||
lastError |
TEXT |
✓ | Rename | Drop | |
lastRefreshedAt |
datetime(3) |
✓ | Rename | Drop | |
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_trusted_key_source_1 |
id
|
✓ | SQL | Drop |