#93 Change Storage Engine for MySQL tables to InnoDB

[Sergio Gutierrez]

By changing the storage engine of MySQL tables to InnoDB, would it be possible to use the power, performance and scalability in the OpenSER database; InnoDB is included by default with the MySQL distrbution, so, it should not create a portability problem.

[Sergio Gutierrez]

Logged In: YES
user_id=1960760
Originator: YES

The attached patches implements within openserdbctl.mysql a function which allows to convert the tables related to a particular module to InnoDB MySQL storage engine and define variables in openserdbctl.base to control which set of tables could be converted to this Storage Engine (So that the scripts asks it).
As said, it works in a per module basis, reading from the create scripts the table names associated.

Also, the patch renames the variable TABLE to MODULE in the for cycles which create several tables (Standard and Extra modules) so that the index of the for be more expressive.
File Added: InnoDBPatch.tar

[Sergio Gutierrez]

Patches for MySQL scripts to support InnoDB Table Conversion