DrupalAPI.de

1. drupal
   1. drupal7

Build the SQL expression for creating columns.

Verwandte Themen

Schema API

A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.

Code

includes/database/sqlite/schema.inc, line 64

<?php
protected function createColumsSql($tablename, $schema) {
  $sql_array = array();

  // Add the SQL statement for each field.
  foreach ($schema['fields'] as $name => $field) {
    if ($field['type'] == 'serial') {
      if (isset($schema['primary key']) && ($key = array_search($name, $schema['primary key'])) !== FALSE) {
        unset($schema['primary key'][$key]);
      }
    }
    $sql_array[] = $this->createFieldSql($name, $this->processField($field));
  }

  // Process keys.
  if (!empty($schema['primary key'])) {
    $sql_array[] = " PRIMARY KEY (" . $this->createKeySql($schema['primary key']) . ")";
  }

  return implode(", \n", $sql_array);
}
?>