{"action":"created","issue":{"url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/10","labels_url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/10/comments","events_url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/10/events","html_url":"https://github.com/blendersfun/seattle-theatre-site/pull/10","id":55204767,"number":10,"title":"Changed database structure to accommodating the following use-cases:","user":{"login":"blendersfun","id":859223,"avatar_url":"https://avatars.githubusercontent.com/u/859223?v=3","gravatar_id":"","url":"https://api.github.com/users/blendersfun","html_url":"https://github.com/blendersfun","followers_url":"https://api.github.com/users/blendersfun/followers","following_url":"https://api.github.com/users/blendersfun/following{/other_user}","gists_url":"https://api.github.com/users/blendersfun/gists{/gist_id}","starred_url":"https://api.github.com/users/blendersfun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blendersfun/subscriptions","organizations_url":"https://api.github.com/users/blendersfun/orgs","repos_url":"https://api.github.com/users/blendersfun/repos","events_url":"https://api.github.com/users/blendersfun/events{/privacy}","received_events_url":"https://api.github.com/users/blendersfun/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"theazureshadow","id":727514,"avatar_url":"https://avatars.githubusercontent.com/u/727514?v=3","gravatar_id":"","url":"https://api.github.com/users/theazureshadow","html_url":"https://github.com/theazureshadow","followers_url":"https://api.github.com/users/theazureshadow/followers","following_url":"https://api.github.com/users/theazureshadow/following{/other_user}","gists_url":"https://api.github.com/users/theazureshadow/gists{/gist_id}","starred_url":"https://api.github.com/users/theazureshadow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theazureshadow/subscriptions","organizations_url":"https://api.github.com/users/theazureshadow/orgs","repos_url":"https://api.github.com/users/theazureshadow/repos","events_url":"https://api.github.com/users/theazureshadow/events{/privacy}","received_events_url":"https://api.github.com/users/theazureshadow/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-01-22T20:31:25Z","updated_at":"2015-01-24T04:29:39Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/pulls/10","html_url":"https://github.com/blendersfun/seattle-theatre-site/pull/10","diff_url":"https://github.com/blendersfun/seattle-theatre-site/pull/10.diff","patch_url":"https://github.com/blendersfun/seattle-theatre-site/pull/10.patch"},"body":" 1. Defaulting performances spaces to a standard producing_org one, and varying producing spaces across a show's run.\r\n 2. Decoupling \"staging\" and \"show\" -- which together create the concept of a \"production\". This is to accommodate festival formats that have multiple stagings in a single show.\r\n 3. A few little things like formalizing writer's contribution to a script as a collaborator_role.\r\nAlso added auto_increment to primary keys across the board.\r\n\r\nNOTE: no application functionality depends on these changes currently."},"comment":{"url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/comments/71299947","html_url":"https://github.com/blendersfun/seattle-theatre-site/pull/10#issuecomment-71299947","issue_url":"https://api.github.com/repos/blendersfun/seattle-theatre-site/issues/10","id":71299947,"user":{"login":"theazureshadow","id":727514,"avatar_url":"https://avatars.githubusercontent.com/u/727514?v=3","gravatar_id":"","url":"https://api.github.com/users/theazureshadow","html_url":"https://github.com/theazureshadow","followers_url":"https://api.github.com/users/theazureshadow/followers","following_url":"https://api.github.com/users/theazureshadow/following{/other_user}","gists_url":"https://api.github.com/users/theazureshadow/gists{/gist_id}","starred_url":"https://api.github.com/users/theazureshadow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theazureshadow/subscriptions","organizations_url":"https://api.github.com/users/theazureshadow/orgs","repos_url":"https://api.github.com/users/theazureshadow/repos","events_url":"https://api.github.com/users/theazureshadow/events{/privacy}","received_events_url":"https://api.github.com/users/theazureshadow/received_events","type":"User","site_admin":false},"created_at":"2015-01-24T04:29:39Z","updated_at":"2015-01-24T04:29:39Z","body":"LGTM. The changes sound reasonable. I haven't tried to review the sql files themselves."}}