{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/7","labels_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/7/comments","events_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/7/events","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/7","id":56559400,"number":7,"title":"feat: Account locked feature.","user":{"login":"shane-tomlinson","id":848085,"avatar_url":"https://avatars.githubusercontent.com/u/848085?v=3","gravatar_id":"","url":"https://api.github.com/users/shane-tomlinson","html_url":"https://github.com/shane-tomlinson","followers_url":"https://api.github.com/users/shane-tomlinson/followers","following_url":"https://api.github.com/users/shane-tomlinson/following{/other_user}","gists_url":"https://api.github.com/users/shane-tomlinson/gists{/gist_id}","starred_url":"https://api.github.com/users/shane-tomlinson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shane-tomlinson/subscriptions","organizations_url":"https://api.github.com/users/shane-tomlinson/orgs","repos_url":"https://api.github.com/users/shane-tomlinson/repos","events_url":"https://api.github.com/users/shane-tomlinson/events{/privacy}","received_events_url":"https://api.github.com/users/shane-tomlinson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/labels/waffle:needs%20review","name":"waffle:needs review","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-02-04T17:29:44Z","updated_at":"2015-02-05T14:25:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/pulls/7","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/7","diff_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/7.diff","patch_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/7.patch"},"body":"* Add `lockAccount`, `unlockAccount`, and `unlockCode` db functions.\r\n* Add a new `lockedAt` column to the `accounts` table.\r\n* Update `emailRecord` and `account` to return `lockedAt`\r\n* Add `accountUnlockCodes` table to keep track of account unlock codes\r\n\r\nPieced together from:\r\n* https://github.com/mozilla/fxa-auth-db-server/pull/91\r\n* https://github.com/chilts/fxa-auth-db-server/pull/2\r\n* My own additions."},"comment":{"url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/comments/73053641","html_url":"https://github.com/mozilla/fxa-auth-db-mysql/pull/7#issuecomment-73053641","issue_url":"https://api.github.com/repos/mozilla/fxa-auth-db-mysql/issues/7","id":73053641,"user":{"login":"shane-tomlinson","id":848085,"avatar_url":"https://avatars.githubusercontent.com/u/848085?v=3","gravatar_id":"","url":"https://api.github.com/users/shane-tomlinson","html_url":"https://github.com/shane-tomlinson","followers_url":"https://api.github.com/users/shane-tomlinson/followers","following_url":"https://api.github.com/users/shane-tomlinson/following{/other_user}","gists_url":"https://api.github.com/users/shane-tomlinson/gists{/gist_id}","starred_url":"https://api.github.com/users/shane-tomlinson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shane-tomlinson/subscriptions","organizations_url":"https://api.github.com/users/shane-tomlinson/orgs","repos_url":"https://api.github.com/users/shane-tomlinson/repos","events_url":"https://api.github.com/users/shane-tomlinson/events{/privacy}","received_events_url":"https://api.github.com/users/shane-tomlinson/received_events","type":"User","site_admin":false},"created_at":"2015-02-05T14:25:19Z","updated_at":"2015-02-05T14:25:19Z","body":"> So yeah...I couldn't help giving a high-level review pass while I was here. This is looking really solid.\r\n\r\nThanks for the drive by!"}}