Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 430 insertions, 0 deletions

diff --git a/doc/schemaspy_hubzilla/diagrams/mail.2degrees.dot b/doc/schemaspy_hubzilla/diagrams/mail.2degrees.dot
new file mode 100644
index 000000000..7c5c0ee95
--- /dev/null
+++ b/doc/schemaspy_hubzilla/diagrams/mail.2degrees.dot
@@ -0,0 +1,430 @@
+// dot 2.26.3 on Linux 3.2.0-4-686-pae
+// SchemaSpy rev 590
+digraph "twoDegreesRelationshipsDiagram" {
+  graph [
+    rankdir="RL"
+    bgcolor="#f7f7f7"
+    label="\nGenerated by SchemaSpy"
+    labeljust="l"
+    nodesep="0.18"
+    ranksep="0.46"
+    fontname="Helvetica"
+    fontsize="11"
+  ];
+  node [
+    fontname="Helvetica"
+    fontsize="11"
+    shape="plaintext"
+  ];
+  edge [
+    arrowsize="0.8"
+  ];
+  "abook":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "channel":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "chat":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "chatpresence":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "dreport":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "group_member":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "hubloc":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "hubloc":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "mail":"from_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "mail":"to_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "manage":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "outq":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "outq":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "outq":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot];
+  "photo":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "shares":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "source":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "source":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "vote":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xchan":"xchan_hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xchan":"xchan_hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xchat":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xconfig":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xign":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xlink":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xprof":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xprof":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xprof":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xtag":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xtag":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xtag":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "abook" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">abook</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">685 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="abook.html"
+    tooltip="abook"
+  ];
+  "attach" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">attach</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">105 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="attach.html"
+    tooltip="attach"
+  ];
+  "channel" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">channel</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">12 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">14 &gt;</TD></TR>
+    </TABLE>>
+    URL="channel.html"
+    tooltip="channel"
+  ];
+  "chat" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">chat</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="chat.html"
+    tooltip="chat"
+  ];
+  "chatpresence" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">chatpresence</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 row</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="chatpresence.html"
+    tooltip="chatpresence"
+  ];
+  "dreport" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">dreport</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">8 579 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="dreport.html"
+    tooltip="dreport"
+  ];
+  "event" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">event</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">12 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="event.html"
+    tooltip="event"
+  ];
+  "group_member" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">group_member</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">42 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="group_member.html"
+    tooltip="group_member"
+  ];
+  "groups" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">groups</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">10 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="groups.html"
+    tooltip="groups"
+  ];
+  "hubloc" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">hubloc</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 658 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">14 &gt;</TD></TR>
+    </TABLE>>
+    URL="hubloc.html"
+    tooltip="hubloc"
+  ];
+  "item" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">37 583 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="item.html"
+    tooltip="item"
+  ];
+  "mail" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">mail</TD></TR>
+      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="convid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">convid</TD><TD PORT="convid.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="mail_flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_flags</TD><TD PORT="mail_flags.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="from_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">from_xchan</TD><TD PORT="from_xchan.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="to_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">to_xchan</TD><TD PORT="to_xchan.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="account_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">account_id</TD><TD PORT="account_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="channel_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_id</TD><TD PORT="channel_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="title" COLSPAN="2" ALIGN="LEFT">title</TD><TD PORT="title.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="body" COLSPAN="2" ALIGN="LEFT">body</TD><TD PORT="body.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="sig" COLSPAN="2" ALIGN="LEFT">sig</TD><TD PORT="sig.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="attach" COLSPAN="2" ALIGN="LEFT">attach</TD><TD PORT="attach.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mid</TD><TD PORT="mid.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="parent_mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">parent_mid</TD><TD PORT="parent_mid.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="mail_deleted" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_deleted</TD><TD PORT="mail_deleted.type" ALIGN="LEFT">tinyint[3]</TD></TR>
+      <TR><TD PORT="mail_replied" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_replied</TD><TD PORT="mail_replied.type" ALIGN="LEFT">tinyint[3]</TD></TR>
+      <TR><TD PORT="mail_isreply" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_isreply</TD><TD PORT="mail_isreply.type" ALIGN="LEFT">tinyint[3]</TD></TR>
+      <TR><TD PORT="mail_seen" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_seen</TD><TD PORT="mail_seen.type" ALIGN="LEFT">tinyint[3]</TD></TR>
+      <TR><TD PORT="mail_recalled" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_recalled</TD><TD PORT="mail_recalled.type" ALIGN="LEFT">tinyint[3]</TD></TR>
+      <TR><TD PORT="mail_obscured" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mail_obscured</TD><TD PORT="mail_obscured.type" ALIGN="LEFT">smallint[5]</TD></TR>
+      <TR><TD PORT="created" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD><TD PORT="created.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD PORT="expires" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">expires</TD><TD PORT="expires.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD PORT="conv_guid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">conv_guid</TD><TD PORT="conv_guid.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">39 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
+    </TABLE>>
+    URL="mail.html"
+    tooltip="mail"
+  ];
+  "manage" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">manage</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="manage.html"
+    tooltip="manage"
+  ];
+  "notify" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">notify</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">528 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="notify.html"
+    tooltip="notify"
+  ];
+  "outq" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">outq</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">660 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="outq.html"
+    tooltip="outq"
+  ];
+  "photo" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">photo</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 888 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="photo.html"
+    tooltip="photo"
+  ];
+  "profext" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profext</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="profext.html"
+    tooltip="profext"
+  ];
+  "register" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">register</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="register.html"
+    tooltip="register"
+  ];
+  "shares" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">shares</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="shares.html"
+    tooltip="shares"
+  ];
+  "source" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">source</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="source.html"
+    tooltip="source"
+  ];
+  "term" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">term</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 6</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">8 980 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="term.html"
+    tooltip="term"
+  ];
+  "updates" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">updates</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="updates.html"
+    tooltip="updates"
+  ];
+  "vote" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">vote</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="vote.html"
+    tooltip="vote"
+  ];
+  "xchan" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xchan</TD></TR>
+      <TR><TD PORT="xchan_hash" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">xchan_hash</TD></TR>
+      <TR><TD PORT="xchan_guid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_guid</TD></TR>
+      <TR><TD PORT="xchan_guid_sig" COLSPAN="3" ALIGN="LEFT">xchan_guid_sig</TD></TR>
+      <TR><TD PORT="xchan_pubkey" COLSPAN="3" ALIGN="LEFT">xchan_pubkey</TD></TR>
+      <TR><TD PORT="xchan_photo_mimetype" COLSPAN="3" ALIGN="LEFT">xchan_photo_mimetype</TD></TR>
+      <TR><TD PORT="xchan_photo_l" COLSPAN="3" ALIGN="LEFT">xchan_photo_l</TD></TR>
+      <TR><TD PORT="xchan_photo_m" COLSPAN="3" ALIGN="LEFT">xchan_photo_m</TD></TR>
+      <TR><TD PORT="xchan_photo_s" COLSPAN="3" ALIGN="LEFT">xchan_photo_s</TD></TR>
+      <TR><TD PORT="xchan_addr" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_addr</TD></TR>
+      <TR><TD PORT="xchan_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_url</TD></TR>
+      <TR><TD PORT="xchan_connurl" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_connurl</TD></TR>
+      <TR><TD PORT="xchan_follow" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_follow</TD></TR>
+      <TR><TD PORT="xchan_connpage" COLSPAN="3" ALIGN="LEFT">xchan_connpage</TD></TR>
+      <TR><TD PORT="xchan_name" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_name</TD></TR>
+      <TR><TD PORT="xchan_network" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_network</TD></TR>
+      <TR><TD PORT="xchan_instance_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_instance_url</TD></TR>
+      <TR><TD PORT="xchan_flags" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_flags</TD></TR>
+      <TR><TD PORT="xchan_photo_date" COLSPAN="3" ALIGN="LEFT">xchan_photo_date</TD></TR>
+      <TR><TD PORT="xchan_name_date" COLSPAN="3" ALIGN="LEFT">xchan_name_date</TD></TR>
+      <TR><TD PORT="xchan_hidden" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_hidden</TD></TR>
+      <TR><TD PORT="xchan_orphan" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_orphan</TD></TR>
+      <TR><TD PORT="xchan_censored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_censored</TD></TR>
+      <TR><TD PORT="xchan_selfcensored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_selfcensored</TD></TR>
+      <TR><TD PORT="xchan_system" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_system</TD></TR>
+      <TR><TD PORT="xchan_pubforum" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_pubforum</TD></TR>
+      <TR><TD PORT="xchan_deleted" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_deleted</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 301 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">35 &gt;</TD></TR>
+    </TABLE>>
+    URL="xchan.html"
+    tooltip="xchan"
+  ];
+  "xchat" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xchat</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xchat.html"
+    tooltip="xchat"
+  ];
+  "xconfig" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xconfig</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">8 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xconfig.html"
+    tooltip="xconfig"
+  ];
+  "xign" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xign</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xign.html"
+    tooltip="xign"
+  ];
+  "xlink" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xlink</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 105 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xlink.html"
+    tooltip="xlink"
+  ];
+  "xprof" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xprof</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xprof.html"
+    tooltip="xprof"
+  ];
+  "xtag" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xtag</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xtag.html"
+    tooltip="xtag"
+  ];
+}