From 2ae55cb29667344e43ef58737680421d06d90e65 Mon Sep 17 00:00:00 2001 From: Rob Austein 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