X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=e363dd57dda033318ca30c9137033f58f5d438bf;hb=6557efd786d2ab1f7be1a9884fb5dd2438fba0de;hp=40abb7f05624e819fa80bc44d89b5d699d0438af;hpb=bb52e5a804c069d57444a1dce60808d14492940a;p=friendica.git diff --git a/database.sql b/database.sql index 40abb7f056..e363dd57dd 100644 --- a/database.sql +++ b/database.sql @@ -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`),