function webform_update_6331 in Webform 6.3

Add an index for nid_sid to webform_submissions.

File

./webform.install, line 1522

Webform module install/schema hooks.

Code

function webform_update_6331() {

  // Even though we already have an index 'nid_uid_sid', adding the index for
  // 'nid_sid' saves us a tablesort on the node/x/webform-results page.
  $ret = array();
  db_add_index($ret, 'webform_submissions', 'nid_sid', array(
    'nid',
    'sid',
  ));
  return $ret;
}