From d58e9d7954404c3bd2ff48e55c81ae15d5d4fa03 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Fri, 14 Sep 2007 15:56:08 +0000
Subject: Latest from Tim
svn path=/docs/rpki-db-schema.pdf; revision=955
---
docs/rpki-db-schema.sql | 25 +++++--------------------
1 file changed, 5 insertions(+), 20 deletions(-)
(limited to 'docs/rpki-db-schema.sql')
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index a98a05cd..5e4f9e49 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -22,29 +22,18 @@ drop table if exists route_origin_prefix;
CREATE TABLE bsc (
bsc_id SERIAL NOT NULL,
+ priv_key_id LONGBLOB,
self_id BIGINT unsigned NOT NULL,
+ pub_key LONGBLOB,
PRIMARY KEY (bsc_id)
);
CREATE TABLE bsc_cert (
bsc_cert_id SERIAL NOT NULL,
- request LONGBLOB,
cert LONGBLOB,
- bsc_key_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (bsc_cert_id)
-);
-
-
-CREATE TABLE bsc_key (
- bsc_key_id SERIAL NOT NULL,
- key_type VARCHAR(100),
- hash_alg TEXT,
- key_length INT unsigned,
- pub_key LONGBLOB,
- priv_key_id LONGBLOB,
bsc_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (bsc_key_id)
+ PRIMARY KEY (bsc_cert_id)
);
@@ -157,7 +146,7 @@ CREATE TABLE self (
CREATE TABLE self_pref (
pref_name VARCHAR(100),
pref_value TEXT,
- self_id SERIAL NOT NULL,
+ self_id BIGINT unsigned NOT NULL,
PRIMARY KEY (self_id, pref_name)
);
@@ -168,11 +157,6 @@ ALTER TABLE bsc
ALTER TABLE bsc_cert
- ADD FOREIGN KEY (bsc_key_id)
- REFERENCES bsc_key;
-
-
-ALTER TABLE bsc_key
ADD FOREIGN KEY (bsc_id)
REFERENCES bsc;
@@ -263,3 +247,4 @@ ALTER TABLE self_pref
+
--
cgit v1.2.3