function activity_update_5400 in Activity 5.4

A column for the user ID is being added back to make certain things easier to do going forward

File

./activity.install, line 143

Install file for activity module.

Code

function activity_update_5400() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      update_sql('ALTER TABLE {activity} ADD COLUMN uid INT(11) NOT NULL DEFAULT 0');
      break;
    case 'pgsql':
      db_add_field($ret, 'activity', 'uid', array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ));
      break;
  }
  $activities = db_query('SELECT aid, module, data FROM {activity}');
  while ($activity = db_fetch_object($activities)) {
    $aid = $activity->aid;
    $data = unserialize($activity->data);
    $uid = $activity->module == 'user_relationshipsactivity' ? $data['requester-id'] : $data['author-uid'];
    db_query('UPDATE {activity} SET uid = %d WHERE aid = %d', $uid, $aid);
  }
  return $ret;
}