function linkchecker_update_7003 in Link checker 7

Issue #1321378: Improve performance of queries.

File

./linkchecker.install, line 301

Installation file for Link Checker module.

Code

function linkchecker_update_7003() {
  db_drop_index('linkchecker_block_custom', 'lid');
  db_drop_index('linkchecker_comment', 'lid');
  db_drop_index('linkchecker_node', 'lid');
  db_add_index('linkchecker_block_custom', 'lid', array(
    'lid',
  ));
  db_add_index('linkchecker_comment', 'lid', array(
    'lid',
  ));
  db_add_index('linkchecker_node', 'lid', array(
    'lid',
  ));
  return t('Added indexes to database tables.');
}