[ljcom] r10663: LJSUP-9024: add index to friendstimes ta...

U   trunk/bin/upgrading/update-db-local.pl

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2011-06-20 06:58:31 UTC (rev 10662)
+++ trunk/bin/upgrading/update-db-local.pl	2011-06-20 07:55:32 UTC (rev 10663)
@@ -1598,8 +1598,8 @@
     jitemid             INT(10) UNSIGNED NOT NULL, 
     added               DATETIME NOT NULL,
 
-    UNIQUE INDEX(userid, journalid, jitemid)
-
+    UNIQUE INDEX(userid, journalid, jitemid),
+    INDEX(userid, added DESC)
     ) TYPE=InnoDB
 EOC