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.c src/hg/lib/gtexSampleData.c
index 67a38ac..2a9d2be 100644
--- src/hg/lib/gtexSampleData.c
+++ src/hg/lib/gtexSampleData.c
@@ -137,19 +137,20 @@
 
 /* -------------------------------- End autoSql Generated Code -------------------------------- */
 
 void gtexSampleDataCreateTable(struct sqlConnection *conn, char *table)
 /* Create expression record format table of given name. */
 {
 char query[1024];
 
 sqlSafef(query, sizeof(query),
 "CREATE TABLE %s (\n"
 "    geneId varchar(255) not null,     # Gene identifier (ensembl)\n"
 "    sample varchar(255) not null,     # GTEx sample identifier\n"
 "    tissue varchar(255) not null,     # Tissue name\n"
 "    score float not null,	# Expression level (RPKM)\n"
 "              #Indices\n"
-"    PRIMARY KEY(geneId)\n"
+"    KEY(geneId),\n"
+"    KEY(tissue)\n"
 ")\n",   table);
 sqlRemakeTable(conn, table, query);
 }