919620af4ae7a9d4d901d445a04e844324b89f9e
galt
  Mon Jan 24 22:12:33 2022 -0800
Fixing compatibility for MariaDb 10.6 which has a new keyword "offset". refs #28799

diff --git src/hg/lib/wiggle.sql src/hg/lib/wiggle.sql
index 90bce74..b4ef0a4 100644
--- src/hg/lib/wiggle.sql
+++ src/hg/lib/wiggle.sql
@@ -1,23 +1,23 @@
 # wiggle.sql was originally generated by the autoSql program, which also 
 # generated wiggle.c and wiggle.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Wiggle track values to display as y-values (first 6 fields are bed6)
 CREATE TABLE wiggle (
     chrom varchar(255) not null,	# Human chromosome or FPC contig
     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)
 );