Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 75 insertions, 0 deletions

diff --git a/doc/schemaspy_hubzilla/diagrams/profile.1degree.dot b/doc/schemaspy_hubzilla/diagrams/profile.1degree.dot
new file mode 100644
index 000000000..1ae01de9b
--- /dev/null
+++ b/doc/schemaspy_hubzilla/diagrams/profile.1degree.dot
@@ -0,0 +1,75 @@
+// dot 2.26.3 on Linux 3.2.0-4-686-pae
+// SchemaSpy rev 590
+digraph "oneDegreeRelationshipsDiagram" {
+  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"
+  ];
+  "profile" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profile</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="profile_guid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">profile_guid</TD><TD PORT="profile_guid.type" ALIGN="LEFT">char[64]</TD></TR>
+      <TR><TD PORT="aid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">aid</TD><TD PORT="aid.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="uid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD><TD PORT="uid.type" ALIGN="LEFT">int[10]</TD></TR>
+      <TR><TD PORT="profile_name" COLSPAN="2" ALIGN="LEFT">profile_name</TD><TD PORT="profile_name.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="is_default" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_default</TD><TD PORT="is_default.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD PORT="hide_friends" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hide_friends</TD><TD PORT="hide_friends.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD PORT="name" COLSPAN="2" ALIGN="LEFT">name</TD><TD PORT="name.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="pdesc" COLSPAN="2" ALIGN="LEFT">pdesc</TD><TD PORT="pdesc.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="chandesc" COLSPAN="2" ALIGN="LEFT">chandesc</TD><TD PORT="chandesc.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="dob" COLSPAN="2" ALIGN="LEFT">dob</TD><TD PORT="dob.type" ALIGN="LEFT">char[32]</TD></TR>
+      <TR><TD PORT="dob_tz" COLSPAN="2" ALIGN="LEFT">dob_tz</TD><TD PORT="dob_tz.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="address" COLSPAN="2" ALIGN="LEFT">address</TD><TD PORT="address.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="locality" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">locality</TD><TD PORT="locality.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="region" COLSPAN="2" ALIGN="LEFT">region</TD><TD PORT="region.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="postal_code" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">postal_code</TD><TD PORT="postal_code.type" ALIGN="LEFT">char[32]</TD></TR>
+      <TR><TD PORT="country_name" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">country_name</TD><TD PORT="country_name.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="hometown" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hometown</TD><TD PORT="hometown.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="gender" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">gender</TD><TD PORT="gender.type" ALIGN="LEFT">char[32]</TD></TR>
+      <TR><TD PORT="marital" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">marital</TD><TD PORT="marital.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="with" COLSPAN="2" ALIGN="LEFT">with</TD><TD PORT="with.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="howlong" COLSPAN="2" ALIGN="LEFT">howlong</TD><TD PORT="howlong.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD PORT="sexual" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">sexual</TD><TD PORT="sexual.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="politic" COLSPAN="2" ALIGN="LEFT">politic</TD><TD PORT="politic.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="religion" COLSPAN="2" ALIGN="LEFT">religion</TD><TD PORT="religion.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="keywords" COLSPAN="2" ALIGN="LEFT">keywords</TD><TD PORT="keywords.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="likes" COLSPAN="2" ALIGN="LEFT">likes</TD><TD PORT="likes.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="dislikes" COLSPAN="2" ALIGN="LEFT">dislikes</TD><TD PORT="dislikes.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="about" COLSPAN="2" ALIGN="LEFT">about</TD><TD PORT="about.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="summary" COLSPAN="2" ALIGN="LEFT">summary</TD><TD PORT="summary.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="music" COLSPAN="2" ALIGN="LEFT">music</TD><TD PORT="music.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="book" COLSPAN="2" ALIGN="LEFT">book</TD><TD PORT="book.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="tv" COLSPAN="2" ALIGN="LEFT">tv</TD><TD PORT="tv.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="film" COLSPAN="2" ALIGN="LEFT">film</TD><TD PORT="film.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="interest" COLSPAN="2" ALIGN="LEFT">interest</TD><TD PORT="interest.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="romance" COLSPAN="2" ALIGN="LEFT">romance</TD><TD PORT="romance.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="work" COLSPAN="2" ALIGN="LEFT">work</TD><TD PORT="work.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="education" COLSPAN="2" ALIGN="LEFT">education</TD><TD PORT="education.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="contact" COLSPAN="2" ALIGN="LEFT">contact</TD><TD PORT="contact.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="channels" COLSPAN="2" ALIGN="LEFT">channels</TD><TD PORT="channels.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="homepage" COLSPAN="2" ALIGN="LEFT">homepage</TD><TD PORT="homepage.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="photo" COLSPAN="2" ALIGN="LEFT">photo</TD><TD PORT="photo.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="thumb" COLSPAN="2" ALIGN="LEFT">thumb</TD><TD PORT="thumb.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="publish" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">publish</TD><TD PORT="publish.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">11 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
+    </TABLE>>
+    URL="profile.html"
+    tooltip="profile"
+  ];
+}