5ea9a903ac0263e771e77c7edf14eb64a7e1a7f8 hiram Wed Feb 22 11:55:41 2012 -0800 only need the .as file, not the .sql file diff --git src/hg/lib/kgXrefPrevious.sql src/hg/lib/kgXrefPrevious.sql deleted file mode 100644 index 187fcb0..0000000 --- src/hg/lib/kgXrefPrevious.sql +++ /dev/null @@ -1,22 +0,0 @@ -# this is a copy from kgXref.sql to supply a description for the rn4 -# table kgXrefPrevious - -#Link together a Known Gene ID and a gene alias -CREATE TABLE kgXrefPrevious ( - kgID varchar(40) not null, # Known Gene ID - mRNA varchar(40), # mRNA ID - spID varchar(40), # UniProt protein Accession number - spDisplayID varchar(40), # UniProt display ID - geneSymbol varchar(40), # Gene Symbol - refseq varchar(40), # RefSeq ID - protAcc varchar(40), # NCBI protein Accession number - description varchar(255), # Description - #Indices - KEY(kgID), - KEY(mRNA), - KEY(spID), - KEY(spDisplayID), - KEY(geneSymbol), - KEY(refseq), - KEY(protAcc), -);