Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 468 insertions, 0 deletions

diff --git a/doc/schemaspy_hubzilla/diagrams/likes.implied2degrees.dot b/doc/schemaspy_hubzilla/diagrams/likes.implied2degrees.dot
new file mode 100644
index 000000000..4c1bf49ac
--- /dev/null
+++ b/doc/schemaspy_hubzilla/diagrams/likes.implied2degrees.dot
@@ -0,0 +1,468 @@
+// dot 2.26.3 on Linux 3.2.0-4-686-pae
+// SchemaSpy rev 590
+digraph "impliedTwoDegreesRelationshipsDiagram" {
+  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"
+  ];
+  "attach":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "attach":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "channel":"channel_hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "config":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "conv":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "event":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "notify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "fcontact":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "ffinder":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "group_member":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "group_member":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "groups":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "hubloc":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "hubloc":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "item":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "item_id":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "likes":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
+  "likes":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "mail":"elipses":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
+  "mail":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "mail":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "mail":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "outq":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot];
+  "outq":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "outq":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "photo":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "photo":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profdef":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "profext":"elipses":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
+  "profext":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "profext":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "profile_check":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "register":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "register":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "sign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "sys_perms":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "term":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "term":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "updates":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xchan":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xchan":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xconfig":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "xconfig":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "xign":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xprof":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xprof":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xprof":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xtag":"elipses":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xtag":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "xtag":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "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; 4</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="channel_id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">channel_id</TD></TR>
+      <TR><TD PORT="channel_account_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_account_id</TD></TR>
+      <TR><TD PORT="channel_primary" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_primary</TD></TR>
+      <TR><TD PORT="channel_name" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_name</TD></TR>
+      <TR><TD PORT="channel_address" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_address</TD></TR>
+      <TR><TD PORT="channel_guid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_guid</TD></TR>
+      <TR><TD PORT="channel_guid_sig" COLSPAN="3" ALIGN="LEFT">channel_guid_sig</TD></TR>
+      <TR><TD PORT="channel_hash" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_hash</TD></TR>
+      <TR><TD PORT="channel_timezone" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_timezone</TD></TR>
+      <TR><TD PORT="channel_location" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_location</TD></TR>
+      <TR><TD PORT="channel_theme" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_theme</TD></TR>
+      <TR><TD PORT="channel_startpage" COLSPAN="3" ALIGN="LEFT">channel_startpage</TD></TR>
+      <TR><TD PORT="channel_pubkey" COLSPAN="3" ALIGN="LEFT">channel_pubkey</TD></TR>
+      <TR><TD PORT="channel_prvkey" COLSPAN="3" ALIGN="LEFT">channel_prvkey</TD></TR>
+      <TR><TD PORT="channel_notifyflags" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_notifyflags</TD></TR>
+      <TR><TD PORT="channel_pageflags" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_pageflags</TD></TR>
+      <TR><TD PORT="channel_dirdate" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_dirdate</TD></TR>
+      <TR><TD PORT="channel_lastpost" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_lastpost</TD></TR>
+      <TR><TD PORT="channel_deleted" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_deleted</TD></TR>
+      <TR><TD PORT="channel_max_anon_mail" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_max_anon_mail</TD></TR>
+      <TR><TD PORT="channel_max_friend_req" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_max_friend_req</TD></TR>
+      <TR><TD PORT="channel_expire_days" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_expire_days</TD></TR>
+      <TR><TD PORT="channel_passwd_reset" COLSPAN="3" ALIGN="LEFT">channel_passwd_reset</TD></TR>
+      <TR><TD PORT="channel_default_group" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_default_group</TD></TR>
+      <TR><TD PORT="channel_allow_cid" COLSPAN="3" ALIGN="LEFT">channel_allow_cid</TD></TR>
+      <TR><TD PORT="channel_allow_gid" COLSPAN="3" ALIGN="LEFT">channel_allow_gid</TD></TR>
+      <TR><TD PORT="channel_deny_cid" COLSPAN="3" ALIGN="LEFT">channel_deny_cid</TD></TR>
+      <TR><TD PORT="channel_deny_gid" COLSPAN="3" ALIGN="LEFT">channel_deny_gid</TD></TR>
+      <TR><TD PORT="channel_r_stream" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_stream</TD></TR>
+      <TR><TD PORT="channel_r_profile" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_profile</TD></TR>
+      <TR><TD PORT="channel_r_photos" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_photos</TD></TR>
+      <TR><TD PORT="channel_r_abook" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_abook</TD></TR>
+      <TR><TD PORT="channel_w_stream" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_stream</TD></TR>
+      <TR><TD PORT="channel_w_wall" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_wall</TD></TR>
+      <TR><TD PORT="channel_w_tagwall" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_tagwall</TD></TR>
+      <TR><TD PORT="channel_w_comment" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_comment</TD></TR>
+      <TR><TD PORT="channel_w_mail" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_mail</TD></TR>
+      <TR><TD PORT="channel_w_photos" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_photos</TD></TR>
+      <TR><TD PORT="channel_w_chat" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_chat</TD></TR>
+      <TR><TD PORT="channel_a_delegate" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_a_delegate</TD></TR>
+      <TR><TD PORT="channel_r_storage" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_storage</TD></TR>
+      <TR><TD PORT="channel_w_storage" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_storage</TD></TR>
+      <TR><TD PORT="channel_r_pages" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_r_pages</TD></TR>
+      <TR><TD PORT="channel_w_pages" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_pages</TD></TR>
+      <TR><TD PORT="channel_a_republish" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_a_republish</TD></TR>
+      <TR><TD PORT="channel_w_like" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_w_like</TD></TR>
+      <TR><TD PORT="channel_removed" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_removed</TD></TR>
+      <TR><TD PORT="channel_system" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel_system</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">12 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">17 &gt;</TD></TR>
+    </TABLE>>
+    URL="channel.html"
+    tooltip="channel"
+  ];
+  "config" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">config</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">83 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="config.html"
+    tooltip="config"
+  ];
+  "conv" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">conv</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">15 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="conv.html"
+    tooltip="conv"
+  ];
+  "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; 5</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">12 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="event.html"
+    tooltip="event"
+  ];
+  "fcontact" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fcontact</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="fcontact.html"
+    tooltip="fcontact"
+  ];
+  "ffinder" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">ffinder</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="ffinder.html"
+    tooltip="ffinder"
+  ];
+  "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; 2</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; 4</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; 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">37 583 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="item.html"
+    tooltip="item"
+  ];
+  "item_id" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item_id</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">194 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="item_id.html"
+    tooltip="item_id"
+  ];
+  "likes" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">likes</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="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="liker" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">liker</TD><TD PORT="liker.type" ALIGN="LEFT">char[128]</TD></TR>
+      <TR><TD PORT="likee" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">likee</TD><TD PORT="likee.type" ALIGN="LEFT">char[128]</TD></TR>
+      <TR><TD PORT="iid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">iid</TD><TD PORT="iid.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="verb" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">verb</TD><TD PORT="verb.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="target_type" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">target_type</TD><TD PORT="target_type.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="target_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">target_id</TD><TD PORT="target_id.type" ALIGN="LEFT">char[128]</TD></TR>
+      <TR><TD PORT="target" COLSPAN="2" ALIGN="LEFT">target</TD><TD PORT="target.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="i_mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">i_mid</TD><TD PORT="i_mid.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
+    </TABLE>>
+    URL="likes.html"
+    tooltip="likes"
+  ];
+  "mail" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">mail</TD></TR>
+      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 5</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">39 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="mail.html"
+    tooltip="mail"
+  ];
+  "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">10 &gt;</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; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 888 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="photo.html"
+    tooltip="photo"
+  ];
+  "profdef" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profdef</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="profdef.html"
+    tooltip="profdef"
+  ];
+  "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; 6</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="profext.html"
+    tooltip="profext"
+  ];
+  "profile_check" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profile_check</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="profile_check.html"
+    tooltip="profile_check"
+  ];
+  "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; 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="register.html"
+    tooltip="register"
+  ];
+  "sign" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sign</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="sign.html"
+    tooltip="sign"
+  ];
+  "sys_perms" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sys_perms</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="sys_perms.html"
+    tooltip="sys_perms"
+  ];
+  "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"
+  ];
+  "verify" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">verify</TD></TR>
+      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
+      <TR><TD PORT="channel" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel</TD></TR>
+      <TR><TD PORT="type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type</TD></TR>
+      <TR><TD PORT="token" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">token</TD></TR>
+      <TR><TD PORT="meta" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">meta</TD></TR>
+      <TR><TD PORT="created" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">20 &gt;</TD></TR>
+    </TABLE>>
+    URL="verify.html"
+    tooltip="verify"
+  ];
+  "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="elipses" COLSPAN="3" ALIGN="LEFT">...</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"
+  ];
+  "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; 3</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; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="xign.html"
+    tooltip="xign"
+  ];
+  "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"
+  ];
+}