--创建秒杀库存表

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='秒杀库存表'