From: Ivan Kohler <ivan@freeside.biz>
Date: Thu, 4 Feb 2016 00:42:12 +0000 (-0800)
Subject: Add IF EXISTS to DROP INDEX (except under MySQL)
X-Git-Url: http://git.freeside.biz/gitweb/?p=DBIx-DBSchema.git;a=commitdiff_plain;h=ff1bacd184000ff8417a34c55bb4ec112614952d

Add IF EXISTS to DROP INDEX (except under MySQL)
---

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