afa4cc7f36a1d3d5c2e4dc4f20fbf6332a4258a3
hiram
  Thu Sep 15 11:28:56 2016 -0700
allow chrom name lookup to use the new chromXref table refs #18027

diff --git src/hg/lib/chromXref.sql src/hg/lib/chromXref.sql
new file mode 100644
index 0000000..4a9572a
--- /dev/null
+++ src/hg/lib/chromXref.sql
@@ -0,0 +1,17 @@
+# 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)
+);