Laravel migrations change default value of column Laravel migrations change default value of column laravel laravel

Laravel migrations change default value of column


You can use change() method:

Schema::table('users', function ($table) {    $table->integer('active')->default(0)->change();});

Then run migrate command.

Update

For Laravel 4 use something like this:

DB::statement('ALTER TABLE `users` CHANGE COLUMN `active` `active` INTEGER NOT NULL DEFAULT 0;');

Inside up() method instead of Schema::table(); clause.


You have to call the change function to update the column

if (Schema::hasTable('users')) {    Schema::table('users', function (Blueprint $table) {        if (Schema::hasColumn('users', 'active')) {            $table->integer('active')->default(0)->change();        }    });}


Create new migration file. and use change()

if (Schema::hasTable('users')) {    Schema::table('users', function (Blueprint $table) {        if (Schema::hasColumn('users', 'active')) {            $table->integer('active')->default(0)->change();        }    });}

And also be sure to add the doctrine/dbal dependency to your composer.json file