X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=DBSchema%2FTable.pm;fp=DBSchema%2FTable.pm;h=aec605f4f2dd43f2bf541697e8880afecb6aced8;hb=0f550d6bc09800bece04902f46a521ca3b3282ab;hp=67e2eeaa6f42292acb4846b5fda747cfbc878746;hpb=92bc6dc81a74a727c8cc18e04fbdc1fee871855b;p=DBIx-DBSchema.git

diff --git a/DBSchema/Table.pm b/DBSchema/Table.pm
index 67e2eea..aec605f 100644
--- a/DBSchema/Table.pm
+++ b/DBSchema/Table.pm
@@ -631,8 +631,10 @@ sub sql_alter_table {
     warn "removing obsolete index $table.$old ON ( ".
          $old_indices{$old}->columns_sql. " )\n"
       if $DEBUG > 1;
-    push @r, "DROP INDEX $old ".
-             ( $driver eq 'mysql' ? " ON $table" : ' IF EXISTS');
+    push @r, "DROP INDEX '.
+             ( $driver ne 'mysql' ? ' IF EXISTS ' : '');
+             " $old ".
+             ( $driver eq 'mysql' ? " ON $table " : '');
   }
 
   foreach my $new ( keys %new_indices ) {