{"action":"created","comment":{"url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/comments/103222440","pull_request_review_id":24002112,"id":103222440,"diff_hunk":"@@ -207,6 +213,53 @@ CREATE TABLE `gene_alias` (\n );\n \n -- --------------------------------------------------------\n+CREATE TABLE `geneset` (\n+  `ID` INT(11) NOT NULL auto_increment,\n+  `GENETIC_ENTITY_ID` INT NOT NULL,\n+  `EXTERNAL_ID` VARCHAR(100) NOT NULL,\n+  `NAME` VARCHAR(100) NOT NULL,\n+  `DESCRIPTION` VARCHAR(300) NOT NULL,\n+  `REF_LINK` TEXT,\n+  PRIMARY KEY (`ID`),\n+  UNIQUE INDEX `NAME_UNIQUE` (`NAME` ASC),\n+  UNIQUE INDEX `EXTERNAL_ID_COLL_UNIQUE` (`EXTERNAL_ID` ASC),\n+  UNIQUE INDEX `GENESET_GENETIC_ENTITY_ID_UNIQUE` (`GENETIC_ENTITY_ID` ASC),\n+  FOREIGN KEY (`GENETIC_ENTITY_ID`) REFERENCES `genetic_entity` (`ID`) ON DELETE CASCADE\n+);\n+\n+-- --------------------------------------------------------\n+CREATE TABLE `geneset_gene` (\n+  `GENESET_ID` INT(11) NOT NULL,\n+  `ENTREZ_GENE_ID` INT(11) NOT NULL,\n+  PRIMARY KEY (`GENESET_ID`, `ENTREZ_GENE_ID`),\n+  FOREIGN KEY (`ENTREZ_GENE_ID`) REFERENCES `gene` (`ENTREZ_GENE_ID`) ON DELETE CASCADE,\n+  FOREIGN KEY (`GENESET_ID`) REFERENCES `geneset` (`ID`) ON DELETE CASCADE\n+);\n+\n+-- --------------------------------------------------------\n+CREATE TABLE `geneset_hierarchy` (\n+  `NODE_ID` BIGINT(20) NOT NULL auto_increment,\n+  `NODE_NAME` VARCHAR(200) NOT NULL,\n+  `PARENT_ID` BIGINT NULL DEFAULT NULL,\n+  PRIMARY KEY (`NODE_ID`),\n+  UNIQUE INDEX `NODE_NAME_UNIQUE` (`NODE_NAME` ASC, `PARENT_ID` ASC)\n+);\n+\n+-- --------------------------------------------------------\n+CREATE TABLE `geneset_hierarchy_leaf` (\n+  `NODE_ID` BIGINT NOT NULL,\n+  `GENESET_ID` INT NOT NULL,\n+  PRIMARY KEY (`NODE_ID`, `GENESET_ID`),\n+  FOREIGN KEY (`NODE_ID`) REFERENCES `geneset_hierarchy` (`NODE_ID`) ON DELETE CASCADE,\n+  FOREIGN KEY (`GENESET_ID`) REFERENCES `geneset` (`ID`) ON DELETE CASCADE\n+);\n+\n+-- --------------------------------------------------------\n+CREATE TABLE `geneset_info` (","path":"db-scripts/src/main/resources/cgds.sql","position":70,"original_position":70,"commit_id":"a9841699a82311b6fc4fc4ec62473e9c3e91042d","original_commit_id":"a9841699a82311b6fc4fc4ec62473e9c3e91042d","user":{"login":"ersinciftci","id":3595704,"avatar_url":"https://avatars.githubusercontent.com/u/3595704?v=3","gravatar_id":"","url":"https://api.github.com/users/ersinciftci","html_url":"https://github.com/ersinciftci","followers_url":"https://api.github.com/users/ersinciftci/followers","following_url":"https://api.github.com/users/ersinciftci/following{/other_user}","gists_url":"https://api.github.com/users/ersinciftci/gists{/gist_id}","starred_url":"https://api.github.com/users/ersinciftci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ersinciftci/subscriptions","organizations_url":"https://api.github.com/users/ersinciftci/orgs","repos_url":"https://api.github.com/users/ersinciftci/repos","events_url":"https://api.github.com/users/ersinciftci/events{/privacy}","received_events_url":"https://api.github.com/users/ersinciftci/received_events","type":"User","site_admin":false},"body":"Instead of adding a new table for this, maybe we can add another column to `info` table, called `GENESET_VERSION`?","created_at":"2017-02-27T14:51:05Z","updated_at":"2017-02-27T14:51:05Z","html_url":"https://github.com/cBioPortal/cbioportal/pull/2155#discussion_r103222440","pull_request_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155","_links":{"self":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/comments/103222440"},"html":{"href":"https://github.com/cBioPortal/cbioportal/pull/2155#discussion_r103222440"},"pull_request":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155"}}},"pull_request":{"url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155","id":107827649,"html_url":"https://github.com/cBioPortal/cbioportal/pull/2155","diff_url":"https://github.com/cBioPortal/cbioportal/pull/2155.diff","patch_url":"https://github.com/cBioPortal/cbioportal/pull/2155.patch","issue_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/2155","number":2155,"state":"open","locked":false,"title":"Geneset related tables","user":{"login":"pieterlukasse","id":2900303,"avatar_url":"https://avatars.githubusercontent.com/u/2900303?v=3","gravatar_id":"","url":"https://api.github.com/users/pieterlukasse","html_url":"https://github.com/pieterlukasse","followers_url":"https://api.github.com/users/pieterlukasse/followers","following_url":"https://api.github.com/users/pieterlukasse/following{/other_user}","gists_url":"https://api.github.com/users/pieterlukasse/gists{/gist_id}","starred_url":"https://api.github.com/users/pieterlukasse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pieterlukasse/subscriptions","organizations_url":"https://api.github.com/users/pieterlukasse/orgs","repos_url":"https://api.github.com/users/pieterlukasse/repos","events_url":"https://api.github.com/users/pieterlukasse/events{/privacy}","received_events_url":"https://api.github.com/users/pieterlukasse/received_events","type":"User","site_admin":false},"body":"# What? Why?\r\nThis PR introduces the DB `geneset*` tables needed to support the GSVA part. \r\n\r\nChanges proposed in this pull request:\r\n- new `geneset*` tables (5 in total)\r\n- new `genetic_profile_link` table to keep track of the relation between GSVA-SCORE and GSVA P-VALUE profiles (score and p-value are stored in separate profiles)\r\n- small related change in DaoCancerStudy.deleteCancerStudy\r\n\r\n# Notify reviewers\r\n@n1zea144 : part of this has been reviewed and tested by @angelicaochoa before. Maybe @angelicaochoa can review this one as well? \r\n\r\n","created_at":"2017-02-24T13:19:06Z","updated_at":"2017-02-27T14:51:05Z","closed_at":null,"merged_at":null,"merge_commit_sha":"623c5e5f58b1fe4189689dc3fd9a578460942b08","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155/commits","review_comments_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155/comments","review_comment_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/2155/comments","statuses_url":"https://api.github.com/repos/cBioPortal/cbioportal/statuses/a9841699a82311b6fc4fc4ec62473e9c3e91042d","head":{"label":"cBioPortal:geneset_backend","ref":"geneset_backend","sha":"a9841699a82311b6fc4fc4ec62473e9c3e91042d","user":{"login":"cBioPortal","id":9876251,"avatar_url":"https://avatars.githubusercontent.com/u/9876251?v=3","gravatar_id":"","url":"https://api.github.com/users/cBioPortal","html_url":"https://github.com/cBioPortal","followers_url":"https://api.github.com/users/cBioPortal/followers","following_url":"https://api.github.com/users/cBioPortal/following{/other_user}","gists_url":"https://api.github.com/users/cBioPortal/gists{/gist_id}","starred_url":"https://api.github.com/users/cBioPortal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cBioPortal/subscriptions","organizations_url":"https://api.github.com/users/cBioPortal/orgs","repos_url":"https://api.github.com/users/cBioPortal/repos","events_url":"https://api.github.com/users/cBioPortal/events{/privacy}","received_events_url":"https://api.github.com/users/cBioPortal/received_events","type":"Organization","site_admin":false},"repo":{"id":32481543,"name":"cbioportal","full_name":"cBioPortal/cbioportal","owner":{"login":"cBioPortal","id":9876251,"avatar_url":"https://avatars.githubusercontent.com/u/9876251?v=3","gravatar_id":"","url":"https://api.github.com/users/cBioPortal","html_url":"https://github.com/cBioPortal","followers_url":"https://api.github.com/users/cBioPortal/followers","following_url":"https://api.github.com/users/cBioPortal/following{/other_user}","gists_url":"https://api.github.com/users/cBioPortal/gists{/gist_id}","starred_url":"https://api.github.com/users/cBioPortal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cBioPortal/subscriptions","organizations_url":"https://api.github.com/users/cBioPortal/orgs","repos_url":"https://api.github.com/users/cBioPortal/repos","events_url":"https://api.github.com/users/cBioPortal/events{/privacy}","received_events_url":"https://api.github.com/users/cBioPortal/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cBioPortal/cbioportal","description":"cBioPortal for Cancer Genomics","fork":false,"url":"https://api.github.com/repos/cBioPortal/cbioportal","forks_url":"https://api.github.com/repos/cBioPortal/cbioportal/forks","keys_url":"https://api.github.com/repos/cBioPortal/cbioportal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cBioPortal/cbioportal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cBioPortal/cbioportal/teams","hooks_url":"https://api.github.com/repos/cBioPortal/cbioportal/hooks","issue_events_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/events{/number}","events_url":"https://api.github.com/repos/cBioPortal/cbioportal/events","assignees_url":"https://api.github.com/repos/cBioPortal/cbioportal/assignees{/user}","branches_url":"https://api.github.com/repos/cBioPortal/cbioportal/branches{/branch}","tags_url":"https://api.github.com/repos/cBioPortal/cbioportal/tags","blobs_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/refs{/sha}","trees_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cBioPortal/cbioportal/statuses/{sha}","languages_url":"https://api.github.com/repos/cBioPortal/cbioportal/languages","stargazers_url":"https://api.github.com/repos/cBioPortal/cbioportal/stargazers","contributors_url":"https://api.github.com/repos/cBioPortal/cbioportal/contributors","subscribers_url":"https://api.github.com/repos/cBioPortal/cbioportal/subscribers","subscription_url":"https://api.github.com/repos/cBioPortal/cbioportal/subscription","commits_url":"https://api.github.com/repos/cBioPortal/cbioportal/commits{/sha}","git_commits_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/commits{/sha}","comments_url":"https://api.github.com/repos/cBioPortal/cbioportal/comments{/number}","issue_comment_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/comments{/number}","contents_url":"https://api.github.com/repos/cBioPortal/cbioportal/contents/{+path}","compare_url":"https://api.github.com/repos/cBioPortal/cbioportal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cBioPortal/cbioportal/merges","archive_url":"https://api.github.com/repos/cBioPortal/cbioportal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cBioPortal/cbioportal/downloads","issues_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues{/number}","pulls_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls{/number}","milestones_url":"https://api.github.com/repos/cBioPortal/cbioportal/milestones{/number}","notifications_url":"https://api.github.com/repos/cBioPortal/cbioportal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cBioPortal/cbioportal/labels{/name}","releases_url":"https://api.github.com/repos/cBioPortal/cbioportal/releases{/id}","deployments_url":"https://api.github.com/repos/cBioPortal/cbioportal/deployments","created_at":"2015-03-18T20:09:09Z","updated_at":"2017-02-07T17:12:05Z","pushed_at":"2017-02-27T13:32:08Z","git_url":"git://github.com/cBioPortal/cbioportal.git","ssh_url":"git@github.com:cBioPortal/cbioportal.git","clone_url":"https://github.com/cBioPortal/cbioportal.git","svn_url":"https://github.com/cBioPortal/cbioportal","homepage":"http://cbioportal.org","size":192555,"stargazers_count":89,"watchers_count":89,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":122,"mirror_url":null,"open_issues_count":365,"forks":122,"open_issues":365,"watchers":89,"default_branch":"master"}},"base":{"label":"cBioPortal:geneset","ref":"geneset","sha":"f38114c07e91bbe9912acdfc75371c30011601e6","user":{"login":"cBioPortal","id":9876251,"avatar_url":"https://avatars.githubusercontent.com/u/9876251?v=3","gravatar_id":"","url":"https://api.github.com/users/cBioPortal","html_url":"https://github.com/cBioPortal","followers_url":"https://api.github.com/users/cBioPortal/followers","following_url":"https://api.github.com/users/cBioPortal/following{/other_user}","gists_url":"https://api.github.com/users/cBioPortal/gists{/gist_id}","starred_url":"https://api.github.com/users/cBioPortal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cBioPortal/subscriptions","organizations_url":"https://api.github.com/users/cBioPortal/orgs","repos_url":"https://api.github.com/users/cBioPortal/repos","events_url":"https://api.github.com/users/cBioPortal/events{/privacy}","received_events_url":"https://api.github.com/users/cBioPortal/received_events","type":"Organization","site_admin":false},"repo":{"id":32481543,"name":"cbioportal","full_name":"cBioPortal/cbioportal","owner":{"login":"cBioPortal","id":9876251,"avatar_url":"https://avatars.githubusercontent.com/u/9876251?v=3","gravatar_id":"","url":"https://api.github.com/users/cBioPortal","html_url":"https://github.com/cBioPortal","followers_url":"https://api.github.com/users/cBioPortal/followers","following_url":"https://api.github.com/users/cBioPortal/following{/other_user}","gists_url":"https://api.github.com/users/cBioPortal/gists{/gist_id}","starred_url":"https://api.github.com/users/cBioPortal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cBioPortal/subscriptions","organizations_url":"https://api.github.com/users/cBioPortal/orgs","repos_url":"https://api.github.com/users/cBioPortal/repos","events_url":"https://api.github.com/users/cBioPortal/events{/privacy}","received_events_url":"https://api.github.com/users/cBioPortal/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/cBioPortal/cbioportal","description":"cBioPortal for Cancer Genomics","fork":false,"url":"https://api.github.com/repos/cBioPortal/cbioportal","forks_url":"https://api.github.com/repos/cBioPortal/cbioportal/forks","keys_url":"https://api.github.com/repos/cBioPortal/cbioportal/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cBioPortal/cbioportal/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cBioPortal/cbioportal/teams","hooks_url":"https://api.github.com/repos/cBioPortal/cbioportal/hooks","issue_events_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/events{/number}","events_url":"https://api.github.com/repos/cBioPortal/cbioportal/events","assignees_url":"https://api.github.com/repos/cBioPortal/cbioportal/assignees{/user}","branches_url":"https://api.github.com/repos/cBioPortal/cbioportal/branches{/branch}","tags_url":"https://api.github.com/repos/cBioPortal/cbioportal/tags","blobs_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/refs{/sha}","trees_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cBioPortal/cbioportal/statuses/{sha}","languages_url":"https://api.github.com/repos/cBioPortal/cbioportal/languages","stargazers_url":"https://api.github.com/repos/cBioPortal/cbioportal/stargazers","contributors_url":"https://api.github.com/repos/cBioPortal/cbioportal/contributors","subscribers_url":"https://api.github.com/repos/cBioPortal/cbioportal/subscribers","subscription_url":"https://api.github.com/repos/cBioPortal/cbioportal/subscription","commits_url":"https://api.github.com/repos/cBioPortal/cbioportal/commits{/sha}","git_commits_url":"https://api.github.com/repos/cBioPortal/cbioportal/git/commits{/sha}","comments_url":"https://api.github.com/repos/cBioPortal/cbioportal/comments{/number}","issue_comment_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues/comments{/number}","contents_url":"https://api.github.com/repos/cBioPortal/cbioportal/contents/{+path}","compare_url":"https://api.github.com/repos/cBioPortal/cbioportal/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cBioPortal/cbioportal/merges","archive_url":"https://api.github.com/repos/cBioPortal/cbioportal/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cBioPortal/cbioportal/downloads","issues_url":"https://api.github.com/repos/cBioPortal/cbioportal/issues{/number}","pulls_url":"https://api.github.com/repos/cBioPortal/cbioportal/pulls{/number}","milestones_url":"https://api.github.com/repos/cBioPortal/cbioportal/milestones{/number}","notifications_url":"https://api.github.com/repos/cBioPortal/cbioportal/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cBioPortal/cbioportal/labels{/name}","releases_url":"https://api.github.com/repos/cBioPortal/cbioportal/releases{/id}","deployments_url":"https://api.github.com/repos/cBioPortal/cbioportal/deployments","created_at":"2015-03-18T20:09:09Z","updated_at":"2017-02-07T17:12:05Z","pushed_at":"2017-02-27T13:32:08Z","git_url":"git://github.com/cBioPortal/cbioportal.git","ssh_url":"git@github.com:cBioPortal/cbioportal.git","clone_url":"https://github.com/cBioPortal/cbioportal.git","svn_url":"https://github.com/cBioPortal/cbioportal","homepage":"http://cbioportal.org","size":192555,"stargazers_count":89,"watchers_count":89,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":122,"mirror_url":null,"open_issues_count":365,"forks":122,"open_issues":365,"watchers":89,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155"},"html":{"href":"https://github.com/cBioPortal/cbioportal/pull/2155"},"issue":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/issues/2155"},"comments":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/issues/2155/comments"},"review_comments":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155/comments"},"review_comment":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/pulls/2155/commits"},"statuses":{"href":"https://api.github.com/repos/cBioPortal/cbioportal/statuses/a9841699a82311b6fc4fc4ec62473e9c3e91042d"}}}}
{"actor":{"display_login":"ersinciftci"}}