X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=b133489e4e3e6b8cf224b045914d5f1fdbe297c7;hb=bb59f105e719ef420a5cd0dcacfa3e3955dc5a0c;hp=64d8d9f7d0cd605d3e5cc69a164241ca30e24b8b;hpb=be7041c3e06ee5a799851ac3612849dde55a8198;p=friendica.git diff --git a/database.sql b/database.sql index 64d8d9f7d0..b133489e4e 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 3.5.1-dev (Asparagus) --- DB_UPDATE_VERSION 1213 +-- Friendica 3.5.1-rc (Asparagus) +-- DB_UPDATE_VERSION 1215 -- ------------------------------------------ @@ -532,6 +532,7 @@ CREATE TABLE IF NOT EXISTS `item` ( INDEX `parent-uri` (`parent-uri`), INDEX `extid` (`extid`), INDEX `uid_id` (`uid`,`id`), + INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`), INDEX `uid_created` (`uid`,`created`), INDEX `uid_unseen_contactid` (`uid`,`unseen`,`contact-id`), INDEX `uid_network_received` (`uid`,`network`,`received`), @@ -1016,7 +1017,8 @@ CREATE TABLE IF NOT EXISTS `thread` ( INDEX `uid_contactid_commented` (`uid`,`contact-id`,`commented`), INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`), INDEX `uid_created` (`uid`,`created`), - INDEX `uid_commented` (`uid`,`commented`) + INDEX `uid_commented` (`uid`,`commented`), + INDEX `uid_wall_created` (`uid`,`wall`,`created`) ) DEFAULT CHARSET=utf8mb4; --