ecb35e7050f51987983e97ec6566250f252894d6 galt Thu Jan 27 23:50:02 2022 -0800 fix a few more sql files that have the field name offset which became a keyword in MariaDb 10.6. refs #28799 diff --git src/hg/lib/vax004Cons.sql src/hg/lib/vax004Cons.sql index b35fb9c..40b787e 100644 --- src/hg/lib/vax004Cons.sql +++ src/hg/lib/vax004Cons.sql @@ -1,23 +1,23 @@ # vax004Cons.sql was originally generated by the autoSql program, which also # generated vax004Cons.c and vax004Cons.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #VAX004 HIV-1 DNA Sequence Conservation CREATE TABLE vax004Cons ( chrom varchar(255) not null, # Reference sequence chromosome or scaffold chromStart int unsigned not null, # Start position in chromosome chromEnd int unsigned not null, # End position in chromosome name varchar(255) not null, # Name of item span int unsigned not null, # each value spans this many bases count int unsigned not null, # number of values in this block - offset int unsigned not null, # offset in File to fetch data + `offset` int unsigned not null, # offset in File to fetch data file varchar(255) not null, # path name to data file, one byte per value lowerLimit double not null, # lowest data value in this block dataRange double not null, # lowerLimit + dataRange = upperLimit validCount int unsigned not null, # number of valid data values in this block sumData double not null, # sum of the data points, for average and stddev calc sumSquares double not null, # sum of data points squared, for stddev calc #Indices PRIMARY KEY(chrom) );