Set storage engine inside a DB migration file

Hi All

I just noticed that the storage engine for all my tables is MyISAM, but I need InnoDB. For example, in a migration file I create tables like

$this->createTable('tbl_user', array(

            'id'           => 'pk',

            .... )) ;

So, I can specify column names and indixes, but how is the storage engine defined in here ? ( I don’t want to change the MySQL config file for this!)



Use the third parameter of createTable() method:

$this->createTable('tbl_user', array(...), 'ENGINE InnoDB');