Level 51
There's a warning in the docs that this isn't supported
Dropping or modifying multiple columns within a single migration while using a SQLite database is not supported.
Split your operations into two migrations.
3 likes
Nov 6, 2018
2
Level 1
Cannot drop column and add new columns in same migration
I've created a migration that is supposed to drop columns as well as create new ones. When I drop the column, the migration does not add the the columns.
When I remove the dropColumn call, the columns are added just fine. I use SQLite.
Here's the simplified version:
Schema::table('table', function($table) {
$table->integer('new_column_name')->nullable();
$table->dropColumn('old_column_name');
});
Level 14
try this
Schema::table('table', function($table) {
$table->integer('new_column_name')->nullable();
});
Schema::table('table', function($table) {
$table->dropColumn('old_column_name');
});
3 likes
Please or to participate in this conversation.