{"action":"created","comment":{"url":"https://api.github.com/repos/xtuple/xtuple/pulls/comments/221477519","pull_request_review_id":160126841,"id":221477519,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIyMTQ3NzUxOQ==","diff_hunk":"@@ -111,16 +114,20 @@ SELECT\n                    'FOREIGN KEY (cohead_shipto_id) REFERENCES shiptoinfo(shipto_id)', 'public'),\n   xt.add_constraint('cohead', 'cohead_cohead_shipzone_id_fkey',\n                    'FOREIGN KEY (cohead_shipzone_id) REFERENCES shipzone(shipzone_id)', 'public'),\n-  xt.add_constraint('cohead', 'cohead_cohead_taxtype_id_fkey',\n-                   'FOREIGN KEY (cohead_taxtype_id) REFERENCES taxtype(taxtype_id)', 'public'),\n   xt.add_constraint('cohead', 'cohead_cohead_taxzone_id_fkey',\n                    'FOREIGN KEY (cohead_taxzone_id) REFERENCES taxzone(taxzone_id)', 'public'),\n   xt.add_constraint('cohead', 'cohead_cohead_terms_id_fkey',\n                    'FOREIGN KEY (cohead_terms_id) REFERENCES terms(terms_id)', 'public'),\n   xt.add_constraint('cohead', 'cohead_cohead_warehous_id_fkey',\n                    'FOREIGN KEY (cohead_warehous_id) REFERENCES whsinfo(warehous_id)', 'public'),\n   xt.add_constraint('cohead', 'cohead_to_curr_symbol',\n-                   'FOREIGN KEY (cohead_curr_id) REFERENCES curr_symbol(curr_id)', 'public');\n+                   'FOREIGN KEY (cohead_curr_id) REFERENCES curr_symbol(curr_id)', 'public'),\n+  xt.add_constraint('cohead', 'cohead_cohead_freight_taxtype_id_fkey',\n+                    'FOREIGN KEY (cohead_freight_taxtype_id) REFERENCES taxtype(taxtype_id)', 'public'),\n+  xt.add_constraint('cohead', 'cohead_cohead_misc_taxtype_id_fkey',\n+                    'FOREIGN KEY (cohead_misc_taxtype_id) REFERENCES taxtype(taxtype_id)', 'public');\n+\n+  ALTER TABLE cohead DROP COLUMN IF EXISTS cohead_taxtype_id;","path":"foundation-database/public/tables/cohead.sql","position":37,"original_position":37,"commit_id":"9c0404a678c12efd1a26bcd82e42d84128d66123","original_commit_id":"9c0404a678c12efd1a26bcd82e42d84128d66123","user":{"login":"andersdd","id":4682742,"node_id":"MDQ6VXNlcjQ2ODI3NDI=","avatar_url":"https://avatars3.githubusercontent.com/u/4682742?v=4","gravatar_id":"","url":"https://api.github.com/users/andersdd","html_url":"https://github.com/andersdd","followers_url":"https://api.github.com/users/andersdd/followers","following_url":"https://api.github.com/users/andersdd/following{/other_user}","gists_url":"https://api.github.com/users/andersdd/gists{/gist_id}","starred_url":"https://api.github.com/users/andersdd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andersdd/subscriptions","organizations_url":"https://api.github.com/users/andersdd/orgs","repos_url":"https://api.github.com/users/andersdd/repos","events_url":"https://api.github.com/users/andersdd/events{/privacy}","received_events_url":"https://api.github.com/users/andersdd/received_events","type":"User","site_admin":false},"body":"Are there any CASCADE implications here?","created_at":"2018-09-30T23:26:17Z","updated_at":"2018-09-30T23:46:08Z","html_url":"https://github.com/xtuple/xtuple/pull/3428#discussion_r221477519","pull_request_url":"https://api.github.com/repos/xtuple/xtuple/pulls/3428","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/comments/221477519"},"html":{"href":"https://github.com/xtuple/xtuple/pull/3428#discussion_r221477519"},"pull_request":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/3428"}}},"pull_request":{"url":"https://api.github.com/repos/xtuple/xtuple/pulls/3428","id":218507461,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE4NTA3NDYx","html_url":"https://github.com/xtuple/xtuple/pull/3428","diff_url":"https://github.com/xtuple/xtuple/pull/3428.diff","patch_url":"https://github.com/xtuple/xtuple/pull/3428.patch","issue_url":"https://api.github.com/repos/xtuple/xtuple/issues/3428","number":3428,"state":"open","locked":false,"title":"Merge Avalara tax into v5 0","user":{"login":"andersdd","id":4682742,"node_id":"MDQ6VXNlcjQ2ODI3NDI=","avatar_url":"https://avatars3.githubusercontent.com/u/4682742?v=4","gravatar_id":"","url":"https://api.github.com/users/andersdd","html_url":"https://github.com/andersdd","followers_url":"https://api.github.com/users/andersdd/followers","following_url":"https://api.github.com/users/andersdd/following{/other_user}","gists_url":"https://api.github.com/users/andersdd/gists{/gist_id}","starred_url":"https://api.github.com/users/andersdd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andersdd/subscriptions","organizations_url":"https://api.github.com/users/andersdd/orgs","repos_url":"https://api.github.com/users/andersdd/repos","events_url":"https://api.github.com/users/andersdd/events{/privacy}","received_events_url":"https://api.github.com/users/andersdd/received_events","type":"User","site_admin":false},"body":"[NO NOT MERGE] PR created for code review purposes [@andersdd currently reviewing]","created_at":"2018-09-27T02:38:36Z","updated_at":"2018-09-30T23:46:07Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1d9bd8b669cc25d96459d8a62a607d03a3172c91","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/xtuple/xtuple/pulls/3428/commits","review_comments_url":"https://api.github.com/repos/xtuple/xtuple/pulls/3428/comments","review_comment_url":"https://api.github.com/repos/xtuple/xtuple/pulls/comments{/number}","comments_url":"https://api.github.com/repos/xtuple/xtuple/issues/3428/comments","statuses_url":"https://api.github.com/repos/xtuple/xtuple/statuses/9c0404a678c12efd1a26bcd82e42d84128d66123","head":{"label":"andersdd:merge_tax_into_v5_0","ref":"merge_tax_into_v5_0","sha":"9c0404a678c12efd1a26bcd82e42d84128d66123","user":{"login":"andersdd","id":4682742,"node_id":"MDQ6VXNlcjQ2ODI3NDI=","avatar_url":"https://avatars3.githubusercontent.com/u/4682742?v=4","gravatar_id":"","url":"https://api.github.com/users/andersdd","html_url":"https://github.com/andersdd","followers_url":"https://api.github.com/users/andersdd/followers","following_url":"https://api.github.com/users/andersdd/following{/other_user}","gists_url":"https://api.github.com/users/andersdd/gists{/gist_id}","starred_url":"https://api.github.com/users/andersdd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andersdd/subscriptions","organizations_url":"https://api.github.com/users/andersdd/orgs","repos_url":"https://api.github.com/users/andersdd/repos","events_url":"https://api.github.com/users/andersdd/events{/privacy}","received_events_url":"https://api.github.com/users/andersdd/received_events","type":"User","site_admin":false},"repo":{"id":10651573,"node_id":"MDEwOlJlcG9zaXRvcnkxMDY1MTU3Mw==","name":"xtuple","full_name":"andersdd/xtuple","private":false,"owner":{"login":"andersdd","id":4682742,"node_id":"MDQ6VXNlcjQ2ODI3NDI=","avatar_url":"https://avatars3.githubusercontent.com/u/4682742?v=4","gravatar_id":"","url":"https://api.github.com/users/andersdd","html_url":"https://github.com/andersdd","followers_url":"https://api.github.com/users/andersdd/followers","following_url":"https://api.github.com/users/andersdd/following{/other_user}","gists_url":"https://api.github.com/users/andersdd/gists{/gist_id}","starred_url":"https://api.github.com/users/andersdd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andersdd/subscriptions","organizations_url":"https://api.github.com/users/andersdd/orgs","repos_url":"https://api.github.com/users/andersdd/repos","events_url":"https://api.github.com/users/andersdd/events{/privacy}","received_events_url":"https://api.github.com/users/andersdd/received_events","type":"User","site_admin":false},"html_url":"https://github.com/andersdd/xtuple","description":"xTuple Enterprise Resource Planning","fork":true,"url":"https://api.github.com/repos/andersdd/xtuple","forks_url":"https://api.github.com/repos/andersdd/xtuple/forks","keys_url":"https://api.github.com/repos/andersdd/xtuple/keys{/key_id}","collaborators_url":"https://api.github.com/repos/andersdd/xtuple/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/andersdd/xtuple/teams","hooks_url":"https://api.github.com/repos/andersdd/xtuple/hooks","issue_events_url":"https://api.github.com/repos/andersdd/xtuple/issues/events{/number}","events_url":"https://api.github.com/repos/andersdd/xtuple/events","assignees_url":"https://api.github.com/repos/andersdd/xtuple/assignees{/user}","branches_url":"https://api.github.com/repos/andersdd/xtuple/branches{/branch}","tags_url":"https://api.github.com/repos/andersdd/xtuple/tags","blobs_url":"https://api.github.com/repos/andersdd/xtuple/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/andersdd/xtuple/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/andersdd/xtuple/git/refs{/sha}","trees_url":"https://api.github.com/repos/andersdd/xtuple/git/trees{/sha}","statuses_url":"https://api.github.com/repos/andersdd/xtuple/statuses/{sha}","languages_url":"https://api.github.com/repos/andersdd/xtuple/languages","stargazers_url":"https://api.github.com/repos/andersdd/xtuple/stargazers","contributors_url":"https://api.github.com/repos/andersdd/xtuple/contributors","subscribers_url":"https://api.github.com/repos/andersdd/xtuple/subscribers","subscription_url":"https://api.github.com/repos/andersdd/xtuple/subscription","commits_url":"https://api.github.com/repos/andersdd/xtuple/commits{/sha}","git_commits_url":"https://api.github.com/repos/andersdd/xtuple/git/commits{/sha}","comments_url":"https://api.github.com/repos/andersdd/xtuple/comments{/number}","issue_comment_url":"https://api.github.com/repos/andersdd/xtuple/issues/comments{/number}","contents_url":"https://api.github.com/repos/andersdd/xtuple/contents/{+path}","compare_url":"https://api.github.com/repos/andersdd/xtuple/compare/{base}...{head}","merges_url":"https://api.github.com/repos/andersdd/xtuple/merges","archive_url":"https://api.github.com/repos/andersdd/xtuple/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/andersdd/xtuple/downloads","issues_url":"https://api.github.com/repos/andersdd/xtuple/issues{/number}","pulls_url":"https://api.github.com/repos/andersdd/xtuple/pulls{/number}","milestones_url":"https://api.github.com/repos/andersdd/xtuple/milestones{/number}","notifications_url":"https://api.github.com/repos/andersdd/xtuple/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/andersdd/xtuple/labels{/name}","releases_url":"https://api.github.com/repos/andersdd/xtuple/releases{/id}","deployments_url":"https://api.github.com/repos/andersdd/xtuple/deployments","created_at":"2013-06-12T20:36:45Z","updated_at":"2014-07-06T21:58:43Z","pushed_at":"2018-09-27T02:37:34Z","git_url":"git://github.com/andersdd/xtuple.git","ssh_url":"git@github.com:andersdd/xtuple.git","clone_url":"https://github.com/andersdd/xtuple.git","svn_url":"https://github.com/andersdd/xtuple","homepage":null,"size":74619,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"NOASSERTION","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"xtuple:5_0_x","ref":"5_0_x","sha":"5fe0bc1c2e45671b4939efce29e90459466ade41","user":{"login":"xtuple","id":703922,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMzkyMg==","avatar_url":"https://avatars1.githubusercontent.com/u/703922?v=4","gravatar_id":"","url":"https://api.github.com/users/xtuple","html_url":"https://github.com/xtuple","followers_url":"https://api.github.com/users/xtuple/followers","following_url":"https://api.github.com/users/xtuple/following{/other_user}","gists_url":"https://api.github.com/users/xtuple/gists{/gist_id}","starred_url":"https://api.github.com/users/xtuple/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xtuple/subscriptions","organizations_url":"https://api.github.com/users/xtuple/orgs","repos_url":"https://api.github.com/users/xtuple/repos","events_url":"https://api.github.com/users/xtuple/events{/privacy}","received_events_url":"https://api.github.com/users/xtuple/received_events","type":"Organization","site_admin":false},"repo":{"id":8138568,"node_id":"MDEwOlJlcG9zaXRvcnk4MTM4NTY4","name":"xtuple","full_name":"xtuple/xtuple","private":false,"owner":{"login":"xtuple","id":703922,"node_id":"MDEyOk9yZ2FuaXphdGlvbjcwMzkyMg==","avatar_url":"https://avatars1.githubusercontent.com/u/703922?v=4","gravatar_id":"","url":"https://api.github.com/users/xtuple","html_url":"https://github.com/xtuple","followers_url":"https://api.github.com/users/xtuple/followers","following_url":"https://api.github.com/users/xtuple/following{/other_user}","gists_url":"https://api.github.com/users/xtuple/gists{/gist_id}","starred_url":"https://api.github.com/users/xtuple/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xtuple/subscriptions","organizations_url":"https://api.github.com/users/xtuple/orgs","repos_url":"https://api.github.com/users/xtuple/repos","events_url":"https://api.github.com/users/xtuple/events{/privacy}","received_events_url":"https://api.github.com/users/xtuple/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/xtuple/xtuple","description":"This repository contains the source code for the database schema for the PostBooks edition of xTuple ERP and xTuple's REST API server. The REST API server is written in JavaScript running on Node.js. The database schema for PostBooks runs on a PostgreSQL database server.","fork":false,"url":"https://api.github.com/repos/xtuple/xtuple","forks_url":"https://api.github.com/repos/xtuple/xtuple/forks","keys_url":"https://api.github.com/repos/xtuple/xtuple/keys{/key_id}","collaborators_url":"https://api.github.com/repos/xtuple/xtuple/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/xtuple/xtuple/teams","hooks_url":"https://api.github.com/repos/xtuple/xtuple/hooks","issue_events_url":"https://api.github.com/repos/xtuple/xtuple/issues/events{/number}","events_url":"https://api.github.com/repos/xtuple/xtuple/events","assignees_url":"https://api.github.com/repos/xtuple/xtuple/assignees{/user}","branches_url":"https://api.github.com/repos/xtuple/xtuple/branches{/branch}","tags_url":"https://api.github.com/repos/xtuple/xtuple/tags","blobs_url":"https://api.github.com/repos/xtuple/xtuple/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/xtuple/xtuple/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/xtuple/xtuple/git/refs{/sha}","trees_url":"https://api.github.com/repos/xtuple/xtuple/git/trees{/sha}","statuses_url":"https://api.github.com/repos/xtuple/xtuple/statuses/{sha}","languages_url":"https://api.github.com/repos/xtuple/xtuple/languages","stargazers_url":"https://api.github.com/repos/xtuple/xtuple/stargazers","contributors_url":"https://api.github.com/repos/xtuple/xtuple/contributors","subscribers_url":"https://api.github.com/repos/xtuple/xtuple/subscribers","subscription_url":"https://api.github.com/repos/xtuple/xtuple/subscription","commits_url":"https://api.github.com/repos/xtuple/xtuple/commits{/sha}","git_commits_url":"https://api.github.com/repos/xtuple/xtuple/git/commits{/sha}","comments_url":"https://api.github.com/repos/xtuple/xtuple/comments{/number}","issue_comment_url":"https://api.github.com/repos/xtuple/xtuple/issues/comments{/number}","contents_url":"https://api.github.com/repos/xtuple/xtuple/contents/{+path}","compare_url":"https://api.github.com/repos/xtuple/xtuple/compare/{base}...{head}","merges_url":"https://api.github.com/repos/xtuple/xtuple/merges","archive_url":"https://api.github.com/repos/xtuple/xtuple/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/xtuple/xtuple/downloads","issues_url":"https://api.github.com/repos/xtuple/xtuple/issues{/number}","pulls_url":"https://api.github.com/repos/xtuple/xtuple/pulls{/number}","milestones_url":"https://api.github.com/repos/xtuple/xtuple/milestones{/number}","notifications_url":"https://api.github.com/repos/xtuple/xtuple/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/xtuple/xtuple/labels{/name}","releases_url":"https://api.github.com/repos/xtuple/xtuple/releases{/id}","deployments_url":"https://api.github.com/repos/xtuple/xtuple/deployments","created_at":"2013-02-11T13:33:14Z","updated_at":"2018-09-26T02:17:59Z","pushed_at":"2018-09-28T17:53:25Z","git_url":"git://github.com/xtuple/xtuple.git","ssh_url":"git@github.com:xtuple/xtuple.git","clone_url":"https://github.com/xtuple/xtuple.git","svn_url":"https://github.com/xtuple/xtuple","homepage":"http://www.xtuple.com","size":74778,"stargazers_count":215,"watchers_count":215,"language":"PLpgSQL","has_issues":false,"has_projects":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":329,"mirror_url":null,"archived":false,"open_issues_count":4,"license":{"key":"other","name":"NOASSERTION","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":329,"open_issues":4,"watchers":215,"default_branch":"4_12_x"}},"_links":{"self":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/3428"},"html":{"href":"https://github.com/xtuple/xtuple/pull/3428"},"issue":{"href":"https://api.github.com/repos/xtuple/xtuple/issues/3428"},"comments":{"href":"https://api.github.com/repos/xtuple/xtuple/issues/3428/comments"},"review_comments":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/3428/comments"},"review_comment":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/xtuple/xtuple/pulls/3428/commits"},"statuses":{"href":"https://api.github.com/repos/xtuple/xtuple/statuses/9c0404a678c12efd1a26bcd82e42d84128d66123"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"andersdd"}}