PMA\libraries\Index::getFromTableByChoice PHP Метод

    public static function getFromTableByChoice($table, $schema, $choices = 31)
    {
        $indexes = array();
        foreach (self::getFromTable($table, $schema) as $index) {
            if ($choices & Index::PRIMARY && $index->getChoice() == 'PRIMARY') {
                $indexes[] = $index;
            }
            if ($choices & Index::UNIQUE && $index->getChoice() == 'UNIQUE') {
                $indexes[] = $index;
            }
            if ($choices & Index::INDEX && $index->getChoice() == 'INDEX') {
                $indexes[] = $index;
            }
            if ($choices & Index::SPATIAL && $index->getChoice() == 'SPATIAL') {
                $indexes[] = $index;
            }
            if ($choices & Index::FULLTEXT && $index->getChoice() == 'FULLTEXT') {
                $indexes[] = $index;
            }
        }
        return $indexes;
    }

 /**
  * Get columns with indexes
  *
  * @param int $types types bitmask
  *
  * @return array an array of columns
  */
 function getColumnsWithIndex($types)
 {
     $columns_with_index = array();
     foreach (Index::getFromTableByChoice($this->_name, $this->_db_name, $types) as $index) {
         $columns = $index->getColumns();
         foreach ($columns as $column_name => $dummy) {
             $columns_with_index[] = $column_name;
         }
     }
     return $columns_with_index;
 }