7d56cd6635651dfd4c9926d062d92ad7b65a3e80
chmalee
  Wed Jun 3 14:52:52 2026 -0700
More myVariants changes: make the share to accept a comma-sep list of usernames, allow both the read/edit flag and the usernames setting to be editable after creation. When editing usernames, add a confirmation if the field is left blank that this will make the share viewable/editable by anyone with the link, refs #33808

diff --git src/hg/lib/myVariantsShare.sql src/hg/lib/myVariantsShare.sql
index b68cb5f778e..00956b2e913 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
+    targetUser varchar(512) default null,	# Comma-separated usernames, 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;