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