cakephp / phinx

     * @param string $tableName Table Name

     * @return array

     */

    protected function getIndexes($tableName)

    {

        $indexes = [];

        $rows = $this->fetchAll(sprintf('SHOW INDEXES FROM %s', $this->quoteTableName($tableName)));

        foreach ($rows as $row) {

            if (!isset($indexes[$row['Key_name']])) {

                $indexes[$row['Key_name']] = ['columns' => []];

            }

            $indexes[$row['Key_name']]['columns'][] = strtolower($row['Column_name']);

        }

        return $indexes;

    }

    /**

     * {@inheritdoc}

     * @param string $tableName Table Name

     * @return array

     */

    public function getIndexes($tableName)

    {

        $indexes = [];

        $sql = "SELECT index_owner as owner,index_name,column_name FROM ALL_IND_COLUMNS 

                WHERE TABLE_NAME = '$tableName'";

        $rows = $this->fetchAll($sql);

        foreach ($rows as $row) {

            if (!isset($indexes[$row['INDEX_NAME']])) {

                $indexes[$row['INDEX_NAME']] = ['columns' => []];

            }

            $indexes[$row['INDEX_NAME']]['columns'][] = strtoupper($row['COLUMN_NAME']);

        }

        return $indexes;

    }

    /**

     * {@inheritdoc}