00590f0f1b1b91a318f0d76308bc513a83dc2ad7
chmalee
  Tue May 12 11:26:52 2026 -0700
Move myVariants tables from myisam to innodb, refs #33808

diff --git src/hg/lib/myVariants.sql src/hg/lib/myVariants.sql
index 7204b1a25ba..a3c1d34e263 100644
--- src/hg/lib/myVariants.sql
+++ src/hg/lib/myVariants.sql
@@ -1,25 +1,25 @@
 # 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
     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;