From 2ae55cb29667344e43ef58737680421d06d90e65 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Thu, 4 Oct 2007 03:06:25 +0000
Subject: Rename *.peer_ta => *.cms_ta, add parent.https_ta and
 repository.https_ta.

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

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

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index 21812d25..0c9eb531 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -44,7 +44,8 @@ DROP TABLE IF EXISTS repository;
 CREATE TABLE repository (
        repository_id        SERIAL NOT NULL,
        peer_contact_uri     TEXT,
-       peer_ta              LONGBLOB,
+       cms_ta               LONGBLOB,
+       https_ta		    LONGBLOB,
        bsc_id               BIGINT unsigned NOT NULL,
        self_id              BIGINT unsigned NOT NULL,
        PRIMARY KEY          (repository_id),
@@ -56,7 +57,8 @@ DROP TABLE IF EXISTS parent;
 
 CREATE TABLE parent (
        parent_id            SERIAL NOT NULL,
-       peer_ta              LONGBLOB,
+       cms_ta               LONGBLOB,
+       https_ta             LONGBLOB,
        peer_contact_uri     TEXT,
        sia_base             TEXT,
        self_id              BIGINT unsigned NOT NULL,
@@ -107,7 +109,7 @@ DROP TABLE IF EXISTS child;
 
 CREATE TABLE child (
        child_id             SERIAL NOT NULL,
-       peer_ta              LONGBLOB,
+       cms_ta               LONGBLOB,
        self_id              BIGINT unsigned NOT NULL,
        bsc_id               BIGINT unsigned NOT NULL,
        PRIMARY KEY          (child_id),
-- 
cgit v1.2.3

