You are here

Home » API reference » Case Tracker 5 » casetracker.install

function casetracker_update_18 in Case Tracker 5

File

./casetracker.install, line 510

Code

function casetracker_update_18() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {casetracker_case} CHANGE COLUMN p_id pid int(10) NOT NULL default '0'");
      $ret[] = update_sql("ALTER TABLE {casetracker_case} CHANGE COLUMN case_id case_number int(10) NOT NULL default '0'");
      $ret[] = update_sql("ALTER TABLE {casetracker_case} DROP COLUMN case_sender_uid");
      $ret[] = update_sql("ALTER TABLE {casetracker_comment_status} CHANGE COLUMN project_term_id pid int(10) NOT NULL default '0'");
      $ret[] = update_sql("ALTER TABLE {casetracker_project} CHANGE COLUMN project_no project_number int(10) NOT NULL default '0'");
      break;
  }
  return $ret;
}