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/chromAlias.sql src/hg/lib/chromAlias.sql
new file mode 100644
index 0000000..8ae256c
--- /dev/null
+++ src/hg/lib/chromAlias.sql
@@ -0,0 +1,15 @@
+# chromAlias.sql was originally generated by the autoSql program, which also 
+# generated chromAlias.c and chromAlias.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 chromAlias (
+    alias varchar(255) not null,	# external name
+    chrom varchar(255) not null,	# UCSC genome browser chromosome name
+    source varchar(255) not null,	# comma separated list, when available: refseq,genbank,ensembl
+              #Indices
+    PRIMARY KEY(alias),
+    KEY(chrom),
+    KEY(source)
+);