db_add_index

Versions
6
db_add_index(&$ret, $table, $name, $fields)
7
db_add_index($table, $name, $fields)

Add an index.

Parameters

$ret Array to which query results will be added.

$table The table to be altered.

$name The name of the index.

$fields An array of field names.

Related topics

▾ 17 functions call db_add_index()

comment_update_6003 in modules/comment/comment.install
Add index to parent ID field.
locale_update_6004 in modules/locale/locale.install
Fix remaining inconsistent indexes.
system_update_1022 in modules/system/system.install
Add index on users created column.
system_update_6001 in modules/system/system.install
Add version id column to {term_node} to allow taxonomy module to use revisions.
system_update_6003 in modules/system/system.install
Add index on comments status column.
system_update_6019 in modules/system/system.install
Reconcile small differences in the previous, manually created mysql and pgsql schemas so they are the same and can be represented by a single schema structure.
system_update_6022 in modules/system/system.install
Update files tables to associate files to a uid by default instead of a nid. Rename file_revisions to upload since it should only be used by the upload module used by upload to link files to nodes.
system_update_6023 in modules/system/system.install
system_update_6024 in modules/system/system.install
Add translation fields to nodes used by translation module.
system_update_6025 in modules/system/system.install
Increase the maximum length of node titles from 128 to 255.
system_update_6035 in modules/system/system.install
Change index on system table for better performance.
system_update_6043 in modules/system/system.install
Update table indices to make them more rational and useful.
system_update_6044 in modules/system/system.install
RC1 to RC2 index cleanup.
system_update_6049 in modules/system/system.install
Replace src index on the {url_alias} table with src, language.
system_update_6052 in modules/system/system.install
Add a missing index on the {menu_router} table.
system_update_6053 in modules/system/system.install
Add a {system} index on type and name.
_db_create_keys in includes/database.pgsql.inc

Code

includes/database.pgsql.inc, line 826

<?php
function db_add_index(&$ret, $table, $name, $fields) {
  $ret[] = update_sql(_db_create_index_sql($table, $name, $fields));
}
?>
Login or register to post comments
 
 

All source code and documentation on this site is released under the terms of the GNU General Public License, version 2 and later. Drupal is a registered trademark of Dries Buytaert.