{"action":"created","issue":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/759","repository_url":"https://api.github.com/repos/cubing/worldcubeassociation.org","labels_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/759/labels{/name}","comments_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/759/comments","events_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/759/events","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/759","id":163513220,"number":759,"title":"Clean up eventSpecs and virtual models - Fixes #95 - Fixes #741","user":{"login":"pingskills","id":4403168,"avatar_url":"https://avatars.githubusercontent.com/u/4403168?v=3","gravatar_id":"","url":"https://api.github.com/users/pingskills","html_url":"https://github.com/pingskills","followers_url":"https://api.github.com/users/pingskills/followers","following_url":"https://api.github.com/users/pingskills/following{/other_user}","gists_url":"https://api.github.com/users/pingskills/gists{/gist_id}","starred_url":"https://api.github.com/users/pingskills/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingskills/subscriptions","organizations_url":"https://api.github.com/users/pingskills/orgs","repos_url":"https://api.github.com/users/pingskills/repos","events_url":"https://api.github.com/users/pingskills/events{/privacy}","received_events_url":"https://api.github.com/users/pingskills/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-07-02T10:51:31Z","updated_at":"2016-07-03T13:14:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/pulls/759","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/759","diff_url":"https://github.com/cubing/worldcubeassociation.org/pull/759.diff","patch_url":"https://github.com/cubing/worldcubeassociation.org/pull/759.patch"},"body":"**Not to be merged before PHP code is updated!**\r\n\r\n**Create competition_events table**\r\n    \r\nCreate a many to many table to hold competition events\r\nand migrate the data from the eventSpecs column. I am\r\nnot dropping the eventSpecs column in this migration so\r\nthe changes can easily be rolled back. This can be done\r\nin a later migration.\r\n\r\n**Convert Virtual Models Into Real Tables**\r\n    \r\nCountries, Continents, Events, Rounds, and Format models are\r\ncurrently virtual. This change makes the models reference the\r\ndatabase tables. A new table preferred_formats has been created\r\nto store the relationship between events and preferred formats."},"comment":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/comments/230152902","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/759#issuecomment-230152902","issue_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/759","id":230152902,"user":{"login":"pingskills","id":4403168,"avatar_url":"https://avatars.githubusercontent.com/u/4403168?v=3","gravatar_id":"","url":"https://api.github.com/users/pingskills","html_url":"https://github.com/pingskills","followers_url":"https://api.github.com/users/pingskills/followers","following_url":"https://api.github.com/users/pingskills/following{/other_user}","gists_url":"https://api.github.com/users/pingskills/gists{/gist_id}","starred_url":"https://api.github.com/users/pingskills/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pingskills/subscriptions","organizations_url":"https://api.github.com/users/pingskills/orgs","repos_url":"https://api.github.com/users/pingskills/repos","events_url":"https://api.github.com/users/pingskills/events{/privacy}","received_events_url":"https://api.github.com/users/pingskills/received_events","type":"User","site_admin":false},"created_at":"2016-07-03T13:14:02Z","updated_at":"2016-07-03T13:14:02Z","body":"I've updated the PHP code so this change can go live once people have reviewed the PR and are happy with the changes."}}
{"actor":{"display_login":"pingskills"}}