Fix for challenges failure tests.
Merge pull request #118 from LazyChild/develop

Fix for challenges failure tests.
Fixed and cleaned up query.
Cleanup.
Release Assembly - Member Profile Queries Performance Improvement
Merge remote-tracking branch 'upstream/master' into profile

Conflicts:
	queries/get_software_member_statistics_track
	queries/get_user_basic_profile_rating_summary
Update to use handle_lower instead of LOWER(handle) so we can use index in database.
Fix merge issue in get_user_basic_profile_rating_summary query.
Add Short Event Description
Merge branch 'master' into short_even_desc
Add Reset Token API
Add Reset Password API
Merge pull request #119 from Ghost141/profile

Release Assembly - Member Profile Queries Performance Improvement
Agree Term Of Use API
billing api - remove subscription_number
billing api - remove subscription_number - solved merge conflicts
Merge pull request #121 from GeezerButler/master

Pull Request for Create Billing API Update
Merge pull request #120 from hesibo/master

Agree Term Of Use API
Cache 10 min.
Module Assembly - TopCoder NodeJS Develop Review Opportunity Detail API 1.0