| public alterColumn ( string $table, string $column, string $type ) | ||
| $table | string | the table whose column is to be changed. The table name will be properly quoted by the method. |
| $column | string | the name of the column to be changed. The name will be properly quoted by the method. |
| $type | string | the new column type. The [[QueryBuilder::getColumnType()]] method will be invoked to convert abstract column type (if any) into the physical one. Anything that is not recognized as abstract type will be kept in the generated SQL. For example, 'string' will be turned into 'varchar(255)', while 'string not null' will become 'varchar(255) not null'. |
public function alterColumn($table, $column, $type)
{
echo " > alter column {$column} in table {$table} to {$type} ...";
$time = microtime(true);
$this->db->createCommand()->alterColumn($table, $column, $type)->execute();
if ($type instanceof ColumnSchemaBuilder && $type->comment !== null) {
$this->db->createCommand()->addCommentOnColumn($table, $column, $type->comment)->execute();
}
echo ' done (time: ' . sprintf('%.3f', microtime(true) - $time) . "s)\n";
} /**
* @inheritdoc
* Note: table will be auto pefixied if [[$autoWrapTableNames]] is true.
*/
public function alterColumn($table, $column, $type)
{
$table = $this->autoWrappedTableName($table);
return parent::alterColumn($table, $column, $type);
}
