Item storage: Permissions aren't stored in the items anymore (#5495)

[friendica.git] / src / Database / DBStructure.php

diff --git a/src/Database/DBStructure.php b/src/Database/DBStructure.php
index d03268374b0f32c8bc58b2955c4ea0f7968b3486..5ff15227b4fe23e2d3c7cb57932e49bec725467e 100644 (file)
--- a/src/Database/DBStructure.php
+++ b/src/Database/DBStructure.php
@@ -1328,17 +1328,16 @@ class DBStructure
                                                "mention" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => "The owner of this item was mentioned in it"],
                                                "forum_mode" => ["type" => "tinyint unsigned", "not null" => "1", "default" => "0", "comment" => ""],
                                                "psid" => ["type" => "int unsigned", "relation" => ["permissionset" => "id"], "comment" => "ID of the permission set of this post"],
-                                               // These fields will be replaced by the "psid" from above
-                                               "allow_cid" => ["type" => "mediumtext", "comment" => "Access Control - list of allowed contact.id '<19><78>'"],
-                                               "allow_gid" => ["type" => "mediumtext", "comment" => "Access Control - list of allowed groups"],
-                                               "deny_cid" => ["type" => "mediumtext", "comment" => "Access Control - list of denied contact.id"],
-                                               "deny_gid" => ["type" => "mediumtext", "comment" => "Access Control - list of denied groups"],
-                                               // It is to be decided whether these fields belong to the user or the structure
+                                               // It has to be decided whether these fields belong to the user or the structure
                                                "resource-id" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => "Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type"],
                                                "event-id" => ["type" => "int unsigned", "not null" => "1", "default" => "0", "relation" => ["event" => "id"], "comment" => "Used to link to the event.id"],
                                                // Could possibly be replaced by the "attach" table?
                                                "attach" => ["type" => "mediumtext", "comment" => "JSON structure representing attachments to this item"],
                                                // Deprecated fields. Will be removed in upcoming versions
+                                               "allow_cid" => ["type" => "mediumtext", "comment" => "Deprecated"],
+                                               "allow_gid" => ["type" => "mediumtext", "comment" => "Deprecated"],
+                                               "deny_cid" => ["type" => "mediumtext", "comment" => "Deprecated"],
+                                               "deny_gid" => ["type" => "mediumtext", "comment" => "Deprecated"],
                                                "postopts" => ["type" => "text", "comment" => "Deprecated"],
                                                "inform" => ["type" => "mediumtext", "comment" => "Deprecated"],
                                                "type" => ["type" => "varchar(20)", "comment" => "Deprecated"],
@@ -1392,7 +1391,7 @@ class DBStructure
                                                "uid_eventid" => ["uid","event-id"],
                                                "icid" => ["icid"],
                                                "iaid" => ["iaid"],
-                                               "psid" => ["psid"],
+                                               "psid_wall" => ["psid", "wall"],
                                                ]
                                ];
                $database["item-activity"] = [