2f4b2eb1df8521e7f931c3c8cb5d6d20e60384da
ceisenhart
  Wed Apr 26 09:04:55 2017 -0700
Updating the autoSql and sql files to include gene name, refs #19155

diff --git src/hg/lib/barChartBed.sql src/hg/lib/barChartBed.sql
index 0bfe0cc..a0fa41a 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.
 
-#BED6+4 with additional fields for category count and median values, and sample matrix fields
+#BED6+5 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,	# 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
+    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.
+    gene varchar(255) not null,	# Hugo gene name associated with the transcript.
               #Indices
-    INDEX(name),
-    INDEX(chrom(20), chromStart)
+    PRIMARY KEY(chrom)
 );