Schema changes a while back

svn path=/rpkid/doc/rpkid.dot; revision=3425

3 files changed, 523 insertions, 523 deletions

diff --git a/rpkid/doc/rpkid.dot b/rpkid/doc/rpkid.dot
index 7577274e..2e9ab734 100644
--- a/rpkid/doc/rpkid.dot
+++ b/rpkid/doc/rpkid.dot
@@ -13,7 +13,7 @@ digraph test {
 	node7 [label="{child\n|child_id\ SERIAL\ [PK]\lchild_handle\ VARCHAR\ [U]\lbpki_cert\ LONGBLOB\ [N]\lbpki_glue\ LONGBLOB\ [N]\lself_id\ BIGINT\ [FK,U]\lbsc_id\ BIGINT\ [FK]\l}"];
 	node8 [label="{child_cert\n|child_cert_id\ SERIAL\ [PK]\lcert\ LONGBLOB\lpublished\ DATETIME\ [N]\lski\ TINYBLOB\lchild_id\ BIGINT\ [FK]\lca_detail_id\ BIGINT\ [FK]\l}"];
 	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\ [N]\lcert\ LONGBLOB\ [N]\lroa\ LONGBLOB\ [N]\lpublished\ DATETIME\ [N]\lself_id\ BIGINT\ [FK]\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}"];
 	node2 -> node7 [arrowtail=none, arrowhead=crow];
 	node2 -> node4 [arrowtail=none, arrowhead=crow];
diff --git a/rpkid/doc/rpkid.eps b/rpkid/doc/rpkid.eps
index cf3e1fbd..46115022 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 645 1688
+%%BoundingBox: 36 36 654 1746
 %%EndComments
 save
 %%BeginProlog
@@ -178,1058 +178,1058 @@ def
 %%EndSetup
 setupLatin1
 %%Page: 1 1
-%%PageBoundingBox: 36 36 645 1688
+%%PageBoundingBox: 36 36 654 1746
 %%PageOrientation: Portrait
 0 0 1 beginpage
 gsave
-36 36 609 1652 boxprim clip newpath
+36 36 618 1710 boxprim clip newpath
 1 1 set_scale 0 rotate 40 41 translate
 % node1
 gsave
 0 0 1 nodecolor
-newpath 264 1499 moveto
-264 1643 lineto
-438 1643 lineto
-438 1499 lineto
+newpath 269.3 1550.8 moveto
+269.3 1701.2 lineto
+444.7 1701.2 lineto
+444.7 1550.8 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 264 1499 moveto
-264 1643 lineto
-438 1643 lineto
-438 1499 lineto
+newpath 269.3 1550.8 moveto
+269.3 1701.2 lineto
+444.7 1701.2 lineto
+444.7 1550.8 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-341 1626.4 moveto 20 (self) alignedtext
+346.89 1684.6 moveto 20.21 (self) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 264 1619 moveto
-438 1619 lineto
+newpath 269.3 1676.4 moveto
+444.7 1676.4 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1602.4 moveto 119 (self_id SERIAL [PK]) alignedtext
+277.3 1659.8 moveto 121.3 (self_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1586.4 moveto 156 (self_handle VARCHAR [U]) alignedtext
+277.3 1643 moveto 159.39 (self_handle VARCHAR [U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1570.4 moveto 119 (use_hsm BOOLEAN) alignedtext
+277.3 1626.2 moveto 119.36 (use_hsm BOOLEAN) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1554.4 moveto 136 (crl_interval BIGINT [N]) alignedtext
+277.3 1609.4 moveto 138.38 (crl_interval BIGINT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1538.4 moveto 150 (regen_margin BIGINT [N]) alignedtext
+277.3 1592.6 moveto 151.6 (regen_margin BIGINT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1522.4 moveto 155 (bpki_cert LONGBLOB [N]) alignedtext
+277.3 1575.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-272 1506.4 moveto 158 (bpki_glue LONGBLOB [N]) alignedtext
+277.3 1559 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext
 grestore
 % node2
 gsave
 0 0 1 nodecolor
-newpath 116.5 1301 moveto
-116.5 1461 lineto
-323.5 1461 lineto
-323.5 1301 lineto
+newpath 119.2 1346.4 moveto
+119.2 1513.6 lineto
+328.8 1513.6 lineto
+328.8 1346.4 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 116.5 1301 moveto
-116.5 1461 lineto
-323.5 1461 lineto
-323.5 1301 lineto
+newpath 119.2 1346.4 moveto
+119.2 1513.6 lineto
+328.8 1513.6 lineto
+328.8 1346.4 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-210 1444.4 moveto 20 (bsc) alignedtext
+214.67 1497 moveto 18.66 (bsc) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 116.5 1437 moveto
-323.5 1437 lineto
+newpath 119.2 1488.8 moveto
+328.8 1488.8 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1420.4 moveto 119 (bsc_id SERIAL [PK]) alignedtext
+127.2 1472.2 moveto 119.75 (bsc_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1404.4 moveto 156 (bsc_handle VARCHAR [U]) alignedtext
+127.2 1455.4 moveto 157.84 (bsc_handle VARCHAR [U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1388.4 moveto 185 (private_key_id LONGBLOB [N]) alignedtext
+127.2 1438.6 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1372.4 moveto 190 (pkcs10_request LONGBLOB [N]) alignedtext
+127.2 1421.8 moveto 189.72 (pkcs10_request LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1356.4 moveto 118 (hash_alg ENUM [N]) alignedtext
+127.2 1405 moveto 117.4 (hash_alg ENUM [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1340.4 moveto 169 (signing_cert LONGBLOB [N]) alignedtext
+127.2 1388.2 moveto 171.84 (signing_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1324.4 moveto 191 (signing_cert_crl LONGBLOB [N]) alignedtext
+127.2 1371.4 moveto 193.6 (signing_cert_crl LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-124.5 1308.4 moveto 132 (self_id BIGINT [FK,U]) alignedtext
+127.2 1354.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
 grestore
 % node1->node2
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 301.29 1498.9 moveto
-294.74 1489.4 287.96 1479.57 281.25 1469.84 curveto
+newpath 305.96 1550.78 moveto
+299.61 1541.43 293.07 1531.79 286.57 1522.21 curveto
 stroke
 0 0 0 edgecolor
-newpath 281.05 1469.54 moveto
-279.08 1458.76 lineto
-278.21 1465.43 lineto
-275.37 1461.31 lineto
-275.37 1461.31 lineto
-275.37 1461.31 lineto
-278.21 1465.43 lineto
-271.67 1463.87 lineto
-281.05 1469.54 lineto
+newpath 286.5 1522.11 moveto
+284.61 1511.31 lineto
+283.69 1517.97 lineto
+280.89 1513.83 lineto
+280.89 1513.83 lineto
+280.89 1513.83 lineto
+283.69 1517.97 lineto
+277.16 1516.36 lineto
+286.5 1522.11 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 281.05 1469.54 moveto
-279.08 1458.76 lineto
-278.21 1465.43 lineto
-275.37 1461.31 lineto
-275.37 1461.31 lineto
-275.37 1461.31 lineto
-278.21 1465.43 lineto
-271.67 1463.87 lineto
-281.05 1469.54 lineto
+newpath 286.5 1522.11 moveto
+284.61 1511.31 lineto
+283.69 1517.97 lineto
+280.89 1513.83 lineto
+280.89 1513.83 lineto
+280.89 1513.83 lineto
+283.69 1517.97 lineto
+277.16 1516.36 lineto
+286.5 1522.11 lineto
 closepath stroke
 grestore
 % node3
 gsave
 0 0 1 nodecolor
-newpath 233.5 1119 moveto
-233.5 1263 lineto
-442.5 1263 lineto
-442.5 1119 lineto
+newpath 238.03 1158.8 moveto
+238.03 1309.2 lineto
+449.97 1309.2 lineto
+449.97 1158.8 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 233.5 1119 moveto
-233.5 1263 lineto
-442.5 1263 lineto
-442.5 1119 lineto
+newpath 238.03 1158.8 moveto
+238.03 1309.2 lineto
+449.97 1309.2 lineto
+449.97 1158.8 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-309 1246.4 moveto 58 (repository) alignedtext
+315.62 1292.6 moveto 56.76 (repository) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 233.5 1239 moveto
-442.5 1239 lineto
+newpath 238.03 1284.4 moveto
+449.97 1284.4 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1222.4 moveto 156 (repository_id SERIAL [PK]) alignedtext
+246.03 1267.8 moveto 157.85 (repository_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1206.4 moveto 193 (repository_handle VARCHAR [U]) alignedtext
+246.03 1251 moveto 195.95 (repository_handle VARCHAR [U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1190.4 moveto 156 (peer_contact_uri TEXT [N]) alignedtext
+246.03 1234.2 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1174.4 moveto 155 (bpki_cert LONGBLOB [N]) alignedtext
+246.03 1217.4 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1158.4 moveto 158 (bpki_glue LONGBLOB [N]) alignedtext
+246.03 1200.6 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1142.4 moveto 118 (bsc_id BIGINT [FK]) alignedtext
+246.03 1183.8 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-241.5 1126.4 moveto 132 (self_id BIGINT [FK,U]) alignedtext
+246.03 1167 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
 grestore
 % node1->node3
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 348.52 1498.63 moveto
-346.32 1434.32 343.11 1340.35 340.81 1273.22 curveto
+newpath 354.49 1550.42 moveto
+352.3 1484.39 349.13 1388.6 346.84 1319.74 curveto
 stroke
 0 0 0 edgecolor
-newpath 340.81 1273.09 moveto
-344.96 1262.95 lineto
-340.64 1268.1 lineto
-340.47 1263.1 lineto
-340.47 1263.1 lineto
-340.47 1263.1 lineto
-340.64 1268.1 lineto
-335.97 1263.25 lineto
-340.81 1273.09 lineto
+newpath 346.83 1319.34 moveto
+351 1309.2 lineto
+346.66 1314.35 lineto
+346.5 1309.35 lineto
+346.5 1309.35 lineto
+346.5 1309.35 lineto
+346.66 1314.35 lineto
+342 1309.5 lineto
+346.83 1319.34 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 340.81 1273.09 moveto
-344.96 1262.95 lineto
-340.64 1268.1 lineto
-340.47 1263.1 lineto
-340.47 1263.1 lineto
-340.47 1263.1 lineto
-340.64 1268.1 lineto
-335.97 1263.25 lineto
-340.81 1273.09 lineto
+newpath 346.83 1319.34 moveto
+351 1309.2 lineto
+346.66 1314.35 lineto
+346.5 1309.35 lineto
+346.5 1309.35 lineto
+346.5 1309.35 lineto
+346.66 1314.35 lineto
+342 1309.5 lineto
+346.83 1319.34 lineto
 closepath stroke
 grestore
 % node4
 gsave
 0 0 1 nodecolor
-newpath 230.5 841 moveto
-230.5 1081 lineto
-437.5 1081 lineto
-437.5 841 lineto
+newpath 235.57 870.4 moveto
+235.57 1121.6 lineto
+444.43 1121.6 lineto
+444.43 870.4 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 230.5 841 moveto
-230.5 1081 lineto
-437.5 1081 lineto
-437.5 841 lineto
+newpath 235.57 870.4 moveto
+235.57 1121.6 lineto
+444.43 1121.6 lineto
+444.43 870.4 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-316 1064.4 moveto 36 (parent) alignedtext
+322.51 1105 moveto 34.98 (parent) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 230.5 1057 moveto
-437.5 1057 lineto
+newpath 235.57 1096.8 moveto
+444.43 1096.8 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 1040.4 moveto 135 (parent_id SERIAL [PK]) alignedtext
+243.57 1080.2 moveto 136.07 (parent_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 1024.4 moveto 172 (parent_handle VARCHAR [U]) alignedtext
+243.57 1063.4 moveto 174.16 (parent_handle VARCHAR [U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 1008.4 moveto 184 (bpki_cms_cert LONGBLOB [N]) alignedtext
+243.57 1046.6 moveto 185.05 (bpki_cms_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 992.4 moveto 187 (bpki_cms_glue LONGBLOB [N]) alignedtext
+243.57 1029.8 moveto 188.18 (bpki_cms_glue LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 976.4 moveto 189 (bpki_https_cert LONGBLOB [N]) alignedtext
+243.57 1013 moveto 189.73 (bpki_https_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 960.4 moveto 191 (bpki_https_glue LONGBLOB [N]) alignedtext
+243.57 996.2 moveto 192.85 (bpki_https_glue LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 944.4 moveto 156 (peer_contact_uri TEXT [N]) alignedtext
+243.57 979.4 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 928.4 moveto 109 (sia_base TEXT [N]) alignedtext
+243.57 962.6 moveto 109.62 (sia_base TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 912.4 moveto 135 (sender_name TEXT [N]) alignedtext
+243.57 945.8 moveto 136.05 (sender_name TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 896.4 moveto 147 (recipient_name TEXT [N]) alignedtext
+243.57 929 moveto 148.49 (recipient_name TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 880.4 moveto 132 (self_id BIGINT [FK,U]) alignedtext
+243.57 912.2 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 864.4 moveto 118 (bsc_id BIGINT [FK]) alignedtext
+243.57 895.4 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-238.5 848.4 moveto 155 (repository_id BIGINT [FK]) alignedtext
+243.57 878.6 moveto 156.29 (repository_id BIGINT [FK]) alignedtext
 grestore
 % node1->node4
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 390.51 1498.76 moveto
-434.65 1408.32 494.54 1249.29 451 1118 curveto
-447.87 1108.56 443.93 1099.23 439.4 1090.11 curveto
+newpath 397.72 1550.58 moveto
+442.73 1457.02 503.36 1293.32 459 1158 curveto
+456.01 1148.89 452.3 1139.88 448.05 1131.04 curveto
 stroke
 0 0 0 edgecolor
-newpath 439.31 1089.92 moveto
-438.68 1078.98 lineto
-437 1085.49 lineto
-434.69 1081.05 lineto
-434.69 1081.05 lineto
-434.69 1081.05 lineto
-437 1085.49 lineto
-430.69 1083.13 lineto
-439.31 1089.92 lineto
+newpath 447.94 1130.82 moveto
+447.45 1119.86 lineto
+445.68 1126.35 lineto
+443.43 1121.89 lineto
+443.43 1121.89 lineto
+443.43 1121.89 lineto
+445.68 1126.35 lineto
+439.41 1123.92 lineto
+447.94 1130.82 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 439.31 1089.92 moveto
-438.68 1078.98 lineto
-437 1085.49 lineto
-434.69 1081.05 lineto
-434.69 1081.05 lineto
-434.69 1081.05 lineto
-437 1085.49 lineto
-430.69 1083.13 lineto
-439.31 1089.92 lineto
+newpath 447.94 1130.82 moveto
+447.45 1119.86 lineto
+445.68 1126.35 lineto
+443.43 1121.89 lineto
+443.43 1121.89 lineto
+443.43 1121.89 lineto
+445.68 1126.35 lineto
+439.41 1123.92 lineto
+447.94 1130.82 lineto
 closepath stroke
 grestore
 % node7
 gsave
 0 0 1 nodecolor
-newpath -.5 1127 moveto
--.5 1255 lineto
-178.5 1255 lineto
-178.5 1127 lineto
+newpath -.59 1167.2 moveto
+-.59 1300.8 lineto
+182.59 1300.8 lineto
+182.59 1167.2 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath -.5 1127 moveto
--.5 1255 lineto
-178.5 1255 lineto
-178.5 1127 lineto
+newpath -.59 1167.2 moveto
+-.59 1300.8 lineto
+182.59 1300.8 lineto
+182.59 1167.2 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-75 1238.4 moveto 28 (child) alignedtext
+77 1284.2 moveto 28 (child) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath -.5 1231 moveto
-178.5 1231 lineto
+newpath -.59 1276 moveto
+182.59 1276 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1214.4 moveto 127 (child_id SERIAL [PK]) alignedtext
+7.41 1259.4 moveto 129.09 (child_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1198.4 moveto 163 (child_handle VARCHAR [U]) alignedtext
+7.41 1242.6 moveto 167.18 (child_handle VARCHAR [U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1182.4 moveto 155 (bpki_cert LONGBLOB [N]) alignedtext
+7.41 1225.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1166.4 moveto 158 (bpki_glue LONGBLOB [N]) alignedtext
+7.41 1209 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1150.4 moveto 132 (self_id BIGINT [FK,U]) alignedtext
+7.41 1192.2 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-7.5 1134.4 moveto 118 (bsc_id BIGINT [FK]) alignedtext
+7.41 1175.4 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext
 grestore
 % node1->node7
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 263.71 1555.35 moveto
-209.6 1540.79 143.8 1513.27 108 1462 curveto
-68.18 1404.97 67.93 1323.72 74.88 1265.08 curveto
+newpath 269.12 1609.93 moveto
+213.92 1594.94 146.5 1566.62 110 1514 curveto
+69.25 1455.24 68.98 1371.83 76.16 1311.35 curveto
 stroke
 0 0 0 edgecolor
-newpath 74.88 1265.05 moveto
-80.61 1255.7 lineto
-75.52 1260.09 lineto
-76.15 1255.13 lineto
-76.15 1255.13 lineto
-76.15 1255.13 lineto
-75.52 1260.09 lineto
-71.69 1254.56 lineto
-74.88 1265.05 lineto
+newpath 76.21 1311.01 moveto
+81.94 1301.66 lineto
+76.84 1306.05 lineto
+77.48 1301.09 lineto
+77.48 1301.09 lineto
+77.48 1301.09 lineto
+76.84 1306.05 lineto
+73.02 1300.52 lineto
+76.21 1311.01 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 74.88 1265.05 moveto
-80.61 1255.7 lineto
-75.52 1260.09 lineto
-76.15 1255.13 lineto
-76.15 1255.13 lineto
-76.15 1255.13 lineto
-75.52 1260.09 lineto
-71.69 1254.56 lineto
-74.88 1265.05 lineto
+newpath 76.21 1311.01 moveto
+81.94 1301.66 lineto
+76.84 1306.05 lineto
+77.48 1301.09 lineto
+77.48 1301.09 lineto
+77.48 1301.09 lineto
+76.84 1306.05 lineto
+73.02 1300.52 lineto
+76.21 1311.01 lineto
 closepath stroke
 grestore
 % node10
 gsave
 0 0 1 nodecolor
-newpath 425 151 moveto
-425 295 lineto
-591 295 lineto
-591 151 lineto
+newpath 431.8 154.8 moveto
+431.8 305.2 lineto
+600.2 305.2 lineto
+600.2 154.8 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 425 151 moveto
-425 295 lineto
-591 295 lineto
-591 151 lineto
+newpath 431.8 154.8 moveto
+431.8 305.2 lineto
+600.2 305.2 lineto
+600.2 154.8 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-498.5 278.4 moveto 19 (roa) alignedtext
+507.06 288.6 moveto 17.88 (roa) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 425 271 moveto
-591 271 lineto
+newpath 431.8 280.4 moveto
+600.2 280.4 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 254.4 moveto 118 (roa_id SERIAL [PK]) alignedtext
+439.8 263.8 moveto 118.97 (roa_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 238.4 moveto 92 (asn BIGINT [N]) alignedtext
+439.8 247 moveto 69.58 (asn BIGINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 222.4 moveto 123 (cert LONGBLOB [N]) alignedtext
+439.8 230.2 moveto 100.69 (cert LONGBLOB) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 206.4 moveto 121 (roa LONGBLOB [N]) alignedtext
+439.8 213.4 moveto 97.58 (roa LONGBLOB) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 190.4 moveto 150 (published DATETIME [N]) alignedtext
+439.8 196.6 moveto 152.4 (published DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 174.4 moveto 118 (self_id BIGINT [FK]) alignedtext
+439.8 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-433 158.4 moveto 148 (ca_detail_id BIGINT [FK]) alignedtext
+439.8 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
 grestore
 % node1->node10
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 423.24 1498.71 moveto
-432.23 1487.09 440.53 1474.69 447 1462 curveto
-503.1 1352.03 508 1314.46 508 1191 curveto
-508 1191 508 1191 508 715 curveto
-508 570.84 508 402.91 508 305.22 curveto
+newpath 431.55 1550.76 moveto
+440.44 1539.1 448.61 1526.69 455 1514 curveto
+512.3 1400.26 516 1361.36 516 1234 curveto
+516 1234 516 1234 516 741 curveto
+516 591.33 516 417.01 516 315.52 curveto
 stroke
 0 0 0 edgecolor
-newpath 508 305.11 moveto
-512.5 295.11 lineto
-508 300.11 lineto
-508 295.11 lineto
-508 295.11 lineto
-508 295.11 lineto
-508 300.11 lineto
-503.5 295.11 lineto
-508 305.11 lineto
+newpath 516 315.33 moveto
+520.5 305.33 lineto
+516 310.33 lineto
+516 305.33 lineto
+516 305.33 lineto
+516 305.33 lineto
+516 310.33 lineto
+511.5 305.33 lineto
+516 315.33 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 508 305.11 moveto
-512.5 295.11 lineto
-508 300.11 lineto
-508 295.11 lineto
-508 295.11 lineto
-508 295.11 lineto
-508 300.11 lineto
-503.5 295.11 lineto
-508 305.11 lineto
+newpath 516 315.33 moveto
+520.5 305.33 lineto
+516 310.33 lineto
+516 305.33 lineto
+516 305.33 lineto
+516 305.33 lineto
+516 310.33 lineto
+511.5 305.33 lineto
+516 315.33 lineto
 closepath stroke
 grestore
 % node2->node3
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 269.7 1300.97 moveto
-275.68 1291.35 281.79 1281.51 287.78 1271.87 curveto
+newpath 275.24 1346.31 moveto
+280.99 1336.91 286.86 1327.33 292.62 1317.93 curveto
 stroke
 0 0 0 edgecolor
-newpath 287.96 1271.58 moveto
-297.06 1265.45 lineto
-290.6 1267.33 lineto
-293.23 1263.08 lineto
-293.23 1263.08 lineto
-293.23 1263.08 lineto
-290.6 1267.33 lineto
-289.41 1260.71 lineto
-287.96 1271.58 lineto
+newpath 292.64 1317.88 moveto
+301.7 1311.7 lineto
+295.26 1313.62 lineto
+297.87 1309.35 lineto
+297.87 1309.35 lineto
+297.87 1309.35 lineto
+295.26 1313.62 lineto
+294.03 1307 lineto
+292.64 1317.88 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 287.96 1271.58 moveto
-297.06 1265.45 lineto
-290.6 1267.33 lineto
-293.23 1263.08 lineto
-293.23 1263.08 lineto
-293.23 1263.08 lineto
-290.6 1267.33 lineto
-289.41 1260.71 lineto
-287.96 1271.58 lineto
+newpath 292.64 1317.88 moveto
+301.7 1311.7 lineto
+295.26 1313.62 lineto
+297.87 1309.35 lineto
+297.87 1309.35 lineto
+297.87 1309.35 lineto
+295.26 1313.62 lineto
+294.03 1307 lineto
+292.64 1317.88 lineto
 closepath stroke
 grestore
 % node2->node4
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 209.66 1300.76 moveto
-205.66 1247.62 205.88 1177.09 225 1118 curveto
-228.03 1108.65 231.81 1099.36 236.14 1090.24 curveto
+newpath 213.3 1346.15 moveto
+209.25 1291.32 209.54 1218.84 229 1158 curveto
+231.89 1148.96 235.46 1139.97 239.54 1131.13 curveto
 stroke
 0 0 0 edgecolor
-newpath 236.19 1090.14 moveto
-244.67 1083.19 lineto
-238.42 1085.66 lineto
-240.64 1081.18 lineto
-240.64 1081.18 lineto
-240.64 1081.18 lineto
-238.42 1085.66 lineto
-236.61 1079.18 lineto
-236.19 1090.14 lineto
+newpath 239.61 1130.98 moveto
+248.01 1123.93 lineto
+241.79 1126.48 lineto
+243.96 1121.98 lineto
+243.96 1121.98 lineto
+243.96 1121.98 lineto
+241.79 1126.48 lineto
+239.91 1120.02 lineto
+239.61 1130.98 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 236.19 1090.14 moveto
-244.67 1083.19 lineto
-238.42 1085.66 lineto
-240.64 1081.18 lineto
-240.64 1081.18 lineto
-240.64 1081.18 lineto
-238.42 1085.66 lineto
-236.61 1079.18 lineto
-236.19 1090.14 lineto
+newpath 239.61 1130.98 moveto
+248.01 1123.93 lineto
+241.79 1126.48 lineto
+243.96 1121.98 lineto
+243.96 1121.98 lineto
+243.96 1121.98 lineto
+241.79 1126.48 lineto
+239.91 1120.02 lineto
+239.61 1130.98 lineto
 closepath stroke
 grestore
 % node2->node7
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 164.82 1300.97 moveto
-156.25 1288.53 147.42 1275.74 138.97 1263.47 curveto
+newpath 167.21 1346.31 moveto
+158.83 1333.97 150.25 1321.32 142 1309.16 curveto
 stroke
 0 0 0 edgecolor
-newpath 138.86 1263.31 moveto
-136.89 1252.53 lineto
-136.02 1259.2 lineto
-133.18 1255.08 lineto
-133.18 1255.08 lineto
-133.18 1255.08 lineto
-136.02 1259.2 lineto
-129.48 1257.63 lineto
-138.86 1263.31 lineto
+newpath 141.97 1309.11 moveto
+140.07 1298.31 lineto
+139.16 1304.97 lineto
+136.35 1300.83 lineto
+136.35 1300.83 lineto
+136.35 1300.83 lineto
+139.16 1304.97 lineto
+132.63 1303.36 lineto
+141.97 1309.11 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 138.86 1263.31 moveto
-136.89 1252.53 lineto
-136.02 1259.2 lineto
-133.18 1255.08 lineto
-133.18 1255.08 lineto
-133.18 1255.08 lineto
-136.02 1259.2 lineto
-129.48 1257.63 lineto
-138.86 1263.31 lineto
+newpath 141.97 1309.11 moveto
+140.07 1298.31 lineto
+139.16 1304.97 lineto
+136.35 1300.83 lineto
+136.35 1300.83 lineto
+136.35 1300.83 lineto
+139.16 1304.97 lineto
+132.63 1303.36 lineto
+141.97 1309.11 lineto
 closepath stroke
 grestore
 % node3->node4
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 336.75 1118.86 moveto
-336.59 1110.05 336.43 1100.86 336.27 1091.52 curveto
+newpath 342.73 1158.7 moveto
+342.59 1149.99 342.44 1140.93 342.28 1131.73 curveto
 stroke
 0 0 0 edgecolor
-newpath 336.27 1091.35 moveto
-340.59 1081.28 lineto
-336.18 1086.35 lineto
-336.09 1081.35 lineto
-336.09 1081.35 lineto
-336.09 1081.35 lineto
-336.18 1086.35 lineto
-331.59 1081.43 lineto
-336.27 1091.35 lineto
+newpath 342.28 1131.71 moveto
+346.61 1121.63 lineto
+342.2 1126.71 lineto
+342.11 1121.71 lineto
+342.11 1121.71 lineto
+342.11 1121.71 lineto
+342.2 1126.71 lineto
+337.61 1121.78 lineto
+342.28 1131.71 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 336.27 1091.35 moveto
-340.59 1081.28 lineto
-336.18 1086.35 lineto
-336.09 1081.35 lineto
-336.09 1081.35 lineto
-336.09 1081.35 lineto
-336.18 1086.35 lineto
-331.59 1081.43 lineto
-336.27 1091.35 lineto
+newpath 342.28 1131.71 moveto
+346.61 1121.63 lineto
+342.2 1126.71 lineto
+342.11 1121.71 lineto
+342.11 1121.71 lineto
+342.11 1121.71 lineto
+342.2 1126.71 lineto
+337.61 1121.78 lineto
+342.28 1131.71 lineto
 closepath stroke
 grestore
 % node5
 gsave
 0 0 1 nodecolor
-newpath 205 627 moveto
-205 803 lineto
-439 803 lineto
-439 627 lineto
+newpath 209.21 649 moveto
+209.21 833 lineto
+446.79 833 lineto
+446.79 649 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 205 627 moveto
-205 803 lineto
-439 803 lineto
-439 627 lineto
+newpath 209.21 649 moveto
+209.21 833 lineto
+446.79 833 lineto
+446.79 649 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-315.5 786.4 moveto 13 (ca) alignedtext
+321.79 816.4 moveto 12.43 (ca) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 205 779 moveto
-439 779 lineto
+newpath 209.21 808.2 moveto
+446.79 808.2 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 762.4 moveto 112 (ca_id SERIAL [PK]) alignedtext
+217.21 791.6 moveto 113.52 (ca_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 746.4 moveto 111 (last_crl_sn BIGINT) alignedtext
+217.21 774.8 moveto 111.57 (last_crl_sn BIGINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 730.4 moveto 143 (last_manifest_sn BIGINT) alignedtext
+217.21 758 moveto 145.01 (last_manifest_sn BIGINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 714.4 moveto 218 (next_manifest_update DATETIME [N]) alignedtext
+217.21 741.2 moveto 221.59 (next_manifest_update DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 698.4 moveto 186 (next_crl_update DATETIME [N]) alignedtext
+217.21 724.4 moveto 188.15 (next_crl_update DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 682.4 moveto 131 (last_issued_sn BIGINT) alignedtext
+217.21 707.6 moveto 131.8 (last_issued_sn BIGINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 666.4 moveto 99 (sia_uri TEXT [N]) alignedtext
+217.21 690.8 moveto 100.29 (sia_uri TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 650.4 moveto 185 (parent_resource_class TEXT [N]) alignedtext
+217.21 674 moveto 185.79 (parent_resource_class TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-213 634.4 moveto 148 (parent_id BIGINT [FK,N]) alignedtext
+217.21 657.2 moveto 148.11 (parent_id BIGINT [FK,N]) alignedtext
 grestore
 % node4->node5
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 328.14 840.88 moveto
-327.69 831.67 327.24 822.43 326.8 813.38 curveto
+newpath 334.09 870.37 moveto
+333.66 861.23 333.23 852.09 332.81 843.11 curveto
 stroke
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 330.29 813.06 moveto
-326.3 803.25 lineto
-323.3 813.41 lineto
+newpath 336.3 842.89 moveto
+332.33 833.07 lineto
+329.31 843.22 lineto
 closepath stroke
 grestore
 % node6
 gsave
 0 0 1 nodecolor
-newpath 188.5 333 moveto
-188.5 589 lineto
-443.5 589 lineto
-443.5 333 lineto
+newpath 193.09 343 moveto
+193.09 611 lineto
+450.91 611 lineto
+450.91 343 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 188.5 333 moveto
-188.5 589 lineto
-443.5 589 lineto
-443.5 333 lineto
+newpath 193.09 343 moveto
+193.09 611 lineto
+450.91 611 lineto
+450.91 343 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-290.5 572.4 moveto 51 (ca_detail) alignedtext
+296.73 594.4 moveto 50.53 (ca_detail) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 188.5 565 moveto
-443.5 565 lineto
+newpath 193.09 586.2 moveto
+450.91 586.2 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 548.4 moveto 149 (ca_detail_id SERIAL [PK]) alignedtext
+201.09 569.6 moveto 151.62 (ca_detail_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 532.4 moveto 164 (public_key LONGBLOB [N]) alignedtext
+201.09 552.8 moveto 164.84 (public_key LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 516.4 moveto 185 (private_key_id LONGBLOB [N]) alignedtext
+201.09 536 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 500.4 moveto 153 (latest_crl LONGBLOB [N]) alignedtext
+201.09 519.2 moveto 153.94 (latest_crl LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 484.4 moveto 171 (crl_published DATETIME [N]) alignedtext
+201.09 502.4 moveto 174.16 (crl_published DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 468.4 moveto 178 (latest_ca_cert LONGBLOB [N]) alignedtext
+201.09 485.6 moveto 179.59 (latest_ca_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 452.4 moveto 239 (manifest_private_key_id LONGBLOB [N]) alignedtext
+201.09 468.8 moveto 241.82 (manifest_private_key_id LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 436.4 moveto 218 (manifest_public_key LONGBLOB [N]) alignedtext
+201.09 452 moveto 220.05 (manifest_public_key LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 420.4 moveto 213 (latest_manifest_cert LONGBLOB [N]) alignedtext
+201.09 435.2 moveto 215.36 (latest_manifest_cert LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 404.4 moveto 185 (latest_manifest LONGBLOB [N]) alignedtext
+201.09 418.4 moveto 187.38 (latest_manifest LONGBLOB [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 388.4 moveto 204 (manifest_published DATETIME [N]) alignedtext
+201.09 401.6 moveto 207.6 (manifest_published DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 372.4 moveto 71 (state ENUM) alignedtext
+201.09 384.8 moveto 70.37 (state ENUM) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 356.4 moveto 124 (ca_cert_uri TEXT [N]) alignedtext
+201.09 368 moveto 125.15 (ca_cert_uri TEXT [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-196.5 340.4 moveto 111 (ca_id BIGINT [FK]) alignedtext
+201.09 351.2 moveto 111.95 (ca_id BIGINT [FK]) alignedtext
 grestore
 % node5->node6
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 319.92 626.88 moveto
-319.71 617.93 319.49 608.7 319.27 599.39 curveto
+newpath 325.9 648.67 moveto
+325.7 639.71 325.49 630.49 325.28 621.19 curveto
 stroke
 0 0 0 edgecolor
-newpath 319.27 599.26 moveto
-323.53 589.16 lineto
-319.15 594.26 lineto
-319.03 589.27 lineto
-319.03 589.27 lineto
-319.03 589.27 lineto
-319.15 594.26 lineto
-314.53 589.37 lineto
-319.27 599.26 lineto
+newpath 325.27 621.06 moveto
+329.55 610.96 lineto
+325.16 616.07 lineto
+325.05 611.07 lineto
+325.05 611.07 lineto
+325.05 611.07 lineto
+325.16 616.07 lineto
+320.55 611.17 lineto
+325.27 621.06 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 319.27 599.26 moveto
-323.53 589.16 lineto
-319.15 594.26 lineto
-319.03 589.27 lineto
-319.03 589.27 lineto
-319.03 589.27 lineto
-319.15 594.26 lineto
-314.53 589.37 lineto
-319.27 599.26 lineto
+newpath 325.27 621.06 moveto
+329.55 610.96 lineto
+325.16 616.07 lineto
+325.05 611.07 lineto
+325.05 611.07 lineto
+325.05 611.07 lineto
+325.16 616.07 lineto
+320.55 611.17 lineto
+325.27 621.06 lineto
 closepath stroke
 grestore
 % node8
 gsave
 0 0 1 nodecolor
-newpath 24 159 moveto
-24 287 lineto
-194 287 lineto
-194 159 lineto
+newpath 26.47 163.2 moveto
+26.47 296.8 lineto
+199.53 296.8 lineto
+199.53 163.2 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 24 159 moveto
-24 287 lineto
-194 287 lineto
-194 159 lineto
+newpath 26.47 163.2 moveto
+26.47 296.8 lineto
+199.53 296.8 lineto
+199.53 163.2 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-81 270.4 moveto 56 (child_cert) alignedtext
+85.01 280.2 moveto 55.98 (child_cert) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 24 263 moveto
-194 263 lineto
+newpath 26.47 272 moveto
+199.53 272 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 246.4 moveto 154 (child_cert_id SERIAL [PK]) alignedtext
+34.47 255.4 moveto 157.07 (child_cert_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 230.4 moveto 100 (cert LONGBLOB) alignedtext
+34.47 238.6 moveto 100.69 (cert LONGBLOB) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 214.4 moveto 150 (published DATETIME [N]) alignedtext
+34.47 221.8 moveto 152.4 (published DATETIME [N]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 198.4 moveto 90 (ski TINYBLOB) alignedtext
+34.47 205 moveto 90.59 (ski TINYBLOB) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 182.4 moveto 125 (child_id BIGINT [FK]) alignedtext
+34.47 188.2 moveto 127.52 (child_id BIGINT [FK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-32 166.4 moveto 148 (ca_detail_id BIGINT [FK]) alignedtext
+34.47 171.4 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
 grestore
 % node6->node8
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 204.62 332.94 moveto
-193.32 319.95 182.14 307.09 171.63 295.01 curveto
+newpath 208.33 342.66 moveto
+197.33 329.66 186.47 316.83 176.24 304.74 curveto
 stroke
 0 0 0 edgecolor
-newpath 171.39 294.74 moveto
-168.23 284.24 lineto
-168.11 290.96 lineto
-164.83 287.19 lineto
-164.83 287.19 lineto
-164.83 287.19 lineto
-168.11 290.96 lineto
-161.43 290.14 lineto
-171.39 294.74 lineto
+newpath 176.07 304.54 moveto
+173.05 294 lineto
+172.84 300.72 lineto
+169.61 296.91 lineto
+169.61 296.91 lineto
+169.61 296.91 lineto
+172.84 300.72 lineto
+166.18 299.81 lineto
+176.07 304.54 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 171.39 294.74 moveto
-168.23 284.24 lineto
-168.11 290.96 lineto
-164.83 287.19 lineto
-164.83 287.19 lineto
-164.83 287.19 lineto
-168.11 290.96 lineto
-161.43 290.14 lineto
-171.39 294.74 lineto
+newpath 176.07 304.54 moveto
+173.05 294 lineto
+172.84 300.72 lineto
+169.61 296.91 lineto
+169.61 296.91 lineto
+169.61 296.91 lineto
+172.84 300.72 lineto
+166.18 299.81 lineto
+176.07 304.54 lineto
 closepath stroke
 grestore
 % node9
 gsave
 0 0 1 nodecolor
-newpath 218.5 167 moveto
-218.5 279 lineto
-407.5 279 lineto
-407.5 167 lineto
+newpath 223.92 171.6 moveto
+223.92 288.4 lineto
+414.08 288.4 lineto
+414.08 171.6 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 218.5 167 moveto
-218.5 279 lineto
-407.5 279 lineto
-407.5 167 lineto
+newpath 223.92 171.6 moveto
+223.92 288.4 lineto
+414.08 288.4 lineto
+414.08 171.6 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-276 262.4 moveto 74 (revoked_cert) alignedtext
+282.46 271.8 moveto 73.07 (revoked_cert) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 218.5 255 moveto
-407.5 255 lineto
+newpath 223.92 263.6 moveto
+414.08 263.6 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-226.5 238.4 moveto 173 (revoked_cert_id SERIAL [PK]) alignedtext
+231.92 247 moveto 174.16 (revoked_cert_id SERIAL [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-226.5 222.4 moveto 81 (serial BIGINT) alignedtext
+231.92 230.2 moveto 81.24 (serial BIGINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-226.5 206.4 moveto 119 (revoked DATETIME) alignedtext
+231.92 213.4 moveto 120.12 (revoked DATETIME) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-226.5 190.4 moveto 113 (expires DATETIME) alignedtext
+231.92 196.6 moveto 115.45 (expires DATETIME) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-226.5 174.4 moveto 148 (ca_detail_id BIGINT [FK]) alignedtext
+231.92 179.8 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext
 grestore
 % node6->node9
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 314.39 332.94 moveto
-314.2 317.86 314.01 302.98 313.84 289.26 curveto
+newpath 320.37 342.66 moveto
+320.18 327.51 320 312.58 319.84 298.79 curveto
 stroke
 0 0 0 edgecolor
-newpath 313.83 289.02 moveto
-318.21 278.96 lineto
-313.77 284.02 lineto
-313.71 279.02 lineto
-313.71 279.02 lineto
-313.71 279.02 lineto
-313.77 284.02 lineto
-309.21 279.08 lineto
-313.83 289.02 lineto
+newpath 319.83 298.49 moveto
+324.21 288.43 lineto
+319.77 293.49 lineto
+319.71 288.49 lineto
+319.71 288.49 lineto
+319.71 288.49 lineto
+319.77 293.49 lineto
+315.21 288.54 lineto
+319.83 298.49 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 313.83 289.02 moveto
-318.21 278.96 lineto
-313.77 284.02 lineto
-313.71 279.02 lineto
-313.71 279.02 lineto
-313.71 279.02 lineto
-313.77 284.02 lineto
-309.21 279.08 lineto
-313.83 289.02 lineto
+newpath 319.83 298.49 moveto
+324.21 288.43 lineto
+319.77 293.49 lineto
+319.71 288.49 lineto
+319.71 288.49 lineto
+319.71 288.49 lineto
+319.77 293.49 lineto
+315.21 288.54 lineto
+319.83 298.49 lineto
 closepath stroke
 grestore
 % node6->node10
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 419.31 332.94 moveto
-427.49 322.8 435.6 312.75 443.4 303.08 curveto
+newpath 427.52 342.66 moveto
+435.36 332.67 443.13 322.78 450.62 313.24 curveto
 stroke
 0 0 0 edgecolor
-newpath 443.6 302.83 moveto
-453.38 297.88 lineto
-446.74 298.94 lineto
-449.87 295.05 lineto
-449.87 295.05 lineto
-449.87 295.05 lineto
-446.74 298.94 lineto
-446.37 292.23 lineto
-443.6 302.83 lineto
+newpath 450.66 313.19 moveto
+460.38 308.1 lineto
+453.75 309.26 lineto
+456.84 305.32 lineto
+456.84 305.32 lineto
+456.84 305.32 lineto
+453.75 309.26 lineto
+453.3 302.54 lineto
+450.66 313.19 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 443.6 302.83 moveto
-453.38 297.88 lineto
-446.74 298.94 lineto
-449.87 295.05 lineto
-449.87 295.05 lineto
-449.87 295.05 lineto
-446.74 298.94 lineto
-446.37 292.23 lineto
-443.6 302.83 lineto
+newpath 450.66 313.19 moveto
+460.38 308.1 lineto
+453.75 309.26 lineto
+456.84 305.32 lineto
+456.84 305.32 lineto
+456.84 305.32 lineto
+453.75 309.26 lineto
+453.3 302.54 lineto
+450.66 313.19 lineto
 closepath stroke
 grestore
 % node7->node8
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 90.33 1126.74 moveto
-93.89 954.13 103.67 481.08 107.46 297.35 curveto
+newpath 92.47 1166.96 moveto
+96.4 987.6 107.14 497.5 111.31 307.09 curveto
 stroke
 0 0 0 edgecolor
-newpath 107.47 297.24 moveto
-112.17 287.33 lineto
-107.57 292.24 lineto
-107.67 287.24 lineto
-107.67 287.24 lineto
-107.67 287.24 lineto
-107.57 292.24 lineto
-103.17 287.15 lineto
-107.47 297.24 lineto
+newpath 111.32 306.88 moveto
+116.03 296.98 lineto
+111.42 301.88 lineto
+111.53 296.88 lineto
+111.53 296.88 lineto
+111.53 296.88 lineto
+111.42 301.88 lineto
+107.04 296.79 lineto
+111.32 306.88 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 107.47 297.24 moveto
-112.17 287.33 lineto
-107.57 292.24 lineto
-107.67 287.24 lineto
-107.67 287.24 lineto
-107.67 287.24 lineto
-107.57 292.24 lineto
-103.17 287.15 lineto
-107.47 297.24 lineto
+newpath 111.32 306.88 moveto
+116.03 296.98 lineto
+111.42 301.88 lineto
+111.53 296.88 lineto
+111.53 296.88 lineto
+111.53 296.88 lineto
+111.42 301.88 lineto
+107.04 296.79 lineto
+111.32 306.88 lineto
 closepath stroke
 grestore
 % node11
 gsave
 0 0 1 nodecolor
-newpath 415 1 moveto
-415 113 lineto
-601 113 lineto
-601 1 lineto
+newpath 421.7 .6 moveto
+421.7 117.4 lineto
+610.3 117.4 lineto
+610.3 .6 lineto
 closepath fill
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 415 1 moveto
-415 113 lineto
-601 113 lineto
-601 1 lineto
+newpath 421.7 .6 moveto
+421.7 117.4 lineto
+610.3 117.4 lineto
+610.3 .6 lineto
 closepath stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-478.5 96.4 moveto 59 (roa_prefix) alignedtext
+486.85 100.8 moveto 58.3 (roa_prefix) alignedtext
 1 setlinewidth
 filled
 0 0 0 nodecolor
-newpath 415 89 moveto
-601 89 lineto
+newpath 421.7 92.6 moveto
+610.3 92.6 lineto
 stroke
 0 0 0 nodecolor
 14 /Times-Roman set_font
-423 72.4 moveto 133 (prefix VARCHAR [PK]) alignedtext
+429.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-423 56.4 moveto 140 (prefixlen TINYINT [PK]) alignedtext
+429.7 59.2 moveto 141.49 (prefixlen TINYINT [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-423 40.4 moveto 170 (max_prefixlen TINYINT [PK]) alignedtext
+429.7 42.4 moveto 172.59 (max_prefixlen TINYINT [PK]) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-423 24.4 moveto 101 (version TINYINT) alignedtext
+429.7 25.6 moveto 101.46 (version TINYINT) alignedtext
 0 0 0 nodecolor
 14 /Times-Roman set_font
-423 8.4 moveto 138 (roa_id BIGINT [PK,FK]) alignedtext
+429.7 8.8 moveto 138.79 (roa_id BIGINT [PK,FK]) alignedtext
 grestore
 % node10->node11
 gsave
 1 setlinewidth
 0 0 0 edgecolor
-newpath 508 150.67 moveto
-508 141.53 508 132.22 508 123.18 curveto
+newpath 516 154.5 moveto
+516 145.56 516 136.47 516 127.64 curveto
 stroke
 0 0 0 edgecolor
-newpath 508 123.11 moveto
-512.5 113.11 lineto
-508 118.11 lineto
-508 113.11 lineto
-508 113.11 lineto
-508 113.11 lineto
-508 118.11 lineto
-503.5 113.11 lineto
-508 123.11 lineto
+newpath 516 127.4 moveto
+520.5 117.4 lineto
+516 122.4 lineto
+516 117.4 lineto
+516 117.4 lineto
+516 117.4 lineto
+516 122.4 lineto
+511.5 117.4 lineto
+516 127.4 lineto
 closepath fill
 1 setlinewidth
 solid
 0 0 0 edgecolor
-newpath 508 123.11 moveto
-512.5 113.11 lineto
-508 118.11 lineto
-508 113.11 lineto
-508 113.11 lineto
-508 113.11 lineto
-508 118.11 lineto
-503.5 113.11 lineto
-508 123.11 lineto
+newpath 516 127.4 moveto
+520.5 117.4 lineto
+516 122.4 lineto
+516 117.4 lineto
+516 117.4 lineto
+516 117.4 lineto
+516 122.4 lineto
+511.5 117.4 lineto
+516 127.4 lineto
 closepath stroke
 grestore
 endpage
diff --git a/rpkid/doc/rpkid.png b/rpkid/doc/rpkid.png
index ead448dc..929882c8 100644
--- a/rpkid/doc/rpkid.png
+++ b/rpkid/doc/rpkid.png