Merge pull request #11010 from foss-/doc_faq_client-clean-up

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

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 662425b02e7c19dadf4a7ca848f9f4f43cf0477b..a12d5747a5914e09878b002552dc05bbfe274f57 100644 (file)
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -1047,5 +1047,23 @@
                        INNER JOIN `workerqueue` ON `workerqueue`.`pid` = `process`.`pid`
                        WHERE NOT `workerqueue`.`done`"
        ],
+       "profile_field-view" => [
+               "fields" => [
+                       "id" => ["profile_field", "id"],
+                       "uid" => ["profile_field", "uid"],
+                       "label" => ["profile_field", "label"],
+                       "value" => ["profile_field", "value"],
+                       "order" => ["profile_field", "order"],
+                       "psid"=> ["profile_field", "psid"],
+                       "allow_cid" => ["permissionset", "allow_cid"],
+                       "allow_gid" => ["permissionset", "allow_gid"],
+                       "deny_cid" => ["permissionset", "deny_cid"],
+                       "deny_gid" => ["permissionset", "deny_gid"],
+                       "created" => ["profile_field", "created"],
+                       "edited" => ["profile_field", "edited"],
+               ],
+               "query" => "FROM `profile_field`
+                       INNER JOIN `permissionset` ON `permissionset`.`id` = `profile_field`.`psid`"
+       ],
 ];