function boost_update_6123 in Boost 6

Update 6123 - Add indexes to boost_cache_relationships table

File

./boost.install, line 1446

Handles Boost module installation and upgrade tasks.

Code

function boost_update_6123() {
  $ret = array();

  // Issue #1780860: Must truncate the table because it tends to be huge
  $ret[] = update_sql('TRUNCATE {boost_cache_relationships}');

  // Add indexes
  db_add_index($ret, 'boost_cache_relationships', 'base_dir', array(
    'base_dir',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'page_callback', array(
    'page_callback',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'page_id', array(
    'page_id',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'child_page_callback', array(
    'child_page_callback',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'child_page_type', array(
    'child_page_type',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'child_page_id', array(
    'child_page_id',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'hash_url', array(
    'hash_url',
  ));
  db_add_index($ret, 'boost_cache_relationships', 'timestamp', array(
    'timestamp',
  ));
  return $ret;
}