Adds index to authentications table for UID column. Updates API and tests to utilize 'id' for UUID field rather than 'uid'.