ALTER TABLE visit CHANGE `comments` `checklistData` varchar(255) DEFAULT '';


ALTER TABLE `servicejob`
ADD `nextVisitTime` datetime DEFAULT NULL after `statusId`;
CREATE INDEX `nextVisitTime` ON `servicejob`(`nextVisitTime`);

