{"action":"created","comment":{"url":"https://api.github.com/repos/hmcts/snl-events/pulls/comments/214336593","pull_request_review_id":151372984,"id":214336593,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxNDMzNjU5Mw==","diff_hunk":"@@ -0,0 +1,121 @@\n+databaseChangeLog:\n+  - changeSet:\n+      id: add-hibernate-sequence\n+      author: kpakur\n+      comment: Without this sequence hibernate complains and application would not start.\n+      failOnError: false\n+      changes:\n+        - createSequence:\n+            schemaName: public\n+            sequenceName: hibernate_sequence\n+  - changeSet:\n+      id: add-revinfo-table\n+      author: kpakur\n+      changes:\n+        - createTable:\n+            tableName: revinfo\n+            columns:\n+                - column:\n+                    constraints:\n+                      primaryKey: true\n+                    name: rev\n+                    type: int\n+                - column:\n+                    name: revtstmp\n+                    type: bigint\n+  - changeSet:\n+      id: create-hearingpart-history-table\n+      author: kpakur\n+      changes:\n+        - createTable:\n+            tableName: hearing_part_aud\n+            columns:\n+            #audit columns\n+            - column:\n+                name: rev\n+                type: int\n+                constraints:\n+                  nullable: false\n+                  foreignKeyName: fk_hearing_part_aud_revinfo\n+                  references: revinfo(rev)\n+            - column:\n+                name: revtype\n+                type: smallint\n+            #hearingpart columns\n+            - column:\n+                name: id\n+                type: UUID\n+                constraints:\n+                  nullable: false\n+            - column:\n+                name: case_number\n+                type: VARCHAR(200)\n+            - column:\n+                name: case_title\n+                type: VARCHAR(200)\n+            - column:\n+                name: case_type\n+                type: VARCHAR(100)\n+            - column:\n+                name: hearing_type","path":"src/main/resources/db/schema/SL-1471-history-of-changes-listing.yaml","position":60,"original_position":60,"commit_id":"e58affb177c1710afccdbb2e05c5f11c97b0b70c","original_commit_id":"e58affb177c1710afccdbb2e05c5f11c97b0b70c","user":{"login":"kpakur","id":4456120,"node_id":"MDQ6VXNlcjQ0NTYxMjA=","avatar_url":"https://avatars0.githubusercontent.com/u/4456120?v=4","gravatar_id":"","url":"https://api.github.com/users/kpakur","html_url":"https://github.com/kpakur","followers_url":"https://api.github.com/users/kpakur/followers","following_url":"https://api.github.com/users/kpakur/following{/other_user}","gists_url":"https://api.github.com/users/kpakur/gists{/gist_id}","starred_url":"https://api.github.com/users/kpakur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kpakur/subscriptions","organizations_url":"https://api.github.com/users/kpakur/orgs","repos_url":"https://api.github.com/users/kpakur/repos","events_url":"https://api.github.com/users/kpakur/events{/privacy}","received_events_url":"https://api.github.com/users/kpakur/received_events","type":"User","site_admin":false},"body":"discussed","created_at":"2018-08-31T12:26:57Z","updated_at":"2018-08-31T12:26:57Z","html_url":"https://github.com/hmcts/snl-events/pull/108#discussion_r214336593","pull_request_url":"https://api.github.com/repos/hmcts/snl-events/pulls/108","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/comments/214336593"},"html":{"href":"https://github.com/hmcts/snl-events/pull/108#discussion_r214336593"},"pull_request":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/108"}},"in_reply_to_id":214252599},"pull_request":{"url":"https://api.github.com/repos/hmcts/snl-events/pulls/108","id":211706196,"node_id":"MDExOlB1bGxSZXF1ZXN0MjExNzA2MTk2","html_url":"https://github.com/hmcts/snl-events/pull/108","diff_url":"https://github.com/hmcts/snl-events/pull/108.diff","patch_url":"https://github.com/hmcts/snl-events/pull/108.patch","issue_url":"https://api.github.com/repos/hmcts/snl-events/issues/108","number":108,"state":"open","locked":false,"title":"[PREVIEW] Feature/sl 1471 history of changes listing","user":{"login":"kpakur","id":4456120,"node_id":"MDQ6VXNlcjQ0NTYxMjA=","avatar_url":"https://avatars0.githubusercontent.com/u/4456120?v=4","gravatar_id":"","url":"https://api.github.com/users/kpakur","html_url":"https://github.com/kpakur","followers_url":"https://api.github.com/users/kpakur/followers","following_url":"https://api.github.com/users/kpakur/following{/other_user}","gists_url":"https://api.github.com/users/kpakur/gists{/gist_id}","starred_url":"https://api.github.com/users/kpakur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kpakur/subscriptions","organizations_url":"https://api.github.com/users/kpakur/orgs","repos_url":"https://api.github.com/users/kpakur/repos","events_url":"https://api.github.com/users/kpakur/events{/privacy}","received_events_url":"https://api.github.com/users/kpakur/received_events","type":"User","site_admin":false},"body":"SL-1471","created_at":"2018-08-29T10:36:29Z","updated_at":"2018-08-31T12:26:57Z","closed_at":null,"merged_at":null,"merge_commit_sha":"0896a197cf31583d99ec34967a5f762030e1cd9d","assignee":null,"assignees":[],"requested_reviewers":[{"login":"satyachundur","id":1426759,"node_id":"MDQ6VXNlcjE0MjY3NTk=","avatar_url":"https://avatars0.githubusercontent.com/u/1426759?v=4","gravatar_id":"","url":"https://api.github.com/users/satyachundur","html_url":"https://github.com/satyachundur","followers_url":"https://api.github.com/users/satyachundur/followers","following_url":"https://api.github.com/users/satyachundur/following{/other_user}","gists_url":"https://api.github.com/users/satyachundur/gists{/gist_id}","starred_url":"https://api.github.com/users/satyachundur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/satyachundur/subscriptions","organizations_url":"https://api.github.com/users/satyachundur/orgs","repos_url":"https://api.github.com/users/satyachundur/repos","events_url":"https://api.github.com/users/satyachundur/events{/privacy}","received_events_url":"https://api.github.com/users/satyachundur/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/hmcts/snl-events/pulls/108/commits","review_comments_url":"https://api.github.com/repos/hmcts/snl-events/pulls/108/comments","review_comment_url":"https://api.github.com/repos/hmcts/snl-events/pulls/comments{/number}","comments_url":"https://api.github.com/repos/hmcts/snl-events/issues/108/comments","statuses_url":"https://api.github.com/repos/hmcts/snl-events/statuses/e58affb177c1710afccdbb2e05c5f11c97b0b70c","head":{"label":"hmcts:feature/SL-1471-HistoryOfChangesListing","ref":"feature/SL-1471-HistoryOfChangesListing","sha":"e58affb177c1710afccdbb2e05c5f11c97b0b70c","user":{"login":"hmcts","id":22817111,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyODE3MTEx","avatar_url":"https://avatars1.githubusercontent.com/u/22817111?v=4","gravatar_id":"","url":"https://api.github.com/users/hmcts","html_url":"https://github.com/hmcts","followers_url":"https://api.github.com/users/hmcts/followers","following_url":"https://api.github.com/users/hmcts/following{/other_user}","gists_url":"https://api.github.com/users/hmcts/gists{/gist_id}","starred_url":"https://api.github.com/users/hmcts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hmcts/subscriptions","organizations_url":"https://api.github.com/users/hmcts/orgs","repos_url":"https://api.github.com/users/hmcts/repos","events_url":"https://api.github.com/users/hmcts/events{/privacy}","received_events_url":"https://api.github.com/users/hmcts/received_events","type":"Organization","site_admin":false},"repo":{"id":129116735,"node_id":"MDEwOlJlcG9zaXRvcnkxMjkxMTY3MzU=","name":"snl-events","full_name":"hmcts/snl-events","owner":{"login":"hmcts","id":22817111,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyODE3MTEx","avatar_url":"https://avatars1.githubusercontent.com/u/22817111?v=4","gravatar_id":"","url":"https://api.github.com/users/hmcts","html_url":"https://github.com/hmcts","followers_url":"https://api.github.com/users/hmcts/followers","following_url":"https://api.github.com/users/hmcts/following{/other_user}","gists_url":"https://api.github.com/users/hmcts/gists{/gist_id}","starred_url":"https://api.github.com/users/hmcts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hmcts/subscriptions","organizations_url":"https://api.github.com/users/hmcts/orgs","repos_url":"https://api.github.com/users/hmcts/repos","events_url":"https://api.github.com/users/hmcts/events{/privacy}","received_events_url":"https://api.github.com/users/hmcts/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/hmcts/snl-events","description":null,"fork":false,"url":"https://api.github.com/repos/hmcts/snl-events","forks_url":"https://api.github.com/repos/hmcts/snl-events/forks","keys_url":"https://api.github.com/repos/hmcts/snl-events/keys{/key_id}","collaborators_url":"https://api.github.com/repos/hmcts/snl-events/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/hmcts/snl-events/teams","hooks_url":"https://api.github.com/repos/hmcts/snl-events/hooks","issue_events_url":"https://api.github.com/repos/hmcts/snl-events/issues/events{/number}","events_url":"https://api.github.com/repos/hmcts/snl-events/events","assignees_url":"https://api.github.com/repos/hmcts/snl-events/assignees{/user}","branches_url":"https://api.github.com/repos/hmcts/snl-events/branches{/branch}","tags_url":"https://api.github.com/repos/hmcts/snl-events/tags","blobs_url":"https://api.github.com/repos/hmcts/snl-events/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/hmcts/snl-events/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/hmcts/snl-events/git/refs{/sha}","trees_url":"https://api.github.com/repos/hmcts/snl-events/git/trees{/sha}","statuses_url":"https://api.github.com/repos/hmcts/snl-events/statuses/{sha}","languages_url":"https://api.github.com/repos/hmcts/snl-events/languages","stargazers_url":"https://api.github.com/repos/hmcts/snl-events/stargazers","contributors_url":"https://api.github.com/repos/hmcts/snl-events/contributors","subscribers_url":"https://api.github.com/repos/hmcts/snl-events/subscribers","subscription_url":"https://api.github.com/repos/hmcts/snl-events/subscription","commits_url":"https://api.github.com/repos/hmcts/snl-events/commits{/sha}","git_commits_url":"https://api.github.com/repos/hmcts/snl-events/git/commits{/sha}","comments_url":"https://api.github.com/repos/hmcts/snl-events/comments{/number}","issue_comment_url":"https://api.github.com/repos/hmcts/snl-events/issues/comments{/number}","contents_url":"https://api.github.com/repos/hmcts/snl-events/contents/{+path}","compare_url":"https://api.github.com/repos/hmcts/snl-events/compare/{base}...{head}","merges_url":"https://api.github.com/repos/hmcts/snl-events/merges","archive_url":"https://api.github.com/repos/hmcts/snl-events/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/hmcts/snl-events/downloads","issues_url":"https://api.github.com/repos/hmcts/snl-events/issues{/number}","pulls_url":"https://api.github.com/repos/hmcts/snl-events/pulls{/number}","milestones_url":"https://api.github.com/repos/hmcts/snl-events/milestones{/number}","notifications_url":"https://api.github.com/repos/hmcts/snl-events/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/hmcts/snl-events/labels{/name}","releases_url":"https://api.github.com/repos/hmcts/snl-events/releases{/id}","deployments_url":"https://api.github.com/repos/hmcts/snl-events/deployments","created_at":"2018-04-11T15:40:39Z","updated_at":"2018-08-30T10:12:14Z","pushed_at":"2018-08-31T10:50:15Z","git_url":"git://github.com/hmcts/snl-events.git","ssh_url":"git@github.com:hmcts/snl-events.git","clone_url":"https://github.com/hmcts/snl-events.git","svn_url":"https://github.com/hmcts/snl-events","homepage":null,"size":3045,"stargazers_count":2,"watchers_count":2,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":4,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":1,"open_issues":4,"watchers":2,"default_branch":"master"}},"base":{"label":"hmcts:master","ref":"master","sha":"55d48c8e23fe010cf7ea9dbaeebe3df9681f9d90","user":{"login":"hmcts","id":22817111,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyODE3MTEx","avatar_url":"https://avatars1.githubusercontent.com/u/22817111?v=4","gravatar_id":"","url":"https://api.github.com/users/hmcts","html_url":"https://github.com/hmcts","followers_url":"https://api.github.com/users/hmcts/followers","following_url":"https://api.github.com/users/hmcts/following{/other_user}","gists_url":"https://api.github.com/users/hmcts/gists{/gist_id}","starred_url":"https://api.github.com/users/hmcts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hmcts/subscriptions","organizations_url":"https://api.github.com/users/hmcts/orgs","repos_url":"https://api.github.com/users/hmcts/repos","events_url":"https://api.github.com/users/hmcts/events{/privacy}","received_events_url":"https://api.github.com/users/hmcts/received_events","type":"Organization","site_admin":false},"repo":{"id":129116735,"node_id":"MDEwOlJlcG9zaXRvcnkxMjkxMTY3MzU=","name":"snl-events","full_name":"hmcts/snl-events","owner":{"login":"hmcts","id":22817111,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyODE3MTEx","avatar_url":"https://avatars1.githubusercontent.com/u/22817111?v=4","gravatar_id":"","url":"https://api.github.com/users/hmcts","html_url":"https://github.com/hmcts","followers_url":"https://api.github.com/users/hmcts/followers","following_url":"https://api.github.com/users/hmcts/following{/other_user}","gists_url":"https://api.github.com/users/hmcts/gists{/gist_id}","starred_url":"https://api.github.com/users/hmcts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hmcts/subscriptions","organizations_url":"https://api.github.com/users/hmcts/orgs","repos_url":"https://api.github.com/users/hmcts/repos","events_url":"https://api.github.com/users/hmcts/events{/privacy}","received_events_url":"https://api.github.com/users/hmcts/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/hmcts/snl-events","description":null,"fork":false,"url":"https://api.github.com/repos/hmcts/snl-events","forks_url":"https://api.github.com/repos/hmcts/snl-events/forks","keys_url":"https://api.github.com/repos/hmcts/snl-events/keys{/key_id}","collaborators_url":"https://api.github.com/repos/hmcts/snl-events/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/hmcts/snl-events/teams","hooks_url":"https://api.github.com/repos/hmcts/snl-events/hooks","issue_events_url":"https://api.github.com/repos/hmcts/snl-events/issues/events{/number}","events_url":"https://api.github.com/repos/hmcts/snl-events/events","assignees_url":"https://api.github.com/repos/hmcts/snl-events/assignees{/user}","branches_url":"https://api.github.com/repos/hmcts/snl-events/branches{/branch}","tags_url":"https://api.github.com/repos/hmcts/snl-events/tags","blobs_url":"https://api.github.com/repos/hmcts/snl-events/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/hmcts/snl-events/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/hmcts/snl-events/git/refs{/sha}","trees_url":"https://api.github.com/repos/hmcts/snl-events/git/trees{/sha}","statuses_url":"https://api.github.com/repos/hmcts/snl-events/statuses/{sha}","languages_url":"https://api.github.com/repos/hmcts/snl-events/languages","stargazers_url":"https://api.github.com/repos/hmcts/snl-events/stargazers","contributors_url":"https://api.github.com/repos/hmcts/snl-events/contributors","subscribers_url":"https://api.github.com/repos/hmcts/snl-events/subscribers","subscription_url":"https://api.github.com/repos/hmcts/snl-events/subscription","commits_url":"https://api.github.com/repos/hmcts/snl-events/commits{/sha}","git_commits_url":"https://api.github.com/repos/hmcts/snl-events/git/commits{/sha}","comments_url":"https://api.github.com/repos/hmcts/snl-events/comments{/number}","issue_comment_url":"https://api.github.com/repos/hmcts/snl-events/issues/comments{/number}","contents_url":"https://api.github.com/repos/hmcts/snl-events/contents/{+path}","compare_url":"https://api.github.com/repos/hmcts/snl-events/compare/{base}...{head}","merges_url":"https://api.github.com/repos/hmcts/snl-events/merges","archive_url":"https://api.github.com/repos/hmcts/snl-events/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/hmcts/snl-events/downloads","issues_url":"https://api.github.com/repos/hmcts/snl-events/issues{/number}","pulls_url":"https://api.github.com/repos/hmcts/snl-events/pulls{/number}","milestones_url":"https://api.github.com/repos/hmcts/snl-events/milestones{/number}","notifications_url":"https://api.github.com/repos/hmcts/snl-events/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/hmcts/snl-events/labels{/name}","releases_url":"https://api.github.com/repos/hmcts/snl-events/releases{/id}","deployments_url":"https://api.github.com/repos/hmcts/snl-events/deployments","created_at":"2018-04-11T15:40:39Z","updated_at":"2018-08-30T10:12:14Z","pushed_at":"2018-08-31T10:50:15Z","git_url":"git://github.com/hmcts/snl-events.git","ssh_url":"git@github.com:hmcts/snl-events.git","clone_url":"https://github.com/hmcts/snl-events.git","svn_url":"https://github.com/hmcts/snl-events","homepage":null,"size":3045,"stargazers_count":2,"watchers_count":2,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":4,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":1,"open_issues":4,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/108"},"html":{"href":"https://github.com/hmcts/snl-events/pull/108"},"issue":{"href":"https://api.github.com/repos/hmcts/snl-events/issues/108"},"comments":{"href":"https://api.github.com/repos/hmcts/snl-events/issues/108/comments"},"review_comments":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/108/comments"},"review_comment":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/hmcts/snl-events/pulls/108/commits"},"statuses":{"href":"https://api.github.com/repos/hmcts/snl-events/statuses/e58affb177c1710afccdbb2e05c5f11c97b0b70c"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"kpakur"}}