表创建出现问题

create table  seckill(

`seckill_id` bigint NOT NULL AUTO_INCREMENT COMMENT '商品库存id',

`name` varchar(120) NOT NULL COMMENT '商品名称',

`number` int NOT NULL COMMENT '库存数量',

`start_time` timestamp NOT NULL  COMMENT '秒杀开启时间',

`end_time` timestamp NOT NULL COMMENT '秒杀结束时间',

`create_time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',

PRIMARY KEY (seckill_id),

key idx_start_time(start_time),

key idx_end_time(end_time),

key idx_create_time(create_time)

)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='秒杀库存表';

在doc黑窗口中建表时报错

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

请问该怎么整