CREATE TABLE `emails` (
  `IDLNK` int(11) NOT NULL AUTO_INCREMENT,
  `Address` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `DateSent` datetime NOT NULL,
  `failed` bit(1) NOT NULL,
  `Status` varchar(255) NOT NULL,
  `rejectedReason` varchar(255) DEFAULT NULL,
  `Deleted` bit(1) NOT NULL,
  PRIMARY KEY (`IDLNK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1