{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/socorro/issues/3305","repository_url":"https://api.github.com/repos/mozilla/socorro","labels_url":"https://api.github.com/repos/mozilla/socorro/issues/3305/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/socorro/issues/3305/comments","events_url":"https://api.github.com/repos/mozilla/socorro/issues/3305/events","html_url":"https://github.com/mozilla/socorro/pull/3305","id":150945246,"number":3305,"title":"fixes bug 1267301 - Postgres table for storing correlations","user":{"login":"peterbe","id":26739,"avatar_url":"https://avatars.githubusercontent.com/u/26739?v=3","gravatar_id":"","url":"https://api.github.com/users/peterbe","html_url":"https://github.com/peterbe","followers_url":"https://api.github.com/users/peterbe/followers","following_url":"https://api.github.com/users/peterbe/following{/other_user}","gists_url":"https://api.github.com/users/peterbe/gists{/gist_id}","starred_url":"https://api.github.com/users/peterbe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterbe/subscriptions","organizations_url":"https://api.github.com/users/peterbe/orgs","repos_url":"https://api.github.com/users/peterbe/repos","events_url":"https://api.github.com/users/peterbe/events{/privacy}","received_events_url":"https://api.github.com/users/peterbe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"adngdb","id":328790,"avatar_url":"https://avatars.githubusercontent.com/u/328790?v=3","gravatar_id":"","url":"https://api.github.com/users/adngdb","html_url":"https://github.com/adngdb","followers_url":"https://api.github.com/users/adngdb/followers","following_url":"https://api.github.com/users/adngdb/following{/other_user}","gists_url":"https://api.github.com/users/adngdb/gists{/gist_id}","starred_url":"https://api.github.com/users/adngdb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adngdb/subscriptions","organizations_url":"https://api.github.com/users/adngdb/orgs","repos_url":"https://api.github.com/users/adngdb/repos","events_url":"https://api.github.com/users/adngdb/events{/privacy}","received_events_url":"https://api.github.com/users/adngdb/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2016-04-25T18:28:56Z","updated_at":"2016-05-02T18:32:44Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mozilla/socorro/pulls/3305","html_url":"https://github.com/mozilla/socorro/pull/3305","diff_url":"https://github.com/mozilla/socorro/pull/3305.diff","patch_url":"https://github.com/mozilla/socorro/pull/3305.patch"},"body":"This was tricky to make. But I think I figured it out and I have no, in my local psql, a nice looking table. \r\n\r\nHere's how I created it:\r\n\r\n```\r\n$ dropdb \r\n$ createdb socorro_integration_test\r\n$ PYTHONPATH=. python socorro/external/postgresql/setupdb_app.py --database_name=socorro_integration_test --database_username=peterbe --database_password=secret --database_superusername=peterbe --database_superuserpassword=secret\r\n$ alembic -c config/alembic.ini revision --autogenerate -m 'correlations table'\r\n$ jed alembic/versions/373ef4569b93_correlations_table.py\r\n```"},"comment":{"url":"https://api.github.com/repos/mozilla/socorro/issues/comments/216320927","html_url":"https://github.com/mozilla/socorro/pull/3305#issuecomment-216320927","issue_url":"https://api.github.com/repos/mozilla/socorro/issues/3305","id":216320927,"user":{"login":"peterbe","id":26739,"avatar_url":"https://avatars.githubusercontent.com/u/26739?v=3","gravatar_id":"","url":"https://api.github.com/users/peterbe","html_url":"https://github.com/peterbe","followers_url":"https://api.github.com/users/peterbe/followers","following_url":"https://api.github.com/users/peterbe/following{/other_user}","gists_url":"https://api.github.com/users/peterbe/gists{/gist_id}","starred_url":"https://api.github.com/users/peterbe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/peterbe/subscriptions","organizations_url":"https://api.github.com/users/peterbe/orgs","repos_url":"https://api.github.com/users/peterbe/repos","events_url":"https://api.github.com/users/peterbe/events{/privacy}","received_events_url":"https://api.github.com/users/peterbe/received_events","type":"User","site_admin":false},"created_at":"2016-05-02T18:32:44Z","updated_at":"2016-05-02T18:32:44Z","body":"@adngdb Ugh! I'm failing at this PR. Hopefully I get it right this time. "}}