X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbview.config.php;h=3caa7c0877c8d5a505c69310ac4a9a9683cc95bd;hb=7dd757b7f974c9d9d9e91ab394a4f52cca327646;hp=662425b02e7c19dadf4a7ca848f9f4f43cf0477b;hpb=6f290607de7f10cea7429aacd0b394fd3f4c4e69;p=friendica.git

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 662425b02e..3caa7c0877 100644
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -193,6 +193,7 @@
 			"parent-author-id" => ["parent-post", "author-id"],
 			"parent-author-link" => ["parent-post-author", "url"],
 			"parent-author-name" => ["parent-post-author", "name"],
+			"parent-author-nick" => ["parent-post-author", "nick"],
 			"parent-author-network" => ["parent-post-author", "network"],
 			"parent-author-blocked" => ["parent-post-author", "blocked"],
 			"parent-author-hidden" => ["parent-post-author", "hidden"],
@@ -1047,5 +1048,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`"
+	],
 ];