Foward Engineer SQL create...Never seem to work

[Chris Thorley]

I have tried to export a set of tables from Workbench using "Foward Engineer SQL create..." and I cant seem to get the script to import via any import application or command line due to the following error:-

Does anyone know why this is the case becaus ethey are really siple tables and all InnoDB so its all bit of a waste of time right now.


Query:
CREATE TABLE IF NOT EXISTS `projects` (
`projectId` INT(11) NOT NULL AUTO_INCREMENT ,
`projectName` VARCHAR(225) NULL DEFAULT NULL ,
`briefDescription` NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
PRIMARY KEY (`projectId`) )
ENGINE = InnoDB
AUTO_INCREMENT = 503


Error occured at:2009-02-17 21:17:42
Line no.:11
Error Code: 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 'NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
PRIMARY KEY (`projectId`) )
E' at line 4

Query:
CREATE TABLE IF NOT EXISTS `projects` (
`projectId` INT(11) NOT NULL AUTO_INCREMENT ,
`projectName` VARCHAR(225) NULL DEFAULT NULL ,
`briefDescription` NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
PRIMARY KEY (`projectId`) )
ENGINE = InnoDB
AUTO_INCREMENT = 503


Error occured at:2009-02-17 21:19:02
Line no.:11
Error Code: 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 'NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
PRIMARY KEY (`projectId`) )
E' at line 4

Query:
CREATE TABLE IF NOT EXISTS `projects` (
`projectId` INT(11) NOT NULL AUTO_INCREMENT ,
`projectName` VARCHAR(225) NULL DEFAULT NULL ,
`briefDescription` NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
`type` NOT NULL ,
`status` NOT NULL ,
`active` NOT NULL DEFAULT 1 COMMENT '1 is active\n2 is inactive\n3 is delete' ,
`site` NULL ,
PRIMARY KEY (`projectId`) )
ENGINE = InnoDB
AUTO_INCREMENT = 503

Error occured at:2009-02-17 21:20:48
Line no.:32
Error Code: 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 'NULL DEFAULT NULL ,
`stakeHolders` NOT NULL ,
`type` NOT NULL ,
`status`' at line 4