X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=fa4f1bd58b15d92595e74a19e3766aed51dbf079;hb=e6067e6694450e03d75e5d6f1b2477b393bc5d2d;hp=1d0a321760cbe9c3b77baf5d020d80b7ac81841a;hpb=bfca7f47ef1f986ea8515d23c3c1962c7fe3a298;p=friendica.git

diff --git a/database.sql b/database.sql
index 1d0a321760..fa4f1bd58b 100644
--- a/database.sql
+++ b/database.sql
@@ -456,6 +456,7 @@ CREATE TABLE IF NOT EXISTS `hook` (
   `hook` char(255) NOT NULL,
   `file` char(255) NOT NULL,
   `function` char(255) NOT NULL,
+  `priority` int(11) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
@@ -569,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`),