Thinking more about this, an INTEGER will generally store over 2 billion records. Is the reason for updating to BIGINT due to someone having hit that limit?
An inner voice is saying: "Can't the person who has breached that limit be asked to create his own tables instead of giving all the rest of us the inconvenience?". I shall now replace my tin-foil hat.
