X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=bdf928fbe563caba1858bcf4ce09b267cdca8189;hb=34260fc619af9561e0b6ed357ee061618e83b239;hp=9b19517bb90d12115160515dc55d8488d0bb114a;hpb=6730430919a8c2d93f70397d9a2d4374a5001653;p=friendica.git

diff --git a/database.sql b/database.sql
index 9b19517bb9..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
 -- ------------------------------------------
 
 
@@ -1315,11 +1315,11 @@ CREATE TABLE IF NOT EXISTS `post-user-notification` (
 -- TABLE process
 --
 CREATE TABLE IF NOT EXISTS `process` (
-	`pid` int unsigned NOT NULL COMMENT 'The process ID of the current node',
-	`hostname` varchar(32) NOT NULL COMMENT 'The hostname of the node',
+	`pid` int unsigned NOT NULL COMMENT 'The ID of the process',
+	`hostname` varchar(32) NOT NULL COMMENT 'The name of the host the process is ran on',
 	`command` varbinary(32) NOT NULL DEFAULT '' COMMENT '',
 	`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
-	 PRIMARY KEY(`pid`, `hostname`),
+	 PRIMARY KEY(`pid`,`hostname`),
 	 INDEX `command` (`command`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Currently running system processes';
 
@@ -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`