Roberto Musso at IBM is helping to improve Mifos cross-platform compatibility by fixing issue #1513 (and is doing an excellent job so far). If you maintain your own scripts that directly access a Mifos database (especially on a non-Windows platform) there are upcoming changes in the Mifos database structure that you should be aware of. Specifically, table name casing.
First, a bit of background: Since table names in MySQL are--by default--case-sensitive on some platforms and not on others, a workaround is currently necessary for cross-platform portability when, for instance, dumping and restoring a Mifos database. The MySQL docs recommend settling on a naming convention for all table names; specifically, using only lowercase is recommended. And this is what we'll do! Windows-only users probably will not notice the change since the default on this platform is to ignore table name casing. Note that, according to http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html ... "Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive, which differs from standard SQL." Since we don't use named triggers, the only bits we need to change in the code are the table names. Database naming does not seem relevant, but please let me know if I'm incorrect in this assumption. I'm considering: * databases must be created by hand outside of Mifos * when executing a dump or restore, the database name must be specified by hand * by default, database names are not included in database backups Here's the issue that is being worked on: https://mifos.dev.java.net/issues/show_bug.cgi?id=1513 -- Adam Monsen ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Mifos-functional mailing list Mifos-functional@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-functional
