having problems loading mysql into myphpadmin error

[fastz28]

QL query:

CREATE TABLE pop_cpg_pictures ( pid int(11) NOT NULL auto_increment, aid int(11) NOT NULL default '0', filepath varchar(255) NOT NULL default '', filename varchar(255) NOT NULL default '', filesize int(11) NOT NULL default '0', total_filesize int(11) NOT NULL default '0', pwidth smallint(6) NOT NULL default '0', pheight smallint(6) NOT NULL default '0', hits int(10) NOT NULL default '0', mtime timestamp NOT NULL default '0', ctime int(11) NOT NULL default '0', owner_id int(11) NOT NULL default '0', owner_name varchar(40) NOT NULL default '', pic_rating int(11) NOT NULL default '0', votes int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', caption text NOT NULL, keywords varchar(255) NOT NULL default '', approved enum('YES','NO') NOT NULL default 'NO', user1 varchar(255) NOT NULL default '', user2 varchar(255) NOT NULL default '', user3 varchar(255) NOT NULL default '', user4 varchar(255) NOT NULL default '', url_prefix[...]

MySQL said:

#1067 - Invalid default value for 'mtime'

[Barand]

TIMESTAMP default values can be

 

CURRENT_TIMESTAMP (auto insert current datetime on INSERT)

CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP (auto insert current datetime on INSERT and UPDATE)

[fastz28]

thank you  barand i got it to work :-)