Enable Module - Save Configuration - mysql sytax errors

After enabling this module and clicking the submit button I get the following error.

* 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/test/includes/database.mysql.inc on line 172.
* user warning: Table 'testdrupal.quotes' doesn't exist query: CREATE INDEX quotes_nid ON quotes (nid) in /var/www/test/includes/database.mysql.inc on line 172.
* user warning: Table 'testdrupal.quotes' doesn't exist query: CREATE INDEX quotes_promote ON quotes (promote) in /var/www/test/includes/database.mysql.inc on line 172.

It would also seem that there is "left over" tables when I disabled the module. Is there a quick and dirty clean up script or can you tell me which tables to drop in order to remove traces of this module from MySQL in order to try again.

MySQL 5.0.45-1ubuntu3.3
php 5.2.3-1ubuntu6.3