ALTER TABLE `servicejob`
ADD COLUMN `techRepaired` tinyint(1) NOT NULL DEFAULT '0' AFTER `invoiceToId`;
CREATE INDEX `techRepaired` ON `servicejob`(`techRepaired`) USING BTREE ;
