--創建秒殺庫存表

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_creale_time(create_time)

)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT ='秒殺庫存表';