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, CreatedOn DATETIME NOT NULL, ModifiedOn DATETIME NOT NULL, `StartD' at line 1
CREATE TABLE `billing`.`ebUsers` (
`UserID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`UserName` CHAR( 25 ) NOT NULL ,
`UserPassword` VARCHAR( 30 ) NOT NULL ,
`FirstName` VARCHAR( 50 ) NOT NULL ,
`LastName` VARCHAR( 50 ) NOT NULL ,
`Address` VARCHAR( 100 ) NOT NULL ,
`UserEmail` VARCHAR( 200 ) NOT NULL ,
`UserPhone` VARCHAR( 50 ) NOT NULL ,
`Gender` CHAR( 1 ) NOT NULL ,
`UserSecretID` VARCHAR( 10 ) NOT NULL ,
`ActiveStatus` ENUM NOT NULL ,
`CreatedOn` DATETIME NOT NULL ,
`ModifiedOn` DATETIME NOT NULL ,
`StartDate` DATETIME NOT NULL ,
`EndDate` DATETIME NOT NULL ,
`UserToken` VARCHAR( 300 ) NOT NULL ,
UNIQUE (
`UserName` ,
`UserEmail` ,
`UserPhone`
)
) ENGINE = MYISAM ;
cannot able to create table in mysql db. what is the error?
