They're missing engine types:
CREATE TABLE `phpvms_pilotshop_bought` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pilot_id` INT( 11 ) NULL ,
`product_id` INT( 11 ) NULL
) ENGINE = MYISAM;
CREATE TABLE `phpvms_pilotshop_types` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`type` INT( 1 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`description` TEXT NULL
) ENGINE = MYISAM;
CREATE TABLE `phpvms_pilotshop` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pid` INT( 15 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`shop_type` INT( 15 ) NULL ,
`product_type` INT( 15 ) NULL ,
`image_link` TEXT NULL ,
`description` TEXT NULL ,
`price` FLOAT NULL
) ENGINE = MYISAM;
Also, it seems like you were copying the installation text in also. Just copy the code above and try it