diff options
Diffstat (limited to 'checksetup.pl')
-rwxr-xr-x | checksetup.pl | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/checksetup.pl b/checksetup.pl index 681d9bde3..35e7f2d39 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3443,6 +3443,15 @@ if (GetFieldDef("products", "product")) { } print "Fixing Indexes and Uniqueness.\n"; $dbh->do("ALTER TABLE milestones DROP INDEX product"); + + # mkanat@kerio.com - bug 244756 + # Silently drop the PRIMARY key if a buggy mysqldump has put it there. + # Don't print any error messages if the index isn't there. + my $originalprintwarn = $dbh->{'PrintWarn'}; + $dbh->{'PrintWarn'} = 0; + $dbh->do("ALTER TABLE milestones DROP INDEX PRIMARY"); + $dbh->{'PrintWarn'} = $originalprintwarn; + $dbh->do("ALTER TABLE milestones ADD UNIQUE (product_id, value)"); $dbh->do("ALTER TABLE bugs DROP INDEX product"); $dbh->do("ALTER TABLE bugs ADD INDEX (product_id)"); |