]> git.mxchange.org Git - friendica.git/blobdiff - database.sql
bump version 2024.03-dev
[friendica.git] / database.sql
index 134d1f82619bb729f2abada5414666a6e025cfa0..f114bb5bfd0eda9f5c3486249451d5853b0d0d1b 100644 (file)
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 2023.09-rc (Giant Rhubarb)
--- DB_UPDATE_VERSION 1541
+-- Friendica 2023.12 (Yellow archangel)
+-- DB_UPDATE_VERSION 1542
 -- ------------------------------------------
 
 
@@ -1601,8 +1601,12 @@ CREATE TABLE IF NOT EXISTS `post-thread-user` (
         INDEX `uid_received` (`uid`,`received`),
         INDEX `uid_wall_received` (`uid`,`wall`,`received`),
         INDEX `uid_commented` (`uid`,`commented`),
+        INDEX `uid_created` (`uid`,`created`),
         INDEX `uid_starred` (`uid`,`starred`),
         INDEX `uid_mention` (`uid`,`mention`),
+        INDEX `contact-id_commented` (`contact-id`,`commented`),
+        INDEX `contact-id_received` (`contact-id`,`received`),
+        INDEX `contact-id_created` (`contact-id`,`created`),
        FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`conversation-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
        FOREIGN KEY (`owner-id`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE RESTRICT,