cloudfoundry/uaa — pull request #70 by fhanik (2014-03-06 14:45:53+00:00)
Title: Normalize sql table column names

Ensure that table names and column names are all lower case across all databases, and that is the standard going forward.

to run the unit test against 1.5.3 database
MySQL (fails - MySQL is case sensitive)
mvn -Dtest=org.cloudfoundry.identity.uaa.db.TableAndColumnNormalizationTest test -Dspring.profiles.active=mysql -DfailIfNoTests=false -Ddb.target=1.5.3 2>&1

PostgreSQL (succeeds - PostgreSQL automatically converts to lower case)
mvn -Dtest=org.cloudfoundry.identity.uaa.db.TableAndColumnNormalizationTest test -Dspring.profiles.active=mysql -DfailIfNoTests=false -Ddb.target=1.5.3 2>&1

to run the unit test against 1.5.4 database
MySQL (must succeed, we've renamed columns)
mvn -Dtest=org.cloudfoundry.identity.uaa.db.TableAndColumnNormalizationTest test -Dspring.profiles.active=mysql -DfailIfNoTests=false -Ddb.target=1.5.4 2>&1

PostgreSQL (succeeds - PostgreSQL automatically converts to lower case)
mvn -Dtest=org.cloudfoundry.identity.uaa.db.TableAndColumnNormalizationTest test -Dspring.profiles.active=mysql -DfailIfNoTests=false -Ddb.target=1.5.4 2>&1

See PR comments for details on this commit.