{"action":"created","comment":{"url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/comments/24121127","id":24121127,"diff_hunk":"@@ -0,0 +1,25 @@\n+-- Deploy cookbook_artifact_versions\n+-- requires: cookbook_artifacts\n+\n+BEGIN;\n+\n+CREATE TABLE IF NOT EXISTS cookbook_artifact_versions(\n+  id CHAR(32) PRIMARY KEY,\n+  identifier VARCHAR(255) NOT NULL,\n+  meta_attributes bytea NOT NULL,\n+  meta_long_desc bytea NOT NULL,\n+  metadata bytea NOT NULL,\n+  serialized_object bytea NOT NULL,\n+  updated_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,\n+  created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,\n+  last_updated_by CHAR(32) NOT NULL,\n+  cookbook_id INTEGER NOT NULL REFERENCES cookbooks(id) ON DELETE RESTRICT,\n+  UNIQUE(cookbook_id, identifier)\n+);\n+\n+ALTER TABLE cookbook_artifact_versions ALTER meta_attributes SET STORAGE EXTERNAL;","path":"deploy/cookbook_artifact_versions.sql","position":20,"original_position":20,"commit_id":"c3ecbd0dc73051f3b3386054293d98fcb0f0f73a","original_commit_id":"c3ecbd0dc73051f3b3386054293d98fcb0f0f73a","user":{"login":"marcparadise","id":1130204,"avatar_url":"https://avatars.githubusercontent.com/u/1130204?v=3","gravatar_id":"","url":"https://api.github.com/users/marcparadise","html_url":"https://github.com/marcparadise","followers_url":"https://api.github.com/users/marcparadise/followers","following_url":"https://api.github.com/users/marcparadise/following{/other_user}","gists_url":"https://api.github.com/users/marcparadise/gists{/gist_id}","starred_url":"https://api.github.com/users/marcparadise/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcparadise/subscriptions","organizations_url":"https://api.github.com/users/marcparadise/orgs","repos_url":"https://api.github.com/users/marcparadise/repos","events_url":"https://api.github.com/users/marcparadise/events{/privacy}","received_events_url":"https://api.github.com/users/marcparadise/received_events","type":"User","site_admin":false},"body":"Not familiar with EXTERNAL, what's it do?","created_at":"2015-02-04T21:26:51Z","updated_at":"2015-02-04T21:26:51Z","html_url":"https://github.com/chef/enterprise-chef-server-schema/pull/23#discussion_r24121127","pull_request_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23","_links":{"self":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/comments/24121127"},"html":{"href":"https://github.com/chef/enterprise-chef-server-schema/pull/23#discussion_r24121127"},"pull_request":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23"}}},"pull_request":{"url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23","id":28662188,"html_url":"https://github.com/chef/enterprise-chef-server-schema/pull/23","diff_url":"https://github.com/chef/enterprise-chef-server-schema/pull/23.diff","patch_url":"https://github.com/chef/enterprise-chef-server-schema/pull/23.patch","issue_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/23","number":23,"state":"open","locked":false,"title":"Adding required tables for the new cookbook_artifacts endpoint","user":{"login":"wk8","id":2536231,"avatar_url":"https://avatars.githubusercontent.com/u/2536231?v=3","gravatar_id":"","url":"https://api.github.com/users/wk8","html_url":"https://github.com/wk8","followers_url":"https://api.github.com/users/wk8/followers","following_url":"https://api.github.com/users/wk8/following{/other_user}","gists_url":"https://api.github.com/users/wk8/gists{/gist_id}","starred_url":"https://api.github.com/users/wk8/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wk8/subscriptions","organizations_url":"https://api.github.com/users/wk8/orgs","repos_url":"https://api.github.com/users/wk8/repos","events_url":"https://api.github.com/users/wk8/events{/privacy}","received_events_url":"https://api.github.com/users/wk8/received_events","type":"User","site_admin":false},"body":"Mostly similar to the good old 'cookbook*' tables, but still different\r\nenough to make them separate.\r\nAlso makes sense since we want this new endpoint's data completely\r\nseparate from the old one's.","created_at":"2015-02-04T18:26:13Z","updated_at":"2015-02-04T21:26:51Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d88ca47b961e3bae6419fec8fcd09237ca6d0b5e","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23/commits","review_comments_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23/comments","review_comment_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/comments/{number}","comments_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/23/comments","statuses_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/statuses/c3ecbd0dc73051f3b3386054293d98fcb0f0f73a","head":{"label":"chef:jr/new_cookbook_endpoints","ref":"jr/new_cookbook_endpoints","sha":"c3ecbd0dc73051f3b3386054293d98fcb0f0f73a","user":{"login":"chef","id":29740,"avatar_url":"https://avatars.githubusercontent.com/u/29740?v=3","gravatar_id":"","url":"https://api.github.com/users/chef","html_url":"https://github.com/chef","followers_url":"https://api.github.com/users/chef/followers","following_url":"https://api.github.com/users/chef/following{/other_user}","gists_url":"https://api.github.com/users/chef/gists{/gist_id}","starred_url":"https://api.github.com/users/chef/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chef/subscriptions","organizations_url":"https://api.github.com/users/chef/orgs","repos_url":"https://api.github.com/users/chef/repos","events_url":"https://api.github.com/users/chef/events{/privacy}","received_events_url":"https://api.github.com/users/chef/received_events","type":"Organization","site_admin":false},"repo":{"id":12822498,"name":"enterprise-chef-server-schema","full_name":"chef/enterprise-chef-server-schema","owner":{"login":"chef","id":29740,"avatar_url":"https://avatars.githubusercontent.com/u/29740?v=3","gravatar_id":"","url":"https://api.github.com/users/chef","html_url":"https://github.com/chef","followers_url":"https://api.github.com/users/chef/followers","following_url":"https://api.github.com/users/chef/following{/other_user}","gists_url":"https://api.github.com/users/chef/gists{/gist_id}","starred_url":"https://api.github.com/users/chef/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chef/subscriptions","organizations_url":"https://api.github.com/users/chef/orgs","repos_url":"https://api.github.com/users/chef/repos","events_url":"https://api.github.com/users/chef/events{/privacy}","received_events_url":"https://api.github.com/users/chef/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/chef/enterprise-chef-server-schema","description":"SQL Schema for the Enterprise Open Source Chef Server","fork":false,"url":"https://api.github.com/repos/chef/enterprise-chef-server-schema","forks_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/forks","keys_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/keys{/key_id}","collaborators_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/teams","hooks_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/hooks","issue_events_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/events{/number}","events_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/events","assignees_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/assignees{/user}","branches_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/branches{/branch}","tags_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/tags","blobs_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/refs{/sha}","trees_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/trees{/sha}","statuses_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/statuses/{sha}","languages_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/languages","stargazers_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/stargazers","contributors_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/contributors","subscribers_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/subscribers","subscription_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/subscription","commits_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/commits{/sha}","git_commits_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/commits{/sha}","comments_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/comments{/number}","issue_comment_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/comments/{number}","contents_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/contents/{+path}","compare_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/compare/{base}...{head}","merges_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/merges","archive_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/downloads","issues_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues{/number}","pulls_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls{/number}","milestones_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/milestones{/number}","notifications_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/labels{/name}","releases_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/releases{/id}","created_at":"2013-09-14T01:12:39Z","updated_at":"2015-01-23T15:47:38Z","pushed_at":"2015-02-04T21:26:28Z","git_url":"git://github.com/chef/enterprise-chef-server-schema.git","ssh_url":"git@github.com:chef/enterprise-chef-server-schema.git","clone_url":"https://github.com/chef/enterprise-chef-server-schema.git","svn_url":"https://github.com/chef/enterprise-chef-server-schema","homepage":null,"size":775,"stargazers_count":0,"watchers_count":0,"language":"Makefile","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"base":{"label":"chef:master","ref":"master","sha":"568589d96543ba4ad9ce1dda942c4299304a8983","user":{"login":"chef","id":29740,"avatar_url":"https://avatars.githubusercontent.com/u/29740?v=3","gravatar_id":"","url":"https://api.github.com/users/chef","html_url":"https://github.com/chef","followers_url":"https://api.github.com/users/chef/followers","following_url":"https://api.github.com/users/chef/following{/other_user}","gists_url":"https://api.github.com/users/chef/gists{/gist_id}","starred_url":"https://api.github.com/users/chef/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chef/subscriptions","organizations_url":"https://api.github.com/users/chef/orgs","repos_url":"https://api.github.com/users/chef/repos","events_url":"https://api.github.com/users/chef/events{/privacy}","received_events_url":"https://api.github.com/users/chef/received_events","type":"Organization","site_admin":false},"repo":{"id":12822498,"name":"enterprise-chef-server-schema","full_name":"chef/enterprise-chef-server-schema","owner":{"login":"chef","id":29740,"avatar_url":"https://avatars.githubusercontent.com/u/29740?v=3","gravatar_id":"","url":"https://api.github.com/users/chef","html_url":"https://github.com/chef","followers_url":"https://api.github.com/users/chef/followers","following_url":"https://api.github.com/users/chef/following{/other_user}","gists_url":"https://api.github.com/users/chef/gists{/gist_id}","starred_url":"https://api.github.com/users/chef/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chef/subscriptions","organizations_url":"https://api.github.com/users/chef/orgs","repos_url":"https://api.github.com/users/chef/repos","events_url":"https://api.github.com/users/chef/events{/privacy}","received_events_url":"https://api.github.com/users/chef/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/chef/enterprise-chef-server-schema","description":"SQL Schema for the Enterprise Open Source Chef Server","fork":false,"url":"https://api.github.com/repos/chef/enterprise-chef-server-schema","forks_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/forks","keys_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/keys{/key_id}","collaborators_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/teams","hooks_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/hooks","issue_events_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/events{/number}","events_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/events","assignees_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/assignees{/user}","branches_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/branches{/branch}","tags_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/tags","blobs_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/refs{/sha}","trees_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/trees{/sha}","statuses_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/statuses/{sha}","languages_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/languages","stargazers_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/stargazers","contributors_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/contributors","subscribers_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/subscribers","subscription_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/subscription","commits_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/commits{/sha}","git_commits_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/git/commits{/sha}","comments_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/comments{/number}","issue_comment_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/comments/{number}","contents_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/contents/{+path}","compare_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/compare/{base}...{head}","merges_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/merges","archive_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/downloads","issues_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues{/number}","pulls_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls{/number}","milestones_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/milestones{/number}","notifications_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/labels{/name}","releases_url":"https://api.github.com/repos/chef/enterprise-chef-server-schema/releases{/id}","created_at":"2013-09-14T01:12:39Z","updated_at":"2015-01-23T15:47:38Z","pushed_at":"2015-02-04T21:26:28Z","git_url":"git://github.com/chef/enterprise-chef-server-schema.git","ssh_url":"git@github.com:chef/enterprise-chef-server-schema.git","clone_url":"https://github.com/chef/enterprise-chef-server-schema.git","svn_url":"https://github.com/chef/enterprise-chef-server-schema","homepage":null,"size":775,"stargazers_count":0,"watchers_count":0,"language":"Makefile","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23"},"html":{"href":"https://github.com/chef/enterprise-chef-server-schema/pull/23"},"issue":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/23"},"comments":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/issues/23/comments"},"review_comments":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23/comments"},"review_comment":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/pulls/23/commits"},"statuses":{"href":"https://api.github.com/repos/chef/enterprise-chef-server-schema/statuses/c3ecbd0dc73051f3b3386054293d98fcb0f0f73a"}}}}