[ljcom] r10826: LJSUP-9430: Additional development of da...

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

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2011-08-09 14:22:54 UTC (rev 10825)
+++ trunk/bin/upgrading/update-db-local.pl	2011-08-10 03:30:48 UTC (rev 10826)
@@ -1925,6 +1925,18 @@
                  "ALTER TABLE journal_spotlight DROP COLUMN img_url");
     }
 
+    if ( index_name("sg_invites", "UNIQUE:time") eq 'PRIMARY' ) {
+        do_alter(
+            "sg_invites",
+            "ALTER TABLE sg_invites " .
+            "DROP PRIMARY KEY, " .
+            "ADD INDEX `time_idx` (`time`), " .
+            "ADD `posted` INT(3), " .
+            "ADD INDEX `posted_idx` (`posted`)"
+
+        );
+    }
+
     unless (index_name("journal_spotlight", "UNIQUE:userid-domain") ||
             index_name("journal_spotlight", "UNIQUE:spotid") eq 'PRIMARY')
     {