• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/internals/database/helper/common.php
  • Класс: BitrixTasksInternalsDataBaseHelperCommon
  • Вызов: Common::addPrimaryKey
static function addPrimaryKey($tableName, $columns = array())
{
	if(!strlen($tableName) || !is_array($columns) || empty($columns))
		return false;

	$dbConnection = MainHttpApplication::getConnection();
	$dbHelper = $dbConnection->getSqlHelper();

	$tableName = $dbHelper->forSql($tableName);
	$columns = static::escapeArray($columns);

	$dbConnection->query("ALTER TABLE ".$tableName." ADD CONSTRAINT PK_".ToUpper($tableName)." PRIMARY KEY (".implode(', ', $columns).")");

	return true;
}