function support_update_6010 in Support Ticketing System 6

Fix a performance issue with the primary key on {support_assigned}. Add an index on uid to {support_assigned}.

File

./support.install, line 539

Code

function support_update_6010() {
  $ret = array();
  db_drop_primary_key($ret, 'support_assigned');
  db_add_primary_key($ret, 'support_assigned', array(
    'nid',
    'uid',
  ));
  db_add_index($ret, 'support_assigned', 'support_assigned_uid', array(
    'uid',
  ));
  return $ret;
}