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
@@ -1,22 +1,22 @@
 # myVariantsShare.sql was originally generated by the autoSql program, which also
 # generated myVariantsShare.c and myVariantsShare.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly
 # automatic way.
 
 #A share record linking an owner's myVariants project to a recipient.
 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;