Remove database update, use fallback solution instead.

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 80ce05ba0cc998f619df3b0149ba94f515e7637e..fa4f1bd58b15d92595e74a19e3766aed51dbf079 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -570,6 +570,9 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `moderated` (`moderated`),
   KEY `spam` (`spam`),
   KEY `author-name` (`author-name`),
+  KEY `uid_commented` (`uid`, `commented`),
+  KEY `uid_created` (`uid`, `created`),
+  KEY `uid_unseen` (`uid`, `unseen`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),