{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/181","repository_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql","labels_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/181/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/181/comments","events_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/181/events","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/issues/181","id":187900834,"number":181,"title":"Complete securityEvent db tweaks from #180","user":{"login":"rfk","id":34695,"avatar_url":"https://avatars.githubusercontent.com/u/34695?v=3","gravatar_id":"","url":"https://api.github.com/users/rfk","html_url":"https://github.com/rfk","followers_url":"https://api.github.com/users/rfk/followers","following_url":"https://api.github.com/users/rfk/following{/other_user}","gists_url":"https://api.github.com/users/rfk/gists{/gist_id}","starred_url":"https://api.github.com/users/rfk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfk/subscriptions","organizations_url":"https://api.github.com/users/rfk/orgs","repos_url":"https://api.github.com/users/rfk/repos","events_url":"https://api.github.com/users/rfk/events{/privacy}","received_events_url":"https://api.github.com/users/rfk/received_events","type":"User","site_admin":false},"labels":[{"id":241442548,"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/labels/waffle:next","name":"waffle:next","color":"ededed","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-08T04:44:15Z","updated_at":"2016-11-28T17:27:20Z","closed_at":null,"body":"This is a follow-up to #180.  Once that code is successfully deployed, we'll be able to remove the `tokenId` column from the `securityEvents` table.  The migration will need to:\r\n\r\n* drop the tokenId column\r\n* drop the corresponding securityEvents_uid_tokenId index"},"comment":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/comments/263335698","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/issues/181#issuecomment-263335698","issue_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/181","id":263335698,"user":{"login":"vladikoff","id":128755,"avatar_url":"https://avatars.githubusercontent.com/u/128755?v=3","gravatar_id":"","url":"https://api.github.com/users/vladikoff","html_url":"https://github.com/vladikoff","followers_url":"https://api.github.com/users/vladikoff/followers","following_url":"https://api.github.com/users/vladikoff/following{/other_user}","gists_url":"https://api.github.com/users/vladikoff/gists{/gist_id}","starred_url":"https://api.github.com/users/vladikoff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vladikoff/subscriptions","organizations_url":"https://api.github.com/users/vladikoff/orgs","repos_url":"https://api.github.com/users/vladikoff/repos","events_url":"https://api.github.com/users/vladikoff/events{/privacy}","received_events_url":"https://api.github.com/users/vladikoff/received_events","type":"User","site_admin":false},"created_at":"2016-11-28T17:27:20Z","updated_at":"2016-11-28T17:27:20Z","body":"cc @rfk"}}
{"actor":{"display_login":"vladikoff"}}