DrupalAPI.de

1. drupal
   1. drupal7

Generate SQL to create a new table from a Drupal schema definition.

Übergabeparameter

$name The name of the table to create.

$table A Schema API table definition array.

Rückgabewert

An array of SQL statements to create the table.

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/mysql/schema.inc, line 61

<?php
protected function createTableSql($name, $table) {
  // Provide some defaults if needed
  $table += array(
      'mysql_engine' => 'InnoDB',
      'mysql_character_set' => 'UTF8',
    );

  $sql = "CREATE TABLE {" . $name . "} (\n";

  // Add the SQL statement for each field.
  foreach ($table['fields'] as $field_name => $field) {
    $sql .= $this->createFieldSql($field_name, $this->processField($field)) . ", \n";
  }

  // Process keys & indexes.
  $keys = $this->createKeysSql($table);
  if (count($keys)) {
    $sql .= implode(", \n", $keys) . ", \n";
  }

  // Remove the last comma and space.
  $sql = substr($sql, 0, -3) . "\n) ";

  $sql .= 'ENGINE = ' . $table['mysql_engine'] . ' DEFAULT CHARACTER SET ' . $table['mysql_character_set'];

  // Add table comment.
  if (!empty($table['description'])) {
    $sql .= ' COMMENT ' . $this->prepareComment($table['description'], self::COMMENT_MAX_TABLE);
  }

  return array($sql);
}
?>