{"action":"created","comment":{"url":"https://api.github.com/repos/aces/Loris/pulls/comments/217001046","pull_request_review_id":154611180,"id":217001046,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxNzAwMTA0Ng==","diff_hunk":"@@ -18,8 +18,8 @@ CREATE TABLE `physiological_output_type` (\n -- Create a physiological_file table\n CREATE TABLE `physiological_file` (\n   `PhysiologicalFileID`       INT(10)    UNSIGNED  NOT NULL      AUTO_INCREMENT,\n-  `PhysiologicalModalityID`   TINYINT(3) UNSIGNED  DEFAULT NULL,\n-  `Caveat`                    TINYINT(1) UNSIGNED  DEFAULT 0,\n+  `PhysiologicalModalityID`   INT(5)     UNSIGNED  DEFAULT NULL,\n+  `Caveat`                    INT(5)     UNSIGNED  DEFAULT 0,","path":"SQL/New_patches/2018-09-07_EEG_tables.sql","position":null,"original_position":7,"commit_id":"3fa11375b964f2b01bc40be6239c103f54b7baa9","original_commit_id":"3fa11375b964f2b01bc40be6239c103f54b7baa9","user":{"login":"PapillonMcGill","id":34311645,"node_id":"MDQ6VXNlcjM0MzExNjQ1","avatar_url":"https://avatars0.githubusercontent.com/u/34311645?v=4","gravatar_id":"","url":"https://api.github.com/users/PapillonMcGill","html_url":"https://github.com/PapillonMcGill","followers_url":"https://api.github.com/users/PapillonMcGill/followers","following_url":"https://api.github.com/users/PapillonMcGill/following{/other_user}","gists_url":"https://api.github.com/users/PapillonMcGill/gists{/gist_id}","starred_url":"https://api.github.com/users/PapillonMcGill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PapillonMcGill/subscriptions","organizations_url":"https://api.github.com/users/PapillonMcGill/orgs","repos_url":"https://api.github.com/users/PapillonMcGill/repos","events_url":"https://api.github.com/users/PapillonMcGill/events{/privacy}","received_events_url":"https://api.github.com/users/PapillonMcGill/received_events","type":"User","site_admin":false},"body":"Is this a yes/no field?","created_at":"2018-09-12T11:59:04Z","updated_at":"2018-09-12T11:59:04Z","html_url":"https://github.com/aces/Loris/pull/3941#discussion_r217001046","pull_request_url":"https://api.github.com/repos/aces/Loris/pulls/3941","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/aces/Loris/pulls/comments/217001046"},"html":{"href":"https://github.com/aces/Loris/pull/3941#discussion_r217001046"},"pull_request":{"href":"https://api.github.com/repos/aces/Loris/pulls/3941"}}},"pull_request":{"url":"https://api.github.com/repos/aces/Loris/pulls/3941","id":214011004,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE0MDExMDA0","html_url":"https://github.com/aces/Loris/pull/3941","diff_url":"https://github.com/aces/Loris/pull/3941.diff","patch_url":"https://github.com/aces/Loris/pull/3941.patch","issue_url":"https://api.github.com/repos/aces/Loris/issues/3941","number":3941,"state":"open","locked":false,"title":"[New Feature] Adding the SQL patch for the EEG tables","user":{"login":"cmadjar","id":1402456,"node_id":"MDQ6VXNlcjE0MDI0NTY=","avatar_url":"https://avatars0.githubusercontent.com/u/1402456?v=4","gravatar_id":"","url":"https://api.github.com/users/cmadjar","html_url":"https://github.com/cmadjar","followers_url":"https://api.github.com/users/cmadjar/followers","following_url":"https://api.github.com/users/cmadjar/following{/other_user}","gists_url":"https://api.github.com/users/cmadjar/gists{/gist_id}","starred_url":"https://api.github.com/users/cmadjar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmadjar/subscriptions","organizations_url":"https://api.github.com/users/cmadjar/orgs","repos_url":"https://api.github.com/users/cmadjar/repos","events_url":"https://api.github.com/users/cmadjar/events{/privacy}","received_events_url":"https://api.github.com/users/cmadjar/received_events","type":"User","site_admin":false},"body":"### Brief summary of changes\r\n\r\nThis PR includes the SQL patch to be run to create the EEG tables for the insertion scripts of the LORIS-MRI. Note that these tables will be used by the new Electrophysiology Browser module that will be in a separate PR.\r\n\r\nThis PR goes hand in hand with the following LORIS-MRI PR: https://github.com/aces/Loris-MRI/pull/337\r\n\r\nFor people that are visual, here is a screenshot summarizing the table structure for the EEG tables:\r\n\r\n![overall_view](https://user-images.githubusercontent.com/1402456/45237607-2edb2400-b2ad-11e8-9293-4534f4107423.png)\r\n\r\n\r\n### This resolves issue...\r\n\r\n- [ ] Redmine? https://redmine.cbrain.mcgill.ca/issues/13603\r\n\r\n\r\n### To test this change...\r\n\r\n- Run the SQL patch and makes sure all statements work properly\r\n- If you have an empty database, run the default schema with the new changes to make sure all statements work properly\r\n- Feel free to make sure that the tables follow the LORIS SQL standard (crossing my fingers that I did not omit anything there!)","created_at":"2018-09-07T18:51:25Z","updated_at":"2018-09-12T11:59:04Z","closed_at":null,"merged_at":null,"merge_commit_sha":"e784ea193c5563b11f76d53d843cbbfc36a07e72","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":152299721,"node_id":"MDU6TGFiZWwxNTIyOTk3MjE=","url":"https://api.github.com/repos/aces/Loris/labels/Add%20to%20Release%20Notes","name":"Add to Release Notes","color":"66ff66","default":false},{"id":520487238,"node_id":"MDU6TGFiZWw1MjA0ODcyMzg=","url":"https://api.github.com/repos/aces/Loris/labels/Blocked","name":"Blocked","color":"000000","default":false},{"id":152305520,"node_id":"MDU6TGFiZWwxNTIzMDU1MjA=","url":"https://api.github.com/repos/aces/Loris/labels/Feature","name":"Feature","color":"1d76db","default":false},{"id":153844577,"node_id":"MDU6TGFiZWwxNTM4NDQ1Nzc=","url":"https://api.github.com/repos/aces/Loris/labels/SQL","name":"SQL","color":"bfe5bf","default":false},{"id":708895955,"node_id":"MDU6TGFiZWw3MDg4OTU5NTU=","url":"https://api.github.com/repos/aces/Loris/labels/[branch]%20minor","name":"[branch] minor","color":"996633","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/aces/Loris/pulls/3941/commits","review_comments_url":"https://api.github.com/repos/aces/Loris/pulls/3941/comments","review_comment_url":"https://api.github.com/repos/aces/Loris/pulls/comments{/number}","comments_url":"https://api.github.com/repos/aces/Loris/issues/3941/comments","statuses_url":"https://api.github.com/repos/aces/Loris/statuses/3fa11375b964f2b01bc40be6239c103f54b7baa9","head":{"label":"cmadjar:EEG_SQL_tables_minor","ref":"EEG_SQL_tables_minor","sha":"3fa11375b964f2b01bc40be6239c103f54b7baa9","user":{"login":"cmadjar","id":1402456,"node_id":"MDQ6VXNlcjE0MDI0NTY=","avatar_url":"https://avatars0.githubusercontent.com/u/1402456?v=4","gravatar_id":"","url":"https://api.github.com/users/cmadjar","html_url":"https://github.com/cmadjar","followers_url":"https://api.github.com/users/cmadjar/followers","following_url":"https://api.github.com/users/cmadjar/following{/other_user}","gists_url":"https://api.github.com/users/cmadjar/gists{/gist_id}","starred_url":"https://api.github.com/users/cmadjar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmadjar/subscriptions","organizations_url":"https://api.github.com/users/cmadjar/orgs","repos_url":"https://api.github.com/users/cmadjar/repos","events_url":"https://api.github.com/users/cmadjar/events{/privacy}","received_events_url":"https://api.github.com/users/cmadjar/received_events","type":"User","site_admin":false},"repo":{"id":25689182,"node_id":"MDEwOlJlcG9zaXRvcnkyNTY4OTE4Mg==","name":"Loris","full_name":"cmadjar/Loris","owner":{"login":"cmadjar","id":1402456,"node_id":"MDQ6VXNlcjE0MDI0NTY=","avatar_url":"https://avatars0.githubusercontent.com/u/1402456?v=4","gravatar_id":"","url":"https://api.github.com/users/cmadjar","html_url":"https://github.com/cmadjar","followers_url":"https://api.github.com/users/cmadjar/followers","following_url":"https://api.github.com/users/cmadjar/following{/other_user}","gists_url":"https://api.github.com/users/cmadjar/gists{/gist_id}","starred_url":"https://api.github.com/users/cmadjar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmadjar/subscriptions","organizations_url":"https://api.github.com/users/cmadjar/orgs","repos_url":"https://api.github.com/users/cmadjar/repos","events_url":"https://api.github.com/users/cmadjar/events{/privacy}","received_events_url":"https://api.github.com/users/cmadjar/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cmadjar/Loris","description":"LORIS (Longitudinal Online Research and Imaging System) is a web-accessible database solution for neuroimaging.","fork":true,"url":"https://api.github.com/repos/cmadjar/Loris","forks_url":"https://api.github.com/repos/cmadjar/Loris/forks","keys_url":"https://api.github.com/repos/cmadjar/Loris/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cmadjar/Loris/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cmadjar/Loris/teams","hooks_url":"https://api.github.com/repos/cmadjar/Loris/hooks","issue_events_url":"https://api.github.com/repos/cmadjar/Loris/issues/events{/number}","events_url":"https://api.github.com/repos/cmadjar/Loris/events","assignees_url":"https://api.github.com/repos/cmadjar/Loris/assignees{/user}","branches_url":"https://api.github.com/repos/cmadjar/Loris/branches{/branch}","tags_url":"https://api.github.com/repos/cmadjar/Loris/tags","blobs_url":"https://api.github.com/repos/cmadjar/Loris/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cmadjar/Loris/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cmadjar/Loris/git/refs{/sha}","trees_url":"https://api.github.com/repos/cmadjar/Loris/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cmadjar/Loris/statuses/{sha}","languages_url":"https://api.github.com/repos/cmadjar/Loris/languages","stargazers_url":"https://api.github.com/repos/cmadjar/Loris/stargazers","contributors_url":"https://api.github.com/repos/cmadjar/Loris/contributors","subscribers_url":"https://api.github.com/repos/cmadjar/Loris/subscribers","subscription_url":"https://api.github.com/repos/cmadjar/Loris/subscription","commits_url":"https://api.github.com/repos/cmadjar/Loris/commits{/sha}","git_commits_url":"https://api.github.com/repos/cmadjar/Loris/git/commits{/sha}","comments_url":"https://api.github.com/repos/cmadjar/Loris/comments{/number}","issue_comment_url":"https://api.github.com/repos/cmadjar/Loris/issues/comments{/number}","contents_url":"https://api.github.com/repos/cmadjar/Loris/contents/{+path}","compare_url":"https://api.github.com/repos/cmadjar/Loris/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cmadjar/Loris/merges","archive_url":"https://api.github.com/repos/cmadjar/Loris/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cmadjar/Loris/downloads","issues_url":"https://api.github.com/repos/cmadjar/Loris/issues{/number}","pulls_url":"https://api.github.com/repos/cmadjar/Loris/pulls{/number}","milestones_url":"https://api.github.com/repos/cmadjar/Loris/milestones{/number}","notifications_url":"https://api.github.com/repos/cmadjar/Loris/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cmadjar/Loris/labels{/name}","releases_url":"https://api.github.com/repos/cmadjar/Loris/releases{/id}","deployments_url":"https://api.github.com/repos/cmadjar/Loris/deployments","created_at":"2014-10-24T13:13:07Z","updated_at":"2017-11-23T21:24:10Z","pushed_at":"2018-09-11T17:03:25Z","git_url":"git://github.com/cmadjar/Loris.git","ssh_url":"git@github.com:cmadjar/Loris.git","clone_url":"https://github.com/cmadjar/Loris.git","svn_url":"https://github.com/cmadjar/Loris","homepage":"","size":76108,"stargazers_count":0,"watchers_count":0,"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":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"aces:minor","ref":"minor","sha":"f13716b825d409daf6fff5b63652c9f9824c3f6c","user":{"login":"aces","id":472868,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQ3Mjg2OA==","avatar_url":"https://avatars2.githubusercontent.com/u/472868?v=4","gravatar_id":"","url":"https://api.github.com/users/aces","html_url":"https://github.com/aces","followers_url":"https://api.github.com/users/aces/followers","following_url":"https://api.github.com/users/aces/following{/other_user}","gists_url":"https://api.github.com/users/aces/gists{/gist_id}","starred_url":"https://api.github.com/users/aces/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aces/subscriptions","organizations_url":"https://api.github.com/users/aces/orgs","repos_url":"https://api.github.com/users/aces/repos","events_url":"https://api.github.com/users/aces/events{/privacy}","received_events_url":"https://api.github.com/users/aces/received_events","type":"Organization","site_admin":false},"repo":{"id":1125630,"node_id":"MDEwOlJlcG9zaXRvcnkxMTI1NjMw","name":"Loris","full_name":"aces/Loris","owner":{"login":"aces","id":472868,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQ3Mjg2OA==","avatar_url":"https://avatars2.githubusercontent.com/u/472868?v=4","gravatar_id":"","url":"https://api.github.com/users/aces","html_url":"https://github.com/aces","followers_url":"https://api.github.com/users/aces/followers","following_url":"https://api.github.com/users/aces/following{/other_user}","gists_url":"https://api.github.com/users/aces/gists{/gist_id}","starred_url":"https://api.github.com/users/aces/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aces/subscriptions","organizations_url":"https://api.github.com/users/aces/orgs","repos_url":"https://api.github.com/users/aces/repos","events_url":"https://api.github.com/users/aces/events{/privacy}","received_events_url":"https://api.github.com/users/aces/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/aces/Loris","description":"LORIS is a web-accessible database solution for longitudinal multi-site studies.","fork":false,"url":"https://api.github.com/repos/aces/Loris","forks_url":"https://api.github.com/repos/aces/Loris/forks","keys_url":"https://api.github.com/repos/aces/Loris/keys{/key_id}","collaborators_url":"https://api.github.com/repos/aces/Loris/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/aces/Loris/teams","hooks_url":"https://api.github.com/repos/aces/Loris/hooks","issue_events_url":"https://api.github.com/repos/aces/Loris/issues/events{/number}","events_url":"https://api.github.com/repos/aces/Loris/events","assignees_url":"https://api.github.com/repos/aces/Loris/assignees{/user}","branches_url":"https://api.github.com/repos/aces/Loris/branches{/branch}","tags_url":"https://api.github.com/repos/aces/Loris/tags","blobs_url":"https://api.github.com/repos/aces/Loris/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/aces/Loris/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/aces/Loris/git/refs{/sha}","trees_url":"https://api.github.com/repos/aces/Loris/git/trees{/sha}","statuses_url":"https://api.github.com/repos/aces/Loris/statuses/{sha}","languages_url":"https://api.github.com/repos/aces/Loris/languages","stargazers_url":"https://api.github.com/repos/aces/Loris/stargazers","contributors_url":"https://api.github.com/repos/aces/Loris/contributors","subscribers_url":"https://api.github.com/repos/aces/Loris/subscribers","subscription_url":"https://api.github.com/repos/aces/Loris/subscription","commits_url":"https://api.github.com/repos/aces/Loris/commits{/sha}","git_commits_url":"https://api.github.com/repos/aces/Loris/git/commits{/sha}","comments_url":"https://api.github.com/repos/aces/Loris/comments{/number}","issue_comment_url":"https://api.github.com/repos/aces/Loris/issues/comments{/number}","contents_url":"https://api.github.com/repos/aces/Loris/contents/{+path}","compare_url":"https://api.github.com/repos/aces/Loris/compare/{base}...{head}","merges_url":"https://api.github.com/repos/aces/Loris/merges","archive_url":"https://api.github.com/repos/aces/Loris/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/aces/Loris/downloads","issues_url":"https://api.github.com/repos/aces/Loris/issues{/number}","pulls_url":"https://api.github.com/repos/aces/Loris/pulls{/number}","milestones_url":"https://api.github.com/repos/aces/Loris/milestones{/number}","notifications_url":"https://api.github.com/repos/aces/Loris/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/aces/Loris/labels{/name}","releases_url":"https://api.github.com/repos/aces/Loris/releases{/id}","deployments_url":"https://api.github.com/repos/aces/Loris/deployments","created_at":"2010-11-30T14:57:57Z","updated_at":"2018-09-10T16:59:32Z","pushed_at":"2018-09-11T23:42:16Z","git_url":"git://github.com/aces/Loris.git","ssh_url":"git@github.com:aces/Loris.git","clone_url":"https://github.com/aces/Loris.git","svn_url":"https://github.com/aces/Loris","homepage":"","size":76646,"stargazers_count":65,"watchers_count":65,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":95,"mirror_url":null,"archived":false,"open_issues_count":95,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":95,"open_issues":95,"watchers":65,"default_branch":"minor"}},"_links":{"self":{"href":"https://api.github.com/repos/aces/Loris/pulls/3941"},"html":{"href":"https://github.com/aces/Loris/pull/3941"},"issue":{"href":"https://api.github.com/repos/aces/Loris/issues/3941"},"comments":{"href":"https://api.github.com/repos/aces/Loris/issues/3941/comments"},"review_comments":{"href":"https://api.github.com/repos/aces/Loris/pulls/3941/comments"},"review_comment":{"href":"https://api.github.com/repos/aces/Loris/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/aces/Loris/pulls/3941/commits"},"statuses":{"href":"https://api.github.com/repos/aces/Loris/statuses/3fa11375b964f2b01bc40be6239c103f54b7baa9"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"PapillonMcGill"}}