{"action":"created","issue":{"url":"https://api.github.com/repos/gratipay/gratipay.com/issues/3864","labels_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/3864/labels{/name}","comments_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/3864/comments","events_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/3864/events","html_url":"https://github.com/gratipay/gratipay.com/pull/3864","id":120489063,"number":3864,"title":"Updated schema for emails.participant to refer to participants.id","user":{"login":"sammyshj","id":4390022,"avatar_url":"https://avatars.githubusercontent.com/u/4390022?v=3","gravatar_id":"","url":"https://api.github.com/users/sammyshj","html_url":"https://github.com/sammyshj","followers_url":"https://api.github.com/users/sammyshj/followers","following_url":"https://api.github.com/users/sammyshj/following{/other_user}","gists_url":"https://api.github.com/users/sammyshj/gists{/gist_id}","starred_url":"https://api.github.com/users/sammyshj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sammyshj/subscriptions","organizations_url":"https://api.github.com/users/sammyshj/orgs","repos_url":"https://api.github.com/users/sammyshj/repos","events_url":"https://api.github.com/users/sammyshj/events{/privacy}","received_events_url":"https://api.github.com/users/sammyshj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-04T21:24:56Z","updated_at":"2015-12-19T02:39:38Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/gratipay/gratipay.com/pulls/3864","html_url":"https://github.com/gratipay/gratipay.com/pull/3864","diff_url":"https://github.com/gratipay/gratipay.com/pull/3864.diff","patch_url":"https://github.com/gratipay/gratipay.com/pull/3864.patch"},"body":"Changes made in this PR:\r\n* Added `sql/branch.sql`. The `emails.participant` now refers to `participants.id` rather than `participants.username`.\r\n\r\n@whit537 , the tests fail now as the schema is now changed. Please let me know if the schema change looks good and I will move ahead with fixing the tests."},"comment":{"url":"https://api.github.com/repos/gratipay/gratipay.com/issues/comments/165937562","html_url":"https://github.com/gratipay/gratipay.com/pull/3864#issuecomment-165937562","issue_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/3864","id":165937562,"user":{"login":"whit537","id":134455,"avatar_url":"https://avatars.githubusercontent.com/u/134455?v=3","gravatar_id":"","url":"https://api.github.com/users/whit537","html_url":"https://github.com/whit537","followers_url":"https://api.github.com/users/whit537/followers","following_url":"https://api.github.com/users/whit537/following{/other_user}","gists_url":"https://api.github.com/users/whit537/gists{/gist_id}","starred_url":"https://api.github.com/users/whit537/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whit537/subscriptions","organizations_url":"https://api.github.com/users/whit537/orgs","repos_url":"https://api.github.com/users/whit537/repos","events_url":"https://api.github.com/users/whit537/events{/privacy}","received_events_url":"https://api.github.com/users/whit537/received_events","type":"User","site_admin":false},"created_at":"2015-12-19T02:39:38Z","updated_at":"2015-12-19T02:39:38Z","body":"Ping @sammyshj. Are you stuck here? Can we help you get unstuck? :-)"}}