c0a00fe92704046502a278f29fc49cdacf331163
kate
  Thu Aug 14 11:07:00 2014 -0700
Add gtexDonor table.  Fix some table loading problems. refs #13504
diff --git src/hg/lib/gtexSampleData.sql src/hg/lib/gtexSampleData.sql
index 1f8a0dd..2c97493 100644
--- src/hg/lib/gtexSampleData.sql
+++ src/hg/lib/gtexSampleData.sql
@@ -1,14 +1,15 @@
 # gtexSampleData.sql was originally generated by the autoSql program, which also 
 # generated gtexSampleData.c and gtexSampleData.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #GTEX Expression data (RPKM levels, unmapped)
 CREATE TABLE gtexSampleData (
     geneId varchar(255) not null,	# Gene identifier (ensembl)
     sample varchar(255) not null,	# GTEX sample identifier
     tissue varchar(255) not null,	# Tissue short name
     score float not null,	# Expression level (RPKM)
               #Indices
-    PRIMARY KEY(geneId)
+    KEY(geneId),
+    KEY(tissue)
 );