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.
deprecating proc ad_ssl_available_p and replacing it with security::https_available_p. Making sure we do not redirect to HTTPS if AOLserver is not configured to support it