<?php

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

class AddIndexesToCampaignLeadAndLeads extends Migration
{
    public function up()
    {
        Schema::table('campaign_lead', function (Blueprint $table) {
            $table->index(['campaign_id', 'lead_id'], 'idx_campaign_lead_campaign_lead');
            $table->index('campaign_id', 'idx_campaign_lead_campaign_id');
            $table->index('lead_id', 'idx_campaign_lead_lead_id');
        });

        Schema::table('leads', function (Blueprint $table) {
            $table->index('created_at', 'idx_leads_created_at');
        });
    }

    public function down()
    {
        Schema::table('campaign_lead', function (Blueprint $table) {
            $table->dropIndex('idx_campaign_lead_campaign_lead');
            $table->dropIndex('idx_campaign_lead_campaign_id');
            $table->dropIndex('idx_campaign_lead_lead_id');
        });

        Schema::table('leads', function (Blueprint $table) {
            $table->dropIndex('idx_leads_created_at');
        });
    }
}