ALTER TABLE `tblinvoicepaymentrecords` ADD `cancel_note` TEXT NULL AFTER `fee_data`, ADD `updated_by` BIGINT NULL AFTER `cancel_note`, ADD `updated_on` TIMESTAMP NULL AFTER `updated_by`;
ALTER TABLE `tblinvoicepaymentrecords` CHANGE `status` `status` TINYINT NULL DEFAULT '1' COMMENT '1 = Completed | 2 = Pending | 3 = Failed | 4 = Retry | 5 = Refunded | 6 = Cancelled';