From ff1bacd184000ff8417a34c55bb4ec112614952d Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 3 Feb 2016 16:42:12 -0800 Subject: [PATCH] Add IF EXISTS to DROP INDEX (except under MySQL) --- DBSchema/Table.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 " : ''); -- 2.11.0