43131e22c1124612275ed6a49fed2caad4389be5
cline
  Wed Sep 14 15:19:48 2011 -0700
Added an rfam accession field to the end of the kgXref table
diff --git src/hg/lib/kgXref.sql src/hg/lib/kgXref.sql
index 738f78c..f8db7f8 100644
--- src/hg/lib/kgXref.sql
+++ src/hg/lib/kgXref.sql
@@ -1,24 +1,19 @@
 # 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(40) not null,	# Known Gene ID
-    mRNA varchar(40),		# mRNA ID
-    spID varchar(40),		# SWISS-PROT protein Accession number
-    spDisplayID varchar(40),	# SWISS-PROT display ID
-    geneSymbol varchar(40),	# Gene Symbol
-    refseq varchar(40),		# RefSeq ID
-    protAcc varchar(40),	# NCBI protein Accession number
+    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
               #Indices
-    KEY(kgID),
-    KEY(mRNA),
-    KEY(spID),
-    KEY(spDisplayID),
-    KEY(geneSymbol),
-    KEY(refseq),
-    KEY(protAcc)
+    PRIMARY KEY(kgID)
 );