Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 214 insertions, 0 deletions

diff --git a/doc/schemaspy_hubzilla/diagrams/app.implied2degrees.dot b/doc/schemaspy_hubzilla/diagrams/app.implied2degrees.dot
new file mode 100644
index 000000000..3539020f7
--- /dev/null
+++ b/doc/schemaspy_hubzilla/diagrams/app.implied2degrees.dot
@@ -0,0 +1,214 @@
+// 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"
+  ];
+  "addon":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "app":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "channel":"elipses":w -> "xchan":"elipses":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":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "event":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "fserver":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "fsuggest":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "hook":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "hubloc":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "hubloc":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "manage":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "manage":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "notify":"hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
+  "pconfig":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "profile":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "spam":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "xchan":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "xchan":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
+  "addon" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">addon</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">20 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="addon.html"
+    tooltip="addon"
+  ];
+  "app" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">app</TD></TR>
+      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int[10]</TD></TR>
+      <TR><TD PORT="app_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_id</TD><TD PORT="app_id.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_sig" COLSPAN="2" ALIGN="LEFT">app_sig</TD><TD PORT="app_sig.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_author" COLSPAN="2" ALIGN="LEFT">app_author</TD><TD PORT="app_author.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_name" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_name</TD><TD PORT="app_name.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_desc" COLSPAN="2" ALIGN="LEFT">app_desc</TD><TD PORT="app_desc.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="app_url" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_url</TD><TD PORT="app_url.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_photo" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_photo</TD><TD PORT="app_photo.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_version" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_version</TD><TD PORT="app_version.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_channel" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_channel</TD><TD PORT="app_channel.type" ALIGN="LEFT">int[10]</TD></TR>
+      <TR><TD PORT="app_addr" COLSPAN="2" ALIGN="LEFT">app_addr</TD><TD PORT="app_addr.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_price" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_price</TD><TD PORT="app_price.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_page" COLSPAN="2" ALIGN="LEFT">app_page</TD><TD PORT="app_page.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_requires" COLSPAN="2" ALIGN="LEFT">app_requires</TD><TD PORT="app_requires.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="app_created" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_created</TD><TD PORT="app_created.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD PORT="app_edited" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">app_edited</TD><TD PORT="app_edited.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
+    </TABLE>>
+    URL="app.html"
+    tooltip="app"
+  ];
+  "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"
+  ];
+  "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"
+  ];
+  "fserver" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fserver</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="fserver.html"
+    tooltip="fserver"
+  ];
+  "fsuggest" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fsuggest</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="fsuggest.html"
+    tooltip="fsuggest"
+  ];
+  "hook" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">hook</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">41 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="hook.html"
+    tooltip="hook"
+  ];
+  "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"
+  ];
+  "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; 2</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="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
+      <TR><TD PORT="hash" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hash</TD></TR>
+      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT">name</TD></TR>
+      <TR><TD PORT="url" COLSPAN="3" ALIGN="LEFT">url</TD></TR>
+      <TR><TD PORT="photo" COLSPAN="3" ALIGN="LEFT">photo</TD></TR>
+      <TR><TD PORT="date" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">date</TD></TR>
+      <TR><TD PORT="msg" COLSPAN="3" ALIGN="LEFT">msg</TD></TR>
+      <TR><TD PORT="aid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">aid</TD></TR>
+      <TR><TD PORT="uid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD></TR>
+      <TR><TD PORT="link" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">link</TD></TR>
+      <TR><TD PORT="parent" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">parent</TD></TR>
+      <TR><TD PORT="seen" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">seen</TD></TR>
+      <TR><TD PORT="type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type</TD></TR>
+      <TR><TD PORT="verb" COLSPAN="3" ALIGN="LEFT">verb</TD></TR>
+      <TR><TD PORT="otype" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">otype</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"
+  ];
+  "pconfig" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">pconfig</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">719 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="pconfig.html"
+    tooltip="pconfig"
+  ];
+  "profile" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profile</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">11 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
+    </TABLE>>
+    URL="profile.html"
+    tooltip="profile"
+  ];
+  "spam" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">spam</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="spam.html"
+    tooltip="spam"
+  ];
+  "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"
+  ];
+}