95d35e7bc2de062c22bb4969d1d16bd1604b6f26
kate
  Mon Aug 3 23:21:12 2015 -0700
Schemas for GTEX exon and gene tracks. Likely interim. refs #15648

diff --git src/hg/lib/bed6FloatVal.sql src/hg/lib/bed6FloatVal.sql
new file mode 100644
index 0000000..98b8f57
--- /dev/null
+++ src/hg/lib/bed6FloatVal.sql
@@ -0,0 +1,20 @@
+# bed6FloatVal.sql was originally generated by the autoSql program, which also 
+# generated bed6FloatVal.c and bed6FloatVal.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#BED 6 (with 0-1000 score), but also with floating-point value.
+CREATE TABLE bed6FloatVal (
+    bin smallint not null,      # Index field
+    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 of item
+    score int not null,	# 0-1000 score for useScore shading
+    strand char(1) not null,	# + or -
+    val float not null,	# Floating point value.
+              #Indices
+    INDEX(chrom(8),bin),
+    INDEX(chrom(8),chromStart),
+    INDEX(name(12))
+);