CHANGELOG updates for Feb 6th

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 7c3b67715d9f498fbb51ee5c3d870a73aaa1bdff..692b5deb70d2d593f006c591780cade3b2838b49 100644 (file)
--- 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 1449
 -- ------------------------------------------
 
 
@@ -601,6 +601,9 @@ CREATE TABLE IF NOT EXISTS `fcontact` (
        `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `pubkey` text COMMENT '',
        `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+       `interacting_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts this contact interactes with',
+       `interacted_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts that interacted with this contact',
+       `post_count` int unsigned DEFAULT 0 COMMENT 'Number of posts and comments',
         PRIMARY KEY(`id`),
         INDEX `addr` (`addr`(32)),
         UNIQUE INDEX `url` (`url`(190)),
@@ -824,7 +827,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`),
@@ -1315,8 +1319,8 @@ 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 current 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`),
@@ -1511,6 +1515,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 '',
@@ -1609,7 +1614,7 @@ CREATE VIEW `post-user-view` AS SELECT
        `post-content`.`title` AS `title`,
        `post-content`.`content-warning` AS `content-warning`,
        `post-content`.`raw-body` AS `raw-body`,
-       `post-content`.`body` AS `body`,
+       IFNULL (`post-content`.`body`, '') AS `body`,
        `post-content`.`rendered-hash` AS `rendered-hash`,
        `post-content`.`rendered-html` AS `rendered-html`,
        `post-content`.`language` AS `language`,
@@ -1701,6 +1706,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`