Migrations: How can one Add an index to an existing column?

eh?

Guidelines for posting on Laracasts.com

This should get you started http://stackoverflow.com/questions/24419999/laravel-migration-change-and-make-column-nullable

Actually, looking at the API docs, it appears to be there;

http://laravel.com/api/4.2/Illuminate/Database/Schema/Blueprint.html

See the Master branch of the documentation for more info: http://laravel.com/docs/master/migrations#modifying-columns

@mstnorris I thought my title was clear and understandable, any pointers appreciated. @mass6 thanks , this means i need to rollback and change the migration file, quite messy :(

@Ace what is it that you want to change?

Just add a new migration and make your changes in that file within the up() method, and reverse the changes in the down() method.

@mstnorris this way I will loose the data.

''' [Illuminate\Database\QueryException]
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'trader_
id' (SQL: alter table leads add trader_id varchar(255) not null) '''

@mass6 is master for L5 ?

You can just do this right?

<?php

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

class AddIndexToLeads extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('leads', function(Blueprint $table)
        {
            $table->index('trader_id');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('leads', function (Blueprint $table)
        {
            $table->dropIndex(['trader_id']);
        });
    }

}

@Ace You don't need any raw statements for index.

Like @bobbybouwmann above, just pass the name of that index in dropIndex: eg. users_email_index OR an array of column(s) to let laravel guess the name: ['email']

master docs are L5.1, in L4 there is no modify methods.

@JarekTkaczyk You can only pass in the column name right? Or is the array needed there?

@bobbybouwmann If you pass a string, then it must be valid index name (not column) eg. users_email_index, but if you wish laravel take care of the name, then pass an array with column(s) name ['email'] (laravel will convert it to the valid index name, ie. users_email_index)

@JarekTkaczyk Thank you for the explanation, I updated my answer ;)

thanks for the explanations!