Add an index to the user email field to speed up searches (#570)
Merge pull request #572 from MTG/570-email-index

Add an index to the user email field to speed up searches (#570)
#488 small changes in api docs
#488 more small changes in api docs
#488 fixed typo in api docs
#488 Adding authorization page in the api docs
#488 Adding authorization page in the api docs
#488 adding oauth required to resources that required it
#488 Removing scope column in api credentials list
#488 improving authentication docs
#488 updated todo
#488 Adding backslash to authentication examples
#488 Added log when creating new api credentials
#488 updated todo
Add indexes to downloads table to make selects faster

The combination of a WHERE, ORDER BY, and LIMIT meant that we were
ordering entries first before filtering the relevant ones when showing
lists of sounds, packs, and people. Instead, we create three new
composite indexes:

sounds_download(sound_id, created):
For people who downloaded a specific sound

sounds_download(user_id, created)
For sounds downloaded by a specific user

sounds_download(pack_id, created) WHERE pack_id IS NOT NULL
For packs downloaded by a specific user
We have a partial index where pack_id is not null because there are
so many sounds in this table - we don't want to have to always
skip over these rows
#488 Adding https to freesound redirect url
#488 several improvements in redirect uri domain handling
Merge branch 'speedups'
#488 completed api authentication docummentation and fixed a bug regarding access token scopes
#488 changed return_invalid_url for invalid_url in apiv2 views so browseable api nicely prints title