name	description	example
binary
unsigned	no negative	if an INT column is UNSIGNED, the size of the column’s range is the same but its endpoints shift up, from -2147483648 and 2147483647 to 0 and 4294967295.
unsigned zerofill	add leading zeros
on update CURRENT_TIMESTAMP