Пример #1
0
 public static function listTableIndexes($table)
 {
     $keyName = 'Key_name';
     $nonUnique = 'Non_unique';
     $keyName = strtolower($keyName);
     $nonUnique = strtolower($nonUnique);
     $table = Soup_Inflector::quoteIdentifier($table);
     $query = 'SHOW INDEX FROM ' . $table;
     $indexes = Soup_Query::query($query);
     $result = array();
     foreach ($indexes as $indexData) {
         if ($indexData[$nonUnique] && ($index = Soup_Inflector::fixIndexName($indexData[$keyName]))) {
             $result[] = $index;
         }
     }
     return $result;
 }