练习用的数据库

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.56 : Database - seckill

---

*/

/*!40101 SET NAMES utf8 */;

/!40101 SET SQL_MODE=’’/;

/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO’ /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
CREATE DATABASE /!32312 IF NOT EXISTS/seckill /*!40100 DEFAULT CHARACTER SET latin1 */;

USE seckill;

/*Table structure for table tb_seckill_goods */

DROP TABLE IF EXISTS tb_seckill_goods;

CREATE TABLE tb_seckill_goods (
goods_id bigint(20) DEFAULT NULL COMMENT ‘spu ID’,
title varchar(100) DEFAULT NULL COMMENT ‘标题’,
small_pic varchar(150) DEFAULT NULL COMMENT ‘商品图片’,
price decimal(10,2) DEFAULT NULL COMMENT ‘原价格’,
cost_price decimal(10,2) DEFAULT NULL COMMENT ‘秒杀价格’,
start_time