vadvs (vadvs) wrote in changelog,
vadvs
vadvs
changelog

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

Committer: vsukhanov
LJSUP-9024: add index to friendstimes table
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
 

Tags: ljcom, pl, vadvs
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments