3a63c684fc647b345d52e96147b3344453b3d28a
kate
  Fri Jul 31 10:12:14 2015 -0700
1. Fix tissue ordering problem (hgGtex). 2. Add stats table (rename gtexTissueData to gtexTissueMedian and use gtexTissueData for stats.  3. Extend gtexInfo table.refs #15645

diff --git src/hg/lib/gtexSampleData.sql src/hg/lib/gtexSampleData.sql
index 2c97493..4a3ec98 100644
--- src/hg/lib/gtexSampleData.sql
+++ src/hg/lib/gtexSampleData.sql
@@ -1,15 +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
-    KEY(geneId),
-    KEY(tissue)
+    INDEX(geneId),
+    INDEX(tissue)
 );