Error creating quotes table on installation

Installing the latest 5.x-1.2 quotes module on Drupal 5.7 using MySQL 5.0.32 on Debian Etch gives the following 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 'UNSIGNED, vid INTEGER NOT NULL UNSIGNED PRIMARY KEY, author ' at line 2 query: CREATE TABLE quotes ( nid INTEGER NOT NULL UNSIGNED, vid INTEGER NOT NULL UNSIGNED PRIMARY KEY, author VARCHAR(255) NOT NULL, citation VARCHAR(255), promote INTEGER UNSIGNED NOT NULL DEFAULT 0 ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/training.richardrobbins.co.za/drupal/includes/database.mysql.inc on line 172.
# user warning: Table 'testdb.quotes' doesn't exist query: CREATE INDEX quotes_nid ON quotes (nid) in /var/www/training.richardrobbins.co.za/drupal/includes/database.mysql.inc on line 172.
# user warning: Table 'testdb.quotes' doesn't exist query: CREATE INDEX quotes_promote ON quotes (promote) in /var/www/training.richardrobbins.co.za/drupal/includes/database.mysql.inc on line 172.

I fixed this by manually creating the table using the following command:
CREATE TABLE `quotes` (
`nid` INT UNSIGNED NOT NULL ,
`vid` INT NOT NULL ,
`author` VARCHAR( 255 ) NOT NULL ,
`citation` VARCHAR( 255 ) NULL ,
`promote` INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `vid` )
);

There after I manually executed the two index create commands and now everything appears to be working correctly.