From 1db55bca09b6ac8e3cdcd4c1196269f8d33147e1 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 3 Feb 2016 16:43:45 -0800
Subject: [PATCH] Add IF EXISTS to DROP INDEX (except under MySQL)

---
 DBSchema/Table.pm | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

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