{"action":"created","comment":{"url":"https://api.github.com/repos/BOINC/boinc/pulls/comments/217743296","pull_request_review_id":155535422,"id":217743296,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxNzc0MzI5Ng==","diff_hunk":"@@ -0,0 +1,9 @@\n+/*\n+    This file contants inital content for any tables.\n+\n+    The table must be first defined in schema.sql before any content\n+    is added!\n+*/\n+insert into consent_type (id, shortname, description, enabled, protect, privacypref)\n+    values (1, 'ENROLL', 'General terms-of-use for this BOINC project.', 0, 1, 0),\n+    (2, 'STATSEXPORT', 'Do you consent to exporting your data to BOINC statistics aggregation Web sites?', 0, 1, 1);","path":"db/content.sql","position":9,"original_position":9,"commit_id":"7bf7d5c0a05111632f5d8c6105d4234d069d6d83","original_commit_id":"7bf7d5c0a05111632f5d8c6105d4234d069d6d83","user":{"login":"TheAspens","id":22824141,"node_id":"MDQ6VXNlcjIyODI0MTQx","avatar_url":"https://avatars0.githubusercontent.com/u/22824141?v=4","gravatar_id":"","url":"https://api.github.com/users/TheAspens","html_url":"https://github.com/TheAspens","followers_url":"https://api.github.com/users/TheAspens/followers","following_url":"https://api.github.com/users/TheAspens/following{/other_user}","gists_url":"https://api.github.com/users/TheAspens/gists{/gist_id}","starred_url":"https://api.github.com/users/TheAspens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TheAspens/subscriptions","organizations_url":"https://api.github.com/users/TheAspens/orgs","repos_url":"https://api.github.com/users/TheAspens/repos","events_url":"https://api.github.com/users/TheAspens/events{/privacy}","received_events_url":"https://api.github.com/users/TheAspens/received_events","type":"User","site_admin":false},"body":"Since consent_type.id is auto-increment and you are intentionally not tying specific values of consent_type.id to behavior in the application, then you should not specify the value for the id on the insert.  \r\n\r\n```\r\ninsert into consent_type (shortname, description, enabled, protect, privacypref)\r\n    values ('ENROLL', 'General terms-of-use for this BOINC project.', 0, 1, 0),\r\n    ('STATSEXPORT', 'Do you consent to exporting your data to BOINC statistics aggregation Web sites?', 0, 1, 1);\r\n```","created_at":"2018-09-14T15:01:27Z","updated_at":"2018-09-14T15:01:27Z","html_url":"https://github.com/BOINC/boinc/pull/2504#discussion_r217743296","pull_request_url":"https://api.github.com/repos/BOINC/boinc/pulls/2504","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/comments/217743296"},"html":{"href":"https://github.com/BOINC/boinc/pull/2504#discussion_r217743296"},"pull_request":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/2504"}}},"pull_request":{"url":"https://api.github.com/repos/BOINC/boinc/pulls/2504","id":186129207,"node_id":"MDExOlB1bGxSZXF1ZXN0MTg2MTI5MjA3","html_url":"https://github.com/BOINC/boinc/pull/2504","diff_url":"https://github.com/BOINC/boinc/pull/2504.diff","patch_url":"https://github.com/BOINC/boinc/pull/2504.patch","issue_url":"https://api.github.com/repos/BOINC/boinc/issues/2504","number":2504,"state":"open","locked":false,"title":"User Opt-in consent","user":{"login":"drshawnkwang","id":18352107,"node_id":"MDQ6VXNlcjE4MzUyMTA3","avatar_url":"https://avatars3.githubusercontent.com/u/18352107?v=4","gravatar_id":"","url":"https://api.github.com/users/drshawnkwang","html_url":"https://github.com/drshawnkwang","followers_url":"https://api.github.com/users/drshawnkwang/followers","following_url":"https://api.github.com/users/drshawnkwang/following{/other_user}","gists_url":"https://api.github.com/users/drshawnkwang/gists{/gist_id}","starred_url":"https://api.github.com/users/drshawnkwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drshawnkwang/subscriptions","organizations_url":"https://api.github.com/users/drshawnkwang/orgs","repos_url":"https://api.github.com/users/drshawnkwang/repos","events_url":"https://api.github.com/users/drshawnkwang/events{/privacy}","received_events_url":"https://api.github.com/users/drshawnkwang/received_events","type":"User","site_admin":false},"body":"Resolves GDPR User Opt-in Consent #2413.\r\n\r\nThis is a work in progress (WIP) merge. I wish to allow people to review what I have done and comment on it. As of this initial PR the following features are present.\r\n\r\n1. New `consent` and `consent_type` tables which record a user's consent.\r\n1. Web form now has terms of use (terms_of_use.txt) file which forces users to opt-in.\r\n1. `create_account` and `am_set_info` RPCs modified to record consent.\r\n1. HTML Ops page added for admin to manage `consent_type` table.","created_at":"2018-05-05T00:22:55Z","updated_at":"2018-09-14T15:01:27Z","closed_at":null,"merged_at":null,"merge_commit_sha":"df8845d792a4731f5c808ca61df18bb4a7e37ef8","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/BOINC/boinc/pulls/2504/commits","review_comments_url":"https://api.github.com/repos/BOINC/boinc/pulls/2504/comments","review_comment_url":"https://api.github.com/repos/BOINC/boinc/pulls/comments{/number}","comments_url":"https://api.github.com/repos/BOINC/boinc/issues/2504/comments","statuses_url":"https://api.github.com/repos/BOINC/boinc/statuses/7bf7d5c0a05111632f5d8c6105d4234d069d6d83","head":{"label":"drshawnkwang:sak-useroptin-dbaddconsent","ref":"sak-useroptin-dbaddconsent","sha":"7bf7d5c0a05111632f5d8c6105d4234d069d6d83","user":{"login":"drshawnkwang","id":18352107,"node_id":"MDQ6VXNlcjE4MzUyMTA3","avatar_url":"https://avatars3.githubusercontent.com/u/18352107?v=4","gravatar_id":"","url":"https://api.github.com/users/drshawnkwang","html_url":"https://github.com/drshawnkwang","followers_url":"https://api.github.com/users/drshawnkwang/followers","following_url":"https://api.github.com/users/drshawnkwang/following{/other_user}","gists_url":"https://api.github.com/users/drshawnkwang/gists{/gist_id}","starred_url":"https://api.github.com/users/drshawnkwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drshawnkwang/subscriptions","organizations_url":"https://api.github.com/users/drshawnkwang/orgs","repos_url":"https://api.github.com/users/drshawnkwang/repos","events_url":"https://api.github.com/users/drshawnkwang/events{/privacy}","received_events_url":"https://api.github.com/users/drshawnkwang/received_events","type":"User","site_admin":false},"repo":{"id":56350695,"node_id":"MDEwOlJlcG9zaXRvcnk1NjM1MDY5NQ==","name":"boinc","full_name":"drshawnkwang/boinc","owner":{"login":"drshawnkwang","id":18352107,"node_id":"MDQ6VXNlcjE4MzUyMTA3","avatar_url":"https://avatars3.githubusercontent.com/u/18352107?v=4","gravatar_id":"","url":"https://api.github.com/users/drshawnkwang","html_url":"https://github.com/drshawnkwang","followers_url":"https://api.github.com/users/drshawnkwang/followers","following_url":"https://api.github.com/users/drshawnkwang/following{/other_user}","gists_url":"https://api.github.com/users/drshawnkwang/gists{/gist_id}","starred_url":"https://api.github.com/users/drshawnkwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drshawnkwang/subscriptions","organizations_url":"https://api.github.com/users/drshawnkwang/orgs","repos_url":"https://api.github.com/users/drshawnkwang/repos","events_url":"https://api.github.com/users/drshawnkwang/events{/privacy}","received_events_url":"https://api.github.com/users/drshawnkwang/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/drshawnkwang/boinc","description":"Open-source software for volunteer computing and grid computing.","fork":true,"url":"https://api.github.com/repos/drshawnkwang/boinc","forks_url":"https://api.github.com/repos/drshawnkwang/boinc/forks","keys_url":"https://api.github.com/repos/drshawnkwang/boinc/keys{/key_id}","collaborators_url":"https://api.github.com/repos/drshawnkwang/boinc/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/drshawnkwang/boinc/teams","hooks_url":"https://api.github.com/repos/drshawnkwang/boinc/hooks","issue_events_url":"https://api.github.com/repos/drshawnkwang/boinc/issues/events{/number}","events_url":"https://api.github.com/repos/drshawnkwang/boinc/events","assignees_url":"https://api.github.com/repos/drshawnkwang/boinc/assignees{/user}","branches_url":"https://api.github.com/repos/drshawnkwang/boinc/branches{/branch}","tags_url":"https://api.github.com/repos/drshawnkwang/boinc/tags","blobs_url":"https://api.github.com/repos/drshawnkwang/boinc/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/drshawnkwang/boinc/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/drshawnkwang/boinc/git/refs{/sha}","trees_url":"https://api.github.com/repos/drshawnkwang/boinc/git/trees{/sha}","statuses_url":"https://api.github.com/repos/drshawnkwang/boinc/statuses/{sha}","languages_url":"https://api.github.com/repos/drshawnkwang/boinc/languages","stargazers_url":"https://api.github.com/repos/drshawnkwang/boinc/stargazers","contributors_url":"https://api.github.com/repos/drshawnkwang/boinc/contributors","subscribers_url":"https://api.github.com/repos/drshawnkwang/boinc/subscribers","subscription_url":"https://api.github.com/repos/drshawnkwang/boinc/subscription","commits_url":"https://api.github.com/repos/drshawnkwang/boinc/commits{/sha}","git_commits_url":"https://api.github.com/repos/drshawnkwang/boinc/git/commits{/sha}","comments_url":"https://api.github.com/repos/drshawnkwang/boinc/comments{/number}","issue_comment_url":"https://api.github.com/repos/drshawnkwang/boinc/issues/comments{/number}","contents_url":"https://api.github.com/repos/drshawnkwang/boinc/contents/{+path}","compare_url":"https://api.github.com/repos/drshawnkwang/boinc/compare/{base}...{head}","merges_url":"https://api.github.com/repos/drshawnkwang/boinc/merges","archive_url":"https://api.github.com/repos/drshawnkwang/boinc/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/drshawnkwang/boinc/downloads","issues_url":"https://api.github.com/repos/drshawnkwang/boinc/issues{/number}","pulls_url":"https://api.github.com/repos/drshawnkwang/boinc/pulls{/number}","milestones_url":"https://api.github.com/repos/drshawnkwang/boinc/milestones{/number}","notifications_url":"https://api.github.com/repos/drshawnkwang/boinc/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/drshawnkwang/boinc/labels{/name}","releases_url":"https://api.github.com/repos/drshawnkwang/boinc/releases{/id}","deployments_url":"https://api.github.com/repos/drshawnkwang/boinc/deployments","created_at":"2016-04-15T21:25:43Z","updated_at":"2018-09-14T13:06:06Z","pushed_at":"2018-09-14T13:06:03Z","git_url":"git://github.com/drshawnkwang/boinc.git","ssh_url":"git@github.com:drshawnkwang/boinc.git","clone_url":"https://github.com/drshawnkwang/boinc.git","svn_url":"https://github.com/drshawnkwang/boinc","homepage":"http://boinc.berkeley.edu","size":217122,"stargazers_count":1,"watchers_count":1,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":1,"default_branch":"master"}},"base":{"label":"BOINC:master","ref":"master","sha":"5a42f595cbb3e337863bee9395143b90e2690f37","user":{"login":"BOINC","id":985688,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NTY4OA==","avatar_url":"https://avatars3.githubusercontent.com/u/985688?v=4","gravatar_id":"","url":"https://api.github.com/users/BOINC","html_url":"https://github.com/BOINC","followers_url":"https://api.github.com/users/BOINC/followers","following_url":"https://api.github.com/users/BOINC/following{/other_user}","gists_url":"https://api.github.com/users/BOINC/gists{/gist_id}","starred_url":"https://api.github.com/users/BOINC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BOINC/subscriptions","organizations_url":"https://api.github.com/users/BOINC/orgs","repos_url":"https://api.github.com/users/BOINC/repos","events_url":"https://api.github.com/users/BOINC/events{/privacy}","received_events_url":"https://api.github.com/users/BOINC/received_events","type":"Organization","site_admin":false},"repo":{"id":30260406,"node_id":"MDEwOlJlcG9zaXRvcnkzMDI2MDQwNg==","name":"boinc","full_name":"BOINC/boinc","owner":{"login":"BOINC","id":985688,"node_id":"MDEyOk9yZ2FuaXphdGlvbjk4NTY4OA==","avatar_url":"https://avatars3.githubusercontent.com/u/985688?v=4","gravatar_id":"","url":"https://api.github.com/users/BOINC","html_url":"https://github.com/BOINC","followers_url":"https://api.github.com/users/BOINC/followers","following_url":"https://api.github.com/users/BOINC/following{/other_user}","gists_url":"https://api.github.com/users/BOINC/gists{/gist_id}","starred_url":"https://api.github.com/users/BOINC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BOINC/subscriptions","organizations_url":"https://api.github.com/users/BOINC/orgs","repos_url":"https://api.github.com/users/BOINC/repos","events_url":"https://api.github.com/users/BOINC/events{/privacy}","received_events_url":"https://api.github.com/users/BOINC/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/BOINC/boinc","description":"Open-source software for volunteer computing and grid computing.","fork":false,"url":"https://api.github.com/repos/BOINC/boinc","forks_url":"https://api.github.com/repos/BOINC/boinc/forks","keys_url":"https://api.github.com/repos/BOINC/boinc/keys{/key_id}","collaborators_url":"https://api.github.com/repos/BOINC/boinc/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/BOINC/boinc/teams","hooks_url":"https://api.github.com/repos/BOINC/boinc/hooks","issue_events_url":"https://api.github.com/repos/BOINC/boinc/issues/events{/number}","events_url":"https://api.github.com/repos/BOINC/boinc/events","assignees_url":"https://api.github.com/repos/BOINC/boinc/assignees{/user}","branches_url":"https://api.github.com/repos/BOINC/boinc/branches{/branch}","tags_url":"https://api.github.com/repos/BOINC/boinc/tags","blobs_url":"https://api.github.com/repos/BOINC/boinc/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/BOINC/boinc/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/BOINC/boinc/git/refs{/sha}","trees_url":"https://api.github.com/repos/BOINC/boinc/git/trees{/sha}","statuses_url":"https://api.github.com/repos/BOINC/boinc/statuses/{sha}","languages_url":"https://api.github.com/repos/BOINC/boinc/languages","stargazers_url":"https://api.github.com/repos/BOINC/boinc/stargazers","contributors_url":"https://api.github.com/repos/BOINC/boinc/contributors","subscribers_url":"https://api.github.com/repos/BOINC/boinc/subscribers","subscription_url":"https://api.github.com/repos/BOINC/boinc/subscription","commits_url":"https://api.github.com/repos/BOINC/boinc/commits{/sha}","git_commits_url":"https://api.github.com/repos/BOINC/boinc/git/commits{/sha}","comments_url":"https://api.github.com/repos/BOINC/boinc/comments{/number}","issue_comment_url":"https://api.github.com/repos/BOINC/boinc/issues/comments{/number}","contents_url":"https://api.github.com/repos/BOINC/boinc/contents/{+path}","compare_url":"https://api.github.com/repos/BOINC/boinc/compare/{base}...{head}","merges_url":"https://api.github.com/repos/BOINC/boinc/merges","archive_url":"https://api.github.com/repos/BOINC/boinc/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/BOINC/boinc/downloads","issues_url":"https://api.github.com/repos/BOINC/boinc/issues{/number}","pulls_url":"https://api.github.com/repos/BOINC/boinc/pulls{/number}","milestones_url":"https://api.github.com/repos/BOINC/boinc/milestones{/number}","notifications_url":"https://api.github.com/repos/BOINC/boinc/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/BOINC/boinc/labels{/name}","releases_url":"https://api.github.com/repos/BOINC/boinc/releases{/id}","deployments_url":"https://api.github.com/repos/BOINC/boinc/deployments","created_at":"2015-02-03T19:28:28Z","updated_at":"2018-09-13T14:21:56Z","pushed_at":"2018-09-13T19:18:31Z","git_url":"git://github.com/BOINC/boinc.git","ssh_url":"git@github.com:BOINC/boinc.git","clone_url":"https://github.com/BOINC/boinc.git","svn_url":"https://github.com/BOINC/boinc","homepage":"https://boinc.berkeley.edu","size":219120,"stargazers_count":723,"watchers_count":723,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":231,"mirror_url":null,"archived":false,"open_issues_count":468,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":231,"open_issues":468,"watchers":723,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/2504"},"html":{"href":"https://github.com/BOINC/boinc/pull/2504"},"issue":{"href":"https://api.github.com/repos/BOINC/boinc/issues/2504"},"comments":{"href":"https://api.github.com/repos/BOINC/boinc/issues/2504/comments"},"review_comments":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/2504/comments"},"review_comment":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/BOINC/boinc/pulls/2504/commits"},"statuses":{"href":"https://api.github.com/repos/BOINC/boinc/statuses/7bf7d5c0a05111632f5d8c6105d4234d069d6d83"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"TheAspens"}}