Remove references to Pear Text_Highlighter stylesheets

[friendica.git] / config / dbstructure.json

diff --git a/config/dbstructure.json b/config/dbstructure.json
index fa7513332718c20012fd3c1b7af8e02ff1498804..c467ba6bc7644a062c896289a806362b584df9ac 100644 (file)
--- a/config/dbstructure.json
+++ b/config/dbstructure.json
@@ -211,7 +211,7 @@
        "conversation": {
                "comment": "Raw data and structure information for messages",
                "fields": {
-                       "item-uri": {"type": "varbinary(255)", "not null": "1", "primary": "1", "comment": "URI of the item"},
+                       "item-uri": {"type": "varbinary(255)", "not null": "1", "primary": "1", "comment": "Original URI of the item - unrelated to the table with the same name"},
                        "reply-to-uri": {"type": "varbinary(255)", "not null": "1", "default": "", "comment": "URI to which this item is a reply"},
                        "conversation-uri": {"type": "varbinary(255)", "not null": "1", "default": "", "comment": "GNU Social conversation URI"},
                        "conversation-href": {"type": "varbinary(255)", "not null": "1", "default": "", "comment": "GNU Social conversation link"},
@@ -471,10 +471,13 @@
                        "id": {"type": "int unsigned", "not null": "1", "extra": "auto_increment", "primary": "1", "relation": {"thread": "iid"}},
                        "guid": {"type": "varchar(255)", "not null": "1", "default": "", "comment": "A unique identifier for this item"},
                        "uri": {"type": "varchar(255)", "not null": "1", "default": "", "comment": ""},
+                       "uri-id": {"type": "int unsigned", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table entry that contains the item uri"},
                        "uri-hash": {"type": "varchar(80)", "not null": "1", "default": "", "comment": "RIPEMD-128 hash from uri"},
                        "parent": {"type": "int unsigned", "not null": "1", "default": "0", "relation": {"item": "id"}, "comment": "item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item"},
                        "parent-uri": {"type": "varchar(255)", "not null": "1", "default": "", "comment": "uri of the parent to this item"},
+                       "parent-uri-id": {"type": "int unsigned", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table that contains the parent uri"},
                        "thr-parent": {"type": "varchar(255)", "not null": "1", "default": "", "comment": "If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri"},
+                       "thr-parent-id": {"type": "int unsigned", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table that contains the thread parent uri"},
                        "created": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Creation timestamp."},
                        "edited": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Date of last edit (default is created)"},
                        "commented": {"type": "datetime", "not null": "1", "default": "0001-01-01 00:00:00", "comment": "Date of last comment/reply to this item"},
@@ -571,6 +574,7 @@
                "fields": {
                        "id": {"type": "int unsigned", "not null": "1", "extra": "auto_increment", "primary": "1", "relation": {"thread": "iid"}},
                        "uri": {"type": "varchar(255)", "comment": ""},
+                       "uri-id": {"type": "int unsigned", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table entry that contains the item uri"},
                        "uri-hash": {"type": "varchar(80)", "not null": "1", "default": "", "comment": "RIPEMD-128 hash from uri"},
                        "activity": {"type": "smallint unsigned", "not null": "1", "default": "0", "comment": ""}
                },
@@ -585,6 +589,7 @@
                "fields": {
                        "id": {"type": "int unsigned", "not null": "1", "extra": "auto_increment", "primary": "1", "relation": {"thread": "iid"}},
                        "uri": {"type": "varchar(255)", "comment": ""},
+                       "uri-id": {"type": "int unsigned", "relation": {"item-uri": "id"}, "comment": "Id of the item-uri table entry that contains the item uri"},
                        "uri-plink-hash": {"type": "varchar(80)", "not null": "1", "default": "", "comment": "RIPEMD-128 hash from uri"},
                        "title": {"type": "varchar(255)", "not null": "1", "default": "", "comment": "item title"},
                        "content-warning": {"type": "varchar(255)", "not null": "1", "default": "", "comment": ""},
@@ -619,6 +624,19 @@
                        "PRIMARY": ["iid"]
                }
        },
+       "item-uri": {
+               "comment": "URI and GUID for items",
+               "fields": {
+                       "id": {"type": "int unsigned", "not null": "1", "extra": "auto_increment", "primary": "1"},
+                       "uri": {"type": "varbinary(255)", "not null": "1", "comment": "URI of an item"},
+                       "guid": {"type": "varbinary(255)", "comment": "A unique identifier for an item"}
+               },
+               "indexes": {
+                       "PRIMARY": ["id"],
+                       "uri": ["UNIQUE", "uri"],
+                       "guid": ["guid"]
+               }
+       },
        "locks": {
                "comment": "",
                "fields": {
@@ -1206,12 +1224,26 @@
                        "username": ["username(32)"]
                }
        },
+       "user-contact": {
+               "comment": "User specific public contact data",
+               "fields": {
+                       "cid": {"type": "int unsigned", "not null": "1", "default": "0", "primary": "1", "relation": {"contact": "id"}, "comment": "Contact id of the linked public contact"},
+                       "uid": {"type": "mediumint unsigned", "not null": "1", "default": "0", "primary": "1", "relation": {"user": "uid"}, "comment": "User id"},
+                       "blocked": {"type": "boolean", "comment": "Contact is completely blocked for this user"},
+                       "ignored": {"type": "boolean", "comment": "Posts from this contact are ignored"},
+                       "collapsed": {"type": "boolean", "comment": "Posts from this contact are collapsed"}
+               },
+               "indexes": {
+                       "PRIMARY": ["uid", "cid"]
+               }
+       },
        "user-item": {
                "comment": "User specific item data",
                "fields": {
                        "iid": {"type": "int unsigned", "not null": "1", "default": "0", "primary": "1", "relation": {"item": "id"}, "comment": "Item id"},
                        "uid": {"type": "mediumint unsigned", "not null": "1", "default": "0", "primary": "1", "relation": {"user": "uid"}, "comment": "User id"},
-                       "hidden": {"type": "boolean", "not null": "1", "default": "0", "comment": "Marker to hide an item from the user"}
+                       "hidden": {"type": "boolean", "not null": "1", "default": "0", "comment": "Marker to hide an item from the user"},
+                       "ignored": {"type": "boolean", "comment": "Ignore this thread if set"}
                },
                "indexes": {
                        "PRIMARY": ["uid", "iid"]
@@ -1247,4 +1279,4 @@
                        "done_executed": ["done", "executed"]
                }
        }
-}
\ No newline at end of file
+}