<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateAppealsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('appeals', function (Blueprint $table) { $table->increments('id'); $table->string('real_name')->comment('真实姓名'); $table->string('mobile')->comment('手机号'); $table->string('email')->comment('常用邮箱'); $table->string('description')->comment('描述信息'); $table->integer('subsite_id')->comment('分站信息(0:总站)'); $table->tinyInteger('status')->comment('处理状态(1:已处理,0:未处理)'); $table->timestamps(); $table->softDeletes(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('appeals'); } }