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!)

Cheers

Luca

Use the third parameter of createTable() method:




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



thnx