aaf7309dce63a05d18d0e639246fd3fa1f030d47
kate
  Wed Apr 12 14:11:02 2017 -0700
Implement boxplot on details version for hub version of track. refs #18736

diff --git src/hg/lib/barChartBed.sql src/hg/lib/barChartBed.sql
index ccc4a28..4a3f18b 100644
--- src/hg/lib/barChartBed.sql
+++ src/hg/lib/barChartBed.sql
@@ -1,21 +1,21 @@
 # barChartBed.sql was originally generated by the autoSql program, which also 
 # generated barChartBed.c and barChartBed.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
-# TODO: add unique ID field, allow name to be non-unique ?
-
-#BED6+ with additional fields for category count and values
+#BED6+4 with additional fields for category count and median values, and sample matrix fields
 CREATE TABLE barChartBed (
     chrom varchar(255) not null,	# Reference sequence chromosome or scaffold
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
-    name varchar(255) not null,	        # Item identifier
-    score int unsigned not null,	# Score from 0-1000; derived from total median all categories (log-transformed and scaled)
-    strand char(1) not null,	        # + or - for strand
+    name varchar(255) not null,	# Name or ID of item, ideally both human readable and unique
+    score int unsigned not null,	# Score from 0-1000; typically derived from total of median value from all categories
+    strand char(1) not null,	# + or - for strand. Use . if not applicable
     expCount int unsigned not null,	# Number of categories
     expScores longblob not null,	# Comma separated list of category values
+    _dataOffset bigint not null,	# Offset of sample data in data matrix file, for boxplot on details page.
+    _dataLen int not null,	# Length of sample data row in data matrix file.
               #Indices
-    PRIMARY KEY(name),
+    INDEX(name),
     INDEX(chrom(20), chromStart)
 );