Imooc·Java高并发秒杀API（数据库sql）

Java高并发秒杀API（数据库sql）

CREATE DATEBASE seckill;
use seckill;
CREATE TABLE seckill(
	'seckill_id' bigint NOT_INCREMENT COMMENT '商品库存id', 
	'name' varchar 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='秒杀库存表';

insert into
	seckill(name, number, start_time, end_time)
 values
	('1000元秒杀iphone6',100,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
	('500元秒杀ipad2',200,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
	('300元秒杀小米4',300,'2015-11-01 00:00:00','2015-11-02 00:00:00'),
	('200元秒杀红米note',400,'2015-11-01 00:00:00','2015-11-02 00:00:00');
	
create table success_killed(
	'seckill_id' bigint NOT NULL COMMENT '秒杀商品id', 
	'user_phone' bigint NOT NULL COMMENT '用户手机号', 
	'state' tinyint NOT NULL DEFAULT -1 COMMENT '状态标示：-1无效 0成功 1已付款 2已发货', 
	'create_time' timestamp NOT NULL COMMENT '创建时间', 
	PRIMARY KEY(seckill_id,user_phone), /*联合主键(防止用户重复秒杀)*/
	key idx_create_time(create_time)
) ENGINE = InnoDB DEFAULT CHARSET=utf8 COMMENT='秒杀成功明细表';