Connection::createIndex

public function createIndex($tableName, $indexName, $columnNames)
{
	if (!is_array($columnNames))
	{
		$columnNames = array($columnNames);
	}

	$sqlHelper = $this->getSqlHelper();

	foreach ($columnNames as &$columnName)
	{
		$columnName = $sqlHelper->quote($columnName);
	}
	unset($columnName);

	$sql = 'CREATE INDEX '.$sqlHelper->quote($indexName).' ON '.$sqlHelper->quote($tableName).' ('.join(', ', $columnNames).')';

	return $this->query($sql);
}