From 58055d39a4a57e937aa761f06faee79e3ceeb0c0 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Wed, 17 Oct 2007 22:27:49 +0000 Subject: More missing SQL fields svn path=/docs/rpki-db-schema.pdf; revision=1169 --- docs/rpki-db-schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'docs/rpki-db-schema.sql') diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index 5ed0fe66..a9e08eb9 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -26,6 +26,7 @@ CREATE TABLE bsc ( private_key_id LONGBLOB, self_id BIGINT unsigned NOT NULL, public_key LONGBLOB, + hash_alg TEXT, PRIMARY KEY (bsc_id), FOREIGN KEY (self_id) REFERENCES self ); @@ -123,8 +124,9 @@ DROP TABLE IF EXISTS child_cert; CREATE TABLE child_cert ( child_cert_id SERIAL NOT NULL, cert LONGBLOB NOT NULL, - child_id BIGINT unsigned NOT NULL, ski TINYBLOB NOT NULL, + revoked BOOLEAN, + child_id BIGINT unsigned NOT NULL, ca_detail_id BIGINT unsigned NOT NULL, PRIMARY KEY (child_cert_id), FOREIGN KEY (ca_detail_id) REFERENCES ca_detail, -- cgit v1.2.3