hemall.terabimsoft.com.cn/database/migrations/2018_06_12_140403_create_status_flow_table.php

<?php

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

class CreateStatusFlowTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        if (Schema::hasTable('yz_order_pay')) {
            Schema::table('yz_order_pay',
                function (Blueprint $table) {
                    if (!Schema::hasColumn('yz_order_pay', 'is_pending')) {
                        $table->tinyInteger('is_pending')->default(0);
                    }
                });
        }
        if (!Schema::hasTable('yz_flow')) {
            Schema::create('yz_flow', function (Blueprint $table) {
                $table->integer('id', true);
                $table->string('name');
                $table->string('code');
                $table->integer('plugin_id')->default(0);;
                $table->integer('created_at')->nullable();
                $table->integer('updated_at')->nullable();
                $table->integer('deleted_at')->nullable();
            });
        }
        if (!Schema::hasTable('yz_status')) {
            Schema::create('yz_status', function (Blueprint $table) {
                $table->integer('id', true);
                $table->integer('flow_id');
                $table->string('name');
                $table->string('code')->nullable();
                $table->integer('order');

                $table->integer('plugin_id')->default(0);;
                $table->integer('created_at')->nullable();
                $table->integer('updated_at')->nullable();
                $table->integer('deleted_at')->nullable();
//                $table->foreign('flow_id')
//                    ->references('id')
//                    ->on('yz_flow')
//                    ->onDelete('cascade');
            });
        }

        if (!Schema::hasTable('yz_process')) {
            Schema::create('yz_process', function (Blueprint $table) {
                $table->integer('id', true);
                $table->integer('uid')->nullable();
                $table->integer('model_id');
                $table->string('model_type');
                $table->integer('flow_id');
                $table->integer('status_id');
                $table->enum('state', ['processing', 'completed', 'canceled']);
                $table->tinyInteger('is_pending')->default(0);
                $table->integer('created_at')->nullable();
                $table->integer('updated_at')->nullable();
                $table->integer('deleted_at')->nullable();

//                $table->foreign('flow_id')
//                    ->references('id')
//                    ->on((new \app\common\models\Flow())->getTable())
//                    ->onDelete('cascade');
//                $table->foreign('status_id')
//                    ->references('id')
//                    ->on((new \app\common\models\Status)->getTable())
//                    ->onDelete('cascade');
            });
        }

        if (!Schema::hasTable('yz_remittance_record')) {
            Schema::create('yz_remittance_record', function(Blueprint $table) {
                $table->integer('id', true);
                $table->integer('uid');
                $table->integer('order_pay_id');
                $table->text('report_url')->nullable();
                $table->string('card_no')->nullable();
                $table->string('bank_name')->nullable();
                $table->decimal('amount')->nullable();
                $table->text('note')->nullable();
                $table->integer('created_at')->nullable();
                $table->integer('updated_at')->nullable();
                $table->integer('deleted_at')->nullable();
//                $table->foreign('order_pay_id')
//                    ->references('id')
//                    ->on((new \app\common\models\OrderPay)->getTable())
//                    ->onDelete('cascade');
            });
        }
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        if (Schema::hasTable('yz_remittance_record')) {
            Schema::dropIfExists('yz_remittance_record');
        }
        if (Schema::hasTable('yz_process')) {
            Schema::dropIfExists('yz_process');
        }
        if (Schema::hasTable('yz_status')) {
            Schema::dropIfExists('yz_status');
        }
        if (Schema::hasTable('yz_flow')) {
            Schema::dropIfExists('yz_flow');
        }


    }
}