lack of case sensitivity in php/db leads to major problems in *nix

It appears there is no standard convention for case sensitivity in the 
database table names, as the original SQL file has all the table names in 
lowercase, while almost all the PHP calls are in CamelCase. This isn't a 
problem in a case-insensitive environment, e.g. Mac OS/X & Windows, but in 
a *nix environment, bob != Bob, so this spits out a ton of errors. It's a 
relatively simple fix, either change all the instances found in the PHP 
files, or just alter the DB file to reflect the proper case. I went with 
the latter, as it seemed to require the least amount of work, and solved 
the majority of the problems. A small few remain, but those can be found 
by just grepping for the offending table name and then just renaming them. 
I found one so far in:
api/requirement_api.php         FROM requirementversion

which should read:   FROM RequirementVersion

attached is an updated SQL file.

Original issue reported on code.google.com by nazir.ad...@gmail.com on 29 Jul 2008 at 9:53

Attachments:

DATABASE_SQL.txt

csossi / rth-turbo

lack of case sensitivity in php/db leads to major problems in *nix #3