You are here

function _db_create_index_sql in Drupal 6

Related topics

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.

2 calls to _db_create_index_sql()

db_add_index in includes/database.pgsql.inc: Add an index.
db_create_table_sql in includes/database.pgsql.inc: Generate SQL to create a new table from a Drupal schema definition.

File

includes/database.pgsql.inc, line 522: Database interface code for PostgreSQL database servers.

Code

function _db_create_index_sql($table, $name, $fields) {
  $query = 'CREATE INDEX {' . $table . '}_' . $name . '_idx ON {' . $table . '} (';
  $query .= _db_create_key_sql($fields) . ')';
  return $query;
}