{"action":"created","issue":{"url":"https://api.github.com/repos/guardian/bonobo/issues/71","labels_url":"https://api.github.com/repos/guardian/bonobo/issues/71/labels{/name}","comments_url":"https://api.github.com/repos/guardian/bonobo/issues/71/comments","events_url":"https://api.github.com/repos/guardian/bonobo/issues/71/events","html_url":"https://github.com/guardian/bonobo/pull/71","id":118681470,"number":71,"title":"Add index on the users table email field in Dynamo","user":{"login":"cb372","id":106760,"avatar_url":"https://avatars.githubusercontent.com/u/106760?v=3","gravatar_id":"","url":"https://api.github.com/users/cb372","html_url":"https://github.com/cb372","followers_url":"https://api.github.com/users/cb372/followers","following_url":"https://api.github.com/users/cb372/following{/other_user}","gists_url":"https://api.github.com/users/cb372/gists{/gist_id}","starred_url":"https://api.github.com/users/cb372/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cb372/subscriptions","organizations_url":"https://api.github.com/users/cb372/orgs","repos_url":"https://api.github.com/users/cb372/repos","events_url":"https://api.github.com/users/cb372/events{/privacy}","received_events_url":"https://api.github.com/users/cb372/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-24T19:07:58Z","updated_at":"2015-11-25T10:01:51Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/guardian/bonobo/pulls/71","html_url":"https://github.com/guardian/bonobo/pull/71","diff_url":"https://github.com/guardian/bonobo/pull/71.diff","patch_url":"https://github.com/guardian/bonobo/pull/71.patch"},"body":"and a method that uses that index to check if a given email address is already registered.\n\nDoing this with a scan instead of an index query is unusably slow."},"comment":{"url":"https://api.github.com/repos/guardian/bonobo/issues/comments/159557233","html_url":"https://github.com/guardian/bonobo/pull/71#issuecomment-159557233","issue_url":"https://api.github.com/repos/guardian/bonobo/issues/71","id":159557233,"user":{"login":"LATaylor-guardian","id":8861681,"avatar_url":"https://avatars.githubusercontent.com/u/8861681?v=3","gravatar_id":"","url":"https://api.github.com/users/LATaylor-guardian","html_url":"https://github.com/LATaylor-guardian","followers_url":"https://api.github.com/users/LATaylor-guardian/followers","following_url":"https://api.github.com/users/LATaylor-guardian/following{/other_user}","gists_url":"https://api.github.com/users/LATaylor-guardian/gists{/gist_id}","starred_url":"https://api.github.com/users/LATaylor-guardian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LATaylor-guardian/subscriptions","organizations_url":"https://api.github.com/users/LATaylor-guardian/orgs","repos_url":"https://api.github.com/users/LATaylor-guardian/repos","events_url":"https://api.github.com/users/LATaylor-guardian/events{/privacy}","received_events_url":"https://api.github.com/users/LATaylor-guardian/received_events","type":"User","site_admin":false},"created_at":"2015-11-25T10:01:51Z","updated_at":"2015-11-25T10:01:51Z","body":"This looks good to me, and some nice tidy up to make the code more readable. :+1: "}}