Trouble With Database Migrations ( 1.1.14 )

CroftyUK · September 9, 2013, 9:54pm

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?

kumarkulandai · September 11, 2013, 5:47am

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