mysql - Laravel Schema Builder alter storage engine -
i trying alter table , change it's storage engine innodb
. when run php artisan migrate
completes without error. when check storage engine in sequel pro, nothing 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 believe, i'm can define storage engine when create table schema::create()
.
can use raw sql last resort:
db::statement('alter table tests engine = innodb');
Comments
Post a Comment