function userpoints_update_6012 in User Points 6

For userpoints_txn, need an index on expirydate and expired columns.

File

./userpoints.install, line 281

Code

function userpoints_update_6012() {
  $ret = array();
  db_drop_index($ret, 'userpoints_txn', 'status');
  db_add_index($ret, 'userpoints_txn', 'status_expired_expiry', array(
    'status',
    'expired',
    'expirydate',
  ));
  return $ret;
}