aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--rpkid/doc/irdbd.dot1
-rw-r--r--rpkid/doc/irdbd.eps44
-rw-r--r--rpkid/doc/irdbd.pngbin5391 -> 6668 bytes
-rw-r--r--rpkid/doc/rpkid.dot3
-rw-r--r--rpkid/doc/rpkid.eps1115
-rw-r--r--rpkid/doc/rpkid.pngbin25260 -> 27767 bytes
6 files changed, 660 insertions, 503 deletions
diff --git a/rpkid/doc/irdbd.dot b/rpkid/doc/irdbd.dot
index 8541092d..42bafefc 100644
--- a/rpkid/doc/irdbd.dot
+++ b/rpkid/doc/irdbd.dot
@@ -9,6 +9,7 @@ digraph test {
node3 [label="{registrant_net\n|registrant_net_id\ SERIAL\ [PK]\lstart_ip\ VARCHAR\lend_ip\ VARCHAR\lversion\ TINYINT\lregistrant_id\ BIGINT\ [FK]\l}"];
node4 [label="{roa_request\n|roa_request_id\ SERIAL\ [PK]\lroa_request_handle\ VARCHAR\lasn\ BIGINT\l}"];
node5 [label="{roa_request_prefix\n|prefix\ VARCHAR\ [PK]\lprefixlen\ TINYINT\ [PK]\lmax_prefixlen\ TINYINT\ [PK]\lversion\ TINYINT\lroa_request_id\ BIGINT\ [PK,FK]\l}"];
+ node6 [label="{ghostbuster_request\n|ghostbuster_request_id\ SERIAL\ [PK]\lself_handle\ VARCHAR\lparent_handle\ VARCHAR\ [N]\lvcard\ LONGBLOB\l}"];
node1 -> node2 [arrowtail=none, arrowhead=crow];
node1 -> node3 [arrowtail=none, arrowhead=crow];
node4 -> node5 [arrowtail=none, arrowhead=crow];
diff --git a/rpkid/doc/irdbd.eps b/rpkid/doc/irdbd.eps
index 60f7fd43..28e869a5 100644
--- a/rpkid/doc/irdbd.eps
+++ b/rpkid/doc/irdbd.eps
@@ -2,7 +2,7 @@
%%Creator: graphviz version 2.26.3 (20100126.1600)
%%Title: test
%%Pages: 1
-%%BoundingBox: 36 36 672 316
+%%BoundingBox: 36 36 916 316
%%EndComments
save
%%BeginProlog
@@ -178,11 +178,11 @@ def
%%EndSetup
setupLatin1
%%Page: 1 1
-%%PageBoundingBox: 36 36 672 316
+%%PageBoundingBox: 36 36 916 316
%%PageOrientation: Portrait
0 0 1 beginpage
gsave
-36 36 636 280 boxprim clip newpath
+36 36 880 280 boxprim clip newpath
1 1 set_scale 0 rotate 40 41 translate
% node1
gsave
@@ -476,6 +476,44 @@ newpath 527 127.47 moveto
527 127.47 lineto
closepath stroke
grestore
+% node6
+gsave
+0 0 1 nodecolor
+newpath 643.47 163 moveto
+643.47 263 lineto
+872.53 263 lineto
+872.53 163 lineto
+closepath fill
+1 setlinewidth
+filled
+0 0 0 nodecolor
+newpath 643.47 163 moveto
+643.47 263 lineto
+872.53 263 lineto
+872.53 163 lineto
+closepath stroke
+0 0 0 nodecolor
+14 /Times-Roman set_font
+702.01 246.4 moveto 111.97 (ghostbuster_request) alignedtext
+1 setlinewidth
+filled
+0 0 0 nodecolor
+newpath 643.47 238.2 moveto
+872.53 238.2 lineto
+stroke
+0 0 0 nodecolor
+14 /Times-Roman set_font
+651.47 221.6 moveto 213.06 (ghostbuster_request_id SERIAL [PK]) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+651.47 204.8 moveto 136.47 (self_handle VARCHAR) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+651.47 188 moveto 174.16 (parent_handle VARCHAR [N]) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+651.47 171.2 moveto 110.79 (vcard LONGBLOB) alignedtext
+grestore
endpage
showpage
grestore
diff --git a/rpkid/doc/irdbd.png b/rpkid/doc/irdbd.png
index ea28dab0..fadc04f0 100644
--- a/rpkid/doc/irdbd.png
+++ b/rpkid/doc/irdbd.png
Binary files differ
diff --git a/rpkid/doc/rpkid.dot b/rpkid/doc/rpkid.dot
index 037905eb..7d8d33da 100644
--- a/rpkid/doc/rpkid.dot
+++ b/rpkid/doc/rpkid.dot
@@ -15,11 +15,13 @@ digraph test {
node9 [label="{revoked_cert\n|revoked_cert_id\ SERIAL\ [PK]\lserial\ BIGINT\lrevoked\ DATETIME\lexpires\ DATETIME\lca_detail_id\ BIGINT\ [FK]\l}"];
node10 [label="{roa\n|roa_id\ SERIAL\ [PK]\lasn\ BIGINT\lcert\ LONGBLOB\lroa\ LONGBLOB\lpublished\ DATETIME\ [N]\lself_id\ BIGINT\ [FK]\lca_detail_id\ BIGINT\ [FK]\l}"];
node11 [label="{roa_prefix\n|prefix\ VARCHAR\ [PK]\lprefixlen\ TINYINT\ [PK]\lmax_prefixlen\ TINYINT\ [PK]\lversion\ TINYINT\lroa_id\ BIGINT\ [PK,FK]\l}"];
+ node12 [label="{ghostbuster\n|ghostbuster_id\ SERIAL\ [PK]\lvcard\ LONGBLOB\lcert\ LONGBLOB\lghostbuster\ LONGBLOB\lpublished\ DATETIME\ [N]\lself_id\ BIGINT\ [FK]\lca_detail_id\ BIGINT\ [FK]\l}"];
node2 -> node7 [arrowtail=none, arrowhead=crow];
node2 -> node4 [arrowtail=none, arrowhead=crow];
node2 -> node3 [arrowtail=none, arrowhead=crow];
node5 -> node6 [arrowtail=none, arrowhead=crow];
node6 -> node8 [arrowtail=none, arrowhead=crow];
+ node6 -> node12 [arrowtail=none, arrowhead=crow];
node6 -> node9 [arrowtail=none, arrowhead=crow];
node6 -> node10 [arrowtail=none, arrowhead=crow];
node7 -> node8 [arrowtail=none, arrowhead=crow];
@@ -28,6 +30,7 @@ digraph test {
node10 -> node11 [arrowtail=none, arrowhead=crow];
node1 -> node2 [arrowtail=none, arrowhead=crow];
node1 -> node7 [arrowtail=none, arrowhead=crow];
+ node1 -> node12 [arrowtail=none, arrowhead=crow];
node1 -> node4 [arrowtail=none, arrowhead=crow];
node1 -> node3 [arrowtail=none, arrowhead=crow];
node1 -> node10 [arrowtail=none, arrowhead=crow];
diff --git a/rpkid/doc/rpkid.eps b/rpkid/doc/rpkid.eps
index 75644e0e..73284be5 100644
--- a/rpkid/doc/rpkid.eps
+++ b/rpkid/doc/rpkid.eps
@@ -2,7 +2,7 @@
%%Creator: graphviz version 2.26.3 (20100126.1600)
%%Title: test
%%Pages: 1
-%%BoundingBox: 36 36 716 1746
+%%BoundingBox: 36 36 838 1746
%%EndComments
save
%%BeginProlog
@@ -178,139 +178,139 @@ def
%%EndSetup
setupLatin1
%%Page: 1 1
-%%PageBoundingBox: 36 36 716 1746
+%%PageBoundingBox: 36 36 838 1746
%%PageOrientation: Portrait
0 0 1 beginpage
gsave
-36 36 680 1710 boxprim clip newpath
+36 36 802 1710 boxprim clip newpath
1 1 set_scale 0 rotate 40 41 translate
% node1
gsave
0 0 1 nodecolor
-newpath 310.3 1550.8 moveto
-310.3 1701.2 lineto
-485.7 1701.2 lineto
-485.7 1550.8 lineto
+newpath 407.3 1550.8 moveto
+407.3 1701.2 lineto
+582.7 1701.2 lineto
+582.7 1550.8 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 310.3 1550.8 moveto
-310.3 1701.2 lineto
-485.7 1701.2 lineto
-485.7 1550.8 lineto
+newpath 407.3 1550.8 moveto
+407.3 1701.2 lineto
+582.7 1701.2 lineto
+582.7 1550.8 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-387.89 1684.6 moveto 20.21 (self) alignedtext
+484.89 1684.6 moveto 20.21 (self) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 310.3 1676.4 moveto
-485.7 1676.4 lineto
+newpath 407.3 1676.4 moveto
+582.7 1676.4 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1659.8 moveto 121.3 (self_id SERIAL [PK]) alignedtext
+415.3 1659.8 moveto 121.3 (self_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1643 moveto 159.39 (self_handle VARCHAR [U]) alignedtext
+415.3 1643 moveto 159.39 (self_handle VARCHAR [U]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1626.2 moveto 119.36 (use_hsm BOOLEAN) alignedtext
+415.3 1626.2 moveto 119.36 (use_hsm BOOLEAN) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1609.4 moveto 138.38 (crl_interval BIGINT [N]) alignedtext
+415.3 1609.4 moveto 138.38 (crl_interval BIGINT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1592.6 moveto 151.6 (regen_margin BIGINT [N]) alignedtext
+415.3 1592.6 moveto 151.6 (regen_margin BIGINT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1575.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext
+415.3 1575.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-318.3 1559 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext
+415.3 1559 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext
grestore
% node2
gsave
0 0 1 nodecolor
-newpath 156.2 1346.4 moveto
-156.2 1513.6 lineto
-365.8 1513.6 lineto
-365.8 1346.4 lineto
+newpath 182.2 1346.4 moveto
+182.2 1513.6 lineto
+391.8 1513.6 lineto
+391.8 1346.4 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 156.2 1346.4 moveto
-156.2 1513.6 lineto
-365.8 1513.6 lineto
-365.8 1346.4 lineto
+newpath 182.2 1346.4 moveto
+182.2 1513.6 lineto
+391.8 1513.6 lineto
+391.8 1346.4 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-251.67 1497 moveto 18.66 (bsc) alignedtext
+277.67 1497 moveto 18.66 (bsc) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 156.2 1488.8 moveto
-365.8 1488.8 lineto
+newpath 182.2 1488.8 moveto
+391.8 1488.8 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1472.2 moveto 119.75 (bsc_id SERIAL [PK]) alignedtext
+190.2 1472.2 moveto 119.75 (bsc_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1455.4 moveto 157.84 (bsc_handle VARCHAR [U]) alignedtext
+190.2 1455.4 moveto 157.84 (bsc_handle VARCHAR [U]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1438.6 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
+190.2 1438.6 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1421.8 moveto 189.72 (pkcs10_request LONGBLOB [N]) alignedtext
+190.2 1421.8 moveto 189.72 (pkcs10_request LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1405 moveto 117.4 (hash_alg ENUM [N]) alignedtext
+190.2 1405 moveto 117.4 (hash_alg ENUM [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1388.2 moveto 171.84 (signing_cert LONGBLOB [N]) alignedtext
+190.2 1388.2 moveto 171.84 (signing_cert LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1371.4 moveto 193.6 (signing_cert_crl LONGBLOB [N]) alignedtext
+190.2 1371.4 moveto 193.6 (signing_cert_crl LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-164.2 1354.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
+190.2 1354.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
grestore
% node1->node2
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 345.42 1550.78 moveto
-338.89 1541.43 332.15 1531.79 325.46 1522.21 curveto
+newpath 415.18 1550.78 moveto
+404.75 1540.96 393.98 1530.81 383.32 1520.77 curveto
stroke
0 0 0 edgecolor
-newpath 325.33 1522.03 moveto
-323.29 1511.25 lineto
-322.46 1517.93 lineto
-319.6 1513.83 lineto
-319.6 1513.83 lineto
-319.6 1513.83 lineto
-322.46 1517.93 lineto
-315.91 1516.41 lineto
-325.33 1522.03 lineto
+newpath 383.24 1520.69 moveto
+379.05 1510.56 lineto
+379.6 1517.26 lineto
+375.96 1513.83 lineto
+375.96 1513.83 lineto
+375.96 1513.83 lineto
+379.6 1517.26 lineto
+372.88 1517.11 lineto
+383.24 1520.69 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 325.33 1522.03 moveto
-323.29 1511.25 lineto
-322.46 1517.93 lineto
-319.6 1513.83 lineto
-319.6 1513.83 lineto
-319.6 1513.83 lineto
-322.46 1517.93 lineto
-315.91 1516.41 lineto
-325.33 1522.03 lineto
+newpath 383.24 1520.69 moveto
+379.05 1510.56 lineto
+379.6 1517.26 lineto
+375.96 1513.83 lineto
+375.96 1513.83 lineto
+375.96 1513.83 lineto
+379.6 1517.26 lineto
+372.88 1517.11 lineto
+383.24 1520.69 lineto
closepath stroke
grestore
% node3
@@ -367,127 +367,127 @@ grestore
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 398 1550.76 moveto
-398 1485.41 398 1390.45 398 1320.08 curveto
+newpath 476.76 1550.76 moveto
+460.87 1485.27 437.79 1390.06 420.71 1319.65 curveto
stroke
0 0 0 edgecolor
-newpath 398 1319.89 moveto
-402.5 1309.89 lineto
-398 1314.89 lineto
-398 1309.89 lineto
-398 1309.89 lineto
-398 1309.89 lineto
-398 1314.89 lineto
-393.5 1309.89 lineto
-398 1319.89 lineto
+newpath 420.7 1319.61 moveto
+422.72 1308.83 lineto
+419.52 1314.75 lineto
+418.34 1309.89 lineto
+418.34 1309.89 lineto
+418.34 1309.89 lineto
+419.52 1314.75 lineto
+413.97 1310.95 lineto
+420.7 1319.61 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 398 1319.89 moveto
-402.5 1309.89 lineto
-398 1314.89 lineto
-398 1309.89 lineto
-398 1309.89 lineto
-398 1309.89 lineto
-398 1314.89 lineto
-393.5 1309.89 lineto
-398 1319.89 lineto
+newpath 420.7 1319.61 moveto
+422.72 1308.83 lineto
+419.52 1314.75 lineto
+418.34 1309.89 lineto
+418.34 1309.89 lineto
+418.34 1309.89 lineto
+419.52 1314.75 lineto
+413.97 1310.95 lineto
+420.7 1319.61 lineto
closepath stroke
grestore
% node4
gsave
0 0 1 nodecolor
-newpath 280.86 870.8 moveto
-280.86 1105.2 lineto
-509.14 1105.2 lineto
-509.14 870.8 lineto
+newpath 283.86 870.8 moveto
+283.86 1105.2 lineto
+512.14 1105.2 lineto
+512.14 870.8 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 280.86 870.8 moveto
-280.86 1105.2 lineto
-509.14 1105.2 lineto
-509.14 870.8 lineto
+newpath 283.86 870.8 moveto
+283.86 1105.2 lineto
+512.14 1105.2 lineto
+512.14 870.8 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-377.51 1088.6 moveto 34.98 (parent) alignedtext
+380.51 1088.6 moveto 34.98 (parent) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 280.86 1080.4 moveto
-509.14 1080.4 lineto
+newpath 283.86 1080.4 moveto
+512.14 1080.4 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 1063.8 moveto 136.07 (parent_id SERIAL [PK]) alignedtext
+291.86 1063.8 moveto 136.07 (parent_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 1047 moveto 174.16 (parent_handle VARCHAR [U]) alignedtext
+291.86 1047 moveto 174.16 (parent_handle VARCHAR [U]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 1030.2 moveto 185.05 (bpki_cms_cert LONGBLOB [N]) alignedtext
+291.86 1030.2 moveto 185.05 (bpki_cms_cert LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 1013.4 moveto 188.18 (bpki_cms_glue LONGBLOB [N]) alignedtext
+291.86 1013.4 moveto 188.18 (bpki_cms_glue LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 996.6 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext
+291.86 996.6 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 979.8 moveto 109.62 (sia_base TEXT [N]) alignedtext
+291.86 979.8 moveto 109.62 (sia_base TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 963 moveto 136.05 (sender_name TEXT [N]) alignedtext
+291.86 963 moveto 136.05 (sender_name TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 946.2 moveto 148.49 (recipient_name TEXT [N]) alignedtext
+291.86 946.2 moveto 148.49 (recipient_name TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 929.4 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext
+291.86 929.4 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 912.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
+291.86 912.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 895.8 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext
+291.86 895.8 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-288.86 879 moveto 156.29 (repository_id BIGINT [FK]) alignedtext
+291.86 879 moveto 156.29 (repository_id BIGINT [FK]) alignedtext
grestore
% node1->node4
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 444.54 1550.49 moveto
-497.74 1454.14 571.35 1283.05 521 1142 curveto
-517.65 1132.61 513.45 1123.37 508.63 1114.38 curveto
+newpath 516.4 1550.53 moveto
+540.17 1453.12 569.27 1279.79 521 1142 curveto
+517.69 1132.55 513.53 1123.26 508.76 1114.2 curveto
stroke
0 0 0 edgecolor
-newpath 508.53 1114.19 moveto
-507.55 1103.27 lineto
-506.08 1109.83 lineto
-503.63 1105.47 lineto
-503.63 1105.47 lineto
-503.63 1105.47 lineto
-506.08 1109.83 lineto
-499.7 1107.68 lineto
-508.53 1114.19 lineto
+newpath 508.64 1113.97 moveto
+507.73 1103.04 lineto
+506.22 1109.59 lineto
+503.8 1105.22 lineto
+503.8 1105.22 lineto
+503.8 1105.22 lineto
+506.22 1109.59 lineto
+499.86 1107.4 lineto
+508.64 1113.97 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 508.53 1114.19 moveto
-507.55 1103.27 lineto
-506.08 1109.83 lineto
-503.63 1105.47 lineto
-503.63 1105.47 lineto
-503.63 1105.47 lineto
-506.08 1109.83 lineto
-499.7 1107.68 lineto
-508.53 1114.19 lineto
+newpath 508.64 1113.97 moveto
+507.73 1103.04 lineto
+506.22 1109.59 lineto
+503.8 1105.22 lineto
+503.8 1105.22 lineto
+503.8 1105.22 lineto
+506.22 1109.59 lineto
+499.86 1107.4 lineto
+508.64 1113.97 lineto
closepath stroke
grestore
% node7
@@ -541,715 +541,830 @@ grestore
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 310.16 1609.91 moveto
-254.31 1594.88 185.51 1566.53 147 1514 curveto
-104.58 1456.14 99.17 1373.4 102.71 1311.45 curveto
+newpath 407.06 1605.79 moveto
+322.91 1584.69 204.29 1549.74 173 1514 curveto
+124.68 1458.8 112.02 1374.78 110.21 1311.72 curveto
stroke
0 0 0 edgecolor
-newpath 102.72 1311.28 moveto
-107.87 1301.59 lineto
-103.05 1306.29 lineto
-103.38 1301.3 lineto
-103.38 1301.3 lineto
-103.38 1301.3 lineto
-103.05 1306.29 lineto
-98.89 1301 lineto
-102.72 1311.28 lineto
+newpath 110.2 1311.39 moveto
+114.5 1301.3 lineto
+110.1 1306.39 lineto
+110 1301.39 lineto
+110 1301.39 lineto
+110 1301.39 lineto
+110.1 1306.39 lineto
+105.5 1301.48 lineto
+110.2 1311.39 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 102.72 1311.28 moveto
-107.87 1301.59 lineto
-103.05 1306.29 lineto
-103.38 1301.3 lineto
-103.38 1301.3 lineto
-103.38 1301.3 lineto
-103.05 1306.29 lineto
-98.89 1301 lineto
-102.72 1311.28 lineto
+newpath 110.2 1311.39 moveto
+114.5 1301.3 lineto
+110.1 1306.39 lineto
+110 1301.39 lineto
+110 1301.39 lineto
+110 1301.39 lineto
+110.1 1306.39 lineto
+105.5 1301.48 lineto
+110.2 1311.39 lineto
closepath stroke
grestore
% node10
gsave
0 0 1 nodecolor
-newpath 493.8 154.8 moveto
-493.8 305.2 lineto
-662.2 305.2 lineto
-662.2 154.8 lineto
+newpath 425.8 154.8 moveto
+425.8 305.2 lineto
+594.2 305.2 lineto
+594.2 154.8 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 493.8 154.8 moveto
-493.8 305.2 lineto
-662.2 305.2 lineto
-662.2 154.8 lineto
+newpath 425.8 154.8 moveto
+425.8 305.2 lineto
+594.2 305.2 lineto
+594.2 154.8 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-569.06 288.6 moveto 17.88 (roa) alignedtext
+501.06 288.6 moveto 17.88 (roa) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 493.8 280.4 moveto
-662.2 280.4 lineto
+newpath 425.8 280.4 moveto
+594.2 280.4 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 263.8 moveto 118.97 (roa_id SERIAL [PK]) alignedtext
+433.8 263.8 moveto 118.97 (roa_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 247 moveto 69.58 (asn BIGINT) alignedtext
+433.8 247 moveto 69.58 (asn BIGINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 230.2 moveto 100.69 (cert LONGBLOB) alignedtext
+433.8 230.2 moveto 100.69 (cert LONGBLOB) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 213.4 moveto 97.58 (roa LONGBLOB) alignedtext
+433.8 213.4 moveto 97.58 (roa LONGBLOB) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 196.6 moveto 152.4 (published DATETIME [N]) alignedtext
+433.8 196.6 moveto 152.4 (published DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext
+433.8 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-501.8 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
+433.8 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
grestore
% node1->node10
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 483.92 1550.75 moveto
-493.77 1539.22 502.84 1526.85 510 1514 curveto
-574.05 1399.13 578 1357.52 578 1226 curveto
+newpath 536.51 1550.64 moveto
+541.79 1538.66 546.54 1526.19 550 1514 curveto
+585.13 1390.29 578 1354.6 578 1226 curveto
578 1226 578 1226 578 741 curveto
-578 591.33 578 417.01 578 315.52 curveto
+578 562.69 565.55 517.85 536 342 curveto
+534.55 333.35 532.82 324.36 530.97 315.42 curveto
stroke
0 0 0 edgecolor
-newpath 578 315.33 moveto
-582.5 305.33 lineto
-578 310.33 lineto
-578 305.33 lineto
-578 305.33 lineto
-578 305.33 lineto
-578 310.33 lineto
-573.5 305.33 lineto
-578 315.33 lineto
+newpath 530.91 315.13 moveto
+533.23 304.42 lineto
+529.87 310.24 lineto
+528.83 305.35 lineto
+528.83 305.35 lineto
+528.83 305.35 lineto
+529.87 310.24 lineto
+524.43 306.29 lineto
+530.91 315.13 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 578 315.33 moveto
-582.5 305.33 lineto
-578 310.33 lineto
-578 305.33 lineto
-578 305.33 lineto
-578 305.33 lineto
-578 310.33 lineto
-573.5 305.33 lineto
-578 315.33 lineto
+newpath 530.91 315.13 moveto
+533.23 304.42 lineto
+529.87 310.24 lineto
+528.83 305.35 lineto
+528.83 305.35 lineto
+528.83 305.35 lineto
+529.87 310.24 lineto
+524.43 306.29 lineto
+530.91 315.13 lineto
+closepath stroke
+grestore
+% node12
+gsave
+0 0 1 nodecolor
+newpath 612.18 154.8 moveto
+612.18 305.2 lineto
+793.82 305.2 lineto
+793.82 154.8 lineto
+closepath fill
+1 setlinewidth
+filled
+0 0 0 nodecolor
+newpath 612.18 154.8 moveto
+612.18 305.2 lineto
+793.82 305.2 lineto
+793.82 154.8 lineto
+closepath stroke
+0 0 0 nodecolor
+14 /Times-Roman set_font
+670.73 288.6 moveto 64.55 (ghostbuster) alignedtext
+1 setlinewidth
+filled
+0 0 0 nodecolor
+newpath 612.18 280.4 moveto
+793.82 280.4 lineto
+stroke
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 263.8 moveto 165.64 (ghostbuster_id SERIAL [PK]) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 247 moveto 110.79 (vcard LONGBLOB) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 230.2 moveto 100.69 (cert LONGBLOB) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 213.4 moveto 144.25 (ghostbuster LONGBLOB) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 196.6 moveto 152.4 (published DATETIME [N]) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext
+0 0 0 nodecolor
+14 /Times-Roman set_font
+620.18 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
+grestore
+% node1->node12
+gsave
+1 setlinewidth
+0 0 0 edgecolor
+newpath 556.48 1550.64 moveto
+564.44 1538.81 571.93 1526.39 578 1514 curveto
+636.55 1394.62 659 1358.97 659 1226 curveto
+659 1226 659 1226 659 741 curveto
+659 590.99 678.05 417.13 691.08 315.76 curveto
+stroke
+0 0 0 edgecolor
+newpath 691.12 315.5 moveto
+696.87 306.16 lineto
+691.76 310.54 lineto
+692.4 305.58 lineto
+692.4 305.58 lineto
+692.4 305.58 lineto
+691.76 310.54 lineto
+687.94 305 lineto
+691.12 315.5 lineto
+closepath fill
+1 setlinewidth
+solid
+0 0 0 edgecolor
+newpath 691.12 315.5 moveto
+696.87 306.16 lineto
+691.76 310.54 lineto
+692.4 305.58 lineto
+692.4 305.58 lineto
+692.4 305.58 lineto
+691.76 310.54 lineto
+687.94 305 lineto
+691.12 315.5 lineto
closepath stroke
grestore
% node2->node3
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 317.32 1346.14 moveto
-323.48 1336.97 329.77 1327.6 335.99 1318.33 curveto
+newpath 332.63 1346.14 moveto
+337.52 1337.16 342.51 1327.98 347.45 1318.9 curveto
stroke
0 0 0 edgecolor
-newpath 336.11 1318.16 moveto
-345.42 1312.37 lineto
-338.89 1314.01 lineto
-341.68 1309.86 lineto
-341.68 1309.86 lineto
-341.68 1309.86 lineto
-338.89 1314.01 lineto
-337.95 1307.35 lineto
-336.11 1318.16 lineto
+newpath 347.59 1318.65 moveto
+356.32 1312.01 lineto
+349.98 1314.25 lineto
+352.37 1309.86 lineto
+352.37 1309.86 lineto
+352.37 1309.86 lineto
+349.98 1314.25 lineto
+348.42 1307.71 lineto
+347.59 1318.65 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 336.11 1318.16 moveto
-345.42 1312.37 lineto
-338.89 1314.01 lineto
-341.68 1309.86 lineto
-341.68 1309.86 lineto
-341.68 1309.86 lineto
-338.89 1314.01 lineto
-337.95 1307.35 lineto
-336.11 1318.16 lineto
+newpath 347.59 1318.65 moveto
+356.32 1312.01 lineto
+349.98 1314.25 lineto
+352.37 1309.86 lineto
+352.37 1309.86 lineto
+352.37 1309.86 lineto
+349.98 1314.25 lineto
+348.42 1307.71 lineto
+347.59 1318.65 lineto
closepath stroke
grestore
% node2->node4
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 251.99 1346.35 moveto
-248.73 1287.39 250.67 1207.59 275 1142 curveto
-278.45 1132.7 282.68 1123.52 287.46 1114.55 curveto
+newpath 267.47 1346.29 moveto
+257.56 1287.48 251.92 1207.88 275 1142 curveto
+278.31 1132.55 282.47 1123.26 287.24 1114.2 curveto
stroke
0 0 0 edgecolor
-newpath 287.55 1114.39 moveto
-296.35 1107.84 lineto
-289.98 1110.02 lineto
-292.42 1105.65 lineto
-292.42 1105.65 lineto
-292.42 1105.65 lineto
-289.98 1110.02 lineto
-288.49 1103.46 lineto
-287.55 1114.39 lineto
+newpath 287.36 1113.97 moveto
+296.14 1107.4 lineto
+289.78 1109.59 lineto
+292.2 1105.22 lineto
+292.2 1105.22 lineto
+292.2 1105.22 lineto
+289.78 1109.59 lineto
+288.27 1103.04 lineto
+287.36 1113.97 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 287.55 1114.39 moveto
-296.35 1107.84 lineto
-289.98 1110.02 lineto
-292.42 1105.65 lineto
-292.42 1105.65 lineto
-292.42 1105.65 lineto
-289.98 1110.02 lineto
-288.49 1103.46 lineto
-287.55 1114.39 lineto
+newpath 287.36 1113.97 moveto
+296.14 1107.4 lineto
+289.78 1109.59 lineto
+292.2 1105.22 lineto
+292.2 1105.22 lineto
+292.2 1105.22 lineto
+289.78 1109.59 lineto
+288.27 1103.04 lineto
+287.36 1113.97 lineto
closepath stroke
grestore
% node2->node7
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 200.57 1346.14 moveto
-191.89 1334.09 182.95 1321.68 174.27 1309.64 curveto
+newpath 215.89 1346.14 moveto
+205.56 1333.97 194.94 1321.45 184.63 1309.29 curveto
stroke
0 0 0 edgecolor
-newpath 174.15 1309.47 moveto
-171.95 1298.73 lineto
-171.23 1305.41 lineto
-168.3 1301.36 lineto
-168.3 1301.36 lineto
-168.3 1301.36 lineto
-171.23 1305.41 lineto
-164.65 1303.99 lineto
-174.15 1309.47 lineto
+newpath 184.37 1308.98 moveto
+181.34 1298.45 lineto
+181.14 1305.17 lineto
+177.91 1301.36 lineto
+177.91 1301.36 lineto
+177.91 1301.36 lineto
+181.14 1305.17 lineto
+174.47 1304.27 lineto
+184.37 1308.98 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 174.15 1309.47 moveto
-171.95 1298.73 lineto
-171.23 1305.41 lineto
-168.3 1301.36 lineto
-168.3 1301.36 lineto
-168.3 1301.36 lineto
-171.23 1305.41 lineto
-164.65 1303.99 lineto
-174.15 1309.47 lineto
+newpath 184.37 1308.98 moveto
+181.34 1298.45 lineto
+181.14 1305.17 lineto
+177.91 1301.36 lineto
+177.91 1301.36 lineto
+177.91 1301.36 lineto
+181.14 1305.17 lineto
+174.47 1304.27 lineto
+184.37 1308.98 lineto
closepath stroke
grestore
% node3->node4
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 396.94 1142.09 moveto
-396.83 1133.44 396.72 1124.51 396.61 1115.52 curveto
+newpath 398 1142.09 moveto
+398 1133.44 398 1124.51 398 1115.52 curveto
stroke
0 0 0 edgecolor
-newpath 396.61 1115.35 moveto
-400.98 1105.29 lineto
-396.54 1110.35 lineto
-396.48 1105.35 lineto
-396.48 1105.35 lineto
-396.48 1105.35 lineto
-396.54 1110.35 lineto
-391.98 1105.41 lineto
-396.61 1115.35 lineto
+newpath 398 1115.35 moveto
+402.5 1105.35 lineto
+398 1110.35 lineto
+398 1105.35 lineto
+398 1105.35 lineto
+398 1105.35 lineto
+398 1110.35 lineto
+393.5 1105.35 lineto
+398 1115.35 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 396.61 1115.35 moveto
-400.98 1105.29 lineto
-396.54 1110.35 lineto
-396.48 1105.35 lineto
-396.48 1105.35 lineto
-396.48 1105.35 lineto
-396.54 1110.35 lineto
-391.98 1105.41 lineto
-396.61 1115.35 lineto
+newpath 398 1115.35 moveto
+402.5 1105.35 lineto
+398 1110.35 lineto
+398 1105.35 lineto
+398 1105.35 lineto
+398 1105.35 lineto
+398 1110.35 lineto
+393.5 1105.35 lineto
+398 1115.35 lineto
closepath stroke
grestore
% node5
gsave
0 0 1 nodecolor
-newpath 274.21 649 moveto
-274.21 833 lineto
-511.79 833 lineto
-511.79 649 lineto
+newpath 279.21 649 moveto
+279.21 833 lineto
+516.79 833 lineto
+516.79 649 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 274.21 649 moveto
-274.21 833 lineto
-511.79 833 lineto
-511.79 649 lineto
+newpath 279.21 649 moveto
+279.21 833 lineto
+516.79 833 lineto
+516.79 649 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-386.79 816.4 moveto 12.43 (ca) alignedtext
+391.79 816.4 moveto 12.43 (ca) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 274.21 808.2 moveto
-511.79 808.2 lineto
+newpath 279.21 808.2 moveto
+516.79 808.2 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 791.6 moveto 113.52 (ca_id SERIAL [PK]) alignedtext
+287.21 791.6 moveto 113.52 (ca_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 774.8 moveto 111.57 (last_crl_sn BIGINT) alignedtext
+287.21 774.8 moveto 111.57 (last_crl_sn BIGINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 758 moveto 145.01 (last_manifest_sn BIGINT) alignedtext
+287.21 758 moveto 145.01 (last_manifest_sn BIGINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 741.2 moveto 221.59 (next_manifest_update DATETIME [N]) alignedtext
+287.21 741.2 moveto 221.59 (next_manifest_update DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 724.4 moveto 188.15 (next_crl_update DATETIME [N]) alignedtext
+287.21 724.4 moveto 188.15 (next_crl_update DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 707.6 moveto 131.8 (last_issued_sn BIGINT) alignedtext
+287.21 707.6 moveto 131.8 (last_issued_sn BIGINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 690.8 moveto 100.29 (sia_uri TEXT [N]) alignedtext
+287.21 690.8 moveto 100.29 (sia_uri TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 674 moveto 185.79 (parent_resource_class TEXT [N]) alignedtext
+287.21 674 moveto 185.79 (parent_resource_class TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-282.21 657.2 moveto 134.5 (parent_id BIGINT [FK]) alignedtext
+287.21 657.2 moveto 134.5 (parent_id BIGINT [FK]) alignedtext
grestore
% node4->node5
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 394.05 870.65 moveto
-393.98 861.51 393.9 852.34 393.83 843.31 curveto
+newpath 398 870.65 moveto
+398 861.51 398 852.34 398 843.31 curveto
stroke
0 0 0 edgecolor
-newpath 393.83 843.2 moveto
-398.25 833.16 lineto
-393.79 838.2 lineto
-393.75 833.2 lineto
-393.75 833.2 lineto
-393.75 833.2 lineto
-393.79 838.2 lineto
-389.25 833.24 lineto
-393.83 843.2 lineto
+newpath 398 843.2 moveto
+402.5 833.2 lineto
+398 838.2 lineto
+398 833.2 lineto
+398 833.2 lineto
+398 833.2 lineto
+398 838.2 lineto
+393.5 833.2 lineto
+398 843.2 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 393.83 843.2 moveto
-398.25 833.16 lineto
-393.79 838.2 lineto
-393.75 833.2 lineto
-393.75 833.2 lineto
-393.75 833.2 lineto
-393.79 838.2 lineto
-389.25 833.24 lineto
-393.83 843.2 lineto
+newpath 398 843.2 moveto
+402.5 833.2 lineto
+398 838.2 lineto
+398 833.2 lineto
+398 833.2 lineto
+398 833.2 lineto
+398 838.2 lineto
+393.5 833.2 lineto
+398 843.2 lineto
closepath stroke
grestore
% node6
gsave
0 0 1 nodecolor
-newpath 256.09 343 moveto
-256.09 611 lineto
-513.91 611 lineto
-513.91 343 lineto
+newpath 269.09 343 moveto
+269.09 611 lineto
+526.91 611 lineto
+526.91 343 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 256.09 343 moveto
-256.09 611 lineto
-513.91 611 lineto
-513.91 343 lineto
+newpath 269.09 343 moveto
+269.09 611 lineto
+526.91 611 lineto
+526.91 343 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-359.73 594.4 moveto 50.53 (ca_detail) alignedtext
+372.73 594.4 moveto 50.53 (ca_detail) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 256.09 586.2 moveto
-513.91 586.2 lineto
+newpath 269.09 586.2 moveto
+526.91 586.2 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 569.6 moveto 151.62 (ca_detail_id SERIAL [PK]) alignedtext
+277.09 569.6 moveto 151.62 (ca_detail_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 552.8 moveto 164.84 (public_key LONGBLOB [N]) alignedtext
+277.09 552.8 moveto 164.84 (public_key LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 536 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
+277.09 536 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 519.2 moveto 153.94 (latest_crl LONGBLOB [N]) alignedtext
+277.09 519.2 moveto 153.94 (latest_crl LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 502.4 moveto 174.16 (crl_published DATETIME [N]) alignedtext
+277.09 502.4 moveto 174.16 (crl_published DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 485.6 moveto 179.59 (latest_ca_cert LONGBLOB [N]) alignedtext
+277.09 485.6 moveto 179.59 (latest_ca_cert LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 468.8 moveto 241.82 (manifest_private_key_id LONGBLOB [N]) alignedtext
+277.09 468.8 moveto 241.82 (manifest_private_key_id LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 452 moveto 220.05 (manifest_public_key LONGBLOB [N]) alignedtext
+277.09 452 moveto 220.05 (manifest_public_key LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 435.2 moveto 215.36 (latest_manifest_cert LONGBLOB [N]) alignedtext
+277.09 435.2 moveto 215.36 (latest_manifest_cert LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 418.4 moveto 187.38 (latest_manifest LONGBLOB [N]) alignedtext
+277.09 418.4 moveto 187.38 (latest_manifest LONGBLOB [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 401.6 moveto 207.6 (manifest_published DATETIME [N]) alignedtext
+277.09 401.6 moveto 207.6 (manifest_published DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 384.8 moveto 70.37 (state ENUM) alignedtext
+277.09 384.8 moveto 70.37 (state ENUM) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 368 moveto 125.15 (ca_cert_uri TEXT [N]) alignedtext
+277.09 368 moveto 125.15 (ca_cert_uri TEXT [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-264.09 351.2 moveto 111.95 (ca_id BIGINT [FK]) alignedtext
+277.09 351.2 moveto 111.95 (ca_id BIGINT [FK]) alignedtext
grestore
% node5->node6
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 390.2 648.67 moveto
-389.93 639.71 389.65 630.49 389.37 621.19 curveto
+newpath 398 648.67 moveto
+398 639.71 398 630.49 398 621.19 curveto
stroke
0 0 0 edgecolor
-newpath 389.37 621.06 moveto
-393.56 610.93 lineto
-389.21 616.06 lineto
-389.06 611.07 lineto
-389.06 611.07 lineto
-389.06 611.07 lineto
-389.21 616.06 lineto
-384.56 611.2 lineto
-389.37 621.06 lineto
+newpath 398 621.07 moveto
+402.5 611.07 lineto
+398 616.07 lineto
+398 611.07 lineto
+398 611.07 lineto
+398 611.07 lineto
+398 616.07 lineto
+393.5 611.07 lineto
+398 621.07 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 389.37 621.06 moveto
-393.56 610.93 lineto
-389.21 616.06 lineto
-389.06 611.07 lineto
-389.06 611.07 lineto
-389.06 611.07 lineto
-389.21 616.06 lineto
-384.56 611.2 lineto
-389.37 621.06 lineto
+newpath 398 621.07 moveto
+402.5 611.07 lineto
+398 616.07 lineto
+398 611.07 lineto
+398 611.07 lineto
+398 611.07 lineto
+398 616.07 lineto
+393.5 611.07 lineto
+398 621.07 lineto
closepath stroke
grestore
% node8
gsave
0 0 1 nodecolor
-newpath 78.47 163.2 moveto
-78.47 296.8 lineto
-251.53 296.8 lineto
-251.53 163.2 lineto
+newpath 27.47 163.2 moveto
+27.47 296.8 lineto
+200.53 296.8 lineto
+200.53 163.2 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 78.47 163.2 moveto
-78.47 296.8 lineto
-251.53 296.8 lineto
-251.53 163.2 lineto
+newpath 27.47 163.2 moveto
+27.47 296.8 lineto
+200.53 296.8 lineto
+200.53 163.2 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-137.01 280.2 moveto 55.98 (child_cert) alignedtext
+86.01 280.2 moveto 55.98 (child_cert) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 78.47 272 moveto
-251.53 272 lineto
+newpath 27.47 272 moveto
+200.53 272 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 255.4 moveto 157.07 (child_cert_id SERIAL [PK]) alignedtext
+35.47 255.4 moveto 157.07 (child_cert_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 238.6 moveto 100.69 (cert LONGBLOB) alignedtext
+35.47 238.6 moveto 100.69 (cert LONGBLOB) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 221.8 moveto 152.4 (published DATETIME [N]) alignedtext
+35.47 221.8 moveto 152.4 (published DATETIME [N]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 205 moveto 90.59 (ski TINYBLOB) alignedtext
+35.47 205 moveto 90.59 (ski TINYBLOB) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 188.2 moveto 127.52 (child_id BIGINT [FK]) alignedtext
+35.47 188.2 moveto 127.52 (child_id BIGINT [FK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-86.47 171.4 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
+35.47 171.4 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
grestore
% node6->node8
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 265.34 342.66 moveto
-253.66 329.54 242.12 316.59 231.26 304.39 curveto
+newpath 268.88 364.7 moveto
+245.03 343.95 220.68 322.78 198.57 303.55 curveto
stroke
0 0 0 edgecolor
-newpath 231.25 304.38 moveto
-227.95 293.91 lineto
-227.92 300.64 lineto
-224.59 296.91 lineto
-224.59 296.91 lineto
-224.59 296.91 lineto
-227.92 300.64 lineto
-221.23 299.9 lineto
-231.25 304.38 lineto
+newpath 198.39 303.4 moveto
+193.8 293.44 lineto
+194.62 300.12 lineto
+190.85 296.84 lineto
+190.85 296.84 lineto
+190.85 296.84 lineto
+194.62 300.12 lineto
+187.89 300.23 lineto
+198.39 303.4 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 231.25 304.38 moveto
-227.95 293.91 lineto
-227.92 300.64 lineto
-224.59 296.91 lineto
-224.59 296.91 lineto
-224.59 296.91 lineto
-227.92 300.64 lineto
-221.23 299.9 lineto
-231.25 304.38 lineto
+newpath 198.39 303.4 moveto
+193.8 293.44 lineto
+194.62 300.12 lineto
+190.85 296.84 lineto
+190.85 296.84 lineto
+190.85 296.84 lineto
+194.62 300.12 lineto
+187.89 300.23 lineto
+198.39 303.4 lineto
closepath stroke
grestore
% node9
gsave
0 0 1 nodecolor
-newpath 285.92 171.6 moveto
-285.92 288.4 lineto
-476.08 288.4 lineto
-476.08 171.6 lineto
+newpath 217.92 171.6 moveto
+217.92 288.4 lineto
+408.08 288.4 lineto
+408.08 171.6 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 285.92 171.6 moveto
-285.92 288.4 lineto
-476.08 288.4 lineto
-476.08 171.6 lineto
+newpath 217.92 171.6 moveto
+217.92 288.4 lineto
+408.08 288.4 lineto
+408.08 171.6 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-344.46 271.8 moveto 73.07 (revoked_cert) alignedtext
+276.46 271.8 moveto 73.07 (revoked_cert) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 285.92 263.6 moveto
-476.08 263.6 lineto
+newpath 217.92 263.6 moveto
+408.08 263.6 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-293.92 247 moveto 174.16 (revoked_cert_id SERIAL [PK]) alignedtext
+225.92 247 moveto 174.16 (revoked_cert_id SERIAL [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-293.92 230.2 moveto 81.24 (serial BIGINT) alignedtext
+225.92 230.2 moveto 81.24 (serial BIGINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-293.92 213.4 moveto 120.12 (revoked DATETIME) alignedtext
+225.92 213.4 moveto 120.12 (revoked DATETIME) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-293.92 196.6 moveto 115.45 (expires DATETIME) alignedtext
+225.92 196.6 moveto 115.45 (expires DATETIME) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-293.92 179.8 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
+225.92 179.8 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
grestore
% node6->node9
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 382.82 342.66 moveto
-382.58 327.51 382.34 312.58 382.11 298.79 curveto
+newpath 351.77 342.66 moveto
+346.45 327.21 341.22 312 336.4 297.98 curveto
stroke
0 0 0 edgecolor
-newpath 382.11 298.49 moveto
-386.45 288.41 lineto
-382.03 293.49 lineto
-381.95 288.49 lineto
-381.95 288.49 lineto
-381.95 288.49 lineto
-382.03 293.49 lineto
-377.45 288.56 lineto
-382.11 298.49 lineto
+newpath 336.38 297.94 moveto
+337.38 287.02 lineto
+334.75 293.21 lineto
+333.13 288.49 lineto
+333.13 288.49 lineto
+333.13 288.49 lineto
+334.75 293.21 lineto
+328.87 289.95 lineto
+336.38 297.94 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 382.11 298.49 moveto
-386.45 288.41 lineto
-382.03 293.49 lineto
-381.95 288.49 lineto
-381.95 288.49 lineto
-381.95 288.49 lineto
-382.03 293.49 lineto
-377.45 288.56 lineto
-382.11 298.49 lineto
+newpath 336.38 297.94 moveto
+337.38 287.02 lineto
+334.75 293.21 lineto
+333.13 288.49 lineto
+333.13 288.49 lineto
+333.13 288.49 lineto
+334.75 293.21 lineto
+328.87 289.95 lineto
+336.38 297.94 lineto
closepath stroke
grestore
% node6->node10
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 489.97 342.66 moveto
-497.78 332.67 505.51 322.78 512.96 313.24 curveto
+newpath 458.92 342.66 moveto
+463.22 333.17 467.48 323.77 471.61 314.67 curveto
+stroke
+0 0 0 edgecolor
+newpath 471.72 314.43 moveto
+479.94 307.18 lineto
+473.78 309.88 lineto
+475.85 305.32 lineto
+475.85 305.32 lineto
+475.85 305.32 lineto
+473.78 309.88 lineto
+471.75 303.46 lineto
+471.72 314.43 lineto
+closepath fill
+1 setlinewidth
+solid
+0 0 0 edgecolor
+newpath 471.72 314.43 moveto
+479.94 307.18 lineto
+473.78 309.88 lineto
+475.85 305.32 lineto
+475.85 305.32 lineto
+475.85 305.32 lineto
+473.78 309.88 lineto
+471.75 303.46 lineto
+471.72 314.43 lineto
+closepath stroke
+grestore
+% node6->node12
+gsave
+1 setlinewidth
+0 0 0 edgecolor
+newpath 527.35 372.25 moveto
+552.99 351.49 579.52 330 603.95 310.21 curveto
stroke
0 0 0 edgecolor
-newpath 512.99 313.2 moveto
-522.69 308.09 lineto
-516.07 309.26 lineto
-519.14 305.32 lineto
-519.14 305.32 lineto
-519.14 305.32 lineto
-516.07 309.26 lineto
-515.6 302.55 lineto
-512.99 313.2 lineto
+newpath 604.04 310.14 moveto
+614.64 307.35 lineto
+607.92 307 lineto
+611.81 303.85 lineto
+611.81 303.85 lineto
+611.81 303.85 lineto
+607.92 307 lineto
+608.98 300.35 lineto
+604.04 310.14 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 512.99 313.2 moveto
-522.69 308.09 lineto
-516.07 309.26 lineto
-519.14 305.32 lineto
-519.14 305.32 lineto
-519.14 305.32 lineto
-516.07 309.26 lineto
-515.6 302.55 lineto
-512.99 313.2 lineto
+newpath 604.04 310.14 moveto
+614.64 307.35 lineto
+607.92 307 lineto
+611.81 303.85 lineto
+611.81 303.85 lineto
+611.81 303.85 lineto
+607.92 307 lineto
+608.98 300.35 lineto
+604.04 310.14 lineto
closepath stroke
grestore
% node7->node8
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 117.85 1150.73 moveto
-127.29 966.37 151.5 493.71 161.04 307.28 curveto
+newpath 114 1150.73 moveto
+114 966.37 114 493.71 114 307.28 curveto
stroke
0 0 0 edgecolor
-newpath 161.06 307 moveto
-166.06 297.24 lineto
-161.31 302.01 lineto
-161.57 297.01 lineto
-161.57 297.01 lineto
-161.57 297.01 lineto
-161.31 302.01 lineto
-157.07 296.78 lineto
-161.06 307 lineto
+newpath 114 307.01 moveto
+118.5 297.01 lineto
+114 302.01 lineto
+114 297.01 lineto
+114 297.01 lineto
+114 297.01 lineto
+114 302.01 lineto
+109.5 297.01 lineto
+114 307.01 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 161.06 307 moveto
-166.06 297.24 lineto
-161.31 302.01 lineto
-161.57 297.01 lineto
-161.57 297.01 lineto
-161.57 297.01 lineto
-161.31 302.01 lineto
-157.07 296.78 lineto
-161.06 307 lineto
+newpath 114 307.01 moveto
+118.5 297.01 lineto
+114 302.01 lineto
+114 297.01 lineto
+114 297.01 lineto
+114 297.01 lineto
+114 302.01 lineto
+109.5 297.01 lineto
+114 307.01 lineto
closepath stroke
grestore
% node11
gsave
0 0 1 nodecolor
-newpath 483.7 .6 moveto
-483.7 117.4 lineto
-672.3 117.4 lineto
-672.3 .6 lineto
+newpath 415.7 .6 moveto
+415.7 117.4 lineto
+604.3 117.4 lineto
+604.3 .6 lineto
closepath fill
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 483.7 .6 moveto
-483.7 117.4 lineto
-672.3 117.4 lineto
-672.3 .6 lineto
+newpath 415.7 .6 moveto
+415.7 117.4 lineto
+604.3 117.4 lineto
+604.3 .6 lineto
closepath stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-548.85 100.8 moveto 58.3 (roa_prefix) alignedtext
+480.85 100.8 moveto 58.3 (roa_prefix) alignedtext
1 setlinewidth
filled
0 0 0 nodecolor
-newpath 483.7 92.6 moveto
-672.3 92.6 lineto
+newpath 415.7 92.6 moveto
+604.3 92.6 lineto
stroke
0 0 0 nodecolor
14 /Times-Roman set_font
-491.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext
+423.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-491.7 59.2 moveto 141.49 (prefixlen TINYINT [PK]) alignedtext
+423.7 59.2 moveto 141.49 (prefixlen TINYINT [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-491.7 42.4 moveto 172.59 (max_prefixlen TINYINT [PK]) alignedtext
+423.7 42.4 moveto 172.59 (max_prefixlen TINYINT [PK]) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-491.7 25.6 moveto 101.46 (version TINYINT) alignedtext
+423.7 25.6 moveto 101.46 (version TINYINT) alignedtext
0 0 0 nodecolor
14 /Times-Roman set_font
-491.7 8.8 moveto 138.79 (roa_id BIGINT [PK,FK]) alignedtext
+423.7 8.8 moveto 138.79 (roa_id BIGINT [PK,FK]) alignedtext
grestore
% node10->node11
gsave
1 setlinewidth
0 0 0 edgecolor
-newpath 578 154.5 moveto
-578 145.56 578 136.47 578 127.64 curveto
+newpath 510 154.5 moveto
+510 145.56 510 136.47 510 127.64 curveto
stroke
0 0 0 edgecolor
-newpath 578 127.4 moveto
-582.5 117.4 lineto
-578 122.4 lineto
-578 117.4 lineto
-578 117.4 lineto
-578 117.4 lineto
-578 122.4 lineto
-573.5 117.4 lineto
-578 127.4 lineto
+newpath 510 127.4 moveto
+514.5 117.4 lineto
+510 122.4 lineto
+510 117.4 lineto
+510 117.4 lineto
+510 117.4 lineto
+510 122.4 lineto
+505.5 117.4 lineto
+510 127.4 lineto
closepath fill
1 setlinewidth
solid
0 0 0 edgecolor
-newpath 578 127.4 moveto
-582.5 117.4 lineto
-578 122.4 lineto
-578 117.4 lineto
-578 117.4 lineto
-578 117.4 lineto
-578 122.4 lineto
-573.5 117.4 lineto
-578 127.4 lineto
+newpath 510 127.4 moveto
+514.5 117.4 lineto
+510 122.4 lineto
+510 117.4 lineto
+510 117.4 lineto
+510 117.4 lineto
+510 122.4 lineto
+505.5 117.4 lineto
+510 127.4 lineto
closepath stroke
grestore
endpage
diff --git a/rpkid/doc/rpkid.png b/rpkid/doc/rpkid.png
index ad3bae2e..e5d1cbb4 100644
--- a/rpkid/doc/rpkid.png
+++ b/rpkid/doc/rpkid.png
Binary files differ