A BIGINT can hold numbers between -9223372036854775808 and 9223372036854775807
An UNSIGNED BIGINT can hold numbers between 0 and 18446744073709551615
Whether you actually use all the numbers in either range is irrelevant.
By changing the field to UNSIGNED you recover the sign bit to use to doulbe the size of the biggest positive number that can be held.
Helping others to solve their computer problem at http://www.felgall.com/