aboutsummaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
Diffstat (limited to 'docs')
-rw-r--r--docs/Makefile7
-rw-r--r--docs/rpki-db-schema.pdfbin7493 -> 0 bytes
-rw-r--r--docs/rpki-db-schema.sql198
-rw-r--r--docs/sample-irdb.pdfbin3500 -> 0 bytes
-rw-r--r--docs/sample-irdb.sql54
5 files changed, 2 insertions, 257 deletions
diff --git a/docs/Makefile b/docs/Makefile
index c352212a..a568b5e4 100644
--- a/docs/Makefile
+++ b/docs/Makefile
@@ -1,13 +1,10 @@
# $Id$
-all: rpki-db-schema.pdf sample-irdb.pdf repository-engine-objects.pdf bpki.pdf
+all: repository-engine-objects.pdf bpki.pdf
bpki.pdf: bpki-symmetric.pdf bpki-asymmetric.pdf
-.SUFFIXES: .pdf .sql .dot .tex
-
-.sql.pdf:
- sh ../scripts/graphviz-sql.sh $<
+.SUFFIXES: .pdf .dot .tex
.dot.pdf:
dot -Tps2 $< | ps2pdf - $@
diff --git a/docs/rpki-db-schema.pdf b/docs/rpki-db-schema.pdf
deleted file mode 100644
index e1e2bb95..00000000
--- a/docs/rpki-db-schema.pdf
+++ /dev/null
Binary files differ
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
deleted file mode 100644
index d62e0dd2..00000000
--- a/docs/rpki-db-schema.sql
+++ /dev/null
@@ -1,198 +0,0 @@
--- $Id$
-
--- Copyright (C) 2007-2008 American Registry for Internet Numbers ("ARIN")
---
--- Permission to use, copy, modify, and distribute this software for any
--- purpose with or without fee is hereby granted, provided that the above
--- copyright notice and this permission notice appear in all copies.
---
--- THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH
--- REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
--- AND FITNESS. IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT,
--- INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
--- LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
--- OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
--- PERFORMANCE OF THIS SOFTWARE.
-
-DROP TABLE IF EXISTS self;
-
-CREATE TABLE self (
- self_id SERIAL NOT NULL,
- use_hsm BOOLEAN,
- crl_interval BIGINT unsigned,
- regen_margin BIGINT unsigned,
- bpki_cert LONGBLOB,
- bpki_glue LONGBLOB,
- PRIMARY KEY (self_id)
-);
-
-DROP TABLE IF EXISTS self_pref;
-
-CREATE TABLE self_pref (
- pref_name VARCHAR(100),
- pref_value TEXT,
- self_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (self_id, pref_name),
- FOREIGN KEY (self_id) REFERENCES self
-);
-
-DROP TABLE IF EXISTS bsc;
-
-CREATE TABLE bsc (
- bsc_id SERIAL NOT NULL,
- private_key_id LONGBLOB,
- pkcs10_request LONGBLOB,
- hash_alg ENUM ('sha256'),
- self_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (bsc_id),
- FOREIGN KEY (self_id) REFERENCES self
-);
-
-DROP TABLE IF EXISTS bsc_cert;
-
-CREATE TABLE bsc_cert (
- bsc_cert_id SERIAL NOT NULL,
- cert LONGBLOB,
- bsc_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (bsc_cert_id),
- FOREIGN KEY (bsc_id) REFERENCES bsc
-);
-
-DROP TABLE IF EXISTS repository;
-
-CREATE TABLE repository (
- repository_id SERIAL NOT NULL,
- peer_contact_uri TEXT,
- 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),
- FOREIGN KEY (self_id) REFERENCES self,
- FOREIGN KEY (bsc_id) REFERENCES bsc
-);
-
-DROP TABLE IF EXISTS parent;
-
-CREATE TABLE parent (
- parent_id SERIAL NOT NULL,
- 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,
- recipient_name TEXT,
- self_id BIGINT unsigned NOT NULL,
- bsc_id BIGINT unsigned NOT NULL,
- repository_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (parent_id),
- FOREIGN KEY (repository_id) REFERENCES repository,
- FOREIGN KEY (bsc_id) REFERENCES bsc,
- FOREIGN KEY (self_id) REFERENCES self
-);
-
-DROP TABLE IF EXISTS ca;
-
-CREATE TABLE ca (
- ca_id SERIAL NOT NULL,
- last_crl_sn BIGINT unsigned NOT NULL,
- last_manifest_sn BIGINT unsigned NOT NULL,
- next_manifest_update DATETIME,
- next_crl_update DATETIME,
- last_issued_sn BIGINT unsigned NOT NULL,
- sia_uri TEXT,
- parent_resource_class TEXT,
- parent_id BIGINT unsigned,
- PRIMARY KEY (ca_id),
- FOREIGN KEY (parent_id) REFERENCES parent
-);
-
-DROP TABLE IF EXISTS ca_detail;
-
-CREATE TABLE ca_detail (
- ca_detail_id SERIAL NOT NULL,
- public_key LONGBLOB,
- private_key_id LONGBLOB,
- latest_crl LONGBLOB,
- latest_ca_cert LONGBLOB,
- manifest_private_key_id LONGBLOB,
- manifest_public_key LONGBLOB,
- latest_manifest_cert LONGBLOB,
- latest_manifest LONGBLOB,
- state ENUM ('pending', 'active', 'deprecated', 'revoked') NOT NULL,
- ca_cert_uri TEXT,
- ca_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (ca_detail_id),
- FOREIGN KEY (ca_id) REFERENCES ca
-);
-
-DROP TABLE IF EXISTS child;
-
-CREATE TABLE child (
- child_id SERIAL NOT NULL,
- bpki_cert LONGBLOB,
- bpki_glue LONGBLOB,
- self_id BIGINT unsigned NOT NULL,
- bsc_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (child_id),
- FOREIGN KEY (bsc_id) REFERENCES bsc,
- FOREIGN KEY (self_id) REFERENCES self
-);
-
-DROP TABLE IF EXISTS child_cert;
-
-CREATE TABLE child_cert (
- child_cert_id SERIAL NOT NULL,
- cert LONGBLOB NOT NULL,
- ski TINYBLOB NOT NULL,
- child_id BIGINT unsigned NOT NULL,
- ca_detail_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (child_cert_id),
- FOREIGN KEY (ca_detail_id) REFERENCES ca_detail,
- FOREIGN KEY (child_id) REFERENCES child
-);
-
-DROP TABLE IF EXISTS revoked_cert;
-
-CREATE TABLE revoked_cert (
- revoked_cert_id SERIAL NOT NULL,
- serial BIGINT unsigned NOT NULL,
- revoked DATETIME NOT NULL,
- expires DATETIME NOT NULL,
- ca_detail_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (revoked_cert_id),
- FOREIGN KEY (ca_detail_id) REFERENCES ca_detail
-);
-
-DROP TABLE IF EXISTS route_origin;
-
-CREATE TABLE route_origin (
- route_origin_id SERIAL NOT NULL,
- as_number DECIMAL(24,0),
- exact_match BOOLEAN,
- cert LONGBLOB,
- roa LONGBLOB,
- self_id BIGINT unsigned NOT NULL,
- ca_detail_id BIGINT unsigned,
- PRIMARY KEY (route_origin_id),
- FOREIGN KEY (self_id) REFERENCES self,
- FOREIGN KEY (ca_detail_id) REFERENCES ca_detail
-);
-
-DROP TABLE IF EXISTS route_origin_range;
-
-CREATE TABLE route_origin_range (
- start_ip VARCHAR(40),
- end_ip VARCHAR(40),
- route_origin_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (route_origin_id, start_ip, end_ip),
- FOREIGN KEY (route_origin_id) REFERENCES route_origin
-);
-
--- Local Variables:
--- indent-tabs-mode: nil
--- End:
diff --git a/docs/sample-irdb.pdf b/docs/sample-irdb.pdf
deleted file mode 100644
index 93aded2c..00000000
--- a/docs/sample-irdb.pdf
+++ /dev/null
Binary files differ
diff --git a/docs/sample-irdb.sql b/docs/sample-irdb.sql
deleted file mode 100644
index f5c8c970..00000000
--- a/docs/sample-irdb.sql
+++ /dev/null
@@ -1,54 +0,0 @@
--- $Id$
-
--- Copyright (C) 2007-2008 American Registry for Internet Numbers ("ARIN")
---
--- Permission to use, copy, modify, and distribute this software for any
--- purpose with or without fee is hereby granted, provided that the above
--- copyright notice and this permission notice appear in all copies.
---
--- THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH
--- REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
--- AND FITNESS. IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT,
--- INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
--- LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
--- OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
--- PERFORMANCE OF THIS SOFTWARE.
-
-DROP TABLE IF EXISTS registrant;
-
-CREATE TABLE registrant (
- registrant_id SERIAL NOT NULL,
- IRBE_mapped_id TEXT,
- subject_name TEXT,
- rpki_self_id BIGINT unsigned,
- rpki_child_id BIGINT unsigned,
- valid_until DATETIME NOT NULL,
- PRIMARY KEY (registrant_id)
-);
-
-DROP TABLE IF EXISTS asn;
-
-CREATE TABLE asn (
- asn_id SERIAL NOT NULL,
- start_as BIGINT unsigned NOT NULL,
- end_as BIGINT unsigned NOT NULL,
- registrant_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (asn_id),
- FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
-);
-
-DROP TABLE IF EXISTS net;
-
-CREATE TABLE net (
- net_id SERIAL NOT NULL,
- start_ip VARCHAR(40) NOT NULL,
- end_ip VARCHAR(40) NOT NULL,
- version TINYINT unsigned NOT NULL,
- registrant_id BIGINT unsigned NOT NULL,
- PRIMARY KEY (net_id),
- FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
-);
-
--- Local Variables:
--- indent-tabs-mode: nil
--- End:
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-16 20:04:57 +0000