ALTER TABLE `bankref` ADD COLUMN `customerId`  int(10) NULL DEFAULT 0 AFTER `isFullyApplied`;
ALTER TABLE `bankref` ADD COLUMN `paymentMethodId`  int(10) NULL DEFAULT 0 AFTER `customerId`;
CREATE INDEX `customerId` ON `bankref`(`customerId`) USING BTREE ;
CREATE INDEX `paymentMethodId` ON `bankref`(`paymentMethodId`) USING BTREE ;
