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/inc/ottoRequest.h src/hg/inc/ottoRequest.h
index 01d5ab0d911..a4edaf2ab91 100644
--- src/hg/inc/ottoRequest.h
+++ src/hg/inc/ottoRequest.h
@@ -1,39 +1,41 @@
 /* ottoRequest.h was originally generated by the autoSql program, which also 
  * generated ottoRequest.c and ottoRequest.sql.  This header links the database and
  * the RAM representation of objects. */
 
 #ifndef OTTOREQUEST_H
 #define OTTOREQUEST_H
 
 #include "jksql.h"
-#define OTTOREQUEST_NUM_COLS 8
+#define OTTOREQUEST_NUM_COLS 10
 
 extern char *ottoRequestCommaSepFieldNames;
 
 struct ottoRequest
 /* recording requests coming from from functions such as liftRequest */
     {
     struct ottoRequest *next;  /* Next in singly linked list. */
     unsigned id;	/* Auto-incrementing request count */
+    char *requestType;	/* type of request: liftOver or assembly */
     char *fromDb;	/* can be a database name or a GC[AF]_ GenArk accession */
     char *toDb;	/* can be a database name or a GC[AF]_ GenArk accession */
     char *email;	/* user email address */
     char *comment;	/* other comments from the input form */
     char *requestTime;	/* date time request was added */
-    unsigned char doneStatus;	/* # 1 == alignment is complete, 0 == alignment to be done */
-    char *completeTime;	/* date time for alignment completed and user notified */
+    unsigned char doneStatus;	/* # 1 == process is complete, 0 == process to be done */
+    char *workflowId;	/* galaxy workflow ID */
+    char *completeTime;	/* date time for process completed and user notified */
     };
 
 void ottoRequestStaticLoad(char **row, struct ottoRequest *ret);
 /* Load a row from ottoRequest table into ret.  The contents of ret will
  * be replaced at the next call to this function. */
 
 struct ottoRequest *ottoRequestLoadByQuery(struct sqlConnection *conn, char *query);
 /* Load all ottoRequest from table that satisfy the query given.  
  * Where query is of the form 'select * from example where something=something'
  * or 'select example.* from example, anotherTable where example.something = 
  * anotherTable.something'.
  * Dispose of this with ottoRequestFreeList(). */
 
 void ottoRequestSaveToDb(struct sqlConnection *conn, struct ottoRequest *el, char *tableName, int updateSize);
 /* Save ottoRequest as a row to the table specified by tableName.