Schema::createIndexSql

protected Schema::createIndexSql($tablename, $schema)

Build the SQL expression for indexes.

File

core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php, line 56

Class

Schema: SQLite implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\Core\Database\Driver\sqlite

Code

protected function createIndexSql($tablename, $schema) {
  $sql = array();
  $info = $this->getPrefixInfo($tablename);
  if (!empty($schema['unique keys'])) {
    foreach ($schema['unique keys'] as $key => $fields) {
      $sql[] = 'CREATE UNIQUE INDEX ' . $info['schema'] . '.' . $info['table'] . '_' . $key . ' ON ' . $info['table'] . ' (' . $this->createKeySql($fields) . ")\n";
    }
  }
  if (!empty($schema['indexes'])) {
    foreach ($schema['indexes'] as $key => $fields) {
      $sql[] = 'CREATE INDEX ' . $info['schema'] . '.' . $info['table'] . '_' . $key . ' ON ' . $info['table'] . ' (' . $this->createKeySql($fields) . ")\n";
    }
  }
  return $sql;
}

Links:

https://api.drupal.org/api/drupal/core%21lib%21Drupal%21Core%21Database%21Driver%21sqlite%21Schema.php/function/Schema%3A%3AcreateIndexSql/8.2.x

doc_Drupal

2025-01-10 15:47:30

Comments