cakephp / phinx

            $this->getConnection()->quote($parts['table'])

        );

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

        foreach ($rows as $row) {

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

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

            }

            $indexes[$row['index_name']]['columns'][] = $row['column_name'];

        }

        return $indexes;

    }

    {

        $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;

    }