Improve the test data

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

diff --git a/static/dbview.config.php b/static/dbview.config.php
index b987eab4288dbd42d7b843e7cd48d039de587242..5f9c1d34cf8a351eb8a73b33207e35f38fecc355 100644 (file)
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -106,10 +106,13 @@
                        "contact-avatar" => ["contact", "thumb"],
                        "contact-network" => ["contact", "network"],
                        "contact-blocked" => ["contact", "blocked"],
+                       "contact-hidden" => ["contact", "hidden"],
                        "contact-readonly" => ["contact", "readonly"],
+                       "contact-archive" => ["contact", "archive"],
                        "contact-pending" => ["contact", "pending"],
                        "contact-rel" => ["contact", "rel"],
                        "contact-uid" => ["contact", "uid"],
+                       "contact-contact-type" => ["contact", "contact-type"],
                        "writable" => "IF (`item`.`network` IN ('apub', 'dfrn', 'dspr', 'stat'), true, `contact`.`writable`)",
                        "self" => ["contact", "self"],
                        "cid" => ["contact", "id"],
@@ -190,7 +193,7 @@
                        LEFT JOIN `item-content` ON `item-content`.`uri-id` = `item`.`uri-id`
                        LEFT JOIN `post-delivery-data` ON `post-delivery-data`.`uri-id` = `item`.`uri-id` AND `item`.`origin`
                        LEFT JOIN `permissionset` ON `permissionset`.`id` = `item`.`psid`
-                       STRAIGHT_JOIN `item` AS `parent-item` ON `parent-item`.`id` = `item`.`parent`
+                       STRAIGHT_JOIN `item` AS `parent-item` ON `parent-item`.`uri-id` = `item`.`parent-uri-id`
                        STRAIGHT_JOIN `contact` AS `parent-item-author` ON `parent-item-author`.`id` = `parent-item`.`author-id`"
        ],
        "category-view" => [