8479716afe2a31901141de47a23bcddf06325fa3
hiram
  Thu Mar 26 17:28:55 2020 -0700
unsigned int is a poor choice for numbers that need to have operations such as subtraction on them, MySQL keeps everything in unsigned int and is confused by negative results refs #21074

diff --git src/hg/lib/asmEquivalent.as src/hg/lib/asmEquivalent.as
index 009c1c1..fd6661de 100644
--- src/hg/lib/asmEquivalent.as
+++ src/hg/lib/asmEquivalent.as
@@ -1,11 +1,11 @@
 table asmEquivalent
 "Equivalence relationship of assembly versions, Ensembl: UCSC, NCBI genbank/refseq"
     (
     string source;          "assembly name"
     string destination;     "equivalent assembly name"
     enum ("ensembl", "ucsc", "genbank", "refseq") sourceAuthority; "origin of source assembly"
     enum ("ensembl", "ucsc", "genbank", "refseq") destinationAuthority; "origin of equivalent assembly"
-    uint   matchCount;       "number of exactly matching sequences"
-    uint   sourceCount;      "number of sequences in source assembly"
-    uint   destinationCount; "number of sequences in equivalent assembly"
+    bigint   matchCount;       "number of exactly matching sequences"
+    bigint   sourceCount;      "number of sequences in source assembly"
+    bigint   destinationCount; "number of sequences in equivalent assembly"
     )