From e40bf7a235cd7e1a644c8b90d9c268ace845babe Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Tue, 13 Nov 2007 06:13:03 +0000 Subject: Checkpoint of changes leading up to support for revocation svn path=/docs/rpki-db-schema.pdf; revision=1280 --- docs/rpki-db-schema.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'docs/rpki-db-schema.sql') 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), -- cgit v1.2.3