X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=bdf928fbe563caba1858bcf4ce09b267cdca8189;hb=f4907a48d8a93dcba3a6f3d21b5e741cc00d5102;hp=b7217a54f6f98ca238b73b36a7af7f1086e69427;hpb=e251f8f60fe67c9c499aa399a83d9f98a98bbc7c;p=friendica.git diff --git a/database.sql b/database.sql index b7217a54f6..bdf928fbe5 100644 --- a/database.sql +++ b/database.sql @@ -1,7 +1,10 @@ -- ------------------------------------------ --- Friendica 2021.12-dev (Siberian Iris) --- DB_UPDATE_VERSION 1443 +-- Friendica 2021.12-rc (Siberian Iris) +-- DB_UPDATE_VERSION 1445 -- ------------------------------------------ + + +-- -- TABLE gserver -- CREATE TABLE IF NOT EXISTS `gserver` ( @@ -1508,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 '', @@ -1698,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`