From 38621998c155e5e220cdb2ab760de5fdf7b04703 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Wed, 19 Mar 2008 00:07:42 +0000
Subject: Roll back premature commit of revocation changes

svn path=/docs/rpki-db-schema.sql; revision=1560
---
 docs/rpki-db-schema.sql | 12 +-----------
 1 file changed, 1 insertion(+), 11 deletions(-)

(limited to 'docs/rpki-db-schema.sql')

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index 90dbb5fd..17fa1541 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -123,17 +123,6 @@ CREATE TABLE ca_detail (
        FOREIGN KEY              (ca_id) REFERENCES ca
 );
 
-DROP TABLE IF EXISTS revoked;
-
-CREATE TABLE revoked (
-       revoked_id           SERIAL NOT NULL,
-       serial               BIGINT unsigned NOT NULL,
-       expires              DATETIME NOT NULL,
-       ca_detail_id         BIGINT unsigned NOT NULL,
-       PRIMARY KEY          (revoked_id),
-       FOREIGN KEY          (ca_detail_id) REFERENCES ca_detail
-);
-
 DROP TABLE IF EXISTS child;
 
 CREATE TABLE child (
@@ -152,6 +141,7 @@ CREATE TABLE child_cert (
        child_cert_id        SERIAL NOT NULL,
        cert                 LONGBLOB NOT NULL,
        ski                  TINYBLOB NOT NULL,
+       revoked              DATETIME,
        child_id             BIGINT unsigned NOT NULL,
        ca_detail_id         BIGINT unsigned NOT NULL,
        PRIMARY KEY          (child_cert_id),
-- 
cgit v1.2.3

