<?php

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

class CreateMerchantRiskMitigationTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('merchant_risk_mitigation', function (Blueprint $table) {
            
            $table->softDeletes(); 
            $table->bigIncrements('id');
            
            // FOREIGN KEY: Matches 'int unsigned' from your merchant table
            $table->unsignedInteger('merchant_id')->unique(); 

            // 1. security_cheque (0 or 1)
            $table->tinyInteger('security_cheque')->nullable()->comment('0: No, 1: Yes');

            // 2. pm_surayaghar (0 or 1)
            $table->tinyInteger('pm_surayaghar')->nullable()->comment('0: No, 1: Yes');

            // 3. solar_power_type (e.g., "1,2")
            $table->string('solar_power_type')->nullable(); 

            // 4. solar_category (e.g., "1,2,3")
            $table->string('solar_category')->nullable();

            // 5. solar_location (Comma separated state names)
            $table->text('solar_location')->nullable();

            $table->timestamps();

            // Relationship Constraint
            $table->foreign('merchant_id')
                  ->references('id')
                  ->on('merchant')
                  ->onDelete('cascade');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('merchant_risk_mitigation');
    }
}