Error in Mysql inster

[joefox]

For some reason it doesent like the timestamp part any ideas?

It was working in one of my DB's then i had to change to a new server so i did a mysql dump, and tired reuploading and i get this

CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`is_active` int(1) NOT NULL default '1',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`admin` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) AUTO_INCREMENT=2 ;

[Hack]

Moved to database development.

Are you getting an error when you run this? If so, what?

[joefox]

Yes im getting an error, it just says error near line:

`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

[joefox]

anyone?

[joefox]

anyone?