{"action":"opened","issue":{"url":"https://api.github.com/repos/mozilla/activity-streams/issues/564","repository_url":"https://api.github.com/repos/mozilla/activity-streams","labels_url":"https://api.github.com/repos/mozilla/activity-streams/issues/564/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/activity-streams/issues/564/comments","events_url":"https://api.github.com/repos/mozilla/activity-streams/issues/564/events","html_url":"https://github.com/mozilla/activity-streams/issues/564","id":150948785,"number":564,"title":"Table schema changes for Redshift","user":{"login":"ncloudioj","id":1455254,"avatar_url":"https://avatars.githubusercontent.com/u/1455254?v=3","gravatar_id":"","url":"https://api.github.com/users/ncloudioj","html_url":"https://github.com/ncloudioj","followers_url":"https://api.github.com/users/ncloudioj/followers","following_url":"https://api.github.com/users/ncloudioj/following{/other_user}","gists_url":"https://api.github.com/users/ncloudioj/gists{/gist_id}","starred_url":"https://api.github.com/users/ncloudioj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ncloudioj/subscriptions","organizations_url":"https://api.github.com/users/ncloudioj/orgs","repos_url":"https://api.github.com/users/ncloudioj/repos","events_url":"https://api.github.com/users/ncloudioj/events{/privacy}","received_events_url":"https://api.github.com/users/ncloudioj/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mozilla/activity-streams/labels/Reporting","name":"Reporting","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"ncloudioj","id":1455254,"avatar_url":"https://avatars.githubusercontent.com/u/1455254?v=3","gravatar_id":"","url":"https://api.github.com/users/ncloudioj","html_url":"https://github.com/ncloudioj","followers_url":"https://api.github.com/users/ncloudioj/followers","following_url":"https://api.github.com/users/ncloudioj/following{/other_user}","gists_url":"https://api.github.com/users/ncloudioj/gists{/gist_id}","starred_url":"https://api.github.com/users/ncloudioj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ncloudioj/subscriptions","organizations_url":"https://api.github.com/users/ncloudioj/orgs","repos_url":"https://api.github.com/users/ncloudioj/repos","events_url":"https://api.github.com/users/ncloudioj/events{/privacy}","received_events_url":"https://api.github.com/users/ncloudioj/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/mozilla/activity-streams/milestones/7","html_url":"https://github.com/mozilla/activity-streams/milestones/6.%20RC%202%20(Apr%2029)","labels_url":"https://api.github.com/repos/mozilla/activity-streams/milestones/7/labels","id":1682969,"number":7,"title":"6. RC 2 (Apr 29)","description":"","creator":{"login":"edmoz","id":3698618,"avatar_url":"https://avatars.githubusercontent.com/u/3698618?v=3","gravatar_id":"","url":"https://api.github.com/users/edmoz","html_url":"https://github.com/edmoz","followers_url":"https://api.github.com/users/edmoz/followers","following_url":"https://api.github.com/users/edmoz/following{/other_user}","gists_url":"https://api.github.com/users/edmoz/gists{/gist_id}","starred_url":"https://api.github.com/users/edmoz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edmoz/subscriptions","organizations_url":"https://api.github.com/users/edmoz/orgs","repos_url":"https://api.github.com/users/edmoz/repos","events_url":"https://api.github.com/users/edmoz/events{/privacy}","received_events_url":"https://api.github.com/users/edmoz/received_events","type":"User","site_admin":false},"open_issues":25,"closed_issues":19,"state":"open","created_at":"2016-04-04T20:17:52Z","updated_at":"2016-04-25T18:46:12Z","due_on":"2016-04-29T07:00:00Z","closed_at":null},"comments":0,"created_at":"2016-04-25T18:46:12Z","updated_at":"2016-04-25T18:46:12Z","closed_at":null,"body":"1. The `page` column sometimes gets truncated for some values in `activity_stream_events_daily` and `activity_stream_stats_daily`, e.g. its current VCHAR(16) is not enough for 'timeline_bookmarks', Redshift will automatically truncate it as 'timeline_bookmar'. \r\n\r\n  To fix this, we need to:\r\n  * increase the length of this column to VCHAR(64)\r\n  * update all 'timeline_bookmar' to 'timeline_bookmarks'\r\n\r\n2. Increase the size of `addon_version` for both activity_stream tables, since we wanted to add a timestamp or a git commit hash to it. Change to VCHAR(64) from VCHAR(16)"}}