I try to install INVENTORY module, that aborts.

Admin>Repair gives the following message:
Differences Found Between Database and Vardefs

The following script will sync the database structure with the structure defined in the vardefs. You have the option of exporting this script and then running it against your database using external database management tools, or to allow the administration module to run the script.

NOTE: any changes you make to the script in the textbox will be reflected in the exported or executed code.
* Table : inventory_items */
/* MISSING TABLE: inventory_items */
CREATE TABLE inventory_items (id char(36) NOT NULL ,date_entered bool DEFAULT 0 NOT NULL ,date_modified datetime NOT NULL ,modified_user_id varchar(36) NOT NULL ,assigned_user_id varchar(36) NULL ,created_by varchar(36) NULL ,deleted bool DEFAULT 0 NOT NULL ,inventory_number char(255) NOT NULL ,account_name char(255) NOT NULL ,account_id char(36) NOT NULL ,company_name varchar(255) NOT NULL ,storage_type varchar(255) NULL ,artist char(255) NOT NULL ,title char(255) NOT NULL ,circa int NULL ,date_received datetime NOT NULL ,date_left datetime NULL ,medium varchar(255) NOT NULL ,description char(255) NULL ,height double NULL ,width double NULL ,depth double NULL ,packing varchar(255) NULL ,square_footage double NULL ,in_storage varchar(255) NOT NULL ,value char(10) NULL ,insured varchar(255) NOT NULL ,facility varchar(255) NOT NULL ,location char(255) NULL ,photo char(255) DEFAULT 'default.jpg' NULL ,condition varchar(255) DEFAULT 'not inspected' NOT NULL ,condition_description char(255) NULL , PRIMARY KEY (id), KEY inventory_item_artist_index (artist)) CHARACTER SET utf8 COLLATE utf8_general_ci;

If I execute REPAIR I get the following

Executing repair query: Query Failed:CREATE TABLE inventory_items (id char(36) NOT NULL ,date_entered bool DEFAULT 0 NOT NULL ,date_modified datetime NOT NULL ,modified_user_id varchar(36) NOT NULL ,assigned_user_id varchar(36) NULL ,created_by varchar(36) NULL ,deleted bool DEFAULT 0 NOT NULL ,inventory_number char(255) NOT NULL ,account_name char(255) NOT NULL ,account_id char(36) NOT NULL ,company_name varchar(255) NOT NULL ,storage_type varchar(255) NULL ,artist char(255) NOT NULL ,title char(255) NOT NULL ,circa int NULL ,date_received datetime NOT NULL ,date_left datetime NULL ,medium varchar(255) NOT NULL ,description char(255) NULL ,height double NULL ,width double NULL ,depth double NULL ,packing varchar(255) NULL ,square_footage double NULL ,in_storage varchar(255) NOT NULL ,value char(10) NULL ,insured varchar(255) NOT NULL ,facility varchar(255) NOT NULL ,location char(255) NULL ,photo char(255) DEFAULT 'default.jpg' NULL ,condition varchar(255) DEFAULT 'not inspected' NOT NULL ,condition_description char(255) NULL , PRIMARY KEY (id), KEY inventory_item_artist_index (artist)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064:

If I export and run the SQL statement in phpMyAdmin I get

#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 '( 36 ) NOT NULL ,
date_entered bool DEFAULT 0 NOT NULL ,
date_modified datetim' at line 2