Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 54 insertions, 0 deletions

diff --git a/hubzilla_er/diagrams/attach.1degree.dot b/hubzilla_er/diagrams/attach.1degree.dot
new file mode 100644
index 000000000..34646c1dc
--- /dev/null
+++ b/hubzilla_er/diagrams/attach.1degree.dot
@@ -0,0 +1,54 @@
+// 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"
+  ];
+  "attach" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">attach</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="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 unsigned[10]</TD></TR>
+      <TR><TD PORT="hash" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hash</TD><TD PORT="hash.type" ALIGN="LEFT">char[64]</TD></TR>
+      <TR><TD PORT="creator" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">creator</TD><TD PORT="creator.type" ALIGN="LEFT">char[128]</TD></TR>
+      <TR><TD PORT="filename" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filename</TD><TD PORT="filename.type" ALIGN="LEFT">char[255]</TD></TR>
+      <TR><TD PORT="filetype" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filetype</TD><TD PORT="filetype.type" ALIGN="LEFT">char[64]</TD></TR>
+      <TR><TD PORT="filesize" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filesize</TD><TD PORT="filesize.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="revision" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">revision</TD><TD PORT="revision.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="folder" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">folder</TD><TD PORT="folder.type" ALIGN="LEFT">char[64]</TD></TR>
+      <TR><TD PORT="flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">flags</TD><TD PORT="flags.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
+      <TR><TD PORT="is_dir" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_dir</TD><TD PORT="is_dir.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD PORT="is_photo" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_photo</TD><TD PORT="is_photo.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD PORT="os_storage" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">os_storage</TD><TD PORT="os_storage.type" ALIGN="LEFT">bit[0]</TD></TR>
+      <TR><TD PORT="os_path" COLSPAN="2" ALIGN="LEFT">os_path</TD><TD PORT="os_path.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="display_path" COLSPAN="2" ALIGN="LEFT">display_path</TD><TD PORT="display_path.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="data" COLSPAN="2" ALIGN="LEFT">data</TD><TD PORT="data.type" ALIGN="LEFT">longblob[2147483647]</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="edited" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">edited</TD><TD PORT="edited.type" ALIGN="LEFT">datetime[19]</TD></TR>
+      <TR><TD PORT="allow_cid" COLSPAN="2" ALIGN="LEFT">allow_cid</TD><TD PORT="allow_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="allow_gid" COLSPAN="2" ALIGN="LEFT">allow_gid</TD><TD PORT="allow_gid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="deny_cid" COLSPAN="2" ALIGN="LEFT">deny_cid</TD><TD PORT="deny_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD PORT="deny_gid" COLSPAN="2" ALIGN="LEFT">deny_gid</TD><TD PORT="deny_gid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 0</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
+    </TABLE>>
+    URL="attach.html"
+    tooltip="attach"
+  ];
+}