CREATE TABLE `goods`(
	`id` BIGINT AUTO_INCREMENT COMMENT '商品Id',
	goods_name VARCHAR(16) DEFAULT NULL COMMENT '商品名称',
	goods_title VARCHAR(64) DEFAULT NULL COMMENT '商品标题',
	goods_image VARCHAR(64) DEFAULT NULL COMMENT '商品图片',
	goods_detail LONGTEXT COMMENT '商品详细',
	goods_price DECIMAL(10,2) DEFAULT 0.00 COMMENT '商品价格',
	goods_stock INT(11) DEFAULT 0 COMMENT '商品库存为-1表示没有限制',
	PRIMARY KEY(`id`)
 )ENGINE = INNODB AUTO_INCREMENT =3 DEFAULT CHARSET =utf8mb4
 
 ALTER TABLE goods RENAME TO t_goods;
 
 
 -- 订单表
 CREATE TABLE `t_order`(
	`id` BIGINT(20) AUTO_INCREMENT COMMENT '订单Id',
	user_id BIGINT(20) DEFAULT NULL COMMENT '用户ID',
	delivery_addr_id BIGINT(20) DEFAULT NULL COMMENT'收货地址id',
	
	goods_id BIGINT(20) DEFAULT NULL COMMENT '商品id',
	goods_name VARCHAR(16) DEFAULT NULL COMMENT '冗余过来的商品名称',
	goods_count INT(11) DEFAULT '0' COMMENT '商品数量',
	goods_price DECIMAL(10,2) DEFAULT 0.00 COMMENT '商品单价',
	order_channel TINYINT(4) DEFAULT 0 COMMENT '订单渠道,1pc,2android,3ios',
	`status` TINYINT(4) DEFAULT 0 COMMENT '商品状态,0新建未支付,1已支付,2已发货,3以收获,4以退款,5已完成',
	create_date DATETIME DEFAULT NOW() COMMENT '订单创建时间',
	pay_date DATETIME DEFAULT NULL COMMENT '订单支付时间',
	PRIMARY KEY(`id`)
 )ENGINE = INNODB AUTO_INCREMENT =12 DEFAULT CHARSET =utf8mb4
 
 
 -- 秒杀商品表
  CREATE TABLE `t_seckill_goods`(
	`id` BIGINT(20) AUTO_INCREMENT COMMENT '秒杀商品Id',
	goods_id BIGINT(20) DEFAULT NULL COMMENT '商品id',
	seckill_price DECIMAL(10,2) DEFAULT 0.00 COMMENT '秒杀价',
	stock_count INT(10) DEFAULT 0 COMMENT '库存数量',
	start_date DATETIME DEFAULT NULL COMMENT '秒杀开始时间',
	end_date DATETIME DEFAULT NULL COMMENT '秒杀结束时间',
	PRIMARY KEY(`id`)
 )ENGINE = INNODB AUTO_INCREMENT =3 DEFAULT CHARSET =utf8mb4
 
 -- 秒杀订单表
   CREATE TABLE `t_seckill_order`(
	`id` BIGINT(20) AUTO_INCREMENT COMMENT '秒杀订单Id',
	user_id BIGINT(20) DEFAULT NULL COMMENT'用户Id',
	order_id BIGINT(20) DEFAULT NULL COMMENT'订单id',
	goods_id BIGINT(20) DEFAULT NULL COMMENT'商品id',
	PRIMARY KEY(`id`)
   )ENGINE = INNODB AUTO_INCREMENT =3 DEFAULT CHARSET =utf8mb4
 
 
 -- 插入数据
 INSERT INTO `t_goods`VALUES (1,'iphone13 64G','iphone13 64G','/img/iphone13.png','iphone13 64G',6400,100),(2,'iphone13PRO 64G','iphone13PRO 64G','/img/iphonepro13.png','iphone13PRO 64G',9400,100);
 
 INSERT INTO `t_seckill_goods`VALUES (1,1,639,10,'2021-10-4 08:00:00','2021-10-4 09:00:00'),(2,2,929,10,'2021-10-4 08:00:00','2021-10-4 09:00:00');