Friendica now requires PHP 7.3 or above

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index b7217a54f6f98ca238b73b36a7af7f1086e69427..bdf928fbe563caba1858bcf4ce09b267cdca8189 100644 (file)
--- 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`