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; }