--------------------------------------------------
-- 2.2.0 to 2.3.0 delta
-- based on apm_2_2-to-2_3.sql
-- Created 20090923, TNS
--------------------------------------------------


CREATE TABLE IF NOT EXISTS `config_issue_notification` (
  `system` varchar(3) NOT NULL,
  `client` varchar(3) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `from` varchar(320) NOT NULL,
  `toList` text NOT NULL COMMENT 'Comma separated',
  PRIMARY KEY  (`system`,`client`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `queue_issue_notification` (
  `issue_guid` varchar(32) NOT NULL,
  PRIMARY KEY  (`issue_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
