protected function Schem8b7c:f320:99b9:690f:4595:cd17:293a:c069createTableSql protected Schem8b7c:f320:99b9:690f:4595:cd17:293a:c069createTableSql($name, $table) Generate SQL to create a new table from a Drupal schema definition. Parameters  $name: The name of the table to create. $table: A Schema API table definition array. Return value  An array of SQL statements to create the table. File
 core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php, line 221  Class
 
Schema  PostgreSQL implementation of \Drupal\Core\Database\Schema.  Namespace Drupal\Core\Database\Driver\pgsql Code protected function createTableSql($name, $table) {
  $sql_fields = array();
  foreach ($table['fields'] as $field_name => $field) {
    $sql_fields[] = $this->createFieldSql($field_name, $this->processField($field));
  }

  $sql_keys = array();
  if (isset($table['primary key']) && is_array($table['primary key'])) {
    $sql_keys[] = 'CONSTRAINT ' . $this->ensureIdentifiersLength($name, '', 'pkey') . ' PRIMARY KEY (' . $this->createPrimaryKeySql($table['primary key']) . ')';
  }
  if (isset($table['unique keys']) && is_array($table['unique keys'])) {
    foreach ($table['unique keys'] as $key_name => $key) {
      $sql_keys[] = 'CONSTRAINT ' . $this->ensureIdentifiersLength($name, $key_name, 'key') . ' UNIQUE (' . implode(', ', $key) . ')';
    }
  }

  $sql = "CREATE TABLE {" . $name . "} (\n\t";
  $sql .= implode(",\n\t", $sql_fields);
  if (count($sql_keys) > 0) {
    $sql .= ",\n\t";
  }
  $sql .= implode(",\n\t", $sql_keys);
  $sql .= "\n)";
  $statements[] = $sql;

  if (isset($table['indexes']) && is_array($table['indexes'])) {
    foreach ($table['indexes'] as $key_name => $key) {
      $statements[] = $this->_createIndexSql($name, $key_name, $key);
    }
  }

  // Add table comment.
  if (!empty($table['description'])) {
    $statements[] = 'COMMENT ON TABLE {' . $name . '} IS ' . $this->prepareComment($table['description']);
  }

  // Add column comments.
  foreach ($table['fields'] as $field_name => $field) {
    if (!empty($field['description'])) {
      $statements[] = 'COMMENT ON COLUMN {' . $name . '}.' . $field_name . ' IS ' . $this->prepareComment($field['description']);
    }
  }

  return $statements;
}


    
{'path': 'public/docs/drupal~8/core-lib-drupal-core-database-driver-pgsql-schema.php/function/schema-createtablesql/8.1.x.html', 'source': 'DevDocs.IO'}