{"action":"created","issue":{"url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/2341","repository_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform","labels_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/2341/labels{/name}","comments_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/2341/comments","events_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/2341/events","html_url":"https://github.com/dnnsoftware/Dnn.Platform/pull/2341","id":363794339,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE4MTQxNjMw","number":2341,"title":"DNN-9651: drop duplicate index and unused column","user":{"login":"sleupold","id":6377509,"node_id":"MDQ6VXNlcjYzNzc1MDk=","avatar_url":"https://avatars1.githubusercontent.com/u/6377509?v=4","gravatar_id":"","url":"https://api.github.com/users/sleupold","html_url":"https://github.com/sleupold","followers_url":"https://api.github.com/users/sleupold/followers","following_url":"https://api.github.com/users/sleupold/following{/other_user}","gists_url":"https://api.github.com/users/sleupold/gists{/gist_id}","starred_url":"https://api.github.com/users/sleupold/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sleupold/subscriptions","organizations_url":"https://api.github.com/users/sleupold/orgs","repos_url":"https://api.github.com/users/sleupold/repos","events_url":"https://api.github.com/users/sleupold/events{/privacy}","received_events_url":"https://api.github.com/users/sleupold/received_events","type":"User","site_admin":false},"labels":[{"id":183716522,"node_id":"MDU6TGFiZWwxODM3MTY1MjI=","url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/labels/Community","name":"Community","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/milestones/22","html_url":"https://github.com/dnnsoftware/Dnn.Platform/milestone/22","labels_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/milestones/22/labels","id":3377991,"node_id":"MDk6TWlsZXN0b25lMzM3Nzk5MQ==","number":22,"title":"9.3.0","description":"","creator":{"login":"ohine","id":1687117,"node_id":"MDQ6VXNlcjE2ODcxMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/1687117?v=4","gravatar_id":"","url":"https://api.github.com/users/ohine","html_url":"https://github.com/ohine","followers_url":"https://api.github.com/users/ohine/followers","following_url":"https://api.github.com/users/ohine/following{/other_user}","gists_url":"https://api.github.com/users/ohine/gists{/gist_id}","starred_url":"https://api.github.com/users/ohine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ohine/subscriptions","organizations_url":"https://api.github.com/users/ohine/orgs","repos_url":"https://api.github.com/users/ohine/repos","events_url":"https://api.github.com/users/ohine/events{/privacy}","received_events_url":"https://api.github.com/users/ohine/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":41,"state":"open","created_at":"2018-05-26T02:53:24Z","updated_at":"2018-10-04T15:53:53Z","due_on":"2018-11-23T08:00:00Z","closed_at":null},"comments":12,"created_at":"2018-09-25T22:46:19Z","updated_at":"2018-10-04T15:56:35Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/pulls/2341","html_url":"https://github.com/dnnsoftware/Dnn.Platform/pull/2341","diff_url":"https://github.com/dnnsoftware/Dnn.Platform/pull/2341.diff","patch_url":"https://github.com/dnnsoftware/Dnn.Platform/pull/2341.patch"},"body":"Removes the duplicate index `IX_Users_LowerEmail` and removes the calculated column `LowerEmail` column because it's not utilized in the platform. "},"comment":{"url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/comments/427072897","html_url":"https://github.com/dnnsoftware/Dnn.Platform/pull/2341#issuecomment-427072897","issue_url":"https://api.github.com/repos/dnnsoftware/Dnn.Platform/issues/2341","id":427072897,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzA3Mjg5Nw==","user":{"login":"ohine","id":1687117,"node_id":"MDQ6VXNlcjE2ODcxMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/1687117?v=4","gravatar_id":"","url":"https://api.github.com/users/ohine","html_url":"https://github.com/ohine","followers_url":"https://api.github.com/users/ohine/followers","following_url":"https://api.github.com/users/ohine/following{/other_user}","gists_url":"https://api.github.com/users/ohine/gists{/gist_id}","starred_url":"https://api.github.com/users/ohine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ohine/subscriptions","organizations_url":"https://api.github.com/users/ohine/orgs","repos_url":"https://api.github.com/users/ohine/repos","events_url":"https://api.github.com/users/ohine/events{/privacy}","received_events_url":"https://api.github.com/users/ohine/received_events","type":"User","site_admin":false},"created_at":"2018-10-04T15:56:35Z","updated_at":"2018-10-04T15:56:35Z","author_association":"CONTRIBUTOR","body":"As for querying the DB directly, while it's not the best practice. It's still done. I know of 100's if not 1000's of sql reporting modules which are going directly to the DB. I think we should just mention that it's removed and could potentially be a breaking change if you are bypassing the api and going directly to the database. I'd much rather warn someone then have them come and complain after upgrading. "}}
{"actor":{"display_login":"ohine"}}