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