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