How to write a migrate to undo the unique constraint in Laravel?

php laravel laravel-4 laravel-5 database-migration
cyber8200 picture cyber8200 · Jun 3, 2015 · Viewed 16.3k times · Source

I would do this to make my email field unique in the table.

$table->unique('email');

I've tried

public function up()
{
    Schema::table('contacts', function(Blueprint $table)
    {
        $table->dropUnique('email');
    });
}

Then, when I run php artisan migrate, I got this

enter image description here

It tell me that it's not there, but I'm 100% sure that it's there.

enter image description here

How do write a migration to undo that ?

Answer

Ali Gajani picture Ali Gajani · Jun 3, 2015

You have to do $table->dropUnique('users_email_unique');

To drop an index you must specify the index's name. Laravel assigns a reasonable name to the indexes by default. Simply concatenate the table name, the names of the column in the index, and the index type.

Related questions

How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?

I would like to make a timestamp column with a default value of CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP using the Laravel Schema Builder/Migrations. I have gone through the Laravel documentation several times, and I don't see how I …

Read More
Laravel Check If Related Model Exists

I have an Eloquent model which has a related model: public function option() { return $this->hasOne('RepairOption', 'repair_item_id'); } public function setOptionArrayAttribute($values) { $this->option->update($values); } When I create the model, it does not necessarily …

Read More
Can I do Model->where('id', ARRAY) multiple where conditions?

The title says it all. I get that I can do this : DB::table('items')->where('something', 'value')->get() But what I want to check the where condition for multiple values like so: DB::table('items')…

Read More