f9e3913d0a717429adb9e7ce395a80886e1253f0 chinhli Fri Sep 23 09:33:55 2011 -0700 Finished geneReviews for hg19 and hg18 diff --git src/hg/lib/geneReviewsRefGene.sql src/hg/lib/geneReviewsRefGene.sql new file mode 100644 index 0000000..6e81c87 --- /dev/null +++ src/hg/lib/geneReviewsRefGene.sql @@ -0,0 +1,7 @@ +CREATE TABLE geneReviewsRefGene ( + geneSymbol varchar(255) not null, # refSeq gene symbol + grShort varchar(255) not null, # short name for GeneReviews article + diseaseID int unsigned not null, # Disease ID of the review article + diseaseName varchar(255) not null, # Disease name of the review article + index (geneSymbol) +);