{"action":"created","issue":{"url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1967","repository_url":"https://api.github.com/repos/zooniverse/Panoptes","labels_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1967/labels{/name}","comments_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1967/comments","events_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1967/events","html_url":"https://github.com/zooniverse/Panoptes/issues/1967","id":177208706,"number":1967,"title":"Add index for valid_email column","user":{"login":"astopy","id":428423,"avatar_url":"https://avatars.githubusercontent.com/u/428423?v=3","gravatar_id":"","url":"https://api.github.com/users/astopy","html_url":"https://github.com/astopy","followers_url":"https://api.github.com/users/astopy/followers","following_url":"https://api.github.com/users/astopy/following{/other_user}","gists_url":"https://api.github.com/users/astopy/gists{/gist_id}","starred_url":"https://api.github.com/users/astopy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/astopy/subscriptions","organizations_url":"https://api.github.com/users/astopy/orgs","repos_url":"https://api.github.com/users/astopy/repos","events_url":"https://api.github.com/users/astopy/events{/privacy}","received_events_url":"https://api.github.com/users/astopy/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-09-15T15:27:52Z","updated_at":"2016-11-15T13:28:07Z","closed_at":"2016-11-15T13:28:07Z","body":"It looks like there's no index for this field (in the `users` table). We use this to avoid including invalid addresses on our mailing lists, so it should really be indexed.\n"},"comment":{"url":"https://api.github.com/repos/zooniverse/Panoptes/issues/comments/260640820","html_url":"https://github.com/zooniverse/Panoptes/issues/1967#issuecomment-260640820","issue_url":"https://api.github.com/repos/zooniverse/Panoptes/issues/1967","id":260640820,"user":{"login":"camallen","id":295329,"avatar_url":"https://avatars.githubusercontent.com/u/295329?v=3","gravatar_id":"","url":"https://api.github.com/users/camallen","html_url":"https://github.com/camallen","followers_url":"https://api.github.com/users/camallen/followers","following_url":"https://api.github.com/users/camallen/following{/other_user}","gists_url":"https://api.github.com/users/camallen/gists{/gist_id}","starred_url":"https://api.github.com/users/camallen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camallen/subscriptions","organizations_url":"https://api.github.com/users/camallen/orgs","repos_url":"https://api.github.com/users/camallen/repos","events_url":"https://api.github.com/users/camallen/events{/privacy}","received_events_url":"https://api.github.com/users/camallen/received_events","type":"User","site_admin":false},"created_at":"2016-11-15T13:28:07Z","updated_at":"2016-11-15T13:28:07Z","body":"closing this based on the results of the PR work."}}
{"actor":{"display_login":"camallen"}}