INSERT INTO `systemsettings` (`type`, `value`, `description`, `active`, `created`, `createdById`, `updated`, `updatedById`) VALUES
    ('service_no_prefix', 'JOB', 'Prefix for Service No (maximaize 4 bits)', 1, NOW(), 10, NOW(), 10);


ALTER TABLE `visit`
MODIFY `visitNo` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
