db_add_unique_key

• Drupal 6
• Drupal 7

Versions

6

db_add_unique_key(&$ret, $table, $name, $fields)

7

db_add_unique_key($table, $name, $fields)

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.

Code

includes/database.pgsql.inc, line 793

<?php
function db_add_unique_key(&$ret, $table, $name, $fields) {
  $name = '{'. $table .'}_'. $name .'_key';
  $ret[] = update_sql('ALTER TABLE {'. $table .'} ADD CONSTRAINT '.
    $name .' UNIQUE ('. implode(',', $fields) .')');
}
?>

Login or register to post comments