Multiple timestamps

[Eiolon]

Hello,

I am creating a help desk and would like it to stamp the date/time when a request is submitted and also a date/time when the request is completed.  How would I go about having two timestamps?  Here is what I have for my structure:

[code]create table requests (
id int not null primary key auto_increment,
employee varchar(50) not null,
category varchar(50) not null,
priority varchar(10) not null,
description text not null,
status varchar(10) not null default 'Open',
submitted timestamp not null default current_timestamp,
completed timestamp not null default current_timestamp,
technician varchar(50) not null
);[/code]

I get this error:

[quote]ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP
column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause[/quote]

How do I accomplish two timestamps?  Thanks!

[fenway]

Not sure... I'm sure there's a refman page on these crazy column attributes.