1 schema.inc | public DatabaseSchema_mysql::addPrimaryKey($table, $fields) |
Add a primary key.
Parameters
string $table: The table to be altered.
string[] $fields: Fields for the primary key.
Return value
void:
Throws
DatabaseSchemaObjectDoesNotExistException If the specified table doesn't exist.
DatabaseSchemaObjectExistsException If the specified table already has a primary key.
Overrides DatabaseSchema::addPrimaryKey
File
- core/
includes/ database/ mysql/ schema.inc, line 447 - Database schema code for MySQL database servers.
Class
- DatabaseSchema_mysql
- Class to create and manipulate MySQL tables.
Code
public function addPrimaryKey($table, $fields) {
if (!$this->tableExists($table)) {
throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot add primary key to table @table: table doesn't exist.", array(
'@table' => $table,
)));
}
if ($this->indexExists($table, 'PRIMARY')) {
throw new DatabaseSchemaObjectExistsException(t("Cannot add primary key to table @table: primary key already exists.", array(
'@table' => $table,
)));
}
$this->connection->query('ALTER TABLE {' . $table . '} ADD PRIMARY KEY (' . $this->createKeySql($fields) . ')');
}