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

diff --git src/hg/lib/myVariantsShare.sql src/hg/lib/myVariantsShare.sql
index 506278fa8d2..b68cb5f778e 100644
--- src/hg/lib/myVariantsShare.sql
+++ src/hg/lib/myVariantsShare.sql
@@ -7,16 +7,16 @@
 CREATE TABLE myVariantsShares (
     id int unsigned not null AUTO_INCREMENT,	# Auto-increment primary key
     ownerUser varchar(255) not null,	# Owner who created the share
     shareToken varchar(64) not null,	# 48-char URL-safe token
     project varchar(255) not null,	# Project name, or * for all
     db varchar(255) not null,	# Assembly (hg38, mm39, etc.)
     permission tinyint unsigned not null default 0,	# 0=read-only, 1=read-write
     targetUser varchar(255) default null,	# Specific user, or NULL for anyone with link
     label varchar(255) default null,	# Optional human-readable label
     createdAt timestamp not null default CURRENT_TIMESTAMP,	# Timestamp of creation
               #Indices
     PRIMARY KEY(id),
     UNIQUE KEY(shareToken),
     KEY(ownerUser),
     KEY(targetUser)
-);
+) ENGINE=InnoDB;