Merge pull request #129 from HaakonME/master

Hubzilla database entity-relationship documentation and HonO fix

1 files changed, 69 insertions, 0 deletions

diff --git a/hubzilla_er/diagrams/tokens.implied2degrees.dot b/hubzilla_er/diagrams/tokens.implied2degrees.dot
new file mode 100644
index 000000000..e5fa204dc
--- /dev/null
+++ b/hubzilla_er/diagrams/tokens.implied2degrees.dot
@@ -0,0 +1,69 @@
+// 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"
+  ];
+  "auth_codes":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
+  "auth_codes":"id":w -> "tokens":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
+  "tokens":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
+  "auth_codes" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">auth_codes</TD></TR>
+      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
+      <TR><TD PORT="client_id" COLSPAN="3" ALIGN="LEFT">client_id</TD></TR>
+      <TR><TD PORT="redirect_uri" COLSPAN="3" ALIGN="LEFT">redirect_uri</TD></TR>
+      <TR><TD PORT="expires" COLSPAN="3" ALIGN="LEFT">expires</TD></TR>
+      <TR><TD PORT="scope" COLSPAN="3" ALIGN="LEFT">scope</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="auth_codes.html"
+    tooltip="auth_codes"
+  ];
+  "clients" [
+    label=<
+    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">clients</TD></TR>
+      <TR><TD PORT="client_id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">client_id</TD></TR>
+      <TR><TD PORT="pw" COLSPAN="3" ALIGN="LEFT">pw</TD></TR>
+      <TR><TD PORT="redirect_uri" COLSPAN="3" ALIGN="LEFT">redirect_uri</TD></TR>
+      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT">name</TD></TR>
+      <TR><TD PORT="icon" COLSPAN="3" ALIGN="LEFT">icon</TD></TR>
+      <TR><TD PORT="uid" COLSPAN="3" ALIGN="LEFT">uid</TD></TR>
+      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 &gt;</TD></TR>
+    </TABLE>>
+    URL="clients.html"
+    tooltip="clients"
+  ];
+  "tokens" [
+    label=<
+    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">tokens</TD></TR>
+      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">varchar[40]</TD></TR>
+      <TR><TD PORT="secret" COLSPAN="2" ALIGN="LEFT">secret</TD><TD PORT="secret.type" ALIGN="LEFT">text[65535]</TD></TR>
+      <TR><TD PORT="client_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">client_id</TD><TD PORT="client_id.type" ALIGN="LEFT">varchar[20]</TD></TR>
+      <TR><TD PORT="expires" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">expires</TD><TD PORT="expires.type" ALIGN="LEFT">bigint unsigned[20]</TD></TR>
+      <TR><TD PORT="scope" COLSPAN="2" ALIGN="LEFT">scope</TD><TD PORT="scope.type" ALIGN="LEFT">varchar[200]</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 ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
+    </TABLE>>
+    URL="tokens.html"
+    tooltip="tokens"
+  ];
+}