W3cubDocs

/Drupal 8

function db_add_index

db_add_index($table, $name, $fields, array $spec)

Adds an index.

Parameters

$table: The table to be altered.

$name: The name of the index.

array $fields: An array of field names.

array $spec: The table specification of the table to be altered, as taken from a schema definition. See \Drupal\Core\Database\Schema::addIndex() for how to obtain this specification.

Deprecated

as of Drupal 8.0.x, will be removed in Drupal 9.0.0. Instead, get a database connection injected into your service from the container, get its schema driver, and call addIndex() on it. For example, $injected_database->schema()->addIndex($table, $name, $fields, $spec);

See also

hook_schema()

Schema API

\Drupal\Core\Database\Schema::addIndex()

Related topics

Schema API
API to handle database schemas.

File

core/includes/database.inc, line 929
Core systems for the database layer.

Code

function db_add_index($table, $name, $fields, array $spec) {
  return Database::getConnection()->schema()->addIndex($table, $name, $fields, $spec);
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/core!includes!database.inc/function/db_add_index/8.1.x