/**
* @return string
*/
public function build()
{
$columns = [];
foreach ($this->table->getColumns() as $column) {
$columns[] = $column->toSql();
}
$indexes = [];
foreach ($this->table->getIndexes() as $index) {
$indexes[$index->getName()] = $index->toSql();
}
$foreign_keys = [];
foreach ($this->table->getForeignKeys() as $foreign_key) {
$foreign_key_constraint = join(DOT, $foreign_key->getFields());
$foreign_keys[$foreign_key_constraint] = $foreign_key->toSql();
if (!isset($indexes[$foreign_key_constraint])) {
$indexes[$foreign_key_constraint] = Index::buildLink($foreign_key_constraint)->toSql();
}
}
return 'CREATE TABLE IF NOT EXISTS ' . BQ . $this->table->getName() . BQ . ' (' . ($columns ? LF . TAB : '') . join(',' . LF . TAB, $columns) . ($indexes ? ',' . LF . TAB : '') . join(',' . LF . TAB, $indexes) . ($foreign_keys ? ',' . LF . TAB : '') . join(',' . LF . TAB, $foreign_keys) . LF . ') DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci';
}
