CREATE TABLE `eq_emailDetails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `eid` int(10) unsigned NOT NULL DEFAULT '0',
  `eContent` text,
  `eBarcodes` text,
  `subject` varchar(255) DEFAULT NULL,
  `eTxtContent` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `eq_emailRequest` (
  `eid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `email_cc` varchar(255) DEFAULT NULL,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `sendDate` datetime DEFAULT NULL,
  `status` enum('sent','waiting','rejected') NOT NULL DEFAULT 'waiting',
  `retryCount` tinyint(5) unsigned NOT NULL DEFAULT '0',
  `requestDate` datetime DEFAULT NULL,
  `modDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`eid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
