function support_substatus_update_6101 in Support Ticketing System 6

Track Current status (for filtering and sorting).

File

support_substatus/support_substatus.install, line 141

Code

function support_substatus_update_6101() {
  $ret = array();
  db_add_field($ret, 'support_substatus_ticket', 'current', array(
    'type' => 'int',
    'not null' => TRUE,
    'unsigned' => TRUE,
    'default' => 0,
  ), array(
    'indexes' => array(
      'current' => array(
        'current',
      ),
    ),
  ));
  $result = db_query('SELECT DISTINCT(nid) FROM {support_substatus_ticket}');
  while ($nid = db_result($result)) {
    $trid = db_result(db_query_range('SELECT trid FROM {support_substatus_ticket} WHERE nid = %d ORDER BY trid DESC', $nid, 0, 1));
    db_query('UPDATE {support_substatus_ticket} SET current = 1 WHERE trid = %d', $trid);
  }
  return $ret;
}