{"action":"created","comment":{"url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/comments/169880420","pull_request_review_id":98476106,"id":169880420,"diff_hunk":"@@ -3,7 +3,7 @@ JOIN sys.objects t ON i.object_id = t.object_id\n WHERE t.name = 'Collection_Period_Mapping'\n AND i.name = 'IX_PeriodMapping_YearOfCollection')\n BEGIN\n-\tCREATE INDEX IX_PeriodMapping_YearOfCollection ON [dbo].[Collection_Period_Mapping] (YearOfCollection);\n+\tCREATE INDEX IX_PeriodMapping_YearOfCollection ON [dbo].[Collection_Period_Mapping] (Collection_Year);","path":"src/PeriodEnd/CoInvestedPayments/DeployCoInvestedPayments/sql/Migration Scripts/1_CoInvestedPayments.deds.Add_Indexes.sql","position":5,"original_position":5,"commit_id":"f939c01e091cd9c6abb22038396c69d660530180","original_commit_id":"f939c01e091cd9c6abb22038396c69d660530180","user":{"login":"MichaelYoung1981","id":7404131,"avatar_url":"https://avatars2.githubusercontent.com/u/7404131?v=4","gravatar_id":"","url":"https://api.github.com/users/MichaelYoung1981","html_url":"https://github.com/MichaelYoung1981","followers_url":"https://api.github.com/users/MichaelYoung1981/followers","following_url":"https://api.github.com/users/MichaelYoung1981/following{/other_user}","gists_url":"https://api.github.com/users/MichaelYoung1981/gists{/gist_id}","starred_url":"https://api.github.com/users/MichaelYoung1981/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MichaelYoung1981/subscriptions","organizations_url":"https://api.github.com/users/MichaelYoung1981/orgs","repos_url":"https://api.github.com/users/MichaelYoung1981/repos","events_url":"https://api.github.com/users/MichaelYoung1981/events{/privacy}","received_events_url":"https://api.github.com/users/MichaelYoung1981/received_events","type":"User","site_admin":false},"body":"Given the reason these changes didn't cause problems in our environments, can we change this to a drop and create?","created_at":"2018-02-22T08:14:10Z","updated_at":"2018-02-22T08:14:11Z","html_url":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169#discussion_r169880420","pull_request_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/comments/169880420"},"html":{"href":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169#discussion_r169880420"},"pull_request":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169"}}},"pull_request":{"url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169","id":170510211,"html_url":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169","diff_url":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169.diff","patch_url":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169.patch","issue_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/169","number":169,"state":"open","locked":false,"title":"Update to deds sql scripts for DC","user":{"login":"carlbm","id":2923969,"avatar_url":"https://avatars2.githubusercontent.com/u/2923969?v=4","gravatar_id":"","url":"https://api.github.com/users/carlbm","html_url":"https://github.com/carlbm","followers_url":"https://api.github.com/users/carlbm/followers","following_url":"https://api.github.com/users/carlbm/following{/other_user}","gists_url":"https://api.github.com/users/carlbm/gists{/gist_id}","starred_url":"https://api.github.com/users/carlbm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/carlbm/subscriptions","organizations_url":"https://api.github.com/users/carlbm/orgs","repos_url":"https://api.github.com/users/carlbm/repos","events_url":"https://api.github.com/users/carlbm/events{/privacy}","received_events_url":"https://api.github.com/users/carlbm/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-02-21T15:53:30Z","updated_at":"2018-02-22T08:14:11Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8788b796d6205b715c7afa4a48e5fa0e820d2ef0","assignee":null,"assignees":[],"requested_reviewers":[{"login":"chrisfoster76","id":13414996,"avatar_url":"https://avatars2.githubusercontent.com/u/13414996?v=4","gravatar_id":"","url":"https://api.github.com/users/chrisfoster76","html_url":"https://github.com/chrisfoster76","followers_url":"https://api.github.com/users/chrisfoster76/followers","following_url":"https://api.github.com/users/chrisfoster76/following{/other_user}","gists_url":"https://api.github.com/users/chrisfoster76/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisfoster76/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisfoster76/subscriptions","organizations_url":"https://api.github.com/users/chrisfoster76/orgs","repos_url":"https://api.github.com/users/chrisfoster76/repos","events_url":"https://api.github.com/users/chrisfoster76/events{/privacy}","received_events_url":"https://api.github.com/users/chrisfoster76/received_events","type":"User","site_admin":false},{"login":"satya-sanikommu","id":25982336,"avatar_url":"https://avatars1.githubusercontent.com/u/25982336?v=4","gravatar_id":"","url":"https://api.github.com/users/satya-sanikommu","html_url":"https://github.com/satya-sanikommu","followers_url":"https://api.github.com/users/satya-sanikommu/followers","following_url":"https://api.github.com/users/satya-sanikommu/following{/other_user}","gists_url":"https://api.github.com/users/satya-sanikommu/gists{/gist_id}","starred_url":"https://api.github.com/users/satya-sanikommu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/satya-sanikommu/subscriptions","organizations_url":"https://api.github.com/users/satya-sanikommu/orgs","repos_url":"https://api.github.com/users/satya-sanikommu/repos","events_url":"https://api.github.com/users/satya-sanikommu/events{/privacy}","received_events_url":"https://api.github.com/users/satya-sanikommu/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169/commits","review_comments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169/comments","review_comment_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/comments{/number}","comments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/169/comments","statuses_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/statuses/f939c01e091cd9c6abb22038396c69d660530180","head":{"label":"SkillsFundingAgency:DPP-1189-fix-dc-integration-issues","ref":"DPP-1189-fix-dc-integration-issues","sha":"f939c01e091cd9c6abb22038396c69d660530180","user":{"login":"SkillsFundingAgency","id":9841374,"avatar_url":"https://avatars1.githubusercontent.com/u/9841374?v=4","gravatar_id":"","url":"https://api.github.com/users/SkillsFundingAgency","html_url":"https://github.com/SkillsFundingAgency","followers_url":"https://api.github.com/users/SkillsFundingAgency/followers","following_url":"https://api.github.com/users/SkillsFundingAgency/following{/other_user}","gists_url":"https://api.github.com/users/SkillsFundingAgency/gists{/gist_id}","starred_url":"https://api.github.com/users/SkillsFundingAgency/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SkillsFundingAgency/subscriptions","organizations_url":"https://api.github.com/users/SkillsFundingAgency/orgs","repos_url":"https://api.github.com/users/SkillsFundingAgency/repos","events_url":"https://api.github.com/users/SkillsFundingAgency/events{/privacy}","received_events_url":"https://api.github.com/users/SkillsFundingAgency/received_events","type":"Organization","site_admin":false},"repo":{"id":65216151,"name":"das-providerpayments","full_name":"SkillsFundingAgency/das-providerpayments","owner":{"login":"SkillsFundingAgency","id":9841374,"avatar_url":"https://avatars1.githubusercontent.com/u/9841374?v=4","gravatar_id":"","url":"https://api.github.com/users/SkillsFundingAgency","html_url":"https://github.com/SkillsFundingAgency","followers_url":"https://api.github.com/users/SkillsFundingAgency/followers","following_url":"https://api.github.com/users/SkillsFundingAgency/following{/other_user}","gists_url":"https://api.github.com/users/SkillsFundingAgency/gists{/gist_id}","starred_url":"https://api.github.com/users/SkillsFundingAgency/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SkillsFundingAgency/subscriptions","organizations_url":"https://api.github.com/users/SkillsFundingAgency/orgs","repos_url":"https://api.github.com/users/SkillsFundingAgency/repos","events_url":"https://api.github.com/users/SkillsFundingAgency/events{/privacy}","received_events_url":"https://api.github.com/users/SkillsFundingAgency/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SkillsFundingAgency/das-providerpayments","description":null,"fork":false,"url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments","forks_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/forks","keys_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/teams","hooks_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/hooks","issue_events_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/events{/number}","events_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/events","assignees_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/assignees{/user}","branches_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/branches{/branch}","tags_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/tags","blobs_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/refs{/sha}","trees_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/statuses/{sha}","languages_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/languages","stargazers_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/stargazers","contributors_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/contributors","subscribers_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/subscribers","subscription_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/subscription","commits_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/commits{/sha}","git_commits_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/commits{/sha}","comments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/comments{/number}","issue_comment_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/comments{/number}","contents_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/contents/{+path}","compare_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/merges","archive_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/downloads","issues_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues{/number}","pulls_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls{/number}","milestones_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/milestones{/number}","notifications_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/labels{/name}","releases_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/releases{/id}","deployments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/deployments","created_at":"2016-08-08T15:31:45Z","updated_at":"2017-09-12T13:54:31Z","pushed_at":"2018-02-21T15:53:30Z","git_url":"git://github.com/SkillsFundingAgency/das-providerpayments.git","ssh_url":"git@github.com:SkillsFundingAgency/das-providerpayments.git","clone_url":"https://github.com/SkillsFundingAgency/das-providerpayments.git","svn_url":"https://github.com/SkillsFundingAgency/das-providerpayments","homepage":null,"size":12828,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":7,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit"},"forks":0,"open_issues":7,"watchers":0,"default_branch":"develop"}},"base":{"label":"SkillsFundingAgency:R07-MonthEnd-ReleaseBranch","ref":"R07-MonthEnd-ReleaseBranch","sha":"ed547a4738a4d13a1c9b3c49d13e2bf5767d9fe3","user":{"login":"SkillsFundingAgency","id":9841374,"avatar_url":"https://avatars1.githubusercontent.com/u/9841374?v=4","gravatar_id":"","url":"https://api.github.com/users/SkillsFundingAgency","html_url":"https://github.com/SkillsFundingAgency","followers_url":"https://api.github.com/users/SkillsFundingAgency/followers","following_url":"https://api.github.com/users/SkillsFundingAgency/following{/other_user}","gists_url":"https://api.github.com/users/SkillsFundingAgency/gists{/gist_id}","starred_url":"https://api.github.com/users/SkillsFundingAgency/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SkillsFundingAgency/subscriptions","organizations_url":"https://api.github.com/users/SkillsFundingAgency/orgs","repos_url":"https://api.github.com/users/SkillsFundingAgency/repos","events_url":"https://api.github.com/users/SkillsFundingAgency/events{/privacy}","received_events_url":"https://api.github.com/users/SkillsFundingAgency/received_events","type":"Organization","site_admin":false},"repo":{"id":65216151,"name":"das-providerpayments","full_name":"SkillsFundingAgency/das-providerpayments","owner":{"login":"SkillsFundingAgency","id":9841374,"avatar_url":"https://avatars1.githubusercontent.com/u/9841374?v=4","gravatar_id":"","url":"https://api.github.com/users/SkillsFundingAgency","html_url":"https://github.com/SkillsFundingAgency","followers_url":"https://api.github.com/users/SkillsFundingAgency/followers","following_url":"https://api.github.com/users/SkillsFundingAgency/following{/other_user}","gists_url":"https://api.github.com/users/SkillsFundingAgency/gists{/gist_id}","starred_url":"https://api.github.com/users/SkillsFundingAgency/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SkillsFundingAgency/subscriptions","organizations_url":"https://api.github.com/users/SkillsFundingAgency/orgs","repos_url":"https://api.github.com/users/SkillsFundingAgency/repos","events_url":"https://api.github.com/users/SkillsFundingAgency/events{/privacy}","received_events_url":"https://api.github.com/users/SkillsFundingAgency/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SkillsFundingAgency/das-providerpayments","description":null,"fork":false,"url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments","forks_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/forks","keys_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/teams","hooks_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/hooks","issue_events_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/events{/number}","events_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/events","assignees_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/assignees{/user}","branches_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/branches{/branch}","tags_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/tags","blobs_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/refs{/sha}","trees_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/statuses/{sha}","languages_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/languages","stargazers_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/stargazers","contributors_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/contributors","subscribers_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/subscribers","subscription_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/subscription","commits_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/commits{/sha}","git_commits_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/git/commits{/sha}","comments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/comments{/number}","issue_comment_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/comments{/number}","contents_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/contents/{+path}","compare_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/merges","archive_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/downloads","issues_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues{/number}","pulls_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls{/number}","milestones_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/milestones{/number}","notifications_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/labels{/name}","releases_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/releases{/id}","deployments_url":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/deployments","created_at":"2016-08-08T15:31:45Z","updated_at":"2017-09-12T13:54:31Z","pushed_at":"2018-02-21T15:53:30Z","git_url":"git://github.com/SkillsFundingAgency/das-providerpayments.git","ssh_url":"git@github.com:SkillsFundingAgency/das-providerpayments.git","clone_url":"https://github.com/SkillsFundingAgency/das-providerpayments.git","svn_url":"https://github.com/SkillsFundingAgency/das-providerpayments","homepage":null,"size":12828,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":7,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit"},"forks":0,"open_issues":7,"watchers":0,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169"},"html":{"href":"https://github.com/SkillsFundingAgency/das-providerpayments/pull/169"},"issue":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/169"},"comments":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/issues/169/comments"},"review_comments":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169/comments"},"review_comment":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/pulls/169/commits"},"statuses":{"href":"https://api.github.com/repos/SkillsFundingAgency/das-providerpayments/statuses/f939c01e091cd9c6abb22038396c69d660530180"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"MichaelYoung1981"}}