Merge pull request #5971 from MrPetovan/bug/5970-use-temppath-passwordexposed

[friendica.git] / config / dbstructure.json

diff --git a/config/dbstructure.json b/config/dbstructure.json
index 8ea5aaa4bfb00d2ae52419f97a227e769a717b8a..da1da7a66b1a295242db1cf7aaa4ff2af39765c2 100644 (file)
--- a/config/dbstructure.json
+++ b/config/dbstructure.json
@@ -254,6 +254,16 @@
                        "received": ["received"]
                }
        },
+       "diaspora-interaction": {
+               "comment": "Signed Diaspora Interaction",
+               "fields": {
+                       "uri-id": {"type": "int unsigned", "not null": "1", "primary": "1", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table entry that contains the item uri"},
+                       "interaction": {"type": "mediumtext", "comment": "The Diaspora interaction"}
+               },
+               "indexes": {
+                       "PRIMARY": ["uri-id"]
+               }
+       },
        "event": {
                "comment": "Events",
                "fields": {
@@ -610,7 +620,8 @@
                "indexes": {
                        "PRIMARY": ["id"],
                        "uri-hash": ["UNIQUE", "uri-hash"],
-                       "uri": ["uri(191)"]
+                       "uri": ["uri(191)"],
+                       "uri-id": ["uri-id"]
                }
        },
        "item-content": {
@@ -639,7 +650,8 @@
                "indexes": {
                        "PRIMARY": ["id"],
                        "uri-plink-hash": ["UNIQUE", "uri-plink-hash"],
-                       "uri": ["uri(191)"]
+                       "uri": ["uri(191)"],
+                       "uri-id": ["uri-id"]
                }
        },
        "item-delivery-data": {