ALTER TABLE `settings` ADD `email` VARCHAR(255) NULL AFTER `app_name`, ADD `title` VARCHAR(255) NULL AFTER `email`;
/* invest table added */
ALTER TABLE `investments` ADD `banck_name` VARCHAR(255) NULL AFTER `chairman_rec_commission`, ADD `br_name` VARCHAR(255) NULL AFTER `banck_name`, ADD `ac_name` VARCHAR(255) NULL AFTER `br_name`, ADD `chk_no` INT NULL AFTER `ac_name`, ADD `chk_amount` INT NULL AFTER `chk_no`, ADD `chk_date` TIMESTAMP NULL AFTER `chk_amount`, ADD `deed_no` INT NULL AFTER `chk_date`, ADD `deed_date` TIMESTAMP NULL DEFAULT NULL AFTER `deed_no`, ADD `expiry_date` TIMESTAMP NULL DEFAULT NULL AFTER `deed_date`;

