X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=202d5365523d77b093bc95ef0ad8ff11ffe55683;hb=5b2a006c7098a2c1a9f6b5180abf75afd1330972;hp=3e6d398cf1b9b9fe5a960e41550a4cf972ea91b1;hpb=6f44476c567165a6c244bedde9f7548070393315;p=friendica.git diff --git a/database.sql b/database.sql index 3e6d398cf1..202d536552 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2021.06-rc (Siberian Iris) --- DB_UPDATE_VERSION 1419 +-- DB_UPDATE_VERSION 1420 -- ------------------------------------------ @@ -1685,7 +1685,9 @@ CREATE VIEW `post-user-view` AS SELECT `parent-post`.`author-id` AS `parent-author-id`, `parent-post-author`.`url` AS `parent-author-link`, `parent-post-author`.`name` AS `parent-author-name`, - `parent-post-author`.`network` AS `parent-author-network` + `parent-post-author`.`network` AS `parent-author-network`, + `parent-post-author`.`blocked` AS `parent-author-blocked`, + `parent-post-author`.`hidden` AS `parent-author-hidden` FROM `post-user` STRAIGHT_JOIN `post-thread-user` ON `post-thread-user`.`uri-id` = `post-user`.`parent-uri-id` AND `post-thread-user`.`uid` = `post-user`.`uid` STRAIGHT_JOIN `contact` ON `contact`.`id` = `post-user`.`contact-id`