diff options
| -rw-r--r-- | docs/rpki-db-schema.pdf | bin | 7481 -> 6923 bytes | |||
| -rw-r--r-- | docs/rpki-db-schema.sql | 81 |
2 files changed, 22 insertions, 59 deletions
diff --git a/docs/rpki-db-schema.pdf b/docs/rpki-db-schema.pdf Binary files differindex 75dc31ac..64ed8c72 100644 --- a/docs/rpki-db-schema.pdf +++ b/docs/rpki-db-schema.pdf diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index e50d709b..a98a05cd 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -50,10 +50,12 @@ CREATE TABLE bsc_key ( CREATE TABLE ca (
ca_id SERIAL NOT NULL,
- crl LONGBLOB,
- last_sn BIGINT unsigned,
+ last_crl_sn BIGINT unsigned,
last_manifest_sn BIGINT unsigned,
- next_manifest_update CHAR(18),
+ next_manifest_update DATETIME,
+ next_crl_update DATETIME,
+ last_issued_sn BIGINT unsigned,
+ sia_uri TEXT,
parent_id BIGINT unsigned,
PRIMARY KEY (ca_id)
);
@@ -62,9 +64,13 @@ CREATE TABLE ca ( CREATE TABLE ca_detail (
ca_detail_id SERIAL NOT NULL,
pub_key LONGBLOB,
- priv_key_id LONGBLOB,
+ priv_key_handle LONGBLOB,
latest_crl LONGBLOB,
latest_ca_cert_over_pubkey LONGBLOB,
+ manifest_ee_priv_key_handle LONGBLOB,
+ manifest_ee_pub_key LONGBLOB,
+ latest_manifest_ee_cert LONGBLOB,
+ latest_manifest LONGBLOB,
ca_id BIGINT unsigned NOT NULL,
PRIMARY KEY (ca_detail_id)
);
@@ -94,34 +100,6 @@ CREATE TABLE child_ca_link ( );
-CREATE TABLE ee_cert (
- ca_detail_id BIGINT unsigned NOT NULL,
- ee_cert_id SERIAL NOT NULL,
- cert LONGBLOB,
- PRIMARY KEY (ee_cert_id)
-);
-
-
-CREATE TABLE manifest (
- manifest_serial_id SERIAL NOT NULL,
- hash_alg TEXT,
- this_update DATETIME,
- next_update DATETIME,
- self_id BIGINT unsigned NOT NULL,
- collection_uri TEXT,
- PRIMARY KEY (manifest_serial_id)
-);
-
-
-CREATE TABLE manifest_content (
- filename TEXT,
- manifest_content_id SERIAL NOT NULL,
- hash TEXT,
- manifest_serial_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (manifest_content_id)
-);
-
-
CREATE TABLE parent (
parent_id SERIAL NOT NULL,
ta LONGBLOB,
@@ -138,17 +116,18 @@ CREATE TABLE repos ( repos_id SERIAL NOT NULL,
uri TEXT,
ta LONGBLOB,
- self_id BIGINT unsigned NOT NULL,
bsc_id BIGINT unsigned NOT NULL,
+ self_id BIGINT unsigned NOT NULL,
PRIMARY KEY (repos_id)
);
CREATE TABLE roa (
route_origin_id BIGINT unsigned NOT NULL,
- ee_cert_id BIGINT unsigned NOT NULL,
+ ee_cert LONGBLOB,
roa LONGBLOB NOT NULL,
- PRIMARY KEY (route_origin_id, ee_cert_id)
+ ca_detail_id BIGINT unsigned NOT NULL,
+ PRIMARY KEY (route_origin_id, ca_detail_id)
);
@@ -163,7 +142,6 @@ CREATE TABLE route_origin ( CREATE TABLE route_origin_prefix (
start_ip VARCHAR(40),
end_ip VARCHAR(40),
- version BIGINT unsigned,
route_origin_id BIGINT unsigned NOT NULL,
PRIMARY KEY (route_origin_id, start_ip, end_ip)
);
@@ -234,21 +212,6 @@ ALTER TABLE child_ca_link REFERENCES ca;
-ALTER TABLE ee_cert
- ADD FOREIGN KEY (ca_detail_id)
- REFERENCES ca_detail;
-
-
-ALTER TABLE manifest
- ADD FOREIGN KEY (self_id)
- REFERENCES self;
-
-
-ALTER TABLE manifest_content
- ADD FOREIGN KEY (manifest_serial_id)
- REFERENCES manifest;
-
-
ALTER TABLE parent
ADD FOREIGN KEY (repos_id)
REFERENCES repos;
@@ -265,23 +228,23 @@ ALTER TABLE parent ALTER TABLE repos
- ADD FOREIGN KEY (bsc_id)
- REFERENCES bsc;
+ ADD FOREIGN KEY (self_id)
+ REFERENCES self;
ALTER TABLE repos
- ADD FOREIGN KEY (self_id)
- REFERENCES self;
+ ADD FOREIGN KEY (bsc_id)
+ REFERENCES bsc;
ALTER TABLE roa
- ADD FOREIGN KEY (route_origin_id)
- REFERENCES route_origin;
+ ADD FOREIGN KEY (ca_detail_id)
+ REFERENCES ca_detail;
ALTER TABLE roa
- ADD FOREIGN KEY (ee_cert_id)
- REFERENCES ee_cert;
+ ADD FOREIGN KEY (route_origin_id)
+ REFERENCES route_origin;
ALTER TABLE route_origin
|