Thread:Project:Support desk/ConfirmAccount gives error 1604

Trying to install ConfirmAccount extension, however when I run the update.php script, I get the following error.

Renaming eu_wiki_id -> eu_local_id... already done. Creating account_requests table...A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE `account_requests` ( acr_id int unsigned NOT NULL auto_increment, acr_name varchar(255) binary NOT NULL default , acr_real_name varchar(255) binary NOT NULL default , acr_email tinytext NOT NULL, acr_email_authenticated binary(14) default NULL, acr_email_token binary(32), acr_email_token_expires binary(14), acr_bio mediumblob NOT NULL, acr_notes mediumblob NOT NULL, acr_urls mediumblob NOT NULL, acr_ip VARCHAR(255) NULL default , acr_filename VARCHAR(255) NULL, acr_storage_key VARCHAR(64) NULL, acr_type tinyint(255) unsigned default 0, acr_areas mediumblob NOT NULL, acr_registration char(14) NOT NULL, acr_deleted bool NOT NULL, acr_rejected binary(14), acr_held binary(14), acr_user int unsigned NOT NULL default 0, acr_comment varchar(255) NOT NULL default , PRIMARY KEY (acr_id), UNIQUE KEY (acr_name), UNIQUE KEY (acr_email(255)), INDEX (acr_email_token), INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration) ) TYPE=InnoDB " from within function "DatabaseBase::sourceStream". Database returned error "1064: 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 'TYPE=InnoDB' at line 28 (127.0.0.1)"
 * _mime_minor fields are already long enough.

Could you offer some help to a newby?