X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=f2c558241a0caea41409a84df988cd5173792566;hb=ad48ab29286cdc609e75b8d4412cd05d17204e82;hp=cf060ebf499ec43ae5894c8ed867ff83532e27b6;hpb=4e3d0018c69eaaa122f004357c5c68dacef59fc7;p=friendica.git diff --git a/database.sql b/database.sql index cf060ebf49..f2c558241a 100644 --- a/database.sql +++ b/database.sql @@ -591,6 +591,8 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `uid_created` (`uid`, `created`), KEY `uid_unseen` (`uid`, `unseen`), KEY `mention` (`mention`), + KEY `resource-id` (`resource-id`), + KEY `event_id` (`event-id`), FULLTEXT KEY `title` (`title`), FULLTEXT KEY `body` (`body`), FULLTEXT KEY `allow_cid` (`allow_cid`),