1bae3cecd9581968ad782c5f932cf8f504363399
kate
  Wed Aug 26 09:02:11 2015 -0700
Expand GTEx sample table.  Now includes all fields except RNA-seqC metrics, which if we decide to include them, will likley be in an auxiliary table. refs #13504

diff --git src/hg/lib/gtexSample.sql src/hg/lib/gtexSample.sql
index ccd5311..903f793 100644
--- src/hg/lib/gtexSample.sql
+++ src/hg/lib/gtexSample.sql
@@ -1,13 +1,21 @@
 # gtexSample.sql was originally generated by the autoSql program, which also 
 # generated gtexSample.c and gtexSample.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #GTEx sample description
 CREATE TABLE gtexSample (
-    name varchar(255) not null,	# GTEX sample identifier
-    tissue varchar(255) not null,	# Tissue name
-    donor varchar(255) not null,	# GTEX subject identifier
+    sampleId varchar(255) not null,	# GTEx sample identifier
+    tissue varchar(255) not null,	# Tissue name. Links to tissue table
+    donor varchar(255) not null,	# GTEx subject identifier. Links to donor table
+    autolysisScore int not null default '-1',	# Level of tissue self-digestion (0-3; none,mild,moderate,severe, -1 if unknown)
+    ischemicTime varchar(255) not null default 'unknown',	# Time from tissue removal to preservation, in 4hr intervals
+    rin float not null default '0.0',	# RNA Integrity Number
+    collectionSites varchar(255) not null,	# GTEx Biospecimen Source Site list
+    batchId varchar(255) not null,	# Nucleic acid isolation batch ID
+    isolationType varchar(255) not null,	# Type of nucleic acid isolation
+    isolationDate varchar(255) not null,	# Date of nucleic acid isolation
+    pathNotes varchar(1024) not null default '',	# Pathology report notes
               #Indices
-    PRIMARY KEY(name)
+    PRIMARY KEY(sampleId)
 );