CREATE TABLE `whmcs_custretentiontime` ( `id` INT(10) NOT NULL AUTO_INCREMENT , `division` VARCHAR(25) NOT NULL , `inc_active` VARCHAR(15) NOT NULL , `pgid` INT(10) NOT NULL , `pgname` TEXT NOT NULL , `pid` INT(10) NOT NULL , `pname` TEXT NOT NULL , `billingcycle` VARCHAR(30) NOT NULL , `product_count` INT(10) NOT NULL , `avg_days` INT(10) NOT NULL , `avg_yrs_mths` VARCHAR(60) NOT NULL , `created_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , `modified_date` DATETIME NULL DEFAULT NULL , `disable_date` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT 100000;