DatabaseSchema_mysql::createFieldSql
protected function DatabaseSchema_mysql::createFieldSql
protected DatabaseSchema_mysql::createFieldSql($name, $spec)
Create an SQL string for a field to be used in table creation or alteration.
Before passing a field out of a schema definition into this function it has to be processed by _db_process_field().
Parameters
$name: Name of the field.
$spec: The field specification, as per the schema data structure format.
File
- includes/database/mysql/schema.inc, line 139
- Database schema code for MySQL database servers.
Class
Code
protected function createFieldSql($name, $spec) { $sql = "`" . $name . "` " . $spec['mysql_type']; if (in_array($spec['mysql_type'], array('VARCHAR', 'CHAR', 'TINYTEXT', 'MEDIUMTEXT', 'LONGTEXT', 'TEXT'))) { if (isset($spec['length'])) { $sql .= '(' . $spec['length'] . ')'; } if (!empty($spec['binary'])) { $sql .= ' BINARY'; } } elseif (isset($spec['precision']) && isset($spec['scale'])) { $sql .= '(' . $spec['precision'] . ', ' . $spec['scale'] . ')'; } if (!empty($spec['unsigned'])) { $sql .= ' unsigned'; } if (isset($spec['not null'])) { if ($spec['not null']) { $sql .= ' NOT NULL'; } else { $sql .= ' NULL'; } } if (!empty($spec['auto_increment'])) { $sql .= ' auto_increment'; } // $spec['default'] can be NULL, so we explicitly check for the key here. if (array_key_exists('default', $spec)) { if (is_string($spec['default'])) { $spec['default'] = "'" . $spec['default'] . "'"; } elseif (!isset($spec['default'])) { $spec['default'] = 'NULL'; } $sql .= ' DEFAULT ' . $spec['default']; } if (empty($spec['not null']) && !isset($spec['default'])) { $sql .= ' DEFAULT NULL'; } // Add column comment. if (!empty($spec['description'])) { $sql .= ' COMMENT ' . $this->prepareComment($spec['description'], self::COMMENT_MAX_COLUMN); } return $sql; }
© 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::createFieldSql/7.x