projects
/
DBIx-DBSchema.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Add IF EXISTS to DROP INDEX (except under MySQL)
[DBIx-DBSchema.git]
/
DBSchema
/
Table.pm
diff --git
a/DBSchema/Table.pm
b/DBSchema/Table.pm
index
ef51928
..
67e2eea
100644
(file)
--- a/
DBSchema/Table.pm
+++ b/
DBSchema/Table.pm
@@
-7,7
+7,7
@@
use DBIx::DBSchema::Column 0.14;
use DBIx::DBSchema::Index;
use DBIx::DBSchema::ForeignKey 0.13;
use DBIx::DBSchema::Index;
use DBIx::DBSchema::ForeignKey 0.13;
-our $VERSION = '0.1
1
';
+our $VERSION = '0.1
2
';
our $DEBUG = 0;
=head1 NAME
our $DEBUG = 0;
=head1 NAME
@@
-631,8
+631,8
@@
sub sql_alter_table {
warn "removing obsolete index $table.$old ON ( ".
$old_indices{$old}->columns_sql. " )\n"
if $DEBUG > 1;
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" : '');
+ push @r, "DROP INDEX $old
".
+ ( $driver eq 'mysql' ? " ON $table" : '
IF EXISTS
');
}
foreach my $new ( keys %new_indices ) {
}
foreach my $new ( keys %new_indices ) {