- assigned_to: nobody --> lem9
CREATE TABLE `z_2007_01_15_data` (
`user_id` int(10) unsigned NOT NULL,
`one` float unsigned NOT NULL,
`two` float unsigned NOT NULL,
`three` float unsigned NOT NULL,
`total` float unsigned NOT NULL,
`posted_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`pay` int(10) unsigned NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Then
1) Click on Structure
2) Modify posted_on field
3) Change "Atributes" to '';
Uncheck "Current Timestamp"
Default to "0000-00-00 00:00:00"
4) Save
SQL query:
ALTER TABLE `z_2007_01_15_data` CHANGE `posted_on` `posted_on` TIMESTAMP NOT NULL DEFAULT 0000 -00 -0000 :00 :00
MySQL said: Documentation
#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 '-00-00 00:00:00' at line 1