
CREATE TABLE IF NOT EXISTS `ohrm_calendar_invitation` (
      `id` int(11) not null auto_increment,
      `event_id` int(11) NOT NULL,
      `event_type` varchar(50) NOT NULL,
      `dtstart` varchar(100) NOT NULL,
      `uid` varchar(100) NOT NULL,
      `dtstamp` varchar(100) NOT NULL,
      `status` varchar(50) NOT NULL,
      `sequence` int(4) NOT NULL,
      PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ohrm_config` (`property`, `value`) VALUES ('icalendar_template', 'iCalendar');
INSERT INTO `ohrm_config` (`property`, `value`) VALUES ('calendar_event_service', 'InvitationService');