How to drop softDeletes from a table in a migration

miken32 picture miken32 · May 30, 2016 · Viewed 21.4k times · Source

I'm adding the soft delete columns to my table in a migration:

public function up()
{
    Schema::table("users", function ($table) {
        $table->softDeletes();
    });
}

But, how can I remove these in my down() function, if I roll back the migration? Is there a built-in method to do this, or do I just manually delete the columns that get added?

Answer

Álvaro Guimarães picture Álvaro Guimarães · May 30, 2016

On your migration class:

public function down()
{
    Schema::table("users", function ($table) {
        $table->dropSoftDeletes();
    });
}

Illuminate\Database\Schema\Blueprint.php:

public function dropSoftDeletes()
{
    $this->dropColumn('deleted_at');
}

Since Laravel 5.5, this information can be found in the documentation.