<?php

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

class AddColumnsToGrades extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('grades', function (Blueprint $table) {
            $table->tinyInteger('rejected')->default(1);
            $table->tinyInteger('checkDuplicates')->default(1);
            $table->tinyInteger('negative_area')->default(1);
            $table->tinyInteger('guarantor')->default(1);
            $table->tinyInteger('accountType')->default(1);
            $table->tinyInteger('no_owned_house')->default(1);
            $table->tinyInteger('zero_downpayment')->default(1);
            $table->tinyInteger('caseType')->default(1);
            $table->tinyInteger('ageAtLastEMI')->default(1);
            $table->tinyInteger('dpdCountRejection')->default(1);
            $table->tinyInteger('pastDues')->default(1);
            $table->tinyInteger('threeYear')->default(1);
            $table->tinyInteger('aboveThreeYear')->default(1);
            $table->string('case_type_value')->default('PWOS,SET')->nullable();
            $table->tinyInteger('ageAtLastEMI_age')->default(60)->nullable();
            $table->tinyInteger('dpdCountRejection_years')->default(2)->nullable();
            $table->integer('dpdCountRejection_dpds')->default(6)->nullable();
            $table->string('pastDues_value')->default('500')->nullable();
            $table->string('dpd_keywords')->default('*,000,01+,1+,CLSD,NEW,STD')->nullable();
            $table->tinyInteger('threeYear_years')->default(3)->nullable();
            $table->integer('threeYear_dpds')->default(0)->nullable();
            $table->string('above_dpd_keywords')->default('*,000,01+,1+,30+,CLSD,NEW,STD')->nullable();
            $table->tinyInteger('aboveThreeYear_years')->default(3)->nullable();
            $table->integer('aboveThreeYear_dpds')->default(0)->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('grades', function (Blueprint $table) {
            $table->dropColumn('rejected');
            $table->dropColumn('checkDuplicates');
            $table->dropColumn('negative_area');
            $table->dropColumn('guarantor');
            $table->dropColumn('accountType');
            $table->dropColumn('no_owned_house');
            $table->dropColumn('zero_downpayment');
            $table->dropColumn('caseType');
            $table->dropColumn('ageAtLastEMI');
            $table->dropColumn('dpdCountRejection');
            $table->dropColumn('pastDues');
            $table->dropColumn('threeYear');
            $table->dropColumn('aboveThreeYear');
            $table->dropColumn('case_type_value');
            $table->dropColumn('ageAtLastEMI_age');
            $table->dropColumn('dpdCountRejection_years');
            $table->dropColumn('dpdCountRejection_dpds');
            $table->dropColumn('pastDues_value');
            $table->dropColumn('threeYear_years');
            $table->dropColumn('threeYear_dpds');
            $table->dropColumn('aboveThreeYear_years');
            $table->dropColumn('aboveThreeYear_dpds');
        });
    }
}