vadvs (vadvs) wrote in changelog,
vadvs
vadvs
changelog

[ljcom] r10664: 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 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

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