ALTER TABLE `address`
ADD `type` varchar(20) NOT NULL DEFAULT '' AFTER `customerId`,
ADD INDEX(`type`);

ALTER TABLE `servicejob`
ADD `ifThirdPartyBilling` tinyint(1) NOT NULL DEFAULT 0 AFTER `nextVisitTime`,
ADD INDEX(`ifThirdPartyBilling`);

ALTER TABLE `servicejob`
ADD `thirdPartyBilingAddressId` int(10) DEFAULT NULL AFTER `ifThirdPartyBilling`,
ADD INDEX(`thirdPartyBilingAddressId`);
