How to manually add the userpoints_txn Mysql DB table?

It looks as if my upgrade from Drupal 4.7 to 5.3 didn't go entirely to plan, and as a result the UserPoints module is missing the userpoints_txn table in the database. People suggested manually adding it using the code in the .install file, but I keep getting SQL formatting errors when I try to add it?

How should I reformat this SQL code to make it work?

CREATE TABLE {userpoints_txn} (
txn_id INT NOT NULL AUTO_INCREMENT,
uid INT(10) NOT NULL DEFAULT '0',
approver_uid INT(10) NOT NULL DEFAULT '0',
points INT(10) NOT NULL DEFAULT '0',
time_stamp INT(11) NOT NULL DEFAULT '0',
status INT(1) NOT NULL DEFAULT '0',
event VARCHAR(32),
description TEXT,
reference varchar(128),
PRIMARY KEY (txn_id),
KEY (event),
KEY (reference),
KEY (status)
) /*!40100 DEFAULT CHARACTER SET utf8 */;