CREATE TABLE `def_imap` (
`Imapcode` char(50) NOT NULL,
`Package` char(50) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT NULL,
`IsActive` char(5) DEFAULT 'N',
`Workflow` char(255) DEFAULT NULL,
`RunFrequency` int(11) DEFAULT 300,
`Timeslip` char(50) DEFAULT '8',
`PreSql` text DEFAULT NULL,
`PostSql` text DEFAULT NULL,
`Tag` char(50) DEFAULT '',
`SearchSubject` char(5) DEFAULT 'N',
`RegexSubject` char(255) DEFAULT NULL,
`SearchBody` char(5) DEFAULT 'N',
`RegexContent` char(255) DEFAULT NULL,
`DoDelete` char(5) DEFAULT 'N',
`LastRun` timestamp NULL DEFAULT NULL,
`Folder` char(50) DEFAULT 'INBOX',
`AttachmentFolder` text DEFAULT NULL,
`Filename` text DEFAULT NULL,
`ImportUnique` char(5) DEFAULT 'N',
`Version` char(255) DEFAULT NULL,
`Active` char(1) DEFAULT 'Y',
PRIMARY KEY (`Imapcode`,`Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation};
CREATE TABLE `stage_imap` (
`Guid` VARCHAR(64) NOT NULL,
`ImapCode` char(50) DEFAULT NULL,
`TimeAdded` datetime DEFAULT NULL,
`Tag` char(50) DEFAULT NULL,
`Folder` char(50) DEFAULT NULL,
`Timeslip` char(50) DEFAULT NULL,
`PreSql` text DEFAULT NULL,
`PostSql` text DEFAULT NULL,
`AttachmentFolder` text DEFAULT NULL,
`ImportUnique` char(5) DEFAULT NULL,
`FileName` text DEFAULT NULL,
`IsActive` char(5) DEFAULT NULL,
`RunFrequency` int(11) DEFAULT NULL,
`LastRun` timestamp NULL DEFAULT NULL,
`TimeCompleted` datetime DEFAULT NULL,
`Status` char(50) DEFAULT NULL,
`Module` VARCHAR(255) DEFAULT 'ObjImap',
PRIMARY KEY (`Guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation};
CREATE TABLE `def_imap_senders` (
`SenderEmail` VARCHAR(255) NOT NULL,
`SenderName` VARCHAR(255) DEFAULT '',
`Action` CHAR(10) DEFAULT 'IGNORE',
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255)
DEFAULT 'ObjServiceEmailTicket',
PRIMARY KEY (`SenderEmail`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation};