db_add_unique_key

Add a unique key.

Parameters

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

$table: The table to be altered.

$name: The name of the key.

$fields: An array of field names.

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.

6 calls to db_add_unique_key()

File

includes/database.mysql-common.inc, line 410

Functions shared between mysql and mysqli database engines.

Code

function db_add_unique_key(&$ret, $table, $name, $fields) {
  $ret[] = update_sql('ALTER TABLE {' . $table . '} ADD UNIQUE KEY ' .
    $name . ' (' . _db_create_key_sql($fields) . ')');
}