protected function appendIndexes()
{
foreach ($this->table->indexes as $index) {
$columns = Symbol::prepareColumns($index->columns);
if ($index->type === Index::TYPE_KEY) {
$createIndex = new SimpleExpression("CREATE INDEX ? ON ? (?)", new Symbol($index->getName()), new Symbol($this->table->schemaName), $columns);
$createIndex->bindDatabase($this->database());
$this->add($createIndex);
//$this->appendExpr(' KEY ? (?),' . PHP_EOL, new Symbol($index->getName()), $columns);
} elseif ($index->type === Index::TYPE_UNIQUE) {
$this->createLines->commaExpr(' CONSTRAINT ? UNIQUE (?)', new Symbol($index->getName()), $columns);
}
}
}
public function extractForeignKeysStatement()
{
$alterExpression = new SimpleExpression('ALTER TABLE ?' . PHP_EOL, new Symbol($this->after->schemaName));
$alterExpression->bindDatabase($this->database());
$alterExpression->appendExpr(clone $this->addFkExpression);
$this->addFkExpression->disable();
return $alterExpression;
}
