function Schema::addIndex

Same name in this branch
  1. 9 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::addIndex()
  2. 9 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::addIndex()
  3. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\Schema::addIndex()
  4. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addIndex()
Same name and namespace in other branches
  1. 11.x core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::addIndex()
  2. 11.x core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::addIndex()
  3. 11.x core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::addIndex()
  4. 11.x core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::addIndex()

File

core/modules/mysql/src/Driver/Database/mysql/Schema.php, line 562

Class

Schema
MySQL implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\mysql\Driver\Database\mysql

Code

public function addIndex($table, $name, $fields, array $spec) {
  if (!$this->tableExists($table)) {
    throw new SchemaObjectDoesNotExistException("Cannot add index '{$name}' to table '{$table}': table doesn't exist.");
  }
  if ($this->indexExists($table, $name)) {
    throw new SchemaObjectExistsException("Cannot add index '{$name}' to table '{$table}': index already exists.");
  }
  $spec['indexes'][$name] = $fields;
  $indexes = $this->getNormalizedIndexes($spec);
  $this->connection
    ->query('ALTER TABLE {' . $table . '} ADD INDEX `' . $name . '` (' . $this->createKeySql($indexes[$name]) . ')');
}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.