changing them to BIGINTs as necessary (when possible).

From Moodle 1.7 all int(10) were changed to bigint(10) for new columns. These leave old sites with a mix of INTs and BIGINTs that should be normalized, to avoid losing any DB thought put performing unnecessary CASTS or SORT merges.

Implement one utility within the XMLDB editor, able to iterate over all the int(10) columns, looking if they are correct BIGINTs or no.

The utility won't perform any action against the DB but provide one SQL script to be executed by hand.

Ciao