function db_add_primary_key

7.x database.inc	`db_add_primary_key($table, $fields)`
6.x database.pgsql.inc	`db_add_primary_key(&$ret, $table, $fields)`
6.x database.mysql-common.inc	`db_add_primary_key(&$ret, $table, $fields)`

Add a primary key.

Parameters

$ret: Array to which query results will be added.

$table: The table to be altered.

$fields: Fields for the primary key.

Related topics

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.

7 calls to db_add_primary_key()

system_update_6001 in drupal-6.x/modules/system/system.install: Add version id column to {term_node} to allow taxonomy module to use revisions.
system_update_6002 in drupal-6.x/modules/system/system.install: Increase the maximum length of variable names from 48 to 128.
system_update_6019 in drupal-6.x/modules/system/system.install: Reconcile small differences in the previous, manually created mysql and pgsql schemas so they are the same and can be represented by a single schema structure.
system_update_6022 in drupal-6.x/modules/system/system.install: Update files tables to associate files to a uid by default instead of a nid. Rename file_revisions to upload since it should only be used by the upload module used by upload to link files to nodes.
system_update_6033 in drupal-6.x/modules/system/system.install: Change node_comment_statistics to be not autoincrement.

... See full list

File

drupal-6.x/includes/database.pgsql.inc, line 751: Database interface code for PostgreSQL database servers.

Code

function db_add_primary_key(&$ret, $table, $fields) {
  $ret[] = update_sql('ALTER TABLE {' . $table . '} ADD PRIMARY KEY (' .
    implode(',', $fields) . ')');
}