SQL Error (1064): You have an error in your SQL syntax.

[Clive Wightman]

Hi

I'm new to MYSQL

My company has version 4.0.16 of MySQL

and I installed onto My Laptop for testing the latest version, I know first problem.
but please could someone help in correcting the error.

SQL 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
'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `AnalystID` v



Code..


delimiter $$

CREATE TABLE `audit` (
`AuditTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`AnalystID` varchar(45) DEFAULT NULL,
`ChangeBY` varchar(45) DEFAULT NULL,
`Fullname` varchar(45) DEFAULT NULL,
`Modificationmade` varchar(45) DEFAULT NULL,
`Changetype` varchar(45) DEFAULT NULL,
PRIMARY KEY (`AuditTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$