
ALTER TABLE `payment` ADD `cardNumber` varchar(20) DEFAULT NULL after `value`, add INDEX(`cardNumber`);

ALTER TABLE `payment` ADD `authCode` varchar(10) DEFAULT NULL after `value`, add INDEX(`authCode`);

-- DEFAULT NULL after `statusId`;
-- CREATE INDEX `nextVisitTime` ON `servicejob`(`nextVisitTime`);
