dd63b063d251d10c234c7d2c3d73d78d2e291ecd
cline
  Tue Jan 24 12:24:29 2012 -0800
Addressing code review feedback - thanks, Braney!  Restored some lost indices, and expanded two description lines slightly
diff --git src/hg/lib/kgXref.sql src/hg/lib/kgXref.sql
index b8f0638..a6ca9bf 100644
--- src/hg/lib/kgXref.sql
+++ src/hg/lib/kgXref.sql
@@ -1,20 +1,28 @@
 # kgXref.sql was originally generated by the autoSql program, which also 
 # generated kgXref.c and kgXref.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # 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,	# UniProt protein Accession number
     spDisplayID varchar(255) not null,	# UniProt 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)
 );