How to make column unique and index it in Laravel Migration?

Question

I would like to alter my one of my column on my table - and make them a unique index.

I tried :

public function up()
{
    Schema::table('inventories', function($table)
    {           
        $table->string('sku',255)->unique();
    });
}

I get :

What is the most efficient way to do that ?

Answer 1

You can add indexes separately from their definition. As documented here

Schema::table('inventories', function($table)
{
    $table->unique('sku');
});

Answer 2

I got it.

I did this :

public function up()
{           
    DB::update('alter table `inventories` modify `sku` VARCHAR(200) UNIQUE NOT NULL');
}

and now It works :