function casetracker_mail_install in Case Tracker 5

Implementation of hook_install().

Database schema last updated 2006-12 by Morbus Iff.

casetracker_mail: msg_id: the message ID of an outgoing mail notification. nid: the node ID to which this outgoing mail refers. cid: the comment ID to which this outgoing mail refers.

File

./casetracker_mail.install, line 13

Code

function casetracker_mail_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {casetracker_mail} (\n        msg_id varchar(250) NOT NULL,\n        nid int(11) NOT NULL,\n        cid int(11) NOT NULL,\n        PRIMARY KEY (msg_id)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {casetracker_mail} (\n        msg_id varchar(250) NOT NULL,\n        nid numeric(11) NOT NULL,\n        cid numeric(11) NOT NULL,\n        PRIMARY KEY  (msg_id)\n      )");
      break;
  }
}