ALTER TABLE `payment` ADD COLUMN `purchaseInvoiceNo`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER `cardNumber`;
ALTER TABLE `payment` ADD COLUMN `xeroPaymentId`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER `purchaseInvoiceNo`;
CREATE INDEX `xeroPaymentId` ON `payment`(`xeroPaymentId`) USING BTREE ;
CREATE INDEX `purchaseInvoiceNo` ON `payment`(`purchaseInvoiceNo`) USING BTREE ;
