DatabaseSchema_mysql::fieldSetDefault
public function DatabaseSchema_mysql::fieldSetDefault
public DatabaseSchema_mysql::fieldSetDefault($table, $field, $default)
Set the default value for a field.
Parameters
$table: The table to be altered.
$field: The field to be altered.
$default: Default value to be set. NULL for 'default NULL'.
Throws
DatabaseSchemaObjectDoesNotExistException If the specified table or field doesn't exist.
Overrides DatabaseSchema::fieldSetDefault
File
- includes/database/mysql/schema.inc, line 370
- Database schema code for MySQL database servers.
Class
Code
public function fieldSetDefault($table, $field, $default) { if (!$this->fieldExists($table, $field)) { throw new DatabaseSchemaObjectDoesNotExistException(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); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!mysql!schema.inc/function/DatabaseSchema_mysql::fieldSetDefault/7.x