X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbview.config.php;h=3caa7c0877c8d5a505c69310ac4a9a9683cc95bd;hb=670bbe58a1cddabb622387a8926eb39023cc8a00;hp=18cdc16e8762cad9eb304fcd23292fac9c469646;hpb=f1e4d308987758635cb9955640e65bb6b6565a13;p=friendica.git diff --git a/static/dbview.config.php b/static/dbview.config.php index 18cdc16e87..3caa7c0877 100644 --- a/static/dbview.config.php +++ b/static/dbview.config.php @@ -138,7 +138,6 @@ "uri-date" => ["contact", "uri-date"], "avatar-date" => ["contact", "avatar-date"], "thumb" => ["contact", "thumb"], - "dfrn-id" => ["contact", "dfrn-id"], "author-id" => ["post-user", "author-id"], "author-link" => ["author", "url"], "author-addr" => ["author", "addr"], @@ -187,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"], @@ -195,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"], @@ -298,7 +297,6 @@ "uri-date" => ["contact", "uri-date"], "avatar-date" => ["contact", "avatar-date"], "thumb" => ["contact", "thumb"], - "dfrn-id" => ["contact", "dfrn-id"], "author-id" => ["post-thread-user", "author-id"], "author-link" => ["author", "url"], "author-addr" => ["author", "addr"], @@ -347,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"], @@ -443,7 +440,6 @@ "uri-date" => ["author", "uri-date"], "avatar-date" => ["author", "avatar-date"], "thumb" => ["author", "thumb"], - "dfrn-id" => ["author", "dfrn-id"], "author-id" => ["post", "author-id"], "author-link" => ["author", "url"], "author-addr" => ["author", "addr"], @@ -563,7 +559,6 @@ "uri-date" => ["author", "uri-date"], "avatar-date" => ["author", "avatar-date"], "thumb" => ["author", "thumb"], - "dfrn-id" => ["author", "dfrn-id"], "author-id" => ["post-thread", "author-id"], "author-link" => ["author", "url"], "author-addr" => ["author", "addr"], @@ -708,7 +703,6 @@ "self" => ["contact", "self"], "remote_self" => ["contact", "remote_self"], "rel" => ["contact", "rel"], - "duplex" => ["contact", "duplex"], "network" => ["contact", "network"], "protocol" => ["contact", "protocol"], "name" => ["contact", "name"], @@ -716,17 +710,14 @@ "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"], "thumb" => ["contact", "thumb"], "micro" => ["contact", "micro"], "header" => ["contact", "header"], - "site-pubkey" => ["contact", "site-pubkey"], - "issued-id" => ["contact", "issued-id"], - "dfrn-id" => ["contact", "dfrn-id"], "url" => ["contact", "url"], "nurl" => ["contact", "nurl"], "uri-id" => ["contact", "uri-id"], @@ -740,9 +731,6 @@ "poll" => ["contact", "poll"], "confirm" => ["contact", "confirm"], "poco" => ["contact", "poco"], - "aes_allow" => ["contact", "aes_allow"], - "ret-aes" => ["contact", "ret-aes"], - "usehub" => ["contact", "usehub"], "subhub" => ["contact", "subhub"], "hub-verify" => ["contact", "hub-verify"], "last-update" => ["contact", "last-update"], @@ -771,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"], @@ -840,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"], @@ -847,6 +834,7 @@ "about" => ["contact", "about"], "keywords" => ["contact", "keywords"], "xmpp" => ["contact", "xmpp"], + "matrix" => ["contact", "matrix"], "avatar" => ["contact", "avatar"], "photo" => ["contact", "photo"], "thumb" => ["contact", "thumb"], @@ -909,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" @@ -916,10 +905,12 @@ "account-user-view" => [ "fields" => [ "id" => ["ucontact", "id"], + "pid" => ["contact", "id"], "uid" => ["ucontact", "uid"], "url" => ["contact", "url"], "nurl" => ["contact", "nurl"], "uri-id" => ["contact", "uri-id"], + "guid" => ["item-uri", "guid"], "addr" => ["contact", "addr"], "alias" => ["contact", "alias"], "name" => ["contact", "name"], @@ -927,6 +918,7 @@ "about" => ["contact", "about"], "keywords" => ["contact", "keywords"], "xmpp" => ["contact", "xmpp"], + "matrix" => ["contact", "matrix"], "avatar" => ["contact", "avatar"], "photo" => ["contact", "photo"], "thumb" => ["contact", "thumb"], @@ -940,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"], @@ -956,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"], @@ -980,12 +972,6 @@ "subhub" => ["ucontact", "subhub"], "hub-verify" => ["ucontact", "hub-verify"], "reason" => ["ucontact", "reason"], - "dfrn-duplex" => ["ucontact", "duplex"], - "dfrn-ret-aes" => ["ucontact", "ret-aes"], - "dfrn-site-pubkey" => ["ucontact", "site-pubkey"], - "dfrn-issued-id" => ["ucontact", "issued-id"], - "dfrn-id" => ["ucontact", "dfrn-id"], - "dfrn-aes_allow" => ["ucontact", "aes_allow"], "dfrn-request" => ["contact", "request"], "dfrn-notify" => ["contact", "notify"], "dfrn-poll" => ["contact", "poll"], @@ -1009,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'" ], @@ -1061,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`" + ], ];