390353c4fea824e8431fd1e6b4a5fa660ed9e14f
hiram
  Wed Jan 21 21:53:13 2026 -0800
completeTime should be default null and add indexes on doneStatus and requestTime change comment to longtext from longblob refs #31811

diff --git src/hg/lib/ottoRequest.sql src/hg/lib/ottoRequest.sql
index 9cc7aea2f32..f7f1f68916e 100644
--- src/hg/lib/ottoRequest.sql
+++ src/hg/lib/ottoRequest.sql
@@ -1,18 +1,20 @@
 # 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
     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 longblob not null,	# other comments from the input form
+    comment longtext not null,	# other comments from the input form
     requestTime datetime not null,	# date time request was added
     doneStatus tinyint unsigned not null,	# # 1 == alignment is complete, 0 == alignment to be done
-    completeTime datetime not null,	# date time for alignment completed and user notified
+    completeTime datetime default null,	# date time for alignment completed and user notified
               #Indices
-    PRIMARY KEY(id)
+    PRIMARY KEY(id),
+    INDEX(doneStatus),
+    INDEX(requestTime)
 );