Trouble With Database Migrations ( 1.1.14 )

Hi, this is my first post and unsure weather right location.

But here goes anyway.

I’ve setup 3 Migrations for my project.

Each of my migrations try’s to set an Engine type to InnoDB in the options param of createTable like:




 $this->createTable('table_name',

            array(

               

            ),'ENGINE=INNODB'

        );



The issue I’m having is that the 3 migrations execute and create the tables in my database.

But only the last executed migration has the correct engine type set… the first two default to "MyIASM".

What could i possibly be doing wrong?

you can also set innodb as the default storage engine for mysql database

more detail from this link

http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html

https://www.google.co.in/search?newwindow=1&site=&source=hp&q=mysql+change+default+storage+engine+to+innodb&oq=change+mysql+default+storage+to+inn&gs_l=hp.1.0.0i22i30l2.1251.13628.0.15767.49.32.6.11.12.3.488.5650.6j16j4j4j2.32.0…0…1c.1.26.hp…13.36.3000.Zggenlz-hMU