cf91694df806cf52913c294e6d2cf0452373f8fc
hiram
  Wed Jan 21 21:45:19 2026 -0800
add a doneStatus and a completeTime elements to the table definition refs #31811

diff --git src/hg/inc/ottoRequest.h src/hg/inc/ottoRequest.h
index ab48ab3204b..01d5ab0d911 100644
--- src/hg/inc/ottoRequest.h
+++ src/hg/inc/ottoRequest.h
@@ -1,37 +1,39 @@
 /* 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 6
+#define OTTOREQUEST_NUM_COLS 8
 
 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 *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 */
     };
 
 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.