{"action":"opened","issue":{"url":"https://api.github.com/repos/TheNAF/naflm/issues/139","repository_url":"https://api.github.com/repos/TheNAF/naflm","labels_url":"https://api.github.com/repos/TheNAF/naflm/issues/139/labels{/name}","comments_url":"https://api.github.com/repos/TheNAF/naflm/issues/139/comments","events_url":"https://api.github.com/repos/TheNAF/naflm/issues/139/events","html_url":"https://github.com/TheNAF/naflm/issues/139","id":162899752,"number":139,"title":"Proposal: Add Scheduled Matches to mv_teams","user":{"login":"mfranchetti","id":11505434,"avatar_url":"https://avatars.githubusercontent.com/u/11505434?v=3","gravatar_id":"","url":"https://api.github.com/users/mfranchetti","html_url":"https://github.com/mfranchetti","followers_url":"https://api.github.com/users/mfranchetti/followers","following_url":"https://api.github.com/users/mfranchetti/following{/other_user}","gists_url":"https://api.github.com/users/mfranchetti/gists{/gist_id}","starred_url":"https://api.github.com/users/mfranchetti/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfranchetti/subscriptions","organizations_url":"https://api.github.com/users/mfranchetti/orgs","repos_url":"https://api.github.com/users/mfranchetti/repos","events_url":"https://api.github.com/users/mfranchetti/events{/privacy}","received_events_url":"https://api.github.com/users/mfranchetti/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-06-29T11:12:08Z","updated_at":"2016-06-29T11:12:08Z","closed_at":null,"body":"The `mv_teams` table has a `played` field to record the number of matches played. I am proposing that we add a **scheduled** field to record the number of matches that the team has scheduled but unplayed.\r\nThis will require updating the function `syncMVteam` in order to correctly populate the field.\r\nThe benefit is that we can then include teams who have completed matches _or_ scheduled matches when `syncMVteam` is called. League tables will then show all teams included in a scheduled league from the start rather than only after their first match.\r\n\r\n**Issues**\r\n\r\n- How are table updates being included? Do i just create a new version update or is there one that should be used.\r\n- Are there any other functions that would be affected by the new field? I don't believe so, as I think `syncMVteam` is the only one that updates `mv_teams` and any that read from it should be specifying fields.\r\n- In order for this to update correctly, 'syncMVteam' will need to be called after scheduled matches are added. I doubt that is the case now but have not confirmed. Should be a simple job tho'.\r\n\r\nI'm happy to handle this, but wanted to ensure it was acceptable and not conflicting with any other developments."}}
{"actor":{"display_login":"mfranchetti"}}