DROP TABLE IF EXISTS `ohrm_email_queue`;
CREATE TABLE IF NOT EXISTS `ohrm_email_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to_email` varchar(60) NOT NULL,
  `from_email` varchar(60) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `type` varchar(60) NOT NULL,
  `content_type` enum('text/html','text/plain') DEFAULT NULL,
  `body` longtext NOT NULL,
  `status` enum('STARTED','SENT','PENDING') CHARACTER SET latin1 DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;