• Модуль: perfmon
  • Путь к файлу: ~/bitrix/modules/perfmon/lib/sql/table.php
  • Класс: BitrixPerfmonSqlTable
  • Вызов: Table::getCreateDdl
public function getCreateDdl($dbType = '')
{
	$result = array();

	$items = array();
	/** @var Column $column */
	foreach ($this->columns->getList() as $column)
	{
		$items[] = $column->name." ".$column->body;
	}

	foreach ($this->indexes->getList() as $index)
	{
		$items[] = ($index->fulltext? "FULLTEXT ": "").($index->unique? "UNIQUE ": "")."KEY ".$index->name." (".$index->body.")";
	}

	/** @var Constraint $constraint */
	foreach ($this->constraints->getList() as $constraint)
	{
		if ($constraint->name === '')
			$items[] = $constraint->body;
		else
			$items[] = "CONSTRAINT ".$constraint->name." ".$constraint->body;
	}

	$result[] = "CREATE TABLE ".$this->name."(nt".implode(",nt", $items)."n)".$this->body;

	return $result;
}