I am trying to alter a table and change it's storage engine to InnoDb
. When I run php artisan migrate
it completes without error. However when I check the storage engine in Sequel Pro, nothing is changed.
public function up()
{
Schema::table('tests', function(Blueprint $t) {
$t->engine = 'InnoDB';
$t->foreign('group_id')->references('id')->on('test_groups')->onDelete('restrict');
});
}
Since @alexrussell confirmed my believe, I'm almost certain you can only define the storage engine when you create the table with Schema::create()
.
However you can always use raw SQL as a last resort:
DB::statement('ALTER TABLE tests ENGINE = InnoDB');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With