Failed: ALTER TABLE {path_redirect} CHANGE type `type` INT(small) NOT NULL

hi and thanks for a great module

just fyi-
was running the latest dev version, 6.x-1.x-dev of path redirect-
on a drupal 6.9 install that had never been upgraded from 5.x-
it was a fresh install

anyways-

upon installing the new dev version (jan 27 2009), (or the same with the beta i assume)-
then a new database update is triggered / required by the mod-

however, the update then throws the following msgs / errors-

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'small) NOT NULL' at line 1 query: ALTER TABLE path_redirect CHANGE type `type` INT(small) NOT NULL in /.../includes/database.mysql-common.inc on line 520.

and

Update #5100
ALTER TABLE {path_redirect} CHANGE rid `rid` INT NOT NULL auto_increment
ALTER TABLE {path_redirect} CHANGE query `query` VARCHAR(255) DEFAULT NULL
ALTER TABLE {path_redirect} CHANGE fragment `fragment` VARCHAR(50) DEFAULT NULL
Failed: ALTER TABLE {path_redirect} CHANGE type `type` INT(small) NOT NULL

did a little digging... it seems that maybe mysql 5.1 does not like the syntax for the INT(small)...?

and / or it seems that for me at least, my path_redirect table already has / had a col type of: smallint(6) for 'type'.

so-
maybe this update is not needed / should not be triggered if you are not upgrading from 5.x to 6.x-
but just updating from 6.x to 6.x?

please advise and thanks...
and also see attached...

vincent, in buffalo