From f29c3f1933d5fce35a7193859c77ba563473f963 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Sat, 15 Mar 2008 20:51:55 +0000 Subject: Ok, try adding optional no_certs arg to PKCS7.sign() svn path=/docs/rpki-db-schema.sql; revision=1557 --- docs/rpki-db-schema.sql | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'docs') diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index 17fa1541..90dbb5fd 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -123,6 +123,17 @@ 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 ( @@ -141,7 +152,6 @@ 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