add event-id index to prevent large CPU loads when visiting the events page

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 28a7c931e77b97f3360313b06f9209411480ca71..6a4782fb89cccf31ba98d38b8163a00a05356ec7 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -589,6 +589,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `uid_commented` (`uid`, `commented`),
   KEY `uid_created` (`uid`, `created`),
   KEY `uid_unseen` (`uid`, `unseen`),
+  KEY `event_id` (`event-id`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),