ALTER TABLE `transaction` ADD COLUMN `investorPaymentStatus` VARCHAR(50) NULL DEFAULT NULL AFTER `transactionNumber`;
ALTER TABLE `transaction` ADD COLUMN `filePurchaseOrder` TEXT NULL DEFAULT NULL AFTER `investorDocumentStatus`;

UPDATE `transaction` SET `investorPaymentStatus` = 'UNPAID' WHERE `investorPaymentStatus` IS NULL;

ALTER TABLE `merchant` ADD COLUMN `csEmail` VARCHAR(100) NULL DEFAULT NULL AFTER `picContact`; 