df52d842cf575c8b1f250baed87aa0b937f385a8
kate
  Thu Jan 26 14:09:50 2017 -0800
Initial cut of hgTracks and hgTrackUi for new barchart type track (generalization of GTEx gene expression display). refs #18736

diff --git src/hg/lib/barChartBed.sql src/hg/lib/barChartBed.sql
new file mode 100644
index 0000000..fd10c06
--- /dev/null
+++ src/hg/lib/barChartBed.sql
@@ -0,0 +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
+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
+    strand char(1) not null,	        # + or - for strand
+    expCount int unsigned not null,	# Number of categories
+    expScores longblob not null,	# Comma separated list of category values
+              #Indices
+    PRIMARY KEY(name),
+    INDEX(chrom(20), chromStart)
+);