{"action":"created","comment":{"url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/comments/90659513","pull_request_review_id":11178531,"id":90659513,"diff_hunk":"@@ -19,7 +20,8 @@\n  *\n  */\n @Entity\n-@Table(name=\"addresses\")\n+@Table(name=\"addresses\", indexes={@Index(columnList=\"longitude\"), \n+        @Index(columnList=\"latitude\")})","path":"hni-user/src/main/java/org/hni/user/om/Address.java","position":14,"original_position":14,"commit_id":"66a2de62457feac32362240ad4bd5ffed66075ae","original_commit_id":"5d0732356a866be28d0e6a505d46dcca9dacfec5","user":{"login":"waynemz","id":8452292,"avatar_url":"https://avatars.githubusercontent.com/u/8452292?v=3","gravatar_id":"","url":"https://api.github.com/users/waynemz","html_url":"https://github.com/waynemz","followers_url":"https://api.github.com/users/waynemz/followers","following_url":"https://api.github.com/users/waynemz/following{/other_user}","gists_url":"https://api.github.com/users/waynemz/gists{/gist_id}","starred_url":"https://api.github.com/users/waynemz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/waynemz/subscriptions","organizations_url":"https://api.github.com/users/waynemz/orgs","repos_url":"https://api.github.com/users/waynemz/repos","events_url":"https://api.github.com/users/waynemz/events{/privacy}","received_events_url":"https://api.github.com/users/waynemz/received_events","type":"User","site_admin":false},"body":"I know there is a manual process to load the schema into the database. I just assumed that schema.sql was being used for that purpose. But I see an entirely different schema.sql in the #data channel in slack. It would be nice if we checked in all our artifacts needed for managing the project into our known github repositories.","created_at":"2016-12-02T15:19:31Z","updated_at":"2016-12-02T15:19:31Z","html_url":"https://github.com/hungernotimpossible/hni/pull/116#discussion_r90659513","pull_request_url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116","_links":{"self":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/comments/90659513"},"html":{"href":"https://github.com/hungernotimpossible/hni/pull/116#discussion_r90659513"},"pull_request":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116"}}},"pull_request":{"url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116","id":96115286,"html_url":"https://github.com/hungernotimpossible/hni/pull/116","diff_url":"https://github.com/hungernotimpossible/hni/pull/116.diff","patch_url":"https://github.com/hungernotimpossible/hni/pull/116.patch","issue_url":"https://api.github.com/repos/hungernotimpossible/hni/issues/116","number":116,"state":"open","locked":false,"title":"GeoCoding service update #54","user":{"login":"bhatms","id":11080117,"avatar_url":"https://avatars.githubusercontent.com/u/11080117?v=3","gravatar_id":"","url":"https://api.github.com/users/bhatms","html_url":"https://github.com/bhatms","followers_url":"https://api.github.com/users/bhatms/followers","following_url":"https://api.github.com/users/bhatms/following{/other_user}","gists_url":"https://api.github.com/users/bhatms/gists{/gist_id}","starred_url":"https://api.github.com/users/bhatms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhatms/subscriptions","organizations_url":"https://api.github.com/users/bhatms/orgs","repos_url":"https://api.github.com/users/bhatms/repos","events_url":"https://api.github.com/users/bhatms/events{/privacy}","received_events_url":"https://api.github.com/users/bhatms/received_events","type":"User","site_admin":false},"body":"added indexes to addres.latitude and longitude\r\nchanged column data type to Double of latitude and longitude\r\nmodified search query\r\n#54 ","created_at":"2016-12-01T15:54:44Z","updated_at":"2016-12-02T15:19:31Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6cad180d4458f3794f6531d85ffdb75d962393fe","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116/commits","review_comments_url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116/comments","review_comment_url":"https://api.github.com/repos/hungernotimpossible/hni/pulls/comments{/number}","comments_url":"https://api.github.com/repos/hungernotimpossible/hni/issues/116/comments","statuses_url":"https://api.github.com/repos/hungernotimpossible/hni/statuses/66a2de62457feac32362240ad4bd5ffed66075ae","head":{"label":"bhatms:master","ref":"master","sha":"66a2de62457feac32362240ad4bd5ffed66075ae","user":{"login":"bhatms","id":11080117,"avatar_url":"https://avatars.githubusercontent.com/u/11080117?v=3","gravatar_id":"","url":"https://api.github.com/users/bhatms","html_url":"https://github.com/bhatms","followers_url":"https://api.github.com/users/bhatms/followers","following_url":"https://api.github.com/users/bhatms/following{/other_user}","gists_url":"https://api.github.com/users/bhatms/gists{/gist_id}","starred_url":"https://api.github.com/users/bhatms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhatms/subscriptions","organizations_url":"https://api.github.com/users/bhatms/orgs","repos_url":"https://api.github.com/users/bhatms/repos","events_url":"https://api.github.com/users/bhatms/events{/privacy}","received_events_url":"https://api.github.com/users/bhatms/received_events","type":"User","site_admin":false},"repo":{"id":73197271,"name":"hni","full_name":"bhatms/hni","owner":{"login":"bhatms","id":11080117,"avatar_url":"https://avatars.githubusercontent.com/u/11080117?v=3","gravatar_id":"","url":"https://api.github.com/users/bhatms","html_url":"https://github.com/bhatms","followers_url":"https://api.github.com/users/bhatms/followers","following_url":"https://api.github.com/users/bhatms/following{/other_user}","gists_url":"https://api.github.com/users/bhatms/gists{/gist_id}","starred_url":"https://api.github.com/users/bhatms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhatms/subscriptions","organizations_url":"https://api.github.com/users/bhatms/orgs","repos_url":"https://api.github.com/users/bhatms/repos","events_url":"https://api.github.com/users/bhatms/events{/privacy}","received_events_url":"https://api.github.com/users/bhatms/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/bhatms/hni","description":null,"fork":true,"url":"https://api.github.com/repos/bhatms/hni","forks_url":"https://api.github.com/repos/bhatms/hni/forks","keys_url":"https://api.github.com/repos/bhatms/hni/keys{/key_id}","collaborators_url":"https://api.github.com/repos/bhatms/hni/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/bhatms/hni/teams","hooks_url":"https://api.github.com/repos/bhatms/hni/hooks","issue_events_url":"https://api.github.com/repos/bhatms/hni/issues/events{/number}","events_url":"https://api.github.com/repos/bhatms/hni/events","assignees_url":"https://api.github.com/repos/bhatms/hni/assignees{/user}","branches_url":"https://api.github.com/repos/bhatms/hni/branches{/branch}","tags_url":"https://api.github.com/repos/bhatms/hni/tags","blobs_url":"https://api.github.com/repos/bhatms/hni/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/bhatms/hni/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/bhatms/hni/git/refs{/sha}","trees_url":"https://api.github.com/repos/bhatms/hni/git/trees{/sha}","statuses_url":"https://api.github.com/repos/bhatms/hni/statuses/{sha}","languages_url":"https://api.github.com/repos/bhatms/hni/languages","stargazers_url":"https://api.github.com/repos/bhatms/hni/stargazers","contributors_url":"https://api.github.com/repos/bhatms/hni/contributors","subscribers_url":"https://api.github.com/repos/bhatms/hni/subscribers","subscription_url":"https://api.github.com/repos/bhatms/hni/subscription","commits_url":"https://api.github.com/repos/bhatms/hni/commits{/sha}","git_commits_url":"https://api.github.com/repos/bhatms/hni/git/commits{/sha}","comments_url":"https://api.github.com/repos/bhatms/hni/comments{/number}","issue_comment_url":"https://api.github.com/repos/bhatms/hni/issues/comments{/number}","contents_url":"https://api.github.com/repos/bhatms/hni/contents/{+path}","compare_url":"https://api.github.com/repos/bhatms/hni/compare/{base}...{head}","merges_url":"https://api.github.com/repos/bhatms/hni/merges","archive_url":"https://api.github.com/repos/bhatms/hni/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/bhatms/hni/downloads","issues_url":"https://api.github.com/repos/bhatms/hni/issues{/number}","pulls_url":"https://api.github.com/repos/bhatms/hni/pulls{/number}","milestones_url":"https://api.github.com/repos/bhatms/hni/milestones{/number}","notifications_url":"https://api.github.com/repos/bhatms/hni/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/bhatms/hni/labels{/name}","releases_url":"https://api.github.com/repos/bhatms/hni/releases{/id}","deployments_url":"https://api.github.com/repos/bhatms/hni/deployments","created_at":"2016-11-08T15:05:28Z","updated_at":"2016-11-08T15:05:30Z","pushed_at":"2016-12-02T04:44:55Z","git_url":"git://github.com/bhatms/hni.git","ssh_url":"git@github.com:bhatms/hni.git","clone_url":"https://github.com/bhatms/hni.git","svn_url":"https://github.com/bhatms/hni","homepage":null,"size":8790,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"hungernotimpossible:master","ref":"master","sha":"e262577d6026b343ff7c1592957383628259b271","user":{"login":"hungernotimpossible","id":22616557,"avatar_url":"https://avatars.githubusercontent.com/u/22616557?v=3","gravatar_id":"","url":"https://api.github.com/users/hungernotimpossible","html_url":"https://github.com/hungernotimpossible","followers_url":"https://api.github.com/users/hungernotimpossible/followers","following_url":"https://api.github.com/users/hungernotimpossible/following{/other_user}","gists_url":"https://api.github.com/users/hungernotimpossible/gists{/gist_id}","starred_url":"https://api.github.com/users/hungernotimpossible/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hungernotimpossible/subscriptions","organizations_url":"https://api.github.com/users/hungernotimpossible/orgs","repos_url":"https://api.github.com/users/hungernotimpossible/repos","events_url":"https://api.github.com/users/hungernotimpossible/events{/privacy}","received_events_url":"https://api.github.com/users/hungernotimpossible/received_events","type":"Organization","site_admin":false},"repo":{"id":69965078,"name":"hni","full_name":"hungernotimpossible/hni","owner":{"login":"hungernotimpossible","id":22616557,"avatar_url":"https://avatars.githubusercontent.com/u/22616557?v=3","gravatar_id":"","url":"https://api.github.com/users/hungernotimpossible","html_url":"https://github.com/hungernotimpossible","followers_url":"https://api.github.com/users/hungernotimpossible/followers","following_url":"https://api.github.com/users/hungernotimpossible/following{/other_user}","gists_url":"https://api.github.com/users/hungernotimpossible/gists{/gist_id}","starred_url":"https://api.github.com/users/hungernotimpossible/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hungernotimpossible/subscriptions","organizations_url":"https://api.github.com/users/hungernotimpossible/orgs","repos_url":"https://api.github.com/users/hungernotimpossible/repos","events_url":"https://api.github.com/users/hungernotimpossible/events{/privacy}","received_events_url":"https://api.github.com/users/hungernotimpossible/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/hungernotimpossible/hni","description":null,"fork":false,"url":"https://api.github.com/repos/hungernotimpossible/hni","forks_url":"https://api.github.com/repos/hungernotimpossible/hni/forks","keys_url":"https://api.github.com/repos/hungernotimpossible/hni/keys{/key_id}","collaborators_url":"https://api.github.com/repos/hungernotimpossible/hni/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/hungernotimpossible/hni/teams","hooks_url":"https://api.github.com/repos/hungernotimpossible/hni/hooks","issue_events_url":"https://api.github.com/repos/hungernotimpossible/hni/issues/events{/number}","events_url":"https://api.github.com/repos/hungernotimpossible/hni/events","assignees_url":"https://api.github.com/repos/hungernotimpossible/hni/assignees{/user}","branches_url":"https://api.github.com/repos/hungernotimpossible/hni/branches{/branch}","tags_url":"https://api.github.com/repos/hungernotimpossible/hni/tags","blobs_url":"https://api.github.com/repos/hungernotimpossible/hni/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/hungernotimpossible/hni/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/hungernotimpossible/hni/git/refs{/sha}","trees_url":"https://api.github.com/repos/hungernotimpossible/hni/git/trees{/sha}","statuses_url":"https://api.github.com/repos/hungernotimpossible/hni/statuses/{sha}","languages_url":"https://api.github.com/repos/hungernotimpossible/hni/languages","stargazers_url":"https://api.github.com/repos/hungernotimpossible/hni/stargazers","contributors_url":"https://api.github.com/repos/hungernotimpossible/hni/contributors","subscribers_url":"https://api.github.com/repos/hungernotimpossible/hni/subscribers","subscription_url":"https://api.github.com/repos/hungernotimpossible/hni/subscription","commits_url":"https://api.github.com/repos/hungernotimpossible/hni/commits{/sha}","git_commits_url":"https://api.github.com/repos/hungernotimpossible/hni/git/commits{/sha}","comments_url":"https://api.github.com/repos/hungernotimpossible/hni/comments{/number}","issue_comment_url":"https://api.github.com/repos/hungernotimpossible/hni/issues/comments{/number}","contents_url":"https://api.github.com/repos/hungernotimpossible/hni/contents/{+path}","compare_url":"https://api.github.com/repos/hungernotimpossible/hni/compare/{base}...{head}","merges_url":"https://api.github.com/repos/hungernotimpossible/hni/merges","archive_url":"https://api.github.com/repos/hungernotimpossible/hni/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/hungernotimpossible/hni/downloads","issues_url":"https://api.github.com/repos/hungernotimpossible/hni/issues{/number}","pulls_url":"https://api.github.com/repos/hungernotimpossible/hni/pulls{/number}","milestones_url":"https://api.github.com/repos/hungernotimpossible/hni/milestones{/number}","notifications_url":"https://api.github.com/repos/hungernotimpossible/hni/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/hungernotimpossible/hni/labels{/name}","releases_url":"https://api.github.com/repos/hungernotimpossible/hni/releases{/id}","deployments_url":"https://api.github.com/repos/hungernotimpossible/hni/deployments","created_at":"2016-10-04T12:58:05Z","updated_at":"2016-11-29T16:30:17Z","pushed_at":"2016-12-02T14:56:09Z","git_url":"git://github.com/hungernotimpossible/hni.git","ssh_url":"git@github.com:hungernotimpossible/hni.git","clone_url":"https://github.com/hungernotimpossible/hni.git","svn_url":"https://github.com/hungernotimpossible/hni","homepage":null,"size":8883,"stargazers_count":3,"watchers_count":3,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":19,"mirror_url":null,"open_issues_count":15,"forks":19,"open_issues":15,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116"},"html":{"href":"https://github.com/hungernotimpossible/hni/pull/116"},"issue":{"href":"https://api.github.com/repos/hungernotimpossible/hni/issues/116"},"comments":{"href":"https://api.github.com/repos/hungernotimpossible/hni/issues/116/comments"},"review_comments":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116/comments"},"review_comment":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/hungernotimpossible/hni/pulls/116/commits"},"statuses":{"href":"https://api.github.com/repos/hungernotimpossible/hni/statuses/66a2de62457feac32362240ad4bd5ffed66075ae"}}}}
{"actor":{"display_login":"waynemz"}}