diff options
| author | Rob Austein <sra@hactrn.net> | 2008-04-25 06:45:10 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2008-04-25 06:45:10 +0000 |
| commit | aac95769f39e37f89ca4b304d76dc514822a7271 (patch) | |
| tree | a131f06614dea05d3c7193730e25fb43ff7e5654 /docs/rpki-db-schema.sql | |
| parent | f4d16327a6048cf932b53e40247df0b820e2dccf (diff) | |
New trust anchor model sort of working. make test runs again, anyway.
svn path=/docs/left-right-xml; revision=1704
Diffstat (limited to 'docs/rpki-db-schema.sql')
| -rw-r--r-- | docs/rpki-db-schema.sql | 20 |
1 files changed, 12 insertions, 8 deletions
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), |