Merge pull request #10283 from very-ape/fix-message-button

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

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 17cadaba434f96ab11c3631775b51421b099212f..488cbceaa2662e3c07ff92ddd4c8c6f5ea3048b5 100644 (file)
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2021, the Friendica project
  *
  * @license GNU AGPL version 3 or any later version
  *
@@ -37,6 +37,27 @@
  */
 
  return [
+       "application-view" => [
+               "fields" => [
+                       "id" => ["application", "id"],
+                       "uid" => ["application-token", "uid"],
+                       "name" => ["application", "name"],
+                       "redirect_uri" => ["application", "redirect_uri"],
+                       "website" => ["application", "website"],
+                       "client_id" => ["application", "client_id"],
+                       "client_secret" => ["application", "client_secret"],
+                       "code" => ["application-token", "code"],
+                       "access_token" => ["application-token", "access_token"],
+                       "created_at" => ["application-token", "created_at"],
+                       "scopes" => ["application-token", "scopes"],
+                       "read" => ["application-token", "read"],
+                       "write" => ["application-token", "write"],
+                       "follow" => ["application-token", "follow"],
+                       "push" => ["application-token", "push"],
+               ],
+               "query" => "FROM `application-token`
+                       INNER JOIN `application` ON `application-token`.`application-id` = `application`.`id`"
+       ],
        "post-user-view" => [
                "fields" => [
                        "id" => ["post-user", "id"],
@@ -60,6 +81,7 @@
                        "received" => ["post-user", "received"],
                        "changed" => ["post-thread-user", "changed"],
                        "post-type" => ["post-user", "post-type"],
+                       "post-reason" => ["post-user", "post-reason"],
                        "private" => ["post-user", "private"],
                        "pubmail" => ["post-thread-user", "pubmail"],
                        "visible" => ["post-user", "visible"],
@@ -217,6 +239,7 @@
                        "received" => ["post-thread-user", "received"],
                        "changed" => ["post-thread-user", "changed"],
                        "post-type" => ["post-user", "post-type"],
+                       "post-reason" => ["post-user", "post-reason"],
                        "private" => ["post-user", "private"],
                        "pubmail" => ["post-thread-user", "pubmail"],
                        "ignored" => ["post-thread-user", "ignored"],
@@ -783,6 +806,7 @@
                        "gravity" => ["post-user", "gravity"],
                        "received" => ["post-user", "received"],
                        "network" => ["post-user", "network"],
+                       "author-id" => ["post-user", "author-id"],
                        "name" => ["tag", "name"],
                ],
                "query" => "FROM `post-tag`