59d2ffc93c4484c08d1a8746a94f97375eaa44e6
fanhsu
  Tue Sep 7 10:23:10 2010 -0700
Created several one shot programs and .sql files for the RGD Genes build pipeline
diff --git src/hg/lib/rgdGene2Xref.sql src/hg/lib/rgdGene2Xref.sql
new file mode 100644
index 0000000..bb53e13
--- /dev/null
+++ src/hg/lib/rgdGene2Xref.sql
@@ -0,0 +1,9 @@
+# A xref table for rgdGene2
+CREATE TABLE rgdGene2Xref (
+    rgdGeneId varchar(40) not null,	# RGD gene ID
+    infoType  varchar(40) not null,	# type of info for this record
+    info blob ,				# actual info
+
+    key rgdGene(rgdGeneId),
+    key info(info(20))
+);