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

diff --git a/static/dbview.config.php b/static/dbview.config.php
index b2b9875c19..3caa7c0877 100644
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -186,7 +186,6 @@
 			"event-location" => ["event", "location"],
 			"event-type" => ["event", "type"],
 			"event-nofinish" => ["event", "nofinish"],
-			"event-adjust" => ["event", "adjust"],
 			"event-ignore" => ["event", "ignore"],
 			"signed_text" => ["diaspora-interaction", "interaction"],
 			"parent-guid" => ["parent-item-uri", "guid"],
@@ -194,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"],
@@ -345,7 +345,6 @@
 			"event-location" => ["event", "location"],
 			"event-type" => ["event", "type"],
 			"event-nofinish" => ["event", "nofinish"],
-			"event-adjust" => ["event", "adjust"],
 			"event-ignore" => ["event", "ignore"],
 			"signed_text" => ["diaspora-interaction", "interaction"],
 			"parent-guid" => ["parent-item-uri", "guid"],
@@ -711,8 +710,8 @@
 			"location" => ["contact", "location"],
 			"about" => ["contact", "about"],
 			"keywords" => ["contact", "keywords"],
-			"gender" => ["contact", "gender"],
 			"xmpp" => ["contact", "xmpp"],
+			"matrix" => ["contact", "matrix"],
 			"attag" => ["contact", "attag"],
 			"avatar" => ["contact", "avatar"],
 			"photo" => ["contact", "photo"],
@@ -732,7 +731,6 @@
 			"poll" => ["contact", "poll"],
 			"confirm" => ["contact", "confirm"],
 			"poco" => ["contact", "poco"],
-			"usehub" => ["contact", "usehub"],
 			"subhub" => ["contact", "subhub"],
 			"hub-verify" => ["contact", "hub-verify"],
 			"last-update" => ["contact", "last-update"],
@@ -761,9 +759,7 @@
 			"sensitive" => ["contact", "sensitive"],
 			"baseurl" => ["contact", "baseurl"],
 			"reason" => ["contact", "reason"],
-			"closeness" => ["contact", "closeness"],
 			"info" => ["contact", "info"],
-			"profile-id" => ["contact", "profile-id"],
 			"bdyear" => ["contact", "bdyear"],
 			"bd" => ["contact", "bd"],
 			"notify_new_posts" => ["contact", "notify_new_posts"],
@@ -830,6 +826,7 @@
 			"url" => ["contact", "url"],
 			"nurl" => ["contact", "nurl"],
 			"uri-id" => ["contact", "uri-id"],
+			"guid" => ["item-uri", "guid"],
 			"addr" => ["contact", "addr"],
 			"alias" => ["contact", "alias"],
 			"name" => ["contact", "name"],
@@ -837,6 +834,7 @@
 			"about" => ["contact", "about"],
 			"keywords" => ["contact", "keywords"],
 			"xmpp" => ["contact", "xmpp"],
+			"matrix" => ["contact", "matrix"],
 			"avatar" => ["contact", "avatar"],
 			"photo" => ["contact", "photo"],
 			"thumb" => ["contact", "thumb"],
@@ -899,6 +897,7 @@
 			"ap-statuses_count" => ["apcontact", "statuses_count"],
 		],
 		"query" => "FROM `contact`
+			LEFT JOIN `item-uri` ON `item-uri`.`id` = `contact`.`uri-id`
 			LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `contact`.`uri-id`
 			LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = contact.`uri-id`
 			WHERE `contact`.`uid` = 0"			
@@ -911,6 +910,7 @@
 			"url" => ["contact", "url"],
 			"nurl" => ["contact", "nurl"],
 			"uri-id" => ["contact", "uri-id"],
+			"guid" => ["item-uri", "guid"],
 			"addr" => ["contact", "addr"],
 			"alias" => ["contact", "alias"],
 			"name" => ["contact", "name"],
@@ -918,6 +918,7 @@
 			"about" => ["contact", "about"],
 			"keywords" => ["contact", "keywords"],
 			"xmpp" => ["contact", "xmpp"],
+			"matrix" => ["contact", "matrix"],
 			"avatar" => ["contact", "avatar"],
 			"photo" => ["contact", "photo"],
 			"thumb" => ["contact", "thumb"],
@@ -931,7 +932,7 @@
 			"network" => ["contact", "network"],
 			"protocol" => ["ucontact", "protocol"],
 			"location" => ["contact", "location"],
-			"attag" => ["contact", "attag"],
+			"attag" => ["ucontact", "attag"],
 			"pubkey" => ["contact", "pubkey"],
 			"prvkey" => ["contact", "prvkey"],
 			"subscribe" => ["contact", "subscribe"],
@@ -947,7 +948,7 @@
 			"sensitive" => ["contact", "sensitive"],
 			"baseurl" => ["contact", "baseurl"],
 			"gsid" => ["contact", "gsid"],
-			"info" => ["contact", "info"],
+			"info" => ["ucontact", "info"],
 			"bdyear" => ["contact", "bdyear"],
 			"bd" => ["contact", "bd"],
 			"poco" => ["contact", "poco"],
@@ -994,6 +995,7 @@
 		],
 		"query" => "FROM `contact` AS `ucontact`
 			INNER JOIN `contact` ON `contact`.`uri-id` = `ucontact`.`uri-id` AND `contact`.`uid` = 0
+			LEFT JOIN `item-uri` ON `item-uri`.`id` = `ucontact`.`uri-id`
 			LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `ucontact`.`uri-id`
 			LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = `ucontact`.`uri-id` AND `fcontact`.`network` = 'dspr'"
 	],
@@ -1046,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`"
+	],
 ];