From 38621998c155e5e220cdb2ab760de5fdf7b04703 Mon Sep 17 00:00:00 2001 From: Rob Austein 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