jucai/database/migrations/2018_10_16_144949_create_sms_batchs_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateSmsBatchsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('sms_batchs', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name')->comment('批次标记');
            $table->text('mobiles')->comment('指定手机号码');
            $table->integer('sms_id')->comment('模板id');
            $table->tinyInteger('accept_member')->default('0')->comment('收件会员(0:不限 1:企业 2:个人)');
            $table->tinyInteger('accept_type')->default('0')->comment('验证类型(0:不限 1:邮箱已验证2:邮箱未验证 3:手机已验证 4:手机未验证)');
            $table->tinyInteger('accept_time')->default('0')->comment('登录时间(0:不限 1:一周未登录 2:一月未登录)');
            $table->integer('target_num')->default('0')->comment('目标发送数量');
            $table->integer('send_num')->default('0')->comment('实际发送数量');
            $table->tinyInteger('status')->default('0')->comment('状态:0发送中,1发送完成');
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('sms_batchs');
    }
}