435e92d0ad49164d1b5b156e3fb5ef5ff7b19041
hiram
  Tue Apr 21 12:29:50 2026 -0700
make the ottoRequest table a bit more generic so it can handle both liftOver and assembly requests refs #31811

diff --git src/hg/lib/ottoRequest.as src/hg/lib/ottoRequest.as
index 70cf8540a63..aa51056697d 100644
--- src/hg/lib/ottoRequest.as
+++ src/hg/lib/ottoRequest.as
@@ -1,13 +1,15 @@
 table ottoRequest
 "recording requests coming from from functions such as liftRequest"
     (
     uint id;	      "Auto-incrementing request count"
+    string requestType;  "type of request: liftOver or assembly"
     string fromDb;    "can be a database name or a GC[AF]_ GenArk accession"
     string toDb;      "can be a database name or a GC[AF]_ GenArk accession"
     string email;     "user email address"
     lstring comment;   "other comments from the input form"
     string requestTime; "date time request was added"
-    ubyte doneStatus;   "# 1 == alignment is complete, 0 == alignment to be done"
-    string completeTime; "date time for alignment completed and user notified"
+    ubyte doneStatus;   "# 1 == process is complete, 0 == process to be done"
+    string workflowId;	"galaxy workflow ID"
+    string completeTime; "date time for process completed and user notified"
     )