X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=12ad6eb2c309b1ecbb32e4994af77f2a21df8c41;hb=452cd57437f296ec048c66cb493ec02688ff629b;hp=fbccddcb281da5145efbcbdfe0f23adead4df25d;hpb=a911e8eefdb755436c951450bc6b61c49b3fa490;p=friendica.git diff --git a/database.sql b/database.sql index fbccddcb28..12ad6eb2c3 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2021.12-dev (Siberian Iris) --- DB_UPDATE_VERSION 1443 +-- DB_UPDATE_VERSION 1445 -- ------------------------------------------ @@ -1511,6 +1511,7 @@ CREATE TABLE IF NOT EXISTS `user-contact` ( `blocked` boolean COMMENT 'Contact is completely blocked for this user', `ignored` boolean COMMENT 'Posts from this contact are ignored', `collapsed` boolean COMMENT 'Posts from this contact are collapsed', + `hidden` boolean COMMENT 'This contact is hidden from the others', `pending` boolean COMMENT '', `rel` tinyint unsigned COMMENT 'The kind of the relation between the user and the contact', `info` mediumtext COMMENT '', @@ -1701,6 +1702,7 @@ 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`.`nick` AS `parent-author-nick`, `parent-post-author`.`network` AS `parent-author-network`, `parent-post-author`.`blocked` AS `parent-author-blocked`, `parent-post-author`.`hidden` AS `parent-author-hidden`