5a9e9854a89ac8e2dd7d2e0660dbd699f4de6404 galt Fri Sep 3 23:50:30 2021 -0700 Got Angies original version which is better. diff --git src/hg/lib/bed5SourceVals.sql src/hg/lib/bed5SourceVals.sql index 7cc1ecd..533d31e 100644 --- src/hg/lib/bed5SourceVals.sql +++ src/hg/lib/bed5SourceVals.sql @@ -1,18 +1,19 @@ # bed5SourceVals.sql was originally generated by the autoSql program, which also # generated bed5SourceVals.c and bed5SourceVals.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #BED5+ with a count, list of sources, and list of source scores for combined data CREATE TABLE bed5SourceVals ( + bin int unsigned not null, # Bin number for browser speedup 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 unsigned not null, # Display score (0-1000) sourceCount int unsigned not null, # Number of sources sourceIds longblob not null, # Source ids sourceScores longblob not null, # Source scores #Indices - KEY `name` (`name`(16)) + INDEX (chrom,bin) );