630eb30bc3695afcf73a19be6e3bc9a2829b365f
chmalee
  Wed May 13 13:04:37 2026 -0700
Make myVariants items bed12+ rather than bed9+, refs #33808

diff --git src/hg/lib/myVariants.sql src/hg/lib/myVariants.sql
index a3c1d34e263..57406da1752 100644
--- src/hg/lib/myVariants.sql
+++ src/hg/lib/myVariants.sql
@@ -1,25 +1,28 @@
 # An item in a myVariants type track.
 CREATE TABLE myVariants (
     bin int unsigned not null,    # Bin for range index
     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 - up to 16 chars
     score int unsigned not null,  # 0-1000.  Higher numbers are darker.
     strand char(1) not null,      # + or - for strand
     thickStart int unsigned not null,    # Start of thick part
     thickEnd int unsigned not null,      # End position of thick part
     itemRgb int unsigned not null,   # RGB 8 bits each as in bed
+    blockCount int unsigned not null,    # Number of blocks
+    blockSizes longblob not null,        # Comma separated list of block sizes
+    chromStarts longblob not null,       # Start positions relative to chromStart
     description longblob not null,   # Longer item description
     db varchar(255) not null,        # database name of this annotation
     ref varchar(255) not null,       # reference allele
     alt varchar(255) not null,       # alternate allele
     project varchar(255) not null,   # project name for grouping variants
     mouseover varchar(255) not null, # short mouseover text for hover display
     id int auto_increment,           # Unique ID for item
               #Indices
     PRIMARY KEY(id),
     INDEX(chrom(16),bin),
     INDEX(db),
     INDEX(project)
 ) ENGINE=InnoDB;