diff options
| author | Rob Austein <sra@hactrn.net> | 2007-11-13 06:13:03 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-11-13 06:13:03 +0000 |
| commit | e40bf7a235cd7e1a644c8b90d9c268ace845babe (patch) | |
| tree | ef2d20a2f93869e6c24beb4aa292dfdbe4874817 /docs/rpki-db-schema.sql | |
| parent | fef6711b0bae189b8638b415b151a192abd3dcd8 (diff) | |
Checkpoint of changes leading up to support for revocation
svn path=/docs/rpki-db-schema.pdf; revision=1280
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), |