<?php<448901948@qq.com>
namespace think\migration\db;
use Phinx\Db\Table\Index;
class Table extends \Phinx\Db\Table
{
public function setId($id)
{
$this->options['id'] = $id;
return $this;
}
public function setPrimaryKey($key)
{
$this->options['primary_key'] = $key;
return $this;
}
public function setEngine($engine)
{
$this->options['engine'] = $engine;
return $this;
}
public function setComment($comment)
{
$this->options['comment'] = $comment;
return $this;
}
public function setCollation($collation)
{
$this->options['collation'] = $collation;
return $this;
}
public function addSoftDelete()
{
$this->addColumn(Column::timestamp('delete_time')->setNullable());
return $this;
}
public function addMorphs($name, $indexName = null)
{
$this->addColumn(Column::unsignedInteger("{$name}_id"));
$this->addColumn(Column::string("{$name}_type"));
$this->addIndex(["{$name}_id", "{$name}_type"], ['name' => $indexName]);
return $this;
}
public function addNullableMorphs($name, $indexName = null)
{
$this->addColumn(Column::unsignedInteger("{$name}_id")->setNullable());
$this->addColumn(Column::string("{$name}_type")->setNullable());
$this->addIndex(["{$name}_id", "{$name}_type"], ['name' => $indexName]);
return $this;
}
public function addTimestamps($createdAtColumnName = 'create_time', $updatedAtColumnName = 'update_time')
{
return parent::addTimestamps($createdAtColumnName, $updatedAtColumnName);
}
public function addColumn($columnName, $type = null, $options = [])
{
if ($columnName instanceof Column && $columnName->getUnique()) {
$index = new Index();
$index->setColumns([$columnName->getName()]);
$index->setType(Index::UNIQUE);
$this->addIndex($index);
}
return parent::addColumn($columnName, $type, $options);
}
public function changeColumn($columnName, $newColumnType = null, $options = [])
{
if ($columnName instanceof \Phinx\Db\Table\Column) {
return parent::changeColumn($columnName->getName(), $columnName, $options);
}
return parent::changeColumn($columnName, $newColumnType, $options);
}
}