f622bbdea8672e46c060d95d699a5a38c8d6212d
cline
  Mon Sep 26 13:52:23 2011 -0700
Replaced key declarations that had been lost when I added the tRNA and rfam fields
diff --git src/hg/lib/kgXref.sql src/hg/lib/kgXref.sql
index 4d32dc8..af4ae95 100644
--- src/hg/lib/kgXref.sql
+++ src/hg/lib/kgXref.sql
@@ -4,17 +4,25 @@
 # automatic way.
 
 #Link together a Known Gene ID and a gene alias
 CREATE TABLE kgXref (
     kgID varchar(255) not null,	# Known Gene ID
     mRNA varchar(255) not null,	# mRNA ID
     spID varchar(255) not null,	# SWISS-PROT protein Accession number
     spDisplayID varchar(255) not null,	# SWISS-PROT display ID
     geneSymbol varchar(255) not null,	# Gene Symbol
     refseq varchar(255) not null,	# RefSeq ID
     protAcc varchar(255) not null,	# NCBI protein Accession number
     description longblob not null,	# Description
     rfamAcc varchar(255) not null,	# Rfam accession number
     tRnaName varchar(255) not null,	# Name from the tRNA track
               #Indices
-    PRIMARY KEY(kgID)
+    KEY(kgID),
+    KEY(mRNA),
+    KEY(spID),
+    KEY(spDisplayID),
+    KEY(geneSymbol),
+    KEY(refseq),
+    KEY(protAcc),
+    KEY(rfamAcc),
+    KEY(tRnaName)
 );