07769f5e62216c125dc90df08dac7a90402c3fa4 markd Mon Jun 22 12:54:40 2015 -0700 add geneId to transmap gene table, with backwards compatibilty for current transmap tracks (RM 14574) diff --git src/hg/lib/transMapGene.sql src/hg/lib/transMapGene.sql index a87d5b2..ce1cc4a 100644 --- src/hg/lib/transMapGene.sql +++ src/hg/lib/transMapGene.sql @@ -1,15 +1,15 @@ # transMapGene.sql was originally generated by the autoSql program, which also # generated transMapGene.c and transMapGene.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. -#shared, gene-specific transMap information. This is also a cdsSpec object +#shared, gene-specific transMap information. This is also a cds specification CREATE TABLE transMapGene ( - id varchar(255) not null, # unique sequence id + id varchar(255) not null, # unique transcript id cds varchar(255) not null, # CDS specification, in NCBI format. db char(16) not null, # source db geneName varchar(255) not null, # gene name + geneId varchar(255) not null, # database-specific gene id #Indices - PRIMARY KEY(db,id), - INDEX(id) + PRIMARY KEY(id) );