Home » API reference » Drupal 6 » database.mysql-common.inc

db_add_primary_key

6 database.mysql-common.inc db_add_primary_key(&$ret, $table, $fields)
6 database.pgsql.inc db_add_primary_key(&$ret, $table, $fields)
7 database.inc db_add_primary_key($table, $fields)
8 database.inc db_add_primary_key($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.

77 functions call db_add_primary_key()

File

drupal/includes/database.mysql-common.inc, line 380
Functions shared between mysql and mysqli database engines.

Code

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