{"action":"created","comment":{"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/comments/40020286","id":40020286,"diff_hunk":"@@ -0,0 +1,17 @@\n+// this exercise reflected the data model shown in schema/addressbook_denormalized.png within database decodemtl_addressbook\n+\n+/* it returned:\n+mysql> CREATE TABLE Account \n+    -> (id INT, email VARCHAR(255), password VARCHAR(40), createdOn DATETIME, modifiedON DATETIME);\n+Query OK, 0 rows affected (0.09 sec)\n+\n+mysql> CREATE TABLE AddressBook\n+    -> (id INT, accountId INT, name VARCHAR(255), createdOn DATETIME, modifiedON DATETIME);\n+Query OK, 0 rows affected (0.03 sec)\n+\n+mysql> CREATE TABLE Entry\n+    -> (id INT, addressBookId INT, firstName VARCHAR(255), lastName VARCHAR(255), birthday DATETIME, type ENUM(\"home\", \"work\", \"other\"), subtype ENUM(\"phone\", \"address\", \"email\"), contentLineOne VARCHAR(255), contentLineTwo VARCHAR(255), contentLineThree VARCHAR(255), contentLineFour VARCHAR(255), ContentLineFive VARCHAR(255));                                                                                             \n+Query OK, 0 rows affected (0.03 sec)\n+\n+*/","path":"exercise-8.txt","position":16,"original_position":16,"commit_id":"1955bff5960312c30e2d29acf28aa54d2682d10c","original_commit_id":"1955bff5960312c30e2d29acf28aa54d2682d10c","user":{"login":"nyanofthemoon","id":3919995,"avatar_url":"https://avatars.githubusercontent.com/u/3919995?v=3","gravatar_id":"","url":"https://api.github.com/users/nyanofthemoon","html_url":"https://github.com/nyanofthemoon","followers_url":"https://api.github.com/users/nyanofthemoon/followers","following_url":"https://api.github.com/users/nyanofthemoon/following{/other_user}","gists_url":"https://api.github.com/users/nyanofthemoon/gists{/gist_id}","starred_url":"https://api.github.com/users/nyanofthemoon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyanofthemoon/subscriptions","organizations_url":"https://api.github.com/users/nyanofthemoon/orgs","repos_url":"https://api.github.com/users/nyanofthemoon/repos","events_url":"https://api.github.com/users/nyanofthemoon/events{/privacy}","received_events_url":"https://api.github.com/users/nyanofthemoon/received_events","type":"User","site_admin":false},"body":"Please make sure that Account.id, AddressBook.id and Entry.id is a PRIMARY KEY with attribute AUTO_INCREMENT.","created_at":"2015-09-21T20:18:46Z","updated_at":"2015-09-21T20:18:46Z","html_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77#discussion_r40020286","pull_request_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77","_links":{"self":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/comments/40020286"},"html":{"href":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77#discussion_r40020286"},"pull_request":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77"}}},"pull_request":{"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77","id":45593817,"html_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77","diff_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77.diff","patch_url":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77.patch","issue_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/77","number":77,"state":"open","locked":false,"title":"ex. 8 - reflected the data model","user":{"login":"lolaolah","id":13394757,"avatar_url":"https://avatars.githubusercontent.com/u/13394757?v=3","gravatar_id":"","url":"https://api.github.com/users/lolaolah","html_url":"https://github.com/lolaolah","followers_url":"https://api.github.com/users/lolaolah/followers","following_url":"https://api.github.com/users/lolaolah/following{/other_user}","gists_url":"https://api.github.com/users/lolaolah/gists{/gist_id}","starred_url":"https://api.github.com/users/lolaolah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lolaolah/subscriptions","organizations_url":"https://api.github.com/users/lolaolah/orgs","repos_url":"https://api.github.com/users/lolaolah/repos","events_url":"https://api.github.com/users/lolaolah/events{/privacy}","received_events_url":"https://api.github.com/users/lolaolah/received_events","type":"User","site_admin":false},"body":"bonjour","created_at":"2015-09-21T20:11:52Z","updated_at":"2015-09-21T20:18:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":"456ce9cb20c02e3e4def5d20ebc735aa49c62c8a","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77/commits","review_comments_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77/comments","review_comment_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/comments{/number}","comments_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/77/comments","statuses_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/statuses/1955bff5960312c30e2d29acf28aa54d2682d10c","head":{"label":"lolaolah:exercise-8","ref":"exercise-8","sha":"1955bff5960312c30e2d29acf28aa54d2682d10c","user":{"login":"lolaolah","id":13394757,"avatar_url":"https://avatars.githubusercontent.com/u/13394757?v=3","gravatar_id":"","url":"https://api.github.com/users/lolaolah","html_url":"https://github.com/lolaolah","followers_url":"https://api.github.com/users/lolaolah/followers","following_url":"https://api.github.com/users/lolaolah/following{/other_user}","gists_url":"https://api.github.com/users/lolaolah/gists{/gist_id}","starred_url":"https://api.github.com/users/lolaolah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lolaolah/subscriptions","organizations_url":"https://api.github.com/users/lolaolah/orgs","repos_url":"https://api.github.com/users/lolaolah/repos","events_url":"https://api.github.com/users/lolaolah/events{/privacy}","received_events_url":"https://api.github.com/users/lolaolah/received_events","type":"User","site_admin":false},"repo":{"id":42870177,"name":"mysql-workshop-1","full_name":"lolaolah/mysql-workshop-1","owner":{"login":"lolaolah","id":13394757,"avatar_url":"https://avatars.githubusercontent.com/u/13394757?v=3","gravatar_id":"","url":"https://api.github.com/users/lolaolah","html_url":"https://github.com/lolaolah","followers_url":"https://api.github.com/users/lolaolah/followers","following_url":"https://api.github.com/users/lolaolah/following{/other_user}","gists_url":"https://api.github.com/users/lolaolah/gists{/gist_id}","starred_url":"https://api.github.com/users/lolaolah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lolaolah/subscriptions","organizations_url":"https://api.github.com/users/lolaolah/orgs","repos_url":"https://api.github.com/users/lolaolah/repos","events_url":"https://api.github.com/users/lolaolah/events{/privacy}","received_events_url":"https://api.github.com/users/lolaolah/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lolaolah/mysql-workshop-1","description":"","fork":true,"url":"https://api.github.com/repos/lolaolah/mysql-workshop-1","forks_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/forks","keys_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/teams","hooks_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/hooks","issue_events_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/issues/events{/number}","events_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/events","assignees_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/assignees{/user}","branches_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/branches{/branch}","tags_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/tags","blobs_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/git/refs{/sha}","trees_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/statuses/{sha}","languages_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/languages","stargazers_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/stargazers","contributors_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/contributors","subscribers_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/subscribers","subscription_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/subscription","commits_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/commits{/sha}","git_commits_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/git/commits{/sha}","comments_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/comments{/number}","issue_comment_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/issues/comments{/number}","contents_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/contents/{+path}","compare_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/merges","archive_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/downloads","issues_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/issues{/number}","pulls_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/pulls{/number}","milestones_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/milestones{/number}","notifications_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/labels{/name}","releases_url":"https://api.github.com/repos/lolaolah/mysql-workshop-1/releases{/id}","created_at":"2015-09-21T14:10:11Z","updated_at":"2015-09-20T11:45:36Z","pushed_at":"2015-09-21T20:11:06Z","git_url":"git://github.com/lolaolah/mysql-workshop-1.git","ssh_url":"git@github.com:lolaolah/mysql-workshop-1.git","clone_url":"https://github.com/lolaolah/mysql-workshop-1.git","svn_url":"https://github.com/lolaolah/mysql-workshop-1","homepage":null,"size":151,"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":"DecodeMTL:master","ref":"master","sha":"2239d021e1196bd55ddf931a017f9890692cddfc","user":{"login":"DecodeMTL","id":14301039,"avatar_url":"https://avatars.githubusercontent.com/u/14301039?v=3","gravatar_id":"","url":"https://api.github.com/users/DecodeMTL","html_url":"https://github.com/DecodeMTL","followers_url":"https://api.github.com/users/DecodeMTL/followers","following_url":"https://api.github.com/users/DecodeMTL/following{/other_user}","gists_url":"https://api.github.com/users/DecodeMTL/gists{/gist_id}","starred_url":"https://api.github.com/users/DecodeMTL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DecodeMTL/subscriptions","organizations_url":"https://api.github.com/users/DecodeMTL/orgs","repos_url":"https://api.github.com/users/DecodeMTL/repos","events_url":"https://api.github.com/users/DecodeMTL/events{/privacy}","received_events_url":"https://api.github.com/users/DecodeMTL/received_events","type":"Organization","site_admin":false},"repo":{"id":42811007,"name":"mysql-workshop-1","full_name":"DecodeMTL/mysql-workshop-1","owner":{"login":"DecodeMTL","id":14301039,"avatar_url":"https://avatars.githubusercontent.com/u/14301039?v=3","gravatar_id":"","url":"https://api.github.com/users/DecodeMTL","html_url":"https://github.com/DecodeMTL","followers_url":"https://api.github.com/users/DecodeMTL/followers","following_url":"https://api.github.com/users/DecodeMTL/following{/other_user}","gists_url":"https://api.github.com/users/DecodeMTL/gists{/gist_id}","starred_url":"https://api.github.com/users/DecodeMTL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DecodeMTL/subscriptions","organizations_url":"https://api.github.com/users/DecodeMTL/orgs","repos_url":"https://api.github.com/users/DecodeMTL/repos","events_url":"https://api.github.com/users/DecodeMTL/events{/privacy}","received_events_url":"https://api.github.com/users/DecodeMTL/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/DecodeMTL/mysql-workshop-1","description":"","fork":false,"url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1","forks_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/forks","keys_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/teams","hooks_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/hooks","issue_events_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/events{/number}","events_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/events","assignees_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/assignees{/user}","branches_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/branches{/branch}","tags_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/tags","blobs_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/git/refs{/sha}","trees_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/statuses/{sha}","languages_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/languages","stargazers_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/stargazers","contributors_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/contributors","subscribers_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/subscribers","subscription_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/subscription","commits_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/commits{/sha}","git_commits_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/git/commits{/sha}","comments_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/comments{/number}","issue_comment_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/comments{/number}","contents_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/contents/{+path}","compare_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/merges","archive_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/downloads","issues_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues{/number}","pulls_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls{/number}","milestones_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/milestones{/number}","notifications_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/labels{/name}","releases_url":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/releases{/id}","created_at":"2015-09-20T11:45:36Z","updated_at":"2015-09-20T11:45:36Z","pushed_at":"2015-09-21T20:11:52Z","git_url":"git://github.com/DecodeMTL/mysql-workshop-1.git","ssh_url":"git@github.com:DecodeMTL/mysql-workshop-1.git","clone_url":"https://github.com/DecodeMTL/mysql-workshop-1.git","svn_url":"https://github.com/DecodeMTL/mysql-workshop-1","homepage":null,"size":1797,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":12,"mirror_url":null,"open_issues_count":33,"forks":12,"open_issues":33,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77"},"html":{"href":"https://github.com/DecodeMTL/mysql-workshop-1/pull/77"},"issue":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/77"},"comments":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/issues/77/comments"},"review_comments":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77/comments"},"review_comment":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/pulls/77/commits"},"statuses":{"href":"https://api.github.com/repos/DecodeMTL/mysql-workshop-1/statuses/1955bff5960312c30e2d29acf28aa54d2682d10c"}}}}