{"action":"created","issue":{"url":"https://api.github.com/repos/scrapinghub/frontera/issues/161","repository_url":"https://api.github.com/repos/scrapinghub/frontera","labels_url":"https://api.github.com/repos/scrapinghub/frontera/issues/161/labels{/name}","comments_url":"https://api.github.com/repos/scrapinghub/frontera/issues/161/comments","events_url":"https://api.github.com/repos/scrapinghub/frontera/issues/161/events","html_url":"https://github.com/scrapinghub/frontera/pull/161","id":161156319,"number":161,"title":"Fix SQL integer type for crc32 field","user":{"login":"lopuhin","id":424613,"avatar_url":"https://avatars.githubusercontent.com/u/424613?v=3","gravatar_id":"","url":"https://api.github.com/users/lopuhin","html_url":"https://github.com/lopuhin","followers_url":"https://api.github.com/users/lopuhin/followers","following_url":"https://api.github.com/users/lopuhin/following{/other_user}","gists_url":"https://api.github.com/users/lopuhin/gists{/gist_id}","starred_url":"https://api.github.com/users/lopuhin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lopuhin/subscriptions","organizations_url":"https://api.github.com/users/lopuhin/orgs","repos_url":"https://api.github.com/users/lopuhin/repos","events_url":"https://api.github.com/users/lopuhin/events{/privacy}","received_events_url":"https://api.github.com/users/lopuhin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":12,"created_at":"2016-06-20T09:45:32Z","updated_at":"2016-08-11T10:07:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/scrapinghub/frontera/pulls/161","html_url":"https://github.com/scrapinghub/frontera/pull/161","diff_url":"https://github.com/scrapinghub/frontera/pull/161.diff","patch_url":"https://github.com/scrapinghub/frontera/pull/161.patch"},"body":"CRC32 is an unsigned 4-byte int, so it does not fit in a signed 4-byte int (``Integer``). There is no unsigned int type in the SQL standard, so I changed it to ``BigInteger `` instead. Without this change, both MySQL and Postgres complain that ``host_crc32`` field value is out of bounds. \r\nAnother option (to save space) would be to conver CRC32 into a signed 4-bit int, but this will complicate things, not sure it's worth it."},"comment":{"url":"https://api.github.com/repos/scrapinghub/frontera/issues/comments/239120999","html_url":"https://github.com/scrapinghub/frontera/pull/161#issuecomment-239120999","issue_url":"https://api.github.com/repos/scrapinghub/frontera/issues/161","id":239120999,"user":{"login":"Preetwinder","id":9640238,"avatar_url":"https://avatars.githubusercontent.com/u/9640238?v=3","gravatar_id":"","url":"https://api.github.com/users/Preetwinder","html_url":"https://github.com/Preetwinder","followers_url":"https://api.github.com/users/Preetwinder/followers","following_url":"https://api.github.com/users/Preetwinder/following{/other_user}","gists_url":"https://api.github.com/users/Preetwinder/gists{/gist_id}","starred_url":"https://api.github.com/users/Preetwinder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Preetwinder/subscriptions","organizations_url":"https://api.github.com/users/Preetwinder/orgs","repos_url":"https://api.github.com/users/Preetwinder/repos","events_url":"https://api.github.com/users/Preetwinder/events{/privacy}","received_events_url":"https://api.github.com/users/Preetwinder/received_events","type":"User","site_admin":false},"created_at":"2016-08-11T10:07:17Z","updated_at":"2016-08-11T10:07:17Z","body":"+1. Looks good."}}
{"actor":{"display_login":"Preetwinder"}}