cakephp /
phinx
| @@ 710-726 (lines=17) @@ | ||
| 707 | /** |
|
| 708 | * {@inheritdoc} |
|
| 709 | */ |
|
| 710 | public function dropIndexByName($tableName, $indexName) |
|
| 711 | { |
|
| 712 | $indexes = $this->getIndexes($tableName); |
|
| 713 | ||
| 714 | foreach ($indexes as $name => $index) { |
|
| 715 | if ($name === $indexName) { |
|
| 716 | $this->execute( |
|
| 717 | sprintf( |
|
| 718 | 'DROP INDEX %s ON %s', |
|
| 719 | $this->quoteColumnName($indexName), |
|
| 720 | $this->quoteTableName($tableName) |
|
| 721 | ) |
|
| 722 | ); |
|
| 723 | ||
| 724 | return; |
|
| 725 | } |
|
| 726 | } |
|
| 727 | } |
|
| 728 | ||
| 729 | /** |
|
| @@ 576-593 (lines=18) @@ | ||
| 573 | /** |
|
| 574 | * {@inheritdoc} |
|
| 575 | */ |
|
| 576 | public function dropIndexByName($tableName, $indexName) |
|
| 577 | { |
|
| 578 | $indexes = $this->getIndexes($tableName); |
|
| 579 | ||
| 580 | foreach ($indexes as $name => $index) { |
|
| 581 | //$a = array_diff($columns, $index['columns']); |
|
| 582 | if ($name === $indexName) { |
|
| 583 | $this->execute( |
|
| 584 | sprintf( |
|
| 585 | 'ALTER TABLE %s DROP INDEX %s', |
|
| 586 | $this->quoteTableName($tableName), |
|
| 587 | $this->quoteColumnName($indexName) |
|
| 588 | ) |
|
| 589 | ); |
|
| 590 | ||
| 591 | return; |
|
| 592 | } |
|
| 593 | } |
|
| 594 | } |
|
| 595 | ||
| 596 | /** |
|
| @@ 616-631 (lines=16) @@ | ||
| 613 | /** |
|
| 614 | * {@inheritdoc} |
|
| 615 | */ |
|
| 616 | public function dropIndexByName($tableName, $indexName) |
|
| 617 | { |
|
| 618 | $indexes = $this->getIndexes($tableName); |
|
| 619 | ||
| 620 | foreach ($indexes as $index) { |
|
| 621 | if ($indexName === $index['index']) { |
|
| 622 | $this->execute( |
|
| 623 | sprintf( |
|
| 624 | 'DROP INDEX %s', |
|
| 625 | $this->quoteColumnName($indexName) |
|
| 626 | ) |
|
| 627 | ); |
|
| 628 | ||
| 629 | return; |
|
| 630 | } |
|
| 631 | } |
|
| 632 | } |
|
| 633 | ||
| 634 | /** |
|
