Merge pull request #11913 from tobiasd/2022.09-CHANGELOG

[friendica.git] / static / dbview.config.php

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 0c91016d4906eacae2eb7caba15e84f552f4baed..2a7cb54feb67de92ef8985fb977e11fe1f6507ee 100644 (file)
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -96,6 +96,7 @@
                        "global" => ["post-user", "global"],
                        "featured" => "EXISTS(SELECT `type` FROM `post-collection` WHERE `type` = 0 AND `uri-id` = `post-user`.`uri-id`)",
                        "network" => ["post-user", "network"],
+                       "protocol" => ["post-user", "protocol"],
                        "vid" => ["post-user", "vid"],
                        "psid" => ["post-user", "psid"],
                        "verb" => "IF (`post-user`.`vid` IS NULL, '', `verb`.`name`)",
@@ -701,7 +702,7 @@
                "fields" => [
                        "uri-id" => ["post-collection", "uri-id"],
                        "type" => ["post-collection", "type"],
-                       "cid" => ["post", "author-id"],
+                       "cid" => ["post-collection", "author-id"],
                        "received" => ["post", "received"],
                        "created" => ["post", "created"],
                        "commented" => ["post-thread", "commented"],
@@ -709,7 +710,7 @@
                        "visible" => ["post", "visible"],
                        "deleted" => ["post", "deleted"],
                        "thr-parent-id" => ["post", "thr-parent-id"],
-                       "author-id" => ["post", "author-id"],
+                       "author-id" => ["post-collection", "author-id"],
                        "gravity" => ["post", "gravity"],
                ],
                "query" => "FROM `post-collection`