Helper::checkIndexNameExists

static function checkIndexNameExists($indexName, $tableName)
{
	$dbConnection = MainHttpApplication::getConnection();
	$dbHelper = $dbConnection->getSqlHelper();

	$indexName = trim((string)$indexName);
	$tableName = $dbHelper->forSql(trim((string)$tableName));

	if ($indexName === '' || $tableName === '')
	{
		return false;
	}

	$res = $dbConnection->query("show index from ".$tableName);

	while($item = $res->fetch())
	{
		if (isset($item['Key_name']) && $item['Key_name'] === $indexName)
		{
			return true;
		}
		if (isset($item['KEY_NAME']) && $item['KEY_NAME'] === $indexName)
		{
			return true;
		}
	}

	return false;
}