function casetracker_update_4 in Case Tracker 5

File

./casetracker.install, line 219

Code

function casetracker_update_4() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {casetracker_comment} (\n                 cid int(10) NOT NULL default '0',\n                 sid int(10) NOT NULL auto_increment,\n                 PRIMARY KEY (sid)\n               ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      $ret[] = update_sql("CREATE TABLE {casetracker_comment_status} (\n                 sid int(10) NOT NULL default '0',\n                 project_term_id int(10) NOT NULL default '0',\n                 assign_to int(10) NOT NULL default '0',\n                 case_priority_id int(10) NOT NULL default '0',\n                 case_type_id int(10) NOT NULL default '0',\n                 case_status_id int(10) NOT NULL default '0',\n                 state int(10) NOT NULL default '0'\n               ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      $ret[] = update_sql("DROP TABLE IF EXISTS {casetracker_comments}");
      break;
  }
  return $ret;
}