{"action":"created","comment":{"url":"https://api.github.com/repos/rmunz/BetterU/pulls/comments/57398582","id":57398582,"diff_hunk":"@@ -0,0 +1,69 @@\n+-- Created by Vertabelo (http://vertabelo.com)\n+-- Last modification date: 2016-03-24 18:47:45.761\n+\n+\n+\n+\n+-- tables\n+-- Table Challenges\n+CREATE TABLE Challenges (\n+    Name varchar(255)  NOT NULL,\n+    Description varchar(255)  NOT NULL,\n+    ChallengeType varchar(255)  NOT NULL,\n+    PointsAwarded int  NOT NULL,\n+    CONSTRAINT Challenges_pk PRIMARY KEY (Name)\n+);\n+\n+-- Table Goal\n+CREATE TABLE Goal (","path":"BetterU_create.sql","position":18,"original_position":18,"commit_id":"7bbefba2b2854817cc9d70fc06dfffaeef5a3787","original_commit_id":"7bbefba2b2854817cc9d70fc06dfffaeef5a3787","user":{"login":"jmbinger","id":8798102,"avatar_url":"https://avatars.githubusercontent.com/u/8798102?v=3","gravatar_id":"","url":"https://api.github.com/users/jmbinger","html_url":"https://github.com/jmbinger","followers_url":"https://api.github.com/users/jmbinger/followers","following_url":"https://api.github.com/users/jmbinger/following{/other_user}","gists_url":"https://api.github.com/users/jmbinger/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbinger/subscriptions","organizations_url":"https://api.github.com/users/jmbinger/orgs","repos_url":"https://api.github.com/users/jmbinger/repos","events_url":"https://api.github.com/users/jmbinger/events{/privacy}","received_events_url":"https://api.github.com/users/jmbinger/received_events","type":"User","site_admin":false},"body":"need to allow certain goal fields to be null","created_at":"2016-03-24T22:34:43Z","updated_at":"2016-03-24T22:34:43Z","html_url":"https://github.com/rmunz/BetterU/pull/4#discussion_r57398582","pull_request_url":"https://api.github.com/repos/rmunz/BetterU/pulls/4","_links":{"self":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/comments/57398582"},"html":{"href":"https://github.com/rmunz/BetterU/pull/4#discussion_r57398582"},"pull_request":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/4"}}},"pull_request":{"url":"https://api.github.com/repos/rmunz/BetterU/pulls/4","id":64083583,"html_url":"https://github.com/rmunz/BetterU/pull/4","diff_url":"https://github.com/rmunz/BetterU/pull/4.diff","patch_url":"https://github.com/rmunz/BetterU/pull/4.patch","issue_url":"https://api.github.com/repos/rmunz/BetterU/issues/4","number":4,"state":"closed","locked":false,"title":"sql script","user":{"login":"jmbinger","id":8798102,"avatar_url":"https://avatars.githubusercontent.com/u/8798102?v=3","gravatar_id":"","url":"https://api.github.com/users/jmbinger","html_url":"https://github.com/jmbinger","followers_url":"https://api.github.com/users/jmbinger/followers","following_url":"https://api.github.com/users/jmbinger/following{/other_user}","gists_url":"https://api.github.com/users/jmbinger/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbinger/subscriptions","organizations_url":"https://api.github.com/users/jmbinger/orgs","repos_url":"https://api.github.com/users/jmbinger/repos","events_url":"https://api.github.com/users/jmbinger/events{/privacy}","received_events_url":"https://api.github.com/users/jmbinger/received_events","type":"User","site_admin":false},"body":"first version, may need some tweaking\r\n@rmunz @csmcquay @mybu5 @ojmhetar ","created_at":"2016-03-24T19:08:19Z","updated_at":"2016-03-24T22:34:43Z","closed_at":"2016-03-24T20:22:19Z","merged_at":"2016-03-24T20:22:19Z","merge_commit_sha":"46f32e27b570385f24fff4e3f901069ee3e47afa","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/rmunz/BetterU/pulls/4/commits","review_comments_url":"https://api.github.com/repos/rmunz/BetterU/pulls/4/comments","review_comment_url":"https://api.github.com/repos/rmunz/BetterU/pulls/comments{/number}","comments_url":"https://api.github.com/repos/rmunz/BetterU/issues/4/comments","statuses_url":"https://api.github.com/repos/rmunz/BetterU/statuses/7bbefba2b2854817cc9d70fc06dfffaeef5a3787","head":{"label":"jmbinger:sql","ref":"sql","sha":"7bbefba2b2854817cc9d70fc06dfffaeef5a3787","user":{"login":"jmbinger","id":8798102,"avatar_url":"https://avatars.githubusercontent.com/u/8798102?v=3","gravatar_id":"","url":"https://api.github.com/users/jmbinger","html_url":"https://github.com/jmbinger","followers_url":"https://api.github.com/users/jmbinger/followers","following_url":"https://api.github.com/users/jmbinger/following{/other_user}","gists_url":"https://api.github.com/users/jmbinger/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbinger/subscriptions","organizations_url":"https://api.github.com/users/jmbinger/orgs","repos_url":"https://api.github.com/users/jmbinger/repos","events_url":"https://api.github.com/users/jmbinger/events{/privacy}","received_events_url":"https://api.github.com/users/jmbinger/received_events","type":"User","site_admin":false},"repo":{"id":54517263,"name":"BetterU","full_name":"jmbinger/BetterU","owner":{"login":"jmbinger","id":8798102,"avatar_url":"https://avatars.githubusercontent.com/u/8798102?v=3","gravatar_id":"","url":"https://api.github.com/users/jmbinger","html_url":"https://github.com/jmbinger","followers_url":"https://api.github.com/users/jmbinger/followers","following_url":"https://api.github.com/users/jmbinger/following{/other_user}","gists_url":"https://api.github.com/users/jmbinger/gists{/gist_id}","starred_url":"https://api.github.com/users/jmbinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmbinger/subscriptions","organizations_url":"https://api.github.com/users/jmbinger/orgs","repos_url":"https://api.github.com/users/jmbinger/repos","events_url":"https://api.github.com/users/jmbinger/events{/privacy}","received_events_url":"https://api.github.com/users/jmbinger/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jmbinger/BetterU","description":"A Nutrition and Fitness App combined so that you can be you, but better.","fork":true,"url":"https://api.github.com/repos/jmbinger/BetterU","forks_url":"https://api.github.com/repos/jmbinger/BetterU/forks","keys_url":"https://api.github.com/repos/jmbinger/BetterU/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jmbinger/BetterU/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jmbinger/BetterU/teams","hooks_url":"https://api.github.com/repos/jmbinger/BetterU/hooks","issue_events_url":"https://api.github.com/repos/jmbinger/BetterU/issues/events{/number}","events_url":"https://api.github.com/repos/jmbinger/BetterU/events","assignees_url":"https://api.github.com/repos/jmbinger/BetterU/assignees{/user}","branches_url":"https://api.github.com/repos/jmbinger/BetterU/branches{/branch}","tags_url":"https://api.github.com/repos/jmbinger/BetterU/tags","blobs_url":"https://api.github.com/repos/jmbinger/BetterU/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jmbinger/BetterU/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jmbinger/BetterU/git/refs{/sha}","trees_url":"https://api.github.com/repos/jmbinger/BetterU/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jmbinger/BetterU/statuses/{sha}","languages_url":"https://api.github.com/repos/jmbinger/BetterU/languages","stargazers_url":"https://api.github.com/repos/jmbinger/BetterU/stargazers","contributors_url":"https://api.github.com/repos/jmbinger/BetterU/contributors","subscribers_url":"https://api.github.com/repos/jmbinger/BetterU/subscribers","subscription_url":"https://api.github.com/repos/jmbinger/BetterU/subscription","commits_url":"https://api.github.com/repos/jmbinger/BetterU/commits{/sha}","git_commits_url":"https://api.github.com/repos/jmbinger/BetterU/git/commits{/sha}","comments_url":"https://api.github.com/repos/jmbinger/BetterU/comments{/number}","issue_comment_url":"https://api.github.com/repos/jmbinger/BetterU/issues/comments{/number}","contents_url":"https://api.github.com/repos/jmbinger/BetterU/contents/{+path}","compare_url":"https://api.github.com/repos/jmbinger/BetterU/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jmbinger/BetterU/merges","archive_url":"https://api.github.com/repos/jmbinger/BetterU/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jmbinger/BetterU/downloads","issues_url":"https://api.github.com/repos/jmbinger/BetterU/issues{/number}","pulls_url":"https://api.github.com/repos/jmbinger/BetterU/pulls{/number}","milestones_url":"https://api.github.com/repos/jmbinger/BetterU/milestones{/number}","notifications_url":"https://api.github.com/repos/jmbinger/BetterU/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jmbinger/BetterU/labels{/name}","releases_url":"https://api.github.com/repos/jmbinger/BetterU/releases{/id}","deployments_url":"https://api.github.com/repos/jmbinger/BetterU/deployments","created_at":"2016-03-23T00:02:08Z","updated_at":"2016-02-09T22:33:17Z","pushed_at":"2016-03-24T19:07:11Z","git_url":"git://github.com/jmbinger/BetterU.git","ssh_url":"git@github.com:jmbinger/BetterU.git","clone_url":"https://github.com/jmbinger/BetterU.git","svn_url":"https://github.com/jmbinger/BetterU","homepage":"","size":50,"stargazers_count":0,"watchers_count":0,"language":null,"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":"rmunz:master","ref":"master","sha":"9078101b90c6ac42ba86a67bce2d83cc3eab08e6","user":{"login":"rmunz","id":6867351,"avatar_url":"https://avatars.githubusercontent.com/u/6867351?v=3","gravatar_id":"","url":"https://api.github.com/users/rmunz","html_url":"https://github.com/rmunz","followers_url":"https://api.github.com/users/rmunz/followers","following_url":"https://api.github.com/users/rmunz/following{/other_user}","gists_url":"https://api.github.com/users/rmunz/gists{/gist_id}","starred_url":"https://api.github.com/users/rmunz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmunz/subscriptions","organizations_url":"https://api.github.com/users/rmunz/orgs","repos_url":"https://api.github.com/users/rmunz/repos","events_url":"https://api.github.com/users/rmunz/events{/privacy}","received_events_url":"https://api.github.com/users/rmunz/received_events","type":"User","site_admin":false},"repo":{"id":51302935,"name":"BetterU","full_name":"rmunz/BetterU","owner":{"login":"rmunz","id":6867351,"avatar_url":"https://avatars.githubusercontent.com/u/6867351?v=3","gravatar_id":"","url":"https://api.github.com/users/rmunz","html_url":"https://github.com/rmunz","followers_url":"https://api.github.com/users/rmunz/followers","following_url":"https://api.github.com/users/rmunz/following{/other_user}","gists_url":"https://api.github.com/users/rmunz/gists{/gist_id}","starred_url":"https://api.github.com/users/rmunz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmunz/subscriptions","organizations_url":"https://api.github.com/users/rmunz/orgs","repos_url":"https://api.github.com/users/rmunz/repos","events_url":"https://api.github.com/users/rmunz/events{/privacy}","received_events_url":"https://api.github.com/users/rmunz/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/rmunz/BetterU","description":"A Nutrition and Fitness App combined so that you can be you, but better.","fork":false,"url":"https://api.github.com/repos/rmunz/BetterU","forks_url":"https://api.github.com/repos/rmunz/BetterU/forks","keys_url":"https://api.github.com/repos/rmunz/BetterU/keys{/key_id}","collaborators_url":"https://api.github.com/repos/rmunz/BetterU/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/rmunz/BetterU/teams","hooks_url":"https://api.github.com/repos/rmunz/BetterU/hooks","issue_events_url":"https://api.github.com/repos/rmunz/BetterU/issues/events{/number}","events_url":"https://api.github.com/repos/rmunz/BetterU/events","assignees_url":"https://api.github.com/repos/rmunz/BetterU/assignees{/user}","branches_url":"https://api.github.com/repos/rmunz/BetterU/branches{/branch}","tags_url":"https://api.github.com/repos/rmunz/BetterU/tags","blobs_url":"https://api.github.com/repos/rmunz/BetterU/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/rmunz/BetterU/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/rmunz/BetterU/git/refs{/sha}","trees_url":"https://api.github.com/repos/rmunz/BetterU/git/trees{/sha}","statuses_url":"https://api.github.com/repos/rmunz/BetterU/statuses/{sha}","languages_url":"https://api.github.com/repos/rmunz/BetterU/languages","stargazers_url":"https://api.github.com/repos/rmunz/BetterU/stargazers","contributors_url":"https://api.github.com/repos/rmunz/BetterU/contributors","subscribers_url":"https://api.github.com/repos/rmunz/BetterU/subscribers","subscription_url":"https://api.github.com/repos/rmunz/BetterU/subscription","commits_url":"https://api.github.com/repos/rmunz/BetterU/commits{/sha}","git_commits_url":"https://api.github.com/repos/rmunz/BetterU/git/commits{/sha}","comments_url":"https://api.github.com/repos/rmunz/BetterU/comments{/number}","issue_comment_url":"https://api.github.com/repos/rmunz/BetterU/issues/comments{/number}","contents_url":"https://api.github.com/repos/rmunz/BetterU/contents/{+path}","compare_url":"https://api.github.com/repos/rmunz/BetterU/compare/{base}...{head}","merges_url":"https://api.github.com/repos/rmunz/BetterU/merges","archive_url":"https://api.github.com/repos/rmunz/BetterU/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/rmunz/BetterU/downloads","issues_url":"https://api.github.com/repos/rmunz/BetterU/issues{/number}","pulls_url":"https://api.github.com/repos/rmunz/BetterU/pulls{/number}","milestones_url":"https://api.github.com/repos/rmunz/BetterU/milestones{/number}","notifications_url":"https://api.github.com/repos/rmunz/BetterU/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/rmunz/BetterU/labels{/name}","releases_url":"https://api.github.com/repos/rmunz/BetterU/releases{/id}","deployments_url":"https://api.github.com/repos/rmunz/BetterU/deployments","created_at":"2016-02-08T14:35:13Z","updated_at":"2016-02-09T22:33:17Z","pushed_at":"2016-03-24T20:28:59Z","git_url":"git://github.com/rmunz/BetterU.git","ssh_url":"git@github.com:rmunz/BetterU.git","clone_url":"https://github.com/rmunz/BetterU.git","svn_url":"https://github.com/rmunz/BetterU","homepage":"","size":50,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":0,"forks":1,"open_issues":0,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/4"},"html":{"href":"https://github.com/rmunz/BetterU/pull/4"},"issue":{"href":"https://api.github.com/repos/rmunz/BetterU/issues/4"},"comments":{"href":"https://api.github.com/repos/rmunz/BetterU/issues/4/comments"},"review_comments":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/4/comments"},"review_comment":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/rmunz/BetterU/pulls/4/commits"},"statuses":{"href":"https://api.github.com/repos/rmunz/BetterU/statuses/7bbefba2b2854817cc9d70fc06dfffaeef5a3787"}}}}