Broken create-table SQL in quotes.install

The SQL for creating the tables has a number of issues: missed some commas from the SQL, included an extra one, and backticks around the partial-index of TEXT didn't work for me, and aren't required anyway. Here's the 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 'show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL D' at line 10 query: CREATE TABLE quotes_blocks ( bid INTEGER NOT NULL PRIMARY KEY, block_type INTEGER NOT NULL, cron_interval INTEGER NOT NULL, cron_step INTEGER NOT NULL, cron_last INTEGER NOT NULL, vid INTEGER NOT NULL, count INTEGER NOT NULL DEFAULT 1, show_titles INTEGER NOT NULL DEFAULT 0 show_citation INTEGER NOT NULL DEFAULT 0 max_length INTEGER NOT NULL DEFAULT 0 view_weight INTEGER NOT NULL DEFAULT 1 name VARCHAR(255) NOT NULL UNIQUE, nid_filter TEXT NOT NULL, rid_filter TEXT NOT NULL, uid_filter TEXT NOT NULL, tid_filter TEXT NOT NULL, view_text VARCHAR(64), more_text VARCHAR(64), ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /Users/simonroberts/src/projects/eightyoptions/tafa/public_html/includes/database.mysql.inc on line 174.

user warning: Key column 'name(255)' doesn't exist in table query: CREATE TABLE quotes_authors ( aid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name TEXT NOT NULL, bio TEXT NULL, INDEX (`name(255)`) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /Users/simonroberts/src/projects/eightyoptions/tafa/public_html/includes/database.mysql.inc on line 174.

See attached patch.