public function saveColumn(Column $column)
{
if ($column->isSynced()) {
return $this;
}
$syncedCol = $column->getTable()->getColumn($column->getName())->load();
if ($column->equals($syncedCol, false)) {
return $this;
}
$sql = $this->getColumnSql($column);
$name = $this->quoteName($column->getDatabase(), $column->getTable());
if ($syncedCol->isUnique() && !$column->isUnique()) {
$this->dropUniqueIndex($syncedCol);
}
$this->query("ALTER TABLE {$name} MODIFY {$sql}");
/* Drop/Add UNIQUE if needed */
if (!$syncedCol->isUnique() && $column->isUnique()) {
$this->addUniqueIndex($column);
}
/* Drop PRIMARY if needed (It gets added through getColumnSql() and the PRIMARY KEY addon) */
if ($syncedCol->isPrimary() && !$column->isPrimary()) {
$this->query("ALTER TABLE {$name} DROP PRIMARY KEY");
}
/* Add INDEX if needed */
if (!$syncedCol->isIndex() && $column->isIndex()) {
$this->addIndex($column);
}
/* Drop/Add CONSTRAINTS if needed */
$syncedRef = $syncedCol->getReference();
$colRef = $column->getReference();
$refChanged = $colRef && $syncedRef && !$colRef->equals($syncedRef);
if ($syncedRef && !$colRef || $colRef && !$syncedRef || $refChanged) {
if ($syncedRef && !$colRef || $refChanged) {
$this->dropConstraint($syncedCol);
}
if ($colRef && !$syncedRef || $refChanged) {
$this->addConstraint($column);
}
}
/* Drop INDEX if needed */
if ($syncedCol->isIndex() && !$column->isIndex()) {
$this->dropIndex($column);
}
return $this;
}
