diff options
Diffstat (limited to 'docs/rpki-db-schema.sql')
| -rw-r--r-- | docs/rpki-db-schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index 8cdf5ff8..bdad6f96 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -100,7 +100,8 @@ CREATE TABLE ca_detail ( manifest_public_key LONGBLOB, latest_manifest_cert LONGBLOB, latest_manifest LONGBLOB, - state ENUM ('active', 'deprecated', 'pending') NOT NULL, + state ENUM ('active', 'deprecated', 'pending', 'revoked') NOT NULL, + state_timer DATETIME, ca_cert_uri TEXT, ca_id BIGINT unsigned NOT NULL, PRIMARY KEY (ca_detail_id), @@ -125,7 +126,7 @@ CREATE TABLE child_cert ( child_cert_id SERIAL NOT NULL, cert LONGBLOB NOT NULL, ski TINYBLOB NOT NULL, - revoked DATETIME, + revoked BOOLEAN, child_id BIGINT unsigned NOT NULL, ca_detail_id BIGINT unsigned NOT NULL, PRIMARY KEY (child_cert_id), |