From e40bf7a235cd7e1a644c8b90d9c268ace845babe Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
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

