]> git.mxchange.org Git - friendica.git/blobdiff - database.sql
Merge pull request #11882 from annando/warnings
[friendica.git] / database.sql
index 40abb7f05624e819fa80bc44d89b5d699d0438af..e363dd57dda033318ca30c9137033f58f5d438bf 100644 (file)
@@ -1416,6 +1416,7 @@ CREATE TABLE IF NOT EXISTS `post-user` (
         INDEX `author-id_uid` (`author-id`,`uid`),
         INDEX `author-id_received` (`author-id`,`received`),
         INDEX `parent-uri-id_uid` (`parent-uri-id`,`uid`),
+        INDEX `uid_wall_received` (`uid`,`wall`,`received`),
         INDEX `uid_contactid` (`uid`,`contact-id`),
         INDEX `uid_unseen_contactid` (`uid`,`unseen`,`contact-id`),
         INDEX `uid_unseen` (`uid`,`unseen`),