You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
47 lines
1.3 KiB
47 lines
1.3 KiB
<?php
|
|
|
|
use Illuminate\Support\Facades\Schema;
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
use Illuminate\Database\Migrations\Migration;
|
|
|
|
class CreateSeckillsTable extends Migration
|
|
{
|
|
/**
|
|
* Run the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function up()
|
|
{
|
|
Schema::create('seckills', function (Blueprint $table) {
|
|
$table->increments('id');
|
|
|
|
$table->unsignedInteger('category_id');
|
|
$table->unsignedInteger('product_id');
|
|
|
|
$table->decimal('price', 12, 2)->comment('秒杀价');
|
|
$table->unsignedInteger('number')->default(1)->comment('秒杀的数量');
|
|
$table->unsignedInteger('rollback_count')->default(0)->comment('回滚的库存量');
|
|
$table->unsignedInteger('sale_count')->default(0)->comment('卖出的数量');
|
|
|
|
$table->dateTime('start_at')->comment('抢购开始时间');
|
|
$table->dateTime('end_at')->comment('抢购结束时间');
|
|
|
|
// 回滚过了，就不继续回滚
|
|
$table->tinyInteger('is_rollback')->default(0)->comment('是否回滚了数量');
|
|
|
|
$table->timestamps();
|
|
});
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function down()
|
|
{
|
|
Schema::dropIfExists('seckills');
|
|
}
|
|
}
|