{"action":"created","comment":{"url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/comments/181227297","pull_request_review_id":111801391,"id":181227297,"diff_hunk":"@@ -0,0 +1,13 @@\n+-- Flyway script to add exam index for the IAB dashboard query\n+--\n+USE ${schemaName};\n+\n+ALTER TABLE exam\n+  -- new index for the dashboard query\n+  ADD INDEX idx__exam__student_asmt_type_school_year_completed_at (student_id, asmt_id, type_id, school_year, completed_at),\n+\n+  -- replace foreign key index with the new one\n+  DROP FOREIGN KEY fk__exam__student,\n+  DROP INDEX idx__exam__student;\n+\n+ALTER TABLE exam ADD CONSTRAINT fk__exam__student FOREIGN KEY (student_id) REFERENCES student(id);","path":"reporting/sql/V1_2_0_3__iab_dashboard_exam_index.sql","position":13,"original_position":13,"commit_id":"0db4b61c4b12383e1910509ea9c93191c795006c","original_commit_id":"0db4b61c4b12383e1910509ea9c93191c795006c","user":{"login":"malaffoon","id":5097710,"avatar_url":"https://avatars0.githubusercontent.com/u/5097710?v=4","gravatar_id":"","url":"https://api.github.com/users/malaffoon","html_url":"https://github.com/malaffoon","followers_url":"https://api.github.com/users/malaffoon/followers","following_url":"https://api.github.com/users/malaffoon/following{/other_user}","gists_url":"https://api.github.com/users/malaffoon/gists{/gist_id}","starred_url":"https://api.github.com/users/malaffoon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/malaffoon/subscriptions","organizations_url":"https://api.github.com/users/malaffoon/orgs","repos_url":"https://api.github.com/users/malaffoon/repos","events_url":"https://api.github.com/users/malaffoon/events{/privacy}","received_events_url":"https://api.github.com/users/malaffoon/received_events","type":"User","site_admin":false},"body":"i'm confused, what was it before?","created_at":"2018-04-12T21:28:56Z","updated_at":"2018-04-12T21:28:56Z","html_url":"https://github.com/SmarterApp/RDW_Schema/pull/257#discussion_r181227297","pull_request_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/comments/181227297"},"html":{"href":"https://github.com/SmarterApp/RDW_Schema/pull/257#discussion_r181227297"},"pull_request":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257"}}},"pull_request":{"url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257","id":181330187,"html_url":"https://github.com/SmarterApp/RDW_Schema/pull/257","diff_url":"https://github.com/SmarterApp/RDW_Schema/pull/257.diff","patch_url":"https://github.com/SmarterApp/RDW_Schema/pull/257.patch","issue_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/257","number":257,"state":"open","locked":false,"title":"Add exam index to support IAB dashboard query.","user":{"login":"agorina","id":16457484,"avatar_url":"https://avatars2.githubusercontent.com/u/16457484?v=4","gravatar_id":"","url":"https://api.github.com/users/agorina","html_url":"https://github.com/agorina","followers_url":"https://api.github.com/users/agorina/followers","following_url":"https://api.github.com/users/agorina/following{/other_user}","gists_url":"https://api.github.com/users/agorina/gists{/gist_id}","starred_url":"https://api.github.com/users/agorina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agorina/subscriptions","organizations_url":"https://api.github.com/users/agorina/orgs","repos_url":"https://api.github.com/users/agorina/repos","events_url":"https://api.github.com/users/agorina/events{/privacy}","received_events_url":"https://api.github.com/users/agorina/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-04-12T21:26:12Z","updated_at":"2018-04-12T21:28:56Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d7034fe48c826023cdb0149a07d82c083cc5f7a5","assignee":null,"assignees":[],"requested_reviewers":[{"login":"jtreuting","id":341584,"avatar_url":"https://avatars0.githubusercontent.com/u/341584?v=4","gravatar_id":"","url":"https://api.github.com/users/jtreuting","html_url":"https://github.com/jtreuting","followers_url":"https://api.github.com/users/jtreuting/followers","following_url":"https://api.github.com/users/jtreuting/following{/other_user}","gists_url":"https://api.github.com/users/jtreuting/gists{/gist_id}","starred_url":"https://api.github.com/users/jtreuting/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jtreuting/subscriptions","organizations_url":"https://api.github.com/users/jtreuting/orgs","repos_url":"https://api.github.com/users/jtreuting/repos","events_url":"https://api.github.com/users/jtreuting/events{/privacy}","received_events_url":"https://api.github.com/users/jtreuting/received_events","type":"User","site_admin":false},{"login":"dsnyder-fairway","id":33040425,"avatar_url":"https://avatars1.githubusercontent.com/u/33040425?v=4","gravatar_id":"","url":"https://api.github.com/users/dsnyder-fairway","html_url":"https://github.com/dsnyder-fairway","followers_url":"https://api.github.com/users/dsnyder-fairway/followers","following_url":"https://api.github.com/users/dsnyder-fairway/following{/other_user}","gists_url":"https://api.github.com/users/dsnyder-fairway/gists{/gist_id}","starred_url":"https://api.github.com/users/dsnyder-fairway/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsnyder-fairway/subscriptions","organizations_url":"https://api.github.com/users/dsnyder-fairway/orgs","repos_url":"https://api.github.com/users/dsnyder-fairway/repos","events_url":"https://api.github.com/users/dsnyder-fairway/events{/privacy}","received_events_url":"https://api.github.com/users/dsnyder-fairway/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257/commits","review_comments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257/comments","review_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/comments{/number}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/257/comments","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/statuses/0db4b61c4b12383e1910509ea9c93191c795006c","head":{"label":"SmarterApp:feature/iab-dashboard-exam-index","ref":"feature/iab-dashboard-exam-index","sha":"0db4b61c4b12383e1910509ea9c93191c795006c","user":{"login":"SmarterApp","id":7026395,"avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"repo":{"id":81146376,"name":"RDW_Schema","full_name":"SmarterApp/RDW_Schema","owner":{"login":"SmarterApp","id":7026395,"avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SmarterApp/RDW_Schema","description":"RDW schemas and core data","fork":false,"url":"https://api.github.com/repos/SmarterApp/RDW_Schema","forks_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/forks","keys_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/teams","hooks_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/hooks","issue_events_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/events{/number}","events_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/events","assignees_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/assignees{/user}","branches_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/branches{/branch}","tags_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/tags","blobs_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/refs{/sha}","trees_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/statuses/{sha}","languages_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/languages","stargazers_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/stargazers","contributors_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/contributors","subscribers_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/subscribers","subscription_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/subscription","commits_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/commits{/sha}","git_commits_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/commits{/sha}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/comments{/number}","issue_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/comments{/number}","contents_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/contents/{+path}","compare_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/merges","archive_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/downloads","issues_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues{/number}","pulls_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls{/number}","milestones_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/milestones{/number}","notifications_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/labels{/name}","releases_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/releases{/id}","deployments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/deployments","created_at":"2017-02-06T23:59:36Z","updated_at":"2018-04-11T18:16:19Z","pushed_at":"2018-04-12T21:26:13Z","git_url":"git://github.com/SmarterApp/RDW_Schema.git","ssh_url":"git@github.com:SmarterApp/RDW_Schema.git","clone_url":"https://github.com/SmarterApp/RDW_Schema.git","svn_url":"https://github.com/SmarterApp/RDW_Schema","homepage":null,"size":839,"stargazers_count":1,"watchers_count":1,"language":"SQLPL","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":2,"license":{"key":"other","name":"Other","spdx_id":null,"url":null},"forks":0,"open_issues":2,"watchers":1,"default_branch":"develop"}},"base":{"label":"SmarterApp:develop","ref":"develop","sha":"26ab0e0c86d55aa467814ccbf98b6ffe7a67be9d","user":{"login":"SmarterApp","id":7026395,"avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"repo":{"id":81146376,"name":"RDW_Schema","full_name":"SmarterApp/RDW_Schema","owner":{"login":"SmarterApp","id":7026395,"avatar_url":"https://avatars0.githubusercontent.com/u/7026395?v=4","gravatar_id":"","url":"https://api.github.com/users/SmarterApp","html_url":"https://github.com/SmarterApp","followers_url":"https://api.github.com/users/SmarterApp/followers","following_url":"https://api.github.com/users/SmarterApp/following{/other_user}","gists_url":"https://api.github.com/users/SmarterApp/gists{/gist_id}","starred_url":"https://api.github.com/users/SmarterApp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SmarterApp/subscriptions","organizations_url":"https://api.github.com/users/SmarterApp/orgs","repos_url":"https://api.github.com/users/SmarterApp/repos","events_url":"https://api.github.com/users/SmarterApp/events{/privacy}","received_events_url":"https://api.github.com/users/SmarterApp/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/SmarterApp/RDW_Schema","description":"RDW schemas and core data","fork":false,"url":"https://api.github.com/repos/SmarterApp/RDW_Schema","forks_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/forks","keys_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/keys{/key_id}","collaborators_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/teams","hooks_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/hooks","issue_events_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/events{/number}","events_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/events","assignees_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/assignees{/user}","branches_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/branches{/branch}","tags_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/tags","blobs_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/refs{/sha}","trees_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/trees{/sha}","statuses_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/statuses/{sha}","languages_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/languages","stargazers_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/stargazers","contributors_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/contributors","subscribers_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/subscribers","subscription_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/subscription","commits_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/commits{/sha}","git_commits_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/git/commits{/sha}","comments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/comments{/number}","issue_comment_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/comments{/number}","contents_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/contents/{+path}","compare_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/compare/{base}...{head}","merges_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/merges","archive_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/downloads","issues_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues{/number}","pulls_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls{/number}","milestones_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/milestones{/number}","notifications_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/labels{/name}","releases_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/releases{/id}","deployments_url":"https://api.github.com/repos/SmarterApp/RDW_Schema/deployments","created_at":"2017-02-06T23:59:36Z","updated_at":"2018-04-11T18:16:19Z","pushed_at":"2018-04-12T21:26:13Z","git_url":"git://github.com/SmarterApp/RDW_Schema.git","ssh_url":"git@github.com:SmarterApp/RDW_Schema.git","clone_url":"https://github.com/SmarterApp/RDW_Schema.git","svn_url":"https://github.com/SmarterApp/RDW_Schema","homepage":null,"size":839,"stargazers_count":1,"watchers_count":1,"language":"SQLPL","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":2,"license":{"key":"other","name":"Other","spdx_id":null,"url":null},"forks":0,"open_issues":2,"watchers":1,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257"},"html":{"href":"https://github.com/SmarterApp/RDW_Schema/pull/257"},"issue":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/257"},"comments":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/issues/257/comments"},"review_comments":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257/comments"},"review_comment":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/pulls/257/commits"},"statuses":{"href":"https://api.github.com/repos/SmarterApp/RDW_Schema/statuses/0db4b61c4b12383e1910509ea9c93191c795006c"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"malaffoon"}}