366bbd6166c2d220b559ae13307d7a60e9cee3a9
hiram
  Thu May 21 14:43:49 2026 -0700
ottoRequest table should be InnoDB and allow international characters for email addresses refs #31811

diff --git src/hg/lib/ottoRequest.sql src/hg/lib/ottoRequest.sql
index 05771759f48..aa8c522cf1c 100644
--- src/hg/lib/ottoRequest.sql
+++ src/hg/lib/ottoRequest.sql
@@ -1,23 +1,26 @@
 # ottoRequest.sql was originally generated by the autoSql program, which also 
 # generated ottoRequest.c and ottoRequest.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #recording requests coming from from functions such as liftRequest
 CREATE TABLE ottoRequest (
     id int unsigned not null auto_increment,	# Auto-incrementing request count
     requestType varchar(255) not null,	# type of request: liftOver or assembly
     fromDb varchar(255) not null,	# can be a database name or a GC[AF]_ GenArk accession
     toDb varchar(255) not null,	# can be a database name or a GC[AF]_ GenArk accession
     email varchar(255) not null,	# user email address
     comment longtext not null,	# other comments from the input form
     requestTime datetime not null,	# date time request was added
     status tinyint unsigned not null,	# 0 pending, 1 notified, 2 in progress, 3 galaxy done, 4 tracks complete, 5 finish notification, 6 complete, 7 problems
     buildDir varchar(1024) not null,	# build directory path for alignment workflow
     completeTime datetime default null,	# date time for process completed and user notified
               #Indices
     PRIMARY KEY(id),
     INDEX(requestType),
     INDEX(status),
     INDEX(requestTime)
-);
+) ENGINE=InnoDB
+    DEFAULT CHARSET=utf8mb4
+    COLLATE=utf8mb4_unicode_ci
+    ROW_FORMAT=DYNAMIC;