Fails to build SQL table on install

When installing this on Drupal 5.1 it does not create the database tables due to an error in the SQL query in interests.install

To repro:

Copy module into modules directory

Browse to Administer > Site building > Modules

Activate the Interests module

You will see an error at the top of the screen:

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 ''uid' ('uid') )' at line 5 query: CREATE TABLE if not exists interests ( uid int(8) NOT NULL, tid int(8) NOT NULL, counter int(8) NOT NULL default '0', KEY 'uid' ('uid') ) in /path/to/drupal-5.1/includes/database.mysql.inc on line 172.