Description:
When choosing "Alter table" from contextual menu on a table, I get the error "Error Parsing DDL for `dbCrm`.`email_imap`
There was an error while parsing the DDL retrieved from the server.
Do you want to view the DDL or cancel processing it?"
The DDL contains a mysql comment and I think that this is the problem.
Here is the DDL:
delimiter $$
CREATE TABLE `email_imap` (
`idEmail` int(11) NOT NULL AUTO_INCREMENT,
`inputDate` datetime DEFAULT NULL,
`sendDate` datetime DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`from` varchar(255) DEFAULT NULL,
`srcUser` mediumint(9) DEFAULT NULL,
`srcContact` mediumint(9) DEFAULT NULL,
`srcEmail` int(11) DEFAULT NULL,
`to` varchar(255) DEFAULT NULL,
`dstUser` mediumint(9) DEFAULT NULL,
`dstContact` mediumint(9) DEFAULT NULL,
`dstEmail` int(11) DEFAULT NULL,
`cc` varchar(255) DEFAULT NULL,
`storagePath` varchar(255) DEFAULT NULL,
`uniqueId` varchar(255) DEFAULT NULL,
`messageId` varchar(255) DEFAULT NULL,
`firma` mediumint(9) DEFAULT NULL,
`procesVanzari` mediumint(9) DEFAULT NULL,
`citit` tinyint(1) DEFAULT '0',
`spam` tinyint(1) DEFAULT '0',
`trimisNotificareCitire` tinyint(4) DEFAULT '0',
`privilegiuVanzari` tinyint(1) DEFAULT '0',
`privilegiuDate` tinyint(1) DEFAULT '0',
`privilegiuFinanciar` tinyint(1) DEFAULT '0',
`cntAtasamente` tinyint(4) DEFAULT '0',
`ownerId` mediumint(9) DEFAULT NULL,
`folder` mediumint(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`idEmail`,`folder`),
KEY `inputDate` (`inputDate`),
KEY `sendDate` (`sendDate`),
KEY `srcUser` (`srcUser`),
KEY `srcContact` (`srcContact`),
KEY `srcEmail` (`srcEmail`),
KEY `dstUser` (`dstUser`),
KEY `dstContact` (`dstContact`),
KEY `dstEmail` (`dstEmail`),
KEY `uniqueId` (`uniqueId`),
KEY `messageId` (`messageId`),
KEY `firma` (`firma`),
KEY `procesVanzari` (`procesVanzari`),
KEY `citit` (`citit`),
KEY `spam` (`spam`),
KEY `trimisNotificareCitire` (`trimisNotificareCitire`),
KEY `ownerId` (`ownerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
/*!50100 PARTITION BY HASH (folder)
PARTITIONS 1000 */$$
Printscreen: http://i.imgur.com/iMKySq5.png
How to repeat:
Open Mysql Workbench
Open a connection to a server
Open a database
Richt-click on a table
Choose "Alter Table..."
Suggested fix:
I can't find a fix.
