<?php

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

class AddUmrnToMandateTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('mandate', function (Blueprint $table) {
            $table->string('umrn')->after('mandate_id')->nullable();
            $table->string('action',1)->after('umrn')->nullable();
            $table->string('collection',1)->after('action')->nullable();
            $table->string('frequency',1)->after('collection')->nullable();
            $table->tinyInteger('monthly_frequency')->after('frequency')->nullable();
            $table->integer('mandate_amount')->after('monthly_frequency')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('mandate', function (Blueprint $table) {
            $table->dropColumn('umrn');
            $table->dropColumn('action');
            $table->dropColumn('collection');
            $table->dropColumn('frequency');
            $table->dropColumn('monthly_frequency');
            $table->dropColumn('mandate_amount');
        });
    }
}