X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=bdf928fbe563caba1858bcf4ce09b267cdca8189;hb=3d65809a82b5c357887f5b98ab722464a74ee828;hp=fbccddcb281da5145efbcbdfe0f23adead4df25d;hpb=a911e8eefdb755436c951450bc6b61c49b3fa490;p=friendica.git diff --git a/database.sql b/database.sql index fbccddcb28..bdf928fbe5 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 2021.12-dev (Siberian Iris) --- DB_UPDATE_VERSION 1443 +-- Friendica 2021.12-rc (Siberian Iris) +-- 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`