<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class ExpressItemCreate extends Migration { public function up() { Schema::create('express_item', function (Blueprint $onV5E) { $onV5E->increments('id'); $onV5E->timestamps(); $onV5E->string('biz', 20)->nullable()->comment('业务'); $onV5E->bigInteger('bizId')->nullable()->comment('业务ID'); $onV5E->tinyInteger('status')->nullable()->comment('状态'); $onV5E->dateTime('statusUpdateTime')->nullable()->comment('状态'); $onV5E->string('expressName', 20)->nullable()->comment('快递公司'); $onV5E->string('expressCode', 40)->nullable()->comment('快递号码'); $onV5E->string('phone', 20)->nullable()->comment('收件人手机号'); $onV5E->string('param', 100)->nullable()->comment('其他参数'); $onV5E->string('latestMessage', 100)->nullable()->comment('最新状态'); $onV5E->text('content')->nullable()->comment('内容'); $onV5E->unique(array('biz', 'bizId')); $onV5E->index(array('status', 'statusUpdateTime')); }); } public function down() { } }