Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel Schema Builder alter storage engine

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');
    });
}
like image 391
Gravy Avatar asked Dec 16 '14 08:12

Gravy


1 Answers

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');
like image 153
lukasgeiter Avatar answered Nov 20 '22 20:11

lukasgeiter