New MailRelay table for MySQL replication

PROBLEM

My MailRelay table is out of sync.

ENVIRONMENT

• On-Premise Server + WebMail Installations: Version 6.0 > Current Version

CAUSE

If your slave MySQL is out of sync with your primary MySQL, please do the following via MySQL command prompt.

RESOLUTION

drop table MailRelay;
 
CREATE TABLE `MailRelay` (
`IPaddress` varchar(16) NOT NULL default '',
`DateAdded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Account` varchar(128) default NULL,
`id` bigint(20) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`),
KEY `DateAdded` (`DateAdded`),
KEY `IPaddress` (`IPaddress`),
KEY `Account` (`Account`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;