SQL
CREATE TABLE "trusted_key" (
"sourceId" varchar(36) NOT NULL,
"kid" varchar(255) NOT NULL,
"data" text NOT NULL,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
CONSTRAINT "FK_8c2938d746943dd8f608d23c891" FOREIGN KEY ("sourceId") REFERENCES "trusted_key_source" ("id") ON DELETE CASCADE,
PRIMARY KEY ("sourceId", "kid")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
sourceId |
varchar(36) |
✓ | Rename | Drop | |
kid |
varchar(255) |
✓ | Rename | Drop | |
data |
TEXT |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
sourceId |
trusted_key_source.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_trusted_key_1 |
|
✓ | SQL | Drop |