id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
INT stands for interger, so it is interger values.
INT can contain zero, positive and negetive values.
INT cannot contain fraction values, only hole numbers are excepted.
id BIGINT unsigned auto_increment NOT NULL,
to prevent negative values from being inserted.