Multiple timestamps

Eiolon · #1 (**permalink**) 08-03-06, 15:51

I am using MySQL 5.0.22 and am trying to make multiple timestamps. One for when the record is inserted and one for when the record is updated.

Here is 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
);

Here is the error:

Quote:

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

Is there any way to accomplish this? I tried reading the reference manual on this and I thought I was doing it right but I guess not. Thanks!