DrupalAPI.de

1. drupal
   1. drupal7

Build the SQL expression for indexes.

Verwandte Themen

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/sqlite/schema.inc, line 46

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