CREATE TABLE IF NOT EXISTS `UserDefinedForm_EmailRecipient` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ClassName` enum('UserDefinedForm_EmailRecipient') CHARACTER SET utf8 DEFAULT 'UserDefinedForm_EmailRecipient',
`Created` datetime DEFAULT NULL,
`LastEdited` datetime DEFAULT NULL,
`EmailAddress` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
`EmailSubject` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
`EmailFrom` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
`EmailBody` mediumtext CHARACTER SET utf8,
`SendPlain` tinyint(1) unsigned NOT NULL DEFAULT '0',
`HideFormData` tinyint(1) unsigned NOT NULL DEFAULT '0',
`FormID` int(11) NOT NULL DEFAULT '0',
`SendEmailFromFieldID` int(11) NOT NULL DEFAULT '0',
`SendEmailToFieldID` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `FormID` (`FormID`),
KEY `SendEmailFromFieldID` (`SendEmailFromFieldID`),
KEY `SendEmailToFieldID` (`SendEmailToFieldID`),
KEY `ClassName` (`ClassName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;