73df4b22477525c05614cff79595806231dd64ed hiram Mon Jan 19 14:03:15 2026 -0800 starting the hgcentral table ottoRequest to record lift over request refs #31811 diff --git src/hg/lib/ottoRequest.sql src/hg/lib/ottoRequest.sql new file mode 100644 index 00000000000..1e41bb2f213 --- /dev/null +++ src/hg/lib/ottoRequest.sql @@ -0,0 +1,16 @@ +# 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 + requestTime datetime not null, # date time request was added + #Indices + PRIMARY KEY(id) +);