function system_update_6055 in Drupal 6

Improve indexes on the {url_alias} table.

Related topics

File

modules/system/system.install, line 2730

Code

function system_update_6055() {
  $ret = array();
  db_drop_index($ret, 'url_alias', 'src_language');
  db_drop_unique_key($ret, 'url_alias', 'dst_language');
  db_add_index($ret, 'url_alias', 'src_language_pid', array(
    'src',
    'language',
    'pid',
  ));
  db_add_unique_key($ret, 'url_alias', 'dst_language_pid', array(
    'dst',
    'language',
    'pid',
  ));
  return $ret;
}