965d1048e8671fb3a5630fe75deb88f24df386d7
kate
  Wed Aug 13 15:01:59 2014 -0700
Expand schema for GTex.  Create tissue short names and use these in sample and data tables. refs #13504
diff --git src/hg/lib/gtexSampleData.sql src/hg/lib/gtexSampleData.sql
new file mode 100644
index 0000000..1f8a0dd
--- /dev/null
+++ src/hg/lib/gtexSampleData.sql
@@ -0,0 +1,14 @@
+# 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)
+);