Query to Run - whmcs_retcustpurchase: 
CREATE TABLE whmcs_retcustpurchase ( `id` INT(10) NOT NULL AUTO_INCREMENT , `division` VARCHAR(25) NOT NULL , `currency` VARCHAR(25) NOT NULL , `first_averagevalue` DECIMAL(10,2) NOT NULL , `second_averagedays` DECIMAL(10,2) NOT NULL , `second_averagemths` DECIMAL(10,2) NOT NULL , `second_averagevalue` DECIMAL(10,2) NOT NULL , `third_averagedays` DECIMAL(10,2) NOT NULL , `third_averagemths` DECIMAL(10,2) NOT NULL , `third_averagevalue` DECIMAL(10,2) NOT NULL , `fourth_averagedays` DECIMAL(10,2) NOT NULL , `fourth_averagemths` DECIMAL(10,2) NOT NULL , `fourth_averagevalue` DECIMAL(10,2) NOT NULL , `fifth_averagedays` DECIMAL(10,2) NOT NULL , `fifth_averagemths` DECIMAL(10,2) NOT NULL , `fifth_averagevalue` DECIMAL(10,2) NOT NULL , `created_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`)) ENGINE = MyISAM;