Fix drop indexes for uniq constraints

[dbsrgits/SQL-Translator.git] / lib / SQL / Translator / Producer / MySQL.pm

diff --git a/lib/SQL/Translator/Producer/MySQL.pm b/lib/SQL/Translator/Producer/MySQL.pm
index 9b65bb7..22d0e37 100644 (file)
--- a/lib/SQL/Translator/Producer/MySQL.pm
+++ b/lib/SQL/Translator/Producer/MySQL.pm
@@ -502,7 +502,7 @@ sub alter_drop_constraint
 
     my $out = sprintf('ALTER TABLE %s DROP %s %s',
                       $c->table->name,
-                      $c->type,
+                      $c->type eq FOREIGN_KEY ? $c->type : "INDEX",
                       $qc . $c->name . $qc );
 
     return $out;