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

