Database Forge create table format

[eluser]joytopia[/eluser]
Hi,

probably it would be a good idea, to add the TYPE as optional parameter to Database Forge.
Or at least in the config file, it should be possible to set the default TYPE.

In my application I only use mySQL. I want to make remote upgrades to several instances of the application.

So perhaps it is the simplest make a sql query like this:

Code:

$query = $this->db->query("

        CREATE TABLE IF NOT EXISTS `test` (
          `id` mediumint(8) unsigned NOT NULL auto_increment,          
          PRIMARY KEY  (`id`)
        ) TYPE=InnoDB;

");

Best regards
Bernd