X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=b66568ddf7fb711fb7240e76358ea72e998f4ed9;hb=618903fef7b374fdc67873b150aad5234f018cc2;hp=9567b7ac1b8b8517a4a1e11052f0ad65e34c1bac;hpb=2e05dac7dae0a3d028b442a2d5afbd4176a32e99;p=friendica.git

diff --git a/database.sql b/database.sql
index 9567b7ac1b..b66568ddf7 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 2021.12-dev (Siberian Iris)
--- DB_UPDATE_VERSION 1444
+-- 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`),
@@ -1702,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`