[SQL]CREATE?TABLE?seckill?(
??`seckill_id`?BIGINT?NOT?NULL?AUTO_INCREMENT?COMMENT?'商品庫存id',
??`name`?VARCHAR(120)?NOT?NULL?COMMENT?'商品名稱',
??`number`?INT?NOT?NULL?COMMENT?'庫存數(shù)量',
??`start_time`?TIMESTAMP?NOT?NULL?COMMENT?'開始時間',
??`end_time`?TIMESTAMP?NOT?NULL?COMMENT?'結(jié)束時間',
??`create_time`?TIMESTAMP?NOT?NULL?DEFAULT?CURRENT_TIMESTAMP?COMMENT?'創(chuàng)建時間',
??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='秒殺庫存表';
[Err]?1067?-?Invalid?default?value?for?'end_time'