4dc00f5856bc269c7fec878e93b210d7b885866a braney Fri Mar 2 16:13:52 2012 -0800 more changes to otto-mate the OMIM load (#6943) diff --git src/hg/lib/omim2gene.sql src/hg/lib/omim2gene.sql new file mode 100644 index 0000000..84dda3d --- /dev/null +++ src/hg/lib/omim2gene.sql @@ -0,0 +1,15 @@ +# omim2gene.sql was originally generated by the autoSql program, which also +# generated omim2gene.c and omim2gene.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#OMIM omim2gene +CREATE TABLE omim2gene ( + omimId int unsigned not null, # MIM ID + entryType varchar(40), # entry type (gene or phenotype) + geneId int unsigned, # ENTREZ gene ID + approvedGeneSymbol varchar(40), # Approved Gene Symbol + #Indices + KEY `omimId` (`omimId`), + KEY `geneId` (`geneId`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1;