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
@@ -10,16 +10,16 @@
     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;