Use lower(username) rather than upper(username), create case folded indexes on postgres for username, email, screen_name, move some of the queries in community-core-procs to .xql file.
Change the all_users to acs_users_all, bump version to 5.0.0b3, provide upgrade script. fix where its used in logger, weblogger-portlet, and lars-blogger. fixes bug 1174.