Set the default value for a field.
$table: The table to be altered.
$field: The field to be altered.
$default: Default value to be set. NULL for 'default NULL'.
Drupal\Core\Database\SchemaObjectDoesNotExistException If the specified table or field doesn't exist.
Overrides Schema::fieldSetDefault
public function fieldSetDefault($table, $field, $default) {
if (!$this
->fieldExists($table, $field)) {
throw new SchemaObjectDoesNotExistException(t("Cannot set default value of field @table.@field: field doesn't exist.", array(
'@table' => $table,
'@field' => $field,
)));
}
if (!isset($default)) {
$default = 'NULL';
}
else {
$default = is_string($default) ? "'{$default}'" : $default;
}
$this->connection
->query('ALTER TABLE {' . $table . '} ALTER COLUMN `' . $field . '` SET DEFAULT ' . $default);
}