API: Added trending links

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index cccb233d37e7642a62dcea2e596d6f6fe3be3166..c68ae094c1aa5e11f531e980a9ae27fcebb663fa 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -2438,6 +2438,7 @@ CREATE VIEW `post-thread-view` AS SELECT
        0 AS `has-categories`,
        EXISTS(SELECT `id` FROM `post-media` WHERE `post-media`.`uri-id` = `post-thread`.`uri-id`) AS `has-media`,
        (SELECT COUNT(*) FROM `post` WHERE `parent-uri-id` = `post-thread`.`uri-id` AND `gravity` = 6) AS `total-comments`,
+       (SELECT COUNT(DISTINCT(`author-id`)) FROM `post` WHERE `parent-uri-id` = `post-thread`.`uri-id` AND `gravity` = 6) AS `total-actors`,
        `diaspora-interaction`.`interaction` AS `signed_text`,
        `parent-item-uri`.`guid` AS `parent-guid`,
        `parent-post`.`network` AS `parent-network`,