X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=175c48b8c3f88e4c069e3627703c44dedd2cac93;hb=e61ed419728999fcdaf8c79597b0490655e69867;hp=b7217a54f6f98ca238b73b36a7af7f1086e69427;hpb=e251f8f60fe67c9c499aa399a83d9f98a98bbc7c;p=friendica.git

diff --git a/database.sql b/database.sql
index b7217a54f6..175c48b8c3 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 1447
 -- ------------------------------------------
+
+
+--
 -- TABLE gserver
 --
 CREATE TABLE IF NOT EXISTS `gserver` (
@@ -821,7 +824,8 @@ CREATE TABLE IF NOT EXISTS `notification` (
 	`target-uri-id` int unsigned COMMENT 'Item-uri id of the related post',
 	`parent-uri-id` int unsigned COMMENT 'Item-uri id of the parent of the related post',
 	`created` datetime COMMENT '',
-	`seen` boolean DEFAULT '0' COMMENT '',
+	`seen` boolean DEFAULT '0' COMMENT 'Seen on the desktop',
+	`dismissed` boolean DEFAULT '0' COMMENT 'Dismissed via the API',
 	 PRIMARY KEY(`id`),
 	 UNIQUE INDEX `uid_vid_type_actor-id_target-uri-id` (`uid`,`vid`,`type`,`actor-id`,`target-uri-id`),
 	 INDEX `vid` (`vid`),
@@ -1508,6 +1512,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 +1703,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`