Updated messages.po

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 3c2fbb3150119249ce26b6b2e4c9f2645f9b8b55..87fbd84a6103ac2373f586adf52a205553dc37b1 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2024.03-dev (Yellow Archangel)
--- DB_UPDATE_VERSION 1543
+-- DB_UPDATE_VERSION 1544
 -- ------------------------------------------
 
 
@@ -2025,6 +2025,20 @@ CREATE VIEW `circle-member-view` AS SELECT
                        INNER JOIN `contact` ON `group_member`.`contact-id` = `contact`.`id`
                        INNER JOIN `group` ON `group_member`.`gid` = `group`.`id`;
 
+--
+-- VIEW post-counts-view
+--
+DROP VIEW IF EXISTS `post-counts-view`;
+CREATE VIEW `post-counts-view` AS SELECT 
+       `post-counts`.`uri-id` AS `uri-id`,
+       `post-counts`.`vid` AS `vid`,
+       `verb`.`name` AS `verb`,
+       `post-counts`.`reaction` AS `reaction`,
+       `post-counts`.`parent-uri-id` AS `parent-uri-id`,
+       `post-counts`.`count` AS `count`
+       FROM `post-counts`
+                       INNER JOIN `verb` ON `verb`.`id` = `post-counts`.`vid`;
+
 --
 -- VIEW post-timeline-view
 --