MySQL Workbench 5.2.35: Error 1064: You have an error in your SQL syntax

[Renier Lewis]

Hi Guys

I have created tables in MySQL Workbench.
When I now want to publish the scripts to an empty database, I get all sorts of errors.

The errors are mostly related toExecuting SQL script in server

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NOT NULL AUTO_INCREMENT COMMENT 'This value uniquely identifies a specific cli' at line 2

Can anyone please assist as to what can be wrong with the script and why the Workbench would create a faulty script?

CREATE TABLE IF NOT EXISTS `TTS`.`Client` (
`Client_ID` DOUBLE(11) NOT NULL AUTO_INCREMENT COMMENT 'This value uniquely identifies a specific client' ,
`Client_Name` VARCHAR(100) NOT NULL COMMENT 'The client name' ,
`Client_IsActive` TINYINT(1) NOT NULL DEFAULT TRUE COMMENT 'Identifies if a client is active.Overrides all settings, no completion of candidate actions should be possible if a client is deactivated' ,
PRIMARY KEY (`Client_ID`, `Client_Name`) ,
INDEX `fk_Client_Client_GUI1` (`Client_ID` ASC) ,
CONSTRAINT `fk_Client_Client_GUI1`
FOREIGN KEY (`Client_ID` )
REFERENCES `TTS`.`Client_GUI` (`Client_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_swedish_ci;

What am I doing wrong?

Thanks
Renier