| @@ 520-527 (lines=8) @@ | ||
| 517 | $indexes = $this->getIndexes( $tableName ); |
|
| 518 | $columns = array_map( 'strtolower', $columns ); |
|
| 519 | ||
| 520 | foreach ( $indexes as $indexName => $index ) { |
|
| 521 | if ( $columns == $index['columns'] ) { |
|
| 522 | return new AlterInstructions( [ |
|
| 523 | sprintf( |
|
| 524 | 'DROP INDEX %s', |
|
| 525 | $this->quoteColumnName( $indexName ) |
|
| 526 | ) |
|
| 527 | ] ); |
|
| 528 | } |
|
| 529 | } |
|
| 530 | ||
| @@ 544-551 (lines=8) @@ | ||
| 541 | ||
| 542 | $indexes = $this->getIndexes( $tableName ); |
|
| 543 | ||
| 544 | foreach ( $indexes as $name => $index ) { |
|
| 545 | if ( $name === $indexName ) { |
|
| 546 | return new AlterInstructions( [ |
|
| 547 | sprintf( |
|
| 548 | 'DROP INDEX %s', |
|
| 549 | $this->quoteColumnName( $indexName ) |
|
| 550 | ) |
|
| 551 | ] ); |
|
| 552 | } |
|
| 553 | } |
|
| 554 | ||