[ljcom] r10664: 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 07:55:32 UTC (rev 10663)
+++ trunk/bin/upgrading/update-db-local.pl	2011-06-20 08:05:39 UTC (rev 10664)
@@ -2097,6 +2097,11 @@
             "ALTER TABLE smsru_phones ADD added DATETIME");
     }
 
+    unless (column_type("friendstimes", "added") =~ /int/i) {
+        do_alter("friendstimes",
+            "ALTER TABLE friendstimes MODIFY added int not null");
+    }
+
 });
 
 1;  # true