X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=c337df586eca26066a5c62a696cd9166313351f1;hb=152efdaec5c04dbef27218cce027b9e633df7bca;hp=4a36384d92f3d80cc79d6d783930be5dba4779da;hpb=140886a6a50307ffa527a0f1b2650c40e7c2bf36;p=friendica.git diff --git a/database.sql b/database.sql index 4a36384d92..c337df586e 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 3.5-dev (Asparagus) --- DB_UPDATE_VERSION 1197 +-- DB_UPDATE_VERSION 1198 -- ------------------------------------------ @@ -523,6 +523,8 @@ CREATE TABLE IF NOT EXISTS `item` ( INDEX `uid_parenturi` (`uid`,`parent-uri`), INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`), INDEX `gcontactid_uid_created` (`gcontact-id`,`uid`,`created`), + INDEX `authorid_created` (`author-id`,`created`), + INDEX `ownerid_created` (`owner-id`,`created`), INDEX `wall_body` (`wall`,`body`(6)), INDEX `uid_visible_moderated_created` (`uid`,`visible`,`moderated`,`created`), INDEX `uid_uri` (`uid`,`uri`),