Why can't we use 2 time stamps?

[EchoFool]

I keep getting this error on my message table:

 

 

SQL query:

ALTER TABLE `messages` ADD `ReportedOn` TIMESTAMP NOT NULL AFTER `ReportedBy`

MySQL said: Documentation
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause 

 

 

This is stupid.. if we can only have one cos then I will have to make an entirely new table just because of one field.

 

The table has:

Message ID | Sent On  | ReportedBy |

 

But i need to add a field which is | ReportedOn |

 

But i get that error... what is the reason for this?

[sasa]

try

ALTER TABLE `messages` ADD `ReportedOn` TIMESTAMP NOT NULL  DEFAULT 0 AFTER `ReportedBy`