MySQL Error message on install of User Badges - Drupal 5

In the process of re-building a site in Drupal 5 and after the install of current release of User Badges, was given the following warning:

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 '. )' at line 6 query: CREATE TABLE user_badges_badges ( bid int(10) NOT NULL default '0', name varchar(50) NOT NULL default '', image varchar(80) NOT NULL default '', weight int(2) NOT NULL default '0', href VARCHAR(80) default ''. ) in (path to install on system)\includes\database.mysql.inc on line 174.

Is this a known bug? I couldn't figure this out from reported issues thus far. Thought I should report it as such an error could be impacting on other things!