cfb63bd22072217bc504665d8abeb5f81587c8d7 hiram Thu Sep 15 18:09:14 2016 -0700 better to call chromXref as chromAlias and now is a three column table with primary key refs #18027 diff --git src/hg/lib/chromXref.sql src/hg/lib/chromXref.sql deleted file mode 100644 index 4a9572a..0000000 --- src/hg/lib/chromXref.sql +++ /dev/null @@ -1,17 +0,0 @@ -# chromXref.sql was originally generated by the autoSql program, which also -# generated chromXref.c and chromXref.h. This creates the database representation of -# an object which can be loaded and saved from RAM in a fairly -# automatic way. - -#correspondence of UCSC chromosome names to refseq, genbank, and ensembl names -CREATE TABLE chromXref ( - ucsc varchar(255) not null, # UCSC genome browser chromosome name - refseq varchar(255) not null, # RefSeq assembly accession (n/a when not available) - genbank varchar(255) not null, # Genbank assembly accession (n/a when not available) - ensembl varchar(255) not null, # Ensembl chromosome name (n/a when not available) - #Indices - PRIMARY KEY(ucsc), - KEY(refseq), - KEY(genbank), - KEY(ensembl) -);