From aac95769f39e37f89ca4b304d76dc514822a7271 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Fri, 25 Apr 2008 06:45:10 +0000
Subject: New trust anchor model sort of working.  make test runs again,
 anyway.

svn path=/docs/left-right-xml; revision=1704
---
 docs/rpki-db-schema.sql | 20 ++++++++++++--------
 1 file changed, 12 insertions(+), 8 deletions(-)

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

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index e9bd020b..d62e0dd2 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -21,8 +21,8 @@ CREATE TABLE self (
         use_hsm                 BOOLEAN,
         crl_interval            BIGINT unsigned,
         regen_margin            BIGINT unsigned,
-        biz_cert                LONGBLOB,
-        biz_glue                LONGBLOB,
+        bpki_cert               LONGBLOB,
+        bpki_glue               LONGBLOB,
         PRIMARY KEY             (self_id)
 );
 
@@ -63,8 +63,10 @@ DROP TABLE IF EXISTS repository;
 CREATE TABLE repository (
         repository_id           SERIAL NOT NULL,
         peer_contact_uri        TEXT,
-        peer_biz_cert           LONGBLOB,
-        peer_biz_glue           LONGBLOB,
+        bpki_cms_cert           LONGBLOB,
+        bpki_cms_glue           LONGBLOB,
+        bpki_https_cert         LONGBLOB,
+        bpki_https_glue         LONGBLOB,
         bsc_id                  BIGINT unsigned NOT NULL,
         self_id                 BIGINT unsigned NOT NULL,
         PRIMARY KEY             (repository_id),
@@ -76,8 +78,10 @@ DROP TABLE IF EXISTS parent;
 
 CREATE TABLE parent (
         parent_id               SERIAL NOT NULL,
-        peer_biz_cert           LONGBLOB,
-        peer_biz_glue           LONGBLOB,
+        bpki_cms_cert           LONGBLOB,
+        bpki_cms_glue           LONGBLOB,
+        bpki_https_cert         LONGBLOB,
+        bpki_https_glue         LONGBLOB,
         peer_contact_uri        TEXT,
         sia_base                TEXT,
         sender_name             TEXT,
@@ -130,8 +134,8 @@ DROP TABLE IF EXISTS child;
 
 CREATE TABLE child (
         child_id                SERIAL NOT NULL,
-        peer_biz_cert           LONGBLOB,
-        peer_biz_glue           LONGBLOB,
+        bpki_cert               LONGBLOB,
+        bpki_glue               LONGBLOB,
         self_id                 BIGINT unsigned NOT NULL,
         bsc_id                  BIGINT unsigned NOT NULL,
         PRIMARY KEY             (child_id),
-- 
cgit v1.2.3

