92403f62ccb18b27867f9220c679b31e4336d8a6
fanhsu
  Mon Oct 25 15:13:52 2010 -0700
Checking in .sql for RGD Genes build.  Issue #29.
diff --git src/hg/lib/rgdGene2ToSymbol.sql src/hg/lib/rgdGene2ToSymbol.sql
new file mode 100644
index 0000000..86e02e4
--- /dev/null
+++ src/hg/lib/rgdGene2ToSymbol.sql
@@ -0,0 +1,10 @@
+CREATE TABLE rgdGene2ToSymbol (
+    rgdId  varchar(40)  not null,	# RGD Gene ID
+    rgdIdNum   varchar(40)  not null,	# RGD Gene Number
+    geneSymbol varchar(40) not null,	# UniProt Accession
+              #Indices
+    INDEX(rgdId(20)),
+    INDEX(rgdIdNum(20)),
+    INDEX(geneSymbol(20))
+
+);