CREATE TABLE ?seckill（
'seckill_id' bigint NOT NULL AUTO_INCREMENT COMMENT '商品庫(kù)存id',
'name' varchar (120)NOT NULL COMMENT '商品的名稱',
'number' int　NOT NULL　COMMENT　'庫(kù)存數(shù)量'，
'start_time' timestamp　NOT NULL　COMMENT　'秒殺開(kāi)啟時(shí)間',
'end_time' timestamp NOT NULL COMMENT '秒殺結(jié)束時(shí)間',
'create_time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ?COMMENT '創(chuàng)建時(shí)間',
PRIMARY KEY(seckill_id),
key idx_start_time(start_time),
key idx_end_time(end_time),
key idx_create_time(create_time)
)ENGINE=INNOGB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT ='秒殺庫(kù)存表';